public void Delete()
{
using (var db = new WorkerBeeContext())
{
db.Remove(SelectedWorkItemsListBoxItem);
db.SaveChanges();
}
}
public void Read()
{
using (var db = new WorkerBeeContext())
{
var workItem = db.WorkItems
.OrderBy(wi => wi.Id)
.First();
}
}
public void Create()
{
using (var db = new WorkerBeeContext())
{
db.Add(new WorkItem {
Description = AddWorkItemTextBoxText, Date = SelectedWorkItemDate
});
db.SaveChanges();
}
}
public void MarkAsCompleted()
{
using (var db = new WorkerBeeContext())
{
var workItem = db.WorkItems
.Where(wi => wi.Id == SelectedWorkItemsListBoxItem.Id)
.First();
workItem.Completed = true;
db.SaveChanges();
}
}
public void Update()
{
using (var db = new WorkerBeeContext())
{
var workItem = db.WorkItems
.OrderBy(wi => wi.Id)
.First();
workItem.Description = "Update WorkerBee app";
db.SaveChanges();
}
}
public ObservableCollection <IWorkItem> ReadAll()
{
var workItems = new ObservableCollection <IWorkItem>();
using (var db = new WorkerBeeContext())
{
workItems = new ObservableCollection <IWorkItem>(db.WorkItems
.Where(wi => (IsIncludeCompletedCheckboxChecked || wi.Completed == IsIncludeCompletedCheckboxChecked) &&
wi.Date.Date == SelectedWorkItemDate.Date)
.OrderBy(wi => wi.Id));
}
return(workItems);
}
