//Leave Review
public JsonResult LeaveReview(Rating_tbl rating)
{
try
{
rating.Time = DateTime.Now;
db.Rating_tbl.Add(rating);
var totalrate = (from p in db.tbl_platter
where (p.platter_id == rating.Platter_id)
select p).FirstOrDefault();
totalrate.rating_total = totalrate.rating_total + rating.Rate;
totalrate.rating_count++;
if (totalrate.rating == null)
{
totalrate.rating = 0;
}
if (totalrate.rating_count != 0)
{
totalrate.rating = totalrate.rating_total / totalrate.rating_count;
}
db.SaveChanges();
return(Json(new { Success = true, msg = "Thank You for your time" }, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
return(Json(new { Success = false, msg = e.Message }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConfirmed(int id)
{
Rating_tbl rating_tbl = db.Rating_tbl.Find(id);
db.Rating_tbl.Remove(rating_tbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "RatingID,Rating,MovieID,UserName")] Rating_tbl rating_tbl)
{
if (ModelState.IsValid)
{
db.Entry(rating_tbl).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rating_tbl));
}
public ActionResult Info(Rating_tbl rating_tbl)
{
if (ModelState.IsValid)
{
Movie_ReviewDBEntities db = new Movie_ReviewDBEntities();
db.Rating_tbl.Add(rating_tbl);
db.SaveChanges();
return(RedirectToAction("Info", "Home", new { id = rating_tbl.MovieID }));
}
return(View(rating_tbl));
}
public ActionResult Create([Bind(Include = "RatingID,Rating,MovieID,UserName")] Rating_tbl rating_tbl)
{
if (ModelState.IsValid)
{
db.Rating_tbl.Add(rating_tbl);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(rating_tbl));
}
// GET: Rating_tbl/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Rating_tbl rating_tbl = db.Rating_tbl.Find(id);
if (rating_tbl == null)
{
return(HttpNotFound());
}
return(View(rating_tbl));
}
public ActionResult _AddRating(int id)
{
Movie_ReviewDBEntities db = new Movie_ReviewDBEntities();
List <Rating_tbl> ratings = db.Rating_tbl.Where(x => x.MovieID == id).ToList();
var rating = new Rating_tbl();
if (ratings.Count != 0)
{
rating = ratings.Where(x => x.UserName == User.Identity.Name).FirstOrDefault();
}
if (rating == null || ratings.Count == 0)
{
rating = new Rating_tbl();
rating.MovieID = id;
rating.Rating = -1;
}
;
return(View(rating));
}
public ActionResult UpdateComment(Rating_tbl reviewmodel)
{
if (Session["User_id"] != null && Session["User_name"] != null)
{
Session["User_id"].ToString();
Session["User_name"].ToString();
}
reviewmodel.Time = DateTime.Now;
db.Entry(reviewmodel).State = System.Data.Entity.EntityState.Modified;
var totalrate = (from p in db.tbl_platter
where (p.platter_id == reviewmodel.Platter_id)
select p).FirstOrDefault();
totalrate.rating_total = totalrate.rating_total + reviewmodel.Rate;
totalrate.rating_count++;
db.SaveChanges();
return(RedirectToAction("Index", "Home"));
}
