public ActionResult Admin()
{
string queryString = @"SELECT * 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 signupsVM = new List <SignupVM>();
foreach (var signup in signups)
{
var signupVm = new SignupVM();
signupVm.FirstName = signup.FirstName;
signupVm.LastName = signup.LastName;
signupVm.EmailAddress = signup.EmailAddress;
signupsVM.Add(signupVm);
}
return(View(signupsVM));
}
public override global::System.Data.DataSet Clone()
{
NewsletterSignUp cln = ((NewsletterSignUp)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public async Task <IActionResult> Signup([FromBody] NewsletterSignUp signup)
{
if (signup == null || !signup.IsValid())
{
return(BadRequest());
}
await _svc.Signup(signup);
return(Ok());
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
NewsletterSignUp ds = new NewsletterSignUp();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
// 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);
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);
}
connection.Close();
}
}
public ActionResult Admin()
{
string queryString = @"SELECT Id, FirstName, LastName, EmailAddress, Removed 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.Removed = reader["Removed"].ToString(); // wwe don't want to return this
signups.Add(signup);
}
}
var signupVms = new List <SignupVm>(); // best practice if its obvious what the data type is
//List<SignupVm> 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));
}
public ActionResult Admin()
{
string querystring = @"SELECT Id, FirstName, LastName, EmailAddress, SocialSecurityNumber from SignUps"; //select porperties from the signup tables.
List <NewsletterSignUp> signups = new List <NewsletterSignUp>(); //iniitalize as an empty list
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"]); // assigning the properties/ values coming from the database.
signup.FirstName = reader["FirstName"].ToString(); //objects coming from the database are a different datatype and need to be defined
signup.LastName = reader["LastName"].ToString();
signup.EmailAddress = reader["EmailAddress"].ToString();
signup.SocialSecurityNumber = reader["SocialSecurityNumber"].ToString();
signups.Add(signup); // add this newsletter signup list
}
}
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)); //passes this list to the view
}
public async Task Signup(NewsletterSignUp signup)
{
await PostAsync("signup", signup, "/api/v1/signup");
}
