public static void MigrateReports(ElectronicStoresSystemDbContext storeContext)
{
var mySqlContext = new ElectronicStoreMySQLFluentModel();
var reports = storeContext.Sales.OrderBy(s => s.Store.StoreName).ToList();
for (int i = 1, len = reports.Count; i < len; i++)
{
var newReport = new Report
{
ReportId = i,
Price = reports[i].Price,
ProductName = reports[i].Product.ProductName,
Quantity = reports[i].Quantity,
StoreName = reports[i].Store.StoreName,
Sum = reports[i].Sum,
};
using (var ctx = new ElectronicStoreMySQLFluentModel())
{
ctx.Add(newReport);
ctx.SaveChanges();
}
}
}
public static List<Report> LoadReports()
{
var ctx = new ElectronicStoreMySQLFluentModel();
using (ctx)
{
return ctx.Reports.ToList();
}
}
public static void SaveReport(Report report)
{
var ctx = new ElectronicStoreMySQLFluentModel();
using (ctx)
{
ctx.Add(report);
ctx.SaveChanges();
}
}
