Beispiel #1
0
        public IQueryable <Release> SearchQuery(ReleaseSearchModel query)
        {
            var Entities = this.GetAllDescByReleaseDate("Label");

            if (!string.IsNullOrEmpty(query.Search))
            {
                Entities = Entities.Where(w => w.Title.ToLower().Contains(query.Search.ToLower()));
            }

            if (query.GenreID > 0)
            {
                Entities = Entities.Where(w => w.GenreID == query.GenreID);
            }

            if (query.ReleaseTypeID > 0)
            {
                Entities = Entities.Where(w => w.Type == query.ReleaseTypeID);
            }

            if (query.Year > 0)
            {
                Entities = Entities.Where(w => w.Date_Release.Year == query.Year);
            }

            return(Entities);
        }
        public PagedViewModelsContainer GetSearchs(int GenreID = 0, int Year = 0, int Type = 0, string Search = "")
        {
            var Query     = new ReleaseSearchModel(Search, Year, Type, GenreID);
            var ViewModel = new PagedViewModelsContainer();

            ViewModel.Items = Uow.ReleaseRepository.SearchQuery(Query)
                              .ReleasesToViewModelsWithImage();

            return(ViewModel);
        }