/// <summary>
/// Connects to database and saves banner content.
/// </summary>
/// <param name="obj">SageBannerInfo object.</param>
public void SaveBannerContent(SageBannerInfo obj)
{
try
{
List <KeyValuePair <string, object> > param = new List <KeyValuePair <string, object> >();
param.Add(new KeyValuePair <string, object>("@Caption", obj.Caption));
param.Add(new KeyValuePair <string, object>("@ImagePath", obj.ImagePath));
param.Add(new KeyValuePair <string, object>("@ReadMorePage", obj.ReadMorePage));
param.Add(new KeyValuePair <string, object>("@LinkToImage", obj.LinkToImage));
param.Add(new KeyValuePair <string, object>("@UserModuleID", obj.UserModuleID));
param.Add(new KeyValuePair <string, object>("@BannerID", obj.BannerID));
param.Add(new KeyValuePair <string, object>("@ImageID", obj.ImageID));
param.Add(new KeyValuePair <string, object>("@ReadButtonText", obj.ReadButtonText));
param.Add(new KeyValuePair <string, object>("@NavigationImage", obj.NavigationImage));
param.Add(new KeyValuePair <string, object>("@Description", obj.Description));
param.Add(new KeyValuePair <string, object>("@PortalID", obj.PortalID));
param.Add(new KeyValuePair <string, object>("@CultureCode", obj.CultureCode));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_SageBannerSaveBannerContent", param);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// Connects to database and returns SageBannerInfo list for given usermodule, portalID and culture.
/// </summary>
/// <param name="UserModuleID">UserModuleID</param>
/// <param name="PortalID">PortalID</param>
/// <param name="CultureCode">CultureCode</param>
/// <returns>List of SageBannerInfo class containing bannername and bannerid</returns>
public List <SageBannerInfo> LoadBannerOnDropDown(int UserModuleID, int PortalID, string CultureCode)
{
SqlDataReader Reader = null;
try
{
List <KeyValuePair <string, object> > Parameter = new List <KeyValuePair <string, object> >();
Parameter.Add(new KeyValuePair <string, object>("@UserModuleID", UserModuleID));
Parameter.Add(new KeyValuePair <string, object>("@PortalID", PortalID));
Parameter.Add(new KeyValuePair <string, object>("@CultureCode", CultureCode));
SQLHandler sqlH = new SQLHandler();
Reader = sqlH.ExecuteAsDataReader("usp_SageBannerGetAllBanner", Parameter);
List <SageBannerInfo> BannerListForDropDown = new List <SageBannerInfo>();
while (Reader.Read())
{
SageBannerInfo obj = new SageBannerInfo();
obj.BannerID = Convert.ToInt32(Reader["BannerID"]);
obj.BannerName = Convert.ToString(Reader["BannerName"]);
BannerListForDropDown.Add(obj);
}
return(BannerListForDropDown);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (Reader != null)
{
Reader.Close();
}
}
}
private void AddUpdateBanner()
{
SageBannerInfo ObjInfo = new SageBannerInfo();
ObjInfo.UserModuleID = userModuleID;
ObjInfo.PortalID = GetPortalID;
ObjInfo.AddedBy = GetUsername;
ObjInfo.Culture = GetCurrentCultureName;
ObjInfo.BannerID = Int32.Parse(hdnBannerID.Value.Trim());
ObjInfo.BannerSloganTitle = txtSloganTitle.Text;
ObjInfo.BannerSlogan = txtSlogan.Text;
ObjInfo.LinkButtonName = txtLinkBtnName.Text;
ObjInfo.IsActive = chkIsActive.Checked;
if (ddlPageList.SelectedValue != "0")
{
ObjInfo.LinkUrl = GetHostURL + "/" + ddlPageList.SelectedValue + ".aspx";
}
else
{
ObjInfo.LinkUrl = txtContentLinkUrl.Text;
}
SageBannerController objCon = new SageBannerController();
if (ObjInfo.BannerID <= 0)
{
if (fileCtlContentImage.HasFile)
{
ObjInfo.BannerImageName = SaveImage();
objCon.InsertUpdateBanner(ObjInfo);
pnlBannerForm.Visible = false;
pnlBannerTbl.Visible = true;
BindBanner();
ClearForm();
ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/SageBanner/ModuleLocalText", "UpdatedSuccesfully"), "", SageMessageType.Success);
}
else
{
lblErrorMsg.Text = "Required!";
}
}
else
{
ObjInfo.BannerImageName = hdnImageName.Value;
if (fileCtlContentImage.HasFile)
{
ObjInfo.BannerImageName = SaveImage();
}
objCon.InsertUpdateBanner(ObjInfo);
pnlBannerForm.Visible = false;
pnlBannerTbl.Visible = true;
BindBanner();
ClearForm();
ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/SageBanner/ModuleLocalText", "Savedsuccesfully"), "", SageMessageType.Success);
}
}
/// <summary>
/// Connects to database saves banner information.
/// </summary>
/// <param name="objB">SageBannerInfo object.</param>
public void SaveBannerInformation(SageBannerInfo objB)
{
try
{
List <KeyValuePair <string, object> > para = new List <KeyValuePair <string, object> >();
para.Add(new KeyValuePair <string, object>("@BannerName", objB.BannerName));
para.Add(new KeyValuePair <string, object>("@BannerDescription", objB.BannerDescription));
para.Add(new KeyValuePair <string, object>("@UserModuleID", objB.UserModuleID));
para.Add(new KeyValuePair <string, object>("@PortalID", objB.PortalID));
para.Add(new KeyValuePair <string, object>("@CultureCode", objB.CultureCode));
SQLHandler sagesql = new SQLHandler();
sagesql.ExecuteNonQuery("usp_SageBannerSaveBannerInformation", para);
}
catch (Exception ex)
{
throw ex;
}
}
private void EditContent(int ID)
{
SageBannerController objCon = new SageBannerController();
SageBannerInfo objInfo = objCon.GetBannerByID(ID);
txtContentLinkUrl.Text = objInfo.LinkUrl;
txtLinkBtnName.Text = objInfo.LinkButtonName;
txtSloganTitle.Text = objInfo.BannerSloganTitle;
chkIsActive.Checked = objInfo.IsActive;
txtSlogan.Text = objInfo.BannerSlogan;
hdnBannerID.Value = objInfo.BannerID.ToString();
hdnImageName.Value = objInfo.BannerImageName;
imgPreview.Visible = true;
imgPreview.ImageUrl = "~/Modules/SageBanner/images/Thumbnail/small/" + objInfo.BannerImageName;
pnlBannerForm.Visible = true;
pnlBannerTbl.Visible = false;
btnSaveContent.Text = "Update";
}
private void SaveBannerContent(int BannerId, int ImageId)
{
try
{
string fName = fuFileUpload.FileName;
if (fuFileUpload.HasFile)
{
fName = fuFileUpload.FileName;
}
else
{
fName = imgEditBannerImageImage.ImageUrl;
fName = fName.Substring(fName.LastIndexOf('\\') + 1);
}
if (SageFrame.Web.PictureManager.ValidImageExtension(fName))
{
try
{
// Bitmap img = new Bitmap(fuFileUpload.PostedFile.InputStream, false);
}
catch (Exception)
{
ShowMessage("", "The uploaded image is too large in pixel", "", SageMessageType.Error);
return;
}
// bool isEdit = false;
SageBannerInfo obj = new SageBannerInfo();
if (Session["EditImageID"] != null && Session["EditImageID"].ToString() != string.Empty)
{
obj.ImageID = Int32.Parse(Session["EditImageID"].ToString());
if (fuFileUpload.HasFile)
{
obj.ImagePath = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
obj.NavigationImage = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
}
else
{
//isEdit = true;
obj.ImagePath = Convert.ToString(Session["ImageName"]);
obj.NavigationImage = Convert.ToString(Session["ImageName"]);
}
}
else
{
obj.ImageID = 0;
obj.ImagePath = fuFileUpload.FileName.Replace(" ", "_");
obj.NavigationImage = fuFileUpload.FileName.Replace(" ", "_");
}
obj.Caption = string.Empty;
if (rdbReadMorePageType.SelectedItem.Text == "Page")
{
obj.ReadMorePage = ddlPagesLoad.SelectedValue.ToString();
obj.LinkToImage = string.Empty;
}
if (rdbReadMorePageType.SelectedItem.Text == "Web Url")
{
obj.LinkToImage = txtWebUrl.Text;
obj.ReadMorePage = string.Empty;
}
obj.UserModuleID = Int32.Parse(SageUserModuleID);
obj.BannerID = BannerId;
obj.ImageID = ImageId;
obj.ReadButtonText = txtReadButtonText.Text;
obj.Description = txtBannerDescriptionToBeShown.Text.Trim();
obj.PortalID = GetPortalID;
obj.CultureCode = GetCurrentCulture();
string swfExt = System.IO.Path.GetExtension(fuFileUpload.PostedFile.FileName);
if (swfExt == ".swf")
{
if (fuFileUpload.FileContent.Length > 0)
{
string Path = GetUplaodImagePhysicalPath();
string fileName = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
DirectoryInfo dirUploadImage = new DirectoryInfo(Path);
if (dirUploadImage.Exists == false)
{
dirUploadImage.Create();
}
string fileUrl = Path + fileName;
int i = 1;
while (File.Exists(fileUrl))
{
fileName = i + fileName;
fileUrl = Path + i + fileName;
i++;
}
fuFileUpload.PostedFile.SaveAs(fileUrl);
swfFileName = "Modules/Sage_Banner/images/" + fileName;
obj.ImagePath = fileName;
obj.NavigationImage = fileName;
}
}
else
{
string target = Server.MapPath(@"~/Modules/Sage_Banner/images/OriginalImage/");
string thumbLarge = Server.MapPath(@"~/Modules/Sage_Banner/images/ThumbNail/Large/");
string thumbMedium = Server.MapPath(@"~/Modules/Sage_Banner/images/ThumbNail/Medium/");
string thumbSmall = Server.MapPath(@"~/Modules/Sage_Banner/images/ThumbNail/Small/");
string defaultImage = Server.MapPath(@"~/Modules/Sage_Banner/images/ThumbNail/Default/");
System.Drawing.Image.GetThumbnailImageAbort thumbnailImageAbortDelegate = new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
if (fuFileUpload.HasFile)
{
string fileName = Path.GetFileName(fuFileUpload.PostedFile.FileName.Replace(" ", "_"));
int i = 1;
while (File.Exists(target + "/" + fileName))
{
fileName = i + fileName;
i++;
}
fuFileUpload.SaveAs(Path.Combine(target, fileName));
fuFileUpload.SaveAs(Path.Combine(defaultImage, fileName));
string SourcePath = Path.Combine(target, fileName);//target + fileName;
SaveThumbnailImages(SourcePath, 320, thumbSmall, fileName);
SaveThumbnailImages(SourcePath, 768, thumbMedium, fileName);
SaveThumbnailImages(SourcePath, 965, thumbLarge, fileName);
obj.ImagePath = fileName;
obj.NavigationImage = fileName;
}
}
SageBannerController objcont = new SageBannerController();
objcont.SaveBannerContent(obj);
int userModuleID = Int32.Parse(SageUserModuleID);
BannerCacheClear();
ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Sage_Banner/ModuleLocalText", "BannerSavedsuccesfully"), "", SageMessageType.Success);
}
else
{
ShowMessage("Invalid File Extension", "Invalid File Extension", "The File you want to upload is invalid", SageMessageType.Error);
}
}
catch (Exception ex)
{
throw ex;
}
Session["ImageName"] = null;
Session["EditImageID"] = null;
}
/// <summary>
/// Saves banner information.
/// </summary>
/// <param name="objB">SageBannerInfo object</param>
public void SaveBannerInformation(SageBannerInfo objB)
{
SageBannerProvider objBP = new SageBannerProvider();
objBP.SaveBannerInformation(objB);
}
/// <summary>
/// Saves banner content.
/// </summary>
/// <param name="obj">SageBannerInfo object.</param>
public void SaveBannerContent(SageBannerInfo obj)
{
SageBannerProvider objpro = new SageBannerProvider();
objpro.SaveBannerContent(obj);
}
private void SaveBannerContent(int BannerId, int ImageId)
{
try
{
bool isEdit = false;
SageBannerInfo obj = new SageBannerInfo();
if (Session["EditImageID"] != null && Session["EditImageID"].ToString() != string.Empty)
{
obj.ImageID = Int32.Parse(Session["EditImageID"].ToString());
if (fuFileUpload.HasFile)
{
obj.ImagePath = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
obj.NavigationImage = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
}
else
{
isEdit = true;
obj.ImagePath = Convert.ToString(Session["ImageName"]);
obj.NavigationImage = Convert.ToString(Session["ImageName"]);
}
}
else
{
obj.ImageID = 0;
obj.ImagePath = fuFileUpload.FileName.Replace(" ", "_");
obj.NavigationImage = fuFileUpload.FileName.Replace(" ", "_");
}
obj.Caption = string.Empty;
if (rdbReadMorePageType.SelectedItem.Text == "Page")
{
obj.ReadMorePage = ddlPagesLoad.SelectedValue.ToString();
obj.LinkToImage = string.Empty;
}
if (rdbReadMorePageType.SelectedItem.Text == "Web Url")
{
obj.LinkToImage = txtWebUrl.Text;
obj.ReadMorePage = string.Empty;
}
obj.UserModuleID = Int32.Parse(SageUserModuleID);
obj.BannerID = BannerId;
obj.ImageID = ImageId;
obj.ReadButtonText = txtReadButtonText.Text;
obj.Description = txtBannerDescriptionToBeShown.Text.Trim();
obj.PortalID = GetPortalID;
obj.CultureCode = GetCurrentCulture();
string swfExt = System.IO.Path.GetExtension(fuFileUpload.PostedFile.FileName);
if (swfExt == ".swf")
{
if (fuFileUpload.FileContent.Length > 0)
{
string Path = GetUplaodImagePhysicalPath();
string fileName = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
DirectoryInfo dirUploadImage = new DirectoryInfo(Path);
if (dirUploadImage.Exists == false)
{
dirUploadImage.Create();
}
string fileUrl = Path + fileName;
int i = 1;
while (File.Exists(fileUrl))
{
fileName = i + fileName;
fileUrl = Path + i + fileName;
i++;
}
fuFileUpload.PostedFile.SaveAs(fileUrl);
swfFileName = "Modules/Sage_Banner/images/" + fileName;
obj.ImagePath = fileName;
obj.NavigationImage = fileName;
}
}
else
{
string target = Server.MapPath("~/Modules/Sage_Banner/images/OriginalImage");
string CropImageTarget = Server.MapPath("~/Modules/Sage_banner/images/CroppedImages");
string thumbTarget = Server.MapPath("~/Modules/Sage_Banner/images/ThumbNail");
System.Drawing.Image.GetThumbnailImageAbort thumbnailImageAbortDelegate = new System.Drawing.Image.GetThumbnailImageAbort(ThumbnailCallback);
if (fuFileUpload.HasFile)
{
string fileName = fuFileUpload.PostedFile.FileName.Replace(" ", "_");
int i = 1;
while (File.Exists(target + "/" + fileName))
{
fileName = i + fileName;
i++;
}
fuFileUpload.SaveAs(Path.Combine(target, fileName));
fuFileUpload.SaveAs(Path.Combine(CropImageTarget, fileName));
using (Bitmap originalImage = new Bitmap(fuFileUpload.PostedFile.InputStream))
{
using (System.Drawing.Image thumbnail = originalImage.GetThumbnailImage(80, 80, thumbnailImageAbortDelegate, IntPtr.Zero))
{
thumbnail.Save(Path.Combine(thumbTarget, fileName));
}
}
obj.ImagePath = fileName;
obj.NavigationImage = fileName;
}
}
SageBannerController objcont = new SageBannerController();
objcont.SaveBannerContent(obj);
int userModuleID = Int32.Parse(SageUserModuleID);
BannerCacheClear();
}
catch (Exception ex)
{
throw ex;
}
ShowMessage(SageMessageTitle.Information.ToString(), SageMessage.GetSageModuleLocalMessageByVertualPath("Modules/Sage_Banner/ModuleLocalText", "BannerSavedsuccesfully"), "", SageMessageType.Success);
Session["ImageName"] = null;
Session["EditImageID"] = null;
}
