public static ReferrerAdditionalEmail LoadAll(DataRow row)
{
ReferrerAdditionalEmail rae = Load(row);
rae.DeletedBy = StaffDB.Load(row, "deleted_by_");
rae.DeletedBy.Person = PersonDB.Load(row, "person_deleted_by_");
rae.DeletedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr");
return(rae);
}
public static CreditNote LoadAll(DataRow row)
{
CreditNote creditNote = Load(row);
creditNote.Staff = StaffDB.Load(row, "staff_");
creditNote.Staff.Person = PersonDB.Load(row, "person_");
creditNote.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
return(creditNote);
}
public static Receipt LoadAll(DataRow row)
{
Receipt receipt = Load(row);
receipt.Staff = StaffDB.Load(row, "staff_");
receipt.Staff.Person = PersonDB.Load(row, "person_");
receipt.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
receipt.ReceiptPaymentType = IDandDescrDB.Load(row, "receipt_payment_type_id", "descr");
return(receipt);
}
public static PatientHistory LoadAll(DataRow row)
{
PatientHistory p = Load(row);
p.Title = IDandDescrDB.Load(row, "title_id", "descr");
p.ModifiedFromThisBy = StaffDB.Load(row, "staff_person_");
p.ModifiedFromThisBy.Person = PersonDB.Load(row, "staff_person_");
p.ModifiedFromThisBy.Person.Title = IDandDescrDB.Load(row, "title_staff_title_id", "title_staff_descr");
return(p);
}
public static HealthCardEPCRemainingChangeHistory[] GetByHealthCardID(int health_card_id)
{
string sql = @"
SELECT
health_card_epc_remaining_change_history_id,HealthCardEPCRemainingChangeHistory.health_card_epc_remaining_id,HealthCardEPCRemainingChangeHistory.staff_id,date,
pre_num_services_remaining,post_num_services_remaining,
health_card_id,HealthCardEPCRemaining.field_id,num_services_remaining,deleted_by,date_deleted,
Field.descr,
staff.staff_id as staff_staff_id, staff.person_id as staff_person_id, staff.login as staff_login, staff.pwd as staff_pwd,
staff.staff_position_id as staff_staff_position_id, staff.field_id as staff_field_id, staff.costcentre_id as staff_costcentre_id,
staff.is_contractor as staff_is_contractor, staff.tfn as staff_tfn, staff.provider_number as staff_provider_number,
staff.is_fired as staff_is_fired, staff.is_commission as staff_is_commission, staff.commission_percent as staff_commission_percent,
staff.is_stakeholder as staff_is_stakeholder,staff.is_master_admin as staff_is_master_admin,staff.is_admin as staff_is_admin,staff.is_principal as staff_is_principal,staff.is_provider as staff_is_provider, staff.is_external as staff_is_external,
staff.staff_date_added as staff_staff_date_added, staff.start_date as staff_start_date, staff.end_date as staff_end_date,
staff.comment as staff_comment,
staff.num_days_to_display_on_booking_screen as staff_num_days_to_display_on_booking_screen,
staff.show_header_on_booking_screen as staff_show_header_on_booking_screen,
staff.bk_screen_field_id as staff_bk_screen_field_id, staff.bk_screen_show_key as staff_bk_screen_show_key,
staff.enable_daily_reminder_sms as staff_enable_daily_reminder_sms,
staff.enable_daily_reminder_email as staff_enable_daily_reminder_email,
staff.hide_booking_notes as staff_hide_booking_notes,
" + PersonDB.GetFields("person_", "person") + @",
title.title_id as title_title_id, title.descr as title_descr
FROM
HealthCardEPCRemainingChangeHistory
LEFT OUTER JOIN HealthCardEPCRemaining ON HealthCardEPCRemainingChangeHistory.health_card_epc_remaining_id = HealthCardEPCRemaining.health_card_epc_remaining_id
LEFT OUTER JOIN Field ON HealthCardEPCRemaining.field_id = Field.field_id
LEFT OUTER JOIN Staff staff ON staff.staff_id = HealthCardEPCRemainingChangeHistory.staff_id
LEFT OUTER JOIN Person person ON person.person_id = staff.person_id
LEFT OUTER JOIN Title title ON title.title_id = person.title_id
WHERE
HealthCardEPCRemaining.health_card_id = " + health_card_id;
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
HealthCardEPCRemainingChangeHistory[] histories = new HealthCardEPCRemainingChangeHistory[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
histories[i] = Load(tbl.Rows[i]);
histories[i].HealthCardEpcRemaining = HealthCardEPCRemainingDB.Load(tbl.Rows[i]);
histories[i].HealthCardEpcRemaining.Field = IDandDescrDB.Load(tbl.Rows[i], "field_id", "descr");
histories[i].Staff = StaffDB.Load(tbl.Rows[i], "staff_");
histories[i].Staff.Person = PersonDB.Load(tbl.Rows[i], "person_");
histories[i].Staff.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_title_id", "title_descr");
}
return(histories);
}
public static Refund LoadAll(DataRow row)
{
Refund refund = Load(row);
refund.RefundReason = IDandDescrDB.Load(row, "refund_reason_id", "descr");
refund.Staff = StaffDB.Load(row, "staff_");
refund.Staff.Person = PersonDB.Load(row, "staff_person_");
refund.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
return(refund);
}
public static Staff[] GetWorkingStaffOf(int organistion_id, DateTime date)
{
DataTable tbl = GetDataTable_WorkingStaffOf(organistion_id, date);
Staff[] list = new Staff[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
list[i] = StaffDB.Load(tbl.Rows[i]);
list[i].Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
list[i].Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
}
return(list);
}
public static HealthCard LoadAll(DataRow row)
{
HealthCard hc = Load(row);
if (row["added_or_last_modified_by_staff_id"] != DBNull.Value)
{
hc.AddedOrLastModifiedBy = StaffDB.Load(row, "added_or_last_modified_by_");
}
if (row["person_added_or_last_modified_by_person_id"] != DBNull.Value)
{
hc.AddedOrLastModifiedBy.Person = PersonDB.Load(row, "person_added_or_last_modified_by_");
hc.AddedOrLastModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_added_or_last_modified_by_title_id", "title_added_or_last_modified_by_descr");
}
return(hc);
}
// returns 2d hashtable
// get by: hash[new Hashtable2D.Key(staffID, (int)DayOfWeek.Sunday)]
public static Hashtable Get2DHashByStaffIDDayID(int[] staff_ids = null)
{
string sql = JoinedSql + (staff_ids != null && staff_ids.Length > 0 ? @" AND r.staff_id IN(" + string.Join(",", staff_ids) + ")" : "");
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
Hashtable hash = new Hashtable();
for (int i = 0; i < tbl.Rows.Count; i++)
{
RegisterStaff rr = Load(tbl.Rows[i], "registration_provider_number");
rr.Staff = StaffDB.Load(tbl.Rows[i], "staff_");
rr.Staff.Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
rr.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_");
if (!rr.ExclSun)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Sunday);
}
if (!rr.ExclMon)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Monday);
}
if (!rr.ExclTue)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Tuesday);
}
if (!rr.ExclWed)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Wednesday);
}
if (!rr.ExclThu)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Thursday);
}
if (!rr.ExclFri)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Friday);
}
if (!rr.ExclSat)
{
AddToStaffIDDayIDHash(ref hash, ref rr, DayOfWeek.Saturday);
}
}
return(hash);
}
public static RegisterStaff[] GetAll()
{
DataTable tbl = GetDataTable_All();
RegisterStaff[] list = new RegisterStaff[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
list[i] = RegisterStaffDB.Load(tbl.Rows[i]);
list[i].Staff = StaffDB.Load(tbl.Rows[i], "staff_");
list[i].Staff.Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
list[i].Staff.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
list[i].Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_");
}
return(list);
}
// returns 2d hashtable
// get by: hash[new Hashtable2D.Key(staffID, orgID)]
public static Hashtable Get2DHashByStaffIDOrgID(int[] staff_ids = null)
{
string sql = JoinedSql + (staff_ids != null && staff_ids.Length > 0 ? @" AND r.staff_id IN(" + string.Join(",", staff_ids) + ")" : "");
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
Hashtable hash = new Hashtable();
for (int i = 0; i < tbl.Rows.Count; i++)
{
RegisterStaff rr = Load(tbl.Rows[i], "registration_provider_number");
rr.Staff = StaffDB.Load(tbl.Rows[i], "staff_");
rr.Staff.Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
rr.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_");
hash[new Hashtable2D.Key(rr.Staff.StaffID, rr.Organisation.OrganisationID)] = rr;
}
return(hash);
}
public static RegisterStaff GetByStaffIDAndOrganisationID(int staff_id, int organisation_id, bool inc_deleted = false)
{
string sql = JoinedSql + " AND r.staff_id = " + staff_id + " AND r.organisation_id = " + organisation_id + (inc_deleted ? "" : " AND r.is_deleted = 0 ");
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
if (tbl.Rows.Count == 0)
{
return(null);
}
else
{
RegisterStaff rr = Load(tbl.Rows[0], "registration_provider_number");
rr.Staff = StaffDB.Load(tbl.Rows[0], "staff_");
rr.Staff.Person = PersonDB.Load(tbl.Rows[0], "", "person_entity_id");
rr.Organisation = OrganisationDB.Load(tbl.Rows[0], "organisation_");
return(rr);
}
}
public static RegisterStaff GetByID(int register_staff_id)
{
string sql = JoinedSql + " AND register_staff_id = " + register_staff_id.ToString();
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
if (tbl.Rows.Count == 0)
{
return(null);
}
else
{
RegisterStaff rr = Load(tbl.Rows[0], "registration_provider_number");
rr.Staff = StaffDB.Load(tbl.Rows[0], "staff_");
rr.Staff.Person = PersonDB.Load(tbl.Rows[0], "", "person_entity_id");
rr.Organisation = OrganisationDB.Load(tbl.Rows[0], "organisation_");
return(rr);
}
}
public static Credit LoadAll(DataRow row)
{
Credit credit = Load(row, "credit_");
credit.CreditType = new IDandDescr(Convert.ToInt32(row["credittype_credit_type_id"]), Convert.ToString(row["credittype_descr"]));
if (row["vouchercredit_credit_id"] != DBNull.Value)
{
credit.VoucherCredit = CreditDB.Load(row, "vouchercredit_");
credit.VoucherCredit.CreditType = new IDandDescr(Convert.ToInt32(row["vouchercredittype_credit_type_id"]), Convert.ToString(row["vouchercredittype_descr"]));
}
if (row["added_by_staff_id"] != DBNull.Value)
{
credit.AddedBy = StaffDB.Load(row, "added_by_");
}
if (row["person_added_by_person_id"] != DBNull.Value)
{
credit.AddedBy.Person = PersonDB.Load(row, "person_added_by_");
credit.AddedBy.Person.Title = IDandDescrDB.Load(row, "title_added_by_title_id", "title_added_by_descr");
}
if (row["deleted_by_staff_id"] != DBNull.Value)
{
credit.DeletedBy = StaffDB.Load(row, "deleted_by_");
}
if (row["person_deleted_by_person_id"] != DBNull.Value)
{
credit.DeletedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr");
credit.DeletedBy.Person = PersonDB.Load(row, "person_deleted_by_");
}
if (row["modified_by_staff_id"] != DBNull.Value)
{
credit.ModifiedBy = StaffDB.Load(row, "modified_by_");
}
if (row["person_modified_by_person_id"] != DBNull.Value)
{
credit.ModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_modified_by_title_id", "title_modified_by_descr");
credit.ModifiedBy.Person = PersonDB.Load(row, "person_modified_by_");
}
return(credit);
}
public static StaffOfferings LoadAll(DataRow row)
{
StaffOfferings so = Load(row, "so_");
so.Offering = OfferingDB.Load(row, "o_");
so.Offering.OfferingType = IDandDescrDB.Load(row, "type_offering_type_id", "type_descr");
so.Offering.Field = IDandDescrDB.Load(row, "fld_field_id", "fld_descr");
so.Offering.AgedCarePatientType = IDandDescrDB.Load(row, "acpatientcat_aged_care_patient_type_id", "acpatientcat_descr");
so.Offering.OfferingInvoiceType = IDandDescrDB.Load(row, "invtype_offering_invoice_type_id", "invtype_descr");
so.Staff = StaffDB.Load(row, "staff_");
so.Staff.Person = PersonDB.Load(row, "person_");
so.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr");
so.Staff.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr");
so.Staff.StaffPosition = StaffPositionDB.Load(row, "staff_position_");
so.Staff.CostCentre = CostCentreDB.Load(row, "cost_centre_");
return(so);
}
public static Note LoadAll(DataRow row)
{
Note note = Load(row);
if (row["added_by_staff_id"] != DBNull.Value)
{
note.AddedBy = StaffDB.Load(row, "added_by_");
note.AddedBy.Person = PersonDB.Load(row, "added_by_person_");
note.AddedBy.Person.Title = IDandDescrDB.Load(row, "title_added_by_title_id", "title_added_by_descr");
}
if (row["modified_by_staff_id"] != DBNull.Value)
{
note.ModifiedBy = StaffDB.Load(row, "modified_by_");
note.ModifiedBy.Person = PersonDB.Load(row, "modified_by_person_");
note.ModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_modified_by_title_id", "title_modified_by_descr");
}
if (row["deleted_by_staff_id"] != DBNull.Value)
{
note.DeletedBy = StaffDB.Load(row, "deleted_by_");
note.DeletedBy.Person = PersonDB.Load(row, "deleted_by_person_");
note.DeletedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr");
}
if (row["site_id"] != DBNull.Value)
{
note.Site.Name = row["site_name"].ToString();
}
if (row["body_part_id"] != DBNull.Value)
{
note.BodyPart.Descr = row["body_part_descr"].ToString();
}
if (row["medical_service_type_id"] != DBNull.Value)
{
note.MedicalServiceType.Descr = row["medical_service_type_descr"].ToString();
}
if (row["note_type_id"] != DBNull.Value)
{
note.NoteType.Descr = row["note_type_descr"].ToString();
}
return(note);
}
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);
}
public static Staff[] GetStaffOf(int[] organistion_ids, bool providersOnly = false)
{
DataTable tbl = GetDataTable_StaffOf(organistion_ids);
ArrayList list = new ArrayList();
for (int i = 0; i < tbl.Rows.Count; i++)
{
Staff staff = StaffDB.Load(tbl.Rows[i]);
staff.Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
staff.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
staff.Field = IDandDescrDB.Load(tbl.Rows[i], "field_field_id", "field_descr");
if (staff.IsProvider || !providersOnly)
{
list.Add(staff);
}
}
return((Staff[])list.ToArray(typeof(Staff)));
}
public static Referral LoadAll(DataRow row)
{
Referral referral = Load(row);
referral.HealthCard = HealthCardDB.Load(row);
referral.MedicalServiceType = IDandDescrDB.Load(row, "mct_medical_service_type_id", "mct_descr");
referral.RegisterReferrer = RegisterReferrerDB.Load(row, "regref_");
referral.RegisterReferrer.Referrer = ReferrerDB.Load(row, "referrer_");
referral.RegisterReferrer.Referrer.Person = PersonDB.Load(row, "referrer_person_");
referral.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(row, "referrer_person_title_title_id", "referrer_person_title_descr");
if (row["organisation_organisation_id"] != DBNull.Value)
{
referral.RegisterReferrer.Organisation = OrganisationDB.Load(row, "organisation_");
}
if (row["added_or_last_modified_by_staff_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy = StaffDB.Load(row, "added_or_last_modified_by_");
}
if (row["person_added_or_last_modified_by_person_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy.Person = PersonDB.Load(row, "person_added_or_last_modified_by_");
referral.AddedOrLastModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_added_or_last_modified_by_title_id", "title_added_or_last_modified_by_descr");
}
if (row["deleted_by_staff_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy = StaffDB.Load(row, "deleted_by_");
}
if (row["person_deleted_by_person_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy.Person = PersonDB.Load(row, "person_deleted_by_");
referral.AddedOrLastModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr");
}
return(referral);
}
public static OfferingOrder LoadAll(DataRow row)
{
OfferingOrder o = Load(row, "offeringorder_");
if (row["organisation_organisation_id"] != DBNull.Value)
{
o.Organisation = OrganisationDB.Load(row, "organisation_");
o.Organisation.OrganisationType = OrganisationTypeDB.Load(row, "org_type_");
o.Organisation.OrganisationType.OrganisationTypeGroup = IDandDescrDB.Load(row, "typegroup_organisation_type_group_id", "typegroup_descr");
}
if (row["staff_staff_id"] != DBNull.Value)
{
o.Staff = StaffDB.Load(row, "staff_");
}
if (row["staff_staff_id"] != DBNull.Value)
{
o.Staff.Person = PersonDB.Load(row, "person_staff_");
o.Staff.Person.Title = IDandDescrDB.Load(row, "title_staff_title_id", "title_staff_descr");
}
if (row["patient_patient_id"] != DBNull.Value)
{
o.Patient = PatientDB.Load(row, "patient_");
}
if (row["patient_patient_id"] != DBNull.Value)
{
o.Patient.Person = PersonDB.Load(row, "person_patient_");
o.Patient.Person.Title = IDandDescrDB.Load(row, "title_patient_title_id", "title_patient_descr");
}
if (row["offering_offering_id"] != DBNull.Value)
{
o.Offering = OfferingDB.Load(row, "offering_");
}
if (row["offeringfield_field_id"] != DBNull.Value)
{
o.Offering.Field = IDandDescrDB.Load(row, "offeringfield_field_id", "offeringfield_descr");
}
return(o);
}
/*
* protected bool IsValidFormOrg()
* {
* string orgID = Request.QueryString["org"];
* return orgID != null && Regex.IsMatch(orgID, @"^\d+$") && OrganisationDB.Exists(Convert.ToInt32(orgID));
* }
* protected int GetFormOrg(bool checkIsValid = true)
* {
* if (checkIsValid && !IsValidFormOrg())
* throw new Exception("Invalid url org");
* return Convert.ToInt32(Request.QueryString["org"]);
* }
*
* protected bool IsValidFormOrgs()
* {
* string orgIDs = Request.QueryString["orgs"];
* return orgIDs != null && Regex.IsMatch(orgIDs, @"^[\d,]+$") && OrganisationDB.Exists(orgIDs);
* }
* protected string GetFormOrgs(bool checkIsValid = true)
* {
* if (checkIsValid && !IsValidFormOrgs())
* throw new Exception("Invalid url orgs");
* return Request.QueryString["orgs"];
* }
*/
#endregion
#region GrdStaff
protected void FillStaffGrid()
{
DataTable dt = StaffDB.GetDataTable_StaffInfo(false, false, false, false, txtSearchSurname.Text.Trim(), chkSurnameSearchOnlyStartWith.Checked);
bool onlyProviders = IsValidFormOnlyProviders() ? GetFormOnlyProviders(false) : false;
if (onlyProviders)
{
lblHeading.Text = "Providers";
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
if (!StaffDB.Load(dt.Rows[i]).IsProvider)
{
dt.Rows.RemoveAt(i);
}
}
}
Session["staff_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["staff_sortExpression"] != null && Session["staff_sortExpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["staff_sortExpression"].ToString();
GrdStaff.DataSource = dataView;
}
else
{
GrdStaff.DataSource = dt;
}
try
{
GrdStaff.DataBind();
// don't need paging -- already have scrolling -- and there won't be too many staff to send in one page
GrdStaff.PagerSettings.FirstPageText = "1";
GrdStaff.PagerSettings.LastPageText = GrdStaff.PageCount.ToString();
GrdStaff.DataBind();
}
catch (Exception ex)
{
this.lblErrorMessage.Visible = true;
this.lblErrorMessage.Text = ex.ToString();
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdStaff.DataSource = dt;
GrdStaff.DataBind();
int TotalColumns = GrdStaff.Rows[0].Cells.Count;
GrdStaff.Rows[0].Cells.Clear();
GrdStaff.Rows[0].Cells.Add(new TableCell());
GrdStaff.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdStaff.Rows[0].Cells[0].Text = "No Record Found";
}
}
public static LetterPrintHistory LoadAll(DataRow row)
{
LetterPrintHistory lph = Load(row, "lph_");
lph.Letter = LetterDB.Load(row, "letter_");
lph.SendMethod = new IDandDescr(Convert.ToInt32(row["lph_send_method_letter_print_history_send_method_id"]), Convert.ToString(row["lph_send_method_descr"]));
lph.Letter.LetterType = IDandDescrDB.Load(row, "lettertype_letter_type_id", "lettertype_descr");
if (row["letterorg_organisation_id"] != DBNull.Value)
{
lph.Letter.Organisation = OrganisationDB.Load(row, "letterorg_");
}
if (row["organisation_organisation_id"] != DBNull.Value)
{
lph.Organisation = OrganisationDB.Load(row, "organisation_");
}
if (row["patient_patient_id"] != DBNull.Value)
{
lph.Patient = PatientDB.Load(row, "patient_");
}
if (row["patient_patient_id"] != DBNull.Value)
{
lph.Patient.Person = PersonDB.Load(row, "person_patient_");
lph.Patient.Person.Title = IDandDescrDB.Load(row, "title_patient_title_id", "title_patient_descr");
}
if (row["staff_staff_id"] != DBNull.Value)
{
lph.Staff = StaffDB.Load(row, "staff_");
}
if (row["staff_staff_id"] != DBNull.Value)
{
lph.Staff.Person = PersonDB.Load(row, "person_staff_");
lph.Staff.Person.Title = IDandDescrDB.Load(row, "title_staff_title_id", "title_staff_descr");
}
if (row["regref_register_referrer_id"] != DBNull.Value)
{
lph.RegisterReferrer = RegisterReferrerDB.Load(row, "regref_");
}
if (row["regreforg_organisation_id"] != DBNull.Value)
{
lph.RegisterReferrer.Organisation = OrganisationDB.Load(row, "regreforg_");
}
if (row["referrer_referrer_id"] != DBNull.Value)
{
lph.RegisterReferrer.Referrer = ReferrerDB.Load(row, "referrer_");
}
if (row["referrer_referrer_id"] != DBNull.Value)
{
lph.RegisterReferrer.Referrer.Person = PersonDB.Load(row, "person_referrer_");
lph.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(row, "title_referrer_title_id", "title_referrer_descr");
}
if (row["lph_health_card_action_id"] != DBNull.Value)
{
lph.HealthCardAction = HealthCardActionDB.Load(row, "hca_");
lph.HealthCardAction.healthCardActionType = IDandDescrDB.Load(row, "hcat_health_card_action_type_id", "hcat_descr");
lph.HealthCardAction.HealthCard = HealthCardDB.Load(row, "hc_");
}
if (row["lph_booking_id"] != DBNull.Value)
{
lph.Booking = BookingDB.Load(row, "booking_");
}
return(lph);
}
