USP_DATAFORMTEMPLATE_VIEW_FAFWEBSITEFORMS

The load procedure used by the view dataform template "FAF website forms"

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.
@USERID	int	INOUT	USERID
@REGFORMLINK	nvarchar(1024)	INOUT	REGFORMLINK
@DONFORMLINK	nvarchar(1024)	INOUT	DONFORMLINK
@SPONFORMLINK	nvarchar(1024)	INOUT	SPONFORMLINK
@CONTACTFORMLINK	nvarchar(1024)	INOUT	CONTACTFORMLINK
@PROFILEFORMLINK	nvarchar(1024)	INOUT	PROFILEFORMLINK
@PREFERENCESFORMLINK	nvarchar(1024)	INOUT	PREFERENCESFORMLINK

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FAFWEBSITEFORMS
(
    @ID uniqueidentifier,
  @CURRENTAPPUSERID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @USERID int = null output,
    @REGFORMLINK nvarchar(1024) = null output,
  @DONFORMLINK nvarchar(1024) = null output,
  @SPONFORMLINK nvarchar(1024) = null output,
  @CONTACTFORMLINK nvarchar(1024) = null output,
  @PROFILEFORMLINK nvarchar(1024) = null output,
  @PREFERENCESFORMLINK nvarchar(1024) = null output
)
as
    set nocount on;

  declare @INTEGRATIONURL nvarchar(200),
          @CLIENTSITESID int,
          @CONNECTURL nvarchar(512)


    -- be sure to set this, in case the select returns no rows
    set @DATALOADED = 0;

  select @CLIENTSITESID=CLIENTSITESID, @INTEGRATIONURL = dbo.UFN_BBNC_URL(), @USERID=dbo.UFN_BBNCUSERMAP_GETBBNCUSERID(@CURRENTAPPUSERID) from dbo.EVENTEXTENSION where EVENTID = @ID
  set @CONNECTURL = @INTEGRATIONURL + 'sslautolog.ashx?edit=3&md=1&cid=1&hbc=1&ctid=998&siteid=' + cast(@CLIENTSITESID as nvarchar(5)) + '&s=' + cast(@USERID as nvarchar(5)) + + '&crg=' + cast(@ID as nvarchar(40))

    select @DATALOADED = 1,
         @REGFORMLINK = @CONNECTURL + '&formID=' + case when REGNEW.ID is not null then cast(REGNEW.ID as nvarchar(40)) else cast(REG.ID as nvarchar(40)) end,
         @SPONFORMLINK = @CONNECTURL + '&formID=' + cast(SPON.ID as nvarchar(40)), 
         @DONFORMLINK =  @CONNECTURL + '&formID=' + cast(DON.ID as nvarchar(40)), 
         @CONTACTFORMLINK = @CONNECTURL + '&formID=' + cast(CONTACT.ID as nvarchar(40)), 
         @PROFILEFORMLINK = @CONNECTURL + '&formID=' + cast(PROF.ID as nvarchar(40)), 
         @PREFERENCESFORMLINK = @CONNECTURL + '&formID=' + cast(PREF.ID as nvarchar(40))
  from dbo.EVENTEXTENSION EX
  left join dbo.APEXFORM REG ON EX.CLIENTSITESID = REG.SITEID AND REG.FORMTYPEID = '34C019D8-9CD0-4321-9778-09BD145A3E57'
  left join dbo.APEXFORM REGNEW ON EX.CLIENTSITESID = REGNEW.SITEID AND REGNEW.FORMTYPEID = '0B29CBAA-0B53-47CC-B6B9-B96311299584' and REGNEW.NAME not like '%Mobile%'
  left join dbo.APEXFORM SPON ON EX.CLIENTSITESID = SPON.SITEID and SPON.FORMTYPEID = '59F07A4F-FE97-47D9-A197-B430E8BCBC1C'
  left join dbo.APEXFORM DON ON EX.CLIENTSITESID = DON.SITEID and DON.FORMTYPEID = '33BE06AD-F3EF-46C9-A002-3DD13790737E' and DON.NAME not like '%Mobile%'
  left join dbo.APEXFORM CONTACT ON EX.CLIENTSITESID = CONTACT.SITEID and CONTACT.FORMTYPEID = '644EBCF1-15B1-4B24-AD45-AF1A63A9CBEE'
  left join dbo.APEXFORM PROF ON EX.CLIENTSITESID = PROF.SITEID and PROF.FORMTYPEID = '714FB1BE-4A9D-4CA1-B819-8B5B562037A1'
  left join dbo.APEXFORM PREF ON EX.CLIENTSITESID = PREF.SITEID and PREF.FORMTYPEID = '89D3C4CC-4D01-4E8B-B82E-04AD966EEE09'
  where EX.EVENTID = @ID


    return 0;