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