public PagedList <OperationForTableDto> GetTable(FilterOperationTableSelected filter)
{
var pagedList = _operationRepository.GetTable(filter);
var result = new PagedList <OperationForTableDto>(_mapper.Map <List <OperationForTableDto> >(pagedList.Datas), pagedList.Pagination);
return(result);
}
public FilterOperationTable GetFilterOperationTable(FilterOperationTableSelected filter)
{
FilterOperationTable filterOperationTable = new FilterOperationTable
{
Selected = filter
};
filterOperationTable.OperationMethods = _referentialService.OperationMethodService.GetSelectList(EnumSelectType.Empty);
filterOperationTable.OperationTypes = _referentialService.OperationTypeService.GetSelectGroup(filter.User.IdUserGroup);
return(filterOperationTable);
}
public PagedList <Operation> GetTable(FilterOperationTableSelected filter)
{
var operations = Context.Operation
.Where(x => x.IdUserGroup == filter.User.IdUserGroup)
.Include(x => x.OperationType)
.Include(x => x.OperationMethod)
.AsQueryable();
if (filter.Label != null)
{
operations = operations.Where(x => x.Label.Contains(filter.Label));
}
if (filter.OperationMethods != null && filter.OperationMethods.Count > 0)
{
var idOperationMethods = filter.OperationMethods.Select(x => x.Id).ToList();
operations = operations.Where(x => idOperationMethods.Contains(x.IdOperationMethod));
}
if (filter.OperationTypes != null && filter.OperationTypes.Count > 0)
{
var idOperationTypes = filter.OperationTypes.Select(x => x.Id).ToList();
operations = operations.Where(x => idOperationTypes.Contains(x.IdOperationType));
}
if (filter.Pagination.SortDirection == "asc")
{
operations = operations.OrderBy(filter.Pagination.SortColumn);
}
else
{
operations = operations.OrderByDescending(filter.Pagination.SortColumn);
}
var results = PagedListRepository <Operation> .Create(operations, filter.Pagination);
return(results);
}
public IActionResult getTableFilter([FromBody] FilterOperationTableSelected filter)
{
var result = _filterService.GetFilterOperationTable(filter);
return(Ok(result));
}
public IActionResult getTable([FromBody] FilterOperationTableSelected filter)
{
var pagedList = _referentialService.OperationService.GetTable(filter);
return(Ok(pagedList));
}
