private static int GetProductsCount(SQLServerContext db)
{
var productsCount = db.Products.Count();
return productsCount;
}
private static List<DbDataHelpType> GetProductsDataFromDb(SQLServerContext db)
{
var productsAndTheirSales = db.Products.GroupJoin(
db.Sales,
p => p.ID,
s => s.Product.ID,
(p, s) => new DbDataHelpType()
{
Id = p.ID,
ProductCode = p.ProductCode,
Name = p.Name,
TotalQuantitySold = s.DefaultIfEmpty().Select(x => x.Quantity).FirstOrDefault(),
TotalIncomes = s.DefaultIfEmpty().Select(x => x.Quantity).FirstOrDefault() * p.Price,
ShopName = s.DefaultIfEmpty().Select(x => x.Shop.Name).FirstOrDefault()
}).ToList();
return productsAndTheirSales;
}
