/// <summary>
/// Method to get the products from an order
/// </summary>
/// <param name="orderId">The id of the order to get the products from</param>
public IEnumerable <BusinessLibrary.Product> GetOrderDetails(int orderId)
{
List <BusinessLibrary.Product> orderProductsList = new List <BusinessLibrary.Product>();
IQueryable <Entity.Entities.OrderProduct> orders = _dbContext.OrderProducts.Include(x => x.Product).Where(x => x.OrderId == orderId);
foreach (var p in orders)
{
BusinessLibrary.Product prod = new BusinessLibrary.Product(p.ProductId, p.Product.Name, (double)p.ProductPricePaid, p.ProductQty);
orderProductsList.Add(prod);
}
return(orderProductsList);
}
/// <summary>
/// Method to get a stores product inventory
/// </summary>
/// <param name="l">The stores location object</param>
public IEnumerable <BusinessLibrary.Product> GetStoreInventory(BusinessLibrary.StoreLocation l)
{
//return list to hold all the products
List <BusinessLibrary.Product> products = new List <BusinessLibrary.Product>();
//get products from invetory of selected location
IQueryable <Entity.Entities.StoreInventory> inventory = _dbContext.StoreInventories.Include(x => x.Product)
.Where(x => x.LocationId == l.StoreLocationId + 1);
//add each product to list
foreach (var item in inventory)
{
BusinessLibrary.Product p = new BusinessLibrary.Product(item.ProductId, item.Product.Name, (double)item.Product.Price, item.ProductQty);
products.Add(p);
}
return(products);
}
