示例#1
0
        public static void Main()
        {
            var repo        = new VehicleVendorRepository(new IVehicleVendorDbContext[] { new VehicleVendorDbContext() });
            var repoMySql   = new VehicleVendorMySqlRepository();
            var repoSqLite  = new VehicleVendorSqLiteRepository(new SqLiteContext());
            var repoMongo   = new VehicleVendorMongoRepository(new VehicleVendorMongoDb());
            var mongoLoader = new MongoLoader(repo, repoMongo);

            mongoLoader.LoadRepository();
            repo.SaveChanges();

            var xmlParser   = new XmlParser(repo);
            var parseResult = xmlParser.ParseDiscounts(@"..\..\..\Discounts.xml", @"..\..\..\Discounts.xsd");
            var xmlLoader   = new XmlLoader(repo, parseResult);

            xmlLoader.LoadRepository();
            repo.SaveChanges();

            var zipExLoader = new ZipExcelLoaderNonCom(repo);

            zipExLoader.LoadRepository();
            repo.SaveChanges();

            var pdfReporter = new PdfReportSQLServerGenerator(repo);

            pdfReporter.GenerateReport();

            var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now);

            xmlReporter.GenerateReport();

            var jsonReporter = new JsonReportSQLServerGenerator(repo);

            jsonReporter.GenerateReport();

            var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql);

            jsonToMySql.WriteJsonsReportsToMySql();

            var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, repoSqLite, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1));

            excelReporter.GenerateReport();
        }
        public static void Main()
        {
            var repo = new VehicleVendorRepository( new IVehicleVendorDbContext[] { new VehicleVendorDbContext() });
            var repoMySql = new VehicleVendorMySqlRepository();
            var repoSqLite = new VehicleVendorSqLiteRepository(new SqLiteContext());
            var repoMongo = new VehicleVendorMongoRepository(new VehicleVendorMongoDb());
            var mongoLoader = new MongoLoader(repo, repoMongo);

            mongoLoader.LoadRepository();
            repo.SaveChanges();

            var xmlParser = new XmlParser(repo);
            var parseResult = xmlParser.ParseDiscounts(@"..\..\..\Discounts.xml", @"..\..\..\Discounts.xsd");
            var xmlLoader = new XmlLoader(repo, parseResult);
            xmlLoader.LoadRepository();
            repo.SaveChanges();

            var zipExLoader = new ZipExcelLoaderNonCom(repo);
            zipExLoader.LoadRepository();
            repo.SaveChanges();

            var pdfReporter = new PdfReportSQLServerGenerator(repo);
            pdfReporter.GenerateReport();

            var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now);
            xmlReporter.GenerateReport();

            var jsonReporter = new JsonReportSQLServerGenerator(repo);
            jsonReporter.GenerateReport();

            var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql);
            jsonToMySql.WriteJsonsReportsToMySql();

            var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, repoSqLite, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1));
            excelReporter.GenerateReport();
        }
示例#3
0
 public void OnLoadExcelZipClick(object sender, RoutedEventArgs e)
 {
     try
     {
         var zipExLoader = new ZipExcelLoaderNonCom(repo);
         zipExLoader.LoadRepository();
         repo.SaveChanges();
         Print("Sales from zipped Excel 2003 files to SQL Server successfuly loaded.");
     }
     catch (Exception ex)
     {
         Print(ex.Message);
     }
 }
        public static void Main()
        {
            using (var repo = new VehicleVendorRepository(
                       new IVehicleVendorDbContext[]
            {
                new VehicleVendorDbContext()
            }))
            {
                var nissanMongoDb = new VehicleVendorMongoDb();
                var mongoLoader   = new MongoLoader(repo, nissanMongoDb);
                Console.Write("Loading MongoDb data to SQL DB... ");
                mongoLoader.LoadRepository();
                repo.SaveChanges();
                Console.WriteLine("Done.");

                var xmlParser = new XmlParser(repo);
                Console.Write("Parsing XML data... ");
                var parseResult = xmlParser.ParseDiscounts(@"..\..\..\Discounts.xml", @"..\..\..\Discounts.xsd");
                var xmlLoader   = new XmlLoader(repo, parseResult);
                Console.WriteLine("Done.");
                Console.Write("Loading XML data to SQL DB... ");
                xmlLoader.LoadRepository();
                repo.SaveChanges();
                Console.WriteLine("Done.");

                var zipExLoader = new ZipExcelLoaderNonCom(repo);
                Console.Write("Loading Excel zipped data... ");
                zipExLoader.LoadRepository();
                repo.SaveChanges();
                Console.WriteLine("Done.");

                var pdfReporter = new PdfReportSQLServerGenerator(repo);
                Console.Write("Generating pdf report... ");
                pdfReporter.GenerateReport();
                Console.WriteLine("Done.");

                var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now);
                Console.Write("Generating xml report... ");
                xmlReporter.GenerateReport();
                Console.WriteLine("Done.");

                var jsonReporter = new JsonReportSQLServerGenerator(repo);
                Console.Write("Generating JSON report... ");
                jsonReporter.GenerateReport();
                Console.WriteLine("Done.");

                using (var repoMySql = new VehicleVendorMySqlRepository())
                {
                    var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql);
                    Console.Write("Loading JSON to MySQL... ");
                    jsonToMySql.WriteJsonsReportsToMySql();
                    Console.WriteLine("Done.");

                    using (var sqliteDb = new SqLiteContext())
                    {
                        var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, sqliteDb, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1));
                        Console.Write("Generating Excel report... ");
                        excelReporter.GenerateReport();
                        Console.WriteLine("Done.");
                    }
                }
            }
        }
示例#5
0
        public static void Main()
        {
            using (var repo = new VehicleVendorRepository(
                new IVehicleVendorDbContext[]
                { 
                    new VehicleVendorDbContext()
                }))
            {
                var nissanMongoDb = new VehicleVendorMongoDb();
                var mongoLoader = new MongoLoader(repo, nissanMongoDb);
                Console.Write("Loading MongoDb data to SQL DB... ");
                mongoLoader.LoadRepository();
                repo.SaveChanges();
                Console.WriteLine("Done.");

                var xmlParser = new XmlParser(repo);
                Console.Write("Parsing XML data... ");
                var parseResult = xmlParser.ParseDiscounts(@"..\..\..\Discounts.xml", @"..\..\..\Discounts.xsd");
                var xmlLoader = new XmlLoader(repo, parseResult);
                Console.WriteLine("Done.");
                Console.Write("Loading XML data to SQL DB... ");
                xmlLoader.LoadRepository();
                repo.SaveChanges();
                Console.WriteLine("Done.");

                var zipExLoader = new ZipExcelLoaderNonCom(repo);
                Console.Write("Loading Excel zipped data... ");
                zipExLoader.LoadRepository();
                repo.SaveChanges();
                Console.WriteLine("Done.");

                var pdfReporter = new PdfReportSQLServerGenerator(repo);
                Console.Write("Generating pdf report... ");
                pdfReporter.GenerateReport();
                Console.WriteLine("Done.");

                var xmlReporter = new XmlReportGenerator(repo, new DateTime(2014, 01, 01), DateTime.Now);
                Console.Write("Generating xml report... ");
                xmlReporter.GenerateReport();
                Console.WriteLine("Done.");

                var jsonReporter = new JsonReportSQLServerGenerator(repo);
                Console.Write("Generating JSON report... ");
                jsonReporter.GenerateReport();
                Console.WriteLine("Done.");

                using (var repoMySql = new VehicleVendorMySqlRepository())
                {
                    var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql);
                    Console.Write("Loading JSON to MySQL... ");
                    jsonToMySql.WriteJsonsReportsToMySql();
                    Console.WriteLine("Done.");

                    using (var sqliteDb = new SqLiteContext())
                    {
                        var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, sqliteDb, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1));
                        Console.Write("Generating Excel report... ");
                        excelReporter.GenerateReport();
                        Console.WriteLine("Done.");
                    }
                }
            }
        }