public async Task <IEnumerable <OverviewElementDto> > Handle(MediaOverviewQuery @event, CancellationToken cancellationToken = default)
        {
            var libs = await _dispatcher.Dispatch(new CurrentUserLibraryAccessQuery());

            var seriesDetailIds = await _context.EpisodeFiles
                                  .Where(ef => ef.SeriesDetailsId != null && libs.Contains(ef.PartOfLibraryId))
                                  .Select(ef => ef.SeriesDetailsId).Distinct()
                                  .ToListAsync(cancellationToken);

            var seriesDetails = await _context.SeriesDetails
                                .Where(sd => seriesDetailIds.Contains(sd.Id))
                                .ProjectTo <OverviewElementDto>(_mapper.ConfigurationProvider)
                                .ToListAsync(cancellationToken);

            var filmDetailsIds = await _context.FilmFiles
                                 .Where(ff => ff.FilmDetailsId != null && libs.Contains(ff.PartOfLibraryId))
                                 .Select(ff => ff.FilmDetailsId)
                                 .ToListAsync(cancellationToken);

            var filmDetails = await _context.FilmDetails
                              .AsNoTracking()
                              .Where(fd => filmDetailsIds.Contains(fd.Id))
                              .Include(ff => ff.Genres)
                              .Include(ff => ff.BelongsInCollection)
                              .ToListAsync(cancellationToken);

            var collections = filmDetails
                              .Where(fd => fd.BelongsInCollectionId.HasValue)
                              .GroupBy(fd => fd.BelongsInCollectionId)
                              .Where(group => group.Count() > 1)
                              .Select(group => group.First().BelongsInCollection)
                              .ToList();

            var collectionIds    = collections.Select(c => c.Id).ToList();
            var notInCollections = filmDetails.Where(fd => fd.BelongsInCollectionId == null || !collectionIds.Contains(fd.BelongsInCollectionId.Value)).ToList();

            var overview = new List <OverviewElementDto>(seriesDetails.Count + notInCollections.Count + collections.Count);

            overview.AddRange(seriesDetails);
            overview.AddRange(_mapper.Map <List <DbFilmDetails>, List <OverviewElementDto> >(notInCollections));
            overview.AddRange(_mapper.Map <List <MovieCollection>, List <OverviewElementDto> >(collections));

            return(overview.OrderBy(oe => oe.Title).ToList());
        }
Exemple #2
0
        private async Task <(string CachePrefix, string CacheOwner, string CacheKey)> CacheKeyGenerator(MediaOverviewQuery _)
        {
            var libs = await _dispatcher.Dispatch(new CurrentUserLibraryAccessQuery());

            return("overview", "sys", string.Join(',', libs.OrderBy(i => i)));
        }