public ArrayList Search(gbmodel.user.User p_oUser, SearchParameters p_oSearchParameter)
{
List <SqlParameter> oParams = new List <SqlParameter>();
ArrayList oResult = null;
oParams.Add(new SqlParameter("@sz_company_id", p_oUser.Account.ID));
oParams.Add(new SqlParameter("@i_start_index", p_oSearchParameter.StartIndex));
oParams.Add(new SqlParameter("@i_end_index", p_oSearchParameter.EndIndex));
oParams.Add(new SqlParameter("@sz_order_by", p_oSearchParameter.OrderBy));
oParams.Add(new SqlParameter("@sz_search_text", p_oSearchParameter.SearchText));
DataSet ds = null;
try
{
ds = DBUtil.DataSet(Procedures.PR_SEARCH_PATIENT, oParams);
}
catch (Exception io)
{
}
oResult = new ArrayList(2);
List <gbmodel.patient.Patient> oPatientList = new List <gbmodel.patient.Patient>();
gbmodel.patient.Patient oPatient = null;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
oPatient = new gbmodel.patient.Patient();
oPatient.RowID = Convert.ToInt32(ds.Tables[0].Rows[i]["rowid"].ToString());
oPatient.CaseID = Convert.ToInt32(ds.Tables[0].Rows[i]["sz_case_id"].ToString());
oPatient.CaseNo = Convert.ToInt32(ds.Tables[0].Rows[i]["sz_case_no"].ToString());
oPatient.ClaimNumber = ds.Tables[0].Rows[i]["sz_claim_number"].ToString();
oPatient.Name = ds.Tables[0].Rows[i]["sz_patient_name"].ToString();
gbmodel.carrier.Carrier oCarrier = new gbmodel.carrier.Carrier();
oCarrier.Name = ds.Tables[0].Rows[i]["sz_insurance_company"].ToString();
oPatient.Carrier = oCarrier;
oPatient.ID = ds.Tables[0].Rows[i]["sz_patient_id"].ToString();
oPatient.DOA = ds.Tables[0].Rows[i]["dt_accident_date"].ToString();
gbmodel.account.Account oAccount = new gbmodel.account.Account();
oAccount.ID = ds.Tables[0].Rows[i]["sz_company_id"].ToString();
oPatient.Account = oAccount;
oPatient.FirstName = ds.Tables[0].Rows[i]["sz_patient_first_name"].ToString();
oPatient.LastName = ds.Tables[0].Rows[i]["sz_patient_last_name"].ToString();
oPatientList.Add(oPatient);
}
oResult.Add(oPatientList.ToArray());
for (int i = 0; i < ds.Tables[1].Rows.Count; i++)
{
oResult.Add(ds.Tables[1].Rows[i]["count"].ToString());
}
return(oResult);
}
public List <gbmodel.carrier.Carrier> Select(gbmodel.user.User oUser, gbmodel.carrier.Carrier oCarrier)
{
SqlConnection sqlConnection = null;
List <gbmodel.carrier.Carrier> oList = new List <gbmodel.carrier.Carrier>();
try
{
sqlConnection = new SqlConnection(DBUtil.ConnectionString);
sqlConnection.Open();
SqlCommand sqlCommand = null;
sqlCommand = new SqlCommand(Procedures.PR_CARRIER_SELECT, sqlConnection);//TODO Add procedure name
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.Parameters.Add(new SqlParameter("@id", oUser.Account.ID));
sqlCommand.Parameters.Add(new SqlParameter("@FLAG", "INSURANCE_LIST"));
SqlDataAdapter da = new SqlDataAdapter(sqlCommand);
DataSet ds = new DataSet();
da.Fill(ds);
if (ds != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = ds.Tables[0].Rows[i];
gbmodel.carrier.Carrier oElement = new gbmodel.carrier.Carrier();
oElement.Name = dr["DESCRIPTION"].ToString(); //to do
oElement.Id = dr["CODE"].ToString(); //TODO
oList.Add(oElement);
}
}
}
catch (Exception ex)
{
}
finally
{
if (sqlConnection.State == ConnectionState.Open)
{
sqlConnection.Close();
}
}
return(oList);
}