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