private static void ExportReportsToExcel()
{
using (var dbContext = new FluentModelContent())
{
var reports = dbContext.Reports.ToList();
var excelExporter = new ExcelExporter <Report>();
excelExporter.ExportDataModelsCollectionToExcelFile("../../", "report", "someName", reports);
}
Console.WriteLine("The Excel table was successfully writen.");
}
private static void ExportDataFromJsonReportsToMySql()
{
using (var dbContext = new FluentModelContent())
{
var reports = JSONReportGenerator.ImportProductsInfo("../../../Reports/");
foreach (var item in reports)
{
dbContext.Add(item);
}
dbContext.SaveChanges();
}
Console.WriteLine("The reports was successfully loaded in MySql.");
}
private static void ExportReportsToExcel()
{
using (var dbContext = new FluentModelContent())
{
var reports = dbContext.Reports.ToList();
var excelExporter = new ExcelExporter<Report>();
excelExporter.ExportDataModelsCollectionToExcelFile("../../", "report", "someName", reports);
}
Console.WriteLine("The Excel table was successfully writen.");
}
private static void ExportDataFromJsonReportsToMySql()
{
using (var dbContext = new FluentModelContent())
{
var reports = JSONReportGenerator.ImportProductsInfo("../../../Reports/");
foreach (var item in reports)
{
dbContext.Add(item);
}
dbContext.SaveChanges();
}
Console.WriteLine("The reports was successfully loaded in MySql.");
}
