//============== Constructors =============//
public TeamService(int id)
{
_id = id;
_context = new Context();
_team = FetchTeamById(_id, _context);
}
private TeamGameStatistic FetchGameStatsByTeam(Team team, Game game, Context context)
{
var query = (from tgs in context.TeamGameStatistics
where (team.RefNum == tgs.TeamRefNum) && (game.RefNum == tgs.GameRefNum)
select tgs).Single();
return query;
}
private Conference FetchConferenceByTeam(Team team, Context context)
{
string conferenceRefNum = team.ConfRefNum;
Conference query = (from conference in context.Conferences
where conference.RefNum == conferenceRefNum
select conference).Single();
return query;
}
private void CheckReturnedRefNumFromTeamViewMode(TeamViewModel tvm, Team team)
{
}
private void CheckReturnedTeamFromTeamViewModel(TeamViewModel tvm, Team team)
{
TeamViewModel test = new TeamViewModel(team.Id);
Assert.AreEqual(team, test.Team);
}
public TeamGameStatistic FetchGameStatsByTeam(Team team)
{
return FetchGameStatsByTeam(team, _game, _context);
}
//private IEnumerable<PlayerRecord> FetchPlayerRecordsByPlayers(IEnumerable<Player> teamPlayers)
//{
// ICollection<PlayerRecord> allPlayerRecords = new List<PlayerRecord>();
// foreach (Player player in teamPlayers)
// {
// var query = (from playerRecord in _context.PlayerRecords
// where playerRecord.PlayerRefNum == player.RefNum
// select playerRecord).Single();
// allPlayerRecords.Add(query);
// }
// return allPlayerRecords;
//}
//private IEnumerable<TeamRecord> FetchTeamRecordsByTeam(Team team, Context context)
//{
// var query = (from teamRecord in context.TeamRecords
// where teamRecord.TeamRefNum == team.RefNum
// select teamRecord);
// return query;
//}
private IEnumerable<ICollection<string>> FetchGameInformationByTeam(Team team, Context context)
{
var Games = (from game in _context.Games
where game.HomeTeamRefNum == _team.RefNum || game.VisitTeamRefNum == _team.RefNum
select game).Distinct();
ICollection<List<string>> gameDetail = new List<List<string>>();
foreach (Game game in Games)
{
Team homeTeam = FetchByRefNum(game.HomeTeamRefNum, _context);
Team visitTeam = FetchByRefNum(game.VisitTeamRefNum, _context);
Stadium stadium = FetchStadiumByGame(game, _context);
var gameInformation = new List<string>();
gameInformation.Add(game.Date.ToString("mm/dd/yyyy"));
gameInformation.Add(homeTeam.Name + " vs. " + visitTeam.Name + " at " + stadium.Name + " in " + stadium.City + ", " + stadium.State);
gameInformation.Add(game.Id.ToString());
gameDetail.Add(gameInformation);
}
return gameDetail;
}
private IEnumerable<Player> FetchPlayersByTeam(Team team, Context context)
{
var query = (from player in _context.Players
where player.TeamRefNum == _team.RefNum
select player).Distinct();
return query;
}
//============ Constructors ==============//
public TeamViewModel(int id)
{
_teamService = new TeamService(id);
_team = _teamService.Team();
}