protected void GVEvents_RowCommand(object sender, GridViewCommandEventArgs e)
 {
     if (e.CommandName.Equals("DeleteNews"))
     {
         BLL.EventsLib oEventsLib = new BLL.EventsLib();
         oEventsLib.DeleteEventDetails(Convert.ToInt32(e.CommandArgument));
         lblMsg.Text = "Event has been deleted successfully.";
         oEventsLib = null;
         BindEvents();
     }
     else if (e.CommandName.Equals("StatusChanged"))
     {
         BLL.EventsLib oEventsLib = new BLL.EventsLib();
         oEventsLib.ActivateDeactivateEvent(Convert.ToInt32(e.CommandArgument));
         lblMsg.Text = "Event status has been changed successfully.";
         oEventsLib = null;
         BindEvents();
     }
     else if (e.CommandName.Equals("AppDisStatusChanged"))
     {
         BLL.EventsLib oEventsLib = new BLL.EventsLib();
         oEventsLib.ApproveDisapproveEvent(Convert.ToInt32(e.CommandArgument));
         lblMsg.Text = "Event status has been changed successfully.";
         oEventsLib = null;
         BindEvents();
     }
 }
    private void AddUpdateEventDetails()
    {
        BLL.EventsLib oEventsLib = new BLL.EventsLib();
        Entity.EventInfo oEventInfo = new Entity.EventInfo();
        oEventInfo.IntEventsId = 0;
        oEventInfo.StrUserName = AppLib.GetLoggedInUserName();
        oEventInfo.DtEventDate = Convert.ToDateTime(txtDate.Text);
        oEventInfo.StrActivity = txtActivity.Text.Trim();
        oEventInfo.StrLocation = txtLocation.Text.Trim();
        oEventInfo.StrComments = txtComments.Text.Trim();

        if (oEventInfo.StrComments.Length > 200)
            oEventInfo.StrComments = oEventInfo.StrComments.Substring(0, 199);

        oEventInfo.ChrIsActive = Convert.ToChar(rdoIsActive.SelectedValue);
        oEventInfo.ChrStatus = Convert.ToChar(rdoApproved.SelectedValue);

        oEventInfo.DtCreatedOn = DateTime.Now;
        oEventInfo.ChrIsDeleted = 'N';
        if (Request.QueryString["id"] != null)
        {
            oEventInfo.IntEventsId = Convert.ToInt32(Request.QueryString["id"]);
            if (oEventsLib.UpdateEventDetails(oEventInfo) > 0)
            {
                oEventsLib = null;
                oEventInfo = null;
                Response.Redirect(AppConfig.GetBaseSiteUrl() + "BackOffice/ManageEvents.aspx?msg=up");
            }
            else
            {
                lblMsg.Text = "Event already exists.";
                return;
            }
        }
        else
        {
            if (oEventsLib.SaveEventDetails(oEventInfo) > 0)
            {
                oEventsLib = null;
                oEventInfo = null;
                Response.Redirect(AppConfig.GetBaseSiteUrl() + "BackOffice/ManageEvents.aspx?msg=ins");
            }
            else
            {
                lblMsg.Text = "Event already exists.";
                return;
            }
        }
        oEventInfo = null;
        oEventsLib = null;
    }
    private void AddUpdateEventDetails()
    {
        BLL.EventsLib oEventsLib = new BLL.EventsLib();
        Entity.EventInfo oEventInfo = new Entity.EventInfo();
        oEventInfo.IntEventsId = 0;
        oEventInfo.StrUserName = AppLib.GetLoggedInUserName();
        oEventInfo.DtEventDate = Convert.ToDateTime(txtDate.Text);
        oEventInfo.StrActivity = txtActivity.Text.Trim();
        oEventInfo.StrLocation = txtLocation.Text.Trim();
        oEventInfo.StrComments = txtComments.Text.Trim();

        oEventInfo.ChrIsActive = 'Y';
        oEventInfo.ChrStatus = 'D';
        oEventInfo.ChrIsDeleted = 'N';

        oEventInfo.DtCreatedOn = DateTime.Now;

        if (ViewState["intEventId"] != null)
        {
            oEventInfo.IntEventsId = Convert.ToInt32(ViewState["intEventId"]);
            if (oEventsLib.UpdateEventDetails(oEventInfo) > 0)
            {
                lblMsg.Text = "Event has been updated successfully.";
                ViewState["intEventId"] = null;
                ClearControls();
                BindEvents();
            }
            else
            {
                lblMsg.Text = "Event already exists.";
                return;
            }
        }
        else
        {
            if (oEventsLib.SaveEventDetails(oEventInfo) > 0)
            {
                lblMsg.Text = "Event has been added successfully.";
                ClearControls();
                BindEvents();
            }
            else
            {
                lblMsg.Text = "Event already exists.";
                return;
            }
        }
        oEventInfo = null;
        oEventsLib = null;
    }
    protected void GVEvents_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        if (e.CommandName.Equals("EditNews"))
        {
            Entity.EventInfo oEventInfo = new Entity.EventInfo();
            BLL.EventsLib oEventsLib = new BLL.EventsLib();
            oEventInfo = oEventsLib.GetEventByEventId(Convert.ToInt32(e.CommandArgument));
            if (oEventInfo != null)
            {
                ViewState["intEventId"] = e.CommandArgument.ToString();
                txtActivity.Text = oEventInfo.StrActivity;
                txtComments.Text = oEventInfo.StrComments;
                txtDate.Text = oEventInfo.DtEventDate.ToShortDateString();
                txtLocation.Text = oEventInfo.StrLocation;
            }
        }
        else if (e.CommandName.Equals("DeleteNews"))
        {

            BLL.EventsLib oEventsLib = new BLL.EventsLib();
            oEventsLib.DeleteEventDetails(Convert.ToInt32(e.CommandArgument));
            lblMsg.Text = "Event has been deleted successfully.";

            oEventsLib = null;
            ClearControls();
            BindEvents();
        }
        else if (e.CommandName.Equals("StatusChanged"))
        {
            BLL.EventsLib oEventsLib = new BLL.EventsLib();
            oEventsLib.ActivateDeactivateEvent(Convert.ToInt32(e.CommandArgument));
            lblMsg.Text = "Event status has been changed successfully.";
            oEventsLib = null;
            ClearControls();
            BindEvents();
        }
    }
 /// Function Header*******************************************************
 /// Function Name: BindEvents
 /// Function Type: Function
 /// Functionality: used to get bind the events
 /// Input: 
 /// Output: 
 /// Return Value:
 /// Note: 
 /// *********************************************************************
 private void BindEvents()
 {
     BLL.EventsLib oEventsLib = new BLL.EventsLib();
     GVEvents.DataSource = oEventsLib.SearchEvents(Convert.ToChar(ddlStatus.SelectedValue), ddlUsers.SelectedValue);
     GVEvents.DataBind();
     oEventsLib = 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 BindEvents()
 {
     BLL.EventsLib oEventsLib = new BLL.EventsLib();
     GVEvents.DataSource = oEventsLib.GetEventByUserId(AppLib.GetLoggedInUserName());
     GVEvents.DataBind();
     oEventsLib = null;
 }
    private void BindEventsDetails()
    {
        if (Request.QueryString["id"] != null)
        {
            lnkBtnSearch.Text = "Update";
            lblHeading.Text = "Update Event";
            lblSubHeading.Text = "Update Event Details";
            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)
            {
                txtActivity.Text = oEventInfo.StrActivity;
                txtComments.Text = oEventInfo.StrComments;
                txtDate.Text = oEventInfo.DtEventDate.ToShortDateString();
                txtLocation.Text = oEventInfo.StrLocation;
                rdoIsActive.SelectedValue = oEventInfo.ChrIsActive.ToString();
                rdoApproved.SelectedValue = oEventInfo.ChrStatus.ToString();

            }

            oEventsLib = null;
            oEventInfo = null;
        }
    }