/// <summary> /// Deletes a claim from a user /// </summary> /// <param name="user">The user to have a claim deleted</param> /// <param name="claim">A claim to be deleted from user</param> /// <returns>void</returns> public void Delete(IdentityMember member, Claim claim) { db.Connection.Execute(@"Delete from IdentityUserClaims where UserID = @memberId and @ClaimValue = @value and ClaimType = @type" , new { memberId = member.Id, ClaimValue = claim.Value, type = claim.Type }); }
/// <summary> /// Inserts a new login in the UserLogins table /// </summary> /// <param name="user">User to have new login added</param> /// <param name="login">Login to be added</param> /// <returns></returns> public void Insert(IdentityMember member, UserLoginInfo login) { db.Connection.Execute(@"Insert into IdentityUserLogins (LoginProvider, ProviderKey, UserID) values (@loginProvider, @providerKey, @userId)" , new { loginProvider = login.LoginProvider, providerKey = login.ProviderKey, userId = member.Id }); }
/// <summary> /// Deletes a login from a user in the UserLogins table /// </summary> /// <param name="user">User to have login deleted</param> /// <param name="login">Login to be deleted from user</param> /// <returns></returns> public void Delete(IdentityMember member, UserLoginInfo login) { db.Connection.Execute(@"Delete from IdentityUserLogins where UserID = @userId and LoginProvider = @loginProvider and ProviderKey = @providerKey" , new { userId = member.Id, loginProvider = login.LoginProvider, providerKey = login.ProviderKey }); }
/// <summary> /// Inserts a new role for a user in the UserRoles table /// </summary> /// <param name="user">The User</param> /// <param name="roleId">The Role's id</param> /// <returns></returns> public void Insert(IdentityMember member, int roleId) { db.Connection.Execute(@"Insert into AspNetUserRoles (UserId, RoleId) values (@userId, @roleId", new { userId = member.Id, roleId = roleId }); }