async Task IRepository.AddStoreAsync(BusinessModels.Store store)
{
EfModels.Store newStore = new EfModels.Store()
{
Name = store.Name,
State = store.State,
Street = store.Street,
City = store.City,
Zip = store.Zip
};
await _context.AddAsync(newStore);
await _context.SaveChangesAsync();
}
/// <summary>
/// Returns the order History by Store ID
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
BusinessModels.Store IRepository.GetOrderHistoryOfStore(int id)
{
var dbOrderHitory = _context.CustomerOrders.Include(c => c.Customer).Include(c => c.Store);
var stores = new BusinessModels.Store(id);
foreach (var order in dbOrderHitory)
{
if (order.StoreId == id)
{
var time = order.TransactionTime;
stores.Orders.Add(new Order(order.TransactionNumber, id, order.CustomerId, order.Customer.FirstName, order.Customer.LastName, order.TransactionTime.ToString()));
stores.Name = order.Store.Name;
}
}
return(stores);
}
BusinessModels.Store IRepository.GetAllProducts(int id)
{
var dbInventory = _context.Inventories.Include(i => i.Product).ThenInclude(i => i.Prices);
var store = new BusinessModels.Store(id, "Walmart");
foreach (var inventory in dbInventory)
{
// wont let me do .First i'll have to ask nick why
if (inventory.StoreId == id)
{
// turn the price datatype to a list
var PriceList = inventory.Product.Prices.ToList();
// should grab the newest price in price list
var price = PriceList[PriceList.Count - 1].Price1;
// add to the Inventory class
store.AddInventory(new BusinessModels.Product(inventory.Product.ProductId, inventory.Product.Name, (int)inventory.Quantity, (double)price));
}
}
return(store);
}
