protected void InsertProduct(object sender, EventArgs e) { if (!string.IsNullOrEmpty(txtProductNumber.Text)) { decimal wholesalePrice = 0.0m; decimal retailPrice = 0.0m; decimal.TryParse(txtWholesalePrice.Text, out wholesalePrice); decimal.TryParse(txtRetailPrice.Text, out retailPrice); int quantity = 0; int.TryParse(txtQuantity.Text, out quantity); int category = 0; int.TryParse(ddlCategory.SelectedValue, out category); Product product = new Product() { ProductNumber = txtProductNumber.Text, Category = category, Description = txtDescription.Text, WholesalePrice = wholesalePrice, RetailPrice = retailPrice, Quantity = quantity, Active = chkActive.Checked }; Product.Insert(product); ClearForm(); LoadProducts(); } }
public static DataSet GetPriceHistory(Product item) { return DB.ExecuteStoredProcedure("sp_Product_GetPriceHistory" , new SqlParameter("ProductNumber", item.ProductNumber) ); }
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) { } }
public static void Insert(Product item) { try { DB.ExecuteStoredProcedure("sp_Product_Insert" , new SqlParameter("ProductNumber", item.ProductNumber) , new SqlParameter("Category", item.Category) , new SqlParameter("Active", item.Active) , new SqlParameter("WholesalePrice", item.WholesalePrice) , new SqlParameter("RetailPrice", item.RetailPrice) , new SqlParameter("Description", item.Description) , new SqlParameter("Quantity", item.Quantity) ); } catch (Exception ex) { string e = ex.ToString(); } }