/// Function Header******************************************************* /// Function Name: BindEvents /// Function Type: Function /// Functionality: used to get bind the events /// Input: /// Output: /// Return Value: /// Note: /// ********************************************************************* private void BindFavoriteList() { BLL.NewsLib oNewsLib = new BLL.NewsLib(); GVFavoriteList.DataSource = oNewsLib.GetFavoriteListByUserName(AppLib.GetLoggedInUserName(), "User"); GVFavoriteList.DataBind(); oNewsLib = null; }
private void BindNewsAnnouncements() { BLL.NewsLib oNewsLib = new BLL.NewsLib(); dlNewsAnnouncments.DataSource = oNewsLib.GetAllNewsAnnouncements(); dlNewsAnnouncments.DataBind(); oNewsLib = null; }
protected void GVNews_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("EditNews")) { Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsInfo = oNewsLib.GetNewsAnnouncementsById(Convert.ToInt32(e.CommandArgument)); if (oNewsInfo != null) { txtHeading.Text = oNewsInfo.StrHeading; txtDescription.Text = oNewsInfo.StrDescription; chkIsHome.Checked = oNewsInfo.ChrIsHomePage.Equals('Y') ? true : false; chkIsActive.Checked = oNewsInfo.ChrIsActive.Equals('Y') ? true : false; txtDirectLink.Text = oNewsInfo.StrDirectLink; if (txtDirectLink.Text.Trim().Equals(string.Empty)) { ViewState["strOldFileName"] = oNewsInfo.StrPDFFilename; ancPrevious.Visible = true; ancPrevious.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsAnnouncementsPDFPath() + oNewsInfo.StrPDFFilename; } ViewState["intNewsAnnouncementsId"] = e.CommandArgument.ToString(); oNewsInfo = null; oNewsLib = null; } } else if (e.CommandName.Equals("DeleteNews")) { BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsLib.DeleteNewsAnnouncements(Convert.ToInt32(e.CommandArgument)); lblMsg.Text = "News & Announcements has been deleted successfully."; oNewsLib = null; ClearControls(); BindNewsAnnouncements(); } else if (e.CommandName.Equals("StatusChanged")) { BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsLib.UpdateNewsAnnouncementsStatus(Convert.ToInt32(e.CommandArgument)); lblMsg.Text = "News & Announcements status has been changed successfully."; oNewsLib = null; ClearControls(); BindNewsAnnouncements(); } }
protected void GVNews_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("EditNews")) { Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsInfo = oNewsLib.GetNewsLettersById(Convert.ToInt32(e.CommandArgument)); if (oNewsInfo != null) { // if (!odataReader.DtCancelOn.ToString().Equals("1/1/1999 12:00:00 AM")) txttitle.Text = oNewsInfo.StrTitle; txtDescription.Text = oNewsInfo.StrDescription; if (!oNewsInfo.StrNewsletterDate.ToString().Equals("1/1/1999 12:00:00 AM")) txtDate.Text = oNewsInfo.StrNewsletterDate.ToShortDateString(); chkIsActive.Checked = oNewsInfo.ChrIsActive.Equals('Y') ? true : false; ViewState["strOldFileName"] = oNewsInfo.StrPDFFilename; ancPrevious.Visible = true; ancPrevious.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsLettersPDFPath() + oNewsInfo.StrPDFFilename; ViewState["intNewsLetterId"] = e.CommandArgument.ToString(); } } else if (e.CommandName.Equals("DeleteNews")) { BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsLib.DeleteNewsletter(Convert.ToInt32(e.CommandArgument)); lblMsg.Text = "Newsletter has been deleted successfully."; oNewsLib = null; ClearControls(); BindNewsAnnouncements(); } else if (e.CommandName.Equals("StatusChanged")) { BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsLib.UpdateNewsletterStatus(Convert.ToInt32(e.CommandArgument)); lblMsg.Text = "Newsletter status has been changed successfully."; oNewsLib = null; ClearControls(); BindNewsAnnouncements(); } }
protected void GVNewsLetter_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("AddToFavorite")) { LinkButton lnkBtnFavorite = (LinkButton)e.CommandSource; Entity.UserInfo oUserInfo = new Entity.UserInfo(); oUserInfo.IntFavoriteTypeId = 0; oUserInfo.IntFavoriteId = 0; if (lnkBtnFavorite.Text == "Remove from Favorite") oUserInfo.IntFavoriteId = Convert.ToInt32(e.CommandArgument); oUserInfo.StrUserId = AppLib.GetLoggedInUserName(); oUserInfo.StrTitle = ""; oUserInfo.StrFavoriteType = "Newsletter"; oUserInfo.DtCreatedOn = DateTime.Now; oUserInfo.IntFavoriteTypeId = Convert.ToInt32(e.CommandArgument); BLL.UserLib oUserLib = new BLL.UserLib(); oUserLib.NewsletterAddToFavorite(oUserInfo); oUserInfo = null; oUserLib = null; BindNewsLetters(); } else if (e.CommandName.Equals("PathNewslettersFile")) { Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); BLL.NewsLib oNewsLib = new BLL.NewsLib(); oNewsInfo = oNewsLib.GetNewsLettersById(Convert.ToInt32(e.CommandArgument)); if (oNewsInfo != null) { GridViewRow row = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer); LinkButton lnkNewslettes = (LinkButton)row.FindControl("lnkNewsletters"); ViewState["strOldFileName"] = oNewsInfo.StrPDFFilename; string Path = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsLettersPDFPath() + oNewsInfo.StrPDFFilename; Response.Write("<script type='text/javascript'>detailedresults=window.open('" + Path + "', 'popUpWindow', 'height=700,width=900,resizable=yes,scrollbars=yes,toolbar=yes,menubar=no,location=no,directories=no, status=yes');</script>"); } } }
private void AddUpdateQuestionnareDetails() { BLL.NewsLib oNewsLib = new BLL.NewsLib(); Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); oNewsInfo.IntNewsLetterId = 0; oNewsInfo.StrTitle = txttitle.Text.Trim(); oNewsInfo.StrDescription = txtDescription.Text.Trim(); if (oNewsInfo.StrDescription.Length > 500) oNewsInfo.StrDescription = oNewsInfo.StrDescription.Substring(0, 490); if (!txtDate.Text.Equals(string.Empty)) oNewsInfo.StrNewsletterDate = Convert.ToDateTime(txtDate.Text); else oNewsInfo.StrNewsletterDate = Convert.ToDateTime("01/01/1999"); oNewsInfo.ChrIsActive = chkIsActive.Checked ? 'Y' : 'N'; oNewsInfo.DtCreatedOn = DateTime.Now; oNewsInfo.StrPDFFilename = string.Empty; if (ViewState["strOldFileName"] != null) { oNewsInfo.StrPDFFilename = ViewState["strOldFileName"].ToString(); } string strpath = string.Empty; try { if (fupPDF.HasFile) { strpath = Request.PhysicalApplicationPath + AppConfig.GetNewsLettersPDFPath(); if (ViewState["strOldFileName"] != null) { if (System.IO.File.Exists(strpath + ViewState["strOldFileName"])) { System.IO.File.Delete(strpath + ViewState["strOldFileName"]); } } string strFileName = DateTime.Now.ToString("MMddyyyyHHmmss"); strFileName = AppLib.UploadCompanyExcelForUserRegRequest(ref fupPDF, strFileName, strpath); oNewsInfo.StrPDFFilename = strFileName; } } catch { } if (ViewState["intNewsLetterId"] != null) { oNewsInfo.IntNewsLetterId = Convert.ToInt32(ViewState["intNewsLetterId"]); if (oNewsLib.UpdateNewsletter(oNewsInfo) > 0) { lblMsg.Text = "Newsletter has been updated successfully."; ViewState["intNewsLetterId"] = null; ViewState["strOldFileName"] = null; ClearControls(); BindNewsAnnouncements(); } else { lblMsg.Text = "Newsletter already exists."; } } else { if (oNewsLib.SaveNewsletter(oNewsInfo) > 0) { lblMsg.Text = "Newsletter has been added successfully."; ClearControls(); BindNewsAnnouncements(); } else { lblMsg.Text = "Newsletter already exists."; } } oNewsInfo = null; oNewsLib = null; }
/// Function Header******************************************************* /// Function Name: BindLibrary /// Function Type: Function /// Functionality: used to bind announcements /// Input: /// Output: /// Return Value: /// Note: /// ********************************************************************* private void BindLibrary() { BLL.NewsLib oNewsLib = new BLL.NewsLib(); GVLibrary.DataSource = oNewsLib.GetUserFavoriteLibrary(AppLib.GetLoggedInUserName(), "User"); GVLibrary.DataBind(); oNewsLib = null; }
private void BindDetails() { if (Request.QueryString["type"] != null && Request.QueryString["id"] != null && Request.QueryString["fid"] != null) { BLL.NewsLib oNewsLib = new BLL.NewsLib(); Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); if (Request.QueryString["type"].ToString().ToLower().Equals("newsletter")) { trNewsletter.Visible = true; oNewsInfo = new Entity.NewsInfo(); oNewsLib = new BLL.NewsLib(); oNewsInfo = oNewsLib.GetNewsLettersById(Convert.ToInt32(Request.QueryString["id"])); if (oNewsInfo != null) { lblNewsletterDescription.Text = oNewsInfo.StrDescription; if (!oNewsInfo.StrNewsletterDate.ToString().Equals("1/1/1999 12:00:00 AM")) lblNewsletterDate.Text = oNewsInfo.StrNewsletterDate.ToShortDateString(); if (!oNewsInfo.StrPDFFilename.Equals("na.pdf")) { ancPrevious.Visible = true; ancPrevious.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsLettersPDFPath() + oNewsInfo.StrPDFFilename; } else { trNewsletterPDF.Visible = false; } } } else if (Request.QueryString["type"].ToString().ToLower().Equals("event")) { trEvent.Visible = true; if (Request.QueryString["id"] != null) { int _intEventId = 0; _intEventId = Convert.ToInt32(Request.QueryString["id"]); Entity.EventInfo oEventInfo = new Entity.EventInfo(); BLL.EventsLib oEventsLib = new BLL.EventsLib(); oEventInfo = oEventsLib.GetEventByEventId(_intEventId); if (oEventInfo != null) { lblEventActivity.Text = oEventInfo.StrActivity; lblEventComments.Text = oEventInfo.StrComments; lblEventDate.Text = oEventInfo.DtEventDate.ToShortDateString(); lblEventLocation.Text = oEventInfo.StrLocation; } oEventsLib = null; oEventInfo = null; } } else if (Request.QueryString["type"].ToString().ToLower().Equals("newsannouncements")) { trNewsAnnouncement.Visible = true; oNewsInfo = new Entity.NewsInfo(); oNewsLib = new BLL.NewsLib(); oNewsInfo = oNewsLib.GetNewsAnnouncementsById(Convert.ToInt32(Request.QueryString["id"])); if (oNewsInfo != null) { lblNewsAnnouncementDescription.Text = oNewsInfo.StrDescription; lblNewsAnnouncementDirectLink.Text = oNewsInfo.StrDirectLink; if (lblNewsAnnouncementDirectLink.Text.Trim().Equals(string.Empty)) { trNewsAnnouncementDirectLink.Visible = false; trNewsAnnouncementPDF.Visible = true; ancPreviousNewsAnnoucment.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetNewsAnnouncementsPDFPath() + oNewsInfo.StrPDFFilename; } else { trNewsAnnouncementDirectLink.Visible = true; trNewsAnnouncementPDF.Visible = false; } oNewsInfo = null; oNewsLib = null; } } else if (Request.QueryString["type"].ToString().ToLower().Equals("library")) { trLibrary.Visible = true; Entity.LibraryInfo oLibraryInfo = new Entity.LibraryInfo(); BLL.LibraryLib oLibraryLib = new BLL.LibraryLib(); oLibraryInfo = oLibraryLib.GetLibraryByLibraryId(Convert.ToInt32(Request.QueryString["id"])); if (oLibraryInfo != null) { lblLibraryDescription.Text = oLibraryInfo.StrDescription; if (!oLibraryInfo.DtLibraryDate.ToString().Equals("1/1/1999 12:00:00 AM")) lblLibraryDate.Text = oLibraryInfo.DtLibraryDate.ToShortDateString(); if (oLibraryInfo.StrLocationType.ToLower().Equals("pdf") || oLibraryInfo.StrLocationType.ToLower().Equals("video")) { trLibraryLink.Visible = false; ancLibraryPDF.Visible = true; ancLibraryPDF.HRef = AppConfig.GetBaseSiteUrl() + AppConfig.GetLibrariesFilePath() + oLibraryInfo.StrLocation; } else { trLibraryPDF.Visible = false; lblLibraryWebsiteLink.Text = oLibraryInfo.StrLocation; } lblLibraryCategoryType.Text = oLibraryInfo.StrLocationType; lblLibraryCategory.Text = oLibraryInfo.StrCategory; oLibraryInfo = null; oLibraryLib = null; } } } }
private void BindFavoriteDetails() { if (Request.QueryString["type"] != null && Request.QueryString["id"] != null && Request.QueryString["fid"] != null) { BLL.NewsLib oNewsLib = new BLL.NewsLib(); Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); oNewsInfo = oNewsLib.GetFavoriteListByFavoriteId(Convert.ToInt32(Request.QueryString["fid"])); if (oNewsInfo != null) txtFavoriteTitle.Text = oNewsInfo.StrTitle; oNewsLib = null; oNewsInfo = null; } }
private void AddUpdateQuestionnareDetails() { if (fupPDF.HasFile) { if (!txtDirectLink.Text.Trim().Equals(string.Empty)) { lblMsg.Text = "You can not Upload or Enter Direct Link simultaneously."; return; } } BLL.NewsLib oNewsLib = new BLL.NewsLib(); Entity.NewsInfo oNewsInfo = new Entity.NewsInfo(); oNewsInfo.IntNewsAnnouncementsId = 0; oNewsInfo.StrHeading = txtHeading.Text.Trim(); oNewsInfo.StrDescription = txtDescription.Text.Trim(); if (oNewsInfo.StrDescription.Length > 500) oNewsInfo.StrDescription = oNewsInfo.StrDescription.Substring(0, 499); oNewsInfo.ChrIsHomePage = chkIsHome.Checked ? 'Y' : 'N'; oNewsInfo.ChrIsActive = chkIsActive.Checked ? 'Y' : 'N'; oNewsInfo.StrDirectLink = string.Empty; oNewsInfo.DtCreatedOn = DateTime.Now; oNewsInfo.StrPDFFilename = string.Empty; if (ViewState["strOldFileName"] != null) oNewsInfo.StrPDFFilename = ViewState["strOldFileName"].ToString(); string strpath = string.Empty; try { if (fupPDF.HasFile) { strpath = Request.PhysicalApplicationPath + AppConfig.GetNewsAnnouncementsPDFPath(); if (ViewState["strOldFileName"] != null) { if (System.IO.File.Exists(strpath + ViewState["strOldFileName"])) System.IO.File.Delete(strpath + ViewState["strOldFileName"]); } string strFileName = DateTime.Now.ToString("MMddyyyyHHmmss"); strFileName = AppLib.UploadCompanyExcelForUserRegRequest(ref fupPDF, strFileName, strpath); oNewsInfo.StrPDFFilename = strFileName; } else { oNewsInfo.StrDirectLink = txtDirectLink.Text.Trim(); } } catch { //lblMsg.Text = "Invalid file/Content. Please download the template and fill the proper details."; } if (ViewState["intNewsAnnouncementsId"] != null) { oNewsInfo.IntNewsAnnouncementsId = Convert.ToInt32(ViewState["intNewsAnnouncementsId"]); if (oNewsLib.UpdateNewsAnnouncements(oNewsInfo) > 0) { lblMsg.Text = "News & Announcements has been updated successfully."; ViewState["intNewsAnnouncementsId"] = null; ViewState["strOldFileName"] = null; ClearControls(); BindNewsAnnouncements(); } else { lblMsg.Text = "News & Announcements already exists."; } } else { if (oNewsLib.SaveNewsAnnouncements(oNewsInfo) > 0) { lblMsg.Text = "News & Announcements has been added successfully."; ClearControls(); BindNewsAnnouncements(); } else { lblMsg.Text = "News & Announcements already exists."; } } oNewsInfo = null; oNewsLib = null; }
/// Function Header******************************************************* /// Function Name: BindAnnouncements /// Function Type: Function /// Functionality: used to bind announcements /// Input: /// Output: /// Return Value: /// Note: /// ********************************************************************* private void BindEvents() { BLL.NewsLib oNewsLib = new BLL.NewsLib(); /* GVEvents.DataSource = oNewsLib.GetUserFavoriteEvents(AppLib.GetLoggedInUserName(), "User"); GVEvents.DataBind();*/ oNewsLib = null; }
/// Function Header******************************************************* /// Function Name: BindNewsLetters /// Function Type: Function /// Functionality: used to bind newsletter /// Input: /// Output: /// Return Value: /// Note: /// ********************************************************************* private void BindNewsLetters() { BLL.NewsLib oNewsLib = new BLL.NewsLib(); GVNewsLetter.DataSource = oNewsLib.GetUserFavoriteNewsLetters(AppLib.GetLoggedInUserName(), "User"); GVNewsLetter.DataBind(); oNewsLib = null; }