public virtual async Task <List <TEntity> > GetAsync(QueryInject <TEntity> queryInject = null)
{
IQueryable <TEntity> query = Db.Set <TEntity>();
if (queryInject != null)
{
query = queryInject(query, Db);
}
return(await query.ToListAsync());
}
public virtual async Task <TEntity> FindAsync(TKey id, QueryInject <TEntity> queryInject = null)
{
IQueryable <TEntity> query = Db.Set <TEntity>();
if (queryInject != null)
{
query = queryInject(query, Db);
}
return(await query.FirstOrDefaultAsync(ent => ent.Id.Equals(id)));
}
private IQueryable <Season> GetQuery(QueryInject <Season> queryInject)
{
IQueryable <Season> query = _dbContext.Seasons;
return(queryInject == null ? query : queryInject(query));
}
public async Task <Season> GetSeason(int id, QueryInject <Season> queryInject = null)
{
return(await GetQuery(queryInject).FirstOrDefaultAsync(s => s.Id == id));
}
public async Task <List <Season> > GetAllSeasonsBySeries(int seriesId, QueryInject <Season> queryInject = null)
{
return(await GetQuery(queryInject).Where(season => season.SeriesId == seriesId).ToListAsync());
}
public async Task <Series> GetSeriesByName(string name, QueryInject <Series> queryInject = null)
{
return(await GetQuery(queryInject).FirstOrDefaultAsync(s => s.Name == name));
}
public async Task <List <Series> > GetAllSeries(QueryInject <Series> queryInject = null)
{
return(await GetQuery(queryInject).ToListAsync());
}
private IQueryable <Series> GetQuery(QueryInject <Series> queryInject)
{
IQueryable <Series> query = _context.Series;
return(queryInject == null ? query : queryInject(query));
}
