private IQueryable <PlaqueState> GetFilteredQuery(GetPlaqueStateInput input)
        {
            var query = QueryableExtensions.WhereIf(_plaqueStateRepository.GetAll(),
                                                    !input.Filter.IsNullOrWhiteSpace(), u =>
                                                    u.Name.Contains(input.Filter) ||
                                                    u.Code.Contains(input.Filter));

            return(query);
        }
        public async Task <PagedResultDto <PlaqueStateListDto> > GetPlaqueState(GetPlaqueStateInput input)
        {
            var query     = GetFilteredQuery(input);
            var userCount = await query.CountAsync();

            var plaqueStates = await query
                               .OrderBy(input.Sorting)
                               .PageBy(input)
                               .ToListAsync();

            var plaqueStatesListDto = ObjectMapper.Map <List <PlaqueStateListDto> >(plaqueStates);

            return(new PagedResultDto <PlaqueStateListDto>(
                       userCount,
                       plaqueStatesListDto
                       ));
        }