/// <summary> /// method for adding pizza to the database /// </summary> private void SaveExecute() { try { using (PanPizzaEntities context = new PanPizzaEntities()) { tblPizza newPizza = new tblPizza(); newPizza.SizeID = size.SizeID; newPizza.Salami = pizza.Salami; newPizza.Ham = pizza.Ham; newPizza.Kulen = pizza.Kulen; newPizza.Ketchup = pizza.Ketchup; newPizza.Mayonnaise = pizza.Mayonnaise; newPizza.HotPepper = pizza.HotPepper; newPizza.Olives = pizza.Olives; newPizza.Oregano = pizza.Oregano; newPizza.Sesame = pizza.Sesame; newPizza.Cheese = pizza.Cheese; newPizza.PizzaID = pizza.PizzaID; newPizza.Price = price; context.tblPizzas.Add(newPizza); context.SaveChanges(); MessageBox.Show("The new pizza added successfully"); } } catch (Exception) { MessageBox.Show("Wrong inputs, please check your size input."); } }
public List <tblPizzaOrder> GetPizzaOrdersByOrderID(int orderID) { try { using (PizzeriaDatBEntities1 context = new PizzeriaDatBEntities1()) { List <tblPizzaOrder> list = new List <tblPizzaOrder>(); list = (from x in context.tblPizzaOrders where x.OrderID == orderID select x).ToList(); foreach (var item in list) { tblPizza pizza = (from x in context.tblPizzas where x.ID == item.PizzaID select x).First(); tblOrder order = (from x in context.tblOrders where x.ID == item.OrderID select x).First(); item.tblPizza = pizza; item.tblOrder = order; } return(list); } } catch (Exception ex) { System.Diagnostics.Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Adds a pizza to the database /// </summary> /// <param name="pizza">The pizza ID we are adding or editing</param> /// <returns>The new or pizza ingredient</returns> public tblPizza AddPizza(tblPizza pizza) { try { using (PizzaPanDBEntities context = new PizzaPanDBEntities()) { tblPizza newPizza = new tblPizza { PizzaSize = pizza.PizzaSize }; context.tblPizzas.Add(newPizza); context.SaveChanges(); pizza.PizzaID = newPizza.PizzaID; return(pizza); } } catch (Exception ex) { Debug.WriteLine("Exception" + ex.Message.ToString()); return(null); } }
/// <summary> /// Opens the Add Pizzawindow /// </summary> /// <param name="addPizzaOpen">Window that we open</param> public AddPizzaViewModel(AddPizzaWindow addPizzaOpen) { pizza = new tblPizza(); addPizzaWindow = addPizzaOpen; CanEdit = true; }
// constructor public MainWindowViewModel(MainWindow mainOpen) { main = mainOpen; pizza = new tblPizza(); SizeList = GetAllSize(); }