--DROP OLD
IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[MetaDataTestInsert]') AND type in (N'P', N'PC'))
	DROP PROCEDURE [dbo].[MetaDataTestInsert]
GO


CREATE PROCEDURE [dbo].[MetaDataTestInsert]
	 @uname						VARCHAR(255) ,
	 @username					VARCHAR(255) ,
	 @codperfil					INT ,
	 @codjefeinm				INT ,
	 @user_active				INT ,
	 @usua_builtin				INT ,
	 @usua_authentication_id	INT
	 AS
BEGIN
	IF EXISTS (SELECT 1 FROM [AFW_USERS]
		WHERE	[user_nick_name] = @username AND
				[user_authentication_id] = @usua_authentication_id AND
				[user_guid_ldap] IS NULL
	)
		UPDATE	[AFW_USERS]
		SET		[user_name] = @uname,
				[user_nick_name]= @username,
				[user_codperfil]= @codperfil,
				[user_chief]=@codjefeinm,
				[user_active]=@user_active,
				[user_builtin]=@usua_builtin,
				[user_authentication_id]=@usua_authentication_id
		WHERE	[user_nick_name] = @username AND
				[user_authentication_id] = @usua_authentication_id AND
				[user_guid_ldap] IS NULL
	ELSE
		INSERT INTO [AFW_USERS](
			[user_name],
			[user_nick_name],
			[user_codperfil],
			[user_chief],
			[user_active],
			[user_builtin],
			[user_authentication_id]
		)VALUES(
			@uname,
			@username,
			@codperfil,
			@codjefeinm,
			@user_active,
			@usua_builtin,
			@usua_authentication_id
		)
END
GO

--METADATA

DECLARE @idAuthAranda INT
SELECT @idAuthAranda = id FROM [AFW_LDAP] WHERE [name] = 'Aranda'

EXEC [dbo].[MetaDataTestInsert] 'APPLICATION ADMINISTRATOR', 'ADMINISTRATOR',1, 1, 1, 0, @idAuthAranda
EXEC [dbo].[MetaDataTestInsert] 'ARANDA SERVICES USER', 'ARANDASERVICESUSER',1, 1, 1, 1, @idAuthAranda

Print 'USUARIOS DONE!!'