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