static void Main()
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
var mp = new dataMapper();
var _ = mp.getAllCategories();
var __ = mp.getAllProducts();
var ___ = mp.getAllOrders();
// Names of the 5 most expensive products
var first = __
.OrderByDescending(p => p.unit_price)
.Take(5)
.Select(p => p.nome);
Console.WriteLine(string.Join(Environment.NewLine, first));
Console.WriteLine(new string('-', 10));
// Number of products in each category
var second = __
.GroupBy(p => p.catId)
.Select(grp => new { Category = _.First(c => c.Id == grp.Key).NAME, Count = grp.Count() })
.ToList();
foreach (var item in second)
{
Console.WriteLine("{0}: {1}", item.Category, item.Count);
}
Console.WriteLine(new string('-', 10));
// The 5 top products (by order quantity)
var third = ___
.GroupBy(o => o.product_id)
.Select(grp => new { Product = __.First(p => p.id == grp.Key).nome, Quantities = grp.Sum(grpgrp => grpgrp.quant) })
.OrderByDescending(q => q.Quantities)
.Take(5);
foreach (var item in third)
{
Console.WriteLine("{0}: {1}", item.Product, item.Quantities);
}
Console.WriteLine(new string('-', 10));
// The most profitable category
var category = ___
.GroupBy(o => o.product_id)
.Select(g => new { catId = __.First(p => p.id == g.Key).catId, price = __.First(p => p.id == g.Key).unit_price, quantity = g.Sum(p => p.quant) })
.GroupBy(gg => gg.catId)
.Select(grp => new { category_name = _.First(c => c.Id == grp.Key).NAME, total_quantity = grp.Sum(g => g.quantity * g.price) })
.OrderByDescending(g => g.total_quantity)
.First();
Console.WriteLine("{0}: {1}", category.category_name, category.total_quantity);
}
static void Main()
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
var dataMapper = new dataMapper();
var categories = dataMapper.getAllCategories();
var products = dataMapper.getAllProducts();
var orders = dataMapper.getAllOrders();
var fiveMostExpensiveProducts = products
.OrderByDescending(p => p.UnitPrice)
.Take(5)
.Select(p => p.Name);
Console.WriteLine(string.Join(Environment.NewLine, fiveMostExpensiveProducts));
Console.WriteLine(new string('-', 10));
var countOfProductsInCategories = products
.GroupBy(product => product.CategoryID)
.Select(group => new { Category = categories.First(cat => cat.Id == group.Key)
.Name, Count = group.Count() })
.ToList();
foreach (var item in countOfProductsInCategories)
{
Console.WriteLine("{0}: {1}", item.Category, item.Count);
}
Console.WriteLine(new string('-', 10));
var topProductsByOrderQuantity = orders
.GroupBy(order => order.ProductId)
.Select(group => new { Product = products.First(product => product.Id == group.Key)
.Name, Quantities = group.Sum(count => count.Quantity) })
.OrderByDescending(quantity => quantity.Quantities)
.Take(5);
foreach (var item in topProductsByOrderQuantity)
{
Console.WriteLine("{0}: {1}", item.Product, item.Quantities);
}
Console.WriteLine(new string('-', 10));
var mostProfitableCategory = orders
.GroupBy(order => order.ProductId)
.Select(group => new { catId = products.First(product => product.Id == group.Key)
.CategoryID, price = products.First(product => product.Id == group.Key)
.UnitPrice, quantity = group.Sum(product => product.Quantity) })
.GroupBy(category => category.catId)
.Select(group => new { category_name = categories.First(category => category.Id == group.Key).Name, total_quantity = group.Sum(grp => grp.quantity * grp.price) })
.OrderByDescending(group => group.total_quantity)
.First();
Console.WriteLine("{0}: {1}", mostProfitableCategory.category_name, mostProfitableCategory.total_quantity);
}
static void Main()
{
Thread.CurrentThread.CurrentCulture = CultureInfo.InvariantCulture;
var mp = new dataMapper();
var _ = mp.getAllCategories();
var __ = mp.getAllProducts();
var ___ = mp.getAllOrders();
// Names of the 5 most expensive products
var first = __
.OrderByDescending(p => p.unit_price)
.Take(5)
.Select(p => p.nome);
Console.WriteLine(string.Join(Environment.NewLine, first));
Console.WriteLine(new string('-', 10));
// Number of products in each category
var second = __
.GroupBy(p => p.catId)
.Select(grp => new { Category = _.First(c => c.Id == grp.Key).NAME, Count = grp.Count() })
.ToList();
foreach (var item in second)
{
Console.WriteLine("{0}: {1}", item.Category, item.Count);
}
Console.WriteLine(new string('-', 10));
// The 5 top products (by order quantity)
var third = ___
.GroupBy(o => o.product_id)
.Select(grp => new { Product = __.First(p => p.id == grp.Key).nome, Quantities = grp.Sum(grpgrp => grpgrp.quant) })
.OrderByDescending(q => q.Quantities)
.Take(5);
foreach (var item in third)
{
Console.WriteLine("{0}: {1}", item.Product, item.Quantities);
}
Console.WriteLine(new string('-', 10));
// The most profitable category
var category = ___
.GroupBy(o => o.product_id)
.Select(g => new { catId = __.First(p => p.id == g.Key).catId, price = __.First(p => p.id == g.Key).unit_price, quantity = g.Sum(p => p.quant) })
.GroupBy(gg => gg.catId)
.Select(grp => new { category_name = _.First(c => c.Id == grp.Key).NAME, total_quantity = grp.Sum(g => g.quantity * g.price) })
.OrderByDescending(g => g.total_quantity)
.First();
Console.WriteLine("{0}: {1}", category.category_name, category.total_quantity);
}