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