public IActionResult ReviewConfirmDelete(int id, string UserId)
{
RatingFilm ratingFilm = _DbContext.RatingFilms.FirstOrDefault(a => a.FilmId == id && a.UserId == UserId);
RatingMuziek ratingMuziek = _DbContext.RatingMuziek.FirstOrDefault(a => a.MuziekId == id && a.UserId == UserId);
RatingSerie ratingSerie = _DbContext.RatingSeries.FirstOrDefault(a => a.SerieId == id && a.UserId == UserId);
RatingPodcast ratingPodcast = _DbContext.RatingPodcasts.FirstOrDefault(a => a.PodcastId == id && a.UserId == UserId);
if (ratingFilm != null)
{
_DbContext.RatingFilms.Remove(ratingFilm);
_DbContext.SaveChanges();
}
if (ratingMuziek != null)
{
_DbContext.RatingMuziek.Remove(ratingMuziek);
_DbContext.SaveChanges();
}
if (ratingSerie != null)
{
_DbContext.RatingSeries.Remove(ratingSerie);
_DbContext.SaveChanges();
}
if (ratingPodcast != null)
{
_DbContext.RatingPodcasts.Remove(ratingPodcast);
_DbContext.SaveChanges();
}
return(RedirectToAction("Reviews"));
}
public IActionResult ReviewDelete(int MediaId, string UserId)
{
DeleteReviewViewModel reviewToDelete = new DeleteReviewViewModel();
RatingFilm ratingFilm = _DbContext.RatingFilms.FirstOrDefault(a => a.FilmId == MediaId && a.UserId == UserId);
RatingMuziek ratingMuziek = _DbContext.RatingMuziek.FirstOrDefault(a => a.MuziekId == MediaId && a.UserId == UserId);
RatingSerie ratingSerie = _DbContext.RatingSeries.FirstOrDefault(a => a.SerieId == MediaId && a.UserId == UserId);
RatingPodcast ratingPodcast = _DbContext.RatingPodcasts.FirstOrDefault(a => a.PodcastId == MediaId && a.UserId == UserId);
if (ratingFilm != null)
{
reviewToDelete.MediaId = ratingFilm.FilmId;
reviewToDelete.UserId = ratingFilm.UserId;
}
if (ratingMuziek != null)
{
reviewToDelete.MediaId = ratingMuziek.MuziekId;
reviewToDelete.UserId = ratingMuziek.UserId;
}
if (ratingSerie != null)
{
reviewToDelete.MediaId = ratingSerie.SerieId;
reviewToDelete.UserId = ratingSerie.UserId;
}
if (ratingPodcast != null)
{
reviewToDelete.MediaId = ratingPodcast.PodcastId;
reviewToDelete.UserId = ratingPodcast.UserId;
}
return(View(reviewToDelete));
}
public IActionResult FilmReview(int id, FilmReviewModel model)
{
if (!TryValidateModel(model))
{
return(View(model));
}
var userId = User.FindFirstValue(ClaimTypes.NameIdentifier);
//OPZOEKEN OF PERSOON AL RATING HEEFT
var bestaandeRating = _DbContext.RatingFilms.FirstOrDefault(a => a.FilmId == id && a.UserId == userId);
if (bestaandeRating != null)
{
_DbContext.RatingFilms.Remove(bestaandeRating);
}
//
RatingFilm rating = new RatingFilm();
Film film = _DbContext.Films.FirstOrDefault(a => a.Id == id);
rating.UserId = userId;
rating.Review = model.Review;
rating.Score = model.Score;
rating.FilmId = film.Id;
_DbContext.RatingFilms.Add(rating);
_DbContext.SaveChanges();
if (User.IsInRole("Admin"))
{
return(RedirectToAction("FilmsList"));
}
else
{
return(RedirectToAction("FilmsList", "Gebruiker"));
}
}
