public static void ImportExprencesFromMSSqlToMySQL(SupermarketChainContext context)
{
using (SupermarketChainMySQL contextMySQL = new SupermarketChainMySQL(MySQL.connectionString))
{
using (var mySqlDBTransaction = contextMySQL.Database.BeginTransaction())
{
try
{
var expencesInMSSQL = context.Expences.ToList();
var counter = 0;
foreach (var expence in expencesInMSSQL)
{
if (expenceExist(expence, contextMySQL))
{
Console.WriteLine("ID:{0}, Time:{1}, is present at the MySQL table and will not be added.", expence.Id, expence.Date);
}
else
{
contextMySQL.Expences.Add(new Model.Expence
{
Amount = expence.Amount,
Date = expence.Date,
VendorId = expence.VendorId
});
Console.WriteLine("ID:{0}, Time:{1} is added to MySQL table.", expence.Id, expence.Date);
counter++;
}
}
contextMySQL.SaveChanges();
mySqlDBTransaction.Commit();
Console.WriteLine("{0} expences added to MySQL database", counter);
}
catch (Exception)
{
mySqlDBTransaction.Rollback();
}
}
}
}
public static void ImportMeasuresFromMSSqlToMySQL(SupermarketChainContext context)
{
using (SupermarketChainMySQL contextMySQL = new SupermarketChainMySQL(MySQL.connectionString))
{
using (var mySqlDBTransaction = contextMySQL.Database.BeginTransaction())
{
try
{
var measuresInMSSQL = context.Measures.ToList();
var counter = 0;
foreach (var measure in measuresInMSSQL)
{
if (contextMySQL.Measures.Where(m => m.MeasureName.Equals(measure.MeasureName)).Any())
{
Console.WriteLine("{0} is present at the MySQL table and will not be added.", measure.MeasureName);
}
else
{
contextMySQL.Measures.Add(new Model.Measure
{
MeasureName = measure.MeasureName
});
Console.WriteLine("{0} is added to MySQL table.", measure.MeasureName);
counter++;
}
}
contextMySQL.SaveChanges();
mySqlDBTransaction.Commit();
Console.WriteLine("{0} measures added to MySQL database", counter);
}
catch (Exception)
{
mySqlDBTransaction.Rollback();
}
}
}
}
public static void ImportSalesReportsFromMSSqlToMySQL(SupermarketChainContext context)
{
using (SupermarketChainMySQL contextMySQL = new SupermarketChainMySQL(MySQL.connectionString))
{
using (var mySqlDBTransaction = contextMySQL.Database.BeginTransaction())
{
try
{
var salesReportsInMSSQL = context.SaleReports.ToList();
var counter = 0;
foreach (var saleReport in salesReportsInMSSQL)
{
if(saleExist(saleReport, contextMySQL))
{
Console.WriteLine("ID:{0}, Time:{1}, is present at the MySQL table and will not be added.", saleReport.Id, saleReport.SaleTime);
}
else
{
contextMySQL.SaleReports.Add(new Model.SaleReport
{
ProductId = saleReport.ProductId,
Quantity = saleReport.Quantity,
SaleTime = saleReport.SaleTime,
VendorId = saleReport.VendorId
});
Console.WriteLine("ID:{0}, Time:{1} is added to MySQL table.", saleReport.Id, saleReport.SaleTime);
counter++;
}
}
contextMySQL.SaveChanges();
mySqlDBTransaction.Commit();
Console.WriteLine("{0} salereports added to MySQL database", counter);
}
catch (Exception e)
{
Console.WriteLine(e.Message);
mySqlDBTransaction.Rollback();
}
}
}
}
public static void ImportProductsFromMSSqlToMySQL(SupermarketChainContext context)
{
using (SupermarketChainMySQL contextMySQL = new SupermarketChainMySQL(MySQL.connectionString))
{
using (var mySqlDBTransaction = contextMySQL.Database.BeginTransaction())
{
try
{
var productsInMSSQL = context.Products.ToList();
var counter = 0;
foreach (var product in productsInMSSQL)
{
if (contextMySQL.Products.Where(p => p.ProductName.Equals(product.ProductName)).Any())
{
Console.WriteLine("{0} is present at the MySQL table and will not be added.", product.ProductName);
}
else
{
contextMySQL.Products.Add(new Model.Product
{
ProductName = product.ProductName,
MeasureID = product.MeasureID,
VendorId = product.VendorId,
Price = product.Price
});
Console.WriteLine("{0} is added to MySQL table.", product.ProductName);
counter++;
}
}
contextMySQL.SaveChanges();
mySqlDBTransaction.Commit();
Console.WriteLine("{0} products added to MySQL database", counter);
}
catch (Exception)
{
mySqlDBTransaction.Rollback();
}
}
}
}
