// Update DiningTable info public async Task <IActionResult> UpdateDiningTable(DiningTableDisplayModel table) { DiningTableModel updatedTable = new DiningTableModel { Id = table.Id, TableNumber = table.TableNumber, Seats = table.Seats }; await _data.UpdateTable(updatedTable); return(RedirectToAction("ViewDiningTables")); }
// Edit DiningTable with database Id = id public async Task <IActionResult> EditDiningTable(int id) { DiningTableModel foundTable = await _data.GetTableById(id); DiningTableDisplayModel table = new DiningTableDisplayModel { Id = foundTable.Id, TableNumber = foundTable.TableNumber, Seats = foundTable.Seats }; return(View(table)); }
// Insert DiningTable into database public async Task <IActionResult> InsertDiningTable(DiningTableDisplayModel table) { if (ModelState.IsValid) { DiningTableModel newTable = new DiningTableModel { TableNumber = table.TableNumber, Seats = table.Seats }; await _data.InsertTable(newTable); return(RedirectToAction("ViewDiningTables")); } return(View()); }
// Update DiningTable info in database public async Task UpdateTable(DiningTableModel table) { await _sql.SaveData <DiningTableModel>("DiningTable_Update", table); }
// Insert DiningTable into database public async Task InsertTable(DiningTableModel table) { await _sql.SaveData <DiningTableModel>("DiningTable_Insert", table); }