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); }