private static void AddSaleToDatabase( int rowsCount, DataRowCollection rows, MSSQLContext context, Supermarket supermarket, DateTime saleDate) { const int startRow = 3; for (int i = startRow; i < rowsCount - 1; i++) { string productName = rows[i][1].ToString(); int quantity = int.Parse(rows[i][2].ToString()); decimal price = decimal.Parse(rows[i][3].ToString()); Product product = context.Products.FirstOrDefault(p => p.Name == productName); var sale = new Sale() { Supermarket = supermarket, Product = product, SaleDate = saleDate, SalePrice = price, Quantity = quantity }; context.Sales.Add(sale); context.SaveChanges(); } }
private static void ReplicateSales(IQueryable<Sale> sales, MySQLContext context) { foreach (var sale in sales) { if (!context.Sales.Any(s => s.Supermarket.Name == sale.Supermarket.Name && s.Product.Name == sale.Product.Name && s.SaleDate == sale.SaleDate)) { var newSale = new Sale() { SupermarketId = sale.Supermarket.Id, ProductId = sale.Product.Id, SaleDate = sale.SaleDate, SalePrice = sale.SalePrice, Quantity = sale.Quantity }; context.Sales.Add(newSale); context.SaveChanges(); } } }