public List <Order> GetOrdersByStore(Store store)
{
using var context = new project0Context(_contextOptions);
var custRepo = new CustomerRepo(_contextOptions);
var dbOrders = context.Orders
.Where(o => o.StoreId == store.StoreId)
.Include(o => o.Store)
.Include(o => o.Customer)
.ToList();
var result = new List <Order>();
foreach (var order in dbOrders)
{
var newLocation = _storeRepo.GetStoreById(order.StoreId);
var newCust = _customerRepo.GetCustomerById(order.CustomerId);
var newOrder = new Order()
{
OrderId = order.OrderId,
Store = newLocation,
Customer = newCust,
OrderTotalPrice = order.OrderTotal
};
newOrder.OrderId = order.OrderId;
newOrder.Date = order.Date;
var newOrderItems = GetOrderItemsByOrder(newOrder);
foreach (var orderItem in newOrderItems)
{
newOrder.OrderItems.Add(orderItem);
}
result.Add(newOrder);
}
return(result);
}
public OrderRepo(DbContextOptions <project0Context> contextOptions)
{
_contextOptions = contextOptions;
_storeRepo = new StoreRepo(contextOptions);
_customerRepo = new CustomerRepo(contextOptions);
}
