public ApiListResult <ProductAttributeMappingDTO> Get([FromUri] AntPageOption option = null) { var query = ProductAttributeMappingService .GetAll() .Include(x => x.ProductAttributeValues) .ProjectTo <ProductAttributeMappingDTO>(); if (option != null) { if (!string.IsNullOrEmpty(option.SortField)) { //for example if (option.SortField == "id") { if (option.SortOrder == PageSortTyoe.DESC) { query = query.OrderByDescending(x => x.Id); } else { query = query.OrderBy(x => x.Id); } } } if (option.Page > 0 && option.Results > 0) { if (string.IsNullOrEmpty(option.SortField)) { query = query.OrderBy(x => x.Id); } } } else { query = query.OrderBy(x => x.Id); } var count = query.Count(); var result = query.Paging <ProductAttributeMappingDTO>(option.Page - 1, option.Results, count); return(new ApiListResult <ProductAttributeMappingDTO>(result, result.PageIndex, result.PageSize, count)); }
public ApiListResult <DepartmentDTO> Get([FromUri] AntPageOption option = null) { var query = DepartmentService.GetAll().Where(x => !x.Deleted).ProjectTo <DepartmentDTO>(); if (option != null) { if (!string.IsNullOrEmpty(option.SortField)) { //for example if (option.SortField == "code") { if (option.SortOrder == PageSortTyoe.DESC) { query = query.OrderByDescending(x => x.Code); } else { query = query.OrderBy(x => x.Code); } } } if (option.Page > 0 && option.Results > 0) { if (string.IsNullOrEmpty(option.SortField)) { query = query.OrderBy(x => x.Code); } } } else { query = query.OrderBy(x => x.Code); } var count = query.Count(); var result = query.Paging <DepartmentDTO>(option.Page - 1, option.Results, count); return(new ApiListResult <DepartmentDTO>(result, result.PageIndex, result.PageSize, count)); }
public ApiListResult <MemberDTO> Get([FromUri] AntPageOption option = null) { var query = UserManager.Users.Where(x => !x.Deleted).ProjectTo <MemberDTO>(); if (option != null) { if (!string.IsNullOrEmpty(option.SortField)) { //for example if (option.SortField == "id") { if (option.SortOrder == PageSortTyoe.DESC) { query = query.OrderByDescending(x => x.Id); } else { query = query.OrderBy(x => x.Id); } } } if (option.Page > 0 && option.Results > 0) { if (string.IsNullOrEmpty(option.SortField)) { query = query.OrderBy(x => x.Id); } } } else { query = query.OrderBy(x => x.Id); } var count = query.Count(); var result = query.Paging <MemberDTO>(option.Page - 1, option.Results, count); return(new ApiListResult <MemberDTO>(result, result.PageIndex, result.PageSize, count)); }