public IEnumerable <MovieLocation> GetMovieLocationsAsync(MovieLocationsDto movieLocationsDto) { List <MovieLocation> resultCollections = null; try { resultCollections = new List <MovieLocation>(); List <GridHelper.Filter> filters = new List <GridHelper.Filter>(); GridHelper.Filter gridHelper = new GridHelper.Filter(); gridHelper.PropertyName = movieLocationsDto.SearchBy; gridHelper.Value = movieLocationsDto.SearchByValue; if (!string.IsNullOrEmpty(movieLocationsDto.SearchByFilter)) { gridHelper.Operator = GridHelper.Operator.Contains; //set it only for Single Contain to work } filters.Add(gridHelper); var filterExpression = ExpressionBuilder.GetExpression <MovieLocation>(filters); resultCollections = _db.ListsMovieLocations.Where(filterExpression).ToList(); } catch (Exception ex) { Console.Error.WriteLine("Error occuered:" + ex.Message.ToString()); } return(resultCollections); }
public Task <IEnumerable <MovieLocation> > Handle(GetMovieLocationQueries request, CancellationToken cancellationToken) { var resultCollections = new List <MovieLocation>(); List <GridHelper.Filter> filters = new List <GridHelper.Filter>(); GridHelper.Filter gridHelper = new GridHelper.Filter(); gridHelper.PropertyName = request.SearchBy; gridHelper.Value = request.SearchByValue; if (!string.IsNullOrEmpty(request.SearchByFilter)) { gridHelper.Operator = GridHelper.Operator.Contains; //set it only for Single Contain to work } filters.Add(gridHelper); var filterExpression = ExpressionBuilder.GetExpression <MovieLocation>(filters); var filteResults = _db.ListsMovieLocations.Where(filterExpression).ToList(); return(Task.FromResult(filteResults as IEnumerable <MovieLocation>)); }