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