public IActionResult DeleteTable(Guid id)
{
try
{
DiningTable table = LoadEntityById <DiningTable>(id);
table.Orders.ToList <FoodOrder>().ForEach(order => { order.OrderedItems.Clear(); });
table.Orders.Clear();
table.WaiterTables.Clear();
string sqlOrderedItems = $"Delete from OrderedItem where OrderId in (Select Id from FoodOrder where TableId='{id}')";
Debug.WriteLine(sqlOrderedItems);
dao.Execute(sqlOrderedItems);
string sqlOrders = $"Delete from FoodOrder where TableId='{id}'";
Debug.WriteLine(sqlOrders);
dao.Execute(sqlOrders);
string sqlWaiterTables = $"Delete from WaiterTable where TableId='{id}'";
Debug.WriteLine(sqlWaiterTables);
dao.Execute(sqlWaiterTables);
table = LoadEntityById <DiningTable>(id);
Debug.WriteLine(table.ToJson());
dao.Delete(table);
return(Ok(table));
}
catch (Exception e)
{
return(HandleDeleteException(e));
}
}
