public static void SendNotifications(string dummy) { string emailaddress, subject, mytemplate = ""; Console.Write("Waypoint 1"); GarageSaleDataContext db = new GarageSaleDataContext(); var linqMailTemplates = db.sp_getTemplate(1); foreach (var linqMailTemplate in linqMailTemplates) { mytemplate = linqMailTemplate.TemplateText; } int itemid = 0; string conversation = ""; var linqMembers = db.sp_whatMailToSent(); foreach (var linqMember in linqMembers) { var sendtemplate = mytemplate; emailaddress = linqMember.EmailAddress; subject = linqMember.ItemName; if (linqMember.ItemID != itemid) { conversation = ""; var linqMessages = db.sp_EmailDetails(linqMember.ItemID); foreach (var linqMessage in linqMessages) { if (linqMessage.Seller == 1) { conversation += "<b>Seller</b>" + linqMessage.DateInserted + "<br />"; } else { conversation += "<b>Buyer</b>" + linqMessage.DateInserted + "<br />"; } conversation += linqMessage.MessageText; conversation += "<br /><br />"; } itemid = Convert.ToInt32(linqMember.ItemID); } sendtemplate = sendtemplate.Replace("#Conversation", conversation); sendtemplate = sendtemplate.Replace("#ItemName", linqMember.ItemName); var linqUpdateEmailTrack = db.sp_UpdateEmailTrack(itemid, emailaddress); SendMail(emailaddress, subject, sendtemplate); } }