USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENTBYTRANSACTION

The load procedure used by the edit dataform template "Payment Add by Transaction Form"

Parameters

Parameter	Parameter Type	Mode	Description
@TRANSACTIONID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CONSTITUENTID	uniqueidentifier	INOUT	Constituent
@PAYMENTMETHODCODE	tinyint	INOUT	Payment method
@REVENUESTREAMS	xml	INOUT	Revenue streams
@SINGLEDESIGNATIONID	uniqueidentifier	INOUT	Designation
@TRANSACTIONAMOUNT	money	INOUT	Transaction amount
@ALLOWGIFT	bit	INOUT	Allow gift

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_PAYMENTBYTRANSACTION
(
  @TRANSACTIONID uniqueidentifier,
  @CONSTITUENTID uniqueidentifier = null output,
  @PAYMENTMETHODCODE tinyint = null output,
  @REVENUESTREAMS xml = null output,
  @SINGLEDESIGNATIONID uniqueidentifier = null output,
  @TRANSACTIONAMOUNT money = null output,
  @ALLOWGIFT bit = null output
)
as
  set nocount on;

  set @ALLOWGIFT = 1;

  select @CONSTITUENTID = CONSTITUENTID,
      @PAYMENTMETHODCODE = PAYMENTMETHODCODE,
      @TRANSACTIONAMOUNT = sum(REVENUE.AMOUNT)
  from dbo.REVENUE 
  inner join dbo.REVENUEPAYMENTMETHOD
    on REVENUE.ID = REVENUEPAYMENTMETHOD.REVENUEID
  where REVENUE.ID = @TRANSACTIONID
  group by CONSTITUENTID, PAYMENTMETHODCODE;

  --if exists(select top 1 ID from dbo.REVENUE where TRANSACTIONID = @TRANSACTIONID and TYPECODE = 0)

    set @ALLOWGIFT = 0;

  set @REVENUESTREAMS = dbo.UFN_CONSTITUENT_GETREVENUESTREAMS_TOITEMLISTXML(@CONSTITUENTID);

  return 0;