/// <summary>
        ///
        /// </summary>
        public async Task <List <StateResponse> > findAll(StateRequest filter)
        {
            var response = new List <StateResponse>();

            var filterState = new StateFilter();

            filterState.ids = new int[] { filter.id };
            filterState.setQuery(StateProjections.basicOne.Key);
            var msg = new StateFindAllNoPageMsg(filterState);

            var responseQuery = await searchState.handleAsync(msg);

            if (!responseQuery.Any())
            {
                return(response);
            }

            responseQuery.ForEach(x => {
                var StateResponse = new StateResponse();
                StateResponse.fromEntity(x);
                response.Add(StateResponse);
            });

            return(response);
        }
        /// <summary>
        ///
        /// </summary>
        public async Task <List <State> > findAll(StateFilter filter)
        {
            var cache     = new CacheService();
            var listState = cache.load <List <State> >(key_cache_state);

            if (listState == null)
            {
                var msg = new StateFindAllNoPageMsg(filter);
                listState = await searchState.handleAsync(msg);

                cache.save(key_cache_state, listState);
            }

            return(listState);
        }
        /// <summary>
        ///
        /// </summary>
        public async Task <List <State> > handleAsync(StateFindAllNoPageMsg request)
        {
            var listState = await searchState.findAll(request.filter);

            return(listState);
        }