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