public static void CreateSupplyRecord(Dictionary<int, int> productsInSupplyCart)
{
List<Product> allProducts = db.Products.ToList();
var supplyRecord = new SuppliesRecord();
decimal priceForAll = 0;
foreach (var productInCheck in productsInSupplyCart)
{
Product product = allProducts.FirstOrDefault(p => p.ProductId == productInCheck.Key);
ProductsRecord suppliedProduct = new ProductsRecord { ProductId = productInCheck.Key, Quantity = productInCheck.Value, Price = product.SupplierPrice * productInCheck.Value };
db.AddToProductsRecords(suppliedProduct);
priceForAll += product.Price * productInCheck.Value;
supplyRecord.ProductsRecords.Add(suppliedProduct);
}
DateTime theDate = DateTime.UtcNow;
supplyRecord.TimeOfSupplying = theDate;
supplyRecord.PriceForAll = priceForAll;
db.AddToSuppliesRecords(supplyRecord);
db.SaveChanges();
}
public static void CreateCheck(Dictionary<int, int> productsInCheck)
{
List<Product> allProducts = db.Products.ToList();
var check = new ChecksRecord();
decimal priceForAll = 0;
foreach (var productInCheck in productsInCheck)
{
Product product = allProducts.FirstOrDefault(p => p.ProductId == productInCheck.Key);
ProductsRecord soldProduct = new ProductsRecord { ProductId = productInCheck.Key, Quantity = productInCheck.Value, Price = product.Price * productInCheck.Value };
db.AddToProductsRecords(soldProduct);
priceForAll += product.Price * productInCheck.Value;
check.ProductsRecords.Add(soldProduct);
}
DateTime theDate = DateTime.UtcNow;
check.TimeOfSelling = theDate;
check.PriceForAll = priceForAll;
db.AddToChecksRecords(check);
db.SaveChanges();
}
/// <summary>
/// Deprecated Method for adding a new object to the ProductsRecords EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead.
/// </summary>
public void AddToProductsRecords(ProductsRecord productsRecord)
{
base.AddObject("ProductsRecords", productsRecord);
}
/// <summary>
/// Create a new ProductsRecord object.
/// </summary>
/// <param name="id">Initial value of the Id property.</param>
/// <param name="productId">Initial value of the ProductId property.</param>
/// <param name="quantity">Initial value of the Quantity property.</param>
/// <param name="price">Initial value of the Price property.</param>
public static ProductsRecord CreateProductsRecord(global::System.Int32 id, global::System.Int32 productId, global::System.Int32 quantity, global::System.Decimal price)
{
ProductsRecord productsRecord = new ProductsRecord();
productsRecord.Id = id;
productsRecord.ProductId = productId;
productsRecord.Quantity = quantity;
productsRecord.Price = price;
return productsRecord;
}
