/// 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;
    }
Exemplo n.º 11
0
 /// 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;
 }