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;
}
