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