public ActionResult Edit(Comment comment)
 {
     if (ModelState.IsValid)
     {
         db.Entry(comment).State = EntityState.Modified;
         db.SaveChanges();
         return RedirectToAction("Index");
     }
     ViewBag.EventID = new SelectList(db.Events, "EventID", "Title", comment.EventID);
     ViewBag.UserID = new SelectList(db.Users, "UserID", "LastName", comment.UserID);
     return View(comment);
 }
        public ActionResult Create(Comment comment)
        {
            if (ModelState.IsValid)
            {
                db.Comments.Add(comment);
                db.SaveChanges();
                return RedirectToAction("Index");  
            }

            ViewBag.EventID = new SelectList(db.Events, "EventID", "Title", comment.EventID);
            ViewBag.UserID = new SelectList(db.Users, "UserID", "LastName", comment.UserID);
            return View(comment);
        }