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 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 List<StringBuilder> getAverages() { List<StringBuilder> sbList = new List<StringBuilder>(); StringBuilder sbToday = new StringBuilder(); StringBuilder sbAll = new StringBuilder(); List<BM_Attempt> todayList = null; List<BM_Attempt> allList = null; DA_Attempts daa = new DA_Attempts(); todayList = daa.returnAllAttemptsToday(); allList = daa.returnAllAttempts(); #region averages //today List if(todayList.Count > 0) { int todaySum = 0; double todayMinutesAverage = 0; for (int i = 0; i<todayList.Count;i++) { todaySum += Convert.ToInt32(todayList[i].secondsamt); } double todayAverage = todaySum / todayList.Count; todayMinutesAverage = todayAverage / 60; todayMinutesAverage = Math.Round(todayMinutesAverage, 1); sbToday.Append("<span style=\"font-size:1.2em\">Today's Average</span>"); sbToday.Append("<br /><br />"); sbToday.Append("<span style=\"font-size:1.8em\">"+todayMinutesAverage.ToString()+"</span><br />"); sbToday.Append("<span style=\"font-size:0.9em\">minute(s)</span>"); sbList.Add(sbToday); } else { //No records for today sbToday.Append("<span style=\"font-size:1.2em\">Today's Average</span>"); sbToday.Append("<br /><br />"); sbToday.Append("<span style=\"font-size:1.8em\">0.0</span><br />"); sbToday.Append("<span style=\"font-size:0.9em\">minute(s)</span>"); sbList.Add(sbToday); } if(allList.Count > 0) { int allSum = 0; double allMinutesAverage = 0; for (int i = 0; i < allList.Count; i++) { allSum += Convert.ToInt32(allList[i].secondsamt); } double allAverage = allSum / allList.Count; allMinutesAverage = allAverage / 60; allMinutesAverage = Math.Round(allMinutesAverage, 1); sbAll.Append("<span style=\"font-size:1.2em\">All-time Average</span>"); sbAll.Append("<br /><br />"); sbAll.Append("<span style=\"font-size:1.8em\">" + allMinutesAverage.ToString() + "</span><br />"); sbAll.Append("<span style=\"font-size:0.9em\">minute(s)</span>"); sbList.Add(sbAll); } else { sbAll.Append("<span style=\"font-size:1.2em\">All-time Average</span>"); sbAll.Append("<br /><br />"); sbAll.Append("<span style=\"font-size:1.8em\">0.0</span><br />"); sbAll.Append("<span style=\"font-size:0.9em\">minute(s)</span>"); sbList.Add(sbAll); } #endregion return sbList; }