public ListResultDto <Code_AppraisalTypeListDto> GetAllCode_AppraisalTypes(GetCode_AppraisalTypeListInput input) { var query = _code_AppraisalTypeRepository.GetAll(); var _code_AppraisalTypes = query.Where(r => !input.ParentId.HasValue || r.ParentId == input.ParentId.Value) .OrderBy(input.Sorting) .ToList(); var code_AppraisalTypeDtos = _code_AppraisalTypes.MapTo <List <Code_AppraisalTypeListDto> >(); return(new ListResultDto <Code_AppraisalTypeListDto> { Items = code_AppraisalTypeDtos }); }
public async Task <PagedResultDto <Code_AppraisalTypeListDto> > GetCode_AppraisalTypes(GetCode_AppraisalTypeListInput input) { try { var query = from code in _code_AppraisalTypeRepository.GetAll() join pcoded in _code_AppraisalTypeRepository.GetAll() on code.ParentId equals pcoded.Id into g from pcode in g.DefaultIfEmpty() where (!input.ParentId.HasValue || code.ParentId == input.ParentId.Value) select new Code_AppraisalTypeListDto { Id = code.Id, Name = code.Name, ParentName = pcode.Name, ParentId = code.ParentId, Sort = code.Sort }; var count = await query.CountAsync(); var _code_AppraisalTypes = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); return(new PagedResultDto <Code_AppraisalTypeListDto>(count, _code_AppraisalTypes)); } catch (Exception ex) { throw; } }