public void HandleRequest() { var db = new BoardSquaresRepository(); var messages = db.AttemptGetEmails(Convert.ToInt32(SelectedRound)); if (!messages.Any()) { ErrorMessage = "Emails already sent for selcted week"; IsValid = false; return; } foreach (var message in messages) { var mailClient = new SmtpClient { Host = "relay-hosting.secureserver.net" }; var mailMessage = new MailMessage { From = new MailAddress("*****@*****.**"), Subject = message.Subject, Body = message.Body, IsBodyHtml = true }; mailMessage.To.Add(new MailAddress(message.Email)); mailClient.Send(mailMessage); mailClient.Dispose(); } db.AttemptMarkEmailsSent(messages.FirstOrDefault().BatchID); SuccessMessage = messages.Count + " Messages Sent!"; }