public bool UpdateSportDiscussion(DiscussionEdit model)
        {
            using (var ctx = new ApplicationDbContext())
            {
                var entity =
                    ctx
                    .Discussions
                    .Single(e => e.DiscussionId == model.DiscussionId);

                entity.MediaType       = model.MediaType;
                entity.SportId         = model.SportId;
                entity.DiscussionTitle = model.DiscussionTitle;

                return(ctx.SaveChanges() == 1);
            }
        }
        // GET: Discussion/Edit/{id}
        public ActionResult EditSportDiscussion(Guid id)
        {
            var service = NewDiscussionService();

            var detail = service.GetDiscussionById(id);

            var model = new DiscussionEdit
            {
                DiscussionId    = detail.DiscussionId,
                FilmId          = detail.FilmId,
                TelevisionId    = detail.TelevisionId,
                SportId         = detail.SportId,
                MediaType       = detail.MediaType,
                DiscussionTitle = detail.DiscussionTitle,
            };

            ViewBag.Discussion = service.GetDiscussionTitle(id);
            ViewBag.SportId    = new SelectList(sportService.GetSports(), "SportId", "Matchup", detail.SportId);
            return(View(model));
        }
        public ActionResult EditSportDiscussion(Guid id, DiscussionEdit model)
        {
            if (!ModelState.IsValid)
            {
                return(View(model));
            }

            if (model.DiscussionId != id)
            {
                ModelState.AddModelError("", "Id Mismatch");
                return(View(model));
            }

            var service = NewDiscussionService();

            if (service.UpdateSportDiscussion(model))
            {
                TempData["ResultSaved"] = "The discussion was updated.";
                return(RedirectToAction("Index"));
            }

            ModelState.AddModelError("", "The discussion could not be updated.");
            return(View(model));
        }