/// <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 });
}
