public virtual async Task <IActionResult> List(int itemsPerPage, int currentPage) { var pagination = new FluentPagination(currentPage, true, itemsPerPage); var spec = CreateSpec <FluentAllSpec <T> >().SetParameter(isList: true); var list = await Service.ListAsync(spec, pagination); ViewBag.pagination = pagination; return(View(list)); }
public override async Task <List <User> > ListAsync(IFluentSpecification spec, FluentPagination pagination = null) { var tableName = typeof(User).GetTableName(); var collumName = typeof(User).GetProperty("Code").GetColumnName(); var sql = $"select * from {tableName} where {collumName} = {{0}}"; var newSpec = CreateSpec <FluentSqlSpec <User> >().SetParameter(sql, 45); return(await base.ListAsync(newSpec, pagination)); }