public void Insert(IdentityMember member, int roleId) { this.db.Connection.Execute("Insert into AspNetUserRoles (UserId, RoleId) values (@userId, @roleId)", (object)new { userId = member.Id, roleId = roleId }, (IDbTransaction)null, new int?(), new CommandType?()); }
public void Delete(IdentityMember member, UserLoginInfo login) { this.db.Connection.Execute("Delete from AspNetUserLogins \r\n where UserId = @userId \r\n and LoginProvider = @loginProvider \r\n and ProviderKey = @providerKey", (object)new { userId = member.Id, loginProvider = login.LoginProvider, providerKey = login.ProviderKey }, (IDbTransaction)null, new int?(), new CommandType?()); }
public void Insert(IdentityMember member, UserLoginInfo login) { this.db.Connection.Execute("Insert into AspNetUserLogins \r\n (LoginProvider, ProviderKey, UserId) \r\n values (@loginProvider, @providerKey, @userId)", (object)new { loginProvider = login.LoginProvider, providerKey = login.ProviderKey, userId = member.Id }, (IDbTransaction)null, new int?(), new CommandType?()); }
public void Delete(IdentityMember member, Claim claim) { this.db.Connection.Execute("Delete from AspNetUserClaims \r\n where UserId = @memberId and @ClaimValue = @value and ClaimType = @type", (object)new { memberId = member.Id, ClaimValue = claim.Value, type = claim.Type }, (IDbTransaction)null, new int?(), new CommandType?()); }
/// <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 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) { using (var connection = DbConnectionFactory.GetOpenConnection()) { 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 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) { using (var connection = DbConnectionFactory.GetOpenConnection()) { 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> /// 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) { using (var connection = DbConnectionFactory.GetOpenConnection()) { connection.Execute(@" Delete from MemberLogin where UserId = @userId and LoginProvider = @loginProvider and ProviderKey = @providerKey", new { userId = member.Id, loginProvider = login.LoginProvider, providerKey = login.ProviderKey }); } }
public async Task Insert(IdentityMember user, int roleId) { using (var connection = await DbConnectionFactory.GetOpenConnectionAsync()) { await connection.ExecuteAsync($@" INSERT INTO {TableConstants.UserRoleTable} ( UserId, RoleId ) VALUES ( @UserId, @RoleId );", new { UserId = user.Id, RoleId = roleId } ); } }
/// <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 }); }
/// <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 (@MemberId, @RoleId)", new { MemberId = member.Id, RoleId = roleId }); }