protected void btnGenerateSystemLetters_Click(object sender, EventArgs e)
{
System.Collections.ArrayList fileContentsList = new System.Collections.ArrayList();
Booking[] bookings = BookingDB.GetBookingsToGenerateSystemLetters(DateTime.MinValue, DateTime.MinValue, GetFormID());
for (int i = 0; i < bookings.Length; i++)
{
// send referrer letters
PatientReferrer[] patientReferrers = PatientReferrerDB.GetActiveEPCPatientReferrersOf(bookings[i].Patient.PatientID);
if (patientReferrers.Length > 0)
{
HealthCard hc = HealthCardDB.GetActiveByPatientID(bookings[i].Patient.PatientID);
bool needToGenerateTreatmentLetter = patientReferrers[patientReferrers.Length - 1].RegisterReferrer.ReportEveryVisitToReferrer;
Letter.FileContents[] bookingFileContentsList = bookings[i].GetSystemLettersList(Letter.FileFormat.Word, bookings[i].Patient, hc, bookings[i].Offering.Field.ID, patientReferrers[patientReferrers.Length - 1].RegisterReferrer.Referrer, true, bookings[i].NeedToGenerateFirstLetter, bookings[i].NeedToGenerateLastLetter, needToGenerateTreatmentLetter, false, Convert.ToInt32(Session["SiteID"]), Convert.ToInt32(Session["StaffID"]), 1);
fileContentsList.AddRange(bookingFileContentsList);
BookingDB.UpdateSetGeneratedSystemLetters(bookings[i].BookingID, bookings[i].NeedToGenerateFirstLetter, bookings[i].NeedToGenerateLastLetter, true);
}
}
Letter.FileContents mergedFileContents = Letter.FileContents.Merge((Letter.FileContents[])fileContentsList.ToArray(typeof(Letter.FileContents)), "Treatment Letters.doc"); // .pdf
if (mergedFileContents != null)
{
Session["downloadFile_Contents"] = mergedFileContents.Contents;
Session["downloadFile_DocName"] = mergedFileContents.DocName;
Page.ClientScript.RegisterStartupScript(this.GetType(), "download", "<script language=javascript>window.open('DownloadFile.aspx','_blank','status=1,toolbar=0,menubar=0,location=1,scrollbars=1,resizable=1,width=30,height=30');</script>");
}
UpdateGenerateSystemLetters();
}
protected void InsertEmail(bool PT, bool GP)
{
if (txtUpdatePatientID.Text.Length == 0)
{
SetErrorMessage("No PT Selected");
return;
}
string[] emails = null;
string refName = null;
Patient patient = PatientDB.GetByID(Convert.ToInt32(txtUpdatePatientID.Text));
if (PT)
{
emails = ContactDB.GetEmailsByEntityID(patient.Person.EntityID);
}
else if (GP)
{
PatientReferrer[] patRefs = PatientReferrerDB.GetActiveEPCPatientReferrersOf(patient.PatientID);
if (patRefs.Length > 0)
{
refName = patRefs[0].RegisterReferrer.Referrer.Person.FullnameWithoutMiddlename;
emails = ContactDB.GetEmailsByEntityID(patRefs[0].RegisterReferrer.Organisation.EntityID);
}
}
if (emails != null && emails.Length > 0)
{
txtEmailTo.Text = string.Join(",", emails);
}
else
{
if (PT)
{
SetErrorMessage("No email address set for " + patient.Person.FullnameWithoutMiddlename + "<br />");
}
else if (GP && refName == null)
{
SetErrorMessage("No referrer set for " + patient.Person.FullnameWithoutMiddlename + "<br />");
}
else if (GP)
{
SetErrorMessage("No email set for referrer " + refName + "<br />");
}
txtEmailTo.Text = string.Empty;
}
}
protected Tuple <string, string, string, string> GetReferrersEmail()
{
if (!IsValidFormID())
{
return(null);
}
Booking booking = BookingDB.GetByEntityID(GetFormID());
if (booking == null || booking.Patient == null)
{
return(null);
}
PatientReferrer[] patientReferrer = PatientReferrerDB.GetActiveEPCPatientReferrersOf(booking.Patient.PatientID);
if (patientReferrer.Length == 0)
{
return(null);
}
PatientReferrer currentPatRegReferrer = patientReferrer[patientReferrer.Length - 1];
RegisterReferrer curRegReferrer = currentPatRegReferrer.RegisterReferrer;
//string refName = curRegReferrer.Referrer.Person.Surname + ", " + curRegReferrer.Referrer.Person.Firstname + " [" + curRegReferrer.Organisation.Name + "]" + " [" + currentPatRegReferrer.PatientReferrerDateAdded.ToString("dd-MM-yyyy") + "]";
//SetErrorMessage("Name: " + refName);
string[] emails = ContactDB.GetEmailsByEntityID(currentPatRegReferrer.RegisterReferrer.Organisation.EntityID);
if (emails.Length == 0)
{
return(null);
}
string refEmail = string.Join(",", emails);
string refName = (curRegReferrer.Referrer.Person.Title.ID == 0 ? "Dr." : curRegReferrer.Referrer.Person.Title.Descr) + " " + curRegReferrer.Referrer.Person.Surname;
string bookingOrg = booking.Organisation.Name;
string bookingPatientName = booking.Patient.Person.FullnameWithoutMiddlename;
return(new Tuple <string, string, string, string>(refEmail, refName, bookingOrg, bookingPatientName));
}
protected void SetOrUpdateReferrer(int newRegisterReferrerID)
{
// if change this back to " = PatientReferrerDB.GetEPCPatientReferrersOf(patient.PatientID); " then make sure go through whole list
PatientReferrer[] patientReferrer = PatientReferrerDB.GetActiveEPCPatientReferrersOf(this.PatientID);
if (patientReferrer.Length > 0)
{
PatientReferrer currentPatRegReferrer = patientReferrer[patientReferrer.Length - 1];
RegisterReferrer curRegReferrer = currentPatRegReferrer.RegisterReferrer;
if (curRegReferrer.RegisterReferrerID == newRegisterReferrerID)
{
return;
}
else
{
PatientReferrerDB.UpdateSetInactive(currentPatRegReferrer.PatientReferrerID);
}
}
PatientReferrerDB.Insert(this.PatientID, newRegisterReferrerID, 0, false);
InitForm();
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
Utilities.SetNoCache(Response);
}
try
{
if (Session == null || Session["DB"] == null)
{
throw new SessionTimedOutException();
}
string id = Request.QueryString["id"];
if (id == null)
{
throw new CustomMessageException("No id in url");
}
if (!Regex.IsMatch(id, @"^\d+$"))
{
throw new CustomMessageException("Booking id does not exist or is not a number");
}
string id_type = Request.QueryString["id_type"];
if (id_type == null)
{
throw new CustomMessageException("No id_type in url");
}
if (id_type != "patient" && id_type != "healthcard")
{
throw new CustomMessageException("Unknown id_type in url not in ('patient','healthcard') : '" + id_type + "'");
}
int patientID = -1;
if (id_type == "patient")
{
patientID = Convert.ToInt32(id);
}
else
{
HealthCard hc = HealthCardDB.GetByID(Convert.ToInt32(id));
if (hc != null)
{
patientID = hc.Patient.PatientID;
}
}
if (!PatientDB.Exists(patientID))
{
throw new CustomMessageException("Unknown patient id : " + patientID);
}
bool hasReferrer = PatientReferrerDB.GetActiveEPCPatientReferrersOf(patientID).Length > 0;
Response.Write(hasReferrer ? "1" : "0");
}
catch (SessionTimedOutException)
{
Utilities.UnsetSessionVariables();
Response.Write("SessionTimedOutException");
}
catch (Exception ex)
{
Response.Write("Exception: " + (Utilities.IsDev() ? ex.ToString() : "Error - please contact system administrator."));
}
}
protected void InitForm(int patientID)
{
HideAllRows();
string url = "/PatientReferrerHistoryPopupV2.aspx?id=" + patientID;
string text = "History";
string onclick = @"onclick=""open_new_tab('" + url + @"');return false;""";
lblPatientReferrerHistoryPopup.Text = "<a " + onclick + " href=\"\">" + text + "</a>";
PatientReferrer[] patientReferrer = PatientReferrerDB.GetActiveEPCPatientReferrersOf(patientID); // = PatientReferrerDB.GetEPCPatientReferrersOf(patient.PatientID);
if (patientReferrer.Length > 0)
{
PatientReferrer currentPatRegReferrer = patientReferrer[patientReferrer.Length - 1]; // get latest
RegisterReferrer curRegReferrer = currentPatRegReferrer.RegisterReferrer;
displayHaveReferrerRow.Visible = true;
// only allow removing a referrer if no EPC set [ie no active healthcard, or healthcard with neither date set]
HealthCard hc = HealthCardDB.GetActiveByPatientID(patientID);
bool allowDelete = hc == null || !hc.HasEPC();
btnDelete.Visible = allowDelete;
lblDeleteRegistrationReferrerBtnSeperator.Visible = allowDelete;
//lblReferrer.Text = curRegReferrer.Referrer.Person.Surname + ", " + curRegReferrer.Referrer.Person.Firstname + " [" + curRegReferrer.Organisation.Name + "]" + " [" + currentPatRegReferrer.PatientReferrerDateAdded.ToString("dd-MM-yyyy") + "]";
string phNumTxt = string.Empty;
if (Utilities.GetAddressType().ToString() == "Contact")
{
Contact[] phNums = ContactDB.GetByEntityID(2, curRegReferrer.Organisation.EntityID);
for (int i = 0; i < phNums.Length; i++)
{
phNumTxt += (i > 0 ? "<br />" : "") + Utilities.FormatPhoneNumber(phNums[i].AddrLine1) + " (" + phNums[i].ContactType.Descr + ")";
}
}
else if (Utilities.GetAddressType().ToString() == "ContactAus")
{
ContactAus[] phNums = ContactAusDB.GetByEntityID(2, curRegReferrer.Organisation.EntityID);
for (int i = 0; i < phNums.Length; i++)
{
phNumTxt += (i > 0 ? "<br />" : "") + Utilities.FormatPhoneNumber(phNums[i].AddrLine1) + " (" + phNums[i].ContactType.Descr + ")";
}
}
else
{
throw new Exception("Unknown AddressType in config: " + Utilities.GetAddressType().ToString().ToString());
}
lblReferrer.Text = curRegReferrer.Referrer.Person.Surname + ", " + curRegReferrer.Referrer.Person.Firstname + (curRegReferrer.Organisation.Name.Length == 0 ? "" : " [" + curRegReferrer.Organisation.Name + "]") + "<br />" + Environment.NewLine +
"<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\">" + Environment.NewLine +
"<tr><td>" + "Provider Nbr:" + "</td><td style=\"width:12px\"></td><td><font color=\"#A52A2A\">" + currentPatRegReferrer.RegisterReferrer.ProviderNumber + "</font></td></tr>" + Environment.NewLine +
"<tr><td>" + "Date Added:" + "</td><td style=\"width:12px\"></td><td><font color=\"#A52A2A\">" + currentPatRegReferrer.PatientReferrerDateAdded.ToString("dd-MM-yyyy") + "</font></td></tr>" + Environment.NewLine +
"</table>" + Environment.NewLine +
(phNumTxt.Length == 0 ? "" : phNumTxt + "<br />"); // put in referrers fax and phone numbers
lblReferrerRegisterID.Text = curRegReferrer.RegisterReferrerID.ToString();
}
else
{
displayNoReferrerRow.Visible = true;
}
}
