/// <summary>
/// Uses linq to find the first 5 products in the NorthWind class
/// </summary>
/// <param name="northWind">A NorthWind class</param>
public static void First5Products(NorthWind northWind)
{
Console.WriteLine("");
Console.WriteLine("First 5 products");
//Write list with name of first 5 products
northWind.Products().Take(5).ToList().ForEach(x => WriteLineLock(x.ProductName));
}
/// <summary>
/// Uses linq to find the "Counting of orders by shipping country. Output by descending count" in the NorthWind class
/// </summary>
/// <param name="northWind">A NorthWind class</param>
public static void OrdersByShippingCountry(NorthWind northWind)
{
Console.WriteLine("");
Console.WriteLine("Counting of orders by shipping country. Output by descending count");
//Write the counting of orders by shipping country. Order the output by descending count [use LINQ]
Dictionary<string, int> countryCount = new Dictionary<string, int>();
northWind.Orders().GroupBy(x => x.ShipCountry).Select(x => x.First()).ToList()
.ForEach(x => countryCount.Add(x.ShipCountry, northWind.Orders().Select(a => a.ShipCountry).Where(c => c == x.ShipCountry).Count()));
countryCount.Keys.ToList().OrderBy(x => countryCount[x]).ToList().ForEach(x => WriteLineLock(x + " : " + countryCount[x]));
}
/// <summary>
/// Instantiating Respiratory and NorthWind classes to use in solutions.
/// And runs solutions.
/// </summary>
/// <param name="args"></param>
static void Main(string[] args)
{
//Load CSV...
Respiratory respiratory = CSVimporter.ImportCSV();
NorthWind northWind = new NorthWind(respiratory);
northWind.newOrderEvent += subscription;
Console.WriteLine("Adding an order to Denmark.");
northWind.AddOrder(DateTime.Now, "testName", "testAddress", "testCity", "testRegion", "2300", "Denmark");
//Write list with name of first 5 products
First5Products(northWind);
//Write the counting of orders by shipping country. Order the output by descending count [use LINQ]
OrdersByShippingCountry(northWind);
Console.ReadLine();
}
