ALTER PROCEDURE dbo.AddNewUser2 
	@Username varchar(50),
	@FirstName varchar(50),
	@LastName varchar(50),
	@Residence varchar(50),
	@Country varchar(50),
	@CurrentAge int,
	@Email varchar(50),
	@Favourites varchar(MAX),
	@Interests varchar(MAX),
	@Password nvarchar(50),
	@IPAddress nchar(15)
	
	AS
		declare @result int
		--first make sure this is a valid new user
		--username must be unique
		if exists (select 1 from Userregistration where Username = @Username) begin
			set @result = -1
		end else begin
		
		INSERT  Userregistration (Username, FirstName, LastName, Residence, Country, CurrentAge, 
						Email, Favourites, Interests, Password, IPAddress, DateOfRegistration)
		VALUES (@Username, @FirstName, @LastName, @Residence, @Country, @CurrentAge, @Email,
						 @Favourites, @Interests, @Password, @IPAddress, GetDate()) 

	select @Username, @Password
	
	set @result = @@identity

END

	select result = @result
RETURN @result	

string connectString = @"Data Source=.\\SQLEXPRESS;Initial Catalog=f_new;AttachDBFilename=|DataDirectory|MySample.mdf;Integrated Security=True";