public FilmReviewViewModel CreateFilmReview(FilmReviewModel newReview) { FilmReviewViewModel review = new FilmReviewViewModel { FilmReview = filmRepository.AddFilmReview(newReview), User = userRepository.GetUserList().FirstOrDefault(u => u.User_ID == newReview.User_ID) }; return review; }
public FilmReviewModel AddFilmReview(FilmReviewModel review) { int id = DataProvider.ExecuteScalar<int>("sp_FMAddFilmReviewToFilm", new SqlParameter("@film_id", review.FIlm_ID), new SqlParameter("@user_id", review.User_ID), new SqlParameter("@title", review.Title), new SqlParameter("@review", review.Review), new SqlParameter("@rating", review.Rating)); review.ID = id; return review; }