public List<ProjectViewModel> GetAll() { todoListDbEntities db = new todoListDbEntities(); IQueryable<Project> dbSet = db.Projects.AsQueryable(); List<ProjectViewModel> list = dbSet.Select(x => new ProjectViewModel() { Id = x.Id, Name = x.Name, Count = x.Count}).ToList(); return list; }
public List<TaskViewModel> GetAllByProject(int projectId, string sortOn, string sortBy) { todoListDbEntities db = new todoListDbEntities(); IQueryable<Task> queryable = db.Tasks.Where(x => x.ProjectId == projectId).AsQueryable(); if (sortBy=="desc") { queryable = sortOn=="date" ? queryable.OrderByDescending(x => x.DueDate) : queryable.OrderByDescending(x => x.isCompleted); } else { queryable = sortOn == "date" ? queryable.OrderBy(x => x.DueDate) : queryable.OrderBy(x => x.isCompleted); } List<TaskViewModel> taskViewModels = queryable.Select(x => new TaskViewModel() { Id = x.Id, Name = x.Name, ProjectId = x.ProjectId, ProjectName = x.Project.Name, Priority = x.Priority, DueDate = x.DueDate, IsCompleted = x.isCompleted }).ToList(); return taskViewModels; }
public List<TaskViewModel> GetAllByProject(int projectId) { todoListDbEntities db = new todoListDbEntities(); IQueryable<Task> dbSet = db.Tasks.Where(x=>x.ProjectId==projectId).AsQueryable(); List<TaskViewModel> list = dbSet.Select(x => new TaskViewModel() { Id = x.Id, Name = x.Name, IsCompleted = x.isCompleted, DueDate = x.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 List<TaskViewModel> GetAll() { todoListDbEntities db = new todoListDbEntities(); IQueryable<Task> dbSet = db.Tasks.AsQueryable(); List<TaskViewModel> list = dbSet.Select (x => new TaskViewModel() { Id = x.Id, Name = x.Name , ProjectId = x.ProjectId, ProjectName = x.Project.Name, Priority=x.Priority, DueDate=x.DueDate, IsCompleted=x.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 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, }; }
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; }
public Project GetById(int id) { todoListDbEntities db=new todoListDbEntities(); Project project = db.Projects.Find(id); return project; }