public List<ProductDetails> Get_product_list() { List<ProductDetails> products = new List<ProductDetails>(); DBHelper helper = new DBHelper(); DataSet ds = helper.executeSelectQuery(PROCEDURES.GET_PRODUCTS); if (ds != null) { foreach (DataRow row in ds.Tables[0].Rows) { ProductDetails product = new ProductDetails(); product.Prod_Id = row["Prod_Id"].ToString(); product.Prod_Name = row["Prod_Name"].ToString(); product.Prod_Img = row["Prod_Img"].ToString(); product.Brand_Name = row["Brand_Name"].ToString(); product.SubCategory = row["Sub_Cat_Name"].ToString(); //product. = row["Prod_Img"].ToString(); product.Price = Convert.ToSingle(row["Price"]); product.Offer_Price = Convert.ToSingle(row["offer_price"]); product.Purchase_Price = Convert.ToSingle(row["Purchase_Price"]); product.Prod_Quantity = row["packed_quantity"].ToString(); product.SubClassification = row["SubClassification"].ToString(); product.Total_Quantity = Convert.ToInt32(row["Availabe_qty"]); products.Add(product); } } return products; }
public int updateProduct(ProductDetails product) { DBHelper helper = new DBHelper(); SqlParameter[] param = new SqlParameter[11]; param[0] = new SqlParameter(CONSTANT.SUB_CATEGORY_ID, product.SubCategory); param[1] = new SqlParameter(CONSTANT.BRAND_ID, product.Brand_Name); param[2] = new SqlParameter(CONSTANT.PRODUCT_ID, product.Prod_Id); param[3] = new SqlParameter(CONSTANT.PRODUCT_NAME, product.Prod_Name); param[4] = new SqlParameter(CONSTANT.PRODUCT_IMAGE, product.Prod_Img); param[5] = new SqlParameter(CONSTANT.PRICE, product.Price); param[6] = new SqlParameter(CONSTANT.OFFER_PRICE, product.Offer_Price); param[7] = new SqlParameter(CONSTANT.PURCHASE_PRICE, product.Purchase_Price); param[8] = new SqlParameter(CONSTANT.PACKING_QUANITY, product.Prod_Quantity); param[9] = new SqlParameter(CONSTANT.TotalQuantity, product.Total_Quantity); param[10] = new SqlParameter(CONSTANT.SUB_CLASSFICATION_NAME, product.SubClassification); int res = helper.InsertQuery(PROCEDURES.UPDATE_PRODUCTS, param); return res; }
public ActionResult ProdEdit_post(ProductDetails productdetails) { Session["ControllerName"] = "Prod Edit"; if (Session["loginDetails"] != null) { getDdlsForProduct(); ViewBag.DDLBrand = new SelectList(ddlbrand, "Value", "Text").ToList(); //ViewBag.SubCategory = new SelectList(ddlSubCategory, "Value", "Text").ToList(); ProductAdminBLL bll = new ProductAdminBLL(); int res = bll.updateProduct(productdetails); if (res > 0) { return RedirectToAction("ProductList"); } return View(); } else { return RedirectToAction("Error"); } }