public async Task <IActionResult> GetVettura([FromQuery] int id)
{
using (var context = new AutoConcessonarieDbContext())
{
return(Ok(await context.Vetture.FirstOrDefaultAsync(x => x.ID == id)));
}
}
public async Task <IActionResult> UpdateRivenditoreAuto([FromBody] RivenditoreAuto rivenditoreAuto)
{
using (var context = new AutoConcessonarieDbContext())
{
context.RivenditoriAuto.Update(rivenditoreAuto);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateVettura([FromBody] Vettura vettura)
{
using (var context = new AutoConcessonarieDbContext())
{
context.Vetture.Update(vettura);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateCliente([FromBody] Cliente cliente)
{
using (var context = new AutoConcessonarieDbContext())
{
context.Clienti.Update(cliente);
await context.SaveChangesAsync();
return(Ok());
}
}
public IActionResult SetupDatabase()
{
lock (setupLock)
{
using (var context = new AutoConcessonarieDbContext())
{
// Create database
context.Database.EnsureCreated();
}
return(Ok("database created"));
}
}
public async Task <IActionResult> DeleteRivenditoreAuto([FromQuery] int id)
{
using (var context = new AutoConcessonarieDbContext())
{
var rivenditoreAuto = await context.RivenditoriAuto.FirstOrDefaultAsync(x => x.ID == id);
if (rivenditoreAuto != null)
{
context.RivenditoriAuto.Remove(rivenditoreAuto);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> DeleteVettura([FromQuery] int id)
{
using (var context = new AutoConcessonarieDbContext())
{
var vettura = await context.Vetture.FirstOrDefaultAsync(x => x.ID == id);
if (vettura != null)
{
context.Vetture.Remove(vettura);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> DeleteCliente([FromQuery] int id)
{
using (var context = new AutoConcessonarieDbContext())
{
var cliente = await context.Clienti.FirstOrDefaultAsync(x => x.ID == id);
if (cliente != null)
{
context.Clienti.Remove(cliente);
await context.SaveChangesAsync();
}
return(Ok());
}
}
public async Task <IActionResult> GetRivenditoriAuto()
{
try
{
await parallelism.WaitAsync();
using (var context = new AutoConcessonarieDbContext())
{
return(Ok(context.RivenditoriAuto.ToList()));
}
}
finally
{
parallelism.Release();
}
}
static void Main(string[] args)
{
var host = new WebHostBuilder()
.UseKestrel()
.UseStartup <Startup>()
.Build();
Task restService = host.RunAsync();
using (var context = new AutoConcessonarieDbContext())
{
// Create database
context.Database.EnsureCreated();
//Fatto per la prima volta
/*Cliente c = new Cliente()
* {
* Nome = "Nome",
* DataNascita = new DateTime(2012, 1, 1),
* CF="SVV677",
* Cognome="Cognome",
* Email="*****@*****.**",
* Indirizzo="indirizzo",
* Sesso="x",
* Telefono=100000
* };
*
* context.Clienti.Add(c);
*
* context.SaveChanges();*/
}
//System.Diagnostics.Process.Start("chrome.exe", "http://localhost/netcoreapp2.0/corsoing/");
//System.Diagnostics.Process.Start("cmd", "/C start http://localhost/netcoreapp2.0/corsoing/");
restService.Wait();
}
