public List <domain.Order> ReadOrders(int id, string type = "Store")
{
List <domain.Order> orders = new List <domain.Order>();
List <Order> orderEntities;
if (type == "Store")
{
orderEntities = _db.Order.Where(o => o.StoreId == id).ToList();
}
else
{
orderEntities = _db.Order.Where(o => o.UserId == id).ToList();
}
foreach (Order o in orderEntities)
{
domain.Order newO = new domain.Order();
newO.Date = o.DateCreated;
newO.Status = o.Status;
newO.OrderId = o.OrderId;
newO.StoreId = o.StoreId;
newO.UserId = o.UserId;
newO.Pizzas = ReadAllPizzas(newO.OrderId);
orders.Add(newO);
}
return(orders);
}
private static void FetchAllOrderIDForUserHistory()
{
try{
var usersOrdersHistoryList = _db.Orders.Where(o => o.UserId == _CurrentUsersList[0].UserID).ToList();
_CurrentUsersList[0].PizzaBoxStore.OrderHistory = new List <PizzaBox.Domain.Models.Order>();
foreach (var ordersObjectDB in usersOrdersHistoryList)
{
var newOrderType = new PizzaBox.Domain.Models.Order();
newOrderType.SetOrderID(ordersObjectDB.OrderId);
_CurrentUsersList[0].PizzaBoxStore.OrderHistory.Add(newOrderType);
}
} catch {
System.Console.WriteLine("Unable to reterive any orders from ");
}
}
public int CreateOrder(domain.Order order, int userid, int storeid)
{
var newOrder = new Order();
newOrder.UserId = userid;
newOrder.StoreId = storeid;
newOrder.Status = order.Status;
newOrder.DateCreated = order.Date;
_db.Order.Add(newOrder);
_db.SaveChanges();
int newOrderId = newOrder.OrderId;
foreach (domain.Pizza p in order.Pizzas)
{
CreatePizza(p, newOrderId);
}
return(newOrderId);
}
public void CreateOrder(domain.Order order, int userId, int storeId)
{
var dbOrder = new Order();
dbOrder.UserId = (userId + 1);
dbOrder.StoreId = (storeId + 1);
dbOrder.Done = order.done;
dbOrder.DateOrdered = System.DateTime.Now;
//dbOrder.OrderId = dbOrder.OrderId + 1;
_db.Order.Add(dbOrder);
_db.SaveChanges();
System.Console.WriteLine("FRUSTRATION:Order ID added");
System.Console.WriteLine(ReadAllOrdersIds().Last());
foreach (var p in order.Pizzas)
{
CreatePizza(p, ReadAllOrdersIds().Last());
}
_db.SaveChanges();
}
public void AddOrderToDB(domain.Order order)
{
int newOrderNumber = db.PizzaOrder.Max(p => p.OrderId) + 1;
List <domain.Order> ordersToAdd = new List <domain.Order>();
foreach (domain.Pizza pizza in order.pizzas)
{
int store_ID = order.store.id;
int user_ID = order.user;
PizzaOrder dbOrder = new PizzaOrder {
OrderId = newOrderNumber,
StoreId = store_ID,
PizzaId = pizza.id,
UserId = user_ID,
WhenOrdered = (DateTime)order.created,
TotalCost = (float)order.totalCost,
Size = pizza.size.ToString()
};
AddOrder(dbOrder);
db.PizzaOrder.Add(dbOrder);
}
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 void AddOrder(Order o)
{
this.CompletedOrders.Add(o);
}