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 IEnumerable<Team> FetchTeamsByConference(Conference conference, Context context) { var query = (from teams in context.Teams where teams.ConfRefNum == conference.RefNum select teams).ToList(); return query; }
//============ Constructors =================// public GameService(int id) { _context = new Context(); _id = id; _gameStat = GameStatistic(_id, _context); _game = FetchGameByGameStatistic(_gameStat); }
//public IEnumerable<PlayerRecord> FetchPlayerRecordsByPlayers() //{ // IEnumerable<Player> TeamPlayers = FetchPlayersByTeam(); // return FetchPlayerRecordsByPlayers(TeamPlayers); //} //public IEnumerable<TeamRecord> FetchTeamRecordsByTeam() //{ // return FetchTeamRecordsByTeam(_team, _context); //} //============= Private Methods =============// private Team FetchTeamById(int id, Context context) { var query = (from team in context.Teams where team.Id == id select team).SingleOrDefault(); return query; }
private Team FetchByRefNum(string refNum, Context context) { Team query = (from team in context.Teams where team.RefNum == refNum select team).Single(); return query; }
private Team FetchTeamByPlayer(Player player, Context context) { var query = (from team in context.Teams where team.RefNum == player.TeamRefNum select team).SingleOrDefault(); return query; }
//============== Constructors =============// public TeamService(int id) { _id = id; _context = new Context(); _team = FetchTeamById(_id, _context); }
private IEnumerable<PlayerRecord> FetchRecordsByPlayer(Player player, Context context) { var query = (from record in context.PlayerRecords where record.PlayerRefNum == player.RefNum select record).ToList(); return query; }
private IEnumerable<Player> FetchPlayersBySearch(string searchValue, Context context) { var query = (from player in context.Players where player.FirstName.Contains(searchValue) || player.LastName.Contains(searchValue) select player).ToList(); return query; }
private Stadium FetchStadiumByGame(Game game, Context context) { var query = (from stadium in context.Stadiums where stadium.RefNum == game.StadiumRefNum select stadium).SingleOrDefault(); return query; }
private IEnumerable<Conference> FetchConferencesBySearch(string searchValue, Context context) { var query = (from conference in context.Conferences where conference.Name.Contains(searchValue) select conference).ToList(); return query; }
private IEnumerable<Team> FetchTeamsBySearch(string searchValue, Context context) { var query = (from team in context.Teams where team.Name.Contains(searchValue) select team).ToList(); return query; }
private Conference FetchConferenceByPlayer(Player player, Context context) { Team team = FetchTeamByPlayer(_player, _context); var query = (from conference in context.Conferences where conference.RefNum == team.ConfRefNum select conference).SingleOrDefault(); 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 IEnumerable<TeamRecord> FetchRecordsByTeams(Conference conference, Context context, string gamePhase) { IEnumerable<Team> teamList = FetchTeamsByConference(conference, context); ICollection<TeamRecord> conferenceRecords = new List<TeamRecord>(); foreach (Team team in teamList) { var recordList = (from tr in context.TeamRecords where tr.TeamRefNum == team.RefNum && tr.GamePhase == gamePhase select tr).ToList(); if (recordList != null) { foreach (var record in recordList) { conferenceRecords.Add(record); } } } return conferenceRecords; }
private Team FetchTeamByGame(string homeOrVistior, Game game, Context context) { if (homeOrVistior == "home") { var query = (from team in context.Teams where team.RefNum == game.HomeTeamRefNum select team).Single(); return query; } if (homeOrVistior == "visitor") { var query = (from team in context.Teams where team.RefNum == game.VisitTeamRefNum select team).Single(); return query; } else { throw new ArgumentException("The method - FetchTeamByGame() in GameService.cs - requires the string to contain either home or visitor"); } }
public SearchService(string searchValue) { _searchValue = searchValue; _context = new Context(); }
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; }
//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 Player Player(int id, Context context) { var player = context.Players.Find(id); return player; }
public PlayerService(int id) { _id = id; _context = new Context(); _player = Player(); }
//============== Private Methods =============// private Conference Conference(Context context, int id) { var conference = context.Conferences.Find(id); return conference; }
//============== Constructors =============// public ConferenceService(int id) { _id = id; _context = new Context(); _conference = Conference(_context, _id); }
//=========== Private Methods ===============// private GameStatistic GameStatistic(int id, Context context) { var gameStat = context.GameStatistics.Find(id); return gameStat; }