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 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 void AddNotificationSignup(NotificationSignup ns) { using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand cmd = connection.CreateCommand()) { 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); connection.Open(); cmd.ExecuteNonQuery(); } }
public IEnumerable <NotificationSignup> GetNotificationSignups() { var result = new List <NotificationSignup>(); InitiateDbAction(cmd => { cmd.CommandText = "SELECT * FROM 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 IEnumerable <NotificationSignup> GetNotificationSignups() { using (SqlConnection connection = new SqlConnection(_connectionString)) using (SqlCommand cmd = connection.CreateCommand()) { List <NotificationSignup> result = new List <NotificationSignup>(); cmd.CommandText = "SELECT * FROM NotificationSignups"; connection.Open(); 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 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; }