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