public string populateGoalText()
{
try
{
StringBuilder sb = new StringBuilder();
//Select Goal Info
DataProvider dp = new DataProvider();
DataTable dt = dp.getGoalInfo(goalID);
if (dt.Rows.Count > 0)
{
sb.Append("<p>");
sb.Append(dt.Rows[0]["textGoal"].ToString());
sb.Append("</p>");
sb.Append("<p>");
sb.Append("<b>Goal Date: </b>");
sb.Append(dt.Rows[0]["dateGoal"].ToString());
sb.Append("</p>");
}
else
{
//No Data found
sb.Append("<p>");
sb.Append("An Error Occurred, No Data Found!");
sb.Append("</p>");
}
//Over
return sb.ToString();
}
catch (Exception ex)
{ throw ex; }
}
public string populateCommentsTable()
{
try
{
Users usr = new Users();
StringBuilder sb = new StringBuilder();
DataProvider dp = new DataProvider();
DataTable dt = dp.getComments(goalID);
if (dt.Rows.Count > 0)
{
sb.Append("<table id=\"tableComments\">");
sb.Append("<thead>");
sb.Append("<tr>");
sb.Append("<th></th>");
sb.Append("<th></th>");
sb.Append("</tr>");
sb.Append("</thead>");
sb.Append("<tbody>");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<tr>");
sb.Append("<td>");
sb.Append("<img src='"+ usr.getProfilePic(dt.Rows[i]["OwnerID"].ToString()) + "' alt='PP' style='width:50px;'/>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append(dt.Rows[i]["CommentText"].ToString());
sb.Append("</td>");
sb.Append("</tr>");
}
sb.Append("</tbody>");
sb.Append("</table>");
sb.Append("<script>");
sb.Append("$(document).ready(function(){");
sb.Append("$('#tableComments').DataTable();");
sb.Append("});");
sb.Append("</script>");
}
else
{
sb.Append("<h3>No Comments...</h3>");
}
return sb.ToString();
}
catch (Exception ex)
{
throw ex;
}
}
public void addComment(string comment, string owner)
{
try
{
DataProvider dp = new DataProvider();
dp.addComment(goalID, owner, comment);
}
catch (Exception ex)
{
throw ex;
}
}
public string verifyAccess(string userName, string password)
{
DataProvider dp = new DataProvider();
DataTable dt = dp.verifyAccess(userName, password);
if (dt.Rows.Count > 0)
{
return dt.Rows[0]["Id"].ToString();
}
else
{
return null;
}
}
public void updateUser(string GoalOwnerID, string userName, string userPassword, string email, bool receiveEmails, string profilePicPath)
{
DataProvider dp = new DataProvider();
string receiveEmailsString = "";
if(receiveEmails)
{
receiveEmailsString = "Y";
}
else
{
receiveEmailsString = "N";
}
userName = cleanText(userName);
userPassword = cleanText(userPassword);
email = cleanText(email);
dp.updateUser(GoalOwnerID, userName, userPassword, email, receiveEmailsString, profilePicPath);
}
public string getProfilePic(string GoalOwnerID)
{
DataProvider dp = new DataProvider();
return dp.getProfilePic(GoalOwnerID);
}
public DataTable getUser(string GoalOwnerID)
{
DataProvider dp = new DataProvider();
return dp.getUser(GoalOwnerID);
}
public DataSet getCurrentGoalsWebService()
{
try
{
DataProvider dp = new DataProvider();
DataSet ds = dp.getCurrentGoalsWebService();
return ds;
}
catch (Exception ex)
{
throw ex;
}
}
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();
}
}
public string getCurrentGoalsTable()
{
try
{
Users usr = new Users();
DataProvider dp = new DataProvider();
DataTable dt = dp.getCurrentGoals();
if (dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
StringBuilder scripts = new StringBuilder();
sb.Append("<table class='table table-bordered'>");
scripts.Append("<script>");
#region head
sb.Append("<thead>");
sb.Append("<tr>");
sb.Append("<td>");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("Owner");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("Goal");
sb.Append("</td>");
sb.Append("<td>");
sb.Append("Date to Complete");
sb.Append("</td>");
sb.Append("<td>");
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() + "'>");
//Select Button
sb.Append("<td>");
sb.Append("<button type=\"button\" class=\"btn btn-primary\" id=\"tbnSelect" + 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]["dateGoal"].ToString()).ToShortDateString());
sb.Append("</td>");
//Buttons
sb.Append("<td>");
sb.Append("<a id=\"atag" + i.ToString() + "\" style=\"visibility:hidden;\">" + dt.Rows[i]["Id"].ToString() + "</a>");
sb.Append("<button type=\"button\" class=\"btn btn-danger\" id=\"tbnDelete" + i.ToString() + "\">Delete</button>");
sb.Append("<button type=\"button\" class=\"btn btn-success\" id=\"tbnComplete" + i.ToString() + "\">Complete</button>");
sb.Append("</td>");
sb.Append("</tr>");
//Scripts
scripts.Append("var goalID" + i.ToString() + " = $(\"#atag" + i.ToString() + "\").text();");
//Delete
scripts.Append("$(\"#tbnDelete" + i.ToString() + "\").click(function ()");
scripts.Append("{");
scripts.Append("var textThingy" + i.ToString() + " = $(\"#atag" + i.ToString() + "\").text();");
scripts.Append("var wd" + i.ToString() + " = window.open(\"slavePage.aspx?delete=\"+textThingy" + i.ToString() + ",\"_blank\",\"toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=yes, width=400, height=400\");");
scripts.Append("wd" + i.ToString() + ".onunload = function () {");
scripts.Append("window.location.href = window.location.href;");
scripts.Append("};");
scripts.Append("});");
//Complete
scripts.Append("$(\"#tbnComplete" + i.ToString() + "\").click(function ()");
scripts.Append("{");
scripts.Append("var textThingyC" + i.ToString() + " = $(\"#atag" + i.ToString() + "\").text();");
scripts.Append("var w" + i.ToString() + " = window.open(\"slavePage.aspx?complete=\"+textThingyC" + i.ToString() + ",\"_blank\",\"toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=yes, resizable=no, copyhistory=yes, width=400, height=400\");");
scripts.Append("w" + i.ToString() + ".onunload = function () {");
scripts.Append("window.location.href = window.location.href;");
scripts.Append("};");
scripts.Append("});");
//Select
//Complete
scripts.Append("$(\"#tbnSelect" + i.ToString() + "\").click(function ()");
scripts.Append("{");
scripts.Append("window.location.href = 'Goal.aspx?id='+ goalID" + i.ToString()+";");
scripts.Append("});");
}
sb.Append("</tbody>");
#endregion
sb.Append("</table>");
scripts.Append("</script>");
return sb.ToString() + scripts.ToString();
}
else
{
return "<h2>No Current Goals</h2>";
}
}
catch (Exception ex)
{
return ex.ToString();
}
}
public string populatePictures()
{
StringBuilder sb = new StringBuilder();
DataProvider dp = new DataProvider();
DataTable dt = dp.getPictures(goalID);
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("<div class=\"panel\" style=\"width:32%;float:left;\">");
sb.Append("<img id=\"pdiv" + i.ToString() + "\" src=\"" + dt.Rows[i]["Path"].ToString() + "\" alt=\"X\" style=\"width:100%;\"/>");
sb.Append("<p>" + dt.Rows[i]["Comment"].ToString() + "</p>");
sb.Append("</div>");
sb.Append("<div class=\"modal fade\" id=\"myModal" + i.ToString() + "\" tabindex=\"-1\" role=\"dialog\" aria-hidden=\"true\">");
sb.Append("<div class=\"modal-dialog\">");
sb.Append("<div class=\"modal-content\">");
sb.Append("<div class=\"modal-body\">");
sb.Append("<img src=\"" + dt.Rows[i]["Path"].ToString() + "\" alt=\"X\" style=\"width:100%;\"/>");
sb.Append("<p>" + dt.Rows[i]["Comment"].ToString() + "</p>");
sb.Append("</div>");
sb.Append("<div class=\"modal-footer\">");
sb.Append("<button type=\"button\" class=\"btn btn-default\" data-dismiss=\"modal\">Close</button>");
sb.Append("</div></div></div></div>");
sb.Append("<script>");
sb.Append("$('#myModal" + i.ToString() + "').on('shown.bs.modal', function () {");
sb.Append("$('#pdiv" + i.ToString() + "').focus()");
sb.Append("});");
sb.Append("</script>");
}
}
else
{
sb.Append("<h2>No Pictures...</h2>");
}
return sb.ToString();
}
public void UploadPicture(string ownerID, string comment, string filename)
{
try
{
DataProvider dp = new DataProvider();
dp.addPicture(goalID, filename, ownerID, comment);
}
catch (Exception ex)
{
throw ex;
}
}
