private void button8_Click(object sender, RoutedEventArgs e)
{
ComputersFactoryContext context = new ComputersFactoryContext();
var rootNode = XMLHandler.ReadXMLFile("../../../../XMLFile/Manufacturers.xml");
MongoDBHanlder mongoDbHandler = new MongoDBHanlder("ScrewdriverDB");
XMLHandler.TransferXMLToSQLServer(context, rootNode);
XMLHandler.TransferXMLToMongoDB(mongoDbHandler, rootNode);
}
public static void Task5()
{
ComputersFactoryContext context = new ComputersFactoryContext();
var rootNode = XMLHandler.ReadXMLFile("../../../../XMLFile/Manufacturers.xml");
MongoDBHanlder mongoDbHandler = new MongoDBHanlder("ScrewdriverDB");
XMLHandler.TransferXMLToSQLServer(context, rootNode);
XMLHandler.TransferXMLToMongoDB(mongoDbHandler, rootNode);
}
public static void Task1()
{
//Button - Create Database
Database.SetInitializer(new MigrateDatabaseToLatestVersion <ComputersFactoryContext, Configuration>());
var context = new ComputersFactoryContext();
context.Database.CreateIfNotExists();
//Button - Extract from Zip
ZipHanlder.ExtractExcelFiles(@"..\..\..\..\Excel\Excel.zip");
//Button - Load Data from MongoDB to MSSQL
var mongo = new MongoDBHanlder("ScrewdriverDB");
mongo.TransferToMSSQL().Wait();
//Button - Load data from Excel to MSSQL
ExcelHandler.TransferAllData();
}
private async void LoadFromMongoDB_button(object sender, RoutedEventArgs e)
{
var mongo = new MongoDBHanlder("ScrewdriverDB");
await mongo.TransferToMSSQL();
}
