// GET: Admin
public ActionResult Index()
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
//var signups = (from c in db.SignUps
// where c.Removed == null
// select c).ToList();
var signups = db.SignUps.Where(x => x.Removed == null).ToList();
var 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));
}
//string queryString = @"SELECT Id, FirstName, LastName, EmailAddress, SocialSecurityNumber from SignUps";
//List<NewsletterSignup> signups = new List<NewsletterSignup>();
//using (SqlConnection connection = new SqlConnection(connectionString))
//{
// SqlCommand command = new SqlCommand(queryString, connection);
// connection.Open();
// SqlDataReader reader = command.ExecuteReader();
// while (reader.Read())
// {
// var signup = new NewsletterSignup();
// signup.Id = Convert.ToInt32(reader["id"]);
// signup.FirstName = reader["FirstName"].ToString();
// signup.LastName = reader["LastName"].ToString();
// signup.EmailAddress = reader["EmailAddress"].ToString();
// signup.SocialSecurityNumber = reader["SocialSecurityNumber"].ToString();
// signups.Add(signup);
// }
//}
//var signupVms = new List<SignupVm>();
//foreach (var signup in signups)
//{
// var signupVm = new SignupVm();
// signupVm.FirstName = signup.FirstName;
// signupVm.LastName = signup.LastName;
// signupVm.EmailAddress = signup.EmailAddress;
// signupVms.Add(signupVm);
//}
//return View(signupVms);
}
// GET: Admin
public ActionResult Index()
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
/////OPTION 1: Using lambda to filter unsubscribes out
//var signups = db.SignUps.Where(x => x.Removed == null).ToList();
///OPTION 2: Using Linq to filter results
var signups = (from c in db.SignUps
where c.Removed == null
select c).ToList();
var 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));
}
}
// GET: Admin
public ActionResult Index()
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
//Lambda syntax
//var signups = db.SignUps.Where(x => x.Removed == null).ToList();
//Linq syntax
var signups = (from c in db.SignUps
where c.Removed == null
select c).ToList();
var 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 Unsubscribe(int ID)
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
var signup = db.SignUps.Find(ID);
signup.Removed = DateTime.Now;
db.SaveChanges();
}
return(RedirectToAction("Index"));
}
// GET: Admin
public ActionResult Index()
{
using (NewsletterEntities1 db = new NewsletterEntities1())
{
/*var signups = db.SignUps.Where(x=> x.Removed==null).ToList()*/; //representes all of the records in our database (a list) filtered by subscribed
var signups = (from c in db.SignUps where c.Removed == null select c).ToList(); //same function as before but using Linq
var 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 (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"));
}
}