public List <tblPizza> GetPizzas() { try { using (PizzeriaServiceEntities context = new PizzeriaServiceEntities()) { List <tblPizza> list = new List <tblPizza>(); list = (from p in context.tblPizzas select p).ToList(); return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
public tblPizzaOrder AddPizzaOrder(tblPizzaOrder pizzaOrder) { try { using (PizzeriaServiceEntities context = new PizzeriaServiceEntities()) { 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 (PizzeriaServiceEntities context = new PizzeriaServiceEntities()) { tblOrder newOrder = new tblOrder(); newOrder.CustomerJMBG = order.CustomerJMBG; newOrder.OrderStatus = order.OrderStatus; newOrder.OrderDateTime = order.OrderDateTime; 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); } }