Exemplo n.º 1
0
 public void AddEmailSignup(EmailSignup ns)
 {
     using (SqlConnection connection = new SqlConnection(_connectionString))
         using (SqlCommand cmd = connection.CreateCommand())
         {
             cmd.CommandText =
                 "INSERT INTO EmailSignups " +
                 "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();
         }
 }
Exemplo n.º 2
0
 public IEnumerable <EmailSignup> GetEmailSignups()
 {
     using (SqlConnection connection = new SqlConnection(_connectionString))
         using (SqlCommand cmd = connection.CreateCommand())
         {
             List <EmailSignup> result = new List <EmailSignup>();
             cmd.CommandText = "SELECT * FROM EmailSignups";
             connection.Open();
             var reader = cmd.ExecuteReader();
             while (reader.Read())
             {
                 EmailSignup es = new EmailSignup
                 {
                     Id        = (int)reader["Id"],
                     Email     = (string)reader["Email"],
                     FirstName = (string)reader["FirstName"],
                     LastName  = (string)reader["LastName"]
                 };
                 result.Add(es);
             }
             return(result);
         }
 }