public bool IsLastTaskCompleted(int taskId) { using (var db = new Context.TaskManagerDbContext()) { var task = db.Task.Include("Project").First(t => t.TaskId == taskId); var allTasks = (from t in db.Task where t.ProjectId == task.ProjectId orderby t.EndingDate select t).ToList(); var counter = 0; foreach (var item in allTasks) { if (item.EndingDate == null) { if (++counter > 1) { return(false); } } } task.Project.IsActive = false; db.Entry(task.Project).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); } return(true); }
public bool IsFirstTask(int taskId) { var db = new Context.TaskManagerDbContext(); var task = db.Task.Include("Project").First(t => t.TaskId == taskId); var ownProject = db.Project.First(t => t.ProjectId == task.ProjectId); if (ownProject != null && ownProject.StartingDate == null) { return(true); } return(false); }