public IEnumerable <_514_List> GetList()
{
using (var dataContext = new ReminderDataContext())
{
return(dataContext._514_Lists.Where(x => true).ToList());
}
}
public _514_List GetListById(int id)
{
using (var dataContext = new ReminderDataContext())
{
return(dataContext._514_Lists.Single(x => x.Id == id));
}
}
public IEnumerable <_514_Reminder> GetReminders()
{
using (var dataContext = new ReminderDataContext())
{
return(dataContext._514_Reminders.Where(x => x.IsActive == true).OrderBy(x => x.Date).ToList());
}
}
public void Insert(_514_Reminder reminder)
{
using (var dataContext = new ReminderDataContext())
{
dataContext._514_Reminders.InsertOnSubmit(reminder);
dataContext.SubmitChanges();
}
}
public void DeleteReminderById(int id)
{
using (var dataContext = new ReminderDataContext())
{
var reminder = dataContext._514_Reminders.Single(x => x.Id == id);
dataContext._514_Reminders.DeleteOnSubmit(reminder);
dataContext.SubmitChanges();
}
}
public bool SetReminderIsActive(int id, bool complete)
{
using (var dataContext = new ReminderDataContext())
{
var data = dataContext._514_Reminders.Single(x => x.Id == id);
data.IsActive = complete;
dataContext.SubmitChanges();
return(true);
}
}
public _514_Reminder GetReminderById(int id)
{
using (var dataContext = new ReminderDataContext())
{
var options = new DataLoadOptions();
options.LoadWith <_514_Reminder>(x => x._514_List);
dataContext.LoadOptions = options;
return(dataContext._514_Reminders.SingleOrDefault(x => x.Id == id));
}
}
public IEnumerable <_514_Reminder> GetRemindersByListId(int id)
{
using (var dataContext = new ReminderDataContext())
{
var options = new DataLoadOptions();
options.LoadWith <_514_Reminder>(x => x._514_List);
dataContext.LoadOptions = options;
return(dataContext._514_Reminders.Where(x => x.ListId == id)
.OrderBy(x => x.IsActive == true)
.ThenBy(x => x.Date)
.ToList());
}
}
public void Update(_514_Reminder reminder)
{
using (var dataContext = new ReminderDataContext())
{
var data = dataContext._514_Reminders.Single(x => x.Id == reminder.Id);
data.IsActive = reminder.IsActive;
data.Date = reminder.Date;
data.Title = reminder.Title;
data.ListId = reminder.ListId;
data.Notes = reminder.Notes;
data.Priority = reminder.Priority;
dataContext.SubmitChanges();
}
}
