public ToDo GetToDo(int?id, string userName)
{
int searchableID = 0;
if (id != null)
{
searchableID = (int)id;
}
ToDo toDo = ToDoDBContextFactory.Create().ToDos.
Include(allToDo => allToDo.ToDoFiles).
Where(toDoThatMatches => toDoThatMatches.ID == searchableID &&
toDoThatMatches.UserName == userName).FirstOrDefault();
if (toDo == null)
{
throw new Exception("User is not allowed to view this to do.");
}
if (toDo.ToDoFiles == null)
{
toDo.ToDoFiles = new List <ToDoFile>();
}
return(toDo);
}
public void InsertFile(HttpPostedFileBase postedFile, int toDoID, string userName)
{
ToDo toDoToUpdate = new ToDoSelector().GetToDo(toDoID, userName);
toDoToUpdate.ToDoFiles.Add(new ToDoFileSelector().GetToDoFile(postedFile, toDoID));
ToDoDBContextFactory.Create().SaveChanges();
}
public IOrderedQueryable <ToDo> GetSortedToDosByLoggedInUserName(string userName)
{
return(ToDoDBContextFactory.Create().ToDos.
Where(toDo => toDo.UserName == userName).
OrderBy(toDo => toDo.WhenItWasDone).
ThenByDescending(toDo => toDo.OrderID));
}
public void DeleteToDo(int id)
{
ToDo toDoToBeDeleted = ToDoDBContextFactory.Create().
ToDos.Where(toDo => toDo.ID == id).FirstOrDefault();
ToDoDBContextFactory.Create().ToDos.Remove(toDoToBeDeleted);
ToDoDBContextFactory.Create().SaveChanges();
}
public void DeleteToDoFile(int toDoFileID, int toDoID, string userName)
{
ToDo toDoThatIsSaved = new ToDoSelector().GetToDo(toDoID, userName);
ToDoFile toDoFileToBeRemoved = new ToDoFileSelector().GetToDoFile(toDoThatIsSaved, toDoFileID);
toDoThatIsSaved.ToDoFiles.Remove(toDoFileToBeRemoved);
ToDoDBContextFactory.Create().ToDoFiles.Remove(toDoFileToBeRemoved);
ToDoDBContextFactory.Create().SaveChanges();
}
public ToDo GetNextToDoThatIsLowerInPriority(int toDoOrderID, string userName)
{
ToDo nextToDoThatIsLowerInPriority = ToDoDBContextFactory.Create().
ToDos.OrderBy(toDo => toDo.OrderID).Where(toDo => toDo.OrderID > toDoOrderID &&
toDo.UserName == userName &&
toDo.WhenItWasDone == null).FirstOrDefault();
return(nextToDoThatIsLowerInPriority == null ? new ToDo() : nextToDoThatIsLowerInPriority);
}
public IQueryable <ToDo> GetToDosThatIsLikeWhatToDo(string whatToDoContainsThis, string userName)
{
var toDosFound = ToDoDBContextFactory.Create().
ToDos.Where(toDo => toDo.WhatToDo.ToLower().
Contains(whatToDoContainsThis.ToLower()) && toDo.UserName == userName
);
return(toDosFound);
}
private void SetFakeToDoDBContext()
{
fakeToDoDBContext.ToDos.Add(new ToDo {
ID = 1, WhatToDo = "Buy Groceries"
});
fakeToDoDBContext.ToDos.Add(new ToDo {
ID = 2, WhatToDo = "Cook Rice"
});
ToDoDBContextFactory.SetToDoDBContext(fakeToDoDBContext);
}
private void SetFakeToDoDBContext()
{
fakeToDoDBContext.ToDos.Add(new ToDo {
ID = 1, WhatToDo = "Buy Groceries", OrderID = 1
});
fakeToDoDBContext.ToDos.Add(new ToDo {
ID = 2, WhatToDo = "Cook Rice", OrderID = 2
});
fakeToDoDBContext.ToDos.Add(new ToDo {
ID = 3, WhatToDo = "Buy baby groot",
WhenItWasDone = new DateTime(2012, 10, 12), OrderID = 3
});
ToDoDBContextFactory.SetToDoDBContext(fakeToDoDBContext);
}
public void InsertFile(ToDo toDo, ToDoFile toDoFile)
{
toDo.ToDoFiles.Add(toDoFile);
ToDoDBContextFactory.Create().SaveChanges();
}
public void UpdateToDo(ToDo toDo)
{
ToDoDBContextFactory.Create().SetToDoEntryState(toDo);
toDo.ToDoFiles = ToDoDBContextFactory.Create().ToDoFiles.Where(toDoFile => toDoFile.ToDoID == toDo.ID).ToList();
ToDoDBContextFactory.Create().SaveChanges();
}
private void InsertToDoToDatabase(ToDo toDo)
{
ToDoDBContextFactory.Create().ToDos.Add(toDo);
ToDoDBContextFactory.Create().SaveChanges();
}
public ToDoFile GetToDoFile(int toDoFileID)
{
ToDoFile toDoFile = ToDoDBContextFactory.Create().ToDoFiles.Find(toDoFileID);
return(toDoFile);
}
private int GetMaxToDoOrderID(string userName)
{
List <ToDo> toDos = ToDoDBContextFactory.Create().ToDos.Where(toDo => toDo.UserName == userName).ToList();
return(toDos.Count() > 0 ? toDos.Max(td => td.OrderID) : 0);
}
public void ResetToDoDBContext()
{
ToDoDBContextFactory.SetToDoDBContext(new ToDoDBContext());
}
