USP_DATAFORMTEMPLATE_ADD_PLEDGEBYCONSTITUENT

The save procedure used by the add dataform template "Pledge Add By Constituent Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@DATE	datetime	IN	Date
@AMOUNT	money	IN	Amount
@POSTSTATUSCODE	tinyint	IN	Post status
@POSTDATE	datetime	IN	Post date
@SENDPLEDGEREMINDER	bit	IN	Send pledge reminders
@SPLITS	xml	IN	Designations
@FREQUENCYCODE	tinyint	IN	Frequency
@NUMBEROFINSTALLMENTS	int	IN	No. installments
@STARTDATE	datetime	IN	Starting on
@INSTALLMENTS	xml	IN
@AUTOPAY	bit	IN	Pay installments automatically by
@PAYMENTMETHODCODE	tinyint	IN	Payment method
@CARDHOLDERNAME	nvarchar(255)	IN	Cardholder name
@CREDITCARDNUMBER	nvarchar(20)	IN	Card number
@CREDITTYPECODEID	uniqueidentifier	IN	Card type
@EXPIRESON	UDT_FUZZYDATE	IN	Expires on
@REFERENCEDATE	UDT_FUZZYDATE	IN	Reference date
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@CONSTITUENTACCOUNTID	uniqueidentifier	IN	Account
@FINDERNUMBER	bigint	IN	Finder number
@SOURCECODE	nvarchar(50)	IN	Source code
@APPEALID	uniqueidentifier	IN	Appeal
@BENEFITS	xml	IN	Benefits
@BENEFITSWAIVED	bit	IN	Benefits waived
@GIVENANONYMOUSLY	bit	IN	Pledge is anonymous
@MAILINGID	uniqueidentifier	IN	Effort
@CHANNELCODEID	uniqueidentifier	IN	Inbound channel
@DONOTACKNOWLEDGE	bit	IN	Do not acknowledge
@PLEDGESUBTYPEID	uniqueidentifier	IN	Subtype
@OPPORTUNITYID	uniqueidentifier	IN	Opportunity
@REFERENCE	nvarchar(255)	IN	Reference
@CATEGORYCODEID	uniqueidentifier	IN	Revenue category
@CREDITCARDTOKEN	uniqueidentifier	IN	Credit card token
@STANDINGORDERSETUP	bit	IN	Standing order has been setup
@STANDINGORDERSETUPDATE	datetime	IN	Setup on
@DDISOURCECODEID	uniqueidentifier	IN	DDI source
@DDISOURCEDATE	date	IN	DDI source date
@PERCENTAGEBENEFITS	xml	IN	Benefits

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLEDGEBYCONSTITUENT 
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier,
  @DATE datetime,
  @AMOUNT money,
  @POSTSTATUSCODE tinyint = 1,
  @POSTDATE datetime = null,
  @SENDPLEDGEREMINDER bit = 1,
  @SPLITS xml,
  @FREQUENCYCODE tinyint = 5,
  @NUMBEROFINSTALLMENTS int = 1,
  @STARTDATE datetime = null,
  @INSTALLMENTS xml,
  @AUTOPAY bit = 0,
  @PAYMENTMETHODCODE tinyint = 2,
  @CARDHOLDERNAME nvarchar(255) = '',
  @CREDITCARDNUMBER nvarchar(20) = '',
  @CREDITTYPECODEID uniqueidentifier = null,
  @EXPIRESON dbo.UDT_FUZZYDATE = '00000000',
  @REFERENCEDATE dbo.UDT_FUZZYDATE = '00000000',
  @REFERENCENUMBER nvarchar(20) = '',
  @CONSTITUENTACCOUNTID uniqueidentifier = null,
  @FINDERNUMBER bigint = null,
  @SOURCECODE nvarchar(50) = null,
  @APPEALID uniqueidentifier = null,
  @BENEFITS xml = null,
  @BENEFITSWAIVED bit = 0,
  @GIVENANONYMOUSLY bit = null,
  @MAILINGID uniqueidentifier = null,
  @CHANNELCODEID uniqueidentifier = null,
  @DONOTACKNOWLEDGE bit = 0,
  @PLEDGESUBTYPEID uniqueidentifier = null,
  @OPPORTUNITYID uniqueidentifier = null,
  @REFERENCE nvarchar(255) = null,
  @CATEGORYCODEID uniqueidentifier = null,
  @CREDITCARDTOKEN  uniqueidentifier = null,
  @STANDINGORDERSETUP bit = 0,
  @STANDINGORDERSETUPDATE datetime = null,
  @DDISOURCECODEID uniqueidentifier = null,
  @DDISOURCEDATE date = null, 
  @PERCENTAGEBENEFITS xml = null
)

as
begin
  set nocount on;

  if @ID is null
    set @ID = NewID();

  if @CHANGEAGENTID is null
    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

  declare @r int;
  declare @SPLITSDECLININGGIFTAID xml;
  exec @r = dbo.USP_PLEDGE_ADD
      @ID output,
      @CHANGEAGENTID,
      @CONSTITUENTID,
      @DATE,
      @AMOUNT,
      @POSTSTATUSCODE,
      @POSTDATE,
      @SENDPLEDGEREMINDER,
      @SPLITS,
      @FREQUENCYCODE,
      @NUMBEROFINSTALLMENTS,
      @STARTDATE,
      @INSTALLMENTS,
      @AUTOPAY,
      @PAYMENTMETHODCODE,
      @CARDHOLDERNAME,
      @CREDITCARDNUMBER,
      @CREDITTYPECODEID,
      @EXPIRESON,
      @REFERENCEDATE,
      @REFERENCENUMBER,
      @CONSTITUENTACCOUNTID,
      @FINDERNUMBER,
      @SOURCECODE,
      @APPEALID,
      @BENEFITS,
      @BENEFITSWAIVED,
      @GIVENANONYMOUSLY,
      @MAILINGID,
      @CHANNELCODEID,
      @DONOTACKNOWLEDGE,
      @PLEDGESUBTYPEID,
      default, -- batch number

      @OPPORTUNITYID,
      @REFERENCE,
      @CATEGORYCODEID,
      @CREDITCARDTOKEN,
      @STANDINGORDERSETUP,
      @STANDINGORDERSETUPDATE,
      @DDISOURCECODEID,
      @DDISOURCEDATE,
      @SPLITSDECLININGGIFTAID output,
      @PERCENTAGEBENEFITS;

  exec dbo.USP_GIFTAIDREVENUESPLIT_ADDUPDATESPLITS @ID, @APPEALID, @PAYMENTMETHODCODE, @CREDITTYPECODEID, @CHANGEAGENTID, @DATE, 1, @SPLITSDECLININGGIFTAID; --revenue transaction type code of pledge is 1


  if @@error<>0 
    begin
      if @r <> 0 return @r
      return 1;
    end

  return @r;

end