public ActionResult EventSignup(string firstName, string lastName, string email, int eventId)
        {
            var db = new HockeySignupsDb(_connectionString);
            var e = db.GetEventById(eventId);
            var status = db.GetEventStatus(e);
            if (status == EventStatus.InThePast)
            {
                TempData["Error"] = "You cannot sign up to a game in the past. Jerk.";
                return RedirectToAction("Index");
            }
            else if (status == EventStatus.Full)
            {
                TempData["Error"] = "Nice try sucker....";
                return RedirectToAction("Index");
            }
            EventSignup s = new EventSignup
            {
                Email = email,
                FirstName = firstName,
                LastName = lastName,
                EventId = eventId
            };
            db.AddEventSignup(s);

            TempData["Message"] =
                "You have succesfully signed up for this weeks game, looking forward to checking you into the boards!";
            return RedirectToAction("Index");
        }
 public ActionResult EventDetails(int id)
 {
     var db = new HockeySignupsDb(_connectionString);
     Event e = db.GetEventById(id);
     IEnumerable<EventSignup> signups = db.GetEventSignups(id);
     var vm = new EventDetailsViewModel
     {
         Event = e,
         Signups = signups
     };
     return View(vm);
 }