public ActionResult DeleteConfirmed(string id)
{
tblGuest tblGuest = db.tblGuests.Find(id);
tblUsedTable table = db.tblUsedTables.Find(tblGuest.table_num);
tblUnusedTable unusedTable = new tblUnusedTable();
unusedTable.table_num = table.table_num;
unusedTable.description = table.description;
db.tblUnusedTables.Add(unusedTable);
db.tblUsedTables.Remove(table);
db.tblGuests.Remove(tblGuest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "guest_phone_number,guest_name,time_arrived,num_of_guests,table_num,reservation")] tblGuest tblGuest)
{
if (ModelState.IsValid)
{
tblUnusedTable table = db.tblUnusedTables.Find(tblGuest.table_num);
tblUsedTable usedTable = new tblUsedTable();
usedTable.table_num = table.table_num;
usedTable.description = table.description;
//add used table
db.tblUsedTables.Add(usedTable);
//remove from available tables
db.tblUnusedTables.Remove(table);
db.tblGuests.Add(tblGuest);
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.table_num = new SelectList(db.tblUnusedTables, "table_num", "description", tblGuest.table_num);
return(View(tblGuest));
}
