public async Task <IActionResult> GetCliente([FromQuery] string cf)
{
using (var context = new CateringsDbContext())
{
return(Ok(await context.Cliente.FirstOrDefaultAsync(x => x.Codice_Fiscale == cf))); /*tale che ha l'id uguale a quello che ti sto passando*/
}
}
public async Task <IActionResult> GetRistorante([FromQuery] string piva)
{
using (var context = new CateringsDbContext())
{
return(Ok(await context.Ristorante.FirstOrDefaultAsync(x => x.Piva == piva))); /*tale che ha l'id uguale a quello che ti sto passando*/
}
}
public async Task <IActionResult> GetPortata([FromQuery] int id)
{
using (var context = new CateringsDbContext())
{
return(Ok(await context.Portata.FirstOrDefaultAsync(x => x.Id == id))); /*tale che ha l'id uguale a quello che ti sto passando*/
}
}
public async Task <IActionResult> GetCatering([FromQuery] int id)
{
using (var context = new CateringsDbContext())
{
return(Ok(await context.Catering.FirstOrDefaultAsync(x => x.Codice == id)));
}
}
public async Task <IActionResult> UpdateCliente([FromBody] Cliente cliente)
{
using (var context = new CateringsDbContext())
{
context.Cliente.Update(cliente);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdatePortata([FromBody] Portata portata)
{
using (var context = new CateringsDbContext())
{
context.Portata.Update(portata);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateInvitato([FromBody] Invitato invitato)
{
using (var context = new CateringsDbContext())
{
context.Invitato.Update(invitato);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> UpdateMenu([FromBody] Menu menu)
{
using (var context = new CateringsDbContext())
{
context.Menu.Update(menu);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> CreateRistorante([FromBody] Ristorante ristorante)
{
using (var context = new CateringsDbContext())
{
context.Ristorante.Add(ristorante);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> CreateCatering([FromBody] Catering catering)
{
using (var context = new CateringsDbContext())
{
context.Catering.Add(catering);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> DeleteCliente([FromQuery] int id)
{
using (var context = new CateringsDbContext())
{
var cliente = await context.Cliente.FirstOrDefaultAsync(x => x.Id == id);
context.Cliente.Remove(cliente);
await context.SaveChangesAsync();
return(Ok());
}
}
public IActionResult SetupDatabase()
{
lock (setupLock)
{
using (var context = new CateringsDbContext())
{
// Create database
context.Database.EnsureCreated();
}
return(Ok("database created"));
}
}
public async Task <IActionResult> DeletePortata([FromQuery] int id)
{
using (var context = new CateringsDbContext())
{
var portata = await context.Portata.FirstOrDefaultAsync(x => x.Id == id);
context.Portata.Remove(portata);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> DeleteInvitato([FromQuery] int id)
{
using (var context = new CateringsDbContext())
{
var invitato = await context.Invitato.FirstOrDefaultAsync(x => x.Id == id);
context.Invitato.Remove(invitato);
await context.SaveChangesAsync();
return(Ok());
}
}
public async Task <IActionResult> GetCliente()
{
try
{
await parallelism.WaitAsync();
using (var context = new CateringsDbContext())
{
return(Ok(await context.Cliente.ToListAsync()));
}
}
finally
{
parallelism.Release();
}
}
static void Main(string[] args)
{
using (var context = new CateringsDbContext())
{
// Create database
context.Database.EnsureCreated();
/*inserimento*//*
* context.Students.Add(s);
* context.Students.Add(n);
* context.Students.Add(f);
* context.Corsi.Add(cor);
* context.SaveChanges();
*
* /*cancellazione*/
/*var a=context.Students.FirstOrDefault(x => x.Name == "Giovanni");
* context.Students.Remove(a);
* context.SaveChanges();
*
* /*update*/
/*var b= context.Students.FirstOrDefault(x => x.Name == "Piero");
* b.DateOfBirth = new DateTime(2017, 2, 1);
* context.Students.Update(b);
* context.SaveChanges();*/
}
var host = new WebHostBuilder()
.UseKestrel()
.UseStartup <Startup>()
.Build();
Task restService = host.RunAsync();
//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();
Console.ReadKey();
}
