private static void ImportMongoDbDataInMssql()
{
var clients = FurnitureFactoryMongoDbDAO.GetAllClients();
var products = FurnitureFactoryMongoDbDAO.GetAllProducts();
var materials = FurnitureFactoryMongoDbDAO.GetAllMaterials();
var importer = new FurnitureFactoryMsSqlImporter();
importer.ImportClients(clients);
importer.ImportProducts(products);
importer.ImportMaterials(materials);
}
private static void ImportExcelDataInMssql()
{
var importer = new FurnitureFactoryMsSqlImporter();
string zipFilePath = "../../../../ExcelTables/test.zip";
FileInfo info = new FileInfo(zipFilePath);
ZipFileReader zipReader = ZipFileReader.Create();
zipReader.ReadFile(zipFilePath);
ExcelDataReader excelReader = ExcelDataReader.Create();
excelReader.ReadFile(info.DirectoryName);
for (int i = 0; i < excelReader.ExcelData.Count; i++)
{
importer.ImportOrders(excelReader.ExcelData[i]);
}
}
