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