Using 'PrincipalAccessor.Principal' with a Filter in ZeroDbContext #9962

[email protected] created 4 years ago

.net core MVC 9.x

I have the following code with my ZeroDbContext:

    protected virtual long[] GetCurrentUserOrganizationUnitIds()
    {
        var userOuClaim = PrincipalAccessor.Principal?.Claims.FirstOrDefault(c => c.Type == ClaimsConstants.OrganizationUnitClaimKey);
        if (string.IsNullOrEmpty(userOuClaim?.Value))
        {
            return Array.Empty&lt;long&gt;();
        }

        return userOuClaim.Value.Split(',', StringSplitOptions.RemoveEmptyEntries)
            .Select(long.Parse)
            .ToArray();
    }


        protected override Expression&lt;Func&lt;TEntity, bool&gt;> CreateFilterExpression&lt;TEntity&gt;()
        {
            var expression = base.CreateFilterExpression&lt;TEntity&gt;();
            if (typeof(OrganizationUnit).IsAssignableFrom(typeof(TEntity)))
            {
                if (IsOrganizationUnitFilterEnabled)
                {
                    Expression&lt;Func&lt;TEntity, bool&gt;> organizationUnitFilter = e => CurrentOUId.Contains(((IEntity&lt;long&gt;) e).Id);
                    expression = expression == null ? organizationUnitFilter : CombineExpressions(expression, organizationUnitFilter);
                }
            }
            return expression;
        }

The problem I have is that PrincipalAccessor.Principal?.Claims.FirstOrDefault(c => c.Type == ClaimsConstants.OrganizationUnitClaimKey); always returns null. My working assumption is that filters are created only once when the context is first instantiated and there is no Principal at that time.

I believe other values used within the ZeroDbContext such as CurrentTenantId are provided to the context from the AbpSession.

Question How can I add an EF filter that is based on data that is within the PrincipalAccessor.Principal at the time the query is executed?

2 Answer(s)