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 Site[] GetSitesNotRestricted(int staff_id = -1, int site_id = -1, bool only_clinic = false) { DataTable tbl = GetDataTable_SitesNotRestricted(staff_id, site_id, only_clinic); Site[] list = new Site[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = SiteDB.Load(tbl.Rows[i]); } 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); }
public static UserLogin LoadAll(DataRow row) { UserLogin userlogin = Load(row, "userlogin_"); if (row["userlogin_site_id"] != DBNull.Value) { userlogin.Site = SiteDB.Load(row, "site_"); } if (row["userlogin_staff_id"] != DBNull.Value) { userlogin.Staff = StaffDB.LoadAll(row); } if (row["userlogin_patient_id"] != DBNull.Value) { userlogin.Patient = PatientDB.Load(row, "patient_"); userlogin.Patient.Person = PersonDB.Load(row, "pperson_"); userlogin.Patient.Person.Title = IDandDescrDB.Load(row, "ttitle_title_id", "ttitle_descr"); } return(userlogin); }