public Task <List <Team> > Get([FromQuery] TeamQuery teamQuery) { return(context.SeasonTeams.Include(st => st.Season) .Include(st => st.Team) .Where(st => st.Season.Year == teamQuery.Season) .Select(st => st.Team) .ToListAsync()); }
public async Task <BacklogResponse <Team[]> > GetTeamsAsync(TeamQuery query = null) { query = query ?? new TeamQuery(); var response = await GetAsync($"/api/v2/teams", query.Build()).ConfigureAwait(false); return(await CreateResponseAsync <Team[], List <_Team> >( response, HttpStatusCode.OK, data => data.Select(x => new Team(x, this)).ToArray()).ConfigureAwait(false)); }
public async Task <QueryResult <Team> > GetTeams(TeamQuery queryObj) { var result = new QueryResult <Team>(); var query = context.Teams .Include(t => t.Users) .ThenInclude(ut => ut.User) .AsQueryable(); var columnMap = new Dictionary <string, Expression <Func <Team, object> > > { ["name"] = t => t.Name, }; query = query.ApplyOrderBy(queryObj, columnMap); result.TotalItems = query.Count(); query = query.ApplyPaging(queryObj); result.Items = await query.ToListAsync(); return(result); }
public async Task <IActionResult> GetTeams([FromQuery] TeamQuery query) { var teams = await _store.GetTeams(); if (query.Format == ResponseFormat.Csv) { await using var sw = new StringWriter(); await using (var w = new CsvWriter(sw, CultureInfo.InvariantCulture)) { w.Configuration.TypeConverterCache.AddConverter <bool>(new LowercaseBooleanConverter()); await w.WriteRecordsAsync(teams.Select(x => new CsvTeam(x))); } return(Ok(sw.ToString())); } return(Ok(new ApiResponse <ApiTeam> { Data = teams.Select(u => new ApiTeam(u)) })); }
public async Task <TeamQueryResponse> QueryTeams(TeamQuery query) { await Task.CompletedTask; if (query.Id != null) { return new TeamQueryResponse { Items = stagedTeams.Values.Where(t => t.Id == query.Id) } } ; if (query.AssignedCommunityCode != null) { return new TeamQueryResponse { Items = stagedTeams.Values.Where(t => t.AssignedCommunities.Any(c => c.Code == query.AssignedCommunityCode)) } } ; return(new TeamQueryResponse { Items = stagedTeams.Values }); }
public async Task <PagingCollection <TeamListItem> > GetAsync(TeamQuery query, long?userId = null) { var teamQuery = from team in _appContext.Teams.Include(i => i.TrainerTeams) where team.Status == TeamStatus.Available && (!userId.HasValue || userId.Value == team.AuthorId || team.TrainerTeams.Any(i => i.TrainerId == userId.Value)) && (query.Country == null || team.Country.Contains(query.Country)) && (query.City == null || team.City.Contains(query.City)) select team; return(await(from team in teamQuery select new TeamListItem { Id = team.Id, City = team.City, Country = team.Country, PhotoUrl = team.PhotoUrl, Title = team.Title, PhoneNumber = team.PhoneNumber, SubTitle = team.SubTitle, About = team.About }).GetPageAsync(query.Offset, query.Count)); }
public async Task <PartialCollectionResponse <TeamListItem> > GetAll([FromQuery] TeamQuery request) { var teams = await _service.GetAsync(request); return(teams.ToPartialCollectionResponse()); }
public async Task <PartialCollectionResponse <TeamListItem> > GetSelfTeams([FromQuery] TeamQuery query) { var teams = await _service.GetAsync(query, User.GetUserId()); return(teams.ToPartialCollectionResponse()); }