public IEnumerable <ToDo> List(ToDoFilter filter)
{
return(_repository.List(filter));
}
public IQueryable <ApplicationUser> TodoEditors([FromQuery] ToDoFilter filter)
{
filter.ModifiedById = null;
return(Todos(filter).Where(i => i.ModifiedById != null).Select(i => i.ModifiedBy).Distinct());
}
public async Task <QueryResult <ApplicationUser> > GetTodoEditors(ToDoFilter filter)
{
return(await GetItems <ApplicationUser>(from : "TodoEditors", orderBy : i => i.UserName, parameters : filter?.ToDictionary()));
}
public async Task <QueryResult <Todo> > GetToDos(ToDoFilter filter, int?take = null, int?skip = null)
{
return(await GetItems <Todo>(from : "Todos", orderByDescending : i => i.CreatedOn, take : take, skip : skip, parameters : filter?.ToDictionary()));
}
public IQueryable <ApplicationUser> TodoCreators([FromQuery] ToDoFilter filter)
{
filter.CreatedById = null;
return(Todos(filter).Where(i => i.CreatedBy != null).Select(i => i.CreatedBy).Distinct().AsNoTracking());
}
public IEnumerable <ToDo> List(ToDoFilter filter)
{
var listToDo = connection.Query <ToDo>("exec todo_sp_list @Id, @Text, @IsCompleted", filter);
return(listToDo);
}
