I can't find the enums that are mentioned on page 153 of the C# version Wrox.WebModules.Accounts.ProcResultCodes.AccountAl ready on file. Its not detailed in the book as far as I can tell. Can somebody point me in the right direction?

Its in the Core Project, in the Enums.cs file.

Is it just me or is everyone getting errors when trying to sign up using an email account already on file.
The following code on the new.aspx.cs page does not seem to be working for me:
if (newUser.Create() == (int)Wrox.WebModules.Accounts.ProcResultCodes.Acco untAlreadyOnFile)
            {
                CreateError.Text = "<br><br>An account with that e-mail address is already on file.<br>";
                CreateError.Visible = true;
            }


Here is the stack trace:
The error occurred in: http://localhost/ThePhile/Modules/Users/new.aspx
Error Message: Exception of type Wrox.WebModules.AppException was thrown.
--------------------------------------------------------------------------------
Stack Trace:
Wrox.WebModules.AppException: Exception of type Wrox.WebModules.AppException was thrown. at Wrox.WebModules.Accounts.Data.User.Create(String emailAddress, Byte[] password, String firstName, String lastName, String address1, String address2, String city, String state, String zipCode, String homePhone, String country) in C:\wrox\ThePhile\Modules\Accounts\ACCOUNTSDATA\Use r.cs:line 75 at Wrox.WebModules.Accounts.Business.User.Create() in C:\wrox\ThePhile\Modules\Accounts\ACCOUNTSBUSINESS \User.cs:line 66 at Wrox.ThePhile.WebModules.Accounts.Web._new.Registe r_Click(Object sender, EventArgs e) in C:\wrox\ThePhile\Modules\Users\new.aspx.cs:line 108 at System.Web.UI.WebControls.Button.OnClick(EventArgs e) at System.Web.UI.WebControls.Button.System.Web.UI.IPo stBackEventHandler.RaisePostBackEvent(String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(IPostBackEve ntHandler sourceControl, String eventArgument) at System.Web.UI.Page.RaisePostBackEvent(NameValueCol lection postData) at System.Web.UI.Page.ProcessRequestMain()

Any Ideas,
Thanks,
d.

Did you ever figure this out??

I am having the same problem.

Thanks

-JP

JP I actually did my own mod to get this working.

1st) I changed the sp_Accouns_CreateUser stored procedure, However, don't copy exactly because I have added columns to my User table like Gender


CREATE PROCEDURE sp_Accounts_CreateUser
@EmailAddress varchar(255),
@Password binary(50),
@FirstName varchar(30),
@LastName varchar(50),
@Address1 varchar(80),
@YearofBirth varchar(10),
@City varchar(40),
@State varchar(2),
@ZipCode varchar(10),
@HomePhone varchar(14),
@Country varchar(50),
@Gender varchar(6),
@UserID int output
AS
    DECLARE @NewUserID int

    SELECT @UserID = UserID FROM Accounts_Users WHERE EmailAddress = @EmailAddress

    IF @@RowCount = 0
    BEGIN
    INSERT INTO Accounts_Users(EmailAddress, Password, FirstName, LastName, Address1, YearofBirth,
        City, State, ZipCode, HomePhone, Country, Gender)
    VALUES(@EmailAddress, @Password, @FirstName, @LastName, @Address1, @YearofBirth,
        @City, @State, @ZipCode, @HomePhone, @Country, @Gender)

    SET @NewUserID = @@IDENTITY
    END
    ELSE
    BEGIN
        SET @NewUserID = -1
    END


    Set @UserID = @NewUserID
GO


2nd) In the new.cs file I made the following change

//if (newUser.Create() == (int Wrox.WebModules.Accounts.ProcResultCodes.AccountAl readyOnFile)
                // == -1 is from the stored procedure
                if (newUser.Create() == -1)
                {
                    CreateError.Text = "<br><br>An account with that e-mail address already exists. Please choose a different Email Address.<br>";
                    CreateError.Visible = true;
                }

                else
                {
                    FormsAuthentication.SetAuthCookie( EmailAddress.Text, true );
                    Response.Redirect("congrats.aspx");
                }

3rd)
I added a CreateError asp.net label on the aspx page
---------------------------------------------------------

I think thats it. If not I'm not sure what else I did, but it works for me. Hopefully this helps.

Take care,
d.