public void Edit_Action_Saves_Updated_Review()
        {
            var editedReview = new Review();
            var controller = new ReviewController(_db);
            controller.Edit(editedReview);

            Assert.IsTrue(_db.Reviews.Contains(editedReview));
        }
        public void Edit_Action_Saves_Changes()
        {
            var editedReview = new Review();
            var controller = new ReviewController(_db);
            controller.Edit(editedReview);

            Assert.IsTrue(_db.ChangesSaved);
        }
 public ActionResult Create(int RestaurantID, Review newReview)
 {
     if (ModelState.IsValid)
     {
         var restaurant = _db.Restaurants.FindById(RestaurantID);
         newReview.Created = DateTime.Now;
         newReview.Body = Sanitizer.GetSafeHtmlFragment(newReview.Body);
         _db.Add(newReview);
         _db.SaveChanges();
         return RedirectToAction("Index");
     }
     newReview.InitRestaurant();
     return View(newReview);
 }
 public ActionResult Create1(int RestaurantID, Review newReview)
 {
     try
     {
         var _db = new RCDB1("RCDB");
         var restaurant = _db.Restaurants.Single(r => r.ID == RestaurantID);
         newReview.Created = DateTime.Now;
         newReview.Body = Sanitizer.GetSafeHtmlFragment(newReview.Body);
         restaurant.Reviews.Add(newReview);
         _db.SaveChanges();
         return RedirectToAction("Index");
     }
     catch
     {
         return View();
     }
 }
        public ActionResult Edit(Review review)
        {
            //try
            //{
            //    review.Body = Sanitizer.GetSafeHtmlFragment(review.Body);
            //    _db.Attach(review);
            //    _db.SaveChanges();
            //    return RedirectToAction("Index");
            //}
            //catch (System.Data.Entity.Validation.DbEntityValidationException ex)
            //{
            //    System.Text.StringBuilder sb = new System.Text.StringBuilder();

            //    foreach (var failure in ex.EntityValidationErrors)
            //    {
            //        sb.AppendFormat("{0} failed validation\n", failure.Entry.Entity.GetType());
            //        foreach (var error in failure.ValidationErrors)
            //        {
            //            sb.AppendFormat("- {0} : {1}", error.PropertyName, error.ErrorMessage);
            //            sb.AppendLine();
            //        }
            //    }

            //    throw new System.Data.Entity.Validation.DbEntityValidationException(
            //        "Entity Validation Failed - errors follow:\n" +
            //        sb.ToString(), ex
            //        );
            //}

            if (ModelState.IsValid)
            {
                review.Body = Sanitizer.GetSafeHtmlFragment(review.Body);
                _db.Attach(review);
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
            review.InitRestaurant();
            return View(review);
        }
        public ActionResult Edit333(int id, Review review)
        {
            /*
            if (ModelState.IsValid)
            {
                var item = _db.Reviews.FindById(id);
                item.Body = Sanitizer.GetSafeHtmlFragment(review.Body);
                item.Rating = review.Rating;
                item.DiningDate = review.DiningDate;
                _db.Entry(item).State = EntityState.Modified;
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
            var restaurant = _db.Restaurants.FindById(review.RestaurantID);
            review.Restaurant = restaurant;
            return View(review);
            */

            /*
            var review = _db.Reviews.FindById(id);
            if (TryUpdateModel(review))
            {
                _db.SaveChanges();
                return RedirectToAction("Index");
            }
             *
            return View(review);
            */
            /*
            try
            {
                var review = _db.Reviews.FindById(id);
                TryUpdateModel(review);

                return RedirectToAction("Index");
            }
            catch
            {
                return View();
            }
            */
            return View(review);
        }