USP_ADDUPDATE_CONSENTOPTION

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@ContentID	int	IN
@Caption	nvarchar(1024)	IN
@Sequence	int	IN
@IsRequired	bit	IN
@SolicitCodeID	uniqueidentifier	IN
@ConsentCode	tinyint	IN
@Name	nvarchar(200)	IN
@SiteID	uniqueidentifier	IN
@ChannelCode	tinyint	IN
Definition

Copy



CREATE procedure dbo.USP_ADDUPDATE_CONSENTOPTION
(
        @ID uniqueidentifier output,
        @ContentID int,
        @Caption nvarchar(1024) = '',
        @Sequence int,
        @IsRequired bit = 0,
        @SolicitCodeID uniqueidentifier = null,
        @ConsentCode tinyint = null,
        @Name nvarchar(200) = '',
        @SiteID uniqueidentifier = null,
        @ChannelCode tinyint = null
)
as

declare @CHANGEAGENTID UNIQUEIDENTIFIER;
exec dbo.Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID OUTPUT;

declare @DATE datetime
set @DATE = Getdate()

merge into CONSENTOPTION AS TARGET
using (select @ID as ID) AS SOURCE
on(Source.ID = Target.ID)
when MATCHED then 
update set 
                CONTENTID = @ContentID ,
                         CAPTION  = @Caption ,
                         SEQUENCE  = @Sequence ,
                         ISREQUIRED  = @IsRequired ,
                         CHANGEDBYID  = @CHANGEAGENTID ,
                         DATECHANGED   = @DATE,
                         SOLICITCODEID = @SolicitCodeID,
                         CONSENTCODE = @ConsentCode,
                         CONSENTNAME = @Name,
                         SITEID = @SiteID,
                         CHANNELCODE = @ChannelCode
when not matched by TARGET
then insert (
                                         ID,
                                         CONTENTID,
                                         CAPTION ,
                                         SEQUENCE ,
                                         ISREQUIRED,
                                         [ADDEDBYID],
                                         [CHANGEDBYID],
                                         [DATEADDED],
                                         [DATECHANGED],
                                         [SOLICITCODEID],
                                         [CONSENTCODE],
                                         [CONSENTNAME],
                                         [SITEID],
                                         [CHANNELCODE]
                            )
                            values
                            (
                                         @ID,
                                         @ContentID ,
                                         @Caption ,
                                         @Sequence ,
                                         @IsRequired,
                                         @CHANGEAGENTID,
                                         @CHANGEAGENTID,
                                         @DATE,
                                         @DATE,
                                         @SolicitCodeID,
                                         @ConsentCode,
                                         @Name,
                                         @SiteID,
                                         @ChannelCode
                            );