public IActionResult Index()
{
List <MovieRegisseurListViewModel> listVM = new List <MovieRegisseurListViewModel>();
IEnumerable <MovieRegisseur> movieGenresFromDb = _movieRegisseurService.Get();
foreach (var genre in movieGenresFromDb)
{
listVM.Add(new MovieRegisseurListViewModel
{
Id = genre.Id,
Naam = genre.Naam
});
}
MovieRegisseurIndexViewModel vm = new MovieRegisseurIndexViewModel
{
ListVM = listVM
};
return(View(vm));
}
public IActionResult Index()
{
List <MovieListViewModel> movies = new List <MovieListViewModel>();
IEnumerable <Movie> moviesFromDb = _movieService.Get();
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
foreach (var movie in moviesFromDb)
{
string regisseurs = _regisseurService.GetRegisseursByMovieId(movie.Id).Count() != 0 ? string.Join(",", _regisseurService.GetRegisseursByMovieId(movie.Id).Select(x => x.Naam)) : "Geen regisseur";
string genres = _genreService.GetGenresByMovieId(movie.Id) != null?string.Join(",", _genreService.GetGenresByMovieId(movie.Id).Select(x => x.Naam)) : "Geen genres";
int ratingAvg = movie.RatingReviews != null && movie.RatingReviews.Where(r => r.MovieId == movie.Id).Select(r => r.Rating).Count() != 0 ?
movie.RatingReviews.Where(rat => rat.MovieId == movie.Id && rat.Rating > -1).Select(r => r.Rating).Sum()
/ movie.RatingReviews.Where(rat => rat.MovieId == movie.Id && rat.Rating > -1).Count() : -1;
int aantalGezien = movie.UserMovieGezienStatus != null?
movie.UserMovieGezienStatus.Where(s => s.MovieId == movie.Id && s.MovieGezienStatus != null && s.MovieGezienStatusId == 2).Count() : 0;
int heeftGezien = userId != null && movie.UserMovieGezienStatus.Any(s => s.UserId == userId) ?
movie.UserMovieGezienStatus.SingleOrDefault(s => s.MovieId == movie.Id && s.UserId == userId).MovieGezienStatusId : 1;
movies.Add(new MovieListViewModel
{
Id = movie.Id,
Titel = movie.Titel,
Beschrijving = movie.Beschrijving,
Regisseurs = regisseurs,
Genres = genres,
AantalGezien = aantalGezien,
HeeftGezien = heeftGezien,
Rating = ratingAvg,
});
}
List <SelectListItem> GezienStatusList = new List <SelectListItem>();
foreach (var status in _GezienStatusService.Get())
{
GezienStatusList.Add(new SelectListItem {
Value = status.Id.ToString(), Text = status.Status
});
}
List <SelectListItem> RatingList = new List <SelectListItem> {
new SelectListItem {
Value = "0", Text = "Geen selectie"
},
new SelectListItem {
Value = "1", Text = "Up"
},
new SelectListItem {
Value = "2", Text = "Down"
}
};
List <SelectListItem> genreList = new List <SelectListItem>();
genreList.Add(new SelectListItem {
Value = "0", Text = "Selecteer genre"
});
foreach (var gen in _genreService.Get())
{
genreList.Add(new SelectListItem {
Value = gen.Id.ToString(), Text = gen.Naam
});
}
List <SelectListItem> regisseurList = new List <SelectListItem>();
regisseurList.Add(new SelectListItem {
Value = "0", Text = "Selecteer regisseur"
});
foreach (var reg in _regisseurService.Get())
{
regisseurList.Add(new SelectListItem {
Value = reg.Id.ToString(), Text = reg.Naam
});
}
MovieFilterListViewModel model = new MovieFilterListViewModel
{
Movies = movies,
RegisseurList = regisseurList,
};
return(View(model));
}