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