public static void DeleteOrder(tblOrder order) { try { using (dbPizzeria1Entities context = new dbPizzeria1Entities()) { tblOrder orderToDelete = (from u in context.tblOrders where u.orderId == order.orderId select u).First(); context.tblOrders.Remove(orderToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public static tblOrder AddNewOrder(tblOrder order) { try { using (dbPizzeria1Entities context = new dbPizzeria1Entities()) { if (order.orderId == 0) { //add tblOrder newOrder = new tblOrder(); newOrder.status = order.status; newOrder.username = order.username; newOrder.dateAndTime = order.dateAndTime; newOrder.dishId = order.dishId; newOrder.count = order.count; context.tblOrders.Add(newOrder); context.SaveChanges(); order.orderId = newOrder.orderId; return(order); } else { //edit tblOrder orderToEdit = (from x in context.tblOrders where x.orderId == order.orderId select x).FirstOrDefault(); orderToEdit.status = order.status; context.SaveChanges(); return(order); } } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception: " + ex.Message.ToString()); return(null); } }