public string getPastGoalsTable()
{
try
{
Users usr = new Users();
DataProvider dp = new DataProvider();
DataTable dt = dp.getPastGoals();
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
sb.Append("<table class='table table-bordered'>");
#region head
sb.Append("<thead>");
sb.Append("<tr>");
//button
sb.Append("<td></td>");
//Owner
sb.Append("<td>");
sb.Append("Owner");
sb.Append("</td>");
//Goal
sb.Append("<td>");
sb.Append("Goal");
sb.Append("</td>");
//Date
sb.Append("<td>");
sb.Append("Date Completed");
sb.Append("</td>");
sb.Append("</tr>");
sb.Append("</thead>");
#endregion
#region body
sb.Append("<tbody>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr id='row" + i.ToString() + "'>");
//Button
sb.Append("<td>");
sb.Append("<button type=\"button\" class=\"btn btn-primary\" id=\"btnPastSelect" + i.ToString() + "\">Open</button>");
sb.Append("</td>");
//Owner
sb.Append("<td>");
if (dt.Rows[i]["goalOwner"].ToString().Equals("3"))
{
sb.Append("<img src='" + usr.getProfilePic("1") + "' alt='PP' style='width:25px;'/>");
sb.Append("<img src='" + usr.getProfilePic("2") + "' alt='PP' style='width:25px;'/>");
}
else
{
sb.Append("<img src='" + usr.getProfilePic(dt.Rows[i]["goalOwner"].ToString()) + "' alt='PP' style='width:50px;'/>");
}
sb.Append("</td>");
//Goal Text
sb.Append("<td>");
sb.Append(dt.Rows[i]["textGoal"].ToString());
sb.Append("</td>");
//Date to Complete
sb.Append("<td>");
sb.Append(Convert.ToDateTime(dt.Rows[i]["dateCompleted"].ToString()).ToShortDateString());
sb.Append("</td>");
//Buttons
//Script
sb.Append("<script>");
sb.Append("$(\"#btnPastSelect" + i.ToString() + "\").click(function ()");
sb.Append("{");
sb.Append("window.location.href = 'Goal.aspx?id='+ goalID" + i.ToString() + ";");
sb.Append("});");
sb.Append("</script>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
#endregion
sb.Append("</table>");
return sb.ToString();
}
else
{
return "<h3>No Past Goals</h3>";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
