public async Task <PagedResultDto <EntityChangeListDto> > GetEntityTypeChanges(GetEntityTypeChangeInput input) { // Fix for: https://github.com/aspnetzero/aspnet-zero-core/issues/2101 var entityId = "\"" + input.EntityId + "\""; var query = from entityChangeSet in _entityChangeSetRepository.GetAll() join entityChange in _entityChangeRepository.GetAll() on entityChangeSet.Id equals entityChange.EntityChangeSetId join user in _userRepository.GetAll() on entityChangeSet.UserId equals user.Id where entityChange.EntityTypeFullName == input.EntityTypeFullName && (entityChange.EntityId == input.EntityId || entityChange.EntityId == entityId) select new EntityChangeAndUser { EntityChange = entityChange, User = user }; var resultCount = await query.CountAsync(); var results = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var entityChangeListDtos = ConvertToEntityChangeListDtos(results); return(new PagedResultDto <EntityChangeListDto>(resultCount, entityChangeListDtos)); }
public async Task <PagedResultDto <EntityChangeListDto> > GetEntityTypeChanges(GetEntityTypeChangeInput input) { var query = from entityChangeSet in _entityChangeSetRepository.GetAll() join entityChange in _entityChangeRepository.GetAll() on entityChangeSet.Id equals entityChange.EntityChangeSetId join user in _userRepository.GetAll() on entityChangeSet.UserId equals user.Id where entityChange.EntityTypeFullName == input.EntityTypeFullName && entityChange.EntityId == input.EntityId select new EntityChangeAndUser { EntityChange = entityChange, User = user }; var resultCount = await query.CountAsync(); var results = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var entityChangeListDtos = ConvertToEntityChangeListDtos(results); return(new PagedResultDto <EntityChangeListDto>(resultCount, entityChangeListDtos)); }