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