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)); }