USE [site_fuchs]
GO
/****** Object:  StoredProcedure [dbo].[ocms_admin_createUserAccount]    Script Date: 02.12.2020 21:05:05 ******/
DROP PROCEDURE [dbo].[ocms_admin_createUserAccount]
GO
/****** Object:  StoredProcedure [dbo].[ocms_admin_createUserAccount]    Script Date: 02.12.2020 21:05:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date, ,>
-- Description:	<Description, ,>
-- =============================================
CREATE PROCEDURE [dbo].[ocms_admin_createUserAccount]
	@name nvarchar(255)
	,@email varchar(255)
	,@mobile varchar(50)
	,@password nvarchar(20)
	,@enc_key uniqueidentifier
AS
BEGIN
	SET NOCOUNT ON;

    DECLARE @utcnow datetime = GETUTCDATE();

	INSERT INTO [dbo].[ocms_useraccounts]
           ([useraccount_id]
           ,[name_enc]
           ,[email_enc]
           ,[mobile_enc]
           ,[password_enc]
           ,[UserDisabled]
           ,[DateDisabled]
           ,[UserCreated]
           ,[DateCreated]
           ,[UserModified]
           ,[DateModified]
           ,[UserDeleted]
           ,[DateDeleted])
	 OUTPUT inserted.[useraccount_id]
     VALUES
           ([dbo].[ocms_fn_useraccount_id] ()
           ,ENCRYPTBYKEY(@enc_key, @name)
           ,ENCRYPTBYKEY(@enc_key, @email)
           ,ENCRYPTBYKEY(@enc_key, @mobile)
           ,CASE WHEN @password is null then null ELSE ENCRYPTBYKEY(@enc_key, @password) END
           ,NULL  --[UserDisabled]
           ,NULL  --[DateDisabled]
           ,'sa'
           ,@utcnow
           ,'sa'
           ,@utcnow
           ,NULL
           ,NULL);

END
GO
ALTER AUTHORIZATION ON [dbo].[ocms_admin_createUserAccount] TO  SCHEMA OWNER 
GO