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