public IEnumerable <Player> GetAllByTeamID(int teamID)
{
using (var dbContext = new LivescoreDbContext())
{
return(dbContext.Player.Where(x => x.TeamID == teamID).ToList());
}
}
public IEnumerable <Team> GetAllTeamsForUser(string userID)
{
using (var dbContext = new LivescoreDbContext())
{
return(dbContext.Team.Where(x => x.UserID == userID).ToList());
}
}
public IEnumerable <string> GetAllLevels()
{
using (var dbContext = new LivescoreDbContext())
{
return(dbContext.Team.Select(x => x.TeamLevel).Distinct().ToList());
}
}
public IEnumerable <Team> GetAllTeamsFromLevel(string level)
{
using (var dbContext = new LivescoreDbContext())
{
return(dbContext.Team.Where(x => x.TeamLevel == level).ToList());
}
}
public virtual T GetById(int id)
{
using (var dbContext = new LivescoreDbContext())
{
var dbSet = GetDbSet(dbContext);
return(dbSet.Find(id));
}
}
public virtual IEnumerable <T> GetAll()
{
using (var dbContext = new LivescoreDbContext())
{
var dbSet = GetDbSet(dbContext);
return(dbSet.ToList());
}
}
public override Game GetById(int id)
{
using (var dbContext = new LivescoreDbContext())
{
var game = dbContext.Game.Where(x => x.Id == id).Include(x => x.AwayTeam).Include(x => x.HomeTeam).FirstOrDefault();
return(game);
}
}
public IEnumerable <GameIncident> GetGameIncidentsFromGame(int id)
{
using (var dbContext = new LivescoreDbContext())
{
var incidents = dbContext.GameIncident
.Where(x => x.GameId == id).Include(x => x.Player).Include(x => x.Player.Team);
return(incidents.ToList());
}
}
public virtual T Add(T entity)
{
using (var dbContext = new LivescoreDbContext())
{
dbContext.Entry(entity).State = EntityState.Added;
dbContext.SaveChanges();
return(entity);
}
}
public virtual void Edit(T entity)
{
using (var dbContext = new LivescoreDbContext())
{
var dbSet = GetDbSet(dbContext);
dbContext.Entry(entity).State = EntityState.Modified;
dbContext.SaveChanges();
}
}
public IEnumerable <Game> GetMyComingGames(string userId)
{
using (var dbContext = new LivescoreDbContext())
{
DateTime comparisonDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
var games =
dbContext.Game.Where(x => x.UserId == userId && x.MatchDate > comparisonDate).Include(x => x.AwayTeam).Include(x => x.HomeTeam);
return(games.ToList());
}
}
public IEnumerable <Game> GetTodaysGames()
{
using (var dbContext = new LivescoreDbContext())
{
var games =
dbContext.Game.Where(x => x.MatchDate.Year == DateTime.Now.Year && x.MatchDate.Month == DateTime.Now.Month && x.MatchDate.Day == DateTime.Now.Day)
.Include(x => x.AwayTeam).Include(x => x.HomeTeam);
return(games.ToList());
}
}
public virtual void Delete(int id)
{
using (var dbContext = new LivescoreDbContext())
{
var dbSet = GetDbSet(dbContext);
var entity = dbSet.Find(id);
dbContext.Entry(entity).State = EntityState.Deleted;
dbContext.SaveChanges();
}
}
public override System.Data.Entity.DbSet <GameIncident> GetDbSet(LivescoreDbContext context)
{
return(context.GameIncident);
}
public override System.Data.Entity.DbSet <Team> GetDbSet(LivescoreDbContext context)
{
return(context.Team);
}
public abstract DbSet <T> GetDbSet(LivescoreDbContext context);
public override System.Data.Entity.DbSet <Player> GetDbSet(LivescoreDbContext context)
{
return(context.Player);
}
