public async Task SeedAsync(DataSeedContext context) { if (await _clubPlayerRepository.GetCountAsync() > 0) { return; } Guid nrgClubId = Guid.Parse("161da449-c4e5-4c54-b57f-de7fa7e635ab"); List <ClubPlayer> clubPlayers = new List <ClubPlayer>() { // Steff Beckers new ClubPlayer( Guid.Parse("96b862ec-5948-43b9-af82-eb1746e1f81a"), nrgClubId, Guid.Parse("2c9332b8-8500-4df8-9ba2-ceb7100bbcf0")) { IsPrimaryClubOfPlayer = true }, new ClubPlayer( Guid.Parse("f1180e5e-a2e5-4087-8813-78c1e7e776a3"), // Steff's Club Guid.Parse("e1160f82-7f22-434c-9bae-9e1f0f9ed8d5"), Guid.Parse("2c9332b8-8500-4df8-9ba2-ceb7100bbcf0")), // Marco Vitali new ClubPlayer( Guid.Parse("af8ad872-f724-4232-8522-dffdc3a15fdb"), nrgClubId, Guid.Parse("dcac11b3-c666-44c9-979a-3160c62d44cc")) { IsPrimaryClubOfPlayer = true }, // Ronny Bekkers new ClubPlayer( Guid.Parse("ebf15cc9-50b1-4356-8d4c-a3eb0ae1643c"), nrgClubId, Guid.Parse("0362fe6b-c173-4602-873f-a08b9b49fe80")) { IsPrimaryClubOfPlayer = true }, // Ronny Foets new ClubPlayer( Guid.Parse("846f4109-4a56-460b-87a8-df49b0bcc86e"), nrgClubId, Guid.Parse("fca989ed-d314-4121-9fbe-e52dc81f5a9a")) { IsPrimaryClubOfPlayer = true } }; await _clubPlayerRepository.InsertManyAsync(clubPlayers); }
public async Task GetCountAsync() { // Arrange await WithUnitOfWorkAsync(async() => { // Act long result = await _clubPlayerRepository.GetCountAsync( clubId: Guid.Parse("d772238a-9871-47d7-84d5-c45083799954"), playerId: Guid.Parse("85ea0ccf-0fad-4c6f-b660-23e6004a777d") ); // Assert result.ShouldBe(1); }); }
public virtual async Task <PagedResultDto <ClubPlayerListDto> > GetPlayersListAsync(Guid id, GetClubPlayersInput input) { long totalCount = await _clubPlayerRepository.GetCountAsync( input.FilterText, id, null, input.IsPrimaryClubOfPlayer); IQueryable <ClubPlayer> clubPlayerQueryable = await _clubPlayerRepository.GetFilteredQueryableAsync( input.FilterText, id, null, input.IsPrimaryClubOfPlayer, input.Sorting, input.MaxResultCount); IQueryable <Player> playerQueryable = await _playerRepository.GetFilteredQueryableAsync(input.FilterText); IQueryable <ClubPlayerWithNavigationProperties> clubPlayerWithNavigationPropertiesQueryable = clubPlayerQueryable.Join( playerQueryable, x => x.PlayerId, x => x.Id, (clubPlayer, player) => new ClubPlayerWithNavigationProperties() { Id = clubPlayer.Id, ClubId = clubPlayer.ClubId, PlayerId = clubPlayer.PlayerId, Player = player, IsPrimaryClubOfPlayer = clubPlayer.IsPrimaryClubOfPlayer }); IQueryable <ClubPlayerListDto> clubPlayerListDtoQueryable = ObjectMapper .GetMapper() .ProjectTo <ClubPlayerListDto>(clubPlayerWithNavigationPropertiesQueryable); return(new PagedResultDto <ClubPlayerListDto>() { TotalCount = totalCount, Items = await AsyncExecuter.ToListAsync(clubPlayerListDtoQueryable) }); }