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