protected void btnSetExistingReferrer_Click(object sender, EventArgs e)
{
Referrer referrer = ReferrerDB.GetByID(Convert.ToInt32(jsSetId.Value));
if (referrer == null)
{
lblId.Text = "-1";
SetErrorMessage("Error getting selected referrer. Plase contact the system administrator.<br />");
}
else
{
lblId.Text = referrer.ReferrerID.ToString();
ddlTitle.SelectedValue = referrer.Person.Title.ID.ToString();
txtFirstname.Text = referrer.Person.Firstname;
txtMiddlename.Text = referrer.Person.Middlename;
txtSurname.Text = referrer.Person.Surname;
if (ddlGender.Items.FindByValue(referrer.Person.Gender) == null)
{
ddlGender.Items.Add(new ListItem(referrer.Person.Gender == "" ? "--" : referrer.Person.Gender, referrer.Person.Gender));
}
ddlGender.SelectedValue = referrer.Person.Gender;
ddlTitle.Enabled = false;
txtFirstname.Enabled = false;
txtMiddlename.Enabled = false;
txtSurname.Enabled = false;
ddlGender.Enabled = false;
}
}
public static PatientReferrer GetByID(int patient_referrer_id)
{
//string sql = "SELECT patient_referrer_id,patient_id,register_referrer_id,patient_referrer_date_added,is_debtor,is_active FROM PatientReferrer WHERE patient_referrer_id = " + patient_referrer_id.ToString();
string sql = JoinedSQL() + " AND patient_referrer_id = " + patient_referrer_id.ToString();
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
if (tbl.Rows.Count == 0)
{
return(null);
}
else
{
PatientReferrer pr = Load(tbl.Rows[0]);
pr.Patient = PatientDB.Load(tbl.Rows[0]);
pr.Patient.Person = PersonDB.Load(tbl.Rows[0], "patient_person_");
pr.Patient.Person.Title = IDandDescrDB.Load(tbl.Rows[0], "patient_person_title_title_id", "patient_person_title_descr");
if (tbl.Rows[0]["pr_register_referrer_id"] != DBNull.Value)
{
pr.RegisterReferrer = RegisterReferrerDB.Load(tbl.Rows[0]);
pr.RegisterReferrer.Referrer = ReferrerDB.Load(tbl.Rows[0]);
pr.RegisterReferrer.Referrer.Person = PersonDB.Load(tbl.Rows[0], "referrer_person_");
pr.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[0], "referrer_person_title_title_id", "referrer_person_title_descr");
pr.RegisterReferrer.Organisation = OrganisationDB.Load(tbl.Rows[0], "organisation_");
}
if (tbl.Rows[0]["pr_organisation_id"] != DBNull.Value)
{
pr.Organisation = OrganisationDB.Load(tbl.Rows[0], "nonepcorg_");
}
return(pr);
}
}
public static Hashtable GetHashtableByReferrer(bool incDeleted = false)
{
Hashtable hashtable = new Hashtable();
DataTable tbl = DBBase.ExecuteQuery(JoinedSql(incDeleted, incDeleted, incDeleted)).Tables[0];
foreach (DataRow row in tbl.Rows)
{
if (row["organisation_id"] == DBNull.Value)
{
continue;
}
Referrer r = ReferrerDB.Load(row);
r.Person = PersonDB.Load(row, "", "person_entity_id");
r.Person.Title = IDandDescrDB.Load(row, "title_id", "descr");
Organisation o = OrganisationDB.Load(row, "", "organisation_entity_id", "organisation_is_deleted");
if (hashtable[r.ReferrerID] == null)
{
hashtable[r.ReferrerID] = new ArrayList();
}
((ArrayList)hashtable[r.ReferrerID]).Add(o);
}
return(hashtable);
}
protected void GrdReferrer_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblId = (Label)GrdReferrer.Rows[e.RowIndex].FindControl("lblId");
DropDownList ddlTitle = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlTitle");
TextBox txtFirstname = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtFirstname");
TextBox txtMiddlename = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtMiddlename");
TextBox txtSurname = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtSurname");
DropDownList ddlGender = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlGender");
Referrer referrer = ReferrerDB.GetByID(Convert.ToInt32(lblId.Text));
if (referrer != null)
{
if (referrer.Person.Title.ID != Convert.ToInt32(ddlTitle.SelectedValue) ||
referrer.Person.Firstname != Utilities.FormatName(txtFirstname.Text) ||
referrer.Person.Middlename != Utilities.FormatName(txtMiddlename.Text) ||
referrer.Person.Surname != Utilities.FormatName(txtSurname.Text) ||
referrer.Person.Gender != ddlGender.SelectedValue)
{
PersonDB.Update(referrer.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), referrer.Person.Nickname, ddlGender.SelectedValue, referrer.Person.Dob, DateTime.Now);
}
}
GrdReferrer.EditIndex = -1;
FillGrid();
}
protected void UpdateReferrersAtOrgList()
{
if (ddlOrgsList.SelectedIndex == -1)
{
return;
}
lblProvidersOf.Visible = true;
lblSelectedOrg.Text = ddlOrgsList.Items[ddlOrgsList.SelectedIndex].Text;
DataTable tbl = RegisterReferrerDB.GetDataTable_ReferrersOf(Convert.ToInt32(ddlOrgsList.Items[ddlOrgsList.SelectedIndex].Value));
RegisterReferrer[] regRefs = new RegisterReferrer[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
regRefs[i] = RegisterReferrerDB.Load(tbl.Rows[i]);
regRefs[i].Referrer = ReferrerDB.Load(tbl.Rows[i]);
regRefs[i].Referrer.Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
regRefs[i].Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
}
string list = tbl.Rows.Count == 0 ? string.Empty : @"<table cellpadding=""0"" cellspacing=""0"">";
foreach (RegisterReferrer regRef in regRefs)
{
string url = "ReferrerList_DoctorClinicV2.aspx?surname_search=" + regRef.Referrer.Person.Surname + @"&surname_starts_with=1" + (regRef.ProviderNumber.Length > 0 ? "&provider_nbr_search=" + regRef.ProviderNumber + "&provider_nbr_starts_with=1" : "");
string href = @"<a href=""" + url + @""">" + regRef.Referrer.Person.FullnameWithoutMiddlename + "</a>";
list += "<tr><td>" + href + @"</td><td style=""width:8px;""> </td><td> Prov Nbr: " + (regRef.ProviderNumber.Trim().Length == 0 ? "[None]" : regRef.ProviderNumber) + "</td></tr>";
}
list += tbl.Rows.Count == 0 ? string.Empty : "</table>";
lblProvidersOfSelectedOrg.Text = list.Length > 0 ? list : "None";
}
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 RegisterReferrer LoadAll(DataRow row)
{
RegisterReferrer rr = Load(row);
rr.Referrer = ReferrerDB.Load(row);
rr.Referrer.Person = PersonDB.Load(row, "", "person_entity_id");
rr.Referrer.Person.Title = IDandDescrDB.Load(row, "title_id", "descr");
if (row["organisation_id"] != DBNull.Value)
{
rr.Organisation = OrganisationDB.Load(row, "", "organisation_entity_id", "organisation_is_deleted");
}
return(rr);
}
public static Referrer[] GetReferrersOf(int organistion_id, bool showDeletedRefs = false, bool showDeletedRegRefs = false)
{
DataTable tbl = GetDataTable_ReferrersOf(organistion_id, showDeletedRefs, showDeletedRegRefs);
Referrer[] list = new Referrer[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
list[i] = ReferrerDB.Load(tbl.Rows[i]);
list[i].Person = PersonDB.Load(tbl.Rows[i], "", "person_entity_id");
list[i].Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
}
return(list);
}
public static Referrer[] GetAllNotInc(Referrer[] excList)
{
DataTable tbl = GetDataTable_AllNotInc(excList);
Referrer[] list = new Referrer[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
list[i] = ReferrerDB.Load(tbl.Rows[i]);
list[i].Person = PersonDB.Load(tbl.Rows[i]);
list[i].Person.Title = IDandDescrDB.Load(tbl.Rows[i], "title_id", "descr");
}
return(list);
}
private static RegisterReferrer[] _GetEPCReferrersOf(int patient_id, bool onlyActive)
{
DataTable tbl = onlyActive ? GetDataTable_ActiveEPCReferrersOf(patient_id) : GetDataTable_EPCReferrersOf(patient_id);
RegisterReferrer[] list = new RegisterReferrer[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
RegisterReferrer rr = RegisterReferrerDB.Load(tbl.Rows[i], "regref_");
rr.Referrer = ReferrerDB.Load(tbl.Rows[i], "referrer_");
rr.Referrer.Person = PersonDB.Load(tbl.Rows[i], "referrer_person_");
rr.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "referrer_person_title_title_id", "referrer_person_title_descr");
rr.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_");
list[i] = rr;
}
return(list);
}
/*
* protected bool IsValidFormOrg()
* {
* string orgID = Request.QueryString["org"];
* return orgID != null && Regex.IsMatch(orgID, @"^\d+$") && OrganisationDB.Exists(Convert.ToInt32(orgID));
* }
* protected int GetFormOrg(bool checkIsValid = true)
* {
* if (checkIsValid && !IsValidFormOrg())
* throw new Exception("Invalid url org");
* return Convert.ToInt32(Request.QueryString["org"]);
* }
*
* protected bool IsValidFormOrgs()
* {
* string orgIDs = Request.QueryString["orgs"];
* return orgIDs != null && Regex.IsMatch(orgIDs, @"^[\d,]+$") && OrganisationDB.Exists(orgIDs);
* }
* protected string GetFormOrgs(bool checkIsValid = true)
* {
* if (checkIsValid && !IsValidFormOrgs())
* throw new Exception("Invalid url orgs");
* return Request.QueryString["orgs"];
* }
*/
#endregion
#region GrdReferrer
protected void FillReferrerGrid()
{
//DataTable dt = RegisterReferrerDB.GetDataTable(false, new int[] { 191 }, txtSearchSurname.Text.Trim(), chkSurnameSearchOnlyStartWith.Checked);
DataTable dt = ReferrerDB.GetDataTable(-1, txtSearchSurname.Text.Trim(), chkSurnameSearchOnlyStartWith.Checked);
Session["referrerpersonlistpopup_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["referrerpersonlistpopup_sortexpression"] != null && Session["referrerpersonlistpopup_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["referrerpersonlistpopup_sortexpression"].ToString();
GrdReferrer.DataSource = dataView;
}
else
{
GrdReferrer.DataSource = dt;
}
try
{
GrdReferrer.DataBind();
GrdReferrer.PagerSettings.FirstPageText = "1";
GrdReferrer.PagerSettings.LastPageText = GrdReferrer.PageCount.ToString();
GrdReferrer.DataBind();
}
catch (Exception ex)
{
SetErrorMessage(ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdReferrer.DataSource = dt;
GrdReferrer.DataBind();
int TotalColumns = GrdReferrer.Rows[0].Cells.Count;
GrdReferrer.Rows[0].Cells.Clear();
GrdReferrer.Rows[0].Cells.Add(new TableCell());
GrdReferrer.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdReferrer.Rows[0].Cells[0].Text = "No Record Found";
}
}
protected void GrdReferrer_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
Label lblId = (Label)GrdReferrer.Rows[e.RowIndex].FindControl("lblId");
DropDownList ddlTitle = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlTitle");
TextBox txtFirstname = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtFirstname");
TextBox txtMiddlename = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtMiddlename");
TextBox txtSurname = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtSurname");
DropDownList ddlGender = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlGender");
TextBox txtName = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtName");
TextBox txtABN = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtABN");
TextBox txtACN = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtACN");
TextBox txtProviderNumber = (TextBox)GrdReferrer.Rows[e.RowIndex].FindControl("txtProviderNumber");
DropDownList ddlIsClinic = (DropDownList)GrdReferrer.Rows[e.RowIndex].FindControl("ddlIsClinic");
CheckBox chkIsReportEveryVisit = (CheckBox)GrdReferrer.Rows[e.RowIndex].FindControl("chkIsReportEveryVisit");
CheckBox chkIsBatchSendAllPatientsTreatmentNotes = (CheckBox)GrdReferrer.Rows[e.RowIndex].FindControl("chkIsBatchSendAllPatientsTreatmentNotes");
int registger_referrer_id = Convert.ToInt32(lblId.Text);
DataTable dt = Session["referrerinfolist_data"] as DataTable;
DataRow[] foundRows = dt.Select("register_referrer_id=" + registger_referrer_id.ToString());
DataRow row = foundRows[0];
RegisterReferrer rr = RegisterReferrerDB.Load(row);
rr.Referrer = ReferrerDB.Load(row);
rr.Referrer.Person = PersonDB.Load(row, "", "person_entity_id");
rr.Referrer.Person.Title = IDandDescrDB.Load(row, "title_id", "descr");
if (row["organisation_id"] != DBNull.Value)
{
rr.Organisation = OrganisationDB.Load(row, "", "organisation_entity_id", "organisation_is_deleted");
}
PersonDB.Update(rr.Referrer.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), row["nickname"].ToString(), ddlGender.SelectedValue, row["dob"] == DBNull.Value ? DateTime.MinValue : Convert.ToDateTime(row["dob"]), DateTime.Now);
OrganisationDB.UpdateExtOrg(rr.Organisation.OrganisationID, rr.Organisation.OrganisationType.OrganisationTypeID, txtName.Text, txtACN.Text, txtABN.Text, DateTime.Now, rr.Organisation.IsDebtor, rr.Organisation.IsCreditor, rr.Organisation.BpayAccount, rr.Organisation.Comment);
RegisterReferrerDB.Update(rr.RegisterReferrerID, rr.Organisation.OrganisationID, rr.Referrer.ReferrerID, txtProviderNumber.Text, chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked, rr.DateLastBatchSendAllPatientsTreatmentNotes);
GrdReferrer.EditIndex = -1;
FillGrid();
}
// hashtable: patient_id => RegisterReferrer[]
public static Hashtable GetEPCReferrersOf(int[] patient_ids, bool onlyActive)
{
string sql = JoinedSQL() + @"
AND " + (patient_ids != null && patient_ids.Length > 0 ? " pat.patient_id IN (" + string.Join(",", patient_ids) + @")" : "1 <> 1") + @"
" + (onlyActive ? " AND pr.is_active = 1 " : "") + @"
ORDER BY patient_referrer_date_added";
DataTable tbl = DBBase.ExecuteQuery(sql).Tables[0];
Hashtable hash = new Hashtable();
for (int i = 0; i < tbl.Rows.Count; i++)
{
RegisterReferrer rr = RegisterReferrerDB.Load(tbl.Rows[i], "regref_");
rr.Referrer = ReferrerDB.Load(tbl.Rows[i], "referrer_");
rr.Referrer.Person = PersonDB.Load(tbl.Rows[i], "referrer_person_");
rr.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "referrer_person_title_title_id", "referrer_person_title_descr");
rr.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_");
int patient_id = Convert.ToInt32(tbl.Rows[i]["pr_patient_id"]);
if (hash[patient_id] == null)
{
hash[patient_id] = new System.Collections.ArrayList();
}
((System.Collections.ArrayList)hash[patient_id]).Add(rr);
}
// convert from arraylists to arrays
ArrayList keys = new ArrayList();
foreach (System.Collections.DictionaryEntry de in hash)
{
keys.Add(de.Key);
}
foreach (int key in keys)
{
hash[key] = (RegisterReferrer[])((ArrayList)hash[key]).ToArray(typeof(RegisterReferrer));
}
;
return(hash);
}
public static Referral LoadAll(DataRow row)
{
Referral referral = Load(row);
referral.HealthCard = HealthCardDB.Load(row);
referral.MedicalServiceType = IDandDescrDB.Load(row, "mct_medical_service_type_id", "mct_descr");
referral.RegisterReferrer = RegisterReferrerDB.Load(row, "regref_");
referral.RegisterReferrer.Referrer = ReferrerDB.Load(row, "referrer_");
referral.RegisterReferrer.Referrer.Person = PersonDB.Load(row, "referrer_person_");
referral.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(row, "referrer_person_title_title_id", "referrer_person_title_descr");
if (row["organisation_organisation_id"] != DBNull.Value)
{
referral.RegisterReferrer.Organisation = OrganisationDB.Load(row, "organisation_");
}
if (row["added_or_last_modified_by_staff_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy = StaffDB.Load(row, "added_or_last_modified_by_");
}
if (row["person_added_or_last_modified_by_person_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy.Person = PersonDB.Load(row, "person_added_or_last_modified_by_");
referral.AddedOrLastModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_added_or_last_modified_by_title_id", "title_added_or_last_modified_by_descr");
}
if (row["deleted_by_staff_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy = StaffDB.Load(row, "deleted_by_");
}
if (row["person_deleted_by_person_id"] != DBNull.Value)
{
referral.AddedOrLastModifiedBy.Person = PersonDB.Load(row, "person_deleted_by_");
referral.AddedOrLastModifiedBy.Person.Title = IDandDescrDB.Load(row, "title_deleted_by_title_id", "title_deleted_by_descr");
}
return(referral);
}
protected void GrdReferrer_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Label lblId = (Label)GrdReferrer.Rows[e.RowIndex].FindControl("lblId");
try
{
ReferrerDB.UpdateInactive(Convert.ToInt32(lblId.Text));
}
catch (ForeignKeyConstraintException fkcEx)
{
if (Utilities.IsDev())
{
SetErrorMessage("Can not delete because other records depend on this : " + fkcEx.Message);
}
else
{
SetErrorMessage("Can not delete because other records depend on this");
}
}
FillGrid();
}
public static PatientReferrer LoadAll(DataRow row)
{
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");
if (row["nonepcorg_entity_id"] != DBNull.Value)
{
pr.Organisation = OrganisationDB.Load(row, "nonepcorg_");
}
return(pr);
}
private static PatientReferrer[] _GetEPCPatientReferrersOf(int patient_id, bool onlyActive)
{
DataTable tbl = onlyActive ? GetDataTable_ActiveEPCReferrersOf(patient_id) : GetDataTable_EPCReferrersOf(patient_id);
PatientReferrer[] list = new PatientReferrer[tbl.Rows.Count];
for (int i = 0; i < tbl.Rows.Count; i++)
{
PatientReferrer pr = Load(tbl.Rows[i], "pr_");
pr.RegisterReferrer = RegisterReferrerDB.Load(tbl.Rows[i], "regref_");
pr.RegisterReferrer.Referrer = ReferrerDB.Load(tbl.Rows[i], "referrer_");
pr.RegisterReferrer.Referrer.Person = PersonDB.Load(tbl.Rows[i], "referrer_person_");
pr.RegisterReferrer.Referrer.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "referrer_person_title_title_id", "referrer_person_title_descr");
if (tbl.Rows[i]["organisation_organisation_id"] != DBNull.Value)
{
pr.RegisterReferrer.Organisation = OrganisationDB.Load(tbl.Rows[i], "organisation_");
}
pr.Patient = PatientDB.Load(tbl.Rows[i], "patient_");
pr.Patient.Person = PersonDB.Load(tbl.Rows[i], "patient_person_");
pr.Patient.Person.Title = IDandDescrDB.Load(tbl.Rows[i], "patient_person_title_title_id", "patient_person_title_descr");
list[i] = pr;
}
return(list);
}
protected void FillGrid_Patients(Type type, int id)
{
UserView userView = UserView.GetInstance();
DataTable dt = null;
if (type == typeof(Referrer))
{
Referrer referrer = ReferrerDB.GetByID(id);
lblPatientsHeading.Text = "Patients of <big><b>" + referrer.Person.FullnameWithoutMiddlename + "</b></big> at <big><b>All Clinics</b></big>";
if (userView.IsAdminView && userView.IsClinicView)
{
dt = PatientDB.GetDataTable(false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", "", id.ToString(), "", false, false, false);
}
if (userView.IsAdminView && !userView.IsClinicView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOfOrgGroupType(false, "6", false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", "", id.ToString(), "", false, false, false);
}
if (!userView.IsAdminView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOf(false, Convert.ToInt32(Session["OrgID"]), false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", "", id.ToString(), "", false, false, false);
}
}
else if (type == typeof(RegisterReferrer))
{
RegisterReferrer regRef = RegisterReferrerDB.GetByID(id);
lblPatientsHeading.Text = "Patients of <big><b>" + regRef.Referrer.Person.FullnameWithoutMiddlename + "</b></big> at <big><b>" + regRef.Organisation.Name + "</b></big>";
if (userView.IsAdminView && userView.IsClinicView)
{
dt = PatientDB.GetDataTable(false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", id.ToString(), "", "", false, false, false);
}
if (userView.IsAdminView && !userView.IsClinicView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOfOrgGroupType(false, "6", false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", id.ToString(), "", "", false, false, false);
}
if (!userView.IsAdminView)
{
dt = RegisterPatientDB.GetDataTable_PatientsOf(false, Convert.ToInt32(Session["OrgID"]), false, false, userView.IsClinicView, false, "", false, "", false, "", "", "", "", "", false, -1, -1, -1, "", "", id.ToString(), "", "", false, false, false);
}
}
else
{
SetErrorMessage("Unknown type: " + type.ToString());
return;
}
lblPatientsHeading.Visible = true;
GrdPatients.Visible = true;
// put in epc info into the table in a bulk call
// epc exp date, if valid, how many epc's remaining...
int[] patientIDs = new int[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
{
patientIDs[i] = Convert.ToInt32(dt.Rows[i]["patient_id"]);
}
int MedicareMaxNbrServicesPerYear = Convert.ToInt32(SystemVariableDB.GetByDescr("MedicareMaxNbrServicesPerYear").Value);
Hashtable patientsMedicareCountThisYearCache = PatientsMedicareCardCountThisYearCacheDB.GetBullk(patientIDs, DateTime.Today.Year);
Hashtable patientsMedicareCountNextYearCache = PatientsMedicareCardCountThisYearCacheDB.GetBullk(patientIDs, DateTime.Today.Year + 1);
Hashtable patientsEPCRemainingCache = PatientsEPCRemainingCacheDB.GetBullk(patientIDs, DateTime.MinValue);
dt.Columns.Add("epc_signed_date", typeof(DateTime));
dt.Columns.Add("epc_expiry_date", typeof(DateTime));
dt.Columns.Add("epc_n_services_left", typeof(Int32));
for (int i = 0; i < dt.Rows.Count; i++)
{
int patientID = Convert.ToInt32(dt.Rows[i]["patient_id"]);
int totalServicesAllowedLeft = (MedicareMaxNbrServicesPerYear - (int)patientsMedicareCountThisYearCache[patientID]);
Pair totalEPCRemaining = patientsEPCRemainingCache[patientID] as Pair;
int nServicesLeft = 0;
if (totalEPCRemaining != null)
{
DateTime referralSignedDate = (DateTime)totalEPCRemaining.Second;
DateTime hcExpiredDate = referralSignedDate.AddYears(1);
if (DateTime.Today >= referralSignedDate.Date && DateTime.Today < hcExpiredDate.Date)
{
nServicesLeft = (int)totalEPCRemaining.First;
}
if (totalServicesAllowedLeft < nServicesLeft)
{
nServicesLeft = totalServicesAllowedLeft;
}
dt.Rows[i]["epc_signed_date"] = referralSignedDate;
dt.Rows[i]["epc_expiry_date"] = hcExpiredDate;
dt.Rows[i]["epc_n_services_left"] = nServicesLeft;
}
else
{
dt.Rows[i]["epc_signed_date"] = DBNull.Value;
dt.Rows[i]["epc_expiry_date"] = DBNull.Value;
dt.Rows[i]["epc_n_services_left"] = DBNull.Value;
}
}
Session["referrerinfoperson_patients_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["referrerinfoperson_patients_sortexpression"] != null && Session["referrerinfoperson_patients_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["referrerinfoperson_patients_sortexpression"].ToString();
GrdPatients.DataSource = dataView;
}
else
{
GrdPatients.DataSource = dt;
}
try
{
GrdPatients.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdPatients.DataSource = dt;
GrdPatients.DataBind();
int TotalColumns = GrdPatients.Rows[0].Cells.Count;
GrdPatients.Rows[0].Cells.Clear();
GrdPatients.Rows[0].Cells.Add(new TableCell());
GrdPatients.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdPatients.Rows[0].Cells[0].Text = "No Patients";
}
}
protected void GrdReferrer_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{
DropDownList ddlTitle = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewTitle");
TextBox txtFirstname = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewFirstname");
TextBox txtMiddlename = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewMiddlename");
TextBox txtSurname = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewSurname");
DropDownList ddlGender = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewGender");
txtFirstname.Text = txtFirstname.Text.Trim();
txtMiddlename.Text = txtMiddlename.Text.Trim();
txtSurname.Text = txtSurname.Text.Trim();
if (txtSurname.Text.Length == 0)
{
SetErrorMessage("Surname can not be empty");
return;
}
if (txtSurname.Text.Length == 0)
{
SetErrorMessage("Firstname can not be empty");
return;
}
Staff loggedInStaff = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"]));
int person_id = PersonDB.Insert(loggedInStaff.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), "", ddlGender.SelectedValue, new DateTime(1900, 1, 1));
ReferrerDB.Insert(person_id);
FillGrid();
SetErrorMessage("Added.");
}
if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete"))
{
try
{
// if getting referers of an org, set the reg-ref relationship as active/inactive
if (Request.QueryString["org"] != null)
{
int reg_ref_id = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("_Delete"))
{
RegisterReferrerDB.UpdateInactive(reg_ref_id);
}
else
{
RegisterReferrerDB.UpdateActive(reg_ref_id);
}
}
// if getting all referrers, set the ref as active/inactive
else
{
int referrer_id = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("_Delete"))
{
ReferrerDB.UpdateInactive(referrer_id);
}
else
{
ReferrerDB.UpdateActive(referrer_id);
}
}
}
catch (ForeignKeyConstraintException fkcEx)
{
if (Utilities.IsDev())
{
SetErrorMessage("Can not delete because other records depend on this : " + fkcEx.Message);
}
else
{
SetErrorMessage("Can not delete because other records depend on this");
}
}
FillGrid();
}
if (e.CommandName.Equals("ViewPatients"))
{
int id = Convert.ToInt32(e.CommandArgument);
if (Request.QueryString["org"] == null)
{
FillGrid_Patients(typeof(Referrer), id);
}
else
{
FillGrid_Patients(typeof(RegisterReferrer), id);
}
}
}
protected void GrdReferrer_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{
DropDownList ddlTitle = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewTitle");
TextBox txtFirstname = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewFirstname");
TextBox txtMiddlename = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewMiddlename");
TextBox txtSurname = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewSurname");
DropDownList ddlGender = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewGender");
TextBox txtName = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewName");
TextBox txtABN = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewABN");
TextBox txtACN = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewACN");
TextBox txtProviderNumber = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewProviderNumber");
DropDownList ddlIsClinic = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewIsClinic");
CheckBox chkIsReportEveryVisit = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsReportEveryVisit");
CheckBox chkIsBatchSendAllPatientsTreatmentNotes = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsBatchSendAllPatientsTreatmentNotes");
int person_id = -1;
int referrer_id = -1;
int organisation_id = 0;
int register_referrer_id = -1;
try
{
Staff loggedInStaff = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"]));
person_id = PersonDB.Insert(loggedInStaff.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), "", ddlGender.SelectedValue, new DateTime(1900, 1, 1));
referrer_id = ReferrerDB.Insert(person_id);
organisation_id = OrganisationDB.InsertExtOrg(191, txtName.Text, txtACN.Text, txtABN.Text, false, false, "", "");
register_referrer_id = RegisterReferrerDB.Insert(organisation_id, referrer_id, txtProviderNumber.Text, chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked);
FillGrid();
}
catch (Exception)
{
// roll back - backwards of creation order
RegisterReferrerDB.Delete(register_referrer_id);
OrganisationDB.Delete(organisation_id);
ReferrerDB.Delete(referrer_id);
PersonDB.Delete(person_id);
}
}
if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete"))
{
int register_referrer_id = Convert.ToInt32(e.CommandArgument);
try
{
if (e.CommandName.Equals("_Delete"))
{
RegisterReferrerDB.UpdateInactive(register_referrer_id);
}
else
{
RegisterReferrerDB.UpdateActive(register_referrer_id);
}
}
catch (ForeignKeyConstraintException fkcEx)
{
if (Utilities.IsDev())
{
SetErrorMessage("Can not delete because other records depend on this : " + fkcEx.Message);
}
else
{
SetErrorMessage("Can not delete because other records depend on this");
}
}
FillGrid();
}
}
protected void FillGrid()
{
string searchName = "";
if (Request.QueryString["name_search"] != null && Request.QueryString["name_search"].Length > 0)
{
searchName = Request.QueryString["name_search"];
txtSearchName.Text = Request.QueryString["name_search"];
}
bool searchNameOnlyStartsWith = true;
if (Request.QueryString["name_starts_with"] != null && Request.QueryString["name_starts_with"].Length > 0)
{
searchNameOnlyStartsWith = Request.QueryString["name_starts_with"] == "0" ? false : true;
chkSearchOnlyStartWith.Checked = searchNameOnlyStartsWith;
}
else
{
chkSearchOnlyStartWith.Checked = searchNameOnlyStartsWith;
}
int orgID = 0;
if (Request.QueryString["org"] != null && Regex.IsMatch(Request.QueryString["org"], @"\d{1,10}") && OrganisationDB.Exists(Convert.ToInt32(Request.QueryString["org"])))
{
orgID = Convert.ToInt32(Request.QueryString["org"]);
}
// get count
Hashtable countHash = new Hashtable();
Hashtable countDeletedHash = new Hashtable();
DataTable dt_reg_refs = RegisterReferrerDB.GetDataTable(orgID, -1, true, new int[] { 191 }, "", false, "", "", "", false);
foreach (DataRow row in dt_reg_refs.Rows)
{
int org_id = Convert.ToInt32(row["organisation_id"]);
if (!Convert.ToBoolean(row["is_deleted"]))
{
countHash[org_id] = (countHash[org_id] == null) ? 1 : ((int)countHash[org_id]) + 1;
}
else
{
countDeletedHash[org_id] = (countDeletedHash[org_id] == null) ? 1 : ((int)countDeletedHash[org_id]) + 1;
}
}
DataTable dt = null;
if (Request.QueryString["referrer"] == null)
{
dt = OrganisationDB.GetDataTable(orgID, chkShowDeleted.Checked, true, true, true, true, false, searchName, searchNameOnlyStartsWith, "191");
dt.Columns.Add("count", typeof(Int32));
dt.Columns.Add("count_deleted", typeof(Int32));
for (int i = 0; i < dt.Rows.Count; i++)
{
int org_id = Convert.ToInt32(dt.Rows[i]["organisation_id"]);
dt.Rows[i]["count"] = countHash[org_id] == null ? 0 : (int)countHash[org_id];
dt.Rows[i]["count_deleted"] = countDeletedHash[org_id] == null ? 0 : (int)countDeletedHash[org_id];
}
}
else
{
if (!Regex.IsMatch(Request.QueryString["referrer"], @"^\d+$"))
{
HideTableAndSetErrorMessage("Invalid url referrer");
return;
}
Referrer referrer = ReferrerDB.GetByID(Convert.ToInt32(Request.QueryString["referrer"]));
if (referrer == null)
{
HideTableAndSetErrorMessage("Invalid url referrer");
return;
}
lblHeading.Text = "Referrer Clinics of " + referrer.Person.FullnameWithoutMiddlename;
dt = RegisterReferrerDB.GetDataTable_OrganisationsOf(referrer.ReferrerID, true, chkShowDeleted.Checked, searchName, searchNameOnlyStartsWith);
dt.Columns.Add("is_deleted", typeof(Boolean));
dt.Columns.Add("entity_id", typeof(Int32));
dt.Columns.Add("count", typeof(Int32));
dt.Columns.Add("count_deleted", typeof(Int32));
for (int i = 0; i < dt.Rows.Count; i++)
{
int org_id = Convert.ToInt32(dt.Rows[i]["organisation_id"]);
dt.Rows[i]["count"] = countHash[org_id] == null ? 0 : (int)countHash[org_id];
dt.Rows[i]["count_deleted"] = countDeletedHash[org_id] == null ? 0 : (int)countDeletedHash[org_id];
// update these so when delete/undelete - it removes the connection, not the org
dt.Rows[i]["organisation_id"] = dt.Rows[i]["register_referrer_id"];
dt.Rows[i]["is_deleted"] = dt.Rows[i]["register_referrer_is_deleted"];
dt.Rows[i]["entity_id"] = dt.Rows[i]["organisation_entity_id"];
}
}
// add suburb_name
Hashtable entityIDsHash = new Hashtable();
for (int i = 0; i < dt.Rows.Count; i++)
{
entityIDsHash[Convert.ToInt32(dt.Rows[i]["entity_id"])] = 1;
}
int[] entityIDs = new int[entityIDsHash.Keys.Count];
entityIDsHash.Keys.CopyTo(entityIDs, 0);
Hashtable emailHash = PatientsContactCacheDB.GetBullkAddress(entityIDs, -1);
dt.Columns.Add("suburb_name", typeof(string));
for (int i = 0; i < dt.Rows.Count; i++)
{
int entityID = Convert.ToInt32(dt.Rows[i]["entity_id"]);
string suburbName = GetSuburb(emailHash, entityID);
dt.Rows[i]["suburb_name"] = suburbName == null ? "" : suburbName;
}
Session["referrerinfoclinic_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["referrerinfoclinic_sortexpression"] != null && Session["referrerinfoclinic_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["referrerinfoclinic_sortexpression"].ToString();
GrdReferrer.DataSource = dataView;
}
else
{
GrdReferrer.DataSource = dt;
}
try
{
GrdReferrer.DataBind();
GrdReferrer.PagerSettings.FirstPageText = "1";
GrdReferrer.PagerSettings.LastPageText = GrdReferrer.PageCount.ToString();
GrdReferrer.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdReferrer.DataSource = dt;
GrdReferrer.DataBind();
int TotalColumns = GrdReferrer.Rows[0].Cells.Count;
GrdReferrer.Rows[0].Cells.Clear();
GrdReferrer.Rows[0].Cells.Add(new TableCell());
GrdReferrer.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdReferrer.Rows[0].Cells[0].Text = "No Record Found";
}
if (Request.QueryString["referrer"] != null)
{
GrdReferrer.FooterRow.Visible = false;
GrdReferrer.Columns[GrdReferrer.Columns.Count - 2].Visible = false;
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utilities.SetNoCache(Response);
}
try
{
if (Session == null || Session["DB"] == null)
{
throw new SessionTimedOutException();
}
string colSep = "|";
string rowSep = "<>";
string firstname = Request.QueryString["firstname"];
string surname = Request.QueryString["surname"];
if (firstname == null ||
surname == null)
{
throw new CustomMessageException();
}
if (firstname.Length == 0 || surname.Length == 0)
{
Response.Write("NONE");
return;
}
if (GetUrlParamType() == UrlParamType.Staff)
{
Staff[] list = StaffDB.DuplicateSearch(firstname, "", surname);
if (list.Length == 0)
{
Response.Write("NONE");
}
else
{
string result = "ID" + colSep + "Firstname" + colSep + "Middlename" + colSep + "Surname" + colSep + "D.O.B" + colSep + "Addresses" + colSep + "Phone Nbrs" + rowSep;
for (int i = 0; i < list.Length; i++)
{
result += GetLine(list[i].StaffID, list[i].Person, colSep, rowSep, i > 0, true, true, true, false);
}
Response.Write(result);
}
}
else if (GetUrlParamType() == UrlParamType.Patient)
{
Patient[] list = PatientDB.DuplicateSearch(firstname, "", surname);
if (list.Length == 0)
{
Response.Write("NONE");
}
else
{
string result = "ID" + colSep + "Firstname" + colSep + "Middlename" + colSep + "Surname" + colSep + "D.O.B" + colSep + "Addresses" + colSep + "Phone Nbrs" + rowSep;
for (int i = 0; i < list.Length; i++)
{
result += GetLine(list[i].PatientID, list[i].Person, colSep, rowSep, i > 0, true, true, true, false);
}
Response.Write(result);
}
}
else if (GetUrlParamType() == UrlParamType.Referrer)
{
Referrer[] list = ReferrerDB.DuplicateSearch(firstname, "", surname);
if (list.Length == 0)
{
Response.Write("NONE");
}
else
{
//string result = "ID" + colSep + "Firstname" + colSep + "Middlename" + colSep + "Surname" + colSep + "Addresses" + colSep + "Phone Nbrs" + rowSep;
//for (int i = 0; i < list.Length; i++)
// result += GetLine(list[i].ReferrerID, list[i].Person, colSep, rowSep, i > 0, false);
//Response.Write(result);
string result = "ID" + colSep + "Firstname" + colSep + "Middlename" + colSep + "Surname" + colSep + "Clinics " + colSep + "Provider Nbrs" + rowSep;
for (int i = 0; i < list.Length; i++)
{
result += GetLine(list[i].ReferrerID, list[i].Person, colSep, rowSep, i > 0, false, false, false, true);
}
Response.Write(result);
}
}
else
{
throw new CustomMessageException();
}
}
catch (SessionTimedOutException)
{
Utilities.UnsetSessionVariables();
Response.Write("SessionTimedOutException");
}
catch (Exception ex)
{
Response.Write("Exception: " + (Utilities.IsDev() ? ex.ToString() : "Error - please contact system administrator."));
}
}
protected void GrdReferrer_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName.Equals("Insert"))
{
DropDownList ddlRefs = (DropDownList)GrdReferrer.FooterRow.FindControl("ddlNewRefs");
TextBox txtProviderNumber = (TextBox)GrdReferrer.FooterRow.FindControl("txtNewProviderNumber");
CheckBox chkIsReportEveryVisit = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsReportEveryVisit");
CheckBox chkIsBatchSendAllPatientsTreatmentNotes = (CheckBox)GrdReferrer.FooterRow.FindControl("chkNewIsBatchSendAllPatientsTreatmentNotes");
if (RegisterReferrerDB.Exists(Convert.ToInt32(Request.QueryString["org"]), Convert.ToInt32(ddlRefs.SelectedValue)))
{
SetErrorMessage("Clinic is already linked to " + ddlRefs.SelectedItem.Text + ". If it is not visible, use the 'show deleted' checkbox and un-delete it.");
return;
}
RegisterReferrerDB.Insert(Convert.ToInt32(Request.QueryString["org"]), Convert.ToInt32(ddlRefs.SelectedValue), txtProviderNumber.Text.Trim(), chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked);
FillGrid();
}
if (e.CommandName.Equals("_Delete") || e.CommandName.Equals("_UnDelete"))
{
try
{
// if getting referers of an org, set the reg-ref relationship as active/inactive
if (Request.QueryString["org"] != null)
{
int reg_ref_id = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("_Delete"))
{
RegisterReferrerDB.UpdateInactive(reg_ref_id);
}
else
{
RegisterReferrerDB.UpdateActive(reg_ref_id);
}
}
// if getting all referrers, set the ref as active/inactive
else
{
int referrer_id = Convert.ToInt32(e.CommandArgument);
if (e.CommandName.Equals("_Delete"))
{
ReferrerDB.UpdateInactive(referrer_id);
}
else
{
ReferrerDB.UpdateActive(referrer_id);
}
}
}
catch (ForeignKeyConstraintException fkcEx)
{
if (Utilities.IsDev())
{
SetErrorMessage("Can not delete because other records depend on this : " + fkcEx.Message);
}
else
{
SetErrorMessage("Can not delete because other records depend on this");
}
}
FillGrid();
}
if (e.CommandName.Equals("ViewPatients"))
{
int id = Convert.ToInt32(e.CommandArgument);
if (Request.QueryString["org"] == null)
{
FillGrid_Patients(typeof(Referrer), id);
}
else
{
FillGrid_Patients(typeof(RegisterReferrer), id);
}
}
}
protected void GrdReferrer_RowDataBound(object sender, GridViewRowEventArgs e)
{
DataTable dt = Session["referrerinfopersonofclinic_data"] as DataTable;
bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value);
if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow)
{
Label lblId = (Label)e.Row.FindControl("lblId");
DataRow[] foundRows = dt.Select("referrer_id=" + lblId.Text);
DataRow thisRow = foundRows[0];
DropDownList ddlRefs = (DropDownList)e.Row.FindControl("ddlRefs");
if (ddlRefs != null)
{
DataTable dt_refs = dt = ReferrerDB.GetDataTable(-1, "", false, chkShowDeleted.Checked);
// check for deleted REF
DataRow[] foundRows_orgs = dt_refs.Select("referrer_id=" + thisRow["original_referrer_id"].ToString());
if (!chkShowDeleted.Checked && foundRows_orgs.Length == 0)
{
DataTable dt_deleted_orgs = ReferrerDB.GetDataTable(-1, "", false, true);
foundRows_orgs = dt_deleted_orgs.Select("referrer_id=" + thisRow["original_referrer_id"].ToString());
if (foundRows_orgs.Length == 1)
{
dt_refs.Rows.Add(foundRows_orgs[0].ItemArray);
}
}
ddlRefs.Items.Clear();
foreach (DataRow row in dt_refs.Rows)
{
ddlRefs.Items.Add(new ListItem(row["firstname"] + " " + row["surname"], row["referrer_id"].ToString()));
}
ddlRefs.SelectedValue = thisRow["original_referrer_id"].ToString();
}
ImageButton btnDelete = (ImageButton)e.Row.FindControl("btnDelete");
if (btnDelete != null)
{
bool is_deleted = Convert.ToBoolean(thisRow["is_deleted"]);
if (is_deleted)
{
btnDelete.CommandName = "_UnDelete";
btnDelete.ImageUrl = "~/images/tick-24.png";
btnDelete.AlternateText = "UnDelete";
btnDelete.ToolTip = "UnDelete";
}
}
Label lblFirstname = (Label)e.Row.FindControl("lblFirstname");
if (lblFirstname != null)
{
lblFirstname.Visible = (Request.QueryString["org"] != null);
}
HyperLink lnkFirstname = (HyperLink)e.Row.FindControl("lnkFirstname");
if (lnkFirstname != null)
{
lnkFirstname.Visible = (Request.QueryString["org"] == null);
}
Utilities.AddConfirmationBox(e);
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow);
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList ddlNewRefs = (DropDownList)e.Row.FindControl("ddlNewRefs");
if (ddlNewRefs != null)
{
DataTable dt_refs = dt = ReferrerDB.GetDataTable(-1, "", false, chkShowDeleted.Checked);
ddlNewRefs.Items.Clear();
foreach (DataRow row in dt_refs.Rows)
{
ddlNewRefs.Items.Add(new ListItem(row["firstname"] + " " + row["surname"], row["referrer_id"].ToString()));
}
}
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
// need to be able to roll back .. so keep id's same as invoice
int person_id = -1;
int referrer_id = -1;
int new_org_id = 0;
bool referrer_added = false;
int address_id = -1;
int phone_id1 = -1;
int phone_id2 = -1;
int email_id = -1;
bool contacts_added = false;
try
{
// add referrer
if (lblId.Text == "-1") // add new referrer
{
Staff loggedInStaff = StaffDB.GetByID(Convert.ToInt32(Session["StaffID"]));
person_id = PersonDB.Insert(loggedInStaff.Person.PersonID, Convert.ToInt32(ddlTitle.SelectedValue), Utilities.FormatName(txtFirstname.Text), Utilities.FormatName(txtMiddlename.Text), Utilities.FormatName(txtSurname.Text), "", ddlGender.SelectedValue, new DateTime(1900, 1, 1));
referrer_id = ReferrerDB.Insert(person_id);
}
else // set existing referrer
{
referrer_id = Convert.ToInt32(lblId.Text);
}
// get org (or add new org)
int org_id = 0;
if (orgsListRow.Visible)
{
org_id = Convert.ToInt32(ddlOrgsList.SelectedValue);
}
else
{
org_id = new_org_id = OrganisationDB.InsertExtOrg(191, txtOrgName.Text, txtOrgACN.Text, txtOrgABN.Text, false, false, "", txtOrgComments.Text);
// add contact info
Organisation org = OrganisationDB.GetByID(org_id);
if (Utilities.GetAddressType().ToString() == "Contact")
{
if (txtAddressAddrLine1.Text.Trim().Length > 0 || txtAddressAddrLine2.Text.Trim().Length > 0)
{
address_id = ContactDB.Insert(org.EntityID,
Convert.ToInt32(ddlAddressContactType.SelectedValue),
txtAddressFreeText.Text,
txtAddressAddrLine1.Text,
txtAddressAddrLine2.Text,
Convert.ToInt32(ddlAddressAddressChannel.SelectedValue),
//Convert.ToInt32(ddlAddressSuburb.SelectedValue),
Convert.ToInt32(suburbID.Value),
Convert.ToInt32(ddlAddressCountry.SelectedValue),
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
if (txtPhoneNumber1.Text.Trim().Length > 0)
{
phone_id1 = ContactDB.Insert(org.EntityID,
Convert.ToInt32(ddlPhoneNumber1.SelectedValue),
txtPhoneNumber1FreeText.Text,
System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber1.Text, "[^0-9]", ""),
string.Empty,
-1,
-1,
-1,
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
if (txtPhoneNumber2.Text.Trim().Length > 0)
{
phone_id2 = ContactDB.Insert(org.EntityID,
Convert.ToInt32(ddlPhoneNumber2.SelectedValue),
txtPhoneNumber2FreeText.Text,
System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber2.Text, "[^0-9]", ""),
string.Empty,
-1,
-1,
-1,
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
if (txtEmailAddrLine1.Text.Trim().Length > 0)
{
email_id = ContactDB.Insert(org.EntityID,
Convert.ToInt32(ddlEmailContactType.SelectedValue),
"",
txtEmailAddrLine1.Text,
string.Empty,
-1,
-1,
-1,
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
}
else if (Utilities.GetAddressType().ToString() == "ContactAus")
{
if (txtAddressAddrLine1.Text.Trim().Length > 0 || txtAddressAddrLine2.Text.Trim().Length > 0)
{
address_id = ContactAusDB.Insert(org.EntityID,
Convert.ToInt32(ddlAddressContactType.SelectedValue),
txtAddressFreeText.Text,
txtAddressAddrLine1.Text,
txtAddressAddrLine2.Text,
txtStreet.Text,
Convert.ToInt32(ddlAddressAddressChannelType.SelectedValue),
//Convert.ToInt32(ddlAddressSuburb.SelctedValue),
Convert.ToInt32(suburbID.Value),
Convert.ToInt32(ddlAddressCountry.SelectedValue),
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
if (txtPhoneNumber1.Text.Trim().Length > 0)
{
phone_id1 = ContactAusDB.Insert(org.EntityID,
Convert.ToInt32(ddlPhoneNumber1.SelectedValue),
txtPhoneNumber1FreeText.Text,
System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber1.Text, "[^0-9]", ""),
string.Empty,
string.Empty,
-1,
-1,
-1,
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
if (txtPhoneNumber2.Text.Trim().Length > 0)
{
phone_id2 = ContactAusDB.Insert(org.EntityID,
Convert.ToInt32(ddlPhoneNumber2.SelectedValue),
txtPhoneNumber2FreeText.Text,
System.Text.RegularExpressions.Regex.Replace(txtPhoneNumber2.Text, "[^0-9]", ""),
string.Empty,
string.Empty,
-1,
-1,
-1,
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
if (txtEmailAddrLine1.Text.Trim().Length > 0)
{
email_id = ContactAusDB.Insert(org.EntityID,
Convert.ToInt32(ddlEmailContactType.SelectedValue),
"",
txtEmailAddrLine1.Text,
string.Empty,
string.Empty,
-1,
-1,
-1,
Convert.ToInt32(Session["SiteID"]),
true,
true);
}
}
else
{
throw new Exception("Unknown AddressType in config: " + Utilities.GetAddressType().ToString().ToString());
}
}
contacts_added = true;
// join association
RegisterReferrerDB.Insert(org_id, referrer_id, txtProviderNumber.Text, chkIsReportEveryVisit.Checked, chkIsBatchSendAllPatientsTreatmentNotes.Checked);
referrer_added = true;
if (GetUrlIsPopup())
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "close", "<script language=javascript>window.returnValue=false;self.close();</script>");
}
else
{
Response.Redirect("~/ReferrerList_DoctorClinicV2.aspx?surname_search=" + Utilities.FormatName(txtSurname.Text) + "&surname_starts_with=1", false);
return;
}
}
catch (Exception)
{
// roll back - backwards of creation order
if (Utilities.GetAddressType().ToString() == "Contact")
{
ContactDB.Delete(address_id);
ContactDB.Delete(phone_id1);
ContactDB.Delete(phone_id2);
ContactDB.Delete(email_id);
}
else if (Utilities.GetAddressType().ToString() == "ContactAus")
{
ContactAusDB.Delete(address_id);
ContactAusDB.Delete(phone_id1);
ContactAusDB.Delete(phone_id2);
ContactAusDB.Delete(email_id);
}
else
{
throw new Exception("Unknown AddressType in config: " + Utilities.GetAddressType().ToString().ToString());
}
OrganisationDB.Delete(new_org_id);
ReferrerDB.Delete(referrer_id);
PersonDB.Delete(person_id);
throw;
}
}
protected void FillGrid()
{
string searchName = "";
if (Request.QueryString["name_search"] != null && Request.QueryString["name_search"].Length > 0)
{
searchName = Request.QueryString["name_search"];
txtSearchName.Text = Request.QueryString["name_search"];
}
bool searchNameOnlyStartsWith = true;
if (Request.QueryString["name_starts_with"] != null && Request.QueryString["name_starts_with"].Length > 0)
{
searchNameOnlyStartsWith = Request.QueryString["name_starts_with"] == "0" ? false : true;
chkSearchOnlyStartWith.Checked = searchNameOnlyStartsWith;
}
else
{
chkSearchOnlyStartWith.Checked = searchNameOnlyStartsWith;
}
int referrerID = -1;
if (Request.QueryString["referrer"] != null && Regex.IsMatch(Request.QueryString["referrer"], @"\d{1,10}") && ReferrerDB.Exists(Convert.ToInt32(Request.QueryString["referrer"])))
{
referrerID = Convert.ToInt32(Request.QueryString["referrer"]);
}
// get the counts
Hashtable countHash = new Hashtable();
Hashtable countDeletedHash = new Hashtable();
DataTable dt_reg_refs = RegisterReferrerDB.GetDataTable(0, referrerID, true, new int[] { 191 }, "", false, "", "", "", false);
foreach (DataRow row in dt_reg_refs.Rows)
{
int referrer_id = Convert.ToInt32(row["referrer_id"]);
if (!Convert.ToBoolean(row["is_deleted"]))
{
countHash[referrer_id] = (countHash[referrer_id] == null) ? 1 : ((int)countHash[referrer_id]) + 1;
}
else
{
countDeletedHash[referrer_id] = (countDeletedHash[referrer_id] == null) ? 1 : ((int)countDeletedHash[referrer_id]) + 1;
}
}
DataTable dt = null;
if (Request.QueryString["org"] == null)
{
dt = ReferrerDB.GetDataTable(referrerID, searchName, searchNameOnlyStartsWith, chkShowDeleted.Checked);
dt.Columns.Add("count", typeof(Int32));
dt.Columns.Add("count_deleted", typeof(Int32));
for (int i = 0; i < dt.Rows.Count; i++)
{
int referrer_id = Convert.ToInt32(dt.Rows[i]["referrer_id"]);
dt.Rows[i]["count"] = countHash[referrer_id] == null ? 0 : (int)countHash[referrer_id];
dt.Rows[i]["count_deleted"] = countDeletedHash[referrer_id] == null ? 0 : (int)countDeletedHash[referrer_id];
}
}
else
{
if (!Regex.IsMatch(Request.QueryString["org"], @"^\d+$"))
{
HideTableAndSetErrorMessage("Invalid url org");
return;
}
Organisation org = OrganisationDB.GetByID(Convert.ToInt32(Request.QueryString["org"]));
if (org == null)
{
HideTableAndSetErrorMessage("Invalid url org");
return;
}
lblHeading.Text = "Referrers at " + org.Name;
dt = RegisterReferrerDB.GetDataTable_ReferrersOf(org.OrganisationID, true, chkShowDeleted.Checked, searchName, searchNameOnlyStartsWith);
dt.Columns.Add("count", typeof(Int32));
dt.Columns.Add("count_deleted", typeof(Int32));
dt.Columns.Add("is_deleted", typeof(Boolean));
for (int i = 0; i < dt.Rows.Count; i++)
{
int referrer_id = Convert.ToInt32(dt.Rows[i]["referrer_id"]);
dt.Rows[i]["count"] = countHash[referrer_id] == null ? 0 : (int)countHash[referrer_id];
dt.Rows[i]["count_deleted"] = countDeletedHash[referrer_id] == null ? 0 : (int)countDeletedHash[referrer_id];
// update these so when delete/undelete - it removes the connection, not the referrer
dt.Rows[i]["referrer_id"] = dt.Rows[i]["register_referrer_id"];
dt.Rows[i]["is_deleted"] = dt.Rows[i]["register_referrer_is_deleted"];
}
}
Session["referrerinfoperson_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["referrerinfoperson_sortexpression"] != null && Session["referrerinfoperson_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["referrerinfoperson_sortexpression"].ToString();
GrdReferrer.DataSource = dataView;
}
else
{
GrdReferrer.DataSource = dt;
}
try
{
GrdReferrer.DataBind();
GrdReferrer.PagerSettings.FirstPageText = "1";
GrdReferrer.PagerSettings.LastPageText = GrdReferrer.PageCount.ToString();
GrdReferrer.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdReferrer.DataSource = dt;
GrdReferrer.DataBind();
int TotalColumns = GrdReferrer.Rows[0].Cells.Count;
GrdReferrer.Rows[0].Cells.Clear();
GrdReferrer.Rows[0].Cells.Add(new TableCell());
GrdReferrer.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdReferrer.Rows[0].Cells[0].Text = "No Record Found";
}
if (Request.QueryString["org"] != null)
{
GrdReferrer.FooterRow.Visible = false;
GrdReferrer.Columns[GrdReferrer.Columns.Count - 2].Visible = false;
}
}
protected void GrdRegistration_RowDataBound(object sender, GridViewRowEventArgs e)
{
Organisation org = OrganisationDB.GetByID(GetFormID());
if (org == null)
{
HideTableAndSetErrorMessage("", "Invalid URL Parameters");
return;
}
DataTable dt = Session["registerreferrertoorg_data"] as DataTable;
bool tblEmpty = (dt.Rows.Count == 1 && dt.Rows[0][0] == DBNull.Value);
if (!tblEmpty && e.Row.RowType == DataControlRowType.DataRow)
{
Label lblId = (Label)e.Row.FindControl("lblId");
DataRow[] foundRows = dt.Select("register_referrer_id=" + lblId.Text);
DataRow thisRow = foundRows[0];
DropDownList ddlReferrer = (DropDownList)e.Row.FindControl("ddlReferrer");
if (ddlReferrer != null)
{
Referrer[] incList_orig = RegisterReferrerDB.GetReferrersOf(org.OrganisationID);
Referrer[] incList = Referrer.RemoveByID(incList_orig, Convert.ToInt32(thisRow["referrer_id"]));
DataTable referrers = ReferrerDB.GetDataTable_AllNotInc(incList);
referrers.DefaultView.Sort = "surname ASC";
foreach (DataRowView row in referrers.DefaultView)
{
ddlReferrer.Items.Add(new ListItem(row["surname"].ToString() + ", " + row["firstname"].ToString() + " " + row["middlename"].ToString(), row["referrer_id"].ToString()));
}
ddlReferrer.SelectedValue = thisRow["referrer_id"].ToString();
}
Utilities.AddConfirmationBox(e);
if ((e.Row.RowState & DataControlRowState.Edit) > 0)
{
Utilities.SetEditRowBackColour(e, System.Drawing.Color.LightGoldenrodYellow);
}
}
if (e.Row.RowType == DataControlRowType.Footer)
{
DropDownList ddlReferrer = (DropDownList)e.Row.FindControl("ddlNewReferrer");
if (ddlReferrer != null)
{
Referrer[] incList = RegisterReferrerDB.GetReferrersOf(org.OrganisationID);
DataTable referrers = ReferrerDB.GetDataTable_AllNotInc(incList);
referrers.DefaultView.Sort = "surname ASC";
foreach (DataRowView row in referrers.DefaultView)
{
ddlReferrer.Items.Add(new ListItem(row["surname"].ToString() + ", " + row["firstname"].ToString() + " " + row["middlename"].ToString(), row["referrer_id"].ToString()));
}
if (referrers.Rows.Count == 0)
{
hideFotter = true;
}
}
DropDownList ddlIsClinic = (DropDownList)e.Row.FindControl("ddlNewIsClinic");
ddlIsClinic.SelectedValue = UserView.GetInstance().IsClinicView ? "1" : "0";
}
}
protected void FillGrid()
{
int bulk_letter_sending_queue_batch_id = IsValidFormBatchID() ? GetFormBatchID() : -1;
DataTable dt = BulkLetterSendingQueueDB.GetDataTable(bulk_letter_sending_queue_batch_id);
// send method hashtable
DataTable sendMethodTbl = DBBase.GetGenericDataTable_WithWhereOrderClause(null, "LetterPrintHistorySendMethod", "", "", "letter_print_history_send_method_id", "descr");
Hashtable sendMethodHash = new Hashtable();
for (int i = 0; i < sendMethodTbl.Rows.Count; i++)
{
sendMethodHash[Convert.ToInt32(sendMethodTbl.Rows[i]["letter_print_history_send_method_id"])] = (string)sendMethodTbl.Rows[i]["descr"];
}
// patient hashtable
ArrayList ptIDs = new ArrayList();
for (int i = 0; i < dt.Rows.Count; i++)
{
if (dt.Rows[i]["patient_id"] != DBNull.Value)
{
ptIDs.Add((int)dt.Rows[i]["patient_id"]);
}
}
Hashtable patientHash = PatientDB.GetByIDsInHashtable((int[])ptIDs.ToArray(typeof(int)));
// staff hashtable
Hashtable staffHash = StaffDB.GetAllInHashtable(true, true, true, false);
// referrersHash
Hashtable referrersHash = ReferrerDB.GetHashtableByReferrer();
// letters hashtable
Hashtable letterHash = LetterDB.GetHashTable();
// add from hashtable
dt.Columns.Add("letter_print_history_send_method_descr", typeof(String));
dt.Columns.Add("added_by_name", typeof(String));
dt.Columns.Add("patient_name", typeof(String));
dt.Columns.Add("referrer_name", typeof(String));
dt.Columns.Add("letter_doc_name", typeof(String));
int SMSSent = 0;
int SMSUnSent = 0;
int EmailSent = 0;
int EmailUnSent = 0;
int PrintSent = 0;
int PrintUnSent = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
int letter_print_history_send_method_id = Convert.ToInt32(dt.Rows[i]["letter_print_history_send_method_id"]);
bool sent = dt.Rows[i]["datetime_sent"] != DBNull.Value;
dt.Rows[i]["letter_print_history_send_method_descr"] = (string)sendMethodHash[letter_print_history_send_method_id];
dt.Rows[i]["added_by_name"] = dt.Rows[i]["added_by"] == DBNull.Value ? "" : ((Staff)staffHash[Convert.ToInt32(dt.Rows[i]["added_by"])]).Person.FullnameWithoutMiddlename;
dt.Rows[i]["patient_name"] = dt.Rows[i]["patient_id"] == DBNull.Value ? "" : ((Patient)patientHash[Convert.ToInt32(dt.Rows[i]["patient_id"])]).Person.FullnameWithoutMiddlename;
dt.Rows[i]["referrer_name"] = dt.Rows[i]["referrer_id"] == DBNull.Value ? "" : ((Referrer)referrersHash[Convert.ToInt32(dt.Rows[i]["referrer_id"])]).Person.FullnameWithoutMiddlename;
string source_template_path = dt.Rows[i]["email_letter_source_template_path"].ToString();
string letter_doc_name = source_template_path.Length == 0 ? "" : System.IO.Path.GetFileName(source_template_path);
dt.Rows[i]["letter_doc_name"] = letter_doc_name;
if (letter_print_history_send_method_id == 3 && sent)
{
SMSSent++;
}
if (letter_print_history_send_method_id == 3 && !sent)
{
SMSUnSent++;
}
if (letter_print_history_send_method_id == 2 && sent)
{
EmailSent++;
}
if (letter_print_history_send_method_id == 2 && !sent)
{
EmailUnSent++;
}
if (letter_print_history_send_method_id == 1 && sent)
{
PrintSent++;
}
if (letter_print_history_send_method_id == 1 && !sent)
{
PrintUnSent++;
}
}
lblSMSSent.Text = SMSSent.ToString();
lblSMSUnSent.Text = SMSUnSent.ToString();
lblEmailSent.Text = EmailSent.ToString();
lblEmailUnSent.Text = EmailUnSent.ToString();
lblPrintSent.Text = PrintSent.ToString();
lblPrintUnSent.Text = PrintUnSent.ToString();
lblTotalSent.Text = (SMSSent + EmailSent + PrintSent).ToString();
lblTotalUnSent.Text = (SMSUnSent + EmailUnSent + PrintUnSent).ToString();
DataView dv = new DataView(dt);
dv.Sort = "letter_print_history_send_method_id";
dt = dv.ToTable();
Session["lettersprintbatchstatus_data"] = dt;
if (dt.Rows.Count > 0)
{
if (IsPostBack && Session["lettersprintbatchstatus_sortexpression"] != null && Session["lettersprintbatchstatus_sortexpression"].ToString().Length > 0)
{
DataView dataView = new DataView(dt);
dataView.Sort = Session["lettersprintbatchstatus_sortexpression"].ToString();
GrdBulkLetterSendingQueue.DataSource = dataView;
}
else
{
GrdBulkLetterSendingQueue.DataSource = dt;
}
GrdBulkLetterSendingQueue.AllowPaging = false;
try
{
GrdBulkLetterSendingQueue.DataBind();
GrdBulkLetterSendingQueue.PagerSettings.FirstPageText = "1";
GrdBulkLetterSendingQueue.PagerSettings.LastPageText = GrdBulkLetterSendingQueue.PageCount.ToString();
GrdBulkLetterSendingQueue.DataBind();
}
catch (Exception ex)
{
HideTableAndSetErrorMessage("", ex.ToString());
}
}
else
{
dt.Rows.Add(dt.NewRow());
GrdBulkLetterSendingQueue.DataSource = dt;
GrdBulkLetterSendingQueue.DataBind();
int TotalColumns = GrdBulkLetterSendingQueue.Rows[0].Cells.Count;
GrdBulkLetterSendingQueue.Rows[0].Cells.Clear();
GrdBulkLetterSendingQueue.Rows[0].Cells.Add(new TableCell());
GrdBulkLetterSendingQueue.Rows[0].Cells[0].ColumnSpan = TotalColumns;
GrdBulkLetterSendingQueue.Rows[0].Cells[0].Text = "No Record Found";
}
}
protected bool IsValidFormRegReferrer()
{
string referrer_id = Request.QueryString["referrer"];
return(referrer_id != null && Regex.IsMatch(referrer_id, @"^\d+$") && ReferrerDB.Exists(Convert.ToInt32(referrer_id)));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utilities.SetNoCache(Response);
}
try
{
if (Session == null || Session["DB"] == null)
{
throw new SessionTimedOutException();
}
string fieldsSep = "|";
string itemSep = "<>";
string id = Request.QueryString["id"];
if (id == null || !Regex.IsMatch(id, @"^\-?\d+$"))
{
throw new CustomMessageException();
}
string type = Request.QueryString["type"];
if (type == null || (type.ToLower() != "patient" && type.ToLower() != "staff" && type.ToLower() != "referrer" && type.ToLower() != "register_referrer"))
{
throw new CustomMessageException();
}
Person person = null;
int contactEntityID = -1;
if (type == "patient")
{
Patient patient = PatientDB.GetByID(Convert.ToInt32(id));
if (patient == null)
{
throw new CustomMessageException();
}
person = patient.Person;
contactEntityID = patient.Person.EntityID;
}
else if (type == "staff")
{
Staff staff = StaffDB.GetByID(Convert.ToInt32(id));
if (staff == null)
{
throw new CustomMessageException();
}
person = staff.Person;
contactEntityID = staff.Person.EntityID;
}
else if (type == "referrer")
{
Referrer referrer = ReferrerDB.GetByID(Convert.ToInt32(id));
if (referrer == null)
{
throw new CustomMessageException();
}
person = referrer.Person;
contactEntityID = referrer.Person.EntityID;
}
else if (type == "register_referrer")
{
RegisterReferrer regReferrer = RegisterReferrerDB.GetByID(Convert.ToInt32(id));
if (regReferrer == null || regReferrer.Referrer == null)
{
throw new CustomMessageException();
}
person = regReferrer.Referrer.Person;
contactEntityID = regReferrer.Organisation.EntityID;
}
else
{
throw new CustomMessageException();
}
string details = GetDetails(person, contactEntityID, fieldsSep, itemSep);
Response.Write(details);
}
catch (SessionTimedOutException)
{
Utilities.UnsetSessionVariables();
Response.Write("SessionTimedOutException");
}
catch (Exception ex)
{
Response.Write("Exception: " + (Utilities.IsDev() ? ex.ToString() : "please contact system administrator."));
}
}
