public static Hashtable GetHashtableByReferrer(bool incDeleted = false) { Hashtable hashtable = new Hashtable(); DataTable tbl = DBBase.ExecuteQuery(JoinedSql(incDeleted, incDeleted, incDeleted)).Tables[0]; foreach (DataRow row in tbl.Rows) { if (row["organisation_id"] == DBNull.Value) { continue; } Referrer r = ReferrerDB.Load(row); r.Person = PersonDB.Load(row, "", "person_entity_id"); r.Person.Title = IDandDescrDB.Load(row, "title_id", "descr"); Organisation o = OrganisationDB.Load(row, "", "organisation_entity_id", "organisation_is_deleted"); if (hashtable[r.ReferrerID] == null) { hashtable[r.ReferrerID] = new ArrayList(); } ((ArrayList)hashtable[r.ReferrerID]).Add(o); } return(hashtable); }
public static HealthCardEPCRemaining LoadAll(DataRow row) { HealthCardEPCRemaining epcremaining = Load(row, "epcremaining_"); epcremaining.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr"); return(epcremaining); }
protected Tuple <Booking, PatientReferrer, bool, string, HealthCard> LoadRow(DataRow row) { Booking booking = BookingDB.Load(row, "booking_", true, false); booking.Offering = OfferingDB.Load(row, "offering_"); PatientReferrer pr = PatientReferrerDB.Load(row, "pr_"); pr.RegisterReferrer = RegisterReferrerDB.Load(row, "regref_"); pr.RegisterReferrer.Referrer = ReferrerDB.Load(row, "referrer_"); pr.RegisterReferrer.Referrer.Person = PersonDB.Load(row, "referrer_person_"); pr.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(row, "referrer_person_title_title_id", "referrer_person_title_descr"); if (row["organisation_organisation_id"] != DBNull.Value) { pr.RegisterReferrer.Organisation = OrganisationDB.Load(row, "organisation_"); } pr.Patient = PatientDB.Load(row, "patient_"); pr.Patient.Person = PersonDB.Load(row, "patient_person_"); pr.Patient.Person.Title = IDandDescrDB.Load(row, "patient_person_title_title_id", "patient_person_title_descr"); bool refHasEmail = Convert.ToInt32(row["ref_has_email"]) == 1; string refEmail = row["ref_email"] == DBNull.Value ? null : Convert.ToString(row["ref_email"]); HealthCard hc = HealthCardDB.Load(row, "hc_"); return(new Tuple <Booking, PatientReferrer, bool, string, HealthCard>(booking, pr, refHasEmail, refEmail, hc)); }
public static ContactType LoadAll(DataRow row) { ContactType at = Load(row, "at_"); at.ContactTypeGroup = IDandDescrDB.Load(row, "atg_contact_type_group_id", "atg_descr"); return(at); }
public static PatientReferrer GetByID(int patient_referrer_id) { //string sql = "SELECT patient_referrer_id,patient_id,register_referrer_id,patient_referrer_date_added,is_debtor,is_active FROM PatientReferrer WHERE patient_referrer_id = " + patient_referrer_id.ToString(); string sql = JoinedSQL() + " AND patient_referrer_id = " + patient_referrer_id.ToString(); DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; if (tbl.Rows.Count == 0) { return(null); } else { PatientReferrer pr = Load(tbl.Rows[0]); pr.Patient = PatientDB.Load(tbl.Rows[0]); pr.Patient.Person = PersonDB.Load(tbl.Rows[0], "patient_person_"); pr.Patient.Person.Title = IDandDescrDB.Load(tbl.Rows[0], "patient_person_title_title_id", "patient_person_title_descr"); if (tbl.Rows[0]["pr_register_referrer_id"] != DBNull.Value) { pr.RegisterReferrer = RegisterReferrerDB.Load(tbl.Rows[0]); pr.RegisterReferrer.Referrer = ReferrerDB.Load(tbl.Rows[0]); pr.RegisterReferrer.Referrer.Person = PersonDB.Load(tbl.Rows[0], "referrer_person_"); pr.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[0], "referrer_person_title_title_id", "referrer_person_title_descr"); pr.RegisterReferrer.Organisation = OrganisationDB.Load(tbl.Rows[0], "organisation_"); } if (tbl.Rows[0]["pr_organisation_id"] != DBNull.Value) { pr.Organisation = OrganisationDB.Load(tbl.Rows[0], "nonepcorg_"); } return(pr); } }
public static LetterBest LoadAll(DataRow row) { LetterBest letter = Load(row, "letter_"); letter.LetterType = IDandDescrDB.Load(row, "lettertype_letter_type_id", "lettertype_descr"); return(letter); }
public static ReferralRemaining LoadAll(DataRow row) { ReferralRemaining epcremaining = Load(row, "epcremaining_"); epcremaining.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr"); return(epcremaining); }
public static Person LoadAll(DataRow row) { Person p = Load(row); p.Title = IDandDescrDB.Load(row, "title_id", "descr"); return(p); }
public static Contact LoadAll(DataRow row) { Contact a = Load(row, "ad_"); a.ContactType = ContactTypeDB.Load(row, "at_"); a.ContactType.ContactTypeGroup = IDandDescrDB.Load(row, "atg_contact_type_group_id", "atg_descr"); if (row["act_address_channel_type_id"] != DBNull.Value) { a.AddressChannel = AddressChannelDB.Load(row, "ac_"); a.AddressChannel.AddressChannelType = IDandDescrDB.Load(row, "act_address_channel_type_id", "act_descr"); } if (row["s_suburb_id"] != DBNull.Value) { a.Suburb = SuburbDB.Load(row, "s_"); } if (row["c_country_id"] != DBNull.Value) { a.Country = IDandDescrDB.Load(row, "c_country_id", "c_descr"); } if (row["ad_site_id"] != DBNull.Value) { a.Site.Name = Convert.ToString(row["site_name"]); } return(a); }
protected void UpdateReferrersAtOrgList() { if (ddlOrgsList.SelectedIndex == -1) { return; } lblProvidersOf.Visible = true; lblSelectedOrg.Text = ddlOrgsList.Items[ddlOrgsList.SelectedIndex].Text; DataTable tbl = RegisterReferrerDB.GetDataTable_ReferrersOf(Convert.ToInt32(ddlOrgsList.Items[ddlOrgsList.SelectedIndex].Value)); RegisterReferrer[] regRefs = new RegisterReferrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { regRefs[i] = RegisterReferrerDB.Load(tbl.Rows[i]); regRefs[i].Referrer = ReferrerDB.Load(tbl.Rows[i]); regRefs[i].Referrer.Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id"); regRefs[i].Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr"); } string list = tbl.Rows.Count == 0 ? string.Empty : @"<table cellpadding=""0"" cellspacing=""0"">"; foreach (RegisterReferrer regRef in regRefs) { string url = "ReferrerList_DoctorClinicV2.aspx?surname_search=" + regRef.Referrer.Person.Surname + @"&surname_starts_with=1" + (regRef.ProviderNumber.Length > 0 ? "&provider_nbr_search=" + regRef.ProviderNumber + "&provider_nbr_starts_with=1" : ""); string href = @"<a href=""" + url + @""">" + regRef.Referrer.Person.FullnameWithoutMiddlename + "</a>"; list += "<tr><td>" + href + @"</td><td style=""width:8px;""> </td><td> Prov Nbr: " + (regRef.ProviderNumber.Trim().Length == 0 ? "[None]" : regRef.ProviderNumber) + "</td></tr>"; } list += tbl.Rows.Count == 0 ? string.Empty : "</table>"; lblProvidersOfSelectedOrg.Text = list.Length > 0 ? list : "None"; }
protected void GrdSummaryReport_RowDataBound(object sender, GridViewRowEventArgs e) { DataTable dt = Session["data_bookingswithoutsmsoremail"] as DataTable; bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value); if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow) { Label lblId = (Label)e.Row.FindControl("lblId"); DataRow[] foundRows = dt.Select("patient_id=" + lblId.Text); DataRow thisRow = foundRows[0]; Patient patient = PatientDB.Load(thisRow); patient.Person = PersonDB.Load(thisRow); patient.Person.Title = IDandDescrDB.Load(thisRow, "t_title_id", "t_descr"); Utilities.AddConfirmationBox(e); if ((e.Row.RowState & DataControlRowState.Edit) > 0) { Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow); } } if (e.Row.RowType == DataControlRowType.Footer) { } }
public static AddressChannel LoadAll(DataRow row) { AddressChannel ac = Load(row, "ac_"); ac.AddressChannelType = IDandDescrDB.Load(row, "act_address_channel_type_id", "act_descr"); return(ac); }
public static Referrer LoadAll(DataRow row, string staff_prefix = "", string person_prefix = "", string person_title_id = "title_id", string person_title_descr = "descr") { Referrer r = Load(row, staff_prefix); r.Person = PersonDB.Load(row, person_prefix); r.Person.Title = IDandDescrDB.Load(row, person_title_id, person_title_descr); return(r); }
public static Organisation LoadAll(DataRow row) { Organisation org = Load(row); org.OrganisationType = OrganisationTypeDB.Load(row, "type_"); org.OrganisationType.OrganisationTypeGroup = IDandDescrDB.Load(row, "typegroup_organisation_type_group_id", "typegroup_descr"); org.OrganisationCustomerTypeID = Convert.ToInt32(row["ct_organisation_customer_type_id"]); return(org); }
public static Offering LoadAll(DataRow row) { Offering o = Load(row, "o_"); o.OfferingType = IDandDescrDB.Load(row, "type_offering_type_id", "type_descr"); o.Field = IDandDescrDB.Load(row, "fld_field_id", "fld_descr"); o.AgedCarePatientType = IDandDescrDB.Load(row, "acpatientcat_aged_care_patient_type_id", "acpatientcat_descr"); o.OfferingInvoiceType = IDandDescrDB.Load(row, "invtype_offering_invoice_type_id", "invtype_descr"); return(o); }
public static PatientCondition LoadAll(DataRow row) { PatientCondition patientCondition = Load(row, "patient_condition_"); patientCondition.Condition = ConditionDB.Load(row, "condition_"); patientCondition.Patient = PatientDB.Load(row, "patient_"); patientCondition.Patient.Person = PersonDB.Load(row, "person_", "entity_id"); patientCondition.Patient.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr"); return(patientCondition); }
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 Staff LoadAll(DataRow row) { Staff staff = Load(row, "staff_"); staff.Person = PersonDB.Load(row, "person_"); staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr"); staff.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr"); staff.StaffPosition = StaffPositionDB.Load(row, "staff_position_"); staff.CostCentre = CostCentreDB.Load(row, "cost_centre_"); return(staff); }
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 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 Referrer[] LoadFull(DataTable tbl, string staff_prefix = "", string person_prefix = "", string person_title_id = "title_id", string person_title_descr = "descr") { Referrer[] list = new Referrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = Load(tbl.Rows[i], staff_prefix); list[i].Person = PersonDB.Load(tbl.Rows[i], person_prefix); list[i].Person.Title = IDandDescrDB.Load(tbl.Rows[i], person_title_id, person_title_descr); } return(list); }
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 Letter LoadAll(DataRow row) { Letter letter = Load(row, "letter_"); letter.LetterType = IDandDescrDB.Load(row, "lettertype_letter_type_id", "lettertype_descr"); letter.Site = SiteDB.Load(row, "site_"); if (row["letterorg_organisation_id"] != DBNull.Value) { letter.Organisation = OrganisationDB.Load(row, "letterorg_"); } return(letter); }
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 Referrer[] GetReferrersOf(int organistion_id, bool showDeletedRefs = false, bool showDeletedRegRefs = false) { DataTable tbl = GetDataTable_ReferrersOf(organistion_id, showDeletedRefs, showDeletedRegRefs); Referrer[] list = new Referrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = ReferrerDB.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 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 RegisterReferrer LoadAll(DataRow row) { RegisterReferrer rr = Load(row); rr.Referrer = ReferrerDB.Load(row); rr.Referrer.Person = PersonDB.Load(row, "", "person_entity_id"); rr.Referrer.Person.Title = IDandDescrDB.Load(row, "title_id", "descr"); if (row["organisation_id"] != DBNull.Value) { rr.Organisation = OrganisationDB.Load(row, "", "organisation_entity_id", "organisation_is_deleted"); } return(rr); }
public static Referrer[] GetAllNotInc(Referrer[] excList) { DataTable tbl = GetDataTable_AllNotInc(excList); Referrer[] list = new Referrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = ReferrerDB.Load(tbl.Rows[i]); list[i].Person = PersonDB.Load(tbl.Rows[i]); list[i].Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr"); } return(list); }
public static LetterTreatmentTemplate LoadAll(DataRow row) { LetterTreatmentTemplate letters = Load(row, "lettertreatmenttemplate_"); letters.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr"); letters.FirstLetter = LetterDB.Load(row, "firstletter_"); letters.FirstLetter.LetterType = IDandDescrDB.Load(row, "firstlettertype_letter_type_id", "firstlettertype_descr"); letters.FirstLetter.Site = SiteDB.Load(row, "firstsite_"); if (row["firstletterorg_organisation_id"] != DBNull.Value) { letters.FirstLetter.Organisation = OrganisationDB.Load(row, "firstletterorg_"); } letters.TreatmentNotesLetter = LetterDB.Load(row, "treatmentnotesletter_"); letters.TreatmentNotesLetter.LetterType = IDandDescrDB.Load(row, "treatmentnoteslettertype_letter_type_id", "treatmentnoteslettertype_descr"); letters.TreatmentNotesLetter.Site = SiteDB.Load(row, "treatmentnotessite_"); if (row["treatmentnotesletterorg_organisation_id"] != DBNull.Value) { letters.TreatmentNotesLetter.Organisation = OrganisationDB.Load(row, "treatmentnotesletterorg_"); } letters.LastLetter = LetterDB.Load(row, "lastletter_"); letters.LastLetter.LetterType = IDandDescrDB.Load(row, "lastlettertype_letter_type_id", "lastlettertype_descr"); letters.LastLetter.Site = SiteDB.Load(row, "lastsite_"); if (row["lastletterorg_organisation_id"] != DBNull.Value) { letters.LastLetter.Organisation = OrganisationDB.Load(row, "lastletterorg_"); } letters.LastLetterPT = LetterDB.Load(row, "lastletterpt_"); letters.LastLetterPT.LetterType = IDandDescrDB.Load(row, "lastlettertypept_letter_type_id", "lastlettertypept_descr"); letters.LastLetterPT.Site = SiteDB.Load(row, "lastsitept_"); if (row["lastletterorgpt_organisation_id"] != DBNull.Value) { letters.LastLetterPT.Organisation = OrganisationDB.Load(row, "lastletterorgpt_"); } letters.LastLetterWhenReplacingEPC = LetterDB.Load(row, "lastletterwhenreplacingepc_"); letters.LastLetterWhenReplacingEPC.LetterType = IDandDescrDB.Load(row, "lastletterwhenreplacingepctype_letter_type_id", "lastletterwhenreplacingepctype_descr"); letters.LastLetterWhenReplacingEPC.Site = SiteDB.Load(row, "lastwhenreplacingepcsite_"); if (row["lastletterorg_organisation_id"] != DBNull.Value) { letters.LastLetterWhenReplacingEPC.Organisation = OrganisationDB.Load(row, "lastletterwhenreplacingepcorg_"); } letters.Site = SiteDB.Load(row, "site_"); return(letters); }