public static BookingPatientOffering[] GetByBookingPatientID(int booking_patient_id)
{
DataTable tbl = GetDataTable_ByBookingPatientID(booking_patient_id);
BookingPatientOffering[] bpos = new BookingPatientOffering[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
bpos[i] = LoadAll(tbl.Rows[i]);
return bpos;
}
public static BookingPatientOffering[] GetByBookingPatientID(int booking_patient_id)
{
DataTable tbl = GetDataTable_ByBookingPatientID(booking_patient_id);
BookingPatientOffering[] bpos = new BookingPatientOffering[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
bpos[i] = LoadAll(tbl.Rows[i]);
}
return(bpos);
}
public static Hashtable GetHashtable(int[] booking_patient_ids = null)
{
Hashtable hash = new Hashtable();
DataTable tbl = GetDataTable(booking_patient_ids);
for (int i = 0; i < tbl.Rows.Count; i++)
{
BookingPatientOffering bpo = LoadAll(tbl.Rows[i]);
if (hash[bpo.BookingPatient.BookingPatientID] == null)
{
hash[bpo.BookingPatient.BookingPatientID] = new ArrayList();
}
((ArrayList)hash[bpo.BookingPatient.BookingPatientID]).Add(bpo);
}
return(hash);
}
public static BookingPatientOffering LoadAll(DataRow row)
{
BookingPatientOffering bpo = Load(row, "bpo_");
bpo.Offering = OfferingDB.Load(row, "offering_");
bpo.Offering.Field = IDandDescrDB.Load(row, "offeringfield_field_id", "offeringfield_descr");
bpo.AddedBy = StaffDB.Load(row, "added_by_");
bpo.AddedBy.Person = PersonDB.Load(row, "added_by_person_");
bpo.AddedBy.Person.Title = IDandDescrDB.Load(row, "title_added_by_title_id", "title_added_by_descr");
if (row["deleted_by_person_person_id"] != DBNull.Value)
{
bpo.DeletedBy = StaffDB.Load(row, "deleted_by_");
bpo.DeletedBy.Person = PersonDB.Load(row, "deleted_by_person_");
bpo.DeletedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr");
}
return(bpo);
}
