georgeakpan233

Honestly, this is the first time I am seeing this. I have not seen a situation where userId is inserted into two separate columns of the same table (UserId, CreatedBy)

I recommend using ASP.NET Identity to handle user account management.   Assign Users and Administrators roles.   Use claims to designate the User's Wallet Id.  Craft a table or update the user table to store the admin Id.

All this information will follow the user after a successful login which should make your business logic much easier to implement.

https://docs.microsoft.com/en-us/aspnet/identity/overview/getting-started/introduction-to-aspnet-identity

https://docs.microsoft.com/en-us/aspnet/core/security/authentication/identity?view=aspnetcore-3.1&tabs=visual-studio