protected void Save_Click(object sender, EventArgs e)
{
try
{
string path_db = "";
string path_server = Request.PhysicalApplicationPath + "ProductImages/";
if (!Directory.Exists(path_server))
{
Directory.CreateDirectory(path_server);
}
string [] arr = { ".png", ".gif", ".jpg", ".bmp" };
if (fU.HasFile)
{
path_db = "~/ProductImages/" + fU.FileName;
string type = Path.GetExtension(fU.FileName);
if (!arr.Contains(type))
{
lblMessage.Text = "File not allow Extension";
return;
}
fU.SaveAs(path_server + fU.FileName);
}
else
{
path_db = "~/ProductImages/nologo.png";
}
Entity = new Ecommers.Entity.Product(int.Parse(txtid.Text), txtname.Text, decimal.Parse(txtprice.Text), int.Parse(txtQuity.Text), path_db, CheckBox1.Checked, int.Parse(DropCatName.SelectedItem.Value), int.Parse(Session["id"].ToString()));
if (BLProduct.Add(Entity) > 0)
{
lblMessage.Text = "Data Was Saved....";
}
else
{
lblMessage.Text = "Data Wasnot Saved ....";
}
}
catch (Exception ex) { }
finally
{
FillGrid();
GetID();
}
}
public int Rmove(Ecommers.Entity.Product product)
{
int result = 0;
string sql = "delete from Product where ProductID=@ProductID and SupplerID=@SupplerID";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ProductID", product.ProductID);
cmd.Parameters.AddWithValue("@SupplerID", product.SupplerID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
public int Edit(Ecommers.Entity.Product product)
{
int result = 0;
string sql = "update Product set ProductName=@ProductName,ProductPrice=@ProductPrice,ProductQuantity=@ProductQuantity,CategoryID=@CategoryID where ProductID=@ProductID and SupplerID=@SupplerID ";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ProductID", product.ProductID);
cmd.Parameters.AddWithValue("@ProductName", product.ProductName);
cmd.Parameters.AddWithValue("@ProductPrice", product.ProductPrice);
cmd.Parameters.AddWithValue("@ProductQuantity", product.ProductQuantity);
// cmd.Parameters.AddWithValue("@ProductPicture", product.ProductPicture);
cmd.Parameters.AddWithValue("@CategoryID", product.CategoryID);
cmd.Parameters.AddWithValue("@SupplerID", product.SupplerID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
public int Add(Ecommers.Entity.Product product)
{
int result = 0;
string sql = "insert into Product (ProductID,ProductName,ProductPrice,ProductQuantity,ProductPicture,IsAvilable,CategoryID,SupplerID) values (@ProductID,@ProductName,@ProductPrice,@ProductQuantity,@ProductPicture,@IsAvilable,@CategoryID,@SupplerID)";
SqlCommand cmd = new SqlCommand(sql, DBC.conn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@ProductID", product.ProductID);
cmd.Parameters.AddWithValue("@ProductName", product.ProductName);
cmd.Parameters.AddWithValue("@ProductPrice", product.ProductPrice);
cmd.Parameters.AddWithValue("@ProductQuantity", product.ProductQuantity);
cmd.Parameters.AddWithValue("@ProductPicture", product.ProductPicture);
cmd.Parameters.AddWithValue("@IsAvilable", product.IsAvilable);
cmd.Parameters.AddWithValue("@CategoryID", product.CategoryID);
cmd.Parameters.AddWithValue("@SupplerID", product.SupplerID);
DBC.conn.Open();
result = cmd.ExecuteNonQuery();
DBC.conn.Close();
return(result);
}
