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 Stock[] GetByOrg(int organisation_id) { string sql = JoinedSql + " AND s.organisation_id = " + organisation_id.ToString() + " ORDER BY o.name"; DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0]; Stock[] stockList = new Stock[tbl.Rows.Count]; for (int i = 0; i < tbl.Rows.Count; i++) { stockList[i] = StockDB.Load(tbl.Rows[i], "s_"); stockList[i].Offering = OfferingDB.Load(tbl.Rows[i], "o_"); } return(stockList); }
public static System.Collections.Hashtable GetHashByOrg(int org_id) { System.Collections.Hashtable orgOfferings = new System.Collections.Hashtable(); DataTable dt_orgOfferings = StockDB.GetDataTable_ByOrg(org_id); for (int i = 0; i < dt_orgOfferings.Rows.Count; i++) { Stock curStock = StockDB.Load(dt_orgOfferings.Rows[i], "s_"); curStock.Offering = OfferingDB.Load(dt_orgOfferings.Rows[i], "o_"); orgOfferings[curStock.Offering.OfferingID] = curStock; } return(orgOfferings); }
public static InvoiceLine LoadAll(DataRow row) { InvoiceLine line = Load(row); if (row["offering_id"] != DBNull.Value) { line.Offering = OfferingDB.Load(row); } if (row["patient_id"] != DBNull.Value) { line.Patient = PatientDB.Load(row, "patient_"); line.Patient.Person = PersonDB.Load(row, "patient_person_"); line.Patient.Person.Title = IDandDescrDB.Load(row, "title_patient_title_id", "title_patient_descr"); } return(line); }
public static DataTable AddIsActiveFieldToRows(DataTable dt_original) { DataTable dt = dt_original.Copy(); dt.Columns.Add("is_active", typeof(bool)); System.Collections.Hashtable offerings = new System.Collections.Hashtable(); for (int i = 0; i < dt.Rows.Count; i++) { OrganisationOfferings curOrgOffering = OrganisationOfferingsDB.Load(dt.Rows[i], "oo_"); curOrgOffering.Offering = OfferingDB.Load(dt.Rows[i], "o_"); if (curOrgOffering.DateActive.Date > DateTime.Today) // if date after today - ignore (its inactive) { continue; } if (offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)] == null) { offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)] = curOrgOffering; } else if (((OrganisationOfferings)offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)]).DateActive < curOrgOffering.DateActive) { offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)] = curOrgOffering; } else if (((OrganisationOfferings)offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)]).DateActive == curOrgOffering.DateActive && ((OrganisationOfferings)offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)]).OrganisationOfferingID > curOrgOffering.OrganisationOfferingID) { offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)] = curOrgOffering; } } for (int i = 0; i < dt.Rows.Count; i++) { OrganisationOfferings curOrgOffering = OrganisationOfferingsDB.Load(dt.Rows[i], "oo_"); curOrgOffering.Offering = OfferingDB.Load(dt.Rows[i], "o_"); OrganisationOfferings activeOrgOffering = (OrganisationOfferings)(offerings[new Hashtable2D.Key(curOrgOffering.Offering.OfferingID, curOrgOffering.Organisation.OrganisationID)]); dt.Rows[i]["is_active"] = curOrgOffering.OrganisationOfferingID == activeOrgOffering.OrganisationOfferingID; if (dt.Rows[i]["oo_date_active"] == DBNull.Value) { dt.Rows[i]["is_active"] = false; } } return(dt); }
public static System.Collections.Hashtable GetHashActiveByOrg(int org_id) { System.Collections.Hashtable activeOrgOfferings = new System.Collections.Hashtable(); DataTable dt_activeOrgOfferings = OrganisationOfferingsDB.GetDataTable_ByOrg(org_id); dt_activeOrgOfferings = OrganisationOfferingsDB.AddIsActiveFieldToRows(dt_activeOrgOfferings); for (int i = dt_activeOrgOfferings.Rows.Count - 1; i >= 0; i--) { if (Convert.ToBoolean(dt_activeOrgOfferings.Rows[i]["is_active"])) { OrganisationOfferings curOrgOffering = OrganisationOfferingsDB.Load(dt_activeOrgOfferings.Rows[i], "oo_"); curOrgOffering.Offering = OfferingDB.Load(dt_activeOrgOfferings.Rows[i], "o_"); activeOrgOfferings[curOrgOffering.Offering.OfferingID] = curOrgOffering; } } return(activeOrgOfferings); }
public static StaffOfferings LoadAll(DataRow row) { StaffOfferings so = Load(row, "so_"); so.Offering = OfferingDB.Load(row, "o_"); so.Offering.OfferingType = IDandDescrDB.Load(row, "type_offering_type_id", "type_descr"); so.Offering.Field = IDandDescrDB.Load(row, "fld_field_id", "fld_descr"); so.Offering.AgedCarePatientType = IDandDescrDB.Load(row, "acpatientcat_aged_care_patient_type_id", "acpatientcat_descr"); so.Offering.OfferingInvoiceType = IDandDescrDB.Load(row, "invtype_offering_invoice_type_id", "invtype_descr"); so.Staff = StaffDB.Load(row, "staff_"); so.Staff.Person = PersonDB.Load(row, "person_"); so.Staff.Person.Title = IDandDescrDB.Load(row, "title_title_id", "title_descr"); so.Staff.Field = IDandDescrDB.Load(row, "field_field_id", "field_descr"); so.Staff.StaffPosition = StaffPositionDB.Load(row, "staff_position_"); so.Staff.CostCentre = CostCentreDB.Load(row, "cost_centre_"); return(so); }
public static BookingPatientOffering LoadAll(DataRow row) { BookingPatientOffering bpo = Load(row, "bpo_"); bpo.Offering = OfferingDB.Load(row, "offering_"); bpo.Offering.Field = IDandDescrDB.Load(row, "offeringfield_field_id", "offeringfield_descr"); bpo.AddedBy = StaffDB.Load(row, "added_by_"); bpo.AddedBy.Person = PersonDB.Load(row, "added_by_person_"); bpo.AddedBy.Person.Title = IDandDescrDB.Load(row, "title_added_by_title_id", "title_added_by_descr"); if (row["deleted_by_person_person_id"] != DBNull.Value) { bpo.DeletedBy = StaffDB.Load(row, "deleted_by_"); bpo.DeletedBy.Person = PersonDB.Load(row, "deleted_by_person_"); bpo.DeletedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr"); } return(bpo); }
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); }
protected void FillGrid() { bool isAgedCareResidentTypes = IsValidIsAgedCareResidentTypes() ? GetFormIsAgedCareResidentTypes() : false; if (isAgedCareResidentTypes) { lblHeading.Text = "Aged Care Resident Types - Specific Prices Per Facility/Wing/Unit"; } Organisation org = null; if (IsValidFormID()) { org = OrganisationDB.GetByID(GetFormID()); } DataTable dt = org == null ? dt = OrganisationOfferingsDB.GetDataTable(false, UserView.GetInstance().IsClinicView ? 5 : 6) : OrganisationOfferingsDB.GetDataTable_ByOrg(org.OrganisationID); for (int i = dt.Rows.Count - 1; i >= 0; i--) { Offering o = OfferingDB.Load(dt.Rows[i], "o_"); if ((isAgedCareResidentTypes && o.AgedCarePatientType.ID == 1) || (!isAgedCareResidentTypes && o.AgedCarePatientType.ID != 1)) { dt.Rows.RemoveAt(i); } } dt = OrganisationOfferingsDB.AddIsActiveFieldToRows(dt); Session["registerofferingtoorg_data"] = dt; if (dt.Rows.Count > 0) { if (IsPostBack && Session["registerofferingtoorg_sortexpression"] != null && Session["registerofferingtoorg_sortexpression"].ToString().Length > 0) { DataView dataView = new DataView(dt); dataView.Sort = Session["registerofferingtoorg_sortexpression"].ToString(); GrdRegistration.DataSource = dataView; } else { GrdRegistration.DataSource = dt; } try { GrdRegistration.DataBind(); } catch (Exception ex) { SetErrorMessage("", ex.ToString()); } } else { dt.Rows.Add(dt.NewRow()); GrdRegistration.DataSource = dt; GrdRegistration.DataBind(); int TotalColumns = GrdRegistration.Rows[0].Cells.Count; GrdRegistration.Rows[0].Cells.Clear(); GrdRegistration.Rows[0].Cells.Add(new TableCell()); GrdRegistration.Rows[0].Cells[0].ColumnSpan = TotalColumns; GrdRegistration.Rows[0].Cells[0].Text = "No Record Found"; } if (hideFotter) { GrdRegistration.FooterRow.Visible = false; } }