public List <Series> GetList(IFilmFilter filter) { var seriesQuery = this.DbContext.Series.Include(s => s.Seasons) .AsQueryable(); if (!string.IsNullOrWhiteSpace(filter?.Name)) { seriesQuery = seriesQuery .Where(v => v.Name.ToLower().Contains(filter.Name.ToLower()) || v.Name_ENG.ToLower().Contains(filter.Name.ToLower())); } if (filter != null && filter.Year != 0) { seriesQuery = seriesQuery .Where(v => v.Year == filter.Year); } if (filter?.Category != null && filter?.Category != 0) { List <Series> retVal = new List <Series>(); foreach (Series v in seriesQuery) { if (v.Categories.Contains(filter.Category)) { retVal.Add(v); } } return(retVal.OrderByDescending(v => v.Year).ThenBy(v => v.Name).ToList()); } return(seriesQuery.OrderByDescending(v => v.Year).ThenBy(v => v.Name).ToList()); }
public virtual List <Film> GetList(IFilmFilter filter) { var videosQuery = this.DbContext.Films .AsQueryable(); if (!string.IsNullOrWhiteSpace(filter?.Name)) { videosQuery = videosQuery .Where(v => v.Name.ToLower().Contains(filter.Name.ToLower()) || v.Name_ENG.ToLower().Contains(filter.Name.ToLower())); } if (filter != null && filter.Year != 0) { videosQuery = videosQuery .Where(v => v.Year == filter.Year); } if (filter?.Category != null && filter?.Category != 0) { List <Film> retVal = new List <Film>(); foreach (Film v in videosQuery) { if (v.Categories.Contains(filter.Category)) { retVal.Add(v); } } return(retVal.OrderByDescending(v => v.Year).ThenBy(v => v.Name).ToList()); } return(videosQuery.OrderByDescending(v => v.Year).ThenBy(v => v.Name).ToList()); }
public List <Cartoon> GetList(IFilmFilter filter) { var cartoonsQuery = this.DbContext.Cartoons .AsQueryable(); if (!string.IsNullOrWhiteSpace(filter?.Name)) { cartoonsQuery = cartoonsQuery .Where(v => v.Name.ToLower().Contains(filter.Name.ToLower()) || v.Name_ENG.ToLower().Contains(filter.Name.ToLower())); } if (filter != null && filter.Year != 0) { cartoonsQuery = cartoonsQuery .Where(v => v.Year == filter.Year); } if (filter?.Language != null && filter?.Language != 0) { cartoonsQuery = cartoonsQuery .Where(v => v.Language.Equals(filter.Language)); } if (filter?.Category != null && filter?.Category != 0) { List <Cartoon> retVal = new List <Cartoon>(); foreach (Cartoon v in cartoonsQuery) { if (v.Categories.Contains(filter.Category)) { retVal.Add(v); } } return(retVal.OrderByDescending(v => v.Year).ThenBy(v => v.Name).ToList()); } return(cartoonsQuery.OrderByDescending(v => v.Year).ThenBy(v => v.Name).ToList()); }
public List <Season> GetList(IFilmFilter filter) { return(DbContext.Seasons.Include(e => e.Episodes).ToList()); }
public List <Episode> GetList(IFilmFilter filter) { return(DbContext.Episodes.ToList()); }
public FilmService(IUnitOfWork unitOfWork, IFilmFilter filmFiler, IPagination pagination) : base(unitOfWork) { _unitOfWork = unitOfWork; _filmFiler = filmFiler; _pagination = pagination; }