public static List <UserAccount> GetUserAccounts()
{
List <UserAccount> userAccounts;
using (FantasticHQEntities context = new FantasticHQEntities())
{
var query = from user in context.UserAccounts
select user;
userAccounts = query.Distinct().ToList();
}
return(userAccounts);
}
public static List <Reminder> GetTodayReminders()
{
List <Reminder> reminders = new List <Reminder>();
using (FantasticHQEntities context = new FantasticHQEntities())
{
string dayOfWeek = DateTime.Now.ToString("ddd").ToUpper();
var query = from reminder in context.Reminders
where (reminder.StartDate == null || reminder.EndDate == null || (reminder.StartDate <= DateTime.Now && reminder.EndDate >= DateTime.Now)) &&
reminder.DayOfTheWeek.Contains(dayOfWeek)
select reminder;
reminders = query.Distinct().ToList();
}
return(reminders);
}
