public List <domain.Pizza> ReadAllPizzas(int orderId) { //var pizzas = _db.Pizza; //var pizzaswithcrust = _db.Pizza.Include(t => t.Crust).Include(t => t.Size); var domainPizzas = new List <domain.Pizza>(); var dbPizzas = _db.Pizza.Include(t => t.Crust).Include(t => t.Size).Where(t => t.OrderId == orderId).ToList(); foreach (Pizza dbPizza in dbPizzas) { domain.Pizza pizza = new domain.Pizza(); pizza.Name = dbPizza.Name; pizza.Size = new domain.Size() { Name = dbPizza.Size.Name, Price = (double)dbPizza.Size.Price }; pizza.Crust = new domain.Crust() { Type = dbPizza.Crust.Type, Price = (double)dbPizza.Crust.Price }; var pizzaToppings = _db.PizzaTopping.Where(t => t.PizzaId == dbPizza.PizzaId).Include(t => t.Topping); foreach (PizzaTopping pt in pizzaToppings) { domain.Topping newTop = new domain.Topping() { Name = pt.Topping.Name, Price = (double)pt.Topping.Price }; pizza.Toppings.Add(newTop); } domainPizzas.Add(pizza); } return(domainPizzas); }
public void CreatePizza(domain.Pizza pizza, int orderId) { var dbPizza = new Pizza(); dbPizza.Name = pizza.name; dbPizza.Size = pizza.size; dbPizza.Crust = pizza.crust; dbPizza.OrderId = orderId; _db.Pizza.Add(dbPizza); _db.SaveChanges(); System.Console.WriteLine("Pizza info"); // System.Console.WriteLine(ReadAllOrdersIds().Last()); foreach (var t in pizza.Toppings) { CreateTopping(t, ReadAllOrdersIds().Last()); } }
public void Create(domain.Pizza pizza) { var newPizza = new Pizza(); newPizza.Crust = new Crust() { Name = pizza.Crust.Name }; newPizza.Size = new Size() { Name = pizza.Size.Name }; newPizza.Name = pizza.Name; var orderDate = DateTime.UtcNow; _db.Pizza.Add(newPizza); //Here, you can add a new Pizza table to C# _db.SaveChanges(); }
public void Create(domain.Pizza pizza) { var newPizza = new Pizza(); newPizza.Crust = new Crust() { Name = pizza.Crust.Name }; newPizza.Size = new Size() { Name = pizza.Size.Name }; newPizza.Name = pizza.Name; var orderDate = DateTime.UtcNow; //newPizza.DateModified = DateTime.Now; //newPizza.Active = false; //newPizza.UserModified = Identity.Hash; _db.Pizza.Add(newPizza); _db.SaveChanges(); }
public void CreatePizza(domain.Pizza pizza, int orderId) { var newPizza = new Pizza(); newPizza.Name = pizza.Name; newPizza.Crust = new Crust() { Type = pizza.Crust.Type, Price = (decimal)pizza.Crust.Price }; newPizza.Size = new Size() { Name = pizza.Size.Name, Price = (decimal)pizza.Size.Price }; newPizza.OrderId = orderId; _db.Pizza.Add(newPizza); foreach (domain.Topping t in pizza.Toppings) { var pizzaTopping = new PizzaTopping(); pizzaTopping.Pizza = newPizza; Topping newTop = new Topping() { Name = t.Name, Price = (decimal)t.Price }; pizzaTopping.Topping = newTop; _db.PizzaTopping.Add(pizzaTopping); } _db.SaveChanges(); }
private void AddOrder(PizzaOrder order) { int storeID = (int)order.StoreId; int userID = (int)order.UserId; int orderID = (int)order.OrderId; int pizzaID = (int)order.PizzaId; try { _ = orders[storeID]; } catch (KeyNotFoundException) { orders.Add(storeID, new Dictionary <int, Dictionary <int, domain.Order> >()); // Console.WriteLine("S" + storeID); // working } try { _ = orders[storeID][userID]; } catch (KeyNotFoundException) { orders[storeID].Add(userID, new Dictionary <int, domain.Order>()); // Console.WriteLine($"S{storeID} U{userID}"); // working } domain.Order domainOrder; try { domainOrder = orders[storeID][userID][orderID]; } catch (KeyNotFoundException) { domainOrder = new domain.Order { created = order.WhenOrdered, store = stores[storeID], user = order.UserId }; orders[storeID][userID].Add(orderID, domainOrder); // Console.WriteLine($"S{storeID} U{userID} O{orderID}"); // working } domain.Pizza pizza = pizzas[pizzaID]; pizza.size = order.Size[0]; domainOrder.AddPizza(pizzas[pizzaID], true); orders[storeID][userID][orderID] = domainOrder; }
public Pizza ChoosePizza() { int select; bool end = false; Pizza pizza = new Pizza(); do { System.Console.WriteLine("Type a number to select a pizza"); System.Console.WriteLine("1 - Cheese Pizza - $5.25"); System.Console.WriteLine("2 - Pepperoni Pizza - $5.50"); System.Console.WriteLine("3 - Vegetarian Pizza - $5.75"); System.Console.WriteLine("4 - Hawaiian Pizza - $6.25"); System.Console.WriteLine("5 - Custom - $5.00 + toppings"); System.Console.WriteLine("6 - Gold Pizza - $245.00"); if (int.TryParse(System.Console.ReadLine(), out select)) { System.Console.WriteLine(); end = false; } else { System.Console.WriteLine("Invalid Choice"); end = true; continue; } switch (select) { case 1: pizza.Name = "Cheese Pizza"; pizza.Toppings = new List <Topping> { new Topping("Cheese", 0.25) }; break; case 2: pizza.Name = "Pepperoni Pizza"; pizza.Toppings = new List <Topping> { new Topping("Cheese", 0.25), new Topping("Pepperoni", 0.25) }; break; case 3: pizza.Name = "Vegetarian Pizza"; pizza.Toppings = new List <Topping> { new Topping("Cheese", 0.25), new Topping("Onions", 0.25), new Topping("Green Peppers", 0.25) }; break; case 4: pizza.Name = "Vegetarian Pizza"; pizza.Toppings = new List <Topping> { new Topping("Cheese", 0.25), new Topping("Ham", 0.50), new Topping("Pineapple", 0.50) }; break; case 5: pizza.Name = "Custom Pizza"; pizza.Toppings = ChooseToppings(); break; case 6: pizza.Name = "Gold Pizza"; pizza.Toppings = new List <Topping> { new Topping("Gold", 240.00) }; break; default: end = true; System.Console.WriteLine("Invalid Choice"); break; } } while (end); return(pizza); }
public void RemovePizza(Pizza pizza) { _pizzas.Remove(pizza); }