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