public OperationDataResult <EntityGroupList> GetEntityGroupList(
AdvEntitySelectableGroupListRequestModel requestModel)
{
try
{
eFormCore.Core core = _coreHelper.GetCore();
EntityGroupList model = core.Advanced_EntityGroupAll(requestModel.Sort, requestModel.NameFilter,
requestModel.PageIndex, requestModel.PageSize, Constants.FieldTypes.EntitySelect,
requestModel.IsSortDsc,
Constants.WorkflowStates.NotRemoved);
return(new OperationDataResult <EntityGroupList>(true, model));
}
catch (Exception)
{
return(new OperationDataResult <EntityGroupList>(false, LocaleHelper.GetString("SelectableGroupLoadingFailed")));
}
}
public async Task <OperationDataResult <Paged <EntityGroup> > > Index(
AdvEntitySelectableGroupListRequestModel requestModel)
{
try
{
var core = await _coreHelper.GetCore();
var sdkDbContext = core.DbContextHelper.GetDbContext();
var entityGroupList = new Paged <EntityGroup>();
// get query
var entitySelectableGroupQuery = sdkDbContext.EntityGroups
.Where(x => x.WorkflowState != Constants.WorkflowStates.Removed)
.Where(x => x.Type == Constants.FieldTypes.EntitySelect)
.AsNoTracking()
.AsQueryable();
if (!string.IsNullOrEmpty(requestModel.NameFilter))
{
entitySelectableGroupQuery = entitySelectableGroupQuery
.Where(x => x.Name.Contains(requestModel.NameFilter));
}
// sort
entitySelectableGroupQuery = QueryHelper.AddSortToQuery(entitySelectableGroupQuery, requestModel.Sort, requestModel.IsSortDsc);
// count elements
entityGroupList.Total = await entitySelectableGroupQuery.Select(x => x.Id).CountAsync();
// pagination
entitySelectableGroupQuery =
entitySelectableGroupQuery
.Skip(requestModel.Offset)
.Take(requestModel.PageSize);
// select and take from db
var entityGroups = await entitySelectableGroupQuery
.Select(x => new EntityGroup
{
Description = x.Description,
WorkflowState = x.WorkflowState,
CreatedAt = x.CreatedAt,
Id = x.Id,
MicrotingUUID = x.MicrotingUid,
Name = x.Name,
Type = x.Type,
UpdatedAt = x.UpdatedAt,
EntityGroupItemLst = new List <EntityItem>(),
}).ToListAsync();
entityGroupList.Entities = entityGroups;
var plugins = await _dbContext.EformPlugins.Select(x => x.PluginId).ToListAsync();
foreach (var entityGroup in entityGroupList.Entities)
{
foreach (var _ in plugins.Where(plugin => entityGroup.Name.Contains(plugin)))
{
entityGroup.IsLocked = true;
}
}
return(new OperationDataResult <Paged <EntityGroup> >(true, entityGroupList));
}
catch (Exception)
{
return(new OperationDataResult <Paged <EntityGroup> >(false,
_localizationService.GetString("SelectableGroupLoadingFailed")));
}
}
public Task <OperationDataResult <Paged <EntityGroup> > > Index(
[FromBody] AdvEntitySelectableGroupListRequestModel requestModel)
{
return(_entitySelectService.Index(requestModel));
}
