public ActionResult History()
{
var db = new HockeySignupsDb(_connectionString);
IEnumerable <EventWithPeople> events = db.GetEventsWithCount();
return(View(events));
}
public ActionResult History()
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
IEnumerable <EventWithPeople> events = db.GetEventsWithCount();
return(View(events));
}
public ActionResult History()
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
IEnumerable <Event> events = db.GetEvents();
//longer approach
HistoryViewModel vm = new HistoryViewModel();
//List<EventWithCount> eventsWithCounts = new List<EventWithCount>();
//foreach (Event e in events)
//{
// EventWithCount eventWithCount = new EventWithCount();
// eventWithCount.Event = e;
// eventWithCount.SignupCount = db.GetSignupCountForEvent(e.Id);
// eventsWithCounts.Add(eventWithCount);
//}
//vm.Events = eventsWithCounts;
//shorter approach
vm.Events = events.Select(e => new EventWithCount
{
Event = e,
SignupCount = db.GetSignupCountForEvent(e.Id)
});
return(View(vm));
}
public ActionResult CreateEvent(DateTime date, int maxPeople)
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
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 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 EventDetails(int id)
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
Event e = db.GetEventById(id);
IEnumerable <EventSignup> signups = db.GetEventSignups(id);
var vm = new EventDetailsViewModel
{
Event = e,
Signups = signups
};
return(View(vm));
}
public ActionResult NotificationSignup(string firstName, string lastName, string email)
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
var ns = new NotificationSignup
{
Email = email,
FirstName = firstName,
LastName = lastName
};
db.AddNotificationSignup(ns);
return(View("NotificationSignupConfirmation"));
}
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 CreateEvent(Event e)
{
HockeySignupsDb db = new HockeySignupsDb(_connectionString);
db.AddEvent(e);
#region TempData
TempData["Message"] = "Event Successfully created, Id: " + e.Id;
#endregion
IEnumerable <NotificationSignup> signups = db.GetNotificationSignups();
foreach (NotificationSignup signup in signups)
{
//send email using signup.Email
}
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);
vm.Signup = new EventSignup();
if (Request.Cookies["firstName"] != null)
{
vm.Signup.FirstName = Request.Cookies["firstName"].Value;
vm.Signup.LastName = Request.Cookies["lastName"].Value;
vm.Signup.Email = Request.Cookies["email"].Value;
}
return(View(vm));
}
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;
IEnumerable <NotificationSignup> signups = db.GetNotificationSignups();
foreach (NotificationSignup signup in signups)
{
//send email using signup.Email
}
return(RedirectToAction("Index", "Hockey"));
}
public ActionResult CreateEvent(DateTime date, int maxPeople)
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
Event e = new Event {
Date = date, MaxPeople = maxPeople
};
db.AddEvent(e);
TempData["Message"] = "Event Successfully created, Id: " + e.Id;
IEnumerable <NotificationSignup> signups = db.GetNotificationSignups();
foreach (NotificationSignup signup in signups)
{
SendNotificationEmail(signup);
}
return(RedirectToAction("Index", "Hockey"));
}
public ActionResult EventSignup(string firstName, string lastName, string email, int eventId)
{
HockeySignupsDb db = new HockeySignupsDb(_connectionString);
Event e = db.GetEventById(eventId);
EventStatus status = db.GetEventStatus(e);
if (status == EventStatus.InThePast)
{
#region TempData
TempData["Error"] = "You cannot sign up to a game in the past. Jerk.";
#endregion
return(RedirectToAction("Index"));
}
if (status == EventStatus.Full)
{
#region TempData
TempData["Error"] = "Nice try sucker....";
#endregion
return(RedirectToAction("Index"));
}
EventSignup s = new EventSignup
{
Email = email,
FirstName = firstName,
LastName = lastName,
EventId = eventId
};
HttpCookie firstNameCookie = new HttpCookie("firstName", s.FirstName);
HttpCookie lastNameCookie = new HttpCookie("lastName", s.LastName);
HttpCookie emailCookie = new HttpCookie("email", s.Email);
Response.Cookies.Add(firstNameCookie);
Response.Cookies.Add(lastNameCookie);
Response.Cookies.Add(emailCookie);
db.AddEventSignup(s);
#region TempData
TempData["Message"] =
"You have succesfully signed up for this weeks game, looking forward to checking you into the boards!";
#endregion
return(RedirectToAction("Index"));
}
public ActionResult EventSignup(string firstName, string lastName, string email, int eventId)
{
var db = new HockeySignupsDb(Properties.Settings.Default.ConStr);
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!!";
return(RedirectToAction("Index"));
}
if (status == EventStatus.Full)
{
TempData["Error"] = "Nice try!";
return(RedirectToAction("Index"));
}
EventSignup s = new EventSignup
{
Email = email,
FirstName = firstName,
LastName = lastName,
EventId = eventId
};
HttpCookie firstNameCookie = new HttpCookie("firstName", s.FirstName);
HttpCookie lastNameCookie = new HttpCookie("lastName", s.LastName);
HttpCookie emailCookie = new HttpCookie("email", s.Email);
Response.Cookies.Add(firstNameCookie);
Response.Cookies.Add(lastNameCookie);
Response.Cookies.Add(emailCookie);
db.AddEventSignup(s);
TempData["Message"] =
"You have successfully signed up for this weeks game, looking forward to checking you into the boards!";
return(RedirectToAction("Index"));
}
