Don't like ads? PRO users don't see any ads ;-)
Guest

Untitled

By: a guest on Aug 1st, 2012  |  syntax: None  |  size: 1.23 KB  |  hits: 14  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. Update aspnet membership password answer
  2. user.ChangePasswordQuestionAndAnswer(password, question, answer);
  3.        
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER OFF
  7. GO
  8. ALTER PROCEDURE [dbo].[aspnet_Membership_ChangePasswordQuestionAndAnswer]
  9.     @ApplicationName       nvarchar(256),
  10.     @UserName              nvarchar(256),
  11.     @NewPasswordQuestion   nvarchar(256),
  12.     @NewPasswordAnswer     nvarchar(128)
  13. AS
  14. BEGIN
  15.    DECLARE @UserId uniqueidentifier
  16.    SELECT  @UserId = NULL
  17.    SELECT  @UserId = u.UserId
  18.    FROM    dbo.aspnet_Membership m, dbo.aspnet_Users u, dbo.aspnet_Applications a
  19.    WHERE   LoweredUserName = LOWER(@UserName) AND
  20.         u.ApplicationId = a.ApplicationId  AND
  21.         LOWER(@ApplicationName) = a.LoweredApplicationName AND
  22.         u.UserId = m.UserId
  23.    IF (@UserId IS NULL)
  24.    BEGIN
  25.       RETURN(1)
  26.    END
  27.  
  28.    UPDATE dbo.aspnet_Membership
  29.      SET    PasswordQuestion = @NewPasswordQuestion, PasswordAnswer = @NewPasswordAnswer
  30.     WHERE  UserId=@UserId
  31.    RETURN(0)
  32.    END
  33.        
  34. public virtual bool ChangePassword(string oldPassword, string newPassword)
  35.        
  36. string newPassword = user.ResetPassword();
  37. user.ChangePassword(newPassword, "SOMENEWPASSWORD");
  38.        
  39. user.ChangePasswordQuestionAndAnswer("SOMENEWPASSWORD", question, answer);