Example #1
0
        public static void Main()
        {
            var db = new FurnitureFactoryDbContext();
            ConsoleUserInterfaceIO io = new ConsoleUserInterfaceIO();

            //db.Database.Delete();
            //db.Database.Create();

            //var mongodata = new MongoDbData(DatabaseName, io);
            //mongodata.Import(db);

            //PdfExporter pdfExporter = new PdfExporter(db);
            //pdfExporter.GeneratePdf();

            var furnituresForBedroom = db.Products
                                       .Where(x => x.RoomId == 1)
                                       .Select(x => x.Series.Name)
                                       .ToList();

            // Output must be: ALVIS \n  396    Tests, huh? :D

            io.SetOutput(furnituresForBedroom.FirstOrDefault());
            io.SetOutput(db.Products.Count());

            // task 4.1
            //var jsonReporter = new JsonProductsReporter(db);
            //jsonReporter.GetJsonReport().Load();

            // task 4.2
            //var mySqlImporter = new SalesReportsMySqlImporter(io);
            //mySqlImporter.Save();

            //// Generate Xml Report in Xml-Exports folder
            var productXmlReport = new ProductsXmlFileExporter(db);

            productXmlReport.GetXmlReport();

            var ordersXmlReport = new OrdersXmlFileExporter(db);

            ordersXmlReport.GetXmlReport();

            //// import XML file
            //var importProducts = new ProductsXmlFileImporter();
            //importProducts.ImportXmlData("../../../Xml-Data.xml");


            // Load excel from zip - Task1

            LoadSalesReports(SourceSalesReportsArchiveFilePath);
        }