public PagedList <OtfForTableDto> GetOtfTable(FilterOtfTableSelected filter)
{
var pagedList = _operationTypeFamilyRepository.GetOtfTable(filter);
var result = new PagedList <OtfForTableDto>(_mapper.Map <List <OtfForTableDto> >(pagedList.Datas), pagedList.Pagination);
return(result);
}
public FilterOtfTable GetFilterOtfTable(FilterOtfTableSelected filter)
{
FilterOtfTable filterOtfTable = new FilterOtfTable
{
Selected = filter
};
var Movements = _referentialService.MovementService.GetSelectList(EnumSelectType.Empty);
filterOtfTable.Movements = Movements;
return(filterOtfTable);
}
public PagedList <OperationTypeFamily> GetOtfTable(FilterOtfTableSelected filter)
{
var operationTypeFamilies = Context.OperationTypeFamily
.Where(x => x.IdUserGroup == filter.User.IdUserGroup)
.Include(x => x.Movement)
.AsQueryable();
if (filter.Label != null)
{
operationTypeFamilies = operationTypeFamilies.Where(x => x.Label.Contains(filter.Label));
}
if (filter.Movement != null)
{
operationTypeFamilies = operationTypeFamilies.Where(x => x.IdMovement == filter.Movement.Id);
}
//string columnSorted;
//columnSorted = $"OperationTypeFamily.{filter.Pagination.SortColumn}";
//if (filter.Pagination.SortColumn.Contains("movement"))
//{
// columnSorted = $"{columnSorted}.Label";
//}
if (filter.Pagination.SortDirection == "asc")
{
operationTypeFamilies = operationTypeFamilies.OrderBy(filter.Pagination.SortColumn);
}
else
{
operationTypeFamilies = operationTypeFamilies.OrderByDescending(filter.Pagination.SortColumn);
}
var results = PagedListRepository <OperationTypeFamily> .Create(operationTypeFamilies, filter.Pagination);
return(results);
}
public IActionResult getOtfTable([FromBody] FilterOtfTableSelected filter)
{
var pagedList = _operationTypeFamilyService.GetOtfTable(filter);
return(Ok(pagedList));
}
public IActionResult getOtfTableFilter([FromBody] FilterOtfTableSelected filter)
{
var result = _filterService.GetFilterOtfTable(filter);
return(Ok(result));
}
