public async Task <EasyUIGridOutput <GridContentOutput> > GetGridContents(DataGridInput input) { var query = _commonModelRepository.GetAll() .WhereIf(!string.IsNullOrWhiteSpace(input.Filter), o => o.Title.Contains(input.Filter) || o.Info.Contains(input.Filter)) .WhereIf(input.ColumnId.HasValue, o => o.ColumnId == input.ColumnId); var count = await query.CountAsync(); var list = await query.OrderBy($"{input.Sort} {input.Order}").Skip((input.Page - 1) * input.Rows).Take(input.Rows).ProjectTo <GridContentOutput>().ToListAsync(); return(new EasyUIGridOutput <GridContentOutput> { total = count, rows = list }); }
public override DataGridResult <ToDoListElement> execute(DataGridInput input) { ToDoListRequest request = new ToDoListRequest(); request.UserInfo = NavigationHandler.UserInfo; request.PageSize = input.NumResForPage; request.RequestedPage = input.NumPage; request.IdGruppo = NavigationHandler.RuoloInfo.IdGruppo; request.Registri = NavigationHandler.Registri; if (!string.IsNullOrEmpty(input.IdParent)) { request.ParentFolderId = input.IdParent; } ToDoListResponse resp = WSStub.getTodoList(request); DataGridResult <ToDoListElement> res = new DataGridResult <ToDoListElement>(); res.NumTotResults = resp.TotalRecordCount; res.Elements = new List <ToDoListElement>(); foreach (ToDoListElement temp in resp.Elements) { res.Elements.Add(temp); } return(res); }
public override abstract DataGridResult <C> execute(DataGridInput input);