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