/// <summary> /// Create a new Prices object. /// </summary> /// <param name="id">Initial value of the Id property.</param> /// <param name="datetime">Initial value of the Datetime property.</param> /// <param name="productNumber">Initial value of the ProductNumber property.</param> public static Prices CreatePrices(global::System.Int32 id, global::System.DateTime datetime, global::System.String productNumber) { Prices prices = new Prices(); prices.Id = id; prices.Datetime = datetime; prices.ProductNumber = productNumber; return prices; }
public static void Update(Product item) { try { using (var ctx = new tIMSdbEntities()) { // update product var product = ctx.Products.First(i => i.ProductNumber == item.ProductNumber); product.Description = item.Description; product.Active = item.Active; product.Category = item.Category; // insert new price var price = new Prices { ProductNumber = item.ProductNumber, Wholesale = item.WholesalePrice, Retail = item.RetailPrice, Datetime = DateTime.Now }; ctx.AddToPrices(price); // insert new quantity var quantity = new Quantities { ProductNumber = item.ProductNumber, Count = item.Quantity, Datetime = DateTime.Now }; ctx.Quantities.AddObject(quantity); ctx.SaveChanges(); } } catch(Exception ex) { } }
/// <summary> /// Deprecated Method for adding a new object to the Prices EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToPrices(Prices prices) { base.AddObject("Prices", prices); }