コード例 #1
0
        public async Task <ApiResponse <List <AppVariablesGetDto> > > GetAllFilter(AppVariablesQueryFilter filter)
        {
            List <AppVariablesGetDto> resultDto = new List <AppVariablesGetDto>();
            Metadata metadata = new Metadata
            {
                IsValid = true,
                Message = ""
            };

            ApiResponse <List <AppVariablesGetDto> > response = new ApiResponse <List <AppVariablesGetDto> >(resultDto);

            List <AppVariables> variables = await _unitOfWork.AppVariablesRepository.GetAllFilter(filter);

            List <AppVariablesGetDto> variablesGetDto = _mapper.Map <List <AppVariablesGetDto> >(variables);

            response.Data    = variablesGetDto;
            metadata.IsValid = true;
            metadata.Message = "";
            response.Meta    = metadata;
            return(response);
        }
コード例 #2
0
        public async Task <List <AppVariables> > GetAllFilter(AppVariablesQueryFilter filter)
        {
            List <AppVariables> result = new List <AppVariables>();


            try
            {
                if (filter.Code != null && filter.Code.Length > 0)
                {
                    result = await _context.AppVariables.Where(x => x.Code.Trim().ToLower() == filter.Code.Trim().ToLower()).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();

                    return(result);
                }
                else if (filter.SearchText != null && filter.SearchText.Length > 0)
                {
                    result = await _context.AppVariables.Where(x => x.Description.Trim().ToLower().Contains(filter.SearchText.Trim().ToLower()) || x.Code.Trim().ToLower().Contains(filter.SearchText.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();

                    return(result);
                }
                else if (filter.Description != null && filter.Description.Length > 0)
                {
                    result = await _context.AppVariables.Where(x => x.Description.Trim().ToLower().Contains(filter.Description.Trim().ToLower())).Skip((filter.PageNumber - 1) * filter.PageSize).Take(filter.PageSize).ToListAsync();

                    return(result);
                }
                else
                {
                    result = await _context.AppVariables.Skip((filter.PageNumber - 1) *filter.PageSize).Take(filter.PageSize).ToListAsync();

                    return(result);
                }
            }
            catch (Exception e)
            {
                var a = e.InnerException.Message;
                return(result);
            }
        }
コード例 #3
0
        public async Task <IActionResult> GetAllAppVariable(AppVariablesQueryFilter filters)
        {
            var response = await _appVariablesService.GetAllFilter(filters);

            return(Ok(response));
        }