public static void MoveDatabase() { using (OldEntitiesModel context = new OldEntitiesModel()) { using (NewEntitiesModel newContext = new NewEntitiesModel()) { foreach (var product in context.Products) { SqlServer.Product newProduct = new SqlServer.Product(); newProduct.Id = product.Id; newProduct.BasePrice = product.BasePrice; newProduct.ProductName = product.ProductName; newContext.Products.Add(newProduct); newContext.SaveChanges(); } foreach (var vendor in context.Vendors) { SqlServer.Vendor newVendor = new SqlServer.Vendor(); newVendor.Id = vendor.Id; newVendor.VendorName = vendor.VendorName; foreach (var product in vendor.Products) { var productToAdd = newContext.Products.Where( p => p.Id.Equals(product.Id)) .FirstOrDefault(); if (productToAdd != null) { newVendor.Products.Add(productToAdd); } } newContext.Vendors.Add(newVendor); newContext.SaveChanges(); } foreach (var measure in context.Measures) { SqlServer.Measure newMeasure = new SqlServer.Measure(); newMeasure.Id = measure.Id; newMeasure.MeasureName = measure.MeasureName; foreach (var product in measure.Products) { var productToAdd = newContext.Products.Where( p => p.Id.Equals(product.Id)) .FirstOrDefault(); if (productToAdd != null) { newMeasure.Products.Add(productToAdd); } } newContext.Measures.Add(newMeasure); newContext.SaveChanges(); } } } }
public static void ParseIntoSqlServer(VendorExpensesEntity entity, NewEntitiesModel context) { MonthlyExpenseReport report = new MonthlyExpenseReport(); report.Date = entity.Date; report.Expenses = entity.Expenses; int reportId = -1; if (context.MonthlyExpenseReports.Count() == 0) { reportId = 0; } else { reportId = context.MonthlyExpenseReports.Max(r => r.Id); } reportId++; report.Id = reportId; var vendor = context.Vendors.Where( s => s.VendorName.Equals(entity.VendorName)) .FirstOrDefault(); if (vendor == null) { vendor = new Vendor(); vendor.VendorName = entity.VendorName; int biggestId = -1; if (context.Vendors.Count() == 0) { biggestId = 0; } else { biggestId = context.Vendors.Max(i => i.Id); } biggestId++; vendor.Id = biggestId; context.Vendors.Add(vendor); context.SaveChanges(); } report.VendorId = vendor.Id; context.MonthlyExpenseReports.Add(report); context.SaveChanges(); }
private static void WriteToDatabase(string supermarketName, string[] currentArguments, NewEntitiesModel context, DateTime date) { Report generatedReport = new Report(); generatedReport.ProductId = int.Parse(currentArguments[0]); generatedReport.Quantity = decimal.Parse(currentArguments[1]); generatedReport.UnitPrice = decimal.Parse(currentArguments[2]); generatedReport.Sum = decimal.Parse(currentArguments[3]); generatedReport.Date = date; int reportId = -1; if (context.Reports.Count() == 0) { reportId = 0; } else { reportId = context.Reports.Max(r => r.Id); } reportId++; generatedReport.Id = reportId; var supermarket = context.Supermarkets.Where( s => s.SupermarketName.Equals(supermarketName)) .FirstOrDefault(); if (supermarket == null) { supermarket = new Supermarket(); supermarket.SupermarketName = supermarketName; int biggestId = -1; if (context.Supermarkets.Count() == 0) { biggestId = 0; } else { biggestId = context.Supermarkets.Max(i => i.Id); } biggestId++; supermarket.Id = biggestId; context.Supermarkets.Add(supermarket); context.SaveChanges(); } generatedReport.SupermarketId = supermarket.Id; context.Reports.Add(generatedReport); context.SaveChanges(); }