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