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")); //tilde(~) means -> relative path or root
}
else
{
// accessing database with Entity Framework "which is a wrapper for the ADO.NET Framework or ACTIVEX Data Object" both EF and ADO are libraries that deal with the exchanging and maneuvering of data.
using (NewsletterModelEntities db = new NewsletterModelEntities())
{
var signUp = new SignUp();
signUp.FirstName = firstName;
signUp.LastName = lastName;
signUp.EmailAddress = emailAddress;
db.SignUps.Add(signUp);
db.SaveChanges(); // nothing is saved until you write "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();
// }
// return View("Success");
// }
//}
}
}
// GET: Admin
public ActionResult Index()
{
using (NewsletterModelEntities db = new NewsletterModelEntities())
{
var signUps = db.SignUps; //this is info from the Context.cs file in the Entity Model Section(represents all the records in the database from the SignUps Table)
var signUpVMs = new List <SignUpVM>(); // made list called signUpVMs that is made up of items that are the type of SignUpVM
foreach (var signUp in signUps)
{
var signUpVM = new SignUpVM();
signUpVM.FirstName = signUp.FirstName; //this way you don't need (signUpVM.FirstName = signup.FirstName)
signUpVM.LastName = signUp.LastName; //you can shorten it to (FirstName = signup.FirstName), etc...
signUpVM.EmailAddress = signUp.EmailAddress;
signUpVMs.Add(signUpVM);
}
return(View(signUpVMs));
}
return(View());
}
