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 void SaveReport(Report report)
{
var ctx = new ElectronicStoreMySQLFluentModel();
using (ctx)
{
ctx.Add(report);
ctx.SaveChanges();
}
}
private static void createNode(Report report, XmlTextWriter writer)
{
writer.WriteStartElement("Product");
writer.WriteStartElement("Report-id");
writer.WriteString(report.ReportId.ToString());
writer.WriteEndElement();
writer.WriteStartElement("Product-Name");
writer.WriteString(report.ProductName);
writer.WriteEndElement();
writer.WriteStartElement("Store-Name");
writer.WriteString(report.StoreName);
writer.WriteEndElement();
writer.WriteStartElement("Quantity");
writer.WriteString(report.Quantity.ToString());
writer.WriteEndElement();
writer.WriteStartElement("Price");
writer.WriteString(report.Price.ToString());
writer.WriteEndElement();
writer.WriteStartElement("Sum");
writer.WriteString(report.Sum.ToString());
writer.WriteEndElement();
writer.WriteEndElement();
}