protected void ButtonUpdate_Click(object sender, EventArgs e) { if (UploadNewImage.HasFile) { string imagePath = "~/images/" + UploadNewImage.FileName; UploadNewImage.SaveAs(Server.MapPath(imagePath).ToString()); SqlCommand cmd = new SqlCommand("UPDATE promotionalDeals SET dealName = '" + NewDealName.Text + "', dealImage = '" + imagePath + "', dealDescription = '" + DealDescription.Text + "' WHERE dealID = " + Request.QueryString["ID"], con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); } else { } }
/// <summary> /// Add new Image into the Slider /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.EventArgs"/> instance containing the event data.</param> protected void BtnAddNew_Click(object sender, EventArgs e) { SliderImageItem currentImage = new SliderImageItem(); currentImage.SliderID = this.SliderID; currentImage.SliderCaption = txtSliderCaptionNew.Text; currentImage.SliderImageExt = Path.GetExtension(UploadNewImage.PostedFile.FileName); currentImage.CreatedDate = DateTime.Now; currentImage.CreatedUserName = Appleseed.Framework.Site.Configuration.PortalSettings.CurrentUser.Identity.UserName; currentImage.Active = this.chkActiveNew.Checked; currentImage.DisplayOrder = Convert.ToInt32(txtDisplayOrderNew.Text) > 0 ? Convert.ToInt32(txtDisplayOrderNew.Text) : 0; var newImageID = this.slider.SaveImageDetail(currentImage); string savepath = Server.MapPath("/Images/Sliders/" + this.SliderID + "/" + newImageID + Path.GetExtension(UploadNewImage.PostedFile.FileName)); UploadNewImage.SaveAs(savepath); this.txtSliderCaptionNew.Text = string.Empty; this.txtDisplayOrderNew.Text = string.Empty; this.chkActiveNew.Checked = false; this.LoadGrid(); }