private ATTParticipantSearch GetFilter()
{
ATTParticipantSearch SearchParticipant = new ATTParticipantSearch();
if (this.txtFName.Text.Trim() != "")
{
SearchParticipant.FirstName = this.txtFName.Text.Trim();
}
if (this.txtMName.Text.Trim() != "")
{
SearchParticipant.MiddleName = this.txtMName.Text.Trim();
}
if (this.txtSurName.Text.Trim() != "")
{
SearchParticipant.SurName = this.txtSurName.Text.Trim();
}
if (this.ddlGender.SelectedIndex > 0)
{
SearchParticipant.Gender = this.ddlGender.SelectedValue;
}
if (this.ddlDistrict.SelectedIndex > 0)
{
SearchParticipant.District = this.ddlDistrict.SelectedItem.Text;
}
return(SearchParticipant);
}
public static List <ATTParticipantSearch> SearchParticipant(ATTParticipantSearch objParticipant)
{
List <ATTParticipantSearch> lstParticipant = new List <ATTParticipantSearch>();
foreach (DataRow row in DLLParticipantSearch.SearchParticipant(objParticipant).Rows)
{
ATTParticipantSearch obj = new ATTParticipantSearch(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"]));
lstParticipant.Add(obj);
}
return(lstParticipant);
}
public static DataTable SearchParticipant(ATTParticipantSearch objParticipant)
{
try
{
string strSelectSQL = "";
strSelectSQL = "SELECT P_ID,FIRST_NAME,MID_NAME,SUR_NAME,GENDER,DOB,NEP_DISTNAME,FATHER_NAME,GFATHER_NAME FROM VW_PARTICIPANT_INFO WHERE 1=1";
int i = 0;
if (objParticipant.FirstName != null)
{
i++;
}
if (objParticipant.MiddleName != null)
{
i++;
}
if (objParticipant.SurName != null)
{
i++;
}
if (objParticipant.Gender != null)
{
i++;
}
if (objParticipant.District != null)
{
i++;
}
OracleParameter[] ParamArray = new OracleParameter[i];
int j = 0;
if (objParticipant.FirstName != null)
{
strSelectSQL += " AND FIRST_NAME LIKE :FName||'%'";
ParamArray[j] = Utilities.GetOraParam(":FName", objParticipant.FirstName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objParticipant.MiddleName != null)
{
strSelectSQL += " AND MID_NAME LIKE :MName||'%'";
ParamArray[j] = Utilities.GetOraParam(":MName", objParticipant.MiddleName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objParticipant.SurName != null)
{
strSelectSQL += " AND SUR_NAME LIKE :SurName||'%'";
ParamArray[j] = Utilities.GetOraParam(":SurName", objParticipant.SurName, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objParticipant.Gender != null)
{
strSelectSQL += " AND GENDER = :Gender";
ParamArray[j] = Utilities.GetOraParam(":Gender", objParticipant.Gender, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
if (objParticipant.District != null)
{
strSelectSQL += " AND NEP_DISTNAME = :District";
ParamArray[j] = Utilities.GetOraParam(":District", objParticipant.District, OracleDbType.Varchar2, ParameterDirection.Input);
j++;
}
strSelectSQL += " ORDER BY P_ID";
DataSet ds = SqlHelper.ExecuteDataset(CommandType.Text, strSelectSQL, Module.DLPDS, 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;
}
}
