public void updateProductPrice(ProductInBag Product) { OleDbConnection myConn = new OleDbConnection(Connstring.getConnectionString()); OleDbCommand myCmd; OleDbDataAdapter myDataAdapter = new OleDbDataAdapter(); try { myCmd = new OleDbCommand("UpdateUnitPrice", myConn); myCmd.CommandType = CommandType.StoredProcedure; OleDbParameter objParam; objParam = myCmd.Parameters.Add("@UnitPrice", OleDbType.Decimal); objParam.Direction = ParameterDirection.Input; objParam.Value = Product.Price; objParam = myCmd.Parameters.Add("@ProductID", OleDbType.Integer); objParam.Direction = ParameterDirection.Input; objParam.Value = Product.ProdID; myConn.Open(); myCmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } finally { myConn.Close(); } }
public ProductInBag(ProductInBag product) { this.mPrice = product.Price; this.mProdID = product.ProdID; this.mProdName = product.ProdName; //this.ProductIndex = p.ProductIndex; this.mQuantity = product.Quantity; }
public void DeleteProduct(ProductInBag inProduct) { //מבטל מוצר מהסל int index = SearchProduct(inProduct.ProdID); if (index != -1) { mProducts.RemoveAt(index); } }
public void UpdateProduct(ProductInBag inProduct) { //מעדכן כמות של מוצר בסל int index = SearchProduct(inProduct.ProdID); if (index != -1) { ((ProductInBag)mProducts[index]).Quantity = inProduct.Quantity; } }
protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e) { mShoppingBag = (ShoppingBag)Session["mShoppingBag"]; ProductInBag product = new ProductInBag(); GridViewRow row = GridView2.Rows[e.RowIndex]; product.ProdID = int.Parse(row.Cells[0].Text); mShoppingBag.DeleteProduct(product); Session["mShoppingBag"] = mShoppingBag; GridView2.EditIndex = -1; populate_GridView2(); }
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e) { mShoppingBag = (ShoppingBag)Session["mShoppingBag"]; ProductInBag product = new ProductInBag(); GridViewRow row = GridView2.Rows[e.RowIndex]; product.ProdID = int.Parse(row.Cells[0].Text); product.Quantity = short.Parse(((TextBox)row.Cells[2].Controls[0]).Text); mShoppingBag.UpdateProduct(product); Session["mShoppingBag"] = mShoppingBag; GridView2.EditIndex = -1; populate_GridView2(); }
// Adds a product to the products list. // returns the result of the inserting action (true - everything was alright). public void AddProduct(ProductInBag inProduct) { //מוסיף מוצר לסל .אם קיים כבר בסל מעלה את הכמות ב1 int index = SearchProduct(inProduct.ProdID); if (index == -1) { mProducts.Add(inProduct); } else { ((ProductInBag)mProducts[index]).Quantity++; } }
protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "AddProduct") { int index = Convert.ToInt32(e.CommandArgument); GridViewRow row = GridView1.Rows[index]; string productID = row.Cells[0].Text; string prodactName = row.Cells[1].Text; string price = row.Cells[2].Text; ProductInBag newProduct = new ProductInBag(int.Parse(productID), prodactName, decimal.Parse(price), 1); mShoppingBag.AddProduct(newProduct); Button1.Visible = true; Page.Session["mShoppingBag"] = mShoppingBag; populate_GridView2(); } }
public void updateProductPrice(ProductInBag Product) { ProductService product = new ProductService(); product.updateProductPrice(Product); }