Пример #1
0
        private static void Main(string[] args)
        {
            var csvRepository = new CsvRepository();

            csvRepository.LoadFiles();

            var nwCsvPart2 = new NorthWind(csvRepository);

            // Subscribe..
            nwCsvPart2.NewOrder += NewOrder_Load;

            nwCsvPart2.AddOrder("Doegn Netto", "Rued Langgaards Vej 23a", "Copenhagen", "South", "2300", "Denmark");

            Console.WriteLine();
            Console.WriteLine("First five products:");
            List <Product> firstFiveProducts = nwCsvPart2.Products.Take(5).ToList();

            firstFiveProducts.ForEach(product => Console.WriteLine(product.ProductName));

            Console.WriteLine();
            var shippingCountryCount =
                nwCsvPart2.Orders.GroupBy(order => order.ShipCountry)
                .Select(shipCountry => new
            {
                ShipCountry = shipCountry.Key,
                Count       = shipCountry.Count()
            }).OrderByDescending(x => x.Count).ToList();

            shippingCountryCount.ForEach(
                shippingCountry => Console.WriteLine(shippingCountry.ShipCountry + " - " + shippingCountry.Count));


            var csvRepository2 = new CsvRepository();
            var nw1            = new NorthWind(csvRepository2);

            Console.WriteLine("\nTest CSV 1:");
            List <Order> csvOrders = nw1.Orders.AsEnumerable().Take(10).ToList();

            foreach (Order order in csvOrders)
            {
                order.Order_Details.ToList().ForEach(x => Console.WriteLine(x.Order.OrderID + " " + x.UnitPrice));
            }


            var dbRepository = new DbRepository();
            var nw           = new NorthWind(dbRepository);

            Console.WriteLine("\nTest DB1:");
            List <Order> dbOrders = nw.Orders.AsEnumerable().Take(10).ToList();

            foreach (Order order in dbOrders)
            {
                order.Order_Details.ToList().ForEach(x => Console.WriteLine(x.Order.OrderID + " " + x.UnitPrice));
            }


            Console.WriteLine("\nTest2:");

            List <Product> products2 = nw.Products.AsEnumerable().Skip(10).Take(10).ToList();

            foreach (Product product in products2)
            {
                Console.WriteLine("Product2 name " + product.ProductID);
            }


            Console.WriteLine("\nTest3:");
            List <Product> products3 = nw.Products.AsEnumerable().Take(10).ToList();

            foreach (Product product in products3)
            {
                Console.WriteLine("Product3 name " + product.ProductID);
            }
        }
Пример #2
0
 public ReportModule(DbRepository context)
 {
     _context = context ?? new DbRepository();
 }