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