ATTLawyerSearch GetFilter()
{
ATTLawyerSearch search = new ATTLawyerSearch();
search.FirstName = this.txtFName.Text;
search.MidName = this.txtMName.Text;
search.SurName = this.txtSName.Text;
search.Lisence = this.txtLisenceNo.Text;
search.LawyerTypeID = int.Parse(this.ddlLawyerType.SelectedValue);
search.UnitID = int.Parse(this.ddlUnit.SelectedValue);
if (chkInActive.Checked)
{
search.ACTIVE = "N";
}
else
{
search.ACTIVE = "";
}
if (this.ddlSex.SelectedIndex > 0)
{
search.Gender = this.ddlSex.SelectedValue;
}
else
{
search.Gender = "";
}
return(search);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (
this.txtFName.Text.Trim() == "" &&
this.txtMName.Text.Trim() == "" &&
this.txtSName.Text.Trim() == "" &&
this.txtLisenceNo.Text.Trim() == "" &&
this.ddlLawyerType.SelectedIndex == 0 &&
this.ddlUnit.SelectedIndex == 0 &&
this.ddlSex.SelectedIndex == 0
)
{
this.lblStatus.Text = "Please enter atleast one criteria for record selecttion.";
return;
}
ATTLawyerSearch search = this.GetFilter();
try
{
List <ATTLawyerSearch> lst = BLLLawyerSearch.GetLawyerList(search);
Session["LstSrchedData"] = lst;
this.grdLawyer.SelectedIndex = -1;
this.grdLawyer.DataSource = lst;
this.grdLawyer.DataBind();
this.lblStatus.Text = "";
}
catch (Exception ex)
{
this.lblStatus.Text = ex.Message;
}
}
public static List <ATTLawyerSearch> GetLawyerList(ATTLawyerSearch search)
{
List <ATTLawyerSearch> lst = new List <ATTLawyerSearch>();
char[] token = { '_' };
try
{
DataTable tbl = DLLLawyerSearch.GetLawyerTable(search);
foreach (DataRow row in tbl.Rows)
{
ATTLawyerSearch obj = new ATTLawyerSearch();
obj.PersonID = double.Parse(row["P_ID"].ToString());
obj.FirstName = row["first_name"].ToString();
obj.MidName = row["mid_name"].ToString();
obj.SurName = row["sur_name"].ToString();
obj.Lisence = row["license_no"].ToString();
obj.LawyerTypeName = row["lawyer_type_description"].ToString();
obj.LastRenewalDate = row["LAWYER_LAST_REN_DATE"].ToString();
obj.LastRenewalUpto = row["LAWYER_LAST_REN_UPTO"].ToString();
obj.PvtLawyerLastRenewalDate = row["P_LAWYER_LAST_REN_DATE"].ToString();
obj.PvtLawyerLastRenewalUpto = row["P_LAWYER_LAST_REN_UPTO"].ToString();
obj.UnitName = row["unit_name"].ToString();
obj.ACTIVE = row["ACTIVE"].ToString();
obj.Gender = row["gender"].ToString();
lst.Add(obj);
}
return(lst);
}
catch (Exception ex)
{
throw ex;
}
}
public static DataTable GetLawyerTable(ATTLawyerSearch search)
{
string SQL = "select * from VW_LAWYER_INFO where 1=1 ";
List <OracleParameter> paramArray = new List <OracleParameter>();
if (search.FirstName != "")
{
SQL = SQL + " and first_name like :fname||'%'";
paramArray.Add(Utilities.GetOraParam(":fname", search.FirstName, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (search.MidName != "")
{
SQL = SQL + " and mid_name like :mname||'%'";
paramArray.Add(Utilities.GetOraParam(":mname", search.MidName, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (search.SurName != "")
{
SQL = SQL + " and sur_name like :sname||'%'";
paramArray.Add(Utilities.GetOraParam(":sname", search.SurName, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (search.Lisence != "")
{
SQL = SQL + " and license_no = :lisence";
paramArray.Add(Utilities.GetOraParam(":lisence", search.Lisence, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (search.LawyerTypeID > 0)
{
SQL = SQL + " and lawyer_type_id = :ltID";
paramArray.Add(Utilities.GetOraParam(":ltID", search.LawyerTypeID, OracleDbType.Int16, ParameterDirection.Input));
}
if (search.UnitID > 0)
{
SQL = SQL + " and unit_id = :unit";
paramArray.Add(Utilities.GetOraParam(":unit", search.UnitID, OracleDbType.Int16, ParameterDirection.Input));
}
if (search.Gender != "")
{
SQL = SQL + " and gender = :gender";
paramArray.Add(Utilities.GetOraParam(":gender", search.Gender, OracleDbType.Varchar2, ParameterDirection.Input));
}
if (search.ACTIVE != "")
{
SQL = SQL + " and active = :activex";
paramArray.Add(Utilities.GetOraParam(":activex", search.ACTIVE, OracleDbType.Varchar2, ParameterDirection.Input));
}
SQL = SQL + " order by lawyer_type_id, license_no";
try
{
return(SqlHelper.ExecuteDataset(CommandType.Text, SQL, Module.LJMS, paramArray.ToArray()).Tables[0]);
}
catch (Exception ex)
{
throw ex;
}
}
