protected void PendingRequestGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
        {
            int EmpID = (int)HttpContext.Current.Session["EmpID"];

            PendingRequestGridView.DataSource = RequestBizLogic.ViewPendingRequest(EmpID);
            PendingRequestGridView.PageIndex  = e.NewPageIndex;
            PendingRequestGridView.DataBind();
        }
        protected void PendingRequestGridView_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int EmpID = (int)HttpContext.Current.Session["EmpID"];

            int requestID = Convert.ToInt32(PendingRequestGridView.DataKeys[e.RowIndex].Values[0]);

            RequestBizLogic.DeleteSelectedPendingRequest(requestID);
            PendingRequestGridView.DataSource = RequestBizLogic.ViewPendingRequest(EmpID);
            PendingRequestGridView.DataBind();
            RequestDetailsGridView.Visible = false;
        }
        protected void SelectButton_Click(object sender, EventArgs e)
        {
            int    EmpID = (int)HttpContext.Current.Session["EmpID"];
            string value = StatusRadioButtonList.SelectedValue;

            ViewState["value"] = value;
            if (value == "Pending")
            {
                PendingRequestGridView.DataSource = RequestBizLogic.ViewPendingRequest(EmpID);//hardcord employeeId for testing
                PendingRequestGridView.DataBind();
                RequestGridView.Columns[3].Visible = false;
                RequestGridView.Columns[4].Visible = false;
                PendingRequestGridView.Visible     = true;
                RequestGridView.Visible            = false;
                RequestDetailsGridView.Visible     = false;
                //DeleteButton.Visible = true;
            }
            if (value == "Approved")
            {
                RequestGridView.DataSource = RequestBizLogic.ViewApprovedRequest(EmpID);//hardcord employeeId for testing
                RequestGridView.DataBind();
                RequestGridView.Visible        = true;
                PendingRequestGridView.Visible = false;
                RequestDetailsGridView.Visible = false;
                //DeleteButton.Visible = false;
            }
            if (value == "Rejected")
            {
                RequestGridView.DataSource = RequestBizLogic.ViewRejectedRequest(EmpID);//hardcord employeeId for testing
                RequestGridView.DataBind();
                RequestGridView.Columns[3].Visible = false;
                RequestGridView.Visible            = true;
                PendingRequestGridView.Visible     = false;
                RequestDetailsGridView.Visible     = false;
                //DeleteButton.Visible = false;
            }
        }