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 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; }
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 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 bool MarkCompleter(Task task) { todoListDbEntities db = new todoListDbEntities(); var dbTask = db.Tasks.Find(task.Id); if (dbTask!=null) { dbTask.isCompleted = true; db.SaveChanges(); int projectId = dbTask.ProjectId; UpdateProjectCount(projectId, db); } return true; }