protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa pDa = new PatientDa();
DataSet hpiDs = pDa.GetPatientHPIBladder(this.patientID);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
int rowCount = hpiDs.Tables[0].Rows.Count;
/* if (rowCount < NumHpiRowsAllowed)
* {
* int newHeight = (NumHpiRowsAllowed-rowCount)*10;
* HpiSpacer.Height = newHeight;
* }
*/
}
catch (Exception ex)
{
// HpiSpacer.Height = NumHpiRowsAllowed*10;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
}
/* else
* {
* HpiSpacer.Height = NumHpiRowsAllowed*14;
* }
*/
}
protected void BuildHPI()
{
if (patientID != 0)
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPI(this.patientID, 0, 0);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
int rowCount = hpiDs.Tables[0].Rows.Count;
//nomograms are in a second result set
/* preRPNomo.Text = hpiDs.Tables[1].Rows[0]["preRPNomo"].ToString();
* preXRTNomo.Text = hpiDs.Tables[1].Rows[0]["preXRTNomo"].ToString();
* preBrachyNomo.Text = hpiDs.Tables[1].Rows[0]["preBrachyNomo"].ToString();
* postRP7yrNomo.Text = hpiDs.Tables[1].Rows[0]["postRP7yrNomo"].ToString();
*/
// set the value of the biopsy Id that is to be REMOVED from the results of the
// stored proc spFormListBiopsies so that the biopsy is only listed once in the
// hpi section of the form
if (hpiDs.Tables[1].Rows[0]["DxBiopsyId"] != null && hpiDs.Tables[1].Rows[0]["DxBiopsyId"].ToString().Length > 0)
{
hpiBiopsyId = (int)hpiDs.Tables[1].Rows[0]["DxBiopsyId"];
}
}
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPI(this.patientID, 0, 0);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
int rowCount = hpiDs.Tables[0].Rows.Count;
if (hpiDs.Tables[1].Rows[0]["DxBiopsyId"] != null && hpiDs.Tables[1].Rows[0]["DxBiopsyId"].ToString().Length > 0)
{
hpiBiopsyId = (int)hpiDs.Tables[1].Rows[0]["DxBiopsyId"];
ShowDxBiopsy(hpiBiopsyId);
}
}
catch (Exception ex)
{
hpi.Visible = false;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
}
}
/// <summary>
/// Returns a Table which represent the TableName and TableCount of tables and respecitive records
/// which must be deleted manually before deleting the patient record. 0 rows =no restrictions
/// </summary>
/// <param name="patientId">The PatientId of the patient to check</param>
/// <returns>A table containing TableName, TableCount of child table constraints.</returns>
public DataTable ValidatePatientDeleteConstraints(int patientId)
{
PatientDa da = new PatientDa();
DataTable dt = da.ValidatePatientDeletion(patientId).Tables[0];
return(dt);
}
private void PopulateResults()
{
if (!String.IsNullOrEmpty(FollowUpListCriteria))
{
PatientListController ct = new PatientListController();
DataSet ds = null;
// get list of patients
string dsSQL = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]);
PatientDa ptDa = new PatientDa();
ds = ptDa.ListPatientsByContactStatusPhysicianAndDisease(dsSQL, new string[] { FollowUpListCriteria }, SelectedTreatingPhysicianId,
"Treating", SelectedPatientDisease, "", 0, 0);
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
rptPatient.DataSource = ds.Tables[0].DefaultView;
rptPatient.DataBind();
}
// three sp's used to retrieve patient lists and they all have an output parameter returning a record count
ResultsRecordCount = (int)ds.Tables[0].ExtendedProperties[ExtendedProperty.RowCount];
ResultsRecordMemo = ResultsRecordCount + " patients returned";
}
}
}
public DataSet FindPatientByIdentifier(string searchFilter, string identifierType, string datasetSQL)
{
ValidatePatientIdentifierSearch(identifierType);
PatientDa da = new PatientDa();
return(da.FindPatientByIdentifier(searchFilter, identifierType, datasetSQL));
}
public DataSet FindPatient(string strFind, string datasetSQL)
{
ValidatePatientSearch();
PatientDa da = new PatientDa();
return(da.FindPatient(strFind, datasetSQL));
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPITestis(this.patientID);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
// int rowCount = hpiDs.Tables[0].Rows.Count;
// if (rowCount < NumHpiRowsAllowed)
// {
// int newHeight = (NumHpiRowsAllowed-rowCount)*10;
// HpiSpacer.Height = newHeight;
// }
}
catch (Exception ex)
{
HpiSpacer.Height = NumHpiRowsAllowed * 10;
ExceptionHandler.Publish(ex);
}
}
else
{
HpiSpacer.Height = NumHpiRowsAllowed * 10;
}
}
/* protected void LoadSurveyForm()
* {
* if (null != SurveyFormHolder)
* {
* SurveyFormControl = (Caisis.UI.Core.Classes.BasePaperFormControl)this.LoadControl("UroSurveyUrinSexFunc.ascx");
*
*
* SurveyFormControl.BatchPatientId = this._batchPatientId;
* SurveyFormControl.FormInPatientId = this._formInPatientId;
* SurveyFormControl.FormAppointmentId = this._formAppointmentId;
*
*
*
* SurveyFormHolder.Controls.Add(SurveyFormControl);
* }
* }
*/
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPIProstateGU(this.patientID, 0);
if (hpiDs.Tables[0].Rows.Count > 0)
{
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
}
}
catch (Exception ex)
{
hpi.Visible = false;
ExceptionHandler.Publish(ex);
}
NomogramDa nda = new NomogramDa();
try
{
preRP5Nomo.Text = "PreRP 5: " + ((int)Math.Round(nda.GetPreRPResult(patientID, 5), 0)).ToString();
}
catch { }
try
{
preRP10Nomo.Text = "PreRP 10: " + ((int)Math.Round(nda.GetPreRPResult(patientID, 10), 0)).ToString();
}
catch { }
try
{
preXRTNomo.Text = "PreXRT: " + ((int)Math.Round(nda.GetPreXRTResult(patientID), 0)).ToString();
}
catch { }
try
{
preBrachyNomo.Text = "PreBrachy: " + ((int)Math.Round(nda.GetPreBrachyResult(patientID), 0)).ToString();
}
catch { }
/*
* try
* {
* psaDT.Text = "PSA Doubling Time calculated based on all PSA values from the last 6 months: " + ((int)Math.Round(nda.GetPreBrachyResult(patientID), 0)).ToString();
* }
* catch { }
*/
}
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPI(this.patientID, 0, 0);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
int rowCount = hpiDs.Tables[0].Rows.Count;
//nomograms are in a second result set
//preRPNomo.Text = hpiDs.Tables[1].Rows[0]["preRPNomo"].ToString();
//preXRTNomo.Text = hpiDs.Tables[1].Rows[0]["preXRTNomo"].ToString();
//preBrachyNomo.Text = hpiDs.Tables[1].Rows[0]["preBrachyNomo"].ToString();
NomogramDa nda = new NomogramDa();
try
{
preRP5Nomo.Text = ((int)Math.Round(nda.GetPreRPResult(patientID, 5), 0)).ToString();
}
catch { }
try
{
preRP10Nomo.Text = ((int)Math.Round(nda.GetPreRPResult(patientID, 10), 0)).ToString();
}
catch { }
try
{
preXRTNomo.Text = ((int)Math.Round(nda.GetPreXRTResult(patientID), 0)).ToString();
}
catch { }
try
{
preBrachyNomo.Text = ((int)Math.Round(nda.GetPreBrachyResult(patientID), 0)).ToString();
}
catch { }
}
catch (Exception ex)
{
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
}
// else
// {
// HpiSpacer.Height = NumHpiRowsAllowed*12;
// }
}
protected void BindData(Object Sender, RepeaterItemEventArgs e)
{
Literal ProbsPlans = (Literal)e.Item.FindControl("ProbsPlans");
Literal PtHPI = (Literal)e.Item.FindControl("PtHPI");
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
DataRowView drv = (DataRowView)e.Item.DataItem;
string PtId = drv["ApptPatientId"].ToString();
string physician = drv["ApptPhysician"].ToString();
if (!string.IsNullOrEmpty(PtId))
{
//gets all problems from recent encounter per patient per physician
DataTable ProbsDt = da.GetProblems(PtId, physician);
StringBuilder plstr = new StringBuilder();
StringBuilder str = new StringBuilder();
if (ProbsDt.Rows.Count > 0)
{
foreach (DataRow probs in ProbsDt.Rows)
{
string ProbPlanDt = probs["EnteredDate"].ToString();
string ProbName = probs["ProblemName"].ToString();
int PtprobId = int.Parse(probs["PatientProblemId"].ToString());
//gets all plans per problem
DataTable PlansDt = da.GetPlans(PtprobId);
if (PlansDt.Rows.Count > 0)
{
foreach (DataRow plans in PlansDt.Rows)
{
string PlanName = plans["PlanName"].ToString();
plstr.Append(PlanName + ", ");
}
str.Append("<strong>Problem:</strong> " + ProbName + "<br/><strong>Plans:</strong> " + plstr.ToString() + "<br/><br/>");
}
ProbsPlans.Text = "<strong>Visit Date:</strong> " + ProbPlanDt + "<br/>" + str.ToString();
plstr.Remove(0, plstr.Length);
}
}
//gets HPI data for each patient
PatientDa ptDa = new PatientDa();
DataSet hpiDs = ptDa.GetPatientHPI(int.Parse(PtId), 0, 0);
StringBuilder hpiStr = new StringBuilder();
if (hpiDs.Tables[0].Rows.Count > 0)
{
foreach (DataRow hpi in hpiDs.Tables[0].Rows)
{
string hpiData = hpi["patientHPI"].ToString();
hpiStr.Append(hpiData + "<br/>");
}
}
PtHPI.Text = hpiStr.ToString();
}
}
}
/// <summary>
/// Returns if a Patient (by patient id) is in the specifiec dataset.
/// </summary>
/// <param name="patientId"></param>
/// <param name="datasetSQL"></param>
/// <returns></returns>
public bool IsPatientInDataset(int patientId, string datasetSQL)
{
bool isInDataset = false;
if (!string.IsNullOrEmpty(datasetSQL))
{
isInDataset = new PatientDa().IsPatientInDataset(patientId, datasetSQL);
}
return(isInDataset);
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPIBreast(this.patientID);
if (hpiDs.Tables[0].Rows.Count > 0)
{
DataColumn VarOrderNumCol = new DataColumn("VarOrderNum", typeof(System.Int32));
hpiDs.Tables[0].Columns.Add(VarOrderNumCol);
DataColumn IsAppendedRowCol = new DataColumn("RowType", typeof(System.String));
hpiDs.Tables[0].Columns.Add(IsAppendedRowCol);
for (int i = 0; i < hpiDs.Tables[0].Rows.Count; i++)
{
hpiDs.Tables[0].Rows[i]["VarOrderNum"] = i;
hpiDs.Tables[0].Rows[i]["RowType"] = "normal";
}
int currentRowId = 0;
for (int k = 0; k < hpiDs.Tables[0].Rows.Count; k++)
{
currentRowId = Convert.ToInt16(hpiDs.Tables[0].Rows[k]["RowId"]);
for (int j = 0; j < hpiDs.Tables[0].Rows.Count; j++)
{
if (j != k && hpiDs.Tables[0].Rows[j]["RelatedRowId"].Equals(currentRowId))
{
hpiDs.Tables[0].Rows[j]["VarOrderNum"] = hpiDs.Tables[0].Rows[k]["VarOrderNum"];
hpiDs.Tables[0].Rows[j]["RowType"] = "multi";
hpiDs.Tables[0].Rows[k]["RowType"] = "start multi";
}
}
}
DataView hpiDv = hpiDs.Tables[0].DefaultView;
hpiDv.Sort = "VarOrderNum ASC, RowId ASC";
hpi.DataSource = hpiDv;
hpi.DataBind();
}
}
catch (Exception ex)
{
hpi.Visible = false;
ExceptionHandler.Publish(ex);
}
}
}
protected void BuildPastProblemsPlans(int PatientID)
{
if (Session[SessionKey.CurrentListCrit] != null && Session[SessionKey.CurrentListCrit].ToString().Length > 0)
{
PatientDa pDa = new PatientDa();
DataSet pDs = pDa.FormGetLastPatientProblemPlans(PatientID, Session[SessionKey.CurrentListCrit].ToString());
if (pDs.Tables.Count > 0 && pDs.Tables[0].Rows.Count > 0)
{
NoPastProblemsMsgRow.Visible = false;
ShowPastProblemsOnLoad(true);
string currentProblemId = "";
int currentProblemNumber = 0;
int currentPlanNumber = 0;
int currentProblemDataRowIndex = 0;
pDs.Tables[0].Columns.Add("ProblemNumber");
pDs.Tables[0].Columns.Add("PlanNumber");
pDs.Tables[0].Columns.Add("ProblemDisplayRowSpan");
for (int i = 0; i < pDs.Tables[0].Rows.Count; i++)
{
if (pDs.Tables[0].Rows[i]["PatientProblemId"].ToString().Equals(currentProblemId))
{
currentPlanNumber += 1;
pDs.Tables[0].Rows[i]["ProblemName"] = " ";
pDs.Tables[0].Rows[currentProblemDataRowIndex]["ProblemDisplayRowSpan"] = (i - currentProblemDataRowIndex + 1);
pDs.Tables[0].Rows[i]["ProblemDisplayRowSpan"] = 0;
}
else
{
currentProblemNumber += 1;
currentPlanNumber = 1;
currentProblemDataRowIndex = i;
pDs.Tables[0].Rows[i]["ProblemDisplayRowSpan"] = 1;
}
pDs.Tables[0].Rows[i]["ProblemNumber"] = currentProblemNumber.ToString();
pDs.Tables[0].Rows[i]["PlanNumber"] = currentPlanNumber.ToString();
currentProblemId = pDs.Tables[0].Rows[i]["PatientProblemId"].ToString();
}
PastProblemsRpt.DataSource = pDs.Tables[0].DefaultView;
PastProblemsRpt.DataBind();
ShowPastProblemsOnLoad(true);
}
else
{
ShowPastProblemsOnLoad(false);
}
}
}
private void BuildPatientDemographics(int PatientID, string FormName, string FormType)
{
DataSet ptDemoGxDs;
PatientDa ptDemoDa = new PatientDa();
ptDemoGxDs = ptDemoDa.FormGetPatientsIdentificationAll(PatientID, FormName, FormType);
if (ptDemoGxDs.Tables.Count > 0 && ptDemoGxDs.Tables[0].Rows.Count > 0)
{
PtDemoGx.DataSource = ptDemoGxDs.Tables[0].DefaultView;
PtDemoGx.DataBind();
}
}
protected void BuildHPI()
{
try
{
PatientDa pDa = new PatientDa();
DataSet hpiDs = pDa.GetPatientHPIKidney(this._patientId);
DataView view = GetPatientHPIKidneyView(hpiDs.Tables[0]);
hpi.DataSource = view;
hpi.DataBind();
}
catch (Exception ex)
{
hpi.Visible = false;
ExceptionHandler.Publish(ex);
}
}
/// <summary>
///
/// </summary>
/// <param name="dsSQL"></param>
/// <param name="listName"></param>
/// <param name="listValue"></param>
/// <param name="listModifier"></param>
/// <param name="orderBy"></param>
/// <param name="startRow"></param>
/// <param name="numRows"></param>
/// <param name="clinicDate"></param>
/// <param name="listUser"></param>
/// <returns></returns>
public DataSet GetList(string dsSQL, string listName, string listValue, string listModifier, string orderBy, int startRow, int numRows, string clinicDate, string listUser)
{
DataSet ds = new DataSet();
try
{
PatientDa da = new PatientDa();
ds = da.ListPatients(dsSQL, listName, listValue, listModifier, orderBy, startRow, numRows, listUser);
}
catch (Exception e)
{
Caisis.UI.Core.Classes.ExceptionHandler.Publish(e);
//throw new ClientException(e.Message);
}
return(ds);
}
override protected void Page_Load(object sender, System.EventArgs e)
{
base.Page_Load(sender, e);
valMsg.Text = "";
groupMessage.Text = "";
AddBtn.ImageUrl = "../Images/AdminImages/submit.gif";
AddBtn.Width = 65;
AddBtn.Height = 21;
SelectPatientName.Attributes.Add("onchange", "this.form." + SelectSubmitted.ClientID + ".value = 'true'; this.form.submit();");
if (Page.IsPostBack)
{
//check if form is submitted from select box or to update password
if (!Request.Form["SelectPatientName"].Equals("") && Request.Form["SelectSubmitted"] != null && Request.Form["SelectSubmitted"].Equals("true"))
{
this.ShowInstitutionSelect(int.Parse(Request.Form["SelectPatientName"]));
}
}
else
{
// Put user code to initialize the page here
//don't use AdminUtil function because need username here
if (Request.QueryString["firstLetter"] != null && Request.QueryString["firstLetter"].ToString().Length > 0)
{
PatientDa das = new PatientDa();
string searchTerm = Request.QueryString["firstLetter"].ToString() + "%";
DataTable dt = das.GetPatientsByLastName(searchTerm);
DataView view = dt.DefaultView;
view.Sort = "PatientName ASC";
SelectPatientName.DataSource = view;
SelectPatientName.DataValueField = "PatientId";
SelectPatientName.DataTextField = "PatientName";
SelectPatientName.DataBind();
SelectPatientName.Items.Insert(0, new ListItem(""));
SelectedLetter.Value = Request.QueryString["firstLetter"].ToString();
}
else
{
SelectedLetter.Value = "";
}
SelectInstitutionTable.Visible = false;
}
}//end page_load
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa pDa = new PatientDa();
DataSet hpiDs = pDa.GetPatientHPIKidney(this.patientID);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
}
catch (Exception ex)
{
hpi.Visible = false;
ExceptionHandler.Publish(ex);
}
}
}
override protected void Page_Load(object sender, System.EventArgs e)
{
AppointmentDa aptDa = new AppointmentDa();
//populate clinic list Physicians from look up codes
//rptClinicPhysicians.DataSource = CacheManager.GetLookupCodeList("apptPhysician");
//updated 9/22 fs
rptClinicPhysicians.DataSource = aptDa.GetDistinctAppointmentPhysicians().Tables[0].DefaultView;
rptClinicPhysicians.DataBind();
//append inpatient services to the bottom of the clinic list drop down
//added 12/06/04 to allow form printing of inpatients
InPatientDa ipda = new InPatientDa();
rptInPatientServices.DataSource = ipda.GetInPatientServices();
rptInPatientServices.DataBind();
//populate contact status from distinct values- status also present in look up codes
PatientDa patDa = new PatientDa();
//count of patients in each contact status should be based on dataset user is logged into
string datasetSql = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]);
DataSet contactStatusDs = patDa.GetDistinctContactStatus(datasetSql);
rptStatus.DataSource = contactStatusDs;
rptStatus.DataBind();
//populate categories from distinct values, takes username to display private
SecurityController ct = new SecurityController();
string userName = ct.GetUserName();
CategoryDa catDa = new CategoryDa();
DataSet catDs = catDa.GetDistinctCategories(userName);
rptCategories.DataSource = catDs;
rptCategories.DataBind();
//v5.1: count of patients by action items
ActionDa actionDa = new ActionDa();
DataTable actionDt = actionDa.GetDistinctPatientActions(datasetSql);
rptActions.DataSource = actionDt;
rptActions.DataBind();
}
protected void BuildHPI()
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPIForEForm(this._patientId, 0, 0, 1);
if (hpiDs.Tables[0].Rows.Count > 0)
{
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
}
else
{
NoHPIMsg.Visible = true;
}
if (hpiDs.Tables[1].Rows[0]["DxBiopsyId"] != null && hpiDs.Tables[1].Rows[0]["DxBiopsyId"].ToString().Length > 0)
{
hpiBiopsyId = (int)hpiDs.Tables[1].Rows[0]["DxBiopsyId"];
ShowDxBiopsy(hpiBiopsyId);
}
}
catch (Exception ex)
{
hpi.Visible = false;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
PopulateHPIPreTxPotency();
BuildHpiProstatectomies(this._patientId, this._eformName, "Dynamic");
BuildHpiProtocols(this._patientId, this._eformName, "Dynamic");
BuildHpiBiopsies(this._patientId, this._eformName, "Dynamic", hpiBiopsyId);
BuildHPINerveStatus();
}
//protected Hashtable TimeSpanByYearsMonthsDays(DateTime FirstDate, DateTime SecondDate)
//{
// Hashtable span = new Hashtable();
// span.Add("Years", 0);
// span.Add("Months", 0);
// span.Add("Days", 0);
// int diff = (SecondDate - FirstDate).Days;
// if (diff > 365)
// {
// int years = (int)(Math.Floor(diff / 365.25));
// int extraMonthDays = (int)(Math.Floor(diff % (365.25)));
// int months = (int)(Math.Floor(extraMonthDays / (365.25 / 12)));
// int extraDays = (int)(Math.Round(extraMonthDays % (365.25 / 12)));
// span["Years"] = years;
// span["Months"] = months;
// span["Days"] = extraDays;
// }
// else if (diff > 30)
// {
// int months = (int)(Math.Floor(diff / (365.25 / 12)));
// int extraDays = (int)(Math.Round(diff % (365.25 / 12)));
// span["Months"] = months;
// span["Days"] = extraDays;
// }
// else
// {
// span["Days"] = diff.ToString() + " days";
// }
// return span;
//}
protected int?PatientAge(int PatientId)
{
int?age = null;
string datasetSQL = CacheManager.GetDatasetSQL(Session[SessionKey.DatasetId]);
PatientDa p = new PatientDa();
DataTable pt = p.GetPatientById(PatientId, datasetSQL);
if (pt.Rows.Count == 1 && pt.Rows[0][BOL.Patient.PtBirthDateText].ToString().Length > 0)
{
DateTime dob = new DateTime();
if (DateTime.TryParse(pt.Rows[0][BOL.Patient.PtBirthDateText].ToString(), out dob))
{
int diff = (DateTime.Now - dob).Days;
age = (int)(Math.Floor(diff / 365.2422));
}
}
return(age);
}
protected void BuildHPI()
{
InitContentBuffer();
PatientDa hpiDa = new PatientDa();
DataSet hpiDs;
hpiDs = hpiDa.GetPatientHPIProstateGU(this._patientId, 1);
if (hpiDs.Tables[0].Rows.Count > 0)
{
DataTable ExpandedHpiDT = ExpandedHpi(hpiDs.Tables[0]);
hpi.DataSource = ExpandedHpiDT.DefaultView;
hpi.DataBind();
}
else
{
NoHPIMsg.Visible = true;
}
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPIBreast(this.patientID);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
int rowCount = hpiDs.Tables[0].Rows.Count;
}
catch (Exception ex)
{
hpi.Visible = false;
ExceptionHandler.Publish(ex);
}
}
}
protected void GetLastProblemPlans()
{
if (patientID != 0)
{
PatientDa da = new PatientDa();
DataSet ds = da.FormGetLastPatientProblemPlans(this.patientID);
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
DataTable dt = ds.Tables[0];
dt.Columns.Add("ProblemDisplayName");
dt.Rows[0]["ProblemDisplayName"] = dt.Rows[0][BOL.PatientProblem.ProblemName];
if (dt.Rows.Count > 1)
{
for (int i = 1; i < dt.Rows.Count; i++)
{
if (dt.Rows[i][BOL.PatientProblem.ProblemName].ToString() != dt.Rows[i - 1][BOL.PatientProblem.ProblemName].ToString())
{
dt.Rows[i]["ProblemDisplayName"] = dt.Rows[i][BOL.PatientProblem.ProblemName];
}
}
}
RptProblems.DataSource = ds.Tables[0].DefaultView;
RptProblems.DataBind();
noProblemPlans.Visible = false;
string ProblemPlanNoteText = "";
if (dt.Rows[0][BOL.Encounter.EncPhysician].ToString().Length > 0)
{
ProblemPlanNoteText += "by " + dt.Rows[0][BOL.Encounter.EncPhysician].ToString();
}
if (dt.Rows[0][BOL.Encounter.EncDateText].ToString().Length > 0)
{
ProblemPlanNoteText += " on " + dt.Rows[0][BOL.Encounter.EncDateText].ToString();
}
ProblemPlanNote.Text = (ProblemPlanNoteText.Length > 0) ? ProblemPlanNoteText : "(None Recorded)";
}
}
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPI(this.patientID, 0, 0);
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
int rowCount = hpiDs.Tables[0].Rows.Count;
//nomograms are in a second result set
/*
* preRPNomo.Text = hpiDs.Tables[1].Rows[0]["preRPNomo"].ToString();
* preXRTNomo.Text = hpiDs.Tables[1].Rows[0]["preXRTNomo"].ToString();
* preBrachyNomo.Text = hpiDs.Tables[1].Rows[0]["preBrachyNomo"].ToString();
* postRP7yrNomo.Text = hpiDs.Tables[1].Rows[0]["postRP7yrNomo"].ToString();
*/
// set the value of the biopsy Id that is to be REMOVED from the results of the
// stored proc spFormListBiopsies so that the biopsy is only listed once in the
// hpi section of the form
if (hpiDs.Tables[1].Rows[0]["DxBiopsyId"] != null && hpiDs.Tables[1].Rows[0]["DxBiopsyId"].ToString().Length > 0)
{
hpiBiopsyId = (int)hpiDs.Tables[1].Rows[0]["DxBiopsyId"];
}
}
catch (Exception ex)
{
hpi.Visible = false;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
}
}
protected void BuildHPI()
{
if (patientID != 0)
{
try
{
PatientDa pDa = new PatientDa();
DataSet hpiDs = pDa.GetPatientHPIBladder(this.patientID);
int rowCount = hpiDs.Tables[0].Rows.Count;
if (rowCount > 0)
{
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
if (rowCount > (NumHpiRowsAllowed / 5))
{
BlankHPITable.Visible = false;
}
}
else
{
PopulatedHPITable.Visible = false;
}
}
catch (Exception ex)
{
BlankHPITable.Visible = true;
PopulatedHPITable.Visible = false;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
}
else
{
PopulatedHPITable.Visible = false;
}
}
protected void BuildHPI()
{
try
{
PatientDa pDa = new PatientDa();
DataSet hpiDs = pDa.GetPatientHPIBladder(this._patientId);
DataView view = new DataView(hpiDs.Tables[0]);
if (view.Count > 0)
{
hpi.DataSource = view;
hpi.DataBind();
NoHPIMsgTr.Visible = false;
}
}
catch (Exception ex)
{
hpi.Visible = false;
ExceptionHandler.Publish(ex);
NoHPIMsgTr.Visible = true;
NoHPIMsgTd.InnerHtml = "There was an error retreiving the HPI for this patient.";
NoHPIMsgTd.InnerHtml += ex.Message;
}
}
protected void BuildHPI()
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPIForEForm(this._patientId, 0, 0, 1);
if (hpiDs.Tables[0].Rows.Count > 0)
{
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
}
else
{
NoHPIMsg.Visible = true;
}
}
catch (Exception ex)
{
hpi.Visible = false;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
}
protected void BuildHPI()
{
try
{
PatientDa hpiDa = new PatientDa();
DataSet hpiDs = hpiDa.GetPatientHPIForEForm(this._patientId, 0, 0, 1);
if (hpiDs.Tables[0].Rows.Count > 0)
{
hpi.DataSource = hpiDs.Tables[0].DefaultView;
hpi.DataBind();
}
else
{
NoHPIMsg.Visible = true;
}
//nomograms are in a second result set
//preRPNomo.Text = hpiDs.Tables[1].Rows[0]["preRPNomo"].ToString();
//preXRTNomo.Text = hpiDs.Tables[1].Rows[0]["preXRTNomo"].ToString();
//preBrachyNomo.Text = hpiDs.Tables[1].Rows[0]["preBrachyNomo"].ToString();
//postRP7yrNomo.Text = hpiDs.Tables[1].Rows[0]["postRP7yrNomo"].ToString();
NomogramDa nda = new NomogramDa();
string PreRP5Error = null;
string PreRP10Error = null;
string PreXRTError = null;
string PreBrachyError = null;
string PostRP7Error = null;
string PostRP10Error = null;
try
{
preRP5Nomo.Text = ((int)Math.Round(nda.GetPreRPResult(this._patientId, 5), 0)).ToString();
}
catch (NomogramDataException e1)
{
PreRP5Error = e1.Message;
}
try
{
preRP10Nomo.Text = ((int)Math.Round(nda.GetPreRPResult(this._patientId, 10), 0)).ToString();
}
catch (NomogramDataException e2)
{
PreRP10Error = e2.Message;
}
try
{
preXRTNomo.Text = ((int)Math.Round(nda.GetPreXRTResult(this._patientId), 0)).ToString();
}
catch (NomogramDataException e3)
{
PreXRTError = e3.Message;
}
try
{
preBrachyNomo.Text = ((int)Math.Round(nda.GetPreBrachyResult(this._patientId), 0)).ToString();
}
catch (NomogramDataException e4)
{
PreBrachyError = e4.Message;
}
try
{
postRP7yrNomo.Text = ((int)Math.Round(nda.GetPostRPResult(this._patientId, 7), 0)).ToString();
}
catch (NomogramDataException e5)
{
PostRP7Error = e5.Message;
}
try
{
postRP10yrNomo.Text = ((int)Math.Round(nda.GetPostRPResult(this._patientId, 10), 0)).ToString();
}
catch (NomogramDataException e6)
{
PostRP10Error = e6.Message;
}
if (hpiDs.Tables[1].Rows[0]["DxBiopsyId"] != null && hpiDs.Tables[1].Rows[0]["DxBiopsyId"].ToString().Length > 0)
{
hpiBiopsyId = (int)hpiDs.Tables[1].Rows[0]["DxBiopsyId"];
}
//PreRPError = hpiDs.Tables[1].Rows[0]["PreRPError"].ToString();
//PreXRTError = hpiDs.Tables[1].Rows[0]["PreXRTError"].ToString();
//PreBrachyError = hpiDs.Tables[1].Rows[0]["PreBrachyError"].ToString();
//PostRPError = hpiDs.Tables[1].Rows[0]["PostRPError"].ToString();
if (PreRP5Error != null && PreRP5Error.Length > 0)
{
// preRPNomo.ToolTip = PreRPError;
// preRPNomo.Attributes.Add("style", "cursor:hand;");
preRP5Nomo.Text += "<img src=\"../../Images/NomogramAlert.gif\" width=\"9\" height=\"9\"> " + PreRP5Error;
// old:with error displayed all the time
//NomogramError.Text += "<strong>* Cannot calculate PreRP:</strong> " + PreRPError + "<br/>";
//preRPNomo.Text += "*";
}
if (PostRP10Error != null && PostRP10Error.Length > 0)
{
preRP10Nomo.Text += "<img src=\"../../Images/NomogramAlert.gif\" width=\"9\" height=\"9\"> " + PreRP10Error;
}
if (PreXRTError != null && PreXRTError.Length > 0)
{
if (PreXRTError == "No XRT noted.")
{
preXRTNomo.Text = "No XRT";
}
else
{
// preXRTNomo.ToolTip = PreXRTError;
// preXRTNomo.Attributes.Add("style", "cursor:hand;");
preXRTNomo.Text += "<img src=\"../../Images/NomogramAlert.gif\" width=\"9\" height=\"9\"> " + PreXRTError;
// old:with error displayed all the time
//NomogramError.Text += "<strong>** Cannot calculate PreXRT:</strong> " + PreXRTError + "<br/>";
//preXRTNomo.Text += "**";
}
}
if (PreBrachyError != null && PreBrachyError.Length > 0)
{
// preBrachyNomo.ToolTip = PreBrachyError;
// preBrachyNomo.Attributes.Add("style", "cursor:hand;");
preBrachyNomo.Text += "<img src=\"../../Images/NomogramAlert.gif\" width=\"9\" height=\"9\"> " + PreBrachyError;
// old:with error displayed all the time
//NomogramError.Text += "<strong>*** Cannot calculate PreBrachy:</strong> " + PreBrachyError + "<br/>";
//preBrachyNomo.Text += "***";
}
if (PostRP7Error != null && PostRP7Error.Length > 0)
{
if (PostRP7Error == "No radical prostatectomy noted.")
{
postRP7yrNomo.Text = "No RP";
}
else
{
// postRP7yrNomo.ToolTip = PostRPError;
// postRP7yrNomo.Attributes.Add("style", "cursor:hand;");
postRP7yrNomo.Text += "<img src=\"../../Images/NomogramAlert.gif\" width=\"9\" height=\"9\"> " + PostRP7Error;
// old:with error displayed all the time
//NomogramError.Text += "<strong>**** Cannot calculate PostRP:</strong> " + PostRPError;
//postRP2yrNomo.Text += "****";
//postRP5yrNomo.Text += "****";
//postRP7yrNomo.Text += "****";
}
}
if (PostRP10Error != null && PostRP10Error.Length > 0)
{
if (PostRP10Error == "No radical prostatectomy noted.")
{
postRP10yrNomo.Text = "No RP";
}
else
{
postRP10yrNomo.Text += "<img src=\"../../Images/NomogramAlert.gif\" width=\"9\" height=\"9\"> " + PostRP10Error;
}
}
}
catch (Exception ex)
{
hpi.Visible = false;
//Caisis.UI.Other.EmailError.SendErrorEmail( "Clinic Form: " + this._formTitle, "error creating hpi output");
ExceptionHandler.Publish(ex);
}
PopulateHPIPreTxPotency();
// this condition doesn't work, since this.EFormName doesn't always have a value
// so at the moment, on a GU form we are showing many things that don't need to be there. - jf
// if (this._eformName != null && this._eformName.IndexOf("GU") < 0)
// {
BuildHpiProstatectomies(this._patientId, this._eformName, "Dynamic");
BuildHpiProtocols(this._patientId, this._eformName, "Dynamic");
BuildHpiBiopsies(this._patientId, this._eformName, "Dynamic", hpiBiopsyId);
BuildHPINerveStatus();
// }
}
