/// <summary> /// Deletes all roles from a user in the AspNetUserRoles table. /// </summary> /// <param name="userId">The user's id.</param> /// <returns></returns> public int Delete(string userId) { string commandText = "DELETE FROM AspNetRoles WHERE UserId = @userId"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("UserId", userId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Sets the user's password hash. /// </summary> /// <param name="userId"></param> /// <param name="passwordHash"></param> /// <returns></returns> public int SetPasswordHash(string userId, string passwordHash) { string commandText = "UPDATE " + _tableName + " SET PasswordHash = @pwdHash WHERE Id = @id"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("@pwdHash", passwordHash); parameters.Add("@id", userId); return(_database.Execute(commandText, parameters)); }
public int Insert(Claim roleClaim, string roleId) { string commandText = "INSERT INTO AspNetRoleClaims (ClaimValue, ClaimType, RoleId) VALUES (@value, @type, @roleId)"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("value", roleClaim.Value); parameters.Add("type", roleClaim.Type); parameters.Add("roleId", roleId); return(_database.Execute(commandText, parameters)); }
/// <summary> /// Deletes a login record 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 int Delete(string userId, string loginProvider, string providerKey) { string commandText = "DELETE FROM AspNetUserLogins WHERE UserId = @userId AND LoginProvider = @loginProvider AND ProviderKey = @providerKey"; Dictionary <string, object> parameters = new Dictionary <string, object>(); parameters.Add("UserId", userId); parameters.Add("loginProvider", loginProvider); parameters.Add("providerKey", providerKey); return(_database.Execute(commandText, parameters)); }