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 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));
}
protected override async Task Handle(NewsLetterSignUpUserCommand command)
{
var newsLetterSign = new NewsLetterSignUp
{
Email = command.Email,
CreatedUtc = DateTime.UtcNow,
CreatedBy = command.ModifiedBy,
IsEnabled = command.IsEnabled
};
_newsLetterSignUpRepository.Save(newsLetterSign);
return;
}
public void Delete(NewsLetterSignUp newsLetterSignUp)
{
_newsLetterSignUpRepository.Delete(newsLetterSignUp);
}
public NewsLetterSignUp Save([FromBody] NewsLetterSignUp newsLetterSignUp)
{
return(_newsLetterSignUpRepository.Save(newsLetterSignUp));
}
