[[oktatas:programozás:csharp:dotnetcore:web_api|< .Web API]]

====== REST API kontroller használat ======

  * **Szerző:** Sallai András
  * Copyright (c) 2024, Sallai András
  * Szerkesztve: 2024
  * Licenc: [[https://creativecommons.org/licenses/by-sa/4.0/|CC BY-SA 4.0]]
  * Web: https://szit.hu

===== Projekt készítése =====

  dotnet new webapi -minimal -o app01

===== Függőségek telepítése =====

==== Aktuális ====

Aktuális keretrendszerhez:

  dotnet add package Microsoft.EntityFrameworkCore


==== 7-s verzióhoz ====


Keressük meg az utolsó 7.x verziót:
  * https://www.nuget.org/packages/Microsoft.EntityFrameworkCore

Ha kattintunk a verzióra, akkor kiírja hogyan kell telepíteni:

  dotnet add package Microsoft.EntityFrameworkCore --version 7.0.15

  dotnet add package Pomelo.EntityFrameworkCore.MySql --version 7.0.0

===== Program.cs =====


<code csharp Program.cs>
var builder = WebApplication.CreateBuilder(args);
builder.Services.AddControllers();

var app = builder.Build();
app.MapControllers();
app.Run();
</code>


===== Kontroller =====

<code csharp EmployeeController.cs>
namespace App01.Controllers;

[Route("api/[controller]")]
[ApiController]
public class EmployeeController : ControllerBase {
    [HttpGet]
    public string Get() {
        return "működik";
    }
}
</code>

===== Adatbázis =====

<code mysql create.sql>
create database sargabt;

create table Employees(
    Id int not null primary key auto_increment,
    Name varchar(50),
    City varchar(50),
    Salary double
);
</code>

===== Modell =====

<code csharp Employee.cs>
public class Employee {
    public int Id { get; set; }
    public string? Name { get; set; }
    public string? City { get; set; }
    public double Salary { get; set; }
}
</code>


===== Adatbázis elérése =====

<code javascript appsettings.Development.json>
{
  "ConnectionStrings": {
    "Mariadb": "server=localhost;user=sargabt;password=titok;database=sargabt"
  }
}
</code>

<code csharp DataService.cs>
using Microsoft.EntityFrameworkCore;

namespace App01.Data;

public class DataService : DbContext {
    public DataService(DbContextOptions<DataService> options)
        :base(options) {}
    
    public DbSet<Employee> Employees {get; set;} = null!;
}
</code>


<code csharp Program.cs>
using Microsoft.EntityFrameworkCore;
using App01.Data;

var builder = WebApplication.CreateBuilder(args);
builder.Services.AddControllers();
builder.Services.AddSwaggerGen();

builder.Services.AddDbContext<DataService>(options => {
    var connectionString = builder.Configuration.GetConnectionString("Mariadb");
    options.UseMySql(connectionString, ServerVersion.AutoDetect(connectionString));
});

var app = builder.Build();
app.UseSwagger();
app.UseSwaggerUI();
app.MapControllers();
app.Run();
</code>

===== Kontroller =====

<code csharp EmployeeController.cs>
using App01.Data;
// using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
// using Microsoft.EntityFrameworkCore;

namespace App01.Controllers;

[Route("api/[controller]")]
[ApiController]
public class EmployeeController : ControllerBase {

    private readonly DataService _db;
    
    public EmployeeController(DataService db) {
        _db = db;
    }

    [HttpGet]
    [ProducesResponseType(StatusCodes.Status200OK)]
    [ProducesResponseType(StatusCodes.Status404NotFound)]    
    public ActionResult<List<Employee>> Get() {
        var emps = _db.Employees.ToList();
        return emps == null ? NotFound() : emps;
    }
}
</code>



===== Link =====
  * https://learn.microsoft.com/en-us/aspnet/core/tutorials/first-web-api?view=aspnetcore-8.0&tabs=visual-studio (2024)