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)); }