protected void Sort(string sortExpression, params string[] sortExpr)
{
DataTable dataTable = Session["registerpatienttoorg_data"] as DataTable;
if (dataTable != null)
{
if (Session["registerpatienttoorg_sortexpression"] == null)
{
Session["registerpatienttoorg_sortexpression"] = "";
}
DataView dataView = new DataView(dataTable);
string[] sortData = Session["registerpatienttoorg_sortexpression"].ToString().Trim().Split(' ');
string newSortExpr = (sortExpr.Length == 0) ?
(sortExpression == sortData[0] && sortData[1] == "ASC") ? "DESC" : "ASC" :
sortExpr[0];
dataView.Sort = sortExpression + " " + newSortExpr;
Session["registerpatienttoorg_sortexpression"] = sortExpression + " " + newSortExpr;
GrdRegistration.DataSource = dataView;
GrdRegistration.DataBind();
}
}
protected void FillGrid()
{
Organisation org = null;
if (IsValidFormID())
{
org = OrganisationDB.GetByID(GetFormID());
}
DataTable dt = org == null ? dt = StockDB.GetDataTable(!UserView.GetInstance().IsAgedCareView ? 5 : 6) : dt = StockDB.GetDataTable_ByOrg(org.OrganisationID);
Session["registerstocktoorg_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["registerstocktoorg_sortexpression"] != null && Session["registerstocktoorg_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["registerstocktoorg_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 (org == null || hideFotter)
{
GrdRegistration.FooterRow.Visible = false;
}
}
protected void FillGrid()
{
if (!IsValidFormID())
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
Organisation org = OrganisationDB.GetByID(GetFormID());
if (org == null)
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
lblHeading.Text = Page.Title = "Manage Registrations For : " + org.Name;
this.lnkThisOrg.NavigateUrl = "~/OrganisationDetailV2.aspx?type=view&id=" + GetFormID().ToString();
this.lnkThisOrg.Text = "Back to details for " + org.Name;
string searchSurname = "";
if (Request.QueryString["surname_search"] != null && Request.QueryString["surname_search"].Length > 0)
{
searchSurname = Request.QueryString["surname_search"];
txtSearchSurname.Text = Request.QueryString["surname_search"];
}
bool searchSurnameOnlyStartsWith = true;
if (Request.QueryString["surname_starts_with"] != null && Request.QueryString["surname_starts_with"].Length > 0)
{
searchSurnameOnlyStartsWith = Request.QueryString["surname_starts_with"] == "0" ? false : true;
chkSurnameSearchOnlyStartWith.Checked = searchSurnameOnlyStartsWith;
}
else
{
chkSurnameSearchOnlyStartWith.Checked = searchSurnameOnlyStartsWith;
}
DataTable dt = RegisterPatientDB.GetDataTable_PatientsOf(GetFormViewOnlyLast(), org.OrganisationID, false, false, false, false, searchSurname, searchSurnameOnlyStartsWith);
int[] ptIDs = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
ptIDs[i] = Convert.ToInt32(dt.Rows[i]["patient_id"]);
}
// get last and next booking dates
Hashtable lastBookingDates = BookingDB.GetLastBookingDates(ptIDs, org.OrganisationID);
Hashtable nextBookingDates = BookingDB.GetNextBookingDates(ptIDs, org.OrganisationID);
dt.Columns.Add("last_booking_date", typeof(DateTime));
dt.Columns.Add("next_booking_date", typeof(DateTime));
for (int i = 0; i < dt.Rows.Count; i++)
{
dt.Rows[i]["last_booking_date"] = lastBookingDates[Convert.ToInt32(dt.Rows[i]["patient_id"])] == null ? (object)DBNull.Value : (DateTime)lastBookingDates[Convert.ToInt32(dt.Rows[i]["patient_id"])];
dt.Rows[i]["next_booking_date"] = nextBookingDates[Convert.ToInt32(dt.Rows[i]["patient_id"])] == null ? (object)DBNull.Value : (DateTime)nextBookingDates[Convert.ToInt32(dt.Rows[i]["patient_id"])];
}
// get epc info
Hashtable mostRecentRecallHashByPatientID = LetterPrintHistoryDB.GetMostRecentRecallHashByPatients(ptIDs);
Hashtable patientHealthCardCache = PatientsHealthCardsCacheDB.GetBullkActive(ptIDs);
Hashtable epcRemainingCache = GetEPCRemainingCache(patientHealthCardCache);
Hashtable patientsMedicareCountCache = PatientsMedicareCardCountThisYearCacheDB.GetBullk(ptIDs, DateTime.Today.Year);
Hashtable patientsEPCRemainingCache = PatientsEPCRemainingCacheDB.GetBullk(ptIDs, DateTime.Today.AddYears(-1));
int MedicareMaxNbrServicesPerYear = Convert.ToInt32(SystemVariableDB.GetByDescr("MedicareMaxNbrServicesPerYear").Value);
dt.Columns.Add("epc_expire_date", typeof(DateTime));
dt.Columns.Add("has_valid_epc", typeof(Boolean));
dt.Columns.Add("epc_count_remaining", typeof(Int32));
dt.Columns.Add("most_recent_recall_sent", typeof(DateTime));
for (int i = dt.Rows.Count - 1; i >= 0; i--)
{
int patientID = Convert.ToInt32(dt.Rows[i]["patient_id"]);
HealthCard hc = GetHealthCardFromCache(patientHealthCardCache, patientID);
bool hasEPC = hc != null && hc.DateReferralSigned != DateTime.MinValue;
HealthCardEPCRemaining[] epcsRemaining = !hasEPC ? new HealthCardEPCRemaining[] { } : GetEPCRemainingFromCache(epcRemainingCache, hc);
int totalServicesAllowedLeft = !hasEPC ? 0 : (MedicareMaxNbrServicesPerYear - (int)patientsMedicareCountCache[patientID]);
int totalEpcsRemaining = 0;
for (int j = 0; j < epcsRemaining.Length; j++)
{
totalEpcsRemaining += epcsRemaining[j].NumServicesRemaining;
}
DateTime referralSignedDate = !hasEPC ? DateTime.MinValue : hc.DateReferralSigned.Date;
DateTime hcExpiredDate = !hasEPC ? DateTime.MinValue : referralSignedDate.AddYears(1);
bool isExpired = !hasEPC ? true : hcExpiredDate <= DateTime.Today;
int nServicesLeft = 0;
if (hc != null && DateTime.Today >= referralSignedDate.Date && DateTime.Today < hcExpiredDate.Date)
{
nServicesLeft = totalEpcsRemaining;
}
if (hc != null && totalServicesAllowedLeft < nServicesLeft)
{
nServicesLeft = totalServicesAllowedLeft;
}
bool has_valid_epc = hasEPC && !isExpired && (hc.Organisation.OrganisationID == -2 || (hc.Organisation.OrganisationID == -1 && nServicesLeft > 0));
int epc_count_remaining = hasEPC && hc.Organisation.OrganisationID == -1 ? nServicesLeft : -1;
dt.Rows[i]["has_valid_epc"] = has_valid_epc;
dt.Rows[i]["epc_expire_date"] = hasEPC ? hcExpiredDate : (object)DBNull.Value;
dt.Rows[i]["epc_count_remaining"] = epc_count_remaining != -1 ? epc_count_remaining : (object)DBNull.Value;
dt.Rows[i]["most_recent_recall_sent"] = mostRecentRecallHashByPatientID[patientID] == null ? (object)DBNull.Value : ((LetterPrintHistory)mostRecentRecallHashByPatientID[patientID]).Date;
}
Session["registerpatienttoorg_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["registerpatienttoorg_sortexpression"] != null && Session["registerpatienttoorg_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["registerpatienttoorg_sortexpression"].ToString();
GrdRegistration.DataSource = dataView;
}
else
{
GrdRegistration.DataSource = dt;
}
try
{
GrdRegistration.DataBind();
GrdRegistration.PagerSettings.FirstPageText = "1";
GrdRegistration.PagerSettings.LastPageText = GrdRegistration.PageCount.ToString();
GrdRegistration.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", 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;
}
}
protected void FillGrid()
{
if (!IsValidFormID())
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
Staff staff = StaffDB.GetByID(GetFormID());
if (staff == null)
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
staff.Person = PersonDB.GetByID(staff.Person.PersonID);
lblHeading.Text = Page.Title = "Manage Clinics/Facilities For : " + staff.Person.Firstname + " " + staff.Person.Surname;
this.lnkThisStaff.NavigateUrl = staff.IsExternal ? "~/StaffDetailExternalV2.aspx?type=view&id=" + GetFormID().ToString() : "~/StaffDetailV2.aspx?type=view&id=" + GetFormID().ToString();
this.lnkThisStaff.Text = "Back to details for " + staff.Person.Firstname + " " + staff.Person.Surname;
if (staff.IsExternal)
{
GrdRegistration.Columns[3].Visible = false;
GrdRegistration.Columns[4].Visible = false;
GrdRegistration.Columns[5].Visible = false;
GrdRegistration.Columns[6].Visible = false;
GrdRegistration.Columns[7].Visible = false;
GrdRegistration.Columns[8].Visible = false;
GrdRegistration.Columns[9].Visible = false;
GrdRegistration.Columns[10].Visible = false;
GrdRegistration.Columns[11].Visible = false;
}
DataTable dt = RegisterStaffDB.GetDataTable_OrganisationsOf(staff.StaffID, null, chkShowDeleted.Checked);
Session["registerorgtostaff_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["registerorgtostaff_sortexpression"] != null && Session["registerorgtostaff_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["registerorgtostaff_sortexpression"].ToString();
GrdRegistration.DataSource = dataView;
}
else
{
GrdRegistration.DataSource = dt;
}
try
{
GrdRegistration.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", 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;
}
}
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;
}
}
protected void FillGrid()
{
if (!IsValidFormID())
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
Organisation org = OrganisationDB.GetByID(GetFormID());
if (org == null)
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
lblHeading.Text = Page.Title = "Manage Registrations For : " + org.Name;
this.lnkThisOrg.NavigateUrl = "~/OrganisationDetailV2.aspx?type=view&id=" + GetFormID().ToString();
this.lnkThisOrg.Text = "Back to details for " + org.Name;
DataTable dt = RegisterReferrerDB.GetDataTable_ReferrersOf(org.OrganisationID);
Session["registerreferrertoorg_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["registerreferrertoorg_sortexpression"] != null && Session["registerreferrertoorg_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["registerreferrertoorg_sortexpression"].ToString();
GrdRegistration.DataSource = dataView;
}
else
{
GrdRegistration.DataSource = dt;
}
try
{
GrdRegistration.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", 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;
}
}
protected void FillGrid()
{
if (!IsValidFormID())
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
Patient patient = PatientDB.GetByID(GetFormID());
if (patient == null)
{
HideTableAndSetErrorMessage(Utilities.IsDev() ? "No patient exists with this ID" : "");
return;
}
patient.Person = PersonDB.GetByID(patient.Person.PersonID);
lblHeading.Text = Page.Title = "Manage Registrations For : " + patient.Person.Firstname + " " + patient.Person.Surname;
this.lnkThisPatient.NavigateUrl = "~/PatientDetailV2.aspx?type=view&id=" + GetFormID().ToString();
this.lnkThisPatient.Text = "Back to details for " + patient.Person.FullnameWithoutMiddlename;
DataTable dt = RegisterPatientDB.GetDataTable_OrganisationsOf(patient.PatientID);
Session["registerorgtopatient_data"] = dt;
spn_booking_screen_link.Visible = UserView.GetInstance().IsAdminView;
lblSelectOrgBeforeBooking.Visible = dt.Rows.Count == 0 && GetUrlParamType() == UrlParamType.SelectToGoToBookings;
lnkBookingScreen.Visible = dt.Rows.Count > 0;
lnkBookingScreen.NavigateUrl = String.Format("~/BookingScreenGetPatientOrgsV2.aspx?patient_id={0}", Request["id"]);
lnkBookingScreen.Text = "Make Booking";
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["registerorgtopatient_sortexpression"] != null && Session["registerorgtopatient_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["registerorgtopatient_sortexpression"].ToString();
GrdRegistration.DataSource = dataView;
}
else
{
GrdRegistration.DataSource = dt;
}
try
{
GrdRegistration.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", 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;
}
}
