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