public async Task <MovieViewModel> GetFilmworldMovie(string id)
{
var result = await FilmworldMovies.Include(i => i.MovieInfo).ThenInclude(i => i.Genres).ThenInclude(i => i.Genre).FirstOrDefaultAsync(i => i.MovieInfo.Id == id);
if (result == null)
{
return(null);
}
return(_mapper.Map <MovieViewModel>(result));
}
public async Task <List <MovieViewModel> > GetFilmworldMovies(MovieRequest request)
{
var movies = await Task.Run(() => {
return(_cache.Use(RequestKey(request), () =>
FilmworldMovies.Include(i => i.MovieInfo).ThenInclude(i => i.Genres).ThenInclude(i => i.Genre)
.Where(movie => !RequestIsNotEmpty(request) ||
!string.IsNullOrEmpty(request.Actors) && movie.MovieInfo.Actors.Contains(request.Actors, StringComparison.InvariantCultureIgnoreCase) ||
!string.IsNullOrEmpty(request.Country) && movie.MovieInfo.Country.Equals(request.Country, StringComparison.InvariantCultureIgnoreCase) ||
!string.IsNullOrEmpty(request.Description) &&
movie.MovieInfo.Description.Contains(request.Description, StringComparison.InvariantCultureIgnoreCase) ||
!string.IsNullOrEmpty(request.Genre) &&
movie.MovieInfo.Genres.Exists(g =>
movie.MovieInfo.Genres.Any(gn => gn.Genre.Name.Equals(request.Genre, StringComparison.InvariantCultureIgnoreCase))) ||
!string.IsNullOrEmpty(request.Title) && movie.MovieInfo.Title.Contains(request.Title, StringComparison.InvariantCultureIgnoreCase) ||
request.Year > 0 && movie.MovieInfo.Released.Year == request.Year
).ToListAsync()));
});
switch (request.SortBy)
{
case SortOptions.ByCountry:
movies = movies.OrderBy(o => o.MovieInfo.Country).Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
case SortOptions.ByDate:
movies = movies.OrderBy(o => o.MovieInfo.Released).Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
case SortOptions.ByTitle:
movies = movies.OrderBy(o => o.MovieInfo.Title).Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
case SortOptions.ByCountryDesc:
movies = movies.OrderByDescending(o => o.MovieInfo.Country).Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
case SortOptions.ByDateDesc:
movies = movies.OrderByDescending(o => o.MovieInfo.Released).Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
case SortOptions.ByTitleDesc:
movies = movies.OrderByDescending(o => o.MovieInfo.Title).Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
default:
movies = movies.Skip((request.Page - 1) * request.PageSize).Take(request.PageSize).ToList();
break;
}
return(_mapper.Map <List <MovieViewModel> >(movies));
}
