private void BindGridForBankAdvice()
        {
            try
            {
                string OCODE = ((SessionUser)Session["SessionUser"]).OCode;


                List <BankAdviceRe> Bank1 = new List <BankAdviceRe>();


                if (drpDepartment.SelectedValue != " " && txtDateFrom.Text != "" && txtEid_TRNS.Text == "")
                {
                    string FormDate = txtDateFrom.Text.ToString();
                    //DateTime Todate = Convert.ToDateTime(txtDateFrom.Text.ToString());
                    string dptId = drpDepartment.SelectedValue.ToString();
                    List <BankAdviceRe> Bank2 = new List <BankAdviceRe>();
                    Bank2 = objAtt_BLL.GetBankAdviceByDepartmentId(OCODE, dptId, FormDate).ToList();
                    if (Bank2.Count > 0)
                    {
                        GridViewEMP_AT.DataSource = Bank2.ToList();
                        GridViewEMP_AT.DataBind();
                    }
                    else
                    {
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Found!')", true);
                    }
                }
                else if (txtDateFrom.Text != "" && txtEid_TRNS.Text != "")
                {
                    string eid      = txtEid_TRNS.Text.ToString();
                    string FormDate = txtDateFrom.Text.ToString();
                    //DateTime Todate = Convert.ToDateTime(txtDateFrom.Text.ToString());
                    List <BankAdviceRe> Bank3 = new List <BankAdviceRe>();
                    Bank3 = objAtt_BLL.GetBankAdviceByEid(OCODE, eid, FormDate).ToList();
                    if (Bank3.Count > 0)
                    {
                        GridViewEMP_AT.DataSource = Bank3.ToList();
                        GridViewEMP_AT.DataBind();
                    }

                    else
                    {
                        ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('No Data Found!')", true);
                    }
                }
                else
                {
                    ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('Select Item !')", true);
                    //Bank1 = objAtt_BLL.GetBankAdviceAll(OCODE).ToList();
                    //if (Bank1.Count > 0)
                    //{
                    //    GridViewEMP_AT.DataSource = Bank1.ToList();
                    //    GridViewEMP_AT.DataBind();

                    //}
                }
            }
            catch (Exception ex)
            {
                ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "func('" + ex.Message + "')", true);
            }
        }