public void DeleteOrder(int orderId)
{
try
{
using (RestaurantEntities context = new RestaurantEntities())
{
tblOrder orderToDelete = (from o in context.tblOrders where o.OrderID == orderId select o).First();
context.tblOrders.Remove(orderToDelete);
context.SaveChanges();
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
}
}
public List <tblOrder> GetAllOrders()
{
try
{
using (RestaurantEntities context = new RestaurantEntities())
{
List <tblOrder> list = new List <tblOrder>();
list = (from x in context.tblOrders select x).ToList();
return(list);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblOrder EditOrder(tblOrder order)
{
try
{
using (RestaurantEntities context = new RestaurantEntities())
{
tblOrder orderToEdit = (from o in context.tblOrders where o.OrderID == order.OrderID select o).First();
orderToEdit.Date = order.Date;
orderToEdit.MenuItem = order.MenuItem;
context.SaveChanges();
return(order);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
public tblOrder AddOrder(tblOrder order)
{
try
{
using (RestaurantEntities context = new RestaurantEntities())
{
tblOrder newTblOrder = new tblOrder();
newTblOrder.Date = order.Date;
newTblOrder.MenuItem = order.MenuItem;
context.tblOrders.Add(newTblOrder);
context.SaveChanges();
return(order);
}
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString());
return(null);
}
}
