/// <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 InsertMultiple(IdentityMember member, List <int> roleIds)
{
foreach (var Id in roleIds)
{
db.Connection.Execute(@"INSERT INTO MemberRole (MemberId, RoleId) VALUES (@userId, @roleId)",
new { userId = member.Id, roleId = Id });
}
}
/// <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></returns>
public void Delete(IdentityMember member, Claim claim)
{
db.Connection.Execute(@"Delete from MemberClaim
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 MemberLogin
(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 MemberLogin
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 MemberRole (MemberId, RoleId) VALUES (@userId, @roleId)",
new { userId = member.Id, roleId = roleId });
}
