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