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