private void Page_Load(object sender, System.EventArgs e)
{
Form.Attributes["onsubmit"] = "return(DoSubmitConsentsBySubject(event));";
oDBLookup = new DBLookup();
int nSubjID;
int nStudyID;
SqlCommand oCmd = new SqlCommand();
SqlDataReader oReader;
HtmlTableRow oTr;
HtmlTableCell oTd;
HtmlTableCell tdConsentItems = new HtmlTableCell();
bool bDoDark = false;
string sCFVID = "";
int nCount = 0;
DateTime itemdate = new DateTime();
string n = "";
if (IsPostBack)
{
nSubjID = Convert.ToInt32(oDBLookup.GetSubjIDFromID(Request["txtID"].ToString(), Convert.ToInt32(Request["selStudyID"].ToString())));
}
else
{
nSubjID = Convert.ToInt32(Request["SubjectID"].ToString());
}
nStudyID = oDBLookup.GetStudyIDBySubjID(nSubjID);
hidSubjID.Value = nSubjID.ToString();
hidStudyID.Value = nStudyID.ToString();
tdTitle.InnerHtml = "Consent Forms for " + oDBLookup.GetIDBySubjID(nSubjID, true);
#region Get Info From db
oCmd.Connection = Master.SqlConn;
oCmd.CommandTimeout = 90;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spGetConsentFormsBySubjID2";
oCmd.Parameters.Add(new SqlParameter("@SubjID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, nSubjID));
oReader = oCmd.ExecuteReader();
#endregion
while (oReader.Read())
{
#region Display Data Items
if (sCFVID != oReader["ConsentFormVersionID"].ToString())
{
oTr = new HtmlTableRow();
oTr.Attributes["onclick"] = "HighlightRow(this); HighlightRow(document.getElementById('tr" + oReader["SubjConsentID"].ToString() + "'));";
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
oTd.InnerHtml = "<input type=\"checkbox\" name=\"chkConsentToEdit\" id=\"chkConsentToEdit" + oReader["SubjConsentID"].ToString() + "\" value=\"" + oReader["SubjConsentID"].ToString() + "\" />";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
oTd.InnerHtml = "<a href=\"" + Request.ApplicationPath + "/Measures/EditConsentForm.aspx?SubjConsentID=" + oReader["SubjConsentID"].ToString() + "\">" + oFormat.FormatDBOutput(oReader["ConsentFormName"].ToString()) + "</a>";
if (oReader["Notes"].ToString() != "")
{
oTd.InnerHtml += " <a href=\"javascript:ShowTableRow('tr" + oReader["SubjConsentID"].ToString() + "');\" class=\"smalltext\">(Notes)</a>";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["Version"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["ConsentApproved"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["DateSigned"].ToString()) + " " + oFormat.FormatDBOutput(oReader["TimeSigned"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["ConsentStatusShort"].ToString());
oTr.Cells.Add(oTd);
tdConsentItems = new HtmlTableCell();
tdConsentItems.EnableViewState = false;
//if (oReader["IsConsented"].ToString() == "1")
// tdConsentItems.InnerHtml = "<span style=\"color: #008800;\">" + oFormat.FormatDBOutput(oReader["ConsentItemText"].ToString()) + "</span>";
//else
// tdConsentItems.InnerHtml = "<span style=\"color: #ff0000;\">" + oFormat.FormatDBOutput(oReader["ConsentItemText"].ToString()) + "</span>";
string s = oReader["ConsentItemText"].ToString() + " " + oReader["optiontext"].ToString() + " ";
if (DateTime.TryParse(oReader["ItemDateSigned"].ToString(), out itemdate))
{
s = s + itemdate.ToString("MM/dd/yyyy");
}
s = s + " " + oReader["ItemTimeSigned"].ToString();
n = oReader["SubjConsentItemNotes"].ToString();
if (n.Trim() != "")
{
s = s + "<br> " + n;
}
if (s.Trim() == "")
{
s = " "; //hack to fix missing border around empty table cell
}
tdConsentItems.InnerHtml = s;
oTr.Cells.Add(tdConsentItems);
tblMaster.Rows.Insert(tblMaster.Rows.Count - 2, oTr);
if (oReader["Notes"].ToString() != "")
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.EnableViewState = false;
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTr.Style["display"] = "none";
oTr.Attributes["id"] = "tr" + oReader["SubjConsentID"].ToString();
oTd.ColSpan = 7;
oTd.InnerHtml = oReader["Notes"].ToString();
oTr.Cells.Add(oTd);
tblMaster.Rows.Insert(tblMaster.Rows.Count - 2, oTr);
}
bDoDark = !bDoDark;
nCount++;
sCFVID = oReader["ConsentFormVersionID"].ToString();
}
else
{
tdConsentItems.InnerHtml += "<br/>" + oReader["ConsentItemText"].ToString() + " " + oReader["optiontext"].ToString() + " ";
if (DateTime.TryParse(oReader["ItemDateSigned"].ToString(), out itemdate))
{
tdConsentItems.InnerHtml += itemdate.ToString("MM/dd/yyyy");
}
tdConsentItems.InnerHtml += " " + oReader["ItemTimeSigned"].ToString();
n = oReader["SubjConsentItemNotes"].ToString();
if (n.Trim() != "")
{
tdConsentItems.InnerHtml += "<br> " + n;
}
}
#endregion
}
oReader.Close();
tdTitle.InnerHtml += "<br/><div class=\"DoNotPrint\" style=\"font-size: 8pt;\">";
tdTitle.InnerHtml += "<a href=\"" + Request.ApplicationPath + "/Measures/ActionsBySubject.aspx?SubjectID=" + nSubjID.ToString() + "\">View Actions</a>";
tdTitle.InnerHtml += " | <a href=\"" + Request.ApplicationPath + "/Measures/MeasuresBySubject.aspx?SubjectID=" + nSubjID.ToString() + "\">View Measures</a>";
tdTitle.InnerHtml += " | <a href=\"" + Request.ApplicationPath + "/Household/ViewHousehold.aspx?HouseholdID=" + oDBLookup.GetHouseholdIDBySubjID(nSubjID) + "\">View Household</a><br/>";
tdTitle.InnerHtml += oDBLookup.BindDropDownList("selStudyID", "EXEC spGetActiveStudies", "StudyName", "StudyID", oDBLookup.GetStudyIDBySubjID(nSubjID).ToString(), "--Study--", "font-size: 7pt;");
tdTitle.InnerHtml += "<input type=\"text\" name=\"txtID\" value=\"" + oDBLookup.GetIDBySubjID(nSubjID) + "\" style=\"font-size: 7pt; width: 50px;\" />";
tdTitle.InnerHtml += "<input type=\"submit\" name=\"btnSubmit\" value=\"Update\" style=\"font-size: 7pt;\" />";
tdTitle.InnerHtml += "</div>";
tdTitle.InnerHtml += "<span class=\"verysmalltext\">" + DateTime.Now.ToString("MM/dd/yyyy hh:mm tt") + " - " + nCount.ToString() + " Records</span>";
}
private void DisplayHousehold(int nHouseholdID)
{
oDBLookup = new DBLookup();
HtmlTableRow oTr;
HtmlTableCell oTd;
SqlCommand oCmd = new SqlCommand();
oCmd.Connection = Master.SqlConn;
oCmd.CommandTimeout = 90;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spGetPedigreeByHouseholdID";
oCmd.Parameters.AddWithValue("@HouseholdID", nHouseholdID);
SqlDataReader oReader = oCmd.ExecuteReader();
if (oReader.HasRows)
{
while (oReader.Read())
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["border-bottom"] = "solid 1px #26044a";
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["FullName"].ToString());
oTd.InnerHtml += " (" + oFormat.FormatDBOutput(oReader["ID"].ToString());
if (oReader["PersonRole"].ToString() != "") {oTd.InnerHtml += "/" + oFormat.FormatDBOutput(oReader["PersonRole"].ToString());}
oTd.InnerHtml += ")";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["border-bottom"] = "solid 1px #26044a";
oTd.InnerHtml += "<input type=\"text\" name=\"txtBloodID\" id=\"txtBloodID" + oReader["BloodID"].ToString() + "\" value=\"" + oReader["BloodID"].ToString() + "\" />";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["border-bottom"] = "solid 1px #26044a";
oTd.InnerHtml += "<input type=\"text\" name=\"txtPedigree\" id=\"txtPedigree" + oReader["PersonID"].ToString() + "\" value=\"" + oReader["Pedigree"].ToString() + "\" />";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["border-bottom"] = "solid 1px #26044a";
oTd.InnerHtml += oDBLookup.BindDropDownList("selBloodSourceID", Convert.ToInt32(oReader["PersonID"]), "EXEC spGetBloodSources", "BloodSource", "BloodSourceID", oReader["BloodSourceID"].ToString(), "--Select Blood Source--", "width: 200px;");
oTd.InnerHtml += "<input type=\"hidden\" name=\"hidPersonID\" value=\"" + oReader["PersonID"].ToString() + "\" />";
oTr.Cells.Add(oTd);
tblMaster.Rows.Insert(tblMaster.Rows.Count-1, oTr);
}
}
else
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.InnerHtml = "No one in this household is not enrolled in the Family Study of Autism. ";
oTd.InnerHtml += "This page is only intended for subjects with at least one family member enrolled in that study.";
oTr.Cells.Add(oTd);
tblMaster.Rows.Insert(tblMaster.Rows.Count-1, oTr);
btnReturn.Style["display"] = "none";
btnSaveChanges.Style["display"] = "none";
}
oReader.Close();
}
private void Page_Load(object sender, System.EventArgs e)
{
int nHouseholdID = Convert.ToInt32(Request["HouseholdID"].ToString());
int nStudyID = -1;
string sPersonID = "0";
string sStudyID = "0";
SqlDataReader oReader;
HtmlTableRow oTr;
HtmlTableCell oTd;
bool bDoDark = false;
if (Request["StudyID"] != null)
{
nStudyID = Convert.ToInt32(Request["StudyID"].ToString());
}
oReader = GetActionsByHousehold(nHouseholdID, nStudyID);
if (oReader.HasRows)
{
while (oReader.Read())
{
if (sPersonID != oReader["PersonID"].ToString())
{
#region Display a Header for Each Person
sPersonID = oReader["PersonID"].ToString();
sStudyID = "";
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trHeader";
oTd.ColSpan = 7;
oTd.Style["font-size"] = "14pt";
oTd.InnerHtml = oReader["FullName"].ToString();
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
#endregion
}
if (sStudyID != oReader["StudyID"].ToString())
{
#region Display a Header for Each Study the Person is in
sStudyID = oReader["StudyID"].ToString();
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trHeaderAlt";
oTd.ColSpan = 7;
oTd.Style["text-align"] = "center";
oTd.InnerHtml = oReader["StudyName"].ToString() + " - " + oReader["ID"].ToString() + " (" + oReader["GroupName"].ToString() + " - " + oReader["SubjStatus"].ToString() + ")";
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
#endregion
#region Display a Header for Each Column
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.InnerHtml = " ";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.Style["font-weight"] = "bold";
oTd.InnerHtml = "Action";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.Style["font-weight"] = "bold";
oTd.InnerHtml = "Action Type";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.Style["font-weight"] = "bold";
oTd.InnerHtml = "Status";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.Style["font-weight"] = "bold";
oTd.InnerHtml = "Lab";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.Style["font-weight"] = "bold";
oTd.InnerHtml = "Date Done";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["background-color"] = "#e6ecf5";
oTd.Style["font-weight"] = "bold";
oTd.InnerHtml = "Staff";
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
#endregion
bDoDark = false;
}
#region Display the Actions
oTr = new HtmlTableRow();
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTr.Attributes["onclick"] = "HighlightRow(this);";
oTd = new HtmlTableCell();
oTd.Style["text-align"] = "center";
if (Convert.ToBoolean(oReader["CanEditMultiple"]))
{
oTd.InnerHtml = "<input type=\"checkbox\" name=\"chkActionIDs\" value=\"" + oReader["ActionID"].ToString() + "\" id=\"chkActionID" + oReader["ActionID"].ToString() + "\" />";
}
else
{
oTd.InnerHtml = " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "<a href=\"" + Request.ApplicationPath + "/Measures/EditAction.aspx?ActionID=" + oReader["ActionID"].ToString() + "\">" + oFormatter.FormatDBOutput(oReader["ActionText"].ToString()) + "</a>";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(oReader["ActionType"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(oReader["ActionStatus"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(oReader["LabName"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(oReader["DateDone"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(oReader["Staff"].ToString());
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
#endregion
bDoDark = !bDoDark;
}
}
else
{
tblMaster.Attributes["class"] = "";
btnCompleteAll.Style["display"] = "none";
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.InnerHtml = "There are no Actions for this Household. <a href=\"" + Request.ApplicationPath + "/Household/ViewHousehold.aspx?HouseholdID=" + nHouseholdID.ToString() + "\">Return to View Household page.</a>";
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
}
}
private void Page_Load(object sender, System.EventArgs e)
{
oDBLookup = new DBLookup(Master.SqlConn);
int nConsentFormID = Convert.ToInt32(Request["ConsentFormID"].ToString());
SqlCommand oCmd = new SqlCommand();
SqlDataReader oReader;
HtmlTableRow oTr;
HtmlTableCell oTd;
HtmlTableCell tdConsentItems = new HtmlTableCell();
bool bDoDark = false;
string sSubjID = "";
string sCFVID = "";
tdTitle.InnerHtml = oDBLookup.GetConsentFormNameByConsentFormID(nConsentFormID);
#region Get Info From db
oCmd.Connection = Master.SqlConn;
oCmd.CommandTimeout = 90;
oCmd.CommandType = CommandType.StoredProcedure;
oCmd.CommandText = "spGetSubjConsentsByConsentFormID2";
oCmd.Parameters.Add(new SqlParameter("@ConsentFormID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "", DataRowVersion.Default, nConsentFormID));
#endregion
oReader = oCmd.ExecuteReader();
while (oReader.Read())
{
#region Display Data Items
if (sSubjID != oReader["SubjID"].ToString() || sCFVID != oReader["ConsentFormVersionID"].ToString())
{
oTr = new HtmlTableRow();
oTr.Attributes["onclick"] = "HighlightRow(this);";
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
oTd.InnerHtml = "<a href=\"" + Request.ApplicationPath + "/Measures/EditConsentForm.aspx?SubjConsentID=" + oReader["SubjConsentID"].ToString() + "\">" + oFormat.FormatDBOutput(oReader["ID"].ToString()) + "</a>";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["Version"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["Status"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["DateSigned"].ToString());
oTr.Cells.Add(oTd);
tdConsentItems = new HtmlTableCell();
//if (oReader["IsConsented"].ToString() == "1")
// tdConsentItems.InnerHtml = "<span style=\"color: #008800;\">" + oFormat.FormatDBOutput(oReader["ConsentItemText"].ToString()) + "</span>";
//else
// tdConsentItems.InnerHtml = "<span style=\"color: #ff0000;\">" + oFormat.FormatDBOutput(oReader["ConsentItemText"].ToString()) + "</span>";
string s = oReader["ConsentItemText"].ToString() + " " + oReader["optiontext"].ToString();
if (s.Trim() == "")
{
s = " "; //hack to fix missing border around empty table cell
}
tdConsentItems.InnerHtml = s;
oTr.Cells.Add(tdConsentItems);
tblMaster.Rows.Add(oTr);
bDoDark = !bDoDark;
sSubjID = oReader["SubjID"].ToString();
sCFVID = oReader["ConsentFormVersionID"].ToString();
}
else
{
//if (oReader["IsConsented"].ToString() == "1")
// tdConsentItems.InnerHtml += "<br/>\n<span style=\"color: #008800;\">" + oFormat.FormatDBOutput(oReader["ConsentItemText"].ToString()) + "</span>";
//else
// tdConsentItems.InnerHtml += "<br/>\n<span style=\"color: #ff0000;\">" + oFormat.FormatDBOutput(oReader["ConsentItemText"].ToString()) + "</span>";
tdConsentItems.InnerHtml += "<br/>" + oReader["ConsentItemText"].ToString() + " " + oReader["optiontext"].ToString();
}
#endregion
}
oReader.Close();
}
private void Page_Load(object sender, System.EventArgs e)
{
string ap = Request.ApplicationPath;
bool bDisplayedHeader = false;
bool bDoDark = false;
string sSortField;
string sDOB;
HtmlAnchor aLink;
HtmlTableRow oTr;
HtmlTableCell oTd;
nStudyID = Convert.ToInt32(Request["StudyID"]);
if (Request["SubjStatusID"] == null)
{
Response.Redirect(ap + "/measures/SubjectsByStudy.aspx?StudyID=" + nStudyID.ToString(), true);
}
nSubjStatusID = Convert.ToInt32(Request["SubjStatusID"]);
sSortField = Request["hidSortField"];
if (Request["SubjStatusDetailID"] != "")
{
nSubjStatusDetailID = Convert.ToInt32(Request["SubjStatusDetailID"]);
}
oConn.ConnectionString = ConfigurationManager.ConnectionStrings["TRACKING_CONN_STRING"].ToString();
oConn.Open();
SqlDataReader oReader = GetSubjectsByStatus(oConn, nStudyID, nSubjStatusID, nSubjStatusDetailID, sSortField);
while (oReader.Read())
{
if (!bDisplayedHeader)
{
#region Display Header Title
oTr = new HtmlTableRow();
oTr.Attributes["class"] = "trTitle";
oTd = new HtmlTableCell();
oTd.ColSpan = 8;
if (nSubjStatusDetailID != 0)
{
oTd.InnerHtml = oReader["StudyName"].ToString() + " - " + oReader["SubjStatus"].ToString() + "/" + oReader["SubjStatusDetail"].ToString() + " Subjects";
}
else
{
oTd.InnerHtml = oReader["StudyName"].ToString() + " - " + oReader["SubjStatus"].ToString() + " Subjects";
}
oTr.Cells.Add(oTd);
tblMaster.Rows.Insert(0, oTr);
bDisplayedHeader = true;
#endregion
}
#region Display Data Items
oTr = new HtmlTableRow();
aLink = new HtmlAnchor();
oTr.Attributes.Add("onclick", "HighlightRow(this);");
if (bDoDark)
{
oTr.Attributes.Add("class", "trDark");
}
aLink.HRef = ap + "/measures/EditSubject.aspx?SubjID=" + oReader["SubjID"].ToString();
aLink.InnerHtml = oReader["ID"].ToString();
oTd = new HtmlTableCell();
oTd.Controls.Add(aLink);
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["LastName"].ToString()) + ", " + oFormat.FormatDBOutput(oReader["FirstName"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["GroupName"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["SubjStatusAndDetail"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
sDOB = oReader["DOB"].ToString();
if (sDOB != "")
{
oTd.InnerHtml = oFormat.AgeInYearsAndMonths(Convert.ToDateTime(sDOB));
}
else
{
oTd.InnerHtml = " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["DOB"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["Sex"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["white-space"] = " normal";
oTd.InnerHtml = oFormat.FormatDBOutput(oReader["Notes"].ToString());
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
bDoDark = !bDoDark;
#endregion
}
oConn.Close();
}
private void Page_Load(object sender, System.EventArgs e)
{
string ap = Request.ApplicationPath;
oDBLookup = new DBLookup(Master.SqlConn);
int nHouseholdID = Convert.ToInt32(Request["HouseholdID"].ToString());
DataSet oDataSet = GetHouseholdInfo(nHouseholdID);
DataTable tblPhoneNumbers = oDataSet.Tables["tblPhoneNumbers"];
DataTable tblEmailAddresses = oDataSet.Tables["tblEmailAddresses"];
DataTable tblSubjects = oDataSet.Tables["tblSubjects"];
DataTable tblSecondaryContacts = oDataSet.Tables["tblSecondaryContact"];
DataTable tblInfoLog = oDataSet.Tables["tblInfoLog"];
DataTable tblContactLog = oDataSet.Tables["tblContactLog"];
DataTable tblScreening = oDataSet.Tables["tblScreeningResults"];
string sHouseholdName = oDBLookup.GetHouseholdName(nHouseholdID);
bool bDoDark = false;
HtmlTableRow oTr;
HtmlTableCell oTd;
if (tblSubjects.Rows.Count > 0)
{
tdTitle.Style["text-align"] = "right";
//DF: add app path to href and img tags
tdTitle.InnerHtml += "<span style=\"text-align: center; width: 90%;\">" + sHouseholdName.ToString() + " Household Information</span>";
tdTitle.InnerHtml += "<a href=\"" + ap + "/Household/EditPedigree.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/pedigree.gif\" alt=\"Edit Pedigree for Household\" style=\"align: right;\" /></a> ";
tdTitle.InnerHtml += "<a href=\"" + ap + "/Measures/ActionsByHousehold.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/task.gif\" alt=\"View All Actions for Household\" style=\"align: right;\" /></a> ";
tdTitle.InnerHtml += "<a href=\"" + ap + "/WebCal/FutureHouseholdActions.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/dlcalendar_2.gif\" alt=\"View Upcoming Appointments\" style=\"align: right;\" /></a> ";
tdTitle.InnerHtml += "<a href=\"" + ap + "/Household/EditHousehold.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Edit Household Info\" style=\"align: right;\" /></a>";
#region Display Person/Subject Information
HtmlTableCell tdAddress = new HtmlTableCell();
HtmlTable tblPerson = new HtmlTable();
tblPerson.Attributes["class"] = "tblPersons";
tblPerson.CellSpacing = 0;
tblPerson.Style["width"] = " 100%";
tblPerson.Style["margin-left"] = " 0px";
string sPersonID = "0";
bool bDisplayedAddress = false;
int nRowSpan = 0;
string sMainContactAddressID = "";
#region Display Table Headers
oTr = new HtmlTableRow();
oTr.Attributes["class"] = "trTitle";
oTd = new HtmlTableCell();
oTd.Style["width"] = " 30%";
oTd.InnerHtml = "Name";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "20%";
oTd.InnerHtml = "DOB";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "15%";
oTd.InnerHtml = "Age";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "5%";
oTd.InnerHtml = "Sex";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "15%";
oTd.InnerHtml = "Role";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "15%";
oTd.InnerHtml = "Race/Eth.";
oTr.Cells.Add(oTd);
tblPerson.Rows.Add(oTr);
#endregion
for (int i = 0; i < tblSubjects.Rows.Count; i++)
{
if (sMainContactAddressID == "" && tblSubjects.Rows[i]["MainContact"].ToString() == "-1")
{
sMainContactAddressID = tblSubjects.Rows[i]["AddressID"].ToString();
}
if (sPersonID != tblSubjects.Rows[i]["PersonID"].ToString())
{
sPersonID = tblSubjects.Rows[i]["PersonID"].ToString();
bDisplayedAddress = false;
bDoDark = !bDoDark;
if (i > 0 && nRowSpan > 1)
{
tdAddress.RowSpan = nRowSpan;
}
nRowSpan = 0;
#region Display First, Visible Row
oTr = new HtmlTableRow();
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
oTd.Style["width"] = " 30%";
if (tblSubjects.Rows[i]["MainContact"].ToString() == "-1" || tblSubjects.Rows[i]["MainContact"].ToString() == "1")
{
oTd.Style["font-weight"] = "bold";
}
oTd.InnerHtml += "<a href=\"" + ap + "/Household/CreateSubject.aspx?PersonID=" + sPersonID + "\"><img src=\"" + ap + "/images/book.gif\" alt=\"Enroll in New Study\" /></a>\n";
oTd.InnerHtml += "<a href=\"javascript:ExpandRow('tr" + tblSubjects.Rows[i]["PersonID"].ToString() + "');\">" + oFormatter.FormatDBOutput(tblSubjects.Rows[i]["FullName"].ToString()) + "</a>";
if (Convert.ToBoolean(tblSubjects.Rows[i]["IsDeceased"]))
{
oTd.InnerHtml += "<br/><span style=\"padding-left: 20px; color: #ff0000; font-weight: bold;\">THIS PERSON IS DECEASED</span>";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "20%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSubjects.Rows[i]["DOB"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "15%";
if (tblSubjects.Rows[i]["DOB"].ToString() != "")
{
oTd.InnerHtml += oFormatter.AgeInYearsAndMonths(Convert.ToDateTime(tblSubjects.Rows[i]["DOB"].ToString()));
}
else
{
oTd.InnerHtml += " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "5%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSubjects.Rows[i]["Sex"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "15%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSubjects.Rows[i]["PersonRole"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "15%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSubjects.Rows[i]["EthnicityDesc"].ToString());
oTr.Cells.Add(oTd);
tblPerson.Rows.Add(oTr);
#endregion
}
#region Add Items to Hidden Inner Table
if (!bDisplayedAddress)
{
if (tblSubjects.Rows[i]["PersonNotes"].ToString().Trim() != "")
{
oTr = new HtmlTableRow();
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
oTr.Attributes["name"] = "tr" + tblSubjects.Rows[i]["PersonID"].ToString();
oTd.ColSpan = 6;
oTd.InnerHtml = "<b>Notes:</b> " + tblSubjects.Rows[i]["PersonNotes"].ToString();
oTr.Cells.Add(oTd);
tblPerson.Rows.Add(oTr);
}
oTr = new HtmlTableRow();
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTr.Attributes["id"] = "tr" + tblSubjects.Rows[i]["PersonID"].ToString();
tdAddress = new HtmlTableCell();
if (tblSubjects.Rows[i]["MainContact"].ToString() == "-1" || tblSubjects.Rows[i]["AddressID"].ToString() != sMainContactAddressID && tblSubjects.Rows[i]["AddressID"].ToString() != "")
{
tdAddress.InnerHtml += tblSubjects.Rows[i]["Address1"].ToString() + "<br/>";
if (tblSubjects.Rows[i]["Address2"].ToString() != "")
{
tdAddress.InnerHtml += tblSubjects.Rows[i]["Address2"].ToString() + "<br/>";
}
tdAddress.InnerHtml += tblSubjects.Rows[i]["City"].ToString();
if (tblSubjects.Rows[i]["State"].ToString() != "")
{
tdAddress.InnerHtml += ", " + tblSubjects.Rows[i]["State"].ToString() + " ";
}
if (tblSubjects.Rows[i]["Region"].ToString() != "")
{
tdAddress.InnerHtml += tblSubjects.Rows[i]["Region"].ToString() + " ";
}
if (tblSubjects.Rows[i]["Zip"].ToString() != "")
{
tdAddress.InnerHtml += tblSubjects.Rows[i]["Zip"].ToString();
}
if (tblSubjects.Rows[i]["Country"].ToString() != "")
{
tdAddress.InnerHtml += "<br/>" + tblSubjects.Rows[i]["Country"].ToString();
}
tdAddress.InnerHtml += "<br/><a href=\"" + ap + "/Household/EditAddress.aspx?HouseholdID=" + nHouseholdID.ToString() + "\" class=\"smalltext\">Edit Address</a>";
}
else
{
tdAddress.InnerHtml = " ";
}
oTr.Cells.Add(tdAddress);
tblPerson.Rows.Add(oTr);
bDisplayedAddress = true;
oTd = new HtmlTableCell();
if (tblSubjects.Rows[i]["ID"].ToString() != "")
{
oTd.InnerHtml = "<a href=\"" + ap + "/measures/ActionsBySubject.aspx?SubjectID=" + tblSubjects.Rows[i]["SubjID"].ToString() + "\">" + tblSubjects.Rows[i]["StudyName"].ToString() + " - " + tblSubjects.Rows[i]["ID"].ToString() + "</a>";
if (tblSubjects.Rows[i]["StudyName"].ToString() == "PTP")
{
oTd.InnerHtml += " <a href=\"" + ap + "/dataentryforms/common/UW_PTP_screen/UW_PTP_screen.aspx?studymeasID=1331&ID=" + tblSubjects.Rows[i]["ID"].ToString() + "&IndexNum=1\">(Screen Form)</a>";
}
/* Data Entry form for TSI_UW doesn't exist yet.
* if (tblSubjects.Rows[i]["StudyName"].ToString() == "IBIS Network")
* oTd.InnerHtml += " <a href=\"" + ap + "/dataentryforms/common/TSI_UW/TSI_UW.aspx?studymeasID=1386&ID=" + tblSubjects.Rows[i]["ID"].ToString() + "&IndexNum=1\">(Screen Form)</a>";
* if (tblSubjects.Rows[i]["StudyName"].ToString() == "EarlyConnections")
* oTd.InnerHtml += " <a href=\"" + ap + "/dataentryforms/common/TSI_UW/TSI_UW.aspx?studymeasID=1400&ID=" + tblSubjects.Rows[i]["ID"].ToString() + "&IndexNum=1\">(Screen Form)</a>";
****/
}
else
{
oTd.InnerHtml = " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.ColSpan = 2;
if (tblSubjects.Rows[i]["ID"].ToString() != "")
{
oTd.InnerHtml = "<a href=\"" + ap + "/Measures/EditSubject.aspx?SubjID=" + tblSubjects.Rows[i]["SubjID"].ToString() + "\">" + tblSubjects.Rows[i]["SubjStatus"].ToString() + "</a>";
}
else
{
oTd.InnerHtml = " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.ColSpan = 2;
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSubjects.Rows[i]["GroupName"].ToString());
oTr.Cells.Add(oTd);
tblPerson.Rows.Add(oTr);
}
else
{
oTr = new HtmlTableRow();
oTr.Attributes["name"] = "tr" + tblSubjects.Rows[i]["PersonID"].ToString();
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
if (tblSubjects.Rows[i]["ID"].ToString() != "")
{
oTd.InnerHtml = "<a href=\"" + ap + "/measures/ActionsBySubject.aspx?SubjectID=" + tblSubjects.Rows[i]["SubjID"].ToString() + "\">" + tblSubjects.Rows[i]["StudyName"].ToString() + " - " + tblSubjects.Rows[i]["ID"].ToString() + "</a>";
if (tblSubjects.Rows[i]["StudyName"].ToString() == "PTP")
{
oTd.InnerHtml += " <a href=\"" + ap + "/dataentryforms/common/UW_PTP_screen/UW_PTP_screen.aspx?studymeasID=1331&ID=" + tblSubjects.Rows[i]["ID"].ToString() + "&IndexNum=1\">(Screen Form)</a>";
}
}
else
{
oTd.InnerHtml = " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.ColSpan = 2;
if (tblSubjects.Rows[i]["ID"].ToString() != "")
{
oTd.InnerHtml = "<a href=\"" + ap + "/Measures/EditSubject.aspx?SubjID=" + tblSubjects.Rows[i]["SubjID"].ToString() + "\">" + tblSubjects.Rows[i]["SubjStatus"].ToString() + "</a>";
}
else
{
oTd.InnerHtml = " ";
}
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.ColSpan = 2;
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSubjects.Rows[i]["GroupName"].ToString());
oTr.Cells.Add(oTd);
tblPerson.Rows.Add(oTr);
}
nRowSpan = nRowSpan + 1;
#endregion
}
tdAddress.RowSpan = nRowSpan;
tdPersonInfo.Controls.Add(tblPerson);
bDoDark = false;
#endregion
#region Display Phone Numbers
HtmlTable tblPhone = new HtmlTable();
tblPhone.CellSpacing = 0;
tblPhone.Attributes["class"] = "tblPersons";
tblPhone.Style["width"] = " 100%";
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trTitle";
oTd.ColSpan = 3;
oTd.Style["text-align"] = "right";
oTd.InnerHtml = "<span style=\"width: 90%; text-align: center;\">Household Phone Info.</span>";
oTd.InnerHtml += "<a href=\"" + ap + "/Household/EditHousehold.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Edit Household Info\" style=\"align: right;\" /></a>";
oTr.Cells.Add(oTd);
tblPhone.Rows.Add(oTr);
string sPhoneType;
if (tblPhoneNumbers.Rows.Count > 0)
{
for (int i = 0; i < tblPhoneNumbers.Rows.Count; i++)
{
if (tblPhoneNumbers.Rows[i]["PhoneType"].ToString().Trim() == "")
{
sPhoneType = "Unknown";
}
else
{
sPhoneType = oFormatter.FormatDBOutput(tblPhoneNumbers.Rows[i]["PhoneType"].ToString());
}
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Attributes["style"] = "white-space: nowrap; font-weight: bold; text-align: right;";
oTd.InnerHtml = sPhoneType;
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Attributes["style"] = "white-space: nowrap;";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblPhoneNumbers.Rows[i]["PhoneNumber"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblPhoneNumbers.Rows[i]["PhoneNotes"].ToString());
oTr.Cells.Add(oTd);
tblPhone.Rows.Add(oTr);
}
}
else
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.ColSpan = 2;
oTd.InnerHtml = "No recorded Phone Numbers.";
oTr.Cells.Add(oTd);
tblPhone.Rows.Add(oTr);
}
tdPhoneInfo.Controls.Add(tblPhone);
#endregion
#region Display Email Addresses
HtmlTable tblEmail = new HtmlTable();
tblEmail.CellSpacing = 0;
tblEmail.Attributes["class"] = "tblPersons";
tblEmail.Style["width"] = " 100%";
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trTitle";
oTd.ColSpan = 3;
oTd.Style["text-align"] = "right";
oTd.InnerHtml = "<span style=\"width: 90%; text-align: center;\">Household Email Info.</span>";
oTd.InnerHtml += "<a href=\"" + ap + "/Household/EditHousehold.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Edit Household Info\" style=\"align: right;\" /></a>";
oTr.Cells.Add(oTd);
tblEmail.Rows.Add(oTr);
string sEmailType;
if (tblEmailAddresses.Rows.Count > 0)
{
for (int i = 0; i < tblEmailAddresses.Rows.Count; i++)
{
if (tblEmailAddresses.Rows[i]["EmailType"].ToString().Trim() == "")
{
sEmailType = "Unknown";
}
else
{
sEmailType = oFormatter.FormatDBOutput(tblEmailAddresses.Rows[i]["EmailType"].ToString());
}
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Attributes["style"] = "white-space: nowrap; font-weight: bold; text-align: right;";
oTd.InnerHtml = sEmailType;
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Attributes["style"] = "white-space: nowrap;";
oTd.InnerHtml = "<a href=\"" + tblEmailAddresses.Rows[i]["EmailAddress"].ToString() + "\">" + oFormatter.FormatDBOutput(tblEmailAddresses.Rows[i]["EmailAddress"].ToString()) + "</a>";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblEmailAddresses.Rows[i]["EmailNotes"].ToString());
oTr.Cells.Add(oTd);
tblEmail.Rows.Add(oTr);
}
}
else
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.ColSpan = 2;
oTd.InnerHtml = "No recorded Email Addresses.";
oTr.Cells.Add(oTd);
tblEmail.Rows.Add(oTr);
}
tdEmailInfo.Controls.Add(tblEmail);
tdEmailInfo.Style["page-break-after"] = "always";
#endregion
#region Display Info Log
if (tblInfoLog.Rows.Count > 0)
{
#region Display Header Info.
HtmlTable tblLogInfo = new HtmlTable();
tblLogInfo.Attributes["class"] = "tblPersons";
tblLogInfo.Style["width"] = " 100%";
tblLogInfo.Attributes["name"] = "tblLogInfo";
tblLogInfo.Attributes["id"] = "tblLogInfo";
tblLogInfo.CellSpacing = 0;
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trTitle";
oTd.ColSpan = 5;
oTd.Style["text-align"] = "right";
oTd.InnerHtml += "<span style=\"text-align: center; width: 90%;\">" + sHouseholdName + " Household Info. Log</span>";
oTd.InnerHtml += "<a href=\"" + ap + "/Household/AppendLog.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Append Log\" style=\"align: right;\" /></a>";
oTr.Cells.Add(oTd);
tblLogInfo.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTr.Attributes["class"] = "trHeader";
oTd = new HtmlTableCell();
oTd.InnerHtml = "Date";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "Priority";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "Category";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "Staff";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = " ";
oTr.Cells.Add(oTd);
tblLogInfo.Rows.Add(oTr);
#endregion
for (int i = 0; i < tblInfoLog.Rows.Count; i++)
{
oTr = new HtmlTableRow();
oTr.Attributes["onclick"] = "HighlightRow(this); HighlightRow(document.getElementById('trInfo" + oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoID"].ToString()) + "'));";
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
oTd.Style["width"] = "25%";
oTd.InnerHtml = "<a href=\"javascript:ExpandRow('trInfo" + oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoID"].ToString()) + "');\">" + oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoDate"].ToString()) + "</a>";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "25%";
if (tblInfoLog.Rows[i]["LogPriority"].ToString().ToLower() == "urgent")
{
oTd.Style["color"] = "#ff0000";
oTd.Style["font-weight"] = "bold";
}
oTd.InnerHtml = oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogPriority"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "25%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoCat"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "20%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["StaffShortName"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "5%";
oTd.InnerHtml = "<a href=\"" + ap + "/Household/AppendLog.aspx?HouseholdID=" + nHouseholdID.ToString() + "&LogInfoID=" + oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoID"].ToString()) + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Edit this Log Entry\" /></a>";
oTr.Cells.Add(oTd);
tblLogInfo.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTr.Style["display"] = "none";
oTr.Attributes["id"] = "trInfo" + oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoID"].ToString());
if (bDoDark)
{
oTr.Style["background-color"] = "#efefef";
}
oTd = new HtmlTableCell();
oTd.ColSpan = 5;
oTd.InnerHtml = oFormatter.FormatDBOutput(tblInfoLog.Rows[i]["LogInfoNotes"].ToString());
oTr.Cells.Add(oTd);
tblLogInfo.Rows.Add(oTr);
bDoDark = !bDoDark;
}
tdInfoLog.Controls.Add(tblLogInfo);
}
else
{
tdInfoLog.InnerHtml = "<a href=\"" + ap + "/Household/AppendLog.aspx?HouseholdID=" + nHouseholdID.ToString() + "\" class=\"DoNotPrint\">Add Household Log Entry</a>";
}
bDoDark = false;
#endregion
#region Display Contact Log
if (tblContactLog.Rows.Count > 0)
{
HtmlTable tblLogContact = new HtmlTable();
tblLogContact.Attributes["class"] = "tblPersons";
tblLogContact.Style["width"] = " 100%";
tblLogContact.Attributes["name"] = "tblLogContact";
tblLogContact.Attributes["id"] = "tblLogInfo";
tblLogContact.CellSpacing = 0;
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trTitle";
oTd.ColSpan = 5;
oTd.Style["text-align"] = "right";
oTd.InnerHtml += "<span style=\"text-align: center; width: 90%;\">" + sHouseholdName + " Household Contact Log</span>";
oTd.InnerHtml += "<a href=\"" + ap + "/Household/AppendLog.aspx?HouseholdID=" + nHouseholdID.ToString() + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Append Log\" style=\"align: right;\" /></a>";
oTr.Cells.Add(oTd);
tblLogContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTr.Attributes["class"] = "trHeader";
oTd = new HtmlTableCell();
oTd.InnerHtml = "Date";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "Priority";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "Contact Type";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "Staff";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = " ";
oTr.Cells.Add(oTd);
tblLogContact.Rows.Add(oTr);
for (int i = 0; i < tblContactLog.Rows.Count; i++)
{
oTr = new HtmlTableRow();
oTr.Attributes["onclick"] = "HighlightRow(this); HighlightRow(document.getElementById('trContact" + oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogContactID"].ToString()) + "'));";
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
if (bDoDark)
{
oTr.Attributes["class"] = "trDark";
}
oTd = new HtmlTableCell();
oTd.Style["width"] = "25%";
oTd.InnerHtml = "<a href=\"javascript:ExpandRow('trContact" + oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogContactID"].ToString()) + "');\">" + oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogDate"].ToString()) + "</a>";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "25%";
if (tblContactLog.Rows[i]["LogPriority"].ToString().ToLower() == "urgent")
{
oTd.Style["color"] = "#ff0000";
oTd.Style["font-weight"] = "bold";
}
oTd.InnerHtml = oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogPriority"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "25%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogContactType"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "20%";
oTd.InnerHtml = oFormatter.FormatDBOutput(tblContactLog.Rows[i]["StaffShortName"].ToString());
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.Style["width"] = "5%";
oTd.InnerHtml = "<a href=\"" + ap + "/Household/AppendLog.aspx?HouseholdID=" + nHouseholdID.ToString() + "&LogContactID=" + oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogContactID"].ToString()) + "\"><img src=\"" + ap + "/images/edit.gif\" alt=\"Edit this Log Entry\" /></a>";
oTr.Cells.Add(oTd);
tblLogContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTr.Style["display"] = "none";
oTr.Attributes["id"] = "trContact" + oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogContactID"].ToString());
if (bDoDark)
{
oTr.Style["background-color"] = "#efefef";
}
oTd = new HtmlTableCell();
oTd.ColSpan = 5;
oTd.InnerHtml = oFormatter.FormatDBOutput(tblContactLog.Rows[i]["LogNotes"].ToString());
oTr.Cells.Add(oTd);
tblLogContact.Rows.Add(oTr);
bDoDark = !bDoDark;
}
tdContactLog.Controls.Add(tblLogContact);
}
else
{
tdContactLog.InnerHtml = "<a href=\"" + ap + "/Household/AppendLog.aspx?HouseholdID=" + nHouseholdID.ToString() + "\" class=\"DoNotPrint\">Add Contact Log Entry</a>";
}
bDoDark = false;
#endregion
#region Display Secondary Contact Info
if (tblSecondaryContacts.Rows.Count > 0)
{
HtmlTable tblSecondaryContact = new HtmlTable();
tblSecondaryContact.Attributes["class"] = "tblPersons";
tblSecondaryContact.Style["width"] = " 100%";
tblSecondaryContact.Attributes["name"] = "tblAddress";
tblSecondaryContact.Attributes["id"] = "tblSecondaryContact";
tblSecondaryContact.CellSpacing = 0;
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trTitle";
oTd.ColSpan = 2;
oTd.InnerHtml = "Secondary Contact Info.";
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
if (tblSecondaryContacts.Rows.Count > 0)
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "First Name";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml += oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["FirstName"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Last Name";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["LastName"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Relationship";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["EmerContactType"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Phone 1";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["Phone1"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Phone 2";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["Phone2"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Address";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["Address"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "City";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["City"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "State";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["StateName"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Postal Code";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["Zip"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.Style["text-align"] = " right";
oTd.Style["font-weight"] = " bold";
oTd.Style["width"] = " 35%";
oTd.InnerHtml = "Notes";
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = oFormatter.FormatDBOutput(tblSecondaryContacts.Rows[0]["Notes"].ToString());
oTr.Cells.Add(oTd);
tblSecondaryContact.Rows.Add(oTr);
}
tdSecondaryContact.Controls.Add(tblSecondaryContact);
}
else
{
tdSecondaryContact.InnerHtml = " ";
}
#endregion
#region Display Screening Information
if (tblScreening.Rows.Count > 0)
{
HtmlTable tblScreeningInfo = new HtmlTable();
tblScreeningInfo.Attributes["class"] = "tblPersons";
tblScreeningInfo.Style["width"] = " 100%";
tblScreeningInfo.Attributes["name"] = "tblScreeningInfo";
tblScreeningInfo.Attributes["id"] = "tblScreeningInfo";
tblScreeningInfo.CellSpacing = 0;
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTr.Attributes["class"] = "trTitle";
oTd.ColSpan = 2;
oTd.InnerHtml = "Screening Information";
oTr.Cells.Add(oTd);
tblScreeningInfo.Rows.Add(oTr);
for (int i = 0; i < tblScreening.Rows.Count; i++)
{
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.InnerHtml = tblScreening.Rows[i]["FullName"].ToString();
oTr.Cells.Add(oTd);
oTd = new HtmlTableCell();
oTd.InnerHtml = "<a href=\"" + ap + "/screening/results/individual_results.asp?selSurveyID=" + tblScreening.Rows[i]["SurveyID"].ToString() + "&selPersonID=" + tblScreening.Rows[i]["PersonID"].ToString() + "\">" + tblScreening.Rows[i]["SurveyName"].ToString() + "</a>";
oTr.Cells.Add(oTd);
tblScreeningInfo.Rows.Add(oTr);
}
tdScreening.Controls.Add(tblScreeningInfo);
}
else
{
tdScreening.InnerHtml = " ";
}
#endregion
}
else
{
tblMaster.Rows.Clear();
oTr = new HtmlTableRow();
oTd = new HtmlTableCell();
oTd.InnerHtml = "The Household you selected does not exist or there are no persons within the Household.<br/><a href=\"" + ap + "/Household/EditHousehold.aspx?HouseholdID=" + nHouseholdID.ToString() + "\">Click here to try to edit the Household.</a>";
oTr.Cells.Add(oTd);
tblMaster.Rows.Add(oTr);
}
}
