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