public ActionResult Signup(string firstName, string lastName, string email, int eventId)
{
var db = new HockeySignupDb(_connectionString);
Event e = db.GetEventById(eventId);
var status = db.GetEventStatus(e);
if (status != EventStatus.Open)
{
return RedirectToAction("Index");
}
EventSignup es = new EventSignup
{
FirstName = firstName,
LastName = lastName,
Email = email,
EventId = eventId
};
db.AddEventSignup(es);
HttpCookie firstNameCookie = new HttpCookie("firstName", firstName);
HttpCookie lastNameCookie = new HttpCookie("lastName", lastName);
HttpCookie emailCookie = new HttpCookie("email", email);
Response.Cookies.Add(firstNameCookie);
Response.Cookies.Add(lastNameCookie);
Response.Cookies.Add(emailCookie);
TempData["Message"] = "Signup successfully recorded. Can't wait to check you into the boards!!";
return RedirectToAction("Index");
}
public IEnumerable<EventSignup> GetEventSignups(int eventId)
{
var result = new List<EventSignup>();
InitiateDbAction(cmd =>
{
cmd.CommandText = "SELECT * FROM EventSignups WHERE EventId = @eventId";
cmd.Parameters.AddWithValue("@eventId", eventId);
var reader = cmd.ExecuteReader();
while (reader.Read())
{
EventSignup es = new EventSignup
{
Id = (int)reader["Id"],
Email = (string)reader["Email"],
EventId = (int)reader["EventId"],
FirstName = (string)reader["FirstName"],
LastName = (string)reader["LastName"]
};
result.Add(es);
}
});
return result;
}
public void AddEventSignup(EventSignup es)
{
InitiateDbAction(cmd =>
{
cmd.CommandText =
"INSERT INTO EventSignups (Email, FirstName, LastName, EventId) VALUES (@email, @firstName, @lastName, @eventId)";
cmd.Parameters.AddWithValue("@email", es.Email);
cmd.Parameters.AddWithValue("@firstName", es.FirstName);
cmd.Parameters.AddWithValue("@lastName", es.LastName);
cmd.Parameters.AddWithValue("@eventId", es.EventId);
cmd.ExecuteNonQuery();
});
}