USP_DATAFORMTEMPLATE_PLANNEDGIFT_ADD_LOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@CONTEXT_PROSPECTPLANID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@ISORGANIZATION	bit	INOUT
@PROSPECTID	uniqueidentifier	INOUT
@PROSPECTPLANID	uniqueidentifier	INOUT	Prospect plan
@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_PLANNEDGIFT_ADD_LOAD (
  @CONTEXT_PROSPECTPLANID uniqueidentifier,
  @ISORGANIZATION bit = null output,
  @PROSPECTID uniqueidentifier = null output,
  @PROSPECTPLANID uniqueidentifier = 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,
    @PROSPECTID = PP.PROSPECTID,
    @PROSPECTPLANID = @CONTEXT_PROSPECTPLANID,
    @SSN = N'' /* C.SSN */,
    @BASECURRENCYID = PP.BASECURRENCYID,
    @ISANONYMOUS = C.GIVESANONYMOUSLY
  from
    dbo.PROSPECTPLAN PP
    inner join dbo.CONSTITUENT C on C.ID=PP.PROSPECTID
    left outer join dbo.ORGANIZATIONDATA O on O.ID=PP.PROSPECTID
  where
    PP.ID = @CONTEXT_PROSPECTPLANID;

  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;