public static void ReadExcel(SalesContext db, SupermarketModel sql)
{
var results =
new ReadExcelReports("../../../Data/Sample-Sales-Reports.zip", "../../../Temp/ExcelReports/").Extract().Read();
foreach (var result in results)
{
foreach (var row in result.Items)
{
var productName = sql.Products.Where(x => x.ID == row.Id).First().ProductName;
var product = db.Products.Where(x => x.Name == productName).First();
var supermarket = db.Supermarkets.Where(x => x.Name == result.Name).FirstOrDefault();
if (supermarket == null)
{
supermarket = new Supermarket();
supermarket.Name = result.Name;
}
db.Records.Add(new Models.MSSQL.Record
{
Quantity = row.Quantity,
UnitPrice = row.UnitPrice,
Product = product,
Date = result.Date,
Supermarket = supermarket
});
db.SaveChanges();
}
}
db.SaveChanges();
Directory.Delete("../../../Temp/", true);
}
public static void PassToSql(
IEnumerable<Sales.Models.Excel.SupermarketData> results,
SalesContext db,
SupermarketModel sql)
{
using (db)
{
foreach (var result in results)
{
foreach (var row in result.Items)
{
var productName = sql.Products.Where(x => x.ID == row.Id).First().ProductName;
var product = db.Products.Where(x => x.Name == productName).First();
var supermarket = db.Supermarkets.Where(x => x.Name == result.Name).FirstOrDefault();
if (supermarket == null)
{
supermarket = new Supermarket();
supermarket.Name = result.Name;
}
db.Records.Add(new Models.MSSQL.Record
{
Quantity = row.Quantity,
UnitPrice = row.UnitPrice,
Product = product,
Date = result.Date,
Supermarket = supermarket
});
db.SaveChanges();
}
}
db.SaveChanges();
}
}