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