public List<ProjectViewModel> GetAll() { TodoListDbEntities db = new TodoListDbEntities(); IQueryable<Project> asQueryable = db.Projects.AsQueryable(); List<ProjectViewModel> list = asQueryable.Select(p => new ProjectViewModel() {Id = p.Id, Name = p.Name, Count = p.Count}).ToList(); return list; }
public int Save(Task task) { TodoListDbEntities db = new TodoListDbEntities(); Task dbTask; if (task.Id > 0) { dbTask = db.Tasks.Find(task.Id); if (dbTask != null) { dbTask.Name = task.Name; dbTask.DueDate = task.DueDate; dbTask.IsCompleted = task.IsCompleted; dbTask.Priority = task.Priority; dbTask.ProjectId = task.ProjectId; dbTask.Changed = DateTime.Now; } } else { task.Created = DateTime.Now; task.Changed = DateTime.Now; dbTask = db.Tasks.Add(task); } db.SaveChanges(); UpdateProjectCount(task.ProjectId, db); return dbTask.Id; }
public List<TaskViewModel> GetAllByProject(int projectId) { TodoListDbEntities db = new TodoListDbEntities(); IQueryable<Task> asQueryable = db.Tasks.Where(x=>x.ProjectId == projectId).AsQueryable(); List<TaskViewModel> list = asQueryable.Select(p => new TaskViewModel() { Id = p.Id, Name = p.Name,IsCompleted = p.IsCompleted,DueDate = p.DueDate}).ToList(); return list; }
public bool Delete(int id) { TodoListDbEntities db = new TodoListDbEntities(); Task task = db.Tasks.Find(id); if (task != null) { db.Tasks.Remove(task); db.SaveChanges(); } return true; }
public bool Delete(int id) { TodoListDbEntities db = new TodoListDbEntities(); Project project = db.Projects.Find(id); if (project !=null) { db.Projects.Remove(project); db.SaveChanges(); } return true; }
public Task GetById(int id) { TodoListDbEntities db = new TodoListDbEntities(); Task task = db.Tasks.Find(id); return new Task { ProjectId = task.ProjectId, Name = task.Name, Id = task.Id, DueDate = task.DueDate, IsCompleted = task.IsCompleted, Priority = task.Priority, }; }
public List<TaskViewModel> GetAll() { TodoListDbEntities db = new TodoListDbEntities(); IQueryable<Task> asQueryable = db.Tasks.AsQueryable(); List<TaskViewModel> list = asQueryable.Select(p => new TaskViewModel() { Id = p.Id, Name = p.Name, ProjectId = p.ProjectId, ProjectName = p.Project.Name, Priority = p.Priority, DueDate = p.DueDate, IsCompleted = p.IsCompleted }).ToList(); return list; }
public int Save(Project project) { TodoListDbEntities db = new TodoListDbEntities(); Project dbProject ; if (project.Id > 0) { dbProject = db.Projects.Find(project.Id); if (dbProject != null) { dbProject.Name = project.Name; dbProject.Changed = DateTime.Now; } } else { project.Created = DateTime.Now; project.Changed = DateTime.Now; dbProject = db.Projects.Add(project); } db.SaveChanges(); return dbProject.Id; }
public bool MarkComplete(Task task) { TodoListDbEntities db = new TodoListDbEntities(); Task dbTask = db.Tasks.Find(task.Id); if (dbTask != null) { dbTask.IsCompleted = true; db.SaveChanges(); int projectId = dbTask.ProjectId; UpdateProjectCount(projectId, db); } return true; }
private static void UpdateProjectCount(int projectId, TodoListDbEntities db) { int unfinished = db.Tasks.Count(x => x.ProjectId == projectId && x.IsCompleted == false); Project dbProject = db.Projects.Find(projectId); dbProject.Count = unfinished; db.SaveChanges(); }
public Project GetById(int id) { TodoListDbEntities db = new TodoListDbEntities(); Project project = db.Projects.Find(id); return project; }