public IEnumerable <Todo> List(TodoFilter filter)
{
//Usando o Dapper para comunicacao com o banco
var todos = connection.Query <Todo>("exec todo_sp_list @Id, @Text, @IsCompleted", filter);
return(todos);
}
public async Task <IActionResult> GetTodos([FromQuery] TodoFilter filters)
{
return(await AsyncMethods(async() => {
var result = await TodoManager.GetFiltered(filters.ToDictionary());
return Ok(result);
}));
}
public async Task <IActionResult> TodoList(TodoFilter filter)
{
var entities = await _todoService.ListAsync(statuses : filter?.Statuses, searchString : filter?.SearchString);
var dtos = _mapper.Map(entities, new List <TodoDTO>());
return(PartialView("TodoList", dtos));
}
public void TestIdPredicate()
{
var filter = new TodoFilter {
Id = 123
};
var predicateGenerator = new PredicateGenerator <TodoFilter, Todo>();
var predicate = predicateGenerator.Generate(filter);
//var expectedPredicate = ExpressionExtensions.Expression(x => x.Id == 123);
Expression <Func <Todo, bool> > expectedPredicate = x => x.Id == 123;
Assert.Equal(expectedPredicate.ToString(), predicate.ToString());
}
private void CheckFilter(TodoFilter selectedFilter)
{
if (selectedFilter == TodoFilter.DONE)
{
CompletedFilter.IsChecked = true;
}
else if (selectedFilter == TodoFilter.WIP)
{
InProgressFilter.IsChecked = true;
}
else
{
AllFilter.IsChecked = true;
}
}
public void TestTypePredicate()
{
var filter = new TodoFilter {
Type = new[] { "a", "b" }
};
var predicateGenerator = new PredicateGenerator <TodoFilter, Todo>();
var predicate = predicateGenerator.Generate(filter);
var items = new List <Todo>
{
new Todo {
Type = "a"
},
new Todo {
Type = "b"
},
new Todo {
Type = "c"
},
};
var filteredItems = items.AsQueryable().Where(predicate).ToList();
Assert.DoesNotContain(filteredItems, x => x.Type == "c");
}
public IEnumerable <Todo> List(TodoFilter filter)
{
return(repository.List(filter));
}
public IEnumerable <Todo> List(TodoFilter filter)
{
var result = Connection.Query <Todo>("exec todo_sp_list @Id, @Text, @IsCompleted", filter, transaction: transaction);
return(result);
}
public async Task <IActionResult> GetList([FromBody] TodoFilter filter)
{
var result = await service.GetList(filter);
return(Ok(result));
}
public IEnumerable <Todo> List(TodoFilter filter) => repository.List(filter);
public async Task TodoListSending(TodoFilter filter)
{
var items = await service.GetList(filter);
await Clients.Others.SendAsync("TodoListReceived", new { filter, items });
}
public Task <IEnumerable <TodoItem> > GetList(TodoFilter filter) => storage.Todos.GetList(filter);
private void FilterTodos(TodoFilter filter)
{
App.Store.Dispatch(Actions.setFilter(filter));
}
public IEnumerable <Todo> List(TodoFilter filter)
{
var result = connection.Query <Todo>("exec todo_sp_list @id, @text, @isCompleted", filter);
return(result);
}
public IHttpActionResult LoadTodoList([FromBody] TodoFilter filter)
{
Dictionary <string, int> businessids = GetTodoBusinessIdList(filter.TaskType);
var data = new Framework.Data.PartlyCollection <VTaskTodo>();
if (businessids.Count > 0)
{
var queryFilter = new VTaskTodoFilter();
queryFilter.BusinessIDS = businessids.Select(x => x.Key).ToList();
var startTime = DateTime.MinValue;
DateTime dateNow = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd"));
if (filter.TimeRange.HasValue)
{
switch (filter.TimeRange.Value)
{
case 1:
startTime = dateNow;
break;
case 2:
startTime = dateNow.AddDays(-1);
break;
case 3:
startTime = dateNow.AddDays(Convert.ToDouble((0 - Convert.ToInt16(DateTime.Now.DayOfWeek))) - 7);
break;
case 4:
startTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-1);
break;
case 5:
startTime = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-01")).AddMonths(-3);
break;
case 6:
startTime = DateTime.Parse(DateTime.Now.ToString("yyyy-01-01")).AddYears(-1);
break;
}
queryFilter.CreatorTimeStart = startTime;
}
queryFilter.TaskTitle = filter.TaskTitle;
queryFilter.PageSize = filter.PageSize;
queryFilter.PageIndex = filter.PageIndex;
//queryFilter.EmployeeLoginName = WebHelper.GetCurrentUser().LoginName;
data = VTaskTodoOperator.Instance.GetViewList(queryFilter);
}
var result = data.Select(x =>
{
var finder = businessids.FirstOrDefault(t => t.Key.Equals(x.BusinessID, StringComparison.CurrentCultureIgnoreCase));
var todo = new Todo();
todo.ConvertEntity(x, finder.Value);
return(todo);
}).ToList();
return(BizResult(new ViewData <Todo>()
{
Data = result, TotalCount = data.TotalCount
}));
}
public async Task <IEnumerable <TodoItem> > GetList(TodoFilter filter) => await Task.Run(() =>
public Task <IEnumerable <TodoItem> > GetList(TodoFilter filter)
=> Task.Run(() =>
{
using var context = dbContextFactory.Invoke();
