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); }