public PagedList <AccountStatementImportFile> GetAsifTable(FilterAsifTableSelected filter)
{
var accountStatementImportFiles = Context.AccountStatementImportFile
.Include(x => x.Operation)
.Include(x => x.OperationMethod)
.Include(x => x.OperationType)
.Include(x => x.OperationTypeFamily)
.AsQueryable();
if (filter.IdImport != null)
{
accountStatementImportFiles = accountStatementImportFiles.Where(x => x.IdImport == filter.IdImport);
}
if (filter.Account != null)
{
accountStatementImportFiles = accountStatementImportFiles.Where(x => x.IdAccount == filter.Account.Id);
}
if (filter.AsifState != null)
{
accountStatementImportFiles = accountStatementImportFiles.Where(x => (int)x.EnumAsifState == filter.AsifState.Id);
}
if (filter.Pagination.SortDirection == "asc")
{
accountStatementImportFiles = accountStatementImportFiles.OrderBy(filter.Pagination.SortColumn);
}
else
{
accountStatementImportFiles = accountStatementImportFiles.OrderByDescending(filter.Pagination.SortColumn);
}
var results = PagedListRepository <AccountStatementImportFile> .Create(accountStatementImportFiles, filter.Pagination);
return(results);
}
public PagedList <AsifForTableDto> GetAsifTable(FilterAsifTableSelected filter)
{
var pagedList = _accountStatementImportFileRepository.GetAsifTable(filter);
var result = new PagedList <AsifForTableDto>(_mapper.Map <List <AsifForTableDto> >(pagedList.Datas), pagedList.Pagination);
return(result);
}
public FilterAsifTable GetFilterAsifTable(FilterAsifTableSelected filter)
{
FilterAsifTable filterAsifTable = new FilterAsifTable();
filterAsifTable.Selected = filter;
var asi = _accountStatementImportService.GetForDetailById(filter.IdImport.Value);
filterAsifTable.AsiBankAgencyLabel = asi.BankAgency.Label;
filterAsifTable.AsiDateImport = asi.DateImport;
var accounts = _accountStatementImportFileService.GetAccountSelectListByIdImport(filter.IdImport.Value);
filterAsifTable.Selected.Account = filter.Account == null ? accounts[0] : filter.Account;
var asifStates = _accountStatementImportFileService.GetAsifStates(filter.IdImport.Value, filterAsifTable.Selected.Account.Id);
filterAsifTable.Selected.AsifState = filter.AsifState == null ? asifStates[0] : filter.AsifState;
filterAsifTable.Accounts = accounts;
filterAsifTable.AsifStates = asifStates;
return(filterAsifTable);
}
public IActionResult getAsifTable([FromBody] FilterAsifTableSelected filter)
{
var pagedList = _accountStatementImportFileService.GetAsifTable(filter);
return(Ok(pagedList));
}
public IActionResult getAsifTableFilter([FromBody] FilterAsifTableSelected filter)
{
var result = _filterService.GetFilterAsifTable(filter);
return(Ok(result));
}
