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); }
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); } }
public async Task <IActionResult> GetAllAppVariable(AppVariablesQueryFilter filters) { var response = await _appVariablesService.GetAllFilter(filters); return(Ok(response)); }