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