public PagedList <AccountStatementImport> GetAsiTable(FilterAsiTableSelected filter) { var accountStatementImports = Context.AccountStatementImport .Include(x => x.User) .AsQueryable(); if (filter.IdUser.HasValue) { accountStatementImports = accountStatementImports.Where(x => x.IdUser == filter.IdUser); } if (filter.IdBankAgency.HasValue) { accountStatementImports = accountStatementImports.Where(x => x.IdBankAgency == filter.IdBankAgency); } if (filter.Pagination.SortDirection == "asc") { accountStatementImports = accountStatementImports.OrderBy(filter.Pagination.SortColumn); } else { accountStatementImports = accountStatementImports.OrderByDescending(filter.Pagination.SortColumn); } var results = PagedListRepository <AccountStatementImport> .Create(accountStatementImports, filter.Pagination); return(results); }
public PagedList <AsiForTableDto> GetAsiTable(FilterAsiTableSelected filter) { var pagedList = _accountStatementImportRepository.GetAsiTable(filter); var result = new PagedList <AsiForTableDto>(_mapper.Map <List <AsiForTableDto> >(pagedList.Datas), pagedList.Pagination); return(result); }
public FilterAsiTable GetFilterAsiTable(FilterAsiTableSelected filter) { FilterAsiTable filterAsiTable = new FilterAsiTable(); filterAsiTable.Selected = filter; var BankAgencies = _accountStatementImportService.GetDistinctBankAgencies(filter.IdUser.Value); var BankAgenciesDto = _mapper.Map <List <BankAgencyDto> >(BankAgencies); filterAsiTable.BankAgencies = BankAgenciesDto; filterAsiTable.Selected.IdBankAgency = BankAgenciesDto.Count == 0 ? null : filter.IdBankAgency == null ? BankAgenciesDto[0].Id : filter.IdBankAgency; return(filterAsiTable); }
public IActionResult getAsiTable([FromBody] FilterAsiTableSelected filter) { var pagedList = _accountStatementImportService.GetAsiTable(filter); return(Ok(pagedList)); }
public IActionResult getAsiTableFilter([FromBody] FilterAsiTableSelected filter) { var result = _filterService.GetFilterAsiTable(filter); return(Ok(result)); }