static void Main()
{
Database.SetInitializer(new MigrateDatabaseToLatestVersion<SupermarketContext, Configuration>());
var db = new SupermarketContext();
string conStr = "Server=localhost; Port=3306; Database=supermarketdb; Uid=root; Pwd=6okolad; pooling=true";
SupermarketModel mySqlDB = new SupermarketModel(conStr);
db.Database.Delete();
TransferData(mySqlDB, db);
TransferDataConnTable(mySqlDB, db);
db.Database.Connection.Close();
//Unpack data from zip file
ZipDataReader.ExtractData(@"../../../Sample-Sales-Reports.zip", @"../../../Extracted Files");
ExcelDataReader.TransferDataFromExcelToDB(db, "../../../Extracted Files");
Directory.Delete(@"../../../Extracted Files", true);
//Create Pdf File
CreatePdf.AddDataToPdf(db);
//Create XML File
CreateXMLDocument.AddDataToXML(db);
//Save Json files in the file system
CreateJsonDocument.saveJsonFiles(@"../../../Product-Reports", db);
CreateJsonDocument.saveReportsToMongoDB(db);
}
// Copy data from auto-generates MySql classes to code first made classes for MS SQL Database
public static void TransferData(SupermarketModel mySQL, SupermarketContext msSQL)
{
foreach (var measure in mySQL.Measures)
{
var newMeasure = new SupermarketDB.Models.Measure
{
MeasureID = measure.MeasureID,
MeasureName = measure.MeasureName
};
msSQL.Measures.Add(newMeasure);
msSQL.SaveChanges();
}
foreach (var vendor in mySQL.Vendors)
{
var newVendor = new SupermarketDB.Models.Vendor
{
VendorID = vendor.VendorID,
VendorName = vendor.VendorName
};
msSQL.Vendors.Add(newVendor);
msSQL.SaveChanges();
}
}
public static void TransferDataConnTable(SupermarketModel mySQL, SupermarketContext msSQL)
{
foreach (var product in mySQL.Products)
{
var newProduct = new SupermarketDB.Models.Product
{
ProductID = product.ProductID,
VendorID = product.VendorID,
MeasureID = product.MeasureID,
ProductName = product.ProductName,
BasePrice = product.BasePrice
};
msSQL.Products.Add(newProduct);
msSQL.SaveChanges();
}
}