private ATTPersonSearch GetFilter()
{
ATTPersonSearch SearchPerson = new ATTPersonSearch();
if (this.txtFName.Text.Trim() != "")
{
SearchPerson.FirstName = this.txtFName.Text.Trim();
}
if (this.txtMName.Text.Trim() != "")
{
SearchPerson.MiddleName = this.txtMName.Text.Trim();
}
if (this.txtSurName.Text.Trim() != "")
{
SearchPerson.SurName = this.txtSurName.Text.Trim();
}
if (this.ddlGender.SelectedIndex > 0)
{
SearchPerson.Gender = this.ddlGender.SelectedValue;
}
if (this.ddlDistrict.SelectedIndex > 0)
{
SearchPerson.District = this.ddlDistrict.SelectedItem.Text;
}
//if (this.ddlOrgType.SelectedIndex > 0) SearchPerson.IniType = this.ddlOrgType.SelectedValue;
SearchPerson.IniType = "3";
return(SearchPerson);
}
private ATTPersonSearch GetFilter()
{
ATTPersonSearch SearchPerson = new ATTPersonSearch();
if (this.txtSFirstName.Text.Trim() != "")
{
SearchPerson.FirstName = this.txtSFirstName.Text.Trim();
}
if (this.txtSMName.Text.Trim() != "")
{
SearchPerson.MiddleName = this.txtSMName.Text.Trim();
}
if (this.txtSLastName.Text.Trim() != "")
{
SearchPerson.SurName = this.txtSLastName.Text.Trim();
}
if (this.ddlSGender.SelectedIndex > 0)
{
SearchPerson.Gender = this.ddlSGender.SelectedValue;
}
if (this.ddlSHomeDistrict.SelectedIndex > 0)
{
SearchPerson.BirthDistrict = int.Parse(this.ddlSHomeDistrict.SelectedValue);
}
if (this.ddlSMarStatus.SelectedIndex > 0)
{
SearchPerson.IniType = this.ddlSMarStatus.SelectedValue;
}
return(SearchPerson);
}
public static List <ATTPersonSearch> SearchPerson(ATTPersonSearch objPerson)
{
List <ATTPersonSearch> lstPerson = new List <ATTPersonSearch>();
foreach (DataRow row in DLLPersonSearch.SearchPerson(objPerson).Rows)
{
ATTPersonSearch obj = new ATTPersonSearch(double.Parse(row["P_ID"].ToString()),
((row["FIRST_NAME"] == System.DBNull.Value) ? "" : (string)row["FIRST_NAME"]),
((row["MID_NAME"] == System.DBNull.Value) ? "" : (string)row["MID_NAME"]),
((row["SUR_NAME"] == System.DBNull.Value) ? "" : (string)row["SUR_NAME"]),
((row["GENDER"] == System.DBNull.Value) ? "" : (string)row["GENDER"]),
((row["DOB"] == System.DBNull.Value) ? "" : (string)row["DOB"]),
((row["NEP_DISTNAME"] == System.DBNull.Value) ? "" : (string)row["NEP_DISTNAME"]),
((row["FATHER_NAME"] == System.DBNull.Value) ? "" : (string)row["FATHER_NAME"]),
((row["GFATHER_NAME"] == System.DBNull.Value) ? "" : (string)row["GFATHER_NAME"]));
obj.MaritalStatus = (row["MARTIAL_STATUS"] == System.DBNull.Value ? "" : (string)row["MARTIAL_STATUS"]);
if (row["BIRTH_DISTRICT"] != System.DBNull.Value)
{
obj.BirthDistrict = int.Parse(row["BIRTH_DISTRICT"].ToString());
}
if (row["COUNTRY_ID"] != System.DBNull.Value)
{
obj.CountryID = int.Parse(row["COUNTRY_ID"].ToString());
}
lstPerson.Add(obj);
}
return(lstPerson);
}
public static List <ATTPersonSearch> SearchPersonWithPostIF(ATTPersonSearch objPerson)
{
List <ATTPersonSearch> lstPerson = new List <ATTPersonSearch>();
foreach (DataRow row in DLLEmployeeSearch.SearchPersonWithPostIF(objPerson).Rows)
{
ATTPersonSearch obj = new ATTPersonSearch(double.Parse(row["P_ID"].ToString()),
((row["FIRST_NAME"] == System.DBNull.Value) ? "" : (string)row["FIRST_NAME"]),
((row["MID_NAME"] == System.DBNull.Value) ? "" : (string)row["MID_NAME"]),
((row["SUR_NAME"] == System.DBNull.Value) ? "" : (string)row["SUR_NAME"]),
((row["GENDER"] == System.DBNull.Value) ? "" : (string)row["GENDER"]),
((row["DOB"] == System.DBNull.Value) ? "" : (string)row["DOB"]),
((row["NEP_DISTNAME"] == System.DBNull.Value) ? "" : (string)row["NEP_DISTNAME"]),
((row["FATHER_NAME"] == System.DBNull.Value) ? "" : (string)row["FATHER_NAME"]),
((row["GFATHER_NAME"] == System.DBNull.Value) ? "" : (string)row["GFATHER_NAME"]),
((row["POST_NAME"] == System.DBNull.Value) ? "." : (string)row["POST_NAME"]));
lstPerson.Add(obj);
}
return(lstPerson);
}
public static DataTable SearchPerson(ATTPersonSearch objPerson)
{
try
{
string strSelectSQL = "";
strSelectSQL = "SELECT P_ID,FIRST_NAME,MID_NAME,SUR_NAME,GENDER,DOB,MARTIAL_STATUS,BIRTH_DISTRICT,COUNTRY_ID,";
strSelectSQL += "NEP_DISTNAME,FATHER_NAME,GFATHER_NAME FROM VW_PERSON_ADDRESS_INFO WHERE 1=1";
int i = 0;
if (objPerson.FirstName != null)
{
i++;
}
if (objPerson.MiddleName != null)
{
i++;
}
if (objPerson.SurName != null)
{
i++;
}
if (objPerson.Gender != null)
{
i++;
}
if (objPerson.District != null)
{
i++;
}
if (objPerson.IniType != null)
{
i++;
}
OracleParameter[] ParamArray = new OracleParameter[i];
int j = 0;
if (objPerson.FirstName != null)
{
strSelectSQL += " AND FIRST_NAME LIKE :FName||'%'";
ParamArray[j] = Utilities.GetOraParam(":FName", objPerson.FirstName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objPerson.MiddleName != null)
{
strSelectSQL += " AND MID_NAME LIKE :MName||'%'";
ParamArray[j] = Utilities.GetOraParam(":MName", objPerson.MiddleName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objPerson.SurName != null)
{
strSelectSQL += " AND SUR_NAME LIKE :SurName||'%'";
ParamArray[j] = Utilities.GetOraParam(":SurName", objPerson.SurName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objPerson.Gender != null)
{
strSelectSQL += " AND GENDER = :Gender";
ParamArray[j] = Utilities.GetOraParam(":Gender", objPerson.Gender, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objPerson.District != null)
{
strSelectSQL += " AND NEP_DISTNAME = :District";
ParamArray[j] = Utilities.GetOraParam(":District", objPerson.District, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objPerson.IniType != null)
{
strSelectSQL += " AND INI_TYPE = :IniType";
ParamArray[j] = Utilities.GetOraParam(":IniType", objPerson.IniType, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
strSelectSQL += " ORDER BY P_ID";
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSelectSQL, ParamArray);
return((DataTable)ds.Tables[0]);
}
catch (OracleException oex)
{
PCS.COREDL.OracleError oe = new PCS.COREDL.OracleError();
throw new ArgumentException(oe.GetOraError(oex.Number, oex.Message));
}
catch (Exception ex)
{
throw ex;
}
}
