public tblPizzaOrder AddPizzaOrder(tblPizzaOrder pizzaOrder) { try { using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1()) { tblPizzaOrder newPizzaOrder = new tblPizzaOrder(); newPizzaOrder.Amount = pizzaOrder.Amount; newPizzaOrder.OrderID = pizzaOrder.OrderID; newPizzaOrder.PizzaID = pizzaOrder.PizzaID; context.tblPizzaOrders.Add(newPizzaOrder); context.SaveChanges(); pizzaOrder.ID = newPizzaOrder.ID; return(pizzaOrder); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblOrder AddOrder(tblOrder order) { try { using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1()) { tblOrder newOrder = new tblOrder(); newOrder.JMBG = order.JMBG; newOrder.OrderStatus = order.OrderStatus; newOrder.DateAndTimeOfOrder = order.DateAndTimeOfOrder; newOrder.TotalPrice = order.TotalPrice; context.tblOrders.Add(newOrder); context.SaveChanges(); order.ID = newOrder.ID; return(order); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public void DeleteOrder(int id) { try { using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1()) { tblOrder orderToDelete = (from r in context.tblOrders where r.ID == id select r).First(); context.tblOrders.Remove(orderToDelete); context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }
public void EditOrder(tblOrder order) { try { using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1()) { tblOrder orderDB = (from x in context.tblOrders where x.ID == order.ID select x).First(); orderDB.OrderStatus = order.OrderStatus; context.SaveChanges(); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); } }