public void OnGenerateExcelClick(object sender, RoutedEventArgs e)
{
try
{
var excelReporter = new ExcelReportsSQLiteGenerator(repoMySql, repoSqLite, new DateTime(2014, 8, 1), new DateTime(2014, 9, 1));
excelReporter.GenerateReport();
Print("Excel 2007 report from SQLite and MySql is completed.");
}
catch (Exception ex)
{
Print(ex.Message);
}
}
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.");
}
}
}
}