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