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"); }