USP_DATAFORMTEMPLATE_VIEW_CONFIRMATIONTEMPLATE

The load procedure used by the view dataform template "ConfirmationTemplateList View Data Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@EVENTID	uniqueidentifier	INOUT	EVENTID
@ISREQUESTLINKON	bit	INOUT	ISREQUESTLINKON
@INTEGRATIONURL	nvarchar(1024)	INOUT	INTEGRATIONURL
@CLIENTSITESID	int	INOUT	CLIENTSITESID
@AID	int	INOUT	AID

Definition

Copy


      CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_CONFIRMATIONTEMPLATE
      (
        @ID uniqueidentifier,
        @CURRENTAPPUSERID uniqueidentifier=null,
          @DATALOADED bit = 0 output,
        @EVENTID uniqueidentifier = null output,
        @ISREQUESTLINKON bit = null output,
        @INTEGRATIONURL nvarchar(1024) = null output,
        @CLIENTSITESID int = null output,
        @AID int = null output
      )
      as 
        set nocount on;        

          set @DATALOADED = 0;

        select 
          @DATALOADED = 1,      
          @EVENTID = @ID,
          @ISREQUESTLINKON = COUNT (EVENTID)
        from dbo.EVENTTEAMFAFCONFIG 
        where EVENTID= @ID AND (HOUSEHOLDAPPROVEBYEVENTADMIN = 1 OR TEAMSREQUESTFUNDRAISE = 1 OR COMPANYTEAMSAPPROVEBYEVENTADMIN = 1)

        set @INTEGRATIONURL = dbo.UFN_BBNC_URL()

        select @CLIENTSITESID = CLIENTSITESID from dbo.EVENTEXTENSION where EVENTID= @ID

        select 
          @AID=cu.ID from dbo.BBNCUSERMAP map
        join dbo.ClientUsers cu on cu.UserName=map.BBNCUSERNAME
        where map.ID=@CURRENTAPPUSERID