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);
}
