protected void btnShow_Click(object sender, EventArgs e)
        {
            try
            {
                if (chSalaryIncrementStatus.Checked)   // individual process
                {
                    Attendance_BLL _attendancebll         = new Attendance_BLL();
                    string         eid                    = txtbxEID.Text.Trim();
                    List <HRM_EMPLOYEES_VIEWER> employess = _attendancebll.GetEmployeesByE_id(eid, Convert.ToDateTime(txtbxEffectiveDate.Text));

                    if (employess.Count > 0)
                    {
                        if (chSalaryIncrementStatus.Checked)
                        {
                            grdviewIndivitual.DataSource = employess;
                            grdviewIndivitual.DataBind();
                        }
                        else
                        {
                            grdview.DataSource = employess;
                            grdview.DataBind();
                        }
                    }
                }
                else    //dept/section/subsection wise process
                {
                    if (ddlRegion1.SelectedItem.ToString() == "--Select--")
                    {
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Region!')", true);
                        return;
                    }
                    else if (ddlOffice1.SelectedItem.ToString() == "--Select--")
                    {
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Office!')", true);
                        return;
                    }
                    else if (ddlDept1.SelectedItem.ToString() == "--Select--")
                    {
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Department!')", true);
                        return;
                    }

                    else if (txtbxEffectiveDate.Text == "")
                    {
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Effective Date!')", true);
                        return;
                    }
                    else
                    {
                        try
                        {
                            Attendance_BLL _attendancebll = new Attendance_BLL();
                            if (ddlSubSections.SelectedValue.ToString() == "" || ddlSubSections.SelectedValue.ToString() == "0" || ddlSection.SelectedValue.ToString() == "" || ddlSection.SelectedValue.ToString() == "0")
                            {
                                int RegionId = Convert.ToInt32(ddlRegion1.SelectedValue);
                                int OfficeId = Convert.ToInt32(ddlOffice1.SelectedValue);
                                int DeptId   = Convert.ToInt32(ddlDept1.SelectedValue);

                                List <HRM_EMPLOYEES_VIEWER> employess = _attendancebll.GetEmployeeByDepartment(RegionId, OfficeId, DeptId, Convert.ToDateTime(txtbxEffectiveDate.Text));

                                if (employess.Count > 0)
                                {
                                    if (chSalaryIncrementStatus.Checked)
                                    {
                                        grdviewIndivitual.DataSource = employess;
                                        grdviewIndivitual.DataBind();
                                    }
                                    else
                                    {
                                        grdview.DataSource = employess;
                                        grdview.DataBind();
                                    }
                                }
                            }
                            else
                            {
                                int ResionId  = Convert.ToInt32(ddlRegion1.SelectedValue);
                                int OfficeId  = Convert.ToInt32(ddlOffice1.SelectedValue);
                                int DeptId    = Convert.ToInt32(ddlDept1.SelectedValue);
                                int sction    = Convert.ToInt32(ddlSection.SelectedValue);
                                int subsction = Convert.ToInt32(ddlSubSections.SelectedValue);

                                List <HRM_EMPLOYEES_VIEWER> employess = _attendancebll.GetEmployeeBySubsectionWise(ResionId, OfficeId, DeptId, sction, subsction, Convert.ToDateTime(txtbxEffectiveDate.Text));

                                if (employess.Count > 0)
                                {
                                    if (chSalaryIncrementStatus.Checked)
                                    {
                                        grdviewIndivitual.DataSource = employess;
                                        grdviewIndivitual.DataBind();
                                    }
                                    else
                                    {
                                        grdview.DataSource = employess;
                                        grdview.DataBind();
                                    }
                                }
                            }
                        }
                        catch (Exception ex)
                        {
                            ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
                        }
                    }
                }
                btnConfirm.Visible = true;
            }
            catch (Exception ex)
            {
                string EID = Convert.ToString(((SessionUser)Session["SessionUser"]).EID);
                //LogController<SalaryIncrementList>.SetLog(ex, EID);
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
            }
        }