public IEnumerable<NotificationSignup> GetNotificationSignups()
{
var result = new List<NotificationSignup>();
InitiateDbAction(cmd =>
{
cmd.CommandText = "SELECT * FORM NotificationSignups";
var reader = cmd.ExecuteReader();
while (reader.Read())
{
NotificationSignup ns = new NotificationSignup
{
Id = (int)reader["Id"],
Email = (string)reader["Email"],
FirstName = (string)reader["FirstName"],
LastName = (string)reader["LastName"]
};
result.Add(ns);
}
});
return result;
}
public void AddNotificationSignup(NotificationSignup ns)
{
InitiateDbAction(cmd =>
{
cmd.CommandText =
"INSERT INTO NotificationSignups (Email, FirstName, LastName) VALUES (@email, @firstName, @lastName)";
cmd.Parameters.AddWithValue("@email", ns.Email);
cmd.Parameters.AddWithValue("@firstName", ns.FirstName);
cmd.Parameters.AddWithValue("@lastName", ns.LastName);
cmd.ExecuteNonQuery();
});
}
public ActionResult NotificationSignup(string firstName, string lastName, string email)
{
var db = new HockeySignupDb(_connectionString);
NotificationSignup signup = new NotificationSignup
{
FirstName = firstName,
LastName = lastName,
Email = email
};
db.AddNotificationSignup(signup);
return View("NotificationConfirmation");
}
