Пример #1
0
        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
            });
        }
Пример #2
0
        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;
            }
        }