protected void btnSubmit_Click(object sender, EventArgs e)
{
btnSubmit.Enabled = false;
btnLock.Enabled = true;
txtPrivateNotes.Enabled = false;
txtPublicNotes.Enabled = false;
txtSignOff.Enabled = false;
//do the things
BL_VOE blv = new BL_VOE();
string voeID = Request.QueryString.Get("id");
BM_Logs bml = new BM_Logs();
bml.voeID = voeID;
bml.signoff = txtSignOff.Text;
bml.privateNotes = txtPrivateNotes.Text;
bml.publicNotes = txtPublicNotes.Text;
//get seconds
DateTime pastdate = Convert.ToDateTime(hdnDate.Value.ToString());
bml.seconds = Convert.ToInt32(((DateTime.Now - pastdate).TotalSeconds));
//Update
blv.updateLogs(bml);
txtPrivateNotes.Text = "";
txtPublicNotes.Text = "";
CareForLogs();
}
public BM_Logs getLogs(string voeID)
{
string query = "Select * hectorhaas.precheckVOE WHERE voeID = " + voeID;
DataTable dt = DataAccess.getAnyDataTable(query);
BM_Logs bml = new BM_Logs();
bml.id = dt.Rows[0]["id"].ToString();
bml.privateNotes = dt.Rows[0]["privateNotes"].ToString();
bml.publicNotes = dt.Rows[0]["publicNotes"].ToString();
bml.voeID = dt.Rows[0]["voeID"].ToString();
return(bml);
}
private void CareForLogs()
{
BL_VOE blv = new BL_VOE();
BM_Logs bml = blv.CareForLogs(Request.QueryString["id"].ToString());
if (!(bml == null))
{
StringBuilder sb = new StringBuilder();
sb.Append("<button class=\"btn btn-info\" id=\"btnShowPublicLogs\">Public Logs</button>");
sb.Append(" ");
sb.Append("<button class=\"btn btn-info\" id=\"btnShowPrivateLogs\">Private Logs</button>");
//divs
sb.Append("<div id=\"divPrivateNotes\"><span style=\"font-size:1.2em\">Private</span><br /><br />" + bml.privateNotes + "</div>");
sb.Append("<div id=\"divPublicNotes\"><span style=\"font-size:1.2em\">Public</span><br /><br />" + bml.publicNotes + "<br />" + bml.signoff + "</div>");
//script
sb.Append("<script>");
sb.Append("$(document).ready(function() {");
//Prepare dialogs
sb.Append("$(\"#divPrivateNotes\").dialog({");
sb.Append("autoOpen: false,");
sb.Append("show: \"blind\",");
sb.Append("hide: \"explode\"");
sb.Append("});");
sb.Append("$(\"#divPublicNotes\").dialog({");
sb.Append("autoOpen: false,");
sb.Append("show: \"blind\",");
sb.Append("hide: \"explode\"");
sb.Append("});");
sb.Append("$(\"#btnShowPrivateLogs\").click(function() {");
sb.Append("$(\"#divPrivateNotes\").dialog(\"open\");");
sb.Append("return false;");
sb.Append(" });");
sb.Append("$(\"#btnShowPublicLogs\").click(function() {");
sb.Append("$(\"#divPublicNotes\").dialog(\"open\");");
sb.Append("return false;");
sb.Append(" });");
sb.Append("});");
sb.Append("</script>");
//Inner HTMLS
divBtns.InnerHtml = sb.ToString();
txtSignOff.Text = bml.signoff;
}
}
public void updateLogs(BM_Logs logs)
{
string query = "Select id, publicNotes, privateNotes, voeID FROM hectorhaas.precheckLogs WHERE voeID = " + logs.voeID;
DataTable dt = DataAccess.getAnyDataTable(query);
logs.privateNotes = logs.privateNotes + "<br /><br />" + dt.Rows[0]["privateNotes"].ToString();
logs.publicNotes = logs.publicNotes + "<br /><br />" + dt.Rows[0]["publicNotes"].ToString();
query = "UPDATE hectorhaas.precheckLogs SET publicNotes = '" + logs.publicNotes.Trim().Replace("'", "''") + "', privateNotes='" + logs.privateNotes.Trim().Replace("'", "''") + "', signoff = '" + logs.signoff.Trim().Replace("'", "''") + "' WHERE voeID = " + logs.voeID;
DataAccess.justExecuteQuery(query);
//add time attempts
DA_Attempts daa = new DA_Attempts();
daa.insertAttempt(logs.seconds.ToString());
}
public BM_Logs CareForLogs(string voeID)
{
DA_VOE dav = new DA_VOE();
DataTable dt = dav.CareForLogs(voeID);
BM_Logs bml = new BM_Logs();
if (dt.Rows.Count > 0)
{
bml.id = dt.Rows[0]["id"].ToString();
bml.publicNotes = dt.Rows[0]["publicNotes"].ToString();
bml.privateNotes = dt.Rows[0]["privateNotes"].ToString();
bml.signoff = dt.Rows[0]["signoff"].ToString();
bml.voeID = dt.Rows[0]["voeID"].ToString();
return(bml);
}
else
{
return(null);
}
}
public void updateLogs(BM_Logs logs)
{
DA_VOE dav = new DA_VOE();
dav.updateLogs(logs);
}
