public ActionResult EditA(Adminproductlist productlist, HttpPostedFileBase file) { if (Session["admin"] == null) { return(RedirectToAction("adminlogin")); } string pic = null; if (file != null) { pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/ProductImg/"), pic); file.SaveAs(path); productlist.ProductImage = pic; } else { pic = productlist.ProductImage; } using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "UPDATE Product SET CategoryId=@CategoryId,SubCategoryName=@SubCategoryName,ProductName=@ProductName,ProductDescription=@ProductDescription," + "ProductQuantity=@ProductQuantity,ProductPrice=@ProductPrice,OldPrice=@OldPrice,ProductImage=@ProductImage,Avilable=@Avilable,ProductColor=@ProductColor,Discount=@Discount," + "Tag=@Tag,ProductSize=@ProductSize,BrandName=@BrandName where ProductId = @ProductId "; SqlCommand sqlCmd = new SqlCommand(query, sqlcon); sqlCmd.Parameters.AddWithValue("@ProductId", productlist.ProductId.ToString()); sqlCmd.Parameters.AddWithValue("@CategoryId", productlist.CategoryId.ToString()); sqlCmd.Parameters.AddWithValue("@SubCategoryName", productlist.SubCategoryName.ToString()); sqlCmd.Parameters.AddWithValue("@ProductName", productlist.ProductName.ToString()); sqlCmd.Parameters.AddWithValue("@ProductDescription", productlist.Descriptions.ToString()); sqlCmd.Parameters.AddWithValue("@ProductQuantity", productlist.ProductQuantity.ToString()); sqlCmd.Parameters.AddWithValue("@ProductPrice", productlist.ProductPrice.ToString()); sqlCmd.Parameters.AddWithValue("@OldPrice", productlist.OldPrice.ToString()); sqlCmd.Parameters.AddWithValue("@ProductImage", pic); sqlCmd.Parameters.AddWithValue("@Avilable", productlist.avaiable.ToString()); sqlCmd.Parameters.AddWithValue("@ProductColor", productlist.ProductColor.ToString()); sqlCmd.Parameters.AddWithValue("@Discount", productlist.discount.ToString()); sqlCmd.Parameters.AddWithValue("@Tag", productlist.Taglist.ToString()); sqlCmd.Parameters.AddWithValue("@ProductSize", productlist.ProductSize.ToString()); sqlCmd.Parameters.AddWithValue("@BrandName", productlist.BrandName.ToString()); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("MyProducts")); }
public ActionResult Edit(int ProductId) { if (Session["admin"] == null) { return(RedirectToAction("adminlogin")); } ViewBag.CategoryList = GetCategory(); Adminproductlist productlist = new Adminproductlist(); DataTable dtblProduct = new DataTable(); using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = $"Select * from Product where ProductId = @ProductId"; SqlDataAdapter sqlDa = new SqlDataAdapter(query, sqlcon); sqlDa.SelectCommand.Parameters.AddWithValue("@ProductId", ProductId); sqlDa.Fill(dtblProduct); } if (dtblProduct.Rows.Count == 1) { productlist.ProductId = Convert.ToInt32(dtblProduct.Rows[0][0].ToString()); productlist.CategoryId = Convert.ToInt32(dtblProduct.Rows[0][1].ToString()); productlist.SubCategoryName = dtblProduct.Rows[0][2].ToString(); productlist.ProductName = dtblProduct.Rows[0][3].ToString(); productlist.Descriptions = dtblProduct.Rows[0][4].ToString(); productlist.ProductQuantity = Convert.ToInt32(dtblProduct.Rows[0][5].ToString()); productlist.ProductPrice = Convert.ToInt32(dtblProduct.Rows[0][6].ToString()); productlist.OldPrice = Convert.ToInt32(dtblProduct.Rows[0][7].ToString()); productlist.ProductImage = dtblProduct.Rows[0][8].ToString(); productlist.avaiable = (dtblProduct.Rows[0][9]).ToString(); productlist.ProductColor = dtblProduct.Rows[0][10].ToString(); productlist.discount = dtblProduct.Rows[0][11].ToString(); productlist.Taglist = dtblProduct.Rows[0][12].ToString(); productlist.BrandName = dtblProduct.Rows[0][13].ToString(); return(View(productlist)); } else { return(RedirectToAction("MyProducts")); } }
public ActionResult Create(Adminproductlist productlist, HttpPostedFileBase file) { if (Session["admin"] == null) { return(RedirectToAction("adminlogin")); } string pic = null; if (file != null) { pic = System.IO.Path.GetFileName(file.FileName); string path = System.IO.Path.Combine(Server.MapPath("~/ProductImg/"), pic); file.SaveAs(path); } using (SqlConnection sqlcon = new SqlConnection(connectionString)) { sqlcon.Open(); string query = "Insert into Product Values(@CategoryId,@SubCategoryName,@ProductName,@ProductDescription," + "@ProductQuantity,@ProductPrice,@OldPrice,@ProductImage,@Avilable,@ProductColor,@Discount,@Tag,@ProductSize,@BrandName) "; SqlCommand sqlCmd = new SqlCommand(query, sqlcon); sqlCmd.Parameters.AddWithValue("@CategoryId", productlist.CategoryId); sqlCmd.Parameters.AddWithValue("@SubCategoryName", productlist.SubCategoryName); sqlCmd.Parameters.AddWithValue("@ProductName", productlist.ProductName); sqlCmd.Parameters.AddWithValue("@ProductDescription", productlist.Descriptions); sqlCmd.Parameters.AddWithValue("@ProductQuantity", productlist.ProductQuantity); sqlCmd.Parameters.AddWithValue("@ProductPrice", productlist.ProductPrice); sqlCmd.Parameters.AddWithValue("@OldPrice", productlist.OldPrice); sqlCmd.Parameters.AddWithValue("@ProductImage", pic); sqlCmd.Parameters.AddWithValue("@Avilable", productlist.avaiable); sqlCmd.Parameters.AddWithValue("@ProductColor", productlist.ProductColor); sqlCmd.Parameters.AddWithValue("@Discount", productlist.discount); sqlCmd.Parameters.AddWithValue("@Tag", productlist.Taglist); sqlCmd.Parameters.AddWithValue("@ProductSize", productlist.ProductSize); sqlCmd.Parameters.AddWithValue("@BrandName", productlist.BrandName); sqlCmd.ExecuteNonQuery(); } return(RedirectToAction("MyProducts")); }