USP_DATAFORMTEMPLATE_PROSPECT_PLANNEDGIFT_ADD_LOAD

The load procedure used by the edit dataform template "Prospect Planned Gift Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ISORGANIZATION	bit	INOUT
@SSN	nvarchar(36)	INOUT	SSN
@CONSTITUENTLOOKUPID	nvarchar(36)	INOUT
@CONSTITUENTFIRSTNAME	nvarchar(50)	INOUT
@CONSTITUENTKEYNAME	nvarchar(100)	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEREQUIRED	bit	INOUT	Site required
@BASECURRENCYID	uniqueidentifier	INOUT	Base currency
@TRANSACTIONCURRENCYID	uniqueidentifier	INOUT	Transaction currency
@SITES	xml	INOUT	Sites
@ISANONYMOUS	bit	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_PROSPECT_PLANNEDGIFT_ADD_LOAD (
  @CONSTITUENTID uniqueidentifier,
  @ISORGANIZATION bit = null output,
  @SSN nvarchar(36) = null output,
  @CONSTITUENTLOOKUPID nvarchar(36) = null output,
  @CONSTITUENTFIRSTNAME nvarchar(50) = null output,
  @CONSTITUENTKEYNAME nvarchar(100) = null output,
  @CURRENTAPPUSERID uniqueidentifier = null,
  @SITEREQUIRED bit = null output,
  @BASECURRENCYID uniqueidentifier = null output,
  @TRANSACTIONCURRENCYID uniqueidentifier = null output,
  @SITES xml = null output,
  @ISANONYMOUS bit = null output
) as
  set nocount on;

  select
    @CONSTITUENTLOOKUPID = C.LOOKUPID,
    @CONSTITUENTFIRSTNAME = C.FIRSTNAME,
    @CONSTITUENTKEYNAME = C.KEYNAME,
    @ISORGANIZATION = case when O.ID is null then 0 else 1 end,
    @SSN = N'', /* C.SSN */
  @ISANONYMOUS = C.GIVESANONYMOUSLY
  from
    dbo.CONSTITUENT C
    left outer join dbo.ORGANIZATIONDATA O on O.ID=C.ID
  where
    C.ID = @CONSTITUENTID;

  set @SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID);
  set @BASECURRENCYID = dbo.UFN_APPUSER_GETBASECURRENCY(@CURRENTAPPUSERID);
  set @TRANSACTIONCURRENCYID = @BASECURRENCYID;

  declare @USERSITEID uniqueidentifier = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID)
  if @USERSITEID is not null
  begin
    set @SITES = (
      select newid() ID, @USERSITEID SITEID
      for xml raw('ITEM'),type,elements,root('SITES'),BINARY BASE64
    )
  end

  return 0;