public bool CheckPermission(SrbacRoles role, SrbacPermissions permission) { var res = _srbacRepository.RolesPermissions.FirstOrDefault( p => p.Permission == permission && p.Role == role ); return(res != null); }
public async Task <bool> CheckPermission(SrbacRoles role, SrbacPermissions srbacPermission) { using IDbConnection db = new NpgsqlConnection(ConnectionString); return(await db.QueryFirstOrDefaultAsync <bool>( @$ " SELECT true FROM {TableName} WHERE Role = @Role AND Permission = @Permission ", new { Role = role, Permission = srbacPermission } )); }