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));
}
