public void DoWork() { string body = string.Empty; //using (StreamReader reader = new StreamReader(@"C:\Users\NikhilChetty\documents\visual studio 2017\Projects\JazMax\JazMax.WebJob.LeadReminder\Basic.html")) //{ // body = reader.ReadToEnd(); //} DateTime TomorrowsDate = DateTime.Now.AddDays(+1).Date; using (JazMax.DataAccess.JazMaxDBProdContext db = new DataAccess.JazMaxDBProdContext()) { JazMax.Core.Leads.Logic.LeadHelper o = new Core.Leads.Logic.LeadHelper(); var LeadReminderList = (from t in db.LeadReminders join b in db.CoreUsers on t.CoreUserId equals b.CoreUserId where t.WebJobCompleted == false select new LeadReminderList { LeadId = t.LeadId, ReminderDate = t.ReminderDate, User = b.FirstName + " " + b.LastName, EmailAddress = b.EmailAddress, LeadReminderId = t.LeadReminderId } ).ToList(); List <LeadReminderMailList> List = new List <LeadReminderMailList>(); var DueTomorrow = LeadReminderList.Where(x => x.ReminderDate.Date >= TomorrowsDate && x.ReminderDate.Date <= TomorrowsDate).Select(x => new LeadReminderMailList { EmailAddress = x.EmailAddress, LeadCore = x.LeadCore, LeadId = x.LeadId, ReminderDate = x.ReminderDate, Type = ReminderType.Tomorrow, User = x.User, LeadReminderId = x.LeadReminderId }).ToList(); var DueToday = LeadReminderList.Where(x => x.ReminderDate.Date >= DateTime.Today.Date && x.ReminderDate.Date <= DateTime.Today.Date).Select(x => new LeadReminderMailList { EmailAddress = x.EmailAddress, LeadCore = x.LeadCore, LeadId = x.LeadId, ReminderDate = x.ReminderDate, Type = ReminderType.Today, User = x.User, LeadReminderId = x.LeadReminderId }).ToList(); List.AddRange(DueToday); List.AddRange(DueTomorrow); foreach (var send in List.Where(x => x.Type == ReminderType.Today).ToList()) { body = body.Replace("{ UserName}", send.User); body = body.Replace("{Title}", "Lead Reminder - Due Today: LeadID: " + send.LeadId); JazMax.BusinessLogic.Messenger.JazMaxMail.SendMail(new Web.ViewModel.Messenger.Email { IsAspUserId = false, IsBodyHtml = true, Message = "Lead Reminder due today for LeadID " + send.LeadId, SendTo = send.EmailAddress, Subject = "Lead Reminder Due Today" }); Update(send.LeadReminderId); } foreach (var send in List.Where(x => x.Type == ReminderType.Tomorrow).ToList()) { JazMax.BusinessLogic.Messenger.JazMaxMail.SendMail(new Web.ViewModel.Messenger.Email { IsAspUserId = false, IsBodyHtml = true, Message = "Lead Reminder due tomorrow for LeadID " + send.LeadId, SendTo = send.EmailAddress, Subject = "Lead Reminder Due Tomorrow", }); Update(send.LeadReminderId); } } }
static void Main(string[] args) { JazMax.Core.Leads.Logic.LeadHelper helper = new Core.Leads.Logic.LeadHelper(2); var a = helper.GetLead(); }