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