// GET: Admin
public ActionResult Index()
{
var signupVMs = new List <SignUpVM>();
// Generate a list of all signups
using (var db = new NewsletterDBEntities()) {
// Alt filter method (using "Link"(?)):
//var signups = (from s in db.SignUps
// where s.Removed == null
// select s).ToList();
foreach (var signup in db.SignUps.Where(x => x.Removed == null).ToList())
{
var signupVM = new SignUpVM();
signupVM.Id = signup.Id;
signupVM.FirstName = signup.FirstName;
signupVM.LastName = signup.LastName;
signupVM.EmailAddress = signup.EmailAddress;
signupVMs.Add(signupVM);
}
}
// Submit them with the view
return(View(signupVMs));
}
public ActionResult Unsubscribe(int Id)
{
using (NewsletterDBEntities db = new NewsletterDBEntities())
{
var signup = db.SignUps.Find(Id);
signup.Removed = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult SignUp(string firstName, string lastName, string emailAddress, string creditCardNumber)
{
if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress))
{
return(View("~/Views/Shared/Error.cshtml"));
}
// Command we want to send
//string queryString = @"insert into SignUps(FirstName, LastName, EmailAddress) values " +
// "(@FirstName, @LastName, @EmailAddress)";
//// Wrap memory-use contents in using statement
//using (var connection = new SqlConnection(connectionString)) {
// // Build SqlCommand interfacer to help stave off nasty SQL injection attacks (I assume it sanitizes things for us)
// var command = new SqlCommand(queryString, connection);
// // Add parameters to list (like declaring)
// command.Parameters.Add("@FirstName", SqlDbType.VarChar);
// command.Parameters.Add("@LastName", SqlDbType.VarChar);
// command.Parameters.Add("@EmailAddress", SqlDbType.VarChar);
// // Add values to parameters (like initializing)
// command.Parameters["@FirstName"].Value = firstName;
// command.Parameters["@LastName"].Value = lastName;
// command.Parameters["@EmailAddress"].Value = emailAddress;
// // Open, post, and close
// connection.Open();
// command.ExecuteNonQuery();
// connection.Close();
//}
// Use entity framework instead
using (var db = new NewsletterDBEntities()) {
var signup = new SignUp();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
signup.CreditCardNumber = creditCardNumber; // I don't know if this is even doing anything anymore.
// EF does not have this as a property because I deleted it once,
// and I cannot get it to accept it as a thing again, so... ?
// The app works, though.
db.SignUps.Add(signup);
db.SaveChanges();
}
return(View("Success"));
}
// GET: Admin
public ActionResult Index()
{
using (NewsletterDBEntities db = new NewsletterDBEntities())
{
//var signUps = db.SignUps.Where(x => x.Removed == null).ToList();
var signUps = (from c in db.SignUps where c.Removed == null select c).ToList();
List <SignupVm> signupVms = new List <SignupVm>();
foreach (var signup in signUps)
{
var signupVm = new SignupVm();
signupVm.Id = signup.Id;
signupVm.FirstName = signup.FirstName;
signupVm.LastName = signup.LastName;
signupVm.EmailAddress = signup.EmailAddress;
signupVms.Add(signupVm);
}
return(View(signupVms));
}
}
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 (NewsletterDBEntities db = new NewsletterDBEntities())
{
var signup = new SignUp();
signup.FirstName = firstName;
signup.LastName = lastName;
signup.EmailAddress = emailAddress;
db.SignUps.Add(signup);
db.SaveChanges();
}
//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", System.Data.SqlDbType.VarChar);
// command.Parameters.Add("@LastName", System.Data.SqlDbType.VarChar);
// command.Parameters.Add("@EmailAddress", System.Data.SqlDbType.VarChar);
// command.Parameters["@FirstName"].Value = firstName;
// command.Parameters["@LastName"].Value = lastName;
// command.Parameters["@EmailAddress"].Value = emailAddress;
// connection.Open();
// command.ExecuteNonQuery();
// connection.Close();
//}
return(View("Success"));
}
}
