public static bool WeekExists(int year, int week) { using (var db = new FFStatsDbContext()) { return(db.TeamRecords.Where(tr => tr.Year == year && tr.Week == week).FirstOrDefault() != null); } }
public static List <Team> GetAllTeams() { using (var db = new FFStatsDbContext()) { return(db.Teams.ToList()); } }
public static bool YearExists(int year) { using (var db = new FFStatsDbContext()) { return(db.Games.Where(g => g.Year == year).FirstOrDefault() != null); } }
public static Player GetById(int id) { using (var db = new FFStatsDbContext()) { return(db.Players.Where(p => p.Id == id).FirstOrDefault()); } }
public static Team GetById(int id) { using (var db = new FFStatsDbContext()) { return(db.Teams.Where(t => t.Id == id).FirstOrDefault()); } }
public static List <Player> GetAll() { using (var db = new FFStatsDbContext()) { return(db.Players.ToList()); } }
public static Player GetByName(string name) { using (var db = new FFStatsDbContext()) { return(db.Players.Where(p => p.Name == name).SingleOrDefault()); } }
public static bool WeekExists(int year, int week) { using (var db = new FFStatsDbContext()) { return(db.RosterEntries.Where(re => re.Year == year && re.Week == week).FirstOrDefault() != null); } }
public static void DeleteGamesInYear(int year) { using (var db = new FFStatsDbContext()) { db.Games.RemoveRange(db.Games.Where(g => g.Year == year)); db.SaveChanges(); } }
public static void AddGames(List <Game> games) { using (var db = new FFStatsDbContext()) { db.Games.AddRange(games); db.SaveChanges(); } }
public static void DeleteRostersInWeek(int year, int week) { using (var db = new FFStatsDbContext()) { db.RemoveRange(db.RosterEntries.Where(re => re.Year == year && re.Week == week)); db.SaveChanges(); } }
public static void Add(List <PlayoffProbability> playoffProbs) { using (var db = new FFStatsDbContext()) { db.PlayoffProbabilities.AddRange(playoffProbs); db.SaveChanges(); } }
public static void Update(SeasonInfo seasonInfo) { using (var db = new FFStatsDbContext()) { db.SeasonInfo.Update(seasonInfo); db.SaveChanges(); } }
public static void Add(TeamRecord teamRecord) { using (var db = new FFStatsDbContext()) { db.TeamRecords.Add(teamRecord); db.SaveChanges(); } }
public static void DeleteTeamRecordsInWeek(int year, int week) { using (var db = new FFStatsDbContext()) { db.TeamRecords.RemoveRange(db.TeamRecords.Where(tr => tr.Year == year && tr.Week == week)); db.SaveChanges(); } }
public static int GetNumChampion(int teamId) { using (var db = new FFStatsDbContext()) { return(db.SeasonInfo .Include(si => si.Champion) .Count(si => si.Champion.Id == teamId)); } }
public static List <Player> GetAll(char firstChar) { using (var db = new FFStatsDbContext()) { return(db.Players .Where(p => p.Name.StartsWith(firstChar)) .ToList()); } }
public static void DeleteWeek(int year, int week) { using (var db = new FFStatsDbContext()) { db.PlayoffProbabilities.RemoveRange( db.PlayoffProbabilities.Where(pp => pp.Year == year && pp.Week == week)); db.SaveChanges(); } }
public static bool WeekExists(int year, int week) { using (var db = new FFStatsDbContext()) { return(db.PlayoffProbabilities .Where(pp => pp.Year == year && pp.Week == week) .FirstOrDefault() != null); } }
public static SeasonInfo Add(SeasonInfo seasonInfo) { using (var db = new FFStatsDbContext()) { db.SeasonInfo.Add(seasonInfo); db.SaveChanges(); } return(seasonInfo); }
public static Game AddGame(Game game) { using (var db = new FFStatsDbContext()) { db.Games.Add(game); db.SaveChanges(); } return(game); }
public static Team Add(Team team) { using (var db = new FFStatsDbContext()) { db.Teams.Add(team); db.SaveChanges(); } return(team); }
public static RosterEntry Add(RosterEntry entry) { using (var db = new FFStatsDbContext()) { db.RosterEntries.Add(entry); db.SaveChanges(); } return(entry); }
public static Player Add(Player player) { using (var db = new FFStatsDbContext()) { db.Players.Add(player); db.SaveChanges(); } return(player); }
// tuple: year, num teams, num weeks on roster, num weeks started // TODO: create class to represent this public static List <Tuple <int, int, int, int> > GetNumWeeksOnRosterGroupedByYear(int playerId) { using (var db = new FFStatsDbContext()) { return(db.RosterEntries .Where(re => re.PlayerId == playerId) .GroupBy(re => re.Year) .Select(g => Tuple.Create(g.Key, g.Select(re => re.TeamId).Distinct().Count(), g.Count(), g.Count(re => re.Position <= Position.FLX))) .ToList()); } }
public static List <Game> GetGamesByWeek(int year, int week) { using (var db = new FFStatsDbContext()) { return(db.Games .Where(g => g.Year == year && g.Week == week) .Include(g => g.GameScores) .ThenInclude(gs => gs.Team) .ToList()); } }
public static void UpdatePoints(int year, int week, int teamId, double?points) { using (var db = new FFStatsDbContext()) { db.GameScores .Where(gs => gs.Year == year && gs.Week == week && gs.TeamId == teamId) .First() .Points = points; db.SaveChanges(); } }
public static List <Team> GetTeamsInYear(int year) { using (var db = new FFStatsDbContext()) { return(db.GameScores .Where(gs => gs.Year == year) .Select(gs => gs.Team) .Distinct() .ToList()); } }
public static List <RosterEntry> GetByTeamAndWeek(int teamId, int year, int week) { using (var db = new FFStatsDbContext()) { return(db.RosterEntries .Where(re => re.Year == year && re.Week == week && re.TeamId == teamId) .Include(re => re.Player) .OrderBy(re => re.Position) .ToList()); } }
public static List <Tuple <int, double?> > GetTotalPointsPerTeam(int year, int week) { using (var db = new FFStatsDbContext()) { return(db.RosterEntries .Where(re => re.Year == year && re.Week == week && re.Position <= Position.FLX) .GroupBy(re => re.TeamId) .Select(g => Tuple.Create(g.Key, g.Sum(re => re.Points))) .ToList()); } }