static void Execute(int excursionID)//List<Member> memberList)
{
BlackjackDBEntities NE = new BlackjackDBEntities();
List <Member> memberList = NE.Members.Where(x => x.ExcursionID.Equals(excursionID)).ToList();
string SendGridAPIkey = WebConfigurationManager.AppSettings["SendGridKey"];
var client = new SendGridClient(SendGridAPIkey);
SendGridMessage msg = new SendGridMessage();
msg.SetFrom(new EmailAddress("*****@*****.**", "BlackJack Team"));
List <EmailAddress> recipients = new List <EmailAddress>();
foreach (var member in memberList)
{
EmailAddress email = new EmailAddress(member.Email, member.FirstName);
recipients.Add(email);
}
msg.AddTos(recipients);
msg.SetSubject("Testing the SendGrid API for BlackJack");
//custom link back to website
msg.AddContent(MimeType.Text, "Hello World plain text!");
msg.AddContent(MimeType.Html, "<p>Hello World!</p>");
client.SendEmailAsync(msg);
}
public ActionResult SearchCity(string SearchExcursion)
{
BlackjackDBEntities NE = new BlackjackDBEntities();
List <Excursion> ExcursionList = NE.Excursions.Where(x => x.ExcursionID.Equals(SearchExcursion.ToUpper())).ToList();
ViewBag.ExcursionList = ExcursionList;
return(View("Index"));
}
