public PizzaStore.Storing.Pizza Create(PizzaStore.Domain.Models.Pizza pizza)
{
var newPizza = new PizzaStore.Storing.Pizza();
newPizza.Crust = new Crust()
{
Name = pizza.Crust.CrustName, Price = (decimal)pizza.Crust.Price
};
newPizza.Size = new Size()
{
Name = pizza.Size.SizeName, Price = (decimal)pizza.Size.Price
};
newPizza.Name = pizza.Name;
newPizza.Price = (decimal)pizza.Price;
/**
* foreach (var top in pizza.Toppings)
* {
* //make a new entry in fktoppingspizza to link each pizza and topping
*
* foreach (var t in _db.Topping.ToList())
* {
* if(t.Name==top.TopName)//requires toppings to be in database //db.Toppings.FirstOrDefault(c=c.Name==pizza.Crust.Name)
* {
* var topPizza= new PizzaStore.Storing.FkPizzaToppingId();
* topPizza.Pizza=newPizza;
* topPizza.Topping=t;
* _db.FkPizzaToppingId.Add(topPizza);
* }
* }
* }
**/
// _db.Pizza.Add(newPizza);
// _db.SaveChanges();
return(newPizza);
}
public List <Domain.Models.Order> ReadOrdersUsingStoreID(int sID, string storeName)
{
List <Domain.Models.Order> orders = new List <Domain.Models.Order>();
//Find store orders
foreach (var ord in db.Order.ToList())
{
if (sID == ord.StoreId)
{
List <PizzaStore.Domain.Models.Pizza> pizzas = new List <PizzaStore.Domain.Models.Pizza>();
//Make Pizza, then add it to the List of Pizzas
//Find order pizzas using junction table Order.Pizza
foreach (var p in db.PizzaJunction.ToList())
{
if (ord.OrderId == p.OrderId)
{
//Find Pizza referenced by Order.Pizza using Pizza.Pizza table
foreach (var p1 in db.Pizza.ToList())
{
if (p.PizzaId == p1.PizzaId)
{
//Create new Pizza to add to order
PizzaStore.Domain.Models.Pizza piz = new PizzaStore.Domain.Models.Pizza();
piz.Name = p1.Name;
//Add Crust to Pizza
foreach (var c in db.Crust.ToList())
{
if (p1.CrustId == c.CrustId)
{
piz.Crust = new PizzaStore.Domain.Models.Crust(c.Name);
break;
}
}
//Add Size to Pizza
foreach (var s in db.Size.ToList())
{
if (p1.SizeId == s.SizeId)
{
piz.Size = new PizzaStore.Domain.Models.Size(s.Name);
break;
}
}
//Find Toppings
foreach (var pt in db.PizzaTopping.ToList())
{
if (pt.PizzaId == p1.PizzaId)
{
//Add Toppings
foreach (var top in db.Topping.ToList())
{
if (top.ToppingId == pt.ToppingId)
{
piz.addTopping(new PizzaStore.Domain.Models.Topping(top.Name));
break;
}
}
}
}
pizzas.Add(piz);
}
}
}
}
orders.Add(new Domain.Models.Order(pizzas, Convert.ToDateTime(ord.DateOrdered), (bool)ord.Placed, (bool)ord.Completed, new Domain.Models.Store()
{
Name = storeName
}));
}
}
return(orders);
}
