public ActionResult Unsubscribe(int ID)
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
var signup = db.SignUps.Find(ID);
signup.Removed = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult SignUp(string firstName, string lastName, string emailAddress)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
var signup = new SignUp();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
db.SignUps.Add(signup);
db.SaveChanges();
}
return(View("Success"));
//string queryString = @"INSERT INTO SignUps (FirstName, LastName, EmailAddress) VALUES
// (@FirstName, @LastName, @EmailAddress)";
//using (SqlConnection connection = new SqlConnection(connectionString))
//{
// SqlCommand command = new SqlCommand(queryString, connection);
// command.Parameters.Add("@FirstName", SqlDbType.VarChar);
// command.Parameters.Add("@LastName", SqlDbType.VarChar);
// command.Parameters.Add("@EmailAddress", SqlDbType.VarChar);
// command.Parameters["@FirstName"].Value = firstName;
// command.Parameters["@LastName"].Value = lastName;
// command.Parameters["@EmailAddress"].Value = emailAddress;
// connection.Open();
// command.ExecuteNonQuery();
// connection.Close();
//}
}
}
public ActionResult SignUp(string firstName, string lastName, string emailAddress)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress))
{
return(View("~/Views/Shared/Error.cshtml"));
}
else
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
var signup = new SignUp();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
db.SignUps.Add(signup);
db.SaveChanges();
}
return(View("Success"));
}
}
