Esempio n. 1
0
        public void OnGenerateJSONClick(object sender, RoutedEventArgs e)
        {
            try
            {
                var jsonReporter = new JsonReportSQLServerGenerator(repo);
                jsonReporter.GenerateReport();

                var jsonToMySql = new MySqlDataJsonLoader(repo, repoMySql);
                jsonToMySql.WriteJsonsReportsToMySql();
                Print("Data from SQL to JSON and then to MySQL is successfully transferred.");
            }
            catch (Exception ex)
            {
                Print(ex.Message);
            }
        }
Esempio n. 2
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()
        {
            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.");
                    }
                }
            }
        }