private MainController()
{
Database.SetInitializer(new DropCreateDatabaseAlways<SupermarketContext>());
//Database.SetInitializer(new MigrateDatabaseToLatestVersion<SupermarketContext, Configuration>());
this.sQLServerContext = new SupermarketContext();
this.mySqlContext = new SuperMarketEntitiesModel();
this.excelConnection = new OleDbConnection();
this.sqliteContext = new SuperMarketEntities();
}
public void Export(SuperMarketEntities sqliteContext)
{
var query = MongoDbProvider.db.LoadData<MongoDbProductFormat>().AsQueryable();
foreach (var item in query)
{
sqliteContext.Products.Add(new Product()
{
ProductId = item.ProductId,
ProductName = item.ProductName,
VendorName = item.VendorName,
TotalIncomes = item.TotalIncomes
});
}
sqliteContext.SaveChanges();
}
public IList<SqliteExcelFormat> GetDataForExcelFile(
SuperMarketEntities sqliteContext, SupermarketContext sqlServerContext)
{
IList<SqliteExcelFormat> data;
data = sqliteContext.Products.Include("TaxTables.Tax").Select(x => new SqliteExcelFormat
{
Vendor = x.VendorName,
Incomes = x.TotalIncomes,
TaxPercentage = x.TaxTable.Tax,
ProductId = x.ProductId
}).ToList();
foreach (var item in data)
{
//item.Expenses = sqlServerContext.Expenses.Where(x => x.Vendor.VendorName == item.Vendor).Select(x => x.ExpenseValue).First();
var vendorId = sqlServerContext.Products.Where(x => item.ProductId == x.Id).Select(x => x.VendorId).First();
item.Expenses = sqlServerContext.Expenses.Where(x => x.VendorId == vendorId).Select(x => x.ExpenseValue).First();
}
return data;
}
public void Export(
SuperMarketEntities sqliteContext, SupermarketContext sqlServerContext, string fileName)
{
IList<SqliteExcelFormat> data = GetDataForExcelFile(sqliteContext, sqlServerContext);
CreateExcelFile(fileName, data);
}
