// GET api/values/5
public TodoModel Get(int id)
{
dynamic table = new Todo();
var item = table.First(Id: id);
if (item == null) return null;
return DynamicToModel(item);
}
// GET api/values
public IEnumerable<TodoModel> Get()
{
var items = new List<TodoModel>();
dynamic table = new Todo();
var list = table.All(where: "WHERE Deleted = 0");
foreach (dynamic d in list) {
items.Add(DynamicToModel(d));
}
return items;
}
// PUT api/values/5
public void Put(int id, [FromBody]TodoItem todo)
{
dynamic table = new Todo();
var completed = new Nullable<DateTime>();
if (todo.IsComplete) completed = DateTime.Now;
var item = new {
Name = todo.Name,
IsComplete = todo.IsComplete,
CompletedOn = completed
};
table.Update(item, id);
}
// POST api/values
public void Post([FromBody]NewTodo todo)
{
dynamic table = new Todo();
var item = new { Name = todo.Name, CreatedOn = DateTime.Now };
table.Insert(item);
}
// DELETE api/values/5
public void Delete(int id)
{
dynamic table = new Todo();
var item = new { Deleted = true, DeletedOn = DateTime.Now };
table.Update(item, id);
}
