When searching using filter System.NullReferenceException #4294

6 Answer(s)

• 

  0

  aaron created 6 years ago

  Support Team

  Can you show the implementation of EmployeeDirectoryService.<OpenEmployeeDirectory>?

  Save Cancel
• 

  0

  joe704la created 6 years ago

  Sure. Its two methods. One for the actual service and the other to create the query.

  public async Task<PagedResultDto<EmployeeListDto>> OpenEmployeeDirectory(GetEmployeePagedInput input)
          {
              var query = CreateEmployeeDirectoryQuery(input);
  
              var employeeList = await query
                  .OrderBy(input.Sorting)
                  .PageBy(input)
                  .ToListAsync();
  
              var employeeCount = await query.CountAsync();
  
              return new PagedResultDto<EmployeeListDto>
                  (employeeCount, ObjectMapper.Map<List<EmployeeListDto>>(employeeList));
          }
  
          private IQueryable<Employee> CreateEmployeeDirectoryQuery(GetEmployeePagedInput input)
          {
              var query = _employeeRepository.GetAll()
                  .Select(e => new Employee
              {
                  Id = e.Id,
                  ProId = e.ProId,
                  FirstName = e.FirstName,
                  LastName = e.LastName,
                  WorkPhone = e.WorkPhone,
                  WorkExtension = e.WorkExtension,
                  EmployeeEmail = e.EmployeeEmail,
                  Department = e.Department,
                  Division = e.Division,
                  SupervisorName = e.SupervisorName
              });
  
              query = query
                  .WhereIf(!input.Filter.IsNullOrWhiteSpace(), pc => pc.FirstName.Contains(input.Filter) ||
                                                                     pc.LastName.Contains(input.Filter) ||
                                                                     pc.EmployeeStatus.Contains(input.Filter) ||
                                                                     pc.EmployeeEmail.Contains(input.Filter));
  
              return query;
          }
  

  Save Cancel
• 

  0

  aaron created 6 years ago

  Support Team

  Could the FirstName, LastName, EmployeeStatus or EmployeeEmail be null?

  Save Cancel
• 

  0

  joe704la created 6 years ago

  Yes. None of them are required.

  Save Cancel
• 

  0

  aaron created 6 years ago

  Support Team

  Then you need to add null-checks before using Contains.

  Save Cancel
• 

  0

  joe704la created 6 years ago

  Oh yes I should have thought of that. Thanks for the help.

  Save Cancel