public ActionResult DeleteConfirmed(int id)
        {
            MSComments mSComments = db.comments.Find(id);

            db.comments.Remove(mSComments);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
 public ActionResult Edit([Bind(Include = "MSCommentsId,Title,Description,DateAdded,MovieStarId,UserId")] MSComments mSComments)
 {
     if (ModelState.IsValid)
     {
         db.Entry(mSComments).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     ViewBag.MovieStarId = new SelectList(db.MovieStar, "MovieStarId", "Name", mSComments.MovieStarId);
     ViewBag.UserId      = new SelectList(db.user, "UserId", "UserName", mSComments.UserId);
     return(View(mSComments));
 }
        public ActionResult Create([Bind(Include = "MSCommentsId,Title,Description,DateAdded,MovieStarId,UserId")] MSComments mSComments)
        {
            if (ModelState.IsValid)
            {
                db.comments.Add(mSComments);
                db.SaveChanges();
                return(RedirectToAction("", new { MovieStarId = mSComments.MovieStarId }));
            }

            ViewBag.MovieStarId = new SelectList(db.MovieStar, "MovieStarId", "Name", mSComments.MovieStarId);
            ViewBag.UserId      = new SelectList(db.user, "UserId", "UserName", mSComments.UserId);
            return(View(mSComments));
        }
        // GET: MSComments
        //public ActionResult Index()
        //{
        //    var comments = db.comments.Include(m => m.MovieStar).Include(m => m.User);
        //    return View(comments.ToList());
        //}

        // GET: MSComments/Details/5
        public ActionResult Details(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            MSComments mSComments = db.comments.Find(id);

            if (mSComments == null)
            {
                return(HttpNotFound());
            }
            return(View(mSComments));
        }
        // GET: MSComments/Edit/5
        public ActionResult Edit(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            MSComments mSComments = db.comments.Find(id);

            if (mSComments == null)
            {
                return(HttpNotFound());
            }
            ViewBag.MovieStarId = new SelectList(db.MovieStar, "MovieStarId", "Name", mSComments.MovieStarId);
            ViewBag.UserId      = new SelectList(db.user, "UserId", "UserName", mSComments.UserId);
            return(View(mSComments));
        }