USP_DATAFORMTEMPLATE_PRELOAD_ADD_INVITATION

The load procedure used by the edit dataform template "Invitation Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@EVENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@EVENTNAME	nvarchar(100)	INOUT	Event
@BUSINESSPROCESSOUTPUTDATALISTIDS	xml	INOUT
@ADDRESSPROCESSINGOPTIONID	uniqueidentifier	INOUT	Address processing
@NAMEFORMATPARAMETERID	uniqueidentifier	INOUT	Name format

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_INVITATION
(
  @EVENTID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
  @EVENTNAME nvarchar(100) = null output,
  @BUSINESSPROCESSOUTPUTDATALISTIDS xml = null output,
  @ADDRESSPROCESSINGOPTIONID uniqueidentifier = null output,
  @NAMEFORMATPARAMETERID uniqueidentifier = null output
)
as
  set nocount on;

  select
    @EVENTNAME = EVENT.NAME
  from dbo.EVENT
  where EVENT.ID = @EVENTID;

  select top(1) 
    @ADDRESSPROCESSINGOPTIONID = ADDRESSPROCESSINGOPTION.ID 
  from dbo.[ADDRESSPROCESSINGOPTION] 
  where [ISDEFAULT] = 1 
    and dbo.[UFN_SITEALLOWEDFORUSER](@CURRENTAPPUSERID, ADDRESSPROCESSINGOPTION.SITEID) = 1;

  select top(1) 
    @NAMEFORMATPARAMETERID = [ID] 
  from dbo.[NAMEFORMATPARAMETER] 
  where NAMEFORMATPARAMETER.ISDEFAULT = 1 
    and dbo.UFN_SITEALLOWEDFORUSER(@CURRENTAPPUSERID, NAMEFORMATPARAMETER.SITEID) = 1;

  -- Output formats are no longer being used for invitations

  --select @BUSINESSPROCESSOUTPUTDATALISTIDS = dbo.UFN_BUSINESSPROCESS_GETBUSINESSPROCESSVIEWANDDATALIST_TOITEMLISTXML('InvitationProcesses');


  return 0;