public ActionResult Unsubscribe(int Id) { using (NewsLetterEntities db = new NewsLetterEntities()) { var signup = db.SignUps.Find(Id); signup.Removed = DateTime.Now; db.SaveChanges(); } return RedirectToAction("Index"); }
// GET: Admin public ActionResult Index() { using (NewsLetterEntities db = new NewsLetterEntities()) { var signups = db.SignUps.Where(x => x.Removed == null).ToList(); var signupVms = new List <NewsLetterSignUpVm>(); foreach (var signup in signups) { var signupVm = new NewsLetterSignUpVm(); 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 (NewsLetterEntities db = new NewsLetterEntities()) { var signups = db.SignUps; 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 (NewsLetterEntities db = new NewsLetterEntities()) { 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", 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(); //} return(View("Success")); } }
// GET: Admin public ActionResult Index() { using (NewsLetterEntities db = new NewsLetterEntities()) { // var signups = db.SignUps.Where(x => x.Removed == null).ToList(); 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 SignUp(string firstName, string lastName, string emailAddress) { if (string.IsNullOrEmpty(firstName) || string.IsNullOrEmpty(lastName) || string.IsNullOrEmpty(emailAddress)) { return(View("~/Views/Shared/Errors.cshtml")); } else { using (NewsLetterEntities db = new NewsLetterEntities()) { var signup = new SignUp(); signup.FirstName = firstName; signup.LastName = lastName; signup.EmailAddress = emailAddress; db.SignUps.Add(signup); db.SaveChanges(); } return(View("Success")); } }