public PagedList <TeamsData> GetTeams(TeamParams teamParams)
{
var teamOwners = _context.TeamsData.Where(t => t.OwnerId.HasValue)
.Select(t => t.OwnerId.GetValueOrDefault());
var reviewers = _context.Reviews.Where(r => r.Rate.HasValue && r.ReviewerProfileId != r.ProfileId)
.Select(r => r.ReviewerProfileId);
var reviewersTeamOwners = reviewers.Intersect(teamOwners);
var teams = _context.TeamsData.Where(t => reviewers.Contains(t.OwnerId.GetValueOrDefault()))
.AsQueryable();
if (!string.IsNullOrEmpty(teamParams.Name))
{
teams = teams.Where(t => t.Name.ToLower().Contains(teamParams.Name.ToLower()));
}
if (!string.IsNullOrEmpty(teamParams.Country))
{
teams = teams.Where(t => t.Country == teamParams.Country);
}
teams = teams.Where(t => t.Rating >= teamParams.MinRating && t.Rating <= teamParams.MaxRating);
return(PagedList <TeamsData> .Create(teams, teamParams.PageNumber, teamParams.PageSize));
}
public IActionResult GetJoukkueet(
int kaudetAlku = 2000,
int kaudetLoppu = 2020,
string sarja = "Miesten superpesis",
string sarjavaihe = "Runkosarja",
Boolean vuosittain = false,
string paikka = "",
string tulos = "",
string vastustaja = "",
string joukkue = ""
)
{
ITeamParams teamParams = new TeamParams(
kaudetAlku,
kaudetLoppu,
sarja,
sarjavaihe,
vuosittain,
paikka,
tulos,
vastustaja,
joukkue
);
queryTimer.Start();
string data = query.haeJoukkueet(teamParams);
queryTimer.Stop("JOUKKUEISIIN");
return(returnStatusHandler.handleResultString(data));
}
/// <inheritdoc/>
public async Task <Team> UpdateTeamAsync(string teamId, string name)
{
var teamParams = new TeamParams {
Name = name
};
return(await TeamsClient.PutResultAsync <Team, TeamParams>($"{WxTeamsConstants.TeamsUrl}/{teamId}", teamParams));
}
/// <inheritdoc/>
public async Task <Team> CreateTeamAsync(string name)
{
var teamParams = new TeamParams {
Name = name
};
return(await TeamsClient.PostResultAsync <Team, TeamParams>(WxTeamsConstants.TeamsUrl, teamParams));
}
public IActionResult Get([FromQuery] TeamParams teamParams)
{
var teams = _teamRepository.GetTeams(teamParams);
var teamsToReturn = _mapper.Map <IEnumerable <TeamForListDto> >(teams);
Response.AddPagination(teams.CurrentPage, teams.PageSize, teams.TotalCount, teams.TotalPages);
return(Ok(teamsToReturn));
}
