override protected void Page_Load(object sender, System.EventArgs e)
{
base.Page_Load(sender, e);
BuildPatientPhysiciansReferring(this._patientId, this._eformName, "Dynamic");
base.SetTitle(ComponentTitle);
SetPatientIdsPhysicianNames();
//store the required field for saving and re-loading current eform section when the 'Add Physician' btn is clicked
if (Request.QueryString["eformId"] != null && Request.QueryString["eformId"].Length > 0)
{
HiddenEformID.Text = Request.QueryString["eformId"];
string sql = "SELECT * FROM Eforms ";
sql += "WHERE Eforms.EformId = @EformId ";
SqlCommand com = DataAccessHelper.CreateSqlCommand(sql);
DataAccessHelper.AddIntInputParam(com, "EformId", int.Parse(HiddenEformID.Text));
DataSet eformDs = DataAccessHelper.GetList(com);
if (eformDs.Tables[0].Rows[0]["EformName"].ToString().Length > 0)
{
HiddenEformName.Text = eformDs.Tables[0].Rows[0]["EformName"].ToString();
}
}
if (Request.QueryString["sectionName"] != null && Request.QueryString["sectionName"].Length > 0)
{
HiddenSectionName.Text = Request.QueryString["sectionName"];
}
}
override protected void BuildFamilyHistory()
{
if (patientID != 0)
{
// Family History
SqlCommand familyHistoryCom = DataAccessHelper.CreateCommand("spFormListFamilyMemberDiagnosis");
DataAccessHelper.AddIntInputParam(familyHistoryCom, "patientID", this.patientID);
DataAccessHelper.AddStringInputParam(familyHistoryCom, "formName", "URONV");
DataAccessHelper.AddStringInputParam(familyHistoryCom, "formType", "dynamic");
DataSet familyHistoryDs = DataAccessHelper.GetList(familyHistoryCom);
if (familyHistoryDs.Tables[0].Rows.Count == 0)
{
DataRow blankFamHistoryRow;
blankFamHistoryRow = familyHistoryDs.Tables[0].NewRow();
blankFamHistoryRow["FamMemRelation"] = "<br><br><img src=\"../images/shim.gif\" border=\"0\" width=\"12\" height=\"1\">- Cancer:<br><br><br><br><br><img src=\"../images/shim.gif\" border=\"0\" width=\"12\" height=\"1\">- Other:";
familyHistoryDs.Tables[0].Rows.Add(blankFamHistoryRow);
}
if (familyHistoryDs.Tables[0].Rows.Count > 0)
{
FamilyHistoryFiller.Visible = false;
familyHistory.DataSource = familyHistoryDs.Tables[0].DefaultView;
familyHistory.DataBind();
}
}
}
public static DataSet GetChronoListStatusEntries(int patientId)
{
SqlCommand com = DataAccessHelper.CreateCommand("spChronoListStatus");
DataAccessHelper.AddIntInputParam(com, "PatientId", patientId);
DataSet ds = DataAccessHelper.GetList(com);
return(ds);
}
public static DataSet GetFirstRadiationTherapy(int patientId)
{
// SqlCommand com = DataAccessHelper.CreateCommand("spGetRadiationTherapyFirst");
SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetRadiationTherapyFirst");
DataAccessHelper.AddIntInputParam(com, "PatientId", patientId);
DataSet ds = DataAccessHelper.GetList(com);
return(ds);
}
/*
* public static bool areSprocsInstalled()
* {
* try
* {
* // SqlCommand com = DataAccessHelper.CreateCommand("if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[spGetBiopsiesFlash]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) SELECT 'true' ELSE Select 'false'");
* // return (bool)com.ExecuteScalar();
* return true;
* }
* catch ( SqlException e)
* {
* throw new Exception("Could not create the stored procedures necessary for the PSA Graph. Please contact your System Administrator or DBA",e);
* }
* }
*
* public static void installSprocs(string createSprocsSql)
* {
* SqlCommand com = DataAccessHelper.CreateCommand(createSprocsSql);
* com.ExecuteNonQuery();
* }
*/
public static DataSet GetAllBiopsiesFlash(int patientId)
{
//SqlCommand com = DataAccessHelper.CreateCommand("spGetBiopsiesFlash");
SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetBiopsiesFlash");
DataAccessHelper.AddIntInputParam(com, "PatientId", patientId);
DataSet ds = DataAccessHelper.GetList(com);
return(ds);
}
public static string GetPtFullName(int PatientId)
{
// SqlCommand com = DataAccessHelper.CreateCommand("spGetPtFullName");
SqlCommand com = DataAccessHelper.CreateCommand("spGetPatientsRecord");
DataAccessHelper.AddIntInputParam(com, "PatientId", PatientId);
DataSet ds = DataAccessHelper.GetList(com);
return(ds.Tables[0].Rows[0]["PtFirstName"].ToString() + " " + ds.Tables[0].Rows[0]["PtMiddleName"].ToString() + " " + ds.Tables[0].Rows[0]["PtLastName"].ToString());
}
public static DataSet GetAllPSAs(int PatientId)
{
// SqlCommand com = DataAccessHelper.CreateCommand("spGetLabTestAllPSAs");
SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetLabTestAllPSAs");
DataAccessHelper.AddIntInputParam(com, "PatientId", PatientId);
DataSet ds = DataAccessHelper.GetList(com);
return(ds);
}
public static Hashtable GetProstSurgeryRecord(int PatientId)
{
SqlCommand com = DataAccessHelper.CreateCommand("spFormGetProcProstatectomyDate");
DataAccessHelper.AddIntInputParam(com, "PatientId", PatientId);
DataAccessHelper.AddStringOutputParam(com, "RP_Date");
Hashtable ht = DataAccessHelper.ExecuteScalar(com);
return(ht);
}
public static DataSet GetPSADTVelocity(int patientId, DateTime startDt, DateTime endDt, string PSAThreshold)
{
//SqlCommand com = DataAccessHelper.CreateCommand("spGetPSADTVelocity");
SqlCommand com = DataAccessHelper.CreateCommand("spPluginPSAGraphGetPSADTVelocity");
DataAccessHelper.AddIntInputParam(com, "PatientId", patientId);
DataAccessHelper.AddDateTimeInputParam(com, "StartDT", startDt);
DataAccessHelper.AddDateTimeInputParam(com, "EndDT", endDt);
DataAccessHelper.AddStringInputParam(com, "PSAThreshold", PSAThreshold);
DataSet ds = DataAccessHelper.GetList(com);
return(ds);
}
override protected void BuildSocialHistory()
{
if (patientID != 0)
{
// Social History
SqlCommand socialHistoryCom = DataAccessHelper.CreateCommand("spFormGetSocialHistoriesRecord");
DataAccessHelper.AddIntInputParam(socialHistoryCom, "patientID", this.patientID);
DataAccessHelper.AddStringInputParam(socialHistoryCom, "formName", "URONV");
DataAccessHelper.AddStringInputParam(socialHistoryCom, "formType", "dynamic");
DataSet socialHistoryDs = DataAccessHelper.GetList(socialHistoryCom);
if (!socialHistoryDs.Tables.Count.Equals(0) && !socialHistoryDs.Tables[0].Rows.Count.Equals(0))
{
socHxOccupation.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxOccupation"].ToString();
socHxMaritalStatus.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxMaritalStatus"].ToString();
socHxChildren.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxChildren"].ToString();
// socHxTobaccoType.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoType"].ToString();
if (socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoPacksPerDay"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoPacksPerDay"].ToString() != "")
{
socHxTobaccoPacksPerDay.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoPacksPerDay"].ToString();
socHxTobaccoPacksPerDayCheckBox.Checked = true;
}
if (socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoYears"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoYears"].ToString() != "")
{
socHxTobaccoPacksPerDayCheckBox.Checked = true;
socHxTobaccoYears.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoYears"].ToString();
}
if (socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoQuitYear"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoQuitYear"].ToString() != "")
{
socHxTobaccoQuitYearCheckbox.Checked = true;
socHxTobaccoQuitYear.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxTobaccoQuitYear"].ToString();
}
socHxCarcinogen.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxCarcinogen"].ToString();
if (socialHistoryDs.Tables[0].Rows[0]["SocHxAlcohol"] != null && socialHistoryDs.Tables[0].Rows[0]["SocHxAlcohol"].ToString().Length > 0)
{
socHxAlcohol.Text = socialHistoryDs.Tables[0].Rows[0]["SocHxAlcohol"].ToString();
}
}
}
}