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 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 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); }
protected static Hashtable GetPatientRegOrgCache(Patient[] patients) { ArrayList patientIDArrayList = new ArrayList(); foreach (Patient patient in patients) { patientIDArrayList.Add(patient.PatientID); } int[] patientIDs = (int[])patientIDArrayList.ToArray(typeof(int)); Hashtable regOrgHash = new Hashtable(); System.Data.DataTable tbl = RegisterPatientDB.GetDataTable_OrganisationsOf(patientIDs, true, false, false, true, true); for (int i = 0; i < tbl.Rows.Count; i++) { int patientID = Convert.ToInt32(tbl.Rows[i]["patient_id"]); Organisation org = OrganisationDB.Load(tbl.Rows[i], "", "organisation_entity_id", "organisation_is_deleted"); if (regOrgHash[patientID] == null) { regOrgHash[patientID] = new System.Collections.ArrayList(); } ((System.Collections.ArrayList)regOrgHash[patientID]).Add(org); } return(regOrgHash); }
public static Organisation[] GetOrganisationsOf(int staff_id) { DataTable tbl = GetDataTable_OrganisationsOf(staff_id); Organisation[] list = new Organisation[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = OrganisationDB.Load(tbl.Rows[i], "", "organisation_entity_id", "organisation_is_deleted"); } return(list); }
public static Organisation[] GetAllNotInc(Organisation[] excList, bool exclGroupOrg = true, bool exclIns = true) { DataTable tbl = GetDataTable_AllNotInc(excList, exclGroupOrg, false, false, exclIns); Organisation[] list = new Organisation[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = OrganisationDB.Load(tbl.Rows[i]); } return(list); }
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 Organisation[] GetChildrenOf(int parent_organisation_id) { string sql = JoinedSql + @" WHERE o.is_deleted = 0 AND o.parent_organisation_id = " + parent_organisation_id.ToString() + " ORDER BY o.name"; DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; Organisation[] list = new Organisation[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = OrganisationDB.Load(tbl.Rows[i]); } 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 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); }
private static RegisterReferrer[] _GetEPCReferrersOf(int patient_id, bool onlyActive) { DataTable tbl = onlyActive ? GetDataTable_ActiveEPCReferrersOf(patient_id) : GetDataTable_EPCReferrersOf(patient_id); RegisterReferrer[] list = new RegisterReferrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { RegisterReferrer rr = RegisterReferrerDB.Load(tbl.Rows[i], "regref_"); rr.Referrer = ReferrerDB.Load(tbl.Rows[i], "referrer_"); rr.Referrer.Person = PersonDB.Load(tbl.Rows[i], "referrer_person_"); rr.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "referrer_person_title_title_id", "referrer_person_title_descr"); rr.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_"); list[i] = rr; } return(list); }
// 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 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 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); }
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); } }
// 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); }
protected string GetLine(int id, Person p, string colSep, string rowSep, bool incRowSep, bool incDOB, bool incAddresses, bool incPhoneNbrs, bool incRefInfo) { string result = string.Empty; if (incRowSep) { result += rowSep; } result += id.ToString() + colSep + p.Firstname + colSep + p.Middlename + colSep + p.Surname; if (incDOB) { result += colSep + (p.Dob == DateTime.MinValue ? "" : p.Dob.ToString("dd-MM-yyyy")); } if (incAddresses) { result += colSep + GetAddresses(p.EntityID); } if (incPhoneNbrs) { result += colSep + GetPhoneNbrs(p.EntityID); } if (incRefInfo) { string orgNames = string.Empty; string provNbrs = string.Empty; System.Data.DataTable tbl = RegisterReferrerDB.GetDataTable_OrganisationsOf(id); RegisterReferrer[] list = new RegisterReferrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = RegisterReferrerDB.Load(tbl.Rows[i]); list[i].Organisation = OrganisationDB.Load(tbl.Rows[i], "", "organisation_entity_id", "organisation_is_deleted"); orgNames += (orgNames.Length == 0 ? "" : "\r\n") + list[i].Organisation.Name; provNbrs += (provNbrs.Length == 0 ? "" : "\r\n") + list[i].ProviderNumber; } result += colSep + orgNames; result += colSep + provNbrs; } return(result); }
protected void GrdReferrer_RowUpdating(object sender, GridViewUpdateEventArgs e) { Label lblId = (Label)GrdReferrer.Rows[e.RowIndex].FindControl("lblId"); DropDownList ddlTitle = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlTitle"); TextBox txtFirstname = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtFirstname"); TextBox txtMiddlename = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtMiddlename"); TextBox txtSurname = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtSurname"); DropDownList ddlGender = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlGender"); TextBox txtName = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtName"); TextBox txtABN = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtABN"); TextBox txtACN = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtACN"); TextBox txtProviderNumber = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtProviderNumber"); DropDownList ddlIsClinic = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlIsClinic"); CheckBox chkIsReportEveryVisit = (CheckBox)GrdReferrer.Rows[e.RowIndex].FindControl("chkIsReportEveryVisit"); CheckBox chkIsBatchSendAllPatientsTreatmentNotes = (CheckBox)GrdReferrer.Rows[e.RowIndex].FindControl("chkIsBatchSendAllPatientsTreatmentNotes"); int registger_referrer_id = Convert.ToInt32(lblId.Text); DataTable dt = Session["referrerinfolist_data"] as DataTable; DataRow[] foundRows = dt.Select("register_referrer_id=" + registger_referrer_id.ToString()); DataRow row = foundRows[0]; RegisterReferrer rr = RegisterReferrerDB.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"); } PersonDB.Update(rr.Referrer.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), row["nickname"].ToString(), ddlGender.SelectedValue, row["dob"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(row["dob"]), DateTime.Now); OrganisationDB.UpdateExtOrg(rr.Organisation.OrganisationID, rr.Organisation.OrganisationType.OrganisationTypeID, txtName.Text, txtACN.Text, txtABN.Text, DateTime.Now, rr.Organisation.IsDebtor, rr.Organisation.IsCreditor, rr.Organisation.BpayAccount, rr.Organisation.Comment); RegisterReferrerDB.Update(rr.RegisterReferrerID, rr.Organisation.OrganisationID, rr.Referrer.ReferrerID, txtProviderNumber.Text, chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked, rr.DateLastBatchSendAllPatientsTreatmentNotes); GrdReferrer.EditIndex = -1; FillGrid(); }
// hashtable: patient_id => RegisterReferrer[] public static Hashtable GetEPCReferrersOf(int[] patient_ids, bool onlyActive) { string sql = JoinedSQL() + @" AND " + (patient_ids != null && patient_ids.Length > 0 ? " pat.patient_id IN (" + string.Join(",", patient_ids) + @")" : "1 <> 1") + @" " + (onlyActive ? " AND pr.is_active = 1 " : "") + @" ORDER BY patient_referrer_date_added"; DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; Hashtable hash = new Hashtable(); for (int i = 0; i < tbl.Rows.Count; i++) { RegisterReferrer rr = RegisterReferrerDB.Load(tbl.Rows[i], "regref_"); rr.Referrer = ReferrerDB.Load(tbl.Rows[i], "referrer_"); rr.Referrer.Person = PersonDB.Load(tbl.Rows[i], "referrer_person_"); rr.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "referrer_person_title_title_id", "referrer_person_title_descr"); rr.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_"); int patient_id = Convert.ToInt32(tbl.Rows[i]["pr_patient_id"]); if (hash[patient_id] == null) { hash[patient_id] = new System.Collections.ArrayList(); } ((System.Collections.ArrayList)hash[patient_id]).Add(rr); } // convert from arraylists to arrays ArrayList keys = new ArrayList(); foreach (System.Collections.DictionaryEntry de in hash) { keys.Add(de.Key); } foreach (int key in keys) { hash[key] = (RegisterReferrer[])((ArrayList)hash[key]).ToArray(typeof(RegisterReferrer)); } ; return(hash); }
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); }
public static PatientReferrer LoadAll(DataRow row) { 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"); if (row["nonepcorg_entity_id"] != DBNull.Value) { pr.Organisation = OrganisationDB.Load(row, "nonepcorg_"); } return(pr); }
private static PatientReferrer[] _GetEPCPatientReferrersOf(int patient_id, bool onlyActive) { DataTable tbl = onlyActive ? GetDataTable_ActiveEPCReferrersOf(patient_id) : GetDataTable_EPCReferrersOf(patient_id); PatientReferrer[] list = new PatientReferrer[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { PatientReferrer pr = Load(tbl.Rows[i], "pr_"); pr.RegisterReferrer = RegisterReferrerDB.Load(tbl.Rows[i], "regref_"); pr.RegisterReferrer.Referrer = ReferrerDB.Load(tbl.Rows[i], "referrer_"); pr.RegisterReferrer.Referrer.Person = PersonDB.Load(tbl.Rows[i], "referrer_person_"); pr.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "referrer_person_title_title_id", "referrer_person_title_descr"); if (tbl.Rows[i]["organisation_organisation_id"] != DBNull.Value) { pr.RegisterReferrer.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_"); } pr.Patient = PatientDB.Load(tbl.Rows[i], "patient_"); pr.Patient.Person = PersonDB.Load(tbl.Rows[i], "patient_person_"); pr.Patient.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "patient_person_title_title_id", "patient_person_title_descr"); list[i] = pr; } return(list); }
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); }
protected void GrdRegistration_RowDataBound(object sender, GridViewRowEventArgs e) { UserView userView = UserView.GetInstance(); Organisation org = null; if (IsValidFormID()) { org = OrganisationDB.GetByID(GetFormID()); } DataTable dt = Session["registerofferingtoorg_data"] 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("oo_organisation_offering_id=" + lblId.Text); DataRow thisRow = foundRows[0]; DropDownList ddlOffering = (DropDownList)e.Row.FindControl("ddlOffering"); if (ddlOffering != null) { //Offering[] incList_orig = OrganisationOfferingsDB.GetOfferingsByOrg(false, Convert.ToInt32(thisRow["organisation_organisation_id"])); //Offering[] incList = Offering.RemoveByID(incList_orig, Convert.ToInt32(thisRow["o_offering_id"])); //DataTable offering = OfferingDB.GetDataTable_AllNotInc(incList); //DataTable offering = OfferingDB.GetDataTable_AllNotInc(incList); string offering_invoice_type_ids = "-1"; if (userView.IsAgedCareView) { offering_invoice_type_ids = "3,4"; // 4 = AC } else if (userView.IsClinicView) { offering_invoice_type_ids = "1,3"; // 1 = Clinic } else { throw new Exception("Logged in to neither clinic nor aged care"); } bool isAgedCareResidentTypes = IsValidIsAgedCareResidentTypes() ? GetFormIsAgedCareResidentTypes() : false; DataTable offering = OfferingDB.GetDataTable(isAgedCareResidentTypes, offering_invoice_type_ids); offering.DefaultView.Sort = "o_name ASC"; foreach (DataRowView row in offering.DefaultView) { ddlOffering.Items.Add(new ListItem(row["o_name"].ToString(), row["o_offering_id"].ToString())); } ddlOffering.SelectedValue = thisRow["o_offering_id"].ToString(); } Utilities.AddConfirmationBox(e); if ((e.Row.RowState & DataControlRowState.Edit) > 0) { Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow); } } if (e.Row.RowType == DataControlRowType.Footer) { Label lblOrganisation = (Label)e.Row.FindControl("lblNewOrganisation"); if (lblOrganisation != null) { lblOrganisation.Text = org.Name; } DropDownList ddlOffering = (DropDownList)e.Row.FindControl("ddlNewOffering"); if (ddlOffering != null) { DropDownList ddlOrganisation = (DropDownList)e.Row.FindControl("ddlNewOrganisation"); DataTable organisation = OrganisationDB.GetDataTable(0, false, true, !userView.IsClinicView, !userView.IsAgedCareView, true, true); DataView dataView = new DataView(organisation); dataView.Sort = "name"; organisation = dataView.ToTable(); for (int i = 0; i < organisation.Rows.Count; i++) { Organisation o = OrganisationDB.Load(organisation.Rows[i]); ddlOrganisation.Items.Add(new ListItem(o.Name, o.OrganisationID.ToString())); } if (org != null) { ddlOrganisation.SelectedValue = org.OrganisationID.ToString(); } //Offering[] incList = OrganisationOfferingsDB.GetOfferingsByOrg(false, org.OrganisationID); //DataTable offering = OfferingDB.GetDataTable_AllNotInc(incList); string offering_invoice_type_ids = "-1"; if (userView.IsAgedCareView) { offering_invoice_type_ids = "1,2,3,4"; // 4 = AC } else if (userView.IsClinicView) { offering_invoice_type_ids = "1,2,3"; // 1 = Clinic } else { throw new Exception("Logged in to neither clinic nor aged care"); } bool isAgedCareResidentTypes = IsValidIsAgedCareResidentTypes() ? GetFormIsAgedCareResidentTypes() : false; DataTable offering = OfferingDB.GetDataTable(isAgedCareResidentTypes, offering_invoice_type_ids); DataView dv = new DataView(offering); dv.Sort = "o_name ASC"; offering = dv.ToTable(); foreach (DataRow row in offering.Rows) { ddlOffering.Items.Add(new ListItem(row["o_name"].ToString(), row["o_offering_id"].ToString())); } if (offering.Rows.Count == 0 || organisation.Rows.Count == 0) { hideFotter = true; } } } }