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"));
}
