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