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;
}
}
protected void btnLogin_Click(object sender, EventArgs e)
{
//verify if login is correct
lblError.Text = "";
Users usr = new Users();
string usrID = usr.verifyAccess(txtUsername.Text.Trim().ToUpper(), txtPassword.Text.Trim());
//take action
if (usrID == null)
{
lblError.Text = "The username / password you used is incorrect.";
}
else
{
Session["GoalOwner"] = usrID;
Response.Redirect("Default.aspx");
}
}
private void populateFields()
{
Users usr = new Users();
DataTable dt = usr.getUser(Session["GoalOwner"].ToString());
txtUserName.Text = dt.Rows[0]["userName"].ToString();
txtPassword.Text = dt.Rows[0]["userPassword"].ToString();
txtEmail.Text = dt.Rows[0]["Email"].ToString();
if (dt.Rows[0]["receiveEmails"].ToString().Equals("Y"))
{
chkReceiveEmails.Checked = true;
}
else
{
chkReceiveEmails.Checked = false;
}
if(!dt.Rows[0]["profilePicturePath"].ToString().Equals(""))
{
divProfilePic.InnerHtml = "<img src=\""+dt.Rows[0]["profilePicturePath"].ToString()+"\" style=\"width:100%;\" alt=\"Profile Pic\" />";
}
}
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();
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
string fileName = "";
string ext = "";
string dbFileName = "";
lblMessage.Text = "";
#region Upload
if (!FileUploadPictures.HasFile)
{
}
else
{
if (FileUploadPictures.HasFile)
{
string tempstr = Session["GoalOwner"].ToString();
string[] typeArray = FileUploadPictures.FileName.Split('.');
ext = "." + typeArray[typeArray.Length - 1];
fileName = Server.MapPath("images") + "/" + tempstr + ext;
dbFileName = "images/profile" + tempstr + ext;
int number = 1;
fileName = Server.MapPath("images") + "/profile" + tempstr + number.ToString() + ext;
dbFileName = "images/profile" + tempstr + number.ToString() + ext;
while (File.Exists(fileName))
{
number++;
fileName = Server.MapPath("images") + "/profile" + tempstr + number.ToString() + ext;
dbFileName = "images/profile" + tempstr + number.ToString() + ext;
}
FtpWebRequest request;
string folderName = "/goals.ayalasolivan.com/images/";
string absoluteFileName = dbFileName;
request = WebRequest.Create(new Uri(string.Format(@"ftp://[email protected]/goals.ayalasolivan.com/" + dbFileName))) as FtpWebRequest;
request.Method = WebRequestMethods.Ftp.UploadFile;
request.UseBinary = true;
request.UsePassive = true;
request.KeepAlive = true;
request.Credentials = new NetworkCredential("hectorhaas2", "6470060aA@");
request.ConnectionGroupName = "group";
byte[] buffer = FileUploadPictures.FileBytes;
Stream requestStream = request.GetRequestStream();
requestStream.Write(buffer, 0, buffer.Length);
requestStream.Close();
requestStream.Flush();
}
}
#endregion
Users usr = new Users();
usr.updateUser(Session["GoalOwner"].ToString(), txtUserName.Text, txtPassword.Text, txtEmail.Text, chkReceiveEmails.Checked,dbFileName);
lblMessage.Text = "Info Updated";
populateFields();
}
