public bool edit(Todo todo)
{
using (dev101Entities entity = new dev101Entities())
{
try
{
//int iid = Convert.ToInt32(todo.Id);
TaskEntity task = entity.TaskEntities.Single(pe => pe.id == todo.Id);
task.id = todo.Id;
task.title = todo.Title;
task.tags = todo.Tags;
task.author = todo.Author;
task.executor = todo.Executor;
task.datedue = todo.DateDue;
task.datedone = todo.DateDone;
entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}
public bool create(Todo todo)
{
using (dev101Entities entity = new dev101Entities())
{
try
{
TaskEntity task = new TaskEntity();
task.id = todo.Id;
task.title = todo.Title;
task.tags = todo.Tags;
task.author = todo.Author;
task.executor = todo.Executor;
task.datedue = todo.DateDue;
task.datedone = todo.DateDone;
entity.TaskEntities.Add(task);
entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}
public List <Todo> findAll()
{
using (dev101Entities entity = new dev101Entities())
{
return(entity.TaskEntities.Select(pe => new Todo
{
Id = pe.id,
Title = pe.title,
Tags = pe.tags,
Author = pe.author,
Executor = pe.executor,
DateDue = pe.datedue,
DateDone = pe.datedone
}).ToList());
};
}
public Todo find(string id)
{
using (dev101Entities entity = new dev101Entities())
{
int iid = Convert.ToInt32(id);
return(entity.TaskEntities.Where(pe => pe.id == iid).Select(pe => new Todo
{
Id = pe.id,
Title = pe.title,
Tags = pe.tags,
Author = pe.author,
Executor = pe.executor,
DateDue = pe.datedue,
DateDone = pe.datedone
}).First());
};
}
public bool delete(Todo todo)
{
using (dev101Entities entity = new dev101Entities())
{
try
{
TaskEntity task = entity.TaskEntities.Single(pe => pe.id == todo.Id);
entity.TaskEntities.Remove(task);
entity.SaveChanges();
return(true);
}
catch
{
return(false);
}
};
}