private static void TraverseDirectory(DirectoryInfo directory, ISqlServerDb db)
{
DirectoryInfo[] childDirectories = directory.GetDirectories();
foreach (DirectoryInfo dir in childDirectories)
{
TraverseDirectory(dir, db);
}
FileInfo[] files = directory.GetFiles();
foreach (var file in files)
{
DataTable data = ReadFile(file.FullName);
SalesReport report = new SalesReport();
foreach (DataRow row in data.Rows)
{
Sale sale = CreateSale(row, db);
db.Sales.Add(sale);
sale.SalesReport = report;
sale.SalesReportId = report.Id;
report.Sales.Add(sale);
}
db.SalesReports.Add(report);
db.SaveChanges();
}
}
private void TransferProcessors(IMongoDatabase mongoDatabse, ISqlServerDb sqlServerDatabase)
{
var processorsCollection = mongoDatabse.GetCollection <Processor>("processors");
var mongoProcessors = processorsCollection.Find(b => true).ToList();
var processorsTable = sqlServerDatabase.Processors;
foreach (var processor in mongoProcessors)
{
var newProcessor = this.mssqlModelsFactory
.CreateProcessor(processor.ClockSpeed, processor.CacheMemory);
processorsTable.Add(newProcessor);
}
sqlServerDatabase.SaveChanges();
}
private void TransferBatteries(IMongoDatabase mongoDatabse, ISqlServerDb sqlServerDatabase)
{
var batteriesCollection = mongoDatabse.GetCollection <Battery>("batteries");
var mongoBatteries = batteriesCollection.Find(b => true).ToList();
var batteriesTable = sqlServerDatabase.Batteries;
foreach (var battery in mongoBatteries)
{
var newBattery = this.mssqlModelsFactory
.CreateBattery(battery.Type, battery.Capacity);
batteriesTable.Add(newBattery);
}
sqlServerDatabase.SaveChanges();
}
private void TransferDisplays(IMongoDatabase mongoDatabse, ISqlServerDb sqlServerDatabase)
{
var displaysCollection = mongoDatabse.GetCollection <Display>("displays");
var mongoDisplays = displaysCollection.Find(d => true).ToList();
var displaysTable = sqlServerDatabase.Displays;
foreach (var display in mongoDisplays)
{
var newDisplay = this.mssqlModelsFactory
.CreateDisplay(display.Type, display.Size, display.Resolution);
displaysTable.Add(newDisplay);
}
sqlServerDatabase.SaveChanges();
}
private void TransferMobileDevices(IMongoDatabase mongoDatabse, ISqlServerDb sqlServerDatabase)
{
var devicesCollection = mongoDatabse.GetCollection <MobileDevice>("mobileDevices");
var mongoDevices = devicesCollection.Find(b => true).ToList();
var devicesTable = sqlServerDatabase.MobileDevices;
foreach (var device in mongoDevices)
{
var newDevice = this.mssqlModelsFactory
.CreateMobileDevice(
device.Brand,
device.Model,
device.Display,
device.Battery,
device.Processor);
devicesTable.Add(newDevice);
}
sqlServerDatabase.SaveChanges();
}