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