Filtering by Checkbox list #5876

4 Answer(s)

• 

  0

  sbenfares created 5 years ago

  

  Save Cancel
• 

  0

  ismcagdas created 5 years ago

  Support Team

  Hi,

  Could you share your app service method definition ?

  Save Cancel
• 

  0

  sbenfares created 5 years ago

  Finally, when i use an int? array it's working...

  public class GetCandidatsInput : PagedAndSortedInputDto, IShouldNormalize
      {
          public string Filter { get; set; }
  
          [CanBeNull] public int?[] Metiers { get; set; }
  
          [CanBeNull] public int?[] Statuts { get; set; }
  
          public int? PourcentageMini { get; set; }
  
          public int? PourcentageMaxi { get; set; }
  
          public string Region { get; set; }
  
          public void Normalize()
          {
              if (string.IsNullOrEmpty(Sorting))
              {
                  Sorting = "Name,Surname";
              }
          }
      }
  

  I don't really understand why...

  Here is my AppService code :

  public async Task<PagedResultDto<CandidatListDto>> GetCandidats(GetCandidatsInput input)
          {
              var query = UserManager.Users
                  .Where(u => u.CandidatId.HasValue)
                  .WhereIf((input.Metiers ?? throw new InvalidOperationException()).Any(x=>x.HasValue) , u => input.Metiers.Contains(u.Candidat.MetierCode))
                  .WhereIf((input.Statuts ?? throw new InvalidOperationException()).Any(x => x.HasValue), u => input.Statuts.Contains(u.Candidat.StatutInscriptionCode))
                  .WhereIf(input.PourcentageMini.HasValue, u => u.Candidat.PourcentageCompletudeProfil >= input.PourcentageMini.Value)
                  .WhereIf(input.PourcentageMaxi.HasValue, u => u.Candidat.PourcentageCompletudeProfil <= input.PourcentageMaxi.Value)
                  .WhereIf(!input.Region.IsNullOrWhiteSpace(), u => u.Candidat.Adresse.Region.Equals(input.Region))
                  .WhereIf(
                      !input.Filter.IsNullOrWhiteSpace(),
                      u =>
                          u.Name.Contains(input.Filter) ||
                          u.Surname.Contains(input.Filter) ||
                          u.UserName.Contains(input.Filter) ||
                          u.PhoneNumber.Contains(input.Filter) ||
                          u.EmailAddress.Contains(input.Filter)
                  );
  
              var candidatsCount = await query.CountAsync();
  
              var candidats = await query
                  .OrderBy(input.Sorting)
                  .PageBy(input)
                  .Select(x => new CandidatListDto
                  {
                      Id = x.Id,
                      PhotoUrl = x.PhotoUrl.IsNullOrEmpty() ? BlobConsts.Avatars.DefaultImageFilePath : $"{_appConfiguration["App:AzureContainerUrlBase"] + _appConfiguration["App:AzureAvatarContainerName"]}/{x.PhotoUrl}",
                      FullName = x.FullName,
                      CreationTime = x.CreationTime,
                      Statut = StatutInscriptionCandidatsConsts.StatutsInscriptionKeyValuePairs.FirstOrDefault(p => p.Key.Equals(x.Candidat.StatutInscriptionCode)).Value,
                      Metier = x.Candidat.MetierAutre.IsNullOrEmpty() ? MetiersConsts.MetiersKeyValuePairs.FirstOrDefault(p => p.Key.Equals(x.Candidat.MetierCode)).Value  : x.Candidat.MetierAutre
                  })
                  .ToListAsync();
  
              var candidatsListDtos = ObjectMapper.Map<List<CandidatListDto>>(candidats);
  
              return new PagedResultDto<CandidatListDto>(
                  candidatsCount,
                  candidatsListDtos
                  );
          }
  

  Save Cancel
• 

  0

  ismcagdas created 5 years ago

  Support Team

  Hi @sbenfares

  Have you solved your problem ?

  Save Cancel