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