private static void SendFReminders() { delSend ds = Commagent.SendEmailFromCommAgent; ds += Commagent.LogOutgoingEmail; BallyliffinDataContext db = new BallyliffinDataContext(); List<sp_Email_MatchRemindersResult> reminders = db.sp_Email_MatchReminders().ToList(); string body; foreach (sp_Email_MatchRemindersResult r in reminders) { body = string.Format("Dear {5} {6} \r\n\r\n You have a match on {0:d} at {1:t} \r\n {2} v {3} \r\n at {4}" , r.MatchDate, r.MatchDate, r.TeamA, r.TeamB, r.VenueDesc, r.FirstName, r.LastName); ds("Match Reminder", body, r.EmailAddress, "*****@*****.**"); } }
private void ShowMessage() { BallyliffinDataContext db = new BallyliffinDataContext(); divInfo.InnerText = db.sp_Email_MatchReminders().Count().ToString() + " Email Reminders have been sent to members!"; }