public async Task <DynamicContentPlaceSearchResult> SearchContentPlacesAsync(DynamicContentPlaceSearchCriteria criteria) { var cacheKey = CacheKey.With(GetType(), nameof(SearchContentPlacesAsync), criteria.GetCacheKey()); return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async (cacheEntry) => { cacheEntry.AddExpirationToken(DynamicContentPlaceCacheRegion.CreateChangeToken()); var result = AbstractTypeFactory <DynamicContentPlaceSearchResult> .TryCreateInstance(); using (var repository = _repositoryFactory()) { var sortInfos = BuildSearchExpression(criteria); var query = BuildQuery(criteria, repository); result.TotalCount = await query.CountAsync(); if (criteria.Take > 0) { var ids = await query.OrderBySortInfos(sortInfos).ThenBy(x => x.Id) .Select(x => x.Id).Skip(criteria.Skip) .Take(criteria.Take) .ToArrayAsync(); result.Results = (await _dynamicContentService.GetPlacesByIdsAsync(ids)) .OrderBy(x => Array.IndexOf(ids, x.Id)).ToList(); } } return result; })); }
public async Task DeletePlacesAsync(string[] ids) { using (var repository = _repositoryFactory()) { await repository.RemovePlacesAsync(ids); await repository.UnitOfWork.CommitAsync(); } DynamicContentPlaceCacheRegion.ExpireRegion(); }
public async Task <DynamicContentPlace[]> GetPlacesByIdsAsync(string[] ids) { var cacheKey = CacheKey.With(GetType(), "GetPlacesByIdsAsync", string.Join("-", ids)); return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async (cacheEntry) => { cacheEntry.AddExpirationToken(DynamicContentPlaceCacheRegion.CreateChangeToken()); using (var repository = _repositoryFactory()) { var contentPlaces = await repository.GetContentPlacesByIdsAsync(ids); return contentPlaces .Select(x => x.ToModel(AbstractTypeFactory <DynamicContentPlace> .TryCreateInstance())).ToArray(); } })); }
public async Task SavePlacesAsync(DynamicContentPlace[] places) { var pkMap = new PrimaryKeyResolvingMap(); var changedEntries = new List <GenericChangedEntry <DynamicContentPlace> >(); using (var repository = _repositoryFactory()) { var existEntities = await repository.GetContentPlacesByIdsAsync(places.Where(x => !x.IsTransient()).Select(x => x.Id).ToArray()); foreach (var place in places) { var sourceEntity = AbstractTypeFactory <DynamicContentPlaceEntity> .TryCreateInstance(); if (sourceEntity != null) { sourceEntity = sourceEntity.FromModel(place, pkMap); var targetEntity = existEntities.FirstOrDefault(x => x.Id == place.Id); if (targetEntity != null) { changedEntries.Add(new GenericChangedEntry <DynamicContentPlace>(place, targetEntity.ToModel(AbstractTypeFactory <DynamicContentPlace> .TryCreateInstance()), EntryState.Modified)); sourceEntity.Patch(targetEntity); } else { changedEntries.Add(new GenericChangedEntry <DynamicContentPlace>(place, EntryState.Added)); repository.Add(sourceEntity); } } } await repository.UnitOfWork.CommitAsync(); pkMap.ResolvePrimaryKeys(); DynamicContentPlaceCacheRegion.ExpireRegion(); await _eventPublisher.Publish(new DynamicContentPlaceChangedEvent(changedEntries)); } }
public async Task <DynamicContentPlaceSearchResult> SearchContentPlacesAsync(DynamicContentPlaceSearchCriteria criteria) { var cacheKey = CacheKey.With(GetType(), "SearchContentPlacesAsync", criteria.GetCacheKey()); return(await _platformMemoryCache.GetOrCreateExclusiveAsync(cacheKey, async (cacheEntry) => { cacheEntry.AddExpirationToken(DynamicContentPlaceCacheRegion.CreateChangeToken()); var retVal = AbstractTypeFactory <DynamicContentPlaceSearchResult> .TryCreateInstance(); using (var repository = _repositoryFactory()) { var query = repository.Places; if (!string.IsNullOrEmpty(criteria.FolderId)) { query = query.Where(x => x.FolderId == criteria.FolderId); } if (!string.IsNullOrEmpty(criteria.Keyword)) { query = query.Where(q => q.Name.Contains(criteria.Keyword)); } var sortInfos = criteria.SortInfos; if (sortInfos.IsNullOrEmpty()) { sortInfos = new[] { new SortInfo { SortColumn = ReflectionUtility.GetPropertyName <DynamicContentPlace>(x => x.Name), SortDirection = SortDirection.Ascending } }; } query = query.OrderBySortInfos(sortInfos); retVal.TotalCount = await query.CountAsync(); if (criteria.Take > 0) { var ids = await query.Select(x => x.Id).Skip(criteria.Skip).Take(criteria.Take).ToArrayAsync(); retVal.Results = await _dynamicContentService.GetPlacesByIdsAsync(ids); } } return retVal; })); }