public static List <SportsTeam> GetTeams() { using (var context = new FantasyFootballContext()) { return(context.SportsTeam.ToList()); } }
public static List <Player> GetPlayers() { using (var context = new FantasyFootballContext()) { return(context.Player.ToList()); } }
public static void AddTeam(SportsTeam sportsTeam) { using (var context = new FantasyFootballContext()) { context.SportsTeam.Add(sportsTeam); context.SaveChanges(); } }
public static void AddPlayer(BasePlayer player) { using (var context = new FantasyFootballContext()) { context.BasePlayer.Add(player); context.SaveChanges(); } }
public static void ClearDatabase() { using (var context = new FantasyFootballContext()) { context.BasePlayer.RemoveRange(context.BasePlayer.ToList()); context.Player.RemoveRange(context.Player.ToList()); //context.SportsTeam.RemoveRange(context.SportsTeam.ToList()); context.SaveChanges(); } }
private static Guid?GetTeamId(string team) { using (var context = new FantasyFootballContext()) { return(context.SportsTeam.FirstOrDefault(sportsTeam => sportsTeam.Name.Contains(team, StringComparison.OrdinalIgnoreCase) || team.Contains(sportsTeam.Name, StringComparison.OrdinalIgnoreCase)) ?.Id); } }
private static Guid GetLeagueId(string team) { Guid leagueTeamId = Constants.UnassignedTeamId; using (var context = new FantasyFootballContext()) { leagueTeamId = context.LeagueTeam.FirstOrDefault(sportsTeam => sportsTeam.Name.Contains(team, StringComparison.OrdinalIgnoreCase) || team.Contains(sportsTeam.Name, StringComparison.OrdinalIgnoreCase)) .Id; } return(leagueTeamId); }
public Leaguecontroller(UserManager <ApplicationUser> userManager, FantasyFootballContext db) { _userManager = userManager; _db = db; }
public AccountController(UserManager <ApplicationUser> userManager, SignInManager <ApplicationUser> signInManager, FantasyFootballContext db) { _userManager = userManager; _signInManager = signInManager; _db = db; }
public FantasyFootballUnitOfWork(FantasyFootballContext context) { this.context = context; }