public ActionResult AddSingleRateToDB(int userRating) { ReviewedMedia r = new ReviewedMedia() { MovieID = int.Parse(Session["returnedMovieID"].ToString()), UserID = User.Identity.GetUserId(), UserRating = userRating }; SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["WhatchaWatchinConnection"].ConnectionString); SqlCommand cmd = new SqlCommand("dbo.sp_StoreOrUpdateReviewedMedia", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter inputMovieID = new SqlParameter("@MovieID", r.MovieID); SqlParameter inputUserID = new SqlParameter("@UserID", r.UserID); SqlParameter inputUserRating = new SqlParameter("@UserRating", r.UserRating); cmd.Parameters.Add(inputMovieID); cmd.Parameters.Add(inputUserID); cmd.Parameters.Add(inputUserRating); var da = new SqlDataAdapter(cmd); var ds = new DataTable(); con.Open(); da.Fill(ds); con.Close(); TempData["message"] = string.Format("You have successfully rated {0}!", TempData["SearchedTitle"].ToString()); return(RedirectToAction("index", "home")); }
public ActionResult DeleteConfirmed(int id) { ReviewedMedia reviewedMedia = db.ReviewedMedias.Find(id); db.ReviewedMedias.Remove(reviewedMedia); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ID,MovieID,UserID,UserRating")] ReviewedMedia reviewedMedia) { if (ModelState.IsValid) { db.Entry(reviewedMedia).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reviewedMedia)); }
public ActionResult Create([Bind(Include = "ID,MovieID,UserID,UserRating")] ReviewedMedia reviewedMedia) { if (ModelState.IsValid) { db.ReviewedMedias.Add(reviewedMedia); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(reviewedMedia)); }
// GET: ReviewedMedias/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ReviewedMedia reviewedMedia = db.ReviewedMedias.Find(id); if (reviewedMedia == null) { return(HttpNotFound()); } return(View(reviewedMedia)); }
//This Packages Data from our Survey, and sends it using the StoreInDatabase Method public ActionResult SendData(string[] userRatings) { List <int> baseSurveyMovieIDs; List <ReviewedMedia> reviewedMediaList = new List <ReviewedMedia>(); if (Session["genreChoice"].ToString() == "Comedy") { baseSurveyMovieIDs = new List <int>() { 1, 2, 122, 4, 5, 24 }; } else if (Session["genreChoice"].ToString() == "Action") { baseSurveyMovieIDs = new List <int>() { 38, 68, 69, 70, 12, 43 }; } else if (Session["genreChoice"].ToString() == "Thriller") { baseSurveyMovieIDs = new List <int>() { 63, 65, 64, 67, 71, 121 }; } else if (Session["genreChoice"].ToString() == "Horror") { baseSurveyMovieIDs = new List <int>() { 72, 134, 74, 75, 76, 135 }; } else if (Session["genreChoice"].ToString() == "Family") { baseSurveyMovieIDs = new List <int>() { 77, 78, 115, 125, 80, 118 }; } else { baseSurveyMovieIDs = new List <int>() { 6, 7, 8, 9, 10, 106 }; } for (int i = 0; i < userRatings.Length; i++) { ReviewedMedia reviewedMovie = new ReviewedMedia { MovieID = baseSurveyMovieIDs[i], UserID = User.Identity.GetUserId(), UserRating = int.Parse(userRatings[i]) }; reviewedMediaList.Add(reviewedMovie); } StoreInDatabase(reviewedMediaList); TempData["message"] = string.Format("You have successfully rated the {0} survey!", Session["genreChoice"].ToString()); return(RedirectToAction("Index", "Home")); }