USP_DATAFORMTEMPLATE_EDIT_REGISTRANTPRIVACYSETTING

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ISPRIVATE	bit	IN
@ALLOWADMINACCESSHQ	bit	IN
@ALLOWOTHERPARTICIPANTSCONTACTME	bit	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_REGISTRANTPRIVACYSETTING
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @ISPRIVATE bit,
    @ALLOWADMINACCESSHQ bit,
  @ALLOWOTHERPARTICIPANTSCONTACTME bit
)
as

    set nocount on;

    if @CHANGEAGENTID is null  
        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

    begin try

        -- handle updating the data        
        update dbo.REGISTRANTEXTENSION set
            ISPRIVATE = @ISPRIVATE,
            ALLOWADMINACCESSHQ = @ALLOWADMINACCESSHQ,
      ALLOWOTHERPARTICIPANTSCONTACTME = @ALLOWOTHERPARTICIPANTSCONTACTME,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = getdate()
        where REGISTRANTID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

return 0;