public IEnumerable <EmailData> GetReminderEmails() { using (var context = new SurveyDataContext()) { var found = context.EmailData.Where(x => !x.IsViewed && (x.SentDate != DateTime.MinValue) && (x.SentDate <= DateTime.Today.AddDays(3))).ToList(); return(found); } }
public IEnumerable <EmailData> GetEmailsToSend() { using (var context = new SurveyDataContext()) { var found = context.EmailData.Where(x => !x.IsViewed).ToList(); return(found); } }
public void SetSentDate(string email) { using (var context = new SurveyDataContext()) { var found = context.EmailData.Where(x => x.EmailAddress == email).FirstOrDefault(); if (found != null) { found.SentDate = DateTime.Today; context.SaveChanges(); } } }
public void SetStatus(string email) { using (var context = new SurveyDataContext()) { var found = context.EmailData.Where(x => x.EmailAddress == email).FirstOrDefault(); if (found != null) { found.IsViewed = true; context.SaveChanges(); } } }
public VendorAdminController(SurveyDataContext context) { _context = context; }
public SurveyController(SurveyDataContext context) { _context = context; }
public ResultsController(SurveyDataContext context) { _context = context; }
public UserHelper(SurveyDataContext Context) { context = Context; }
public UserAdminController(SurveyDataContext context) { _context = context; }