public IEnumerable<GameView> GetGame(int id)
{
var game = db.Games.SingleOrDefault(g => g.Id == id);
var homeTeam = db.Teams.SingleOrDefault(t => t.Id == game.HomeTeam_Id).Team1;
var awayTeam = db.Teams.SingleOrDefault(t => t.Id == game.AwayTeam_Id).Team1;
var points = Standen.GetMaxScoreForPredictionType(game.PredictionType_Id);
var numberOfRightPredictions =
db.Predictions.Where(
p =>
p.Game_Id == game.Id &&
p.Points ==
(points)).Count();
var gameViewList = new List<GameView>();
var gameView = new GameView
{
AwayScore = game.AwayScore.ToString(),
HomeScore = game.HomeScore.ToString(),
HomeTeam = homeTeam,
AwayTeam = awayTeam,
NumberOfRightPredictions = numberOfRightPredictions
};
gameViewList.Add(gameView);
return gameViewList;
}
public IEnumerable<GameView> GetGame()
{
var games = from it in db.Games
orderby it.Id
select it;
var gameViewList = new List<GameView>();
foreach (var game in games)
{
var awayScore = 0;
var homeScore = 0;
if (game.AwayScore != null)
{
awayScore = (int) game.AwayScore;
homeScore = (int) game.HomeScore;
}
var gameView = new GameView
{
AwayScore = awayScore.ToString(),
HomeScore = homeScore.ToString(),
HomeTeam = game.HomeTeam_Id.ToString(),
AwayTeam = game.AwayTeam_Id.ToString()
};
gameViewList.Add(gameView);
}
return gameViewList;
}
public GameView GetLatestGame()
{
var playedgames = db.Games.Where(g => g.Played == true);
var sortId = playedgames.Max(g => g.sortId);
var teams = db.Teams.ToList();
var game = playedgames.Single(g => g.sortId == sortId);
var homeTeam = teams.Single(t => t.Id == game.HomeTeam_Id);
var awayTeam = teams.Single(t => t.Id == game.AwayTeam_Id);
var gameView = new GameView()
{
AwayScore = game.AwayScore.ToString(),
HomeScore = game.HomeScore.ToString(),
HomeTeam = homeTeam.ToString(),
AwayTeam = awayTeam.ToString()
};
return gameView;
}
public RightPrediction GetRightPredictions()
{
var rightGamepredictionList = new List<RightGamePrediction>();
var rightSecondRoundPredictionList = new List<RightSecondRoundPrediction>();
var teams = db.Teams.ToList();
var playedGames = db.Games.Where(g => g.Played == true).ToList();
var gameGames = playedGames.Where(g => g.PredictionType_Id == PredictionType.Game).OrderBy(g=>g.sortId);
var secondRoundGames =
playedGames.Where(
g => g.PredictionType_Id != PredictionType.Game && g.PredictionType_Id != PredictionType.Table).ToList();
var predictions = db.Predictions.ToList();
var participants = db.Participants.ToList();
#region
foreach (var game in gameGames)
{
var points = Standen.GetMaxScoreForPredictionType(game.PredictionType_Id);
var rightGamePredictions =
predictions.Where(
p =>
p.Game_Id == game.Id &&
p.Points ==
(points)).ToList();
var participantList = new List<ParticipantView>();
foreach (var rightGamePrediction in rightGamePredictions)
{
var participant = participants.SingleOrDefault(
p => p.Id == rightGamePrediction.Participant_Id);
var participantLine = new ParticipantView
{
Name = participant.Name,
ParticipantId = participant.Id
};
participantList.Add(participantLine);
}
var orderedParticipantList = participantList.OrderBy(p => p.Name).ToList();
var homeTeam = teams.SingleOrDefault(t => t.Id == game.HomeTeam_Id).Team1;
var awayTeam = teams.SingleOrDefault(t => t.Id == game.AwayTeam_Id).Team1;
var gameView = new GameView
{
AwayScore = game.AwayScore.ToString(),
HomeScore = game.HomeScore.ToString(),
HomeTeam = homeTeam,
AwayTeam = awayTeam,
GameId = game.Id,
Played = (bool) game.Played,
Date = game.Date.ToString(),
SortId = (int) game.sortId
};
var firstRoundPrediction = new RightGamePrediction
{
GameView = gameView,
Participants = orderedParticipantList
};
rightGamepredictionList.Add(firstRoundPrediction);
}
#endregion
foreach (var game in secondRoundGames)
{
var points = Standen.GetMaxScoreForPredictionType(game.PredictionType_Id);
var rightSecondRoundPredictions = predictions.Where(
p =>
p.Team_Id == game.Team_Id &&
p.PredictionType_Id == game.PredictionType_Id &&
p.Points ==
(points)).ToList();
var participantList = new List<ParticipantView>();
foreach (var rightSecondRoundPrediction in rightSecondRoundPredictions)
{
var participant = participants.SingleOrDefault(
p => p.Id == rightSecondRoundPrediction.Participant_Id);
var participantLine = new ParticipantView
{
Name = participant.Name,
ParticipantId = participant.Id
};
participantList.Add(participantLine);
}
var orderedParticipantList = participantList.OrderBy(p => p.Name).ToList();
var homeTeam = teams.SingleOrDefault(t => t.Id == game.Team_Id).Team1;
var roundName = "";
switch (game.PredictionType_Id)
{
case PredictionType.QuarterFinals:
{
roundName = "in de kwartfinale";
break;
}
case PredictionType.SemiFinal:
{
roundName = "in de halve finale";
break;
}
case PredictionType.Final:
{
roundName = "in de finale";
break;
}
case PredictionType.Winner:
{
roundName = "als winnaar";
break;
}
}
var gameView = new GameView
{
HomeTeam = homeTeam,
RoundName = roundName,
};
var secondRoundPrediction = new RightSecondRoundPrediction()
{
GameView = gameView,
Participants = orderedParticipantList
};
rightSecondRoundPredictionList.Add(secondRoundPrediction);
}
var orderedFirstRoundPredicionts = rightGamepredictionList.OrderByDescending(r => r.GameView.SortId).ToList();
var rightpredictions = new RightPrediction
{
FirstRoundRightPredictions = orderedFirstRoundPredicionts,
SecondRoundPredictions = rightSecondRoundPredictionList
};
return rightpredictions;
}
public RightPrediction GetRightPredictions(int id)
{
var game = db.Games.SingleOrDefault(g => g.Id == id);
var points = Standen.GetMaxScoreForPredictionType(game.PredictionType_Id);
var rightPredictions =
db.Predictions.Where(
p =>
p.Game_Id == game.Id &&
p.Points ==
(points));
var participants = db.Participants.ToList();
var participantList = new List<ParticipantView>();
foreach (var rightPrediction in rightPredictions)
{
var participant = participants.SingleOrDefault(
p => p.Id == rightPrediction.Participant_Id);
var participantLine = new ParticipantView
{
Name = participant.Name,
ParticipantId = participant.Id
};
participantList.Add(participantLine);
}
var homeTeam = db.Teams.SingleOrDefault(t => t.Id == game.HomeTeam_Id).Team1;
var awayTeam = db.Teams.SingleOrDefault(t => t.Id == game.AwayTeam_Id).Team1;
var gameView = new GameView
{
AwayScore = game.AwayScore.ToString(),
HomeScore = game.HomeScore.ToString(),
HomeTeam = homeTeam,
AwayTeam = awayTeam,
GameId = game.Id,
Played = (bool) game.Played,
Date = game.Date.ToString()
};
var rightPrediction1 = new RightPrediction
{
FirstRoundRightPredictions = new List<RightGamePrediction>
{new RightGamePrediction
{
GameView = gameView,
Participants = participantList
}}
};
return rightPrediction1;
}
public IEnumerable<GameView> GetAllDeelnemers()
{
HetEKSpelEntities db = new HetEKSpelEntities(connectionString);
var firstRoundMatches = db.Games.Where(g => g.PredictionType_Id == PredictionType.Game).ToList();
var secondRoundMatches = db.SecondRounds.ToList();
var teams = db.Teams.ToList();
var gameView = new List<GameView>();
foreach (var firstRoundMatch in firstRoundMatches)
{
var awayTeamShort = teams.Single(t => t.Id == firstRoundMatch.AwayTeam_Id).Short;
var homeTeamShort = teams.Single(t => t.Id == firstRoundMatch.HomeTeam_Id).Short;
var awayTeam = teams.Single(t => t.Id == firstRoundMatch.AwayTeam_Id).Team1;
var homeTeam = teams.Single(t => t.Id == firstRoundMatch.HomeTeam_Id).Team1;
var newline = new GameView
{
AwayScore = firstRoundMatch.AwayScore.ToString(),
HomeScore = firstRoundMatch.HomeScore.ToString(),
AwayTeam = awayTeam,
HomeTeam = homeTeam,
AwayTeamShort = awayTeamShort,
HomeTeamShort = homeTeamShort,
GameId = firstRoundMatch.Id,
Date = string.Format(firstRoundMatch.Date +" om " +firstRoundMatch.Time),
City = firstRoundMatch.City,
SortId = (int) firstRoundMatch.sortId
};
gameView.Add(newline);
}
foreach (var secondRoundMatch in secondRoundMatches)
{
var awayTeam = teams.Single(t => t.Id == secondRoundMatch.AwayTeam_Id).Team1;
var homeTeam = teams.Single(t => t.Id == secondRoundMatch.HomeTeam_Id).Team1;
var awayTeamShort = teams.Single(t => t.Id == secondRoundMatch.AwayTeam_Id).Short;
var homeTeamShort = teams.Single(t => t.Id == secondRoundMatch.HomeTeam_Id).Short;
var newline = new GameView
{
//todo scores meegeven
HomeScore = secondRoundMatch.HomeScore.ToString(),
AwayScore = string.Format(secondRoundMatch.AwayScore +" "+ secondRoundMatch.Uitslag),
AwayTeamShort = awayTeamShort,
HomeTeamShort = homeTeamShort,
AwayTeam = awayTeam,
HomeTeam = homeTeam,
GameId = secondRoundMatch.Id,
Date = string.Format(secondRoundMatch.Date + " om " + secondRoundMatch.Time),
City = secondRoundMatch.City,
SortId = secondRoundMatch.Id
};
gameView.Add(newline);
}
var sortedList = gameView.OrderBy(g => g.SortId).ToList();
return sortedList;
}
