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(); }