//gets the current/upcoming event for the judge
public ActionResult GetEvent()
{
string query = "select j.eventID, j.competitorID, u.fname," +
" u.lname, j.jumpnr, j.jumptype, us.fname as JudgeFirstName ," +
" us.lname as JudgeLastName, s.score, j.finalscore " +
"from jump as j " +
"left join score as s on j.jumpID = s.jumpID " +
"left join competitor as c on c.competitorID = j.competitorID " +
"left join user as u on u.userID = c.userID " +
"left join judge as ju on ju.judgeID = s.judgeID " +
"left join user as us on us.userID = ju.userID " +
"where j.eventID = @eventID " +
"order by j.competitorID and j.jumpnr";
EventJumpModel eventjump = new EventJumpModel();
eventjump.userID = (int)HttpContext.Session.GetInt32("UserID");
Console.WriteLine("userID: " + eventjump.userID);
StringBuilder jumpListHtml = new StringBuilder("<table id=\"jumpTbl\">" +
"<tr><th>Event Name</th><th>Competitor ID</th>" +
"<th>First Name</th><th>Last Name</th><th>Jump nr</th><th>Jump Type</th>" +
"<th>Judge First Name</th><th>Judge Last Name</th><th>Score</th><th>Final Score</th></tr>");
string query_original = "select j.jumpID, j.eventID, j.competitorID," +
" u.fname, u.lname, j.jumpnr, s.judgeID, s.score, j.finalscore" +
" from jump as j inner join score as s on j.jumpID = s.jumpID " +
"inner join competitor as c on c.competitorID = j.competitorID " +
"inner join user as u on u.userID = c.userID " +
"where j.eventID = @eventID group by j.jumpID, s.judgeID";
string query_upcoming_event = "SELECT e.eventID from event as e " +
"inner join eventjudge as ej on ej.eventID = e.eventID " +
"inner join judge as j on j.judgeID = ej.judgeID " +
"inner join user as u on u.userID = j.userID " +
"where u.userID=@userID and startdate>=date('now') " +
"order by startdate " +
"asc limit 1";
eventjump = SqliteDataAccess.SingleObject(eventjump, query_upcoming_event);
if (eventjump == null)
{
return(RedirectToAction("Scoring", "Home"));
}
Console.WriteLine("event: " + eventjump.eventID);
jumpObjList = SqliteDataAccess.LoadEventJumps(eventjump, query);
Console.WriteLine("list: " + jumpObjList);
int i = 1;
foreach (var jump in jumpObjList)
{
jumpListHtml.Append("<tr id=" + i + "><td>");
jumpListHtml.Append(eventjump.eventID);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.competitorID);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.fname);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.lname);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.jumpnr);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.jumptype);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.JudgeFirstName);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.JudgeLastName);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.score);
jumpListHtml.Append("</td><td>");
jumpListHtml.Append(jump.finalscore);
jumpListHtml.Append("</td></tr>");
}
jumpListHtml.Append("</table>");
TempData["eventjumps"] = jumpListHtml.ToString();
return(RedirectToAction("Scoring", "Home"));
}
