/// <summary> /// Common image parameters /// </summary> /// <param name="sliderImage"> slider image</param> /// <param name="sqlCommand"> parameter</param> private static void Imageparameters(SliderImageItem sliderImage, SqlCommand sqlCommand) { var parametereSliderCaption = new SqlParameter("@SliderCaption", SqlDbType.NVarChar, 200) { Value = sliderImage.SliderCaption }; sqlCommand.Parameters.Add(parametereSliderCaption); var parametereSliderImageExt = new SqlParameter("@SliderImageExt", SqlDbType.NVarChar, 5) { Value = sliderImage.SliderImageExt }; sqlCommand.Parameters.Add(parametereSliderImageExt); var parametereActive = new SqlParameter("@Active", SqlDbType.Bit, 0) { Value = sliderImage.Active }; sqlCommand.Parameters.Add(parametereActive); var parametereDisplayOrder = new SqlParameter("@DisplayOrder", SqlDbType.Int, 4) { Value = sliderImage.DisplayOrder }; sqlCommand.Parameters.Add(parametereDisplayOrder); }
/// <summary> /// Slider Image Listing - Row Data Bound /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="T:System.GridViewRowEventArgs"/> instance containing the event data.</param> protected void GdSliderImageManager_RowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowType == DataControlRowType.DataRow) { Image thumbImage; SliderImageItem image = (SliderImageItem)e.Row.DataItem; if ((e.Row.RowState == (DataControlRowState.Edit | DataControlRowState.Alternate)) || (e.Row.RowState == DataControlRowState.Edit)) { thumbImage = (Image)e.Row.FindControl("imgSliderImageEdit") as Image; thumbImage.ImageUrl = "/Images/Sliders/" + image.SliderID + "/" + image.SliderImageID + image.SliderImageExt + "?dt=" + DateTime.Now.ToString("ddMMyyyyHHmmss"); } else if (e.Row.RowType == DataControlRowType.DataRow && (e.Row.RowState == DataControlRowState.Normal || e.Row.RowState == DataControlRowState.Alternate)) { thumbImage = (Image)e.Row.FindControl("imgSliderImage") as Image; thumbImage.ImageUrl = "/Images/Sliders/" + image.SliderID + "/" + image.SliderImageID + image.SliderImageExt + "?dt=" + DateTime.Now.ToString("ddMMyyyyHHmmss"); } } }
/// <summary> /// Update Image Detail /// </summary> /// <param name="sliderImage">SliderImageItem Object</param> public void UpdateImageDetail(SliderImageItem sliderImage) { using (var connection = Config.SqlConnectionString) using (var sqlCommand = new SqlCommand("Update rb_sliderImages set SliderCaption=@SliderCaption ,SliderImageExt=@SliderImageExt, UpdatedDate=@UpdatedDate,UpdatedUserName=@UpdatedUserName,Active=@Active,DisplayOrder=@DisplayOrder where SliderImageID=@SliderImageID", connection)) { // Mark the Command as a SPROC sqlCommand.CommandType = CommandType.Text; //// Add Parameters to SPROC var parameterSliderImageID = new SqlParameter("@SliderImageID", SqlDbType.Int, 4) { Value = sliderImage.SliderImageID }; sqlCommand.Parameters.Add(parameterSliderImageID); var parametereUpdatedDate = new SqlParameter("@UpdatedDate", SqlDbType.DateTime) { Value = sliderImage.UpdatedDate }; sqlCommand.Parameters.Add(parametereUpdatedDate); var parametereUpdatedUserName = new SqlParameter("@UpdatedUserName", SqlDbType.VarChar, 500) { Value = sliderImage.UpdatedUserName }; sqlCommand.Parameters.Add(parametereUpdatedUserName); Imageparameters(sliderImage, sqlCommand); var parameterOutput = new SqlParameter(this.Output, SqlDbType.Int); parameterOutput.Direction = ParameterDirection.Output; sqlCommand.Parameters.Add(parameterOutput); connection.Open(); try { sqlCommand.ExecuteNonQuery(); } finally { } } }
/// <summary> /// Save/Update Image Detail /// </summary> /// <param name="sliderImage">Slider Image Object</param> /// <returns>New Slider Image ID</returns> public string SaveImageDetail(SliderImageItem sliderImage) { using (var connection = Config.SqlConnectionString) using (var sqlCommand = new SqlCommand("insert into rb_sliderImages (SliderID,SliderCaption,SliderImageExt,CreatedDate,CreatedUserName,Active,DisplayOrder) OUTPUT INSERTED.SliderImageID values (@SliderID,@SliderCaption,@SliderImageExt,@CreatedDate,@CreatedUserName,@Active,@DisplayOrder)", connection)) { // Mark the Command as a SPROC sqlCommand.CommandType = CommandType.Text; //// Add Parameters to SPROC var parameterSliderID = new SqlParameter("@SliderID", SqlDbType.Int, 4) { Value = sliderImage.SliderID }; sqlCommand.Parameters.Add(parameterSliderID); var parametereCreatedDate = new SqlParameter("@CreatedDate", SqlDbType.DateTime) { Value = sliderImage.CreatedDate }; sqlCommand.Parameters.Add(parametereCreatedDate); var parametereCreatedUserName = new SqlParameter("@CreatedUserName", SqlDbType.VarChar, 500) { Value = sliderImage.CreatedUserName }; sqlCommand.Parameters.Add(parametereCreatedUserName); Imageparameters(sliderImage, sqlCommand); var parameterOutput = new SqlParameter(this.Output, SqlDbType.Int); parameterOutput.Direction = ParameterDirection.Output; sqlCommand.Parameters.Add(parameterOutput); connection.Open(); try { return(sqlCommand.ExecuteScalar().ToString()); } finally { } } }
/// <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(); }