private static void ImportProducesFromExcel()
{
var db = new ChemicalsDbContext();
IZipExtractor zipExtractor = new ZipExtractor();
ExcelImporter <Produce> k = new ExcelImporter <Produce>(zipExtractor);
ICollection <Produce> produces = k.ImportModelsDataFromZipFile("../../../Files/Produces.zip", "./tests1");
foreach (var item in produces)
{
db.Produces.Add(item);
}
db.SaveChanges();
}
private static void ImportSalesFromExcel()
{
var db = new ChemicalsDbContext();
IZipExtractor zipExtractor = new ZipExtractor();
ExcelImporter <Sale> k = new ExcelImporter <Sale>(zipExtractor);
ICollection <Sale> sales = k.ImportModelsDataFromZipFile("../../../Files/Sales.zip", "./tests2");
foreach (var item in sales)
{
db.Sales.Add(item);
}
db.SaveChanges();
Console.WriteLine("The data was successfully imported to SQL Server.");
}
private static void ImportSalesFromExcel()
{
var db = new ChemicalsDbContext();
IZipExtractor zipExtractor = new ZipExtractor();
ExcelImporter<Sale> k = new ExcelImporter<Sale>(zipExtractor);
ICollection<Sale> sales = k.ImportModelsDataFromZipFile("../../../Files/Sales.zip", "./tests2");
foreach (var item in sales)
{
db.Sales.Add(item);
}
db.SaveChanges();
Console.WriteLine("The data was successfully imported to SQL Server.");
}
private static void ImportProducesFromExcel()
{
var db = new ChemicalsDbContext();
IZipExtractor zipExtractor = new ZipExtractor();
ExcelImporter<Produce> k = new ExcelImporter<Produce>(zipExtractor);
ICollection<Produce> produces = k.ImportModelsDataFromZipFile("../../../Files/Produces.zip", "./tests1");
foreach (var item in produces)
{
db.Produces.Add(item);
}
db.SaveChanges();
}
