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