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(); }