public static void WriteToExcel(OpenAccessRepository <SalesReport> repository)
{
FileInfo newFile = new FileInfo(ExcelFilePath);
using (ExcelPackage xlPackage = new ExcelPackage(newFile))
{
var ws = xlPackage.Workbook.Worksheets.Add("Report");
ws.Cells["A1"].Value = "Car Model";
ws.Cells["B1"].Value = "Manufacturer";
ws.Cells["C1"].Value = "Seats";
ws.Cells["D1"].Value = "Dealer";
ws.Cells["E1"].Value = "TotalSum";
ws.Cells["A1:E1"].Style.Font.Bold = true;
int rowCount = 2;
foreach (var sale in StartUp.GetSalesReportsFromMySqlDatabase(repository))
{
ws.Cells["A" + rowCount].Value = sale.CarModel;
ws.Cells["B" + rowCount].Value = sale.Manufacturer;
ws.Cells["C" + rowCount].Value = sale.Seats;
ws.Cells["D" + rowCount].Value = sale.Dealer;
ws.Cells["E" + rowCount].Value = sale.TotalSum;
rowCount++;
}
xlPackage.Save();
}
}
public static void Main(string[] args)
{
var files = ReadJsonFiles();
var dbContext = new FluentModelContext();
var repository = new OpenAccessRepository <SalesReport>(dbContext);
var unitOfWork = new OpenAccessUnitOfWork(dbContext);
ImportToMySqlDatabase(repository, unitOfWork, files);
}
private static void ImportToMySqlDatabase(OpenAccessRepository <SalesReport> salesRepository, OpenAccessUnitOfWork unitOfWork, IEnumerable <SalesReport> readFiles)
{
int count = 0;
foreach (var report in readFiles)
{
salesRepository.Add(report);
if (count % 100 == 0)
{
unitOfWork.Commit();
}
count++;
}
unitOfWork.Commit();
}
public static void Main(string[] args)
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion <WayneCarCorpsContext, Configuration>());
var db = new WayneCarCorpsContext();
db.Database.CreateIfNotExists();
var cars = new MongoDBExtractor <MongoCar>().GetEntitiesCollection("Cars");
var kernel = BootstrapNinject();
var carsImporter = kernel.Get <CarsImporter>();
carsImporter.import(cars);
var xmlImporter = kernel.Get <XmlImporter>();
xmlImporter.Import();
var zipExtractor = kernel.Get <ExcelReader>();
zipExtractor.ExtractZipFiles();
var pdfExporter = kernel.Get <PdfExporter>();
pdfExporter.CreatePdfTable();
var jsonExporter = kernel.Get <JsonWriter>();
jsonExporter.WriteToJson();
var xmlExporter = kernel.Get <XmlReportExporter>();
xmlExporter.GetSalesForEachDealership();
// CHANGE PASSWORD IN CONNECTIONS STRING
FluentModelContext context = new FluentModelContext();
OpenAccessRepository <SalesReport> report = new OpenAccessRepository <SalesReport>(context);
//ExcelWriter.WriteToExcel(report);
//UpdateMongoDB();
}
public static IEnumerable <SalesReport> GetSalesReportsFromMySqlDatabase(OpenAccessRepository <SalesReport> salesRepository)
{
return(salesRepository.All().ToList());
}
