what are the IDENTITY counterparts to these outdated SQL-membership functions [Answered]RSS

• • Reply
  RateFor

  Member

  45 Points

  80 Posts

  what are the IDENTITY counterparts to these outdated SQL-membership functions

  Feb 22, 2018 11:00 AM|RateFor|LINK

  The following are all SQL-Membership functions that I have been using in my website.   I now want to port to IDENTITY, but I don't know what to replace them with:

  Roles.GetRolesForUser(username) returns list
  Roles.AddUserToRole(username,role)
  Roles.removeUserFromRole(username,role)
  Roles.IsUserInRole("zowner")
  membership.getuser()
  Membership.getallusers()
  Membership.deleteuser(username)
  email - Membership.getusernamebyemail(username)
  Membership.getcreateusererrormessage
  Membership.generatepassword
  Membership.createuser()
  Membership.validateuser(username,password
  Membership.getuser().username
  Membership.updateuser(newusers)
  getuser(username).isapproved
  Membership.enablepassword
  FormsAuthentication.signout()
  FormsAuthentication.timeout.totalminutes
  FormsAuthentication.requireSSL
  FormsAuthentication.RedirectToLoginPage

  My question is, are there IDENTITY counterparts to these, and if so, how do I look them up?

• • Reply
  mgebhard

  All-Star

  39431 Points

  16281 Posts

  Re: what are the IDENTITY counterparts to these outdated SQL-membership functions

  Feb 22, 2018 12:16 PM|mgebhard|LINK

  RateFor

  My question is, are there IDENTITY counterparts to these, and if so, how do I look them up?

  Identity is just an API that provides access data stores.  You need to read the reference docs.

  https://www.asp.net/identity

  The main APIs are the UserManager and SignInManager.  

  UserManager

  https://msdn.microsoft.com/en-us/library/dn613290(v=vs.108).aspx

  SignInManager

  https://msdn.microsoft.com/en-us/library/dn896559(v=vs.108).aspx

• • Reply
  Brando ZWZ

  Star

  9241 Points

  2850 Posts

  Re: what are the IDENTITY counterparts to these outdated SQL-membership functions

  Feb 23, 2018 02:25 AM|Brando ZWZ|LINK

  Hi RateFor,

  RateFor

  The following are all SQL-Membership functions that I have been using in my website.   I now want to port to IDENTITY, but I don't know what to replace them with:

  According to your description, not all membership function could be mapped in the identity. 

  I suggest you could refer to below codes:

  Roles.GetRolesForUser(username) returns list
  -------------
  public async string GetUserRole(string EmailID, string Password)
  {
      var user = await _userManager.FindAsync(EmailID, Password);
      string rolename = await _userManager.GetRoles(user.Id).FirstOrDefault();
      return rolename;
  }

  Roles.AddUserToRole(username,role)
  -----------
      internal void AddUserToRole(string userName, string roleName)
      {
          var UserManager = new UserManager<ApplicationUser>(new UserStore<ApplicationUser>(context));
  
          try
          {
              var user = UserManager.FindByName(userName);
              UserManager.AddToRole(user.Id, roleName);
              context.SaveChanges();
          }
          catch
          {
              throw;
          }
      }

  Roles.removeUserFromRole(username,role)
  ------------------
  public async Task DeleteRolesAsync(List<string> deleteList, int? userId)
  {
      if (userId != null)
      {
          foreach (var roleName in deleteList)
          {
              IdentityResult deletionResult = await UserManager.RemoveFromRoleAsync(userId, roleName);
          }
      }
  }

  Roles.IsUserInRole("zowner")
  -------------
  User.IsInRole("rolename");
  

  membership.getuser()
  ------------
  var user = UserManager.FindById(User.Identity.GetUserId());

  Membership.getallusers()
  ---------------
  //Use EF
  UsersContext = new ApplicationDbContext();
  ...
  UsersContext.Users.ToList();

  Membership.deleteuser(username)
  ----
   await _userManager.DeleteAsync(user);

  email - Membership.getusernamebyemail(username)
  -------------
  ApplicationUser user = UserManager.FindByName(userName);
  string mail= user.Email;

  Membership.createuser()
  ----------------
  var user = model.GetUser();
  var result = await UserManager.CreateAsync(user, model.Password);
  
  if (result.Succeeded)
      result = UserManager.AddToRole(user.Id, "User");

  Membership.updateuser(newusers)
  -----------------
  // Get the existing student from the db
  var user = (Student)UserManager.FindById(model.Id);
  
  // Update it with the values from the view model
  user.Name = model.Name;
  user.Surname = model.Surname;
  user.UserName = model.UserName;
  user.Email = model.Email;
  user.PhoneNumber = model.PhoneNumber;
  user.Number = model.Number; //custom property
  user.PasswordHash = checkUser.PasswordHash;
  
  // Apply the changes if any to the db
  UserManager.Update(user);
  

  Best Regards,

  Brando

  MSDN Community Support
  Please remember to click "Mark as Answer" the responses that resolved your issue.
  If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.