protected void Upload_Click(object sender, EventArgs e) { string pName = Name.Text; string pDescription = Description.Text; int pPrice = Int32.Parse(Price.Text); int pQuantity = Int32.Parse(Quantity.Text); string pImage = Image.FileName.ToString(); Image.SaveAs(Request.PhysicalApplicationPath + "./Images/" + Image.FileName.ToString()); CakeBO cakeBO = new CakeBO() { Name = pName, Description = pDescription, Price = pPrice, Quantity = pQuantity, Image = pImage }; CakeBL cakeBL = new CakeBL(); if (!cakeBL.AddNewCake(cakeBO)) { Response.Redirect("invalid.aspx"); } else { Response.Redirect("add_product.aspx"); } }
public bool AddCake(CakeBO cakeBO) { string sql = "insert into cakes values(@Name,@Description,@Price,@Quantity,@Image)"; SqlConnection cnn = new SqlConnection(strConnection); SqlCommand cmd = new SqlCommand(sql, cnn); cmd.Parameters.AddWithValue("@Name", cakeBO.Name); cmd.Parameters.AddWithValue("@Description", cakeBO.Description); cmd.Parameters.AddWithValue("@Price", cakeBO.Price); cmd.Parameters.AddWithValue("@Quantity", cakeBO.Quantity); cmd.Parameters.AddWithValue("@Image", cakeBO.Image); try { if (cnn.State == ConnectionState.Closed) { cnn.Open(); } return(cmd.ExecuteNonQuery() > 0); } catch (SqlException e) { throw new Exception(e.Message); } }
public bool AddNewCake(CakeBO cakeBO) { CakeDA cakeDA = new CakeDA(); return(cakeDA.AddCake(cakeBO)); }