Many to Many rel with Identity User and modify/extend the User edit page #9064

• Template: app-nolayers

• Created ABP Studio Version: 0.9.25

• Current ABP Studio Version: 0.9.25

• Multi-Tenancy: No

• UI Framework: blazor-server

• Theme: leptonx

• Theme Style: system

• Run Install Libs: Yes

• Database Provider: ef

• Database Management System: postgresql

• Create Initial Migration: Yes

• Run Db Migrator: Yes

• Use Local References: No

• Optional Modules:

  • GDPR

  • FileManagement

  • TextTemplateManagement

  • LanguageManagement

  • AuditLogging

  • Chat

  • OpenIddictAdmin

Hello, I need advice on the best way to implement many-to-many relationships involving the User entity. Here’s my scenario:

Entities Involved:
*Work Sites and Services: I have several dynamic work sites and services.
*User Types: There are two types of users:
* Internal users: They can add and modify services and sites.
* Commercial (customer) users: They are associated with specific services and sites and should only be able to view tasks and activities assigned to those sites.
Relationships:

• I want to establish a many-to-many relationship between IdentityUser and Service.

• I also want a many-to-many relationship between IdentityUser and Site.
  Current Approach:

• I noticed that ABP Suite doesn’t support creating many-to-many relationships with an ABP Entity directly.

• Therefore, I manually configured the navigation properties between Service and IdentityUser.

Questions:

1. Is manually setting up the navigation properties the right approach for establishing these many-to-many relationships?

2. How can I modify the User edit page to include these two relationships? My goal is to assign services and sites to a user, which will then be used to filter data.
   Could you please advise on the best practices and steps to achieve this?

Thanks

I share code about Services and many to many rel ServiceIdentityUser and his joint table

namespace CoopService.Services
{
    public abstract class ServiceBase : FullAuditedAggregateRoot<int>
    {
        [NotNull]
        public virtual string Code { get; set; }

        [NotNull]
        public virtual string Description { get; set; }

        public ICollection<ServiceIdentityUser> IdentityUsers { get; private set; }

        protected ServiceBase()
        {

        }

        public ServiceBase(string code, string description)
        {

            Check.NotNull(code, nameof(code));
            Check.Length(code, nameof(code), ServiceConsts.CodeMaxLength, 0);
            Check.NotNull(description, nameof(description));
            Code = code;
            Description = description;
            IdentityUsers = new Collection<ServiceIdentityUser>();
        }
        public virtual void AddIdentityUser(Guid identityUserId)
        {
            Check.NotNull(identityUserId, nameof(identityUserId));

            if (IsInIdentityUsers(identityUserId))
            {
                return;
            }

            IdentityUsers.Add(new ServiceIdentityUser(Id, identityUserId));
        }

        public virtual void RemoveIdentityUser(Guid identityUserId)
        {
            Check.NotNull(identityUserId, nameof(identityUserId));

            if (!IsInIdentityUsers(identityUserId))
            {
                return;
            }

            IdentityUsers.RemoveAll(x => x.IdentityUserId == identityUserId);
        }

        public virtual void RemoveAllIdentityUsersExceptGivenIds(List<Guid> identityUserIds)
        {
            Check.NotNullOrEmpty(identityUserIds, nameof(identityUserIds));

            IdentityUsers.RemoveAll(x => !identityUserIds.Contains(x.IdentityUserId));
        }

        public virtual void RemoveAllIdentityUsers()
        {
            IdentityUsers.RemoveAll(x => x.ServiceId == Id);
        }

        private bool IsInIdentityUsers(Guid identityUserId)
        {
            return IdentityUsers.Any(x => x.IdentityUserId == identityUserId);
        }
    }
}

namespace CoopService.Services
{
    public class ServiceIdentityUser : Entity
    {

        public int ServiceId { get; protected set; }

        public Guid IdentityUserId { get; protected set; }

        private ServiceIdentityUser()
        {

        }

        public ServiceIdentityUser(int serviceId, Guid identityUserId)
        {
            ServiceId = serviceId;
            IdentityUserId = identityUserId;
        }

        public override object[] GetKeys()
        {
            return new object[]
                {
                    ServiceId,
                    IdentityUserId
                };
        }
    }
}