public ActionResult GAME(int id) { if (User.IsInRole("Judge")) { if (id == 0) { //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var GamePageModel = new GamePageModel(); //GAME ID CHANGES BASED ON WHATEVER IS PASSED THROUGH CONTROLLER //1 IS A TEST VALUE var GAME = (from a in db.GAMES where a.GameID == id select a).FirstOrDefault(); //Count the amount of teams //Where function will have to change based on competition //Create variable "i" to count with each competition so it can find amount of teams attached to each competition //Attach "i" to the where function GamePageModel.Desc = GAME.Desc; GamePageModel.GameID = GAME.GameID; GamePageModel.Name = GAME.Name; foreach (var c in db.Competitions.Where(a => a.GameID == 1).ToList()) { int i = 0; foreach (var s in db.StudentTeams.Where(a => a.CompID == c.CompID)) { i++; } var Competition = (from a in db.Competitions where a.CompID == c.CompID select a).FirstOrDefault(); var CompetitionPageModel = new CompetitionPageModel(); CompetitionPageModel.CompID = Competition.CompID; CompetitionPageModel.Date = Competition.Date; CompetitionPageModel.Location = Competition.Location; CompetitionPageModel.ExtraData = Competition.ExtraData; CompetitionPageModel.TeamCount = i; GamePageModel.Competitions.Add(CompetitionPageModel); } return(View(GamePageModel)); } else { return(View("IsNotAuthenticated")); } }
public ActionResult Competition(int id) { if (id == 0) { //return new HttpStatusCodeResult(HttpStatusCode.BadRequest); } var CompetitionPageModel = new CompetitionPageModel(); int i = 0; //COMPETITION ID CHANGES BASED ON WHATEVER IS PASSED THROUGH CONTROLLER //1 IS A TEST VALUE var Competition = (from a in db.Competitions where a.CompID == id select a).FirstOrDefault(); CompetitionPageModel.CompID = Competition.CompID; CompetitionPageModel.Date = Competition.Date; CompetitionPageModel.Location = Competition.Location; CompetitionPageModel.ExtraData = Competition.ExtraData; CompetitionPageModel.GameID = Competition.GameID; CompetitionPageModel.FieldPreferred.Add(Competition.field1preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field2preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field3preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field4preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field5preferred); CompetitionPageModel.FieldPreferred.Add(Competition.field6preferred); CompetitionPageModel.validmatches[0] = Competition.validmatch1; CompetitionPageModel.validmatches[1] = Competition.validmatch2; CompetitionPageModel.validmatches[2] = Competition.validmatch3; CompetitionPageModel.validmatches[3] = Competition.validmatch4; CompetitionPageModel.validmatches[4] = Competition.validmatch5; CompetitionPageModel.validmatches[5] = Competition.validmatch6; int sitem = 0; foreach (var s in db.StudentTeams.ToList()) { var TeamData = db.StudentTeams.Find(s.TeamID); var Round1 = (from a in db.RoundEntries where a.TeamID == s.TeamID && a.Round == 1 && a.Usable == true select a).FirstOrDefault(); var Round2 = (from a in db.RoundEntries where a.TeamID == s.TeamID && a.Round == 2 && a.Usable == true select a).FirstOrDefault(); i++; var TeamDataModel = new TeamDataModel(); TeamDataModel.TeamName = TeamData.TeamName; TeamDataModel.TeamID = TeamData.TeamID; TeamDataModel.TeamNumberBranch = TeamData.TeamNumberBranch; TeamDataModel.TeamNumberSpecific = TeamData.TeamNumberSpecific; TeamDataModel.Round1Score = 0; TeamDataModel.Round2Score = 0; if (Round2 != null) { TeamDataModel.Round2Score = Round2.Score; } if (Round1 != null) { TeamDataModel.Round1Score = Round1.Score; } TeamDataModel.RoundAverage = TeamDataModel.Round1Score + TeamDataModel.Round2Score; TeamDataModel.RoundAverage = TeamDataModel.RoundAverage / 2; CompetitionPageModel.Teams.Add(TeamDataModel); } return(View(CompetitionPageModel)); }