public static LetterTreatmentTemplate[] GetAll(int site_id = -1) { DataTable tbl = GetDataTable(site_id); LetterTreatmentTemplate[] list = new LetterTreatmentTemplate[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { list[i] = LoadAll(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 LetterTreatmentTemplate[] GetAll(int site_id = -1) { DataTable tbl = GetDataTable(site_id); LetterTreatmentTemplate[] list = new LetterTreatmentTemplate[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) list[i] = LoadAll(tbl.Rows[i]); return list; }