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 CreateEvent(DateTime date, int maxPeople) { var db = new HockeySignupsDb(_connectionString); Event e = new Event {Date = date, MaxPeople = maxPeople}; db.AddEvent(e); TempData["Message"] = "Event Successfully created, Id: " + e.Id; return RedirectToAction("Index", "Hockey"); }
public ActionResult LatestEvent() { var db = new HockeySignupsDb(_connectionString); Event latestEvent = db.GetLatestEvent(); EventSignupViewModel vm = new EventSignupViewModel(); vm.Event = latestEvent; vm.EventStatus = db.GetEventStatus(latestEvent); return View(vm); }
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); }
static void Main(string[] args) { HockeySignupsDb db = new HockeySignupsDb(Settings1.Default.ConStr); //var e = new Event {Date = DateTime.Today.AddDays(3), MaxPeople = 20}; //db.AddEvent(e); //Console.WriteLine(e.Id); db.GetEvents().ToList().ForEach(e => { Console.WriteLine(e.Date + " " + e.MaxPeople + " " + e.Id); }); Console.ReadKey(true); }
public ActionResult NotificationSignup(string firstName, string lastName, string email) { var db = new HockeySignupsDb(_connectionString); var ns = new NotificationSignup { Email = email, FirstName = firstName, LastName = lastName }; db.AddNotificationSignup(ns); return View("NotificationSignupConfirmation"); }
public ActionResult History() { var db = new HockeySignupsDb(_connectionString); IEnumerable<EventWithPeople> events = db.GetEventsWithCount(); return View(events); }