USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEOFFLINEDONATION

The load procedure used by the edit dataform template "Revenue Offline Donation Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@REGISTRANTID	uniqueidentifier	INOUT	Registrant
@ADDRESSBOOKFAFID	uniqueidentifier	INOUT	Address book Faf
@DONORNAME	nvarchar(255)	INOUT	Donor name
@AMOUNT	money	INOUT	Amount
@PAYMENTTYPECODE	tinyint	INOUT	Payment type
@CHECKNUMBER	nvarchar(20)	INOUT	Check number
@EXPECTEDDATE	datetime	INOUT	Expected date
@LOCALCORPNAME	nvarchar(20)	INOUT	Local corp
@LOCALCORPZIP	nvarchar(20)	INOUT	Local corp zip

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_REVENUEOFFLINEDONATION(
  @ID uniqueidentifier,
  @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,

    @REGISTRANTID uniqueidentifier= null output,
    @ADDRESSBOOKFAFID uniqueidentifier= null output,
    @DONORNAME nvarchar(255)= null output,
    @AMOUNT money= null output,     
    @PAYMENTTYPECODE tinyint= null output,
    @CHECKNUMBER nvarchar(20)= null output,
    @EXPECTEDDATE datetime= null output
    ,@LOCALCORPNAME nvarchar(20)    =  null output-- 'none', 1= 'preferredcorp',  2 = 'zipcode'
    ,@LOCALCORPZIP nvarchar(20) = null output

 --,@AMOUNTCONFIRMED money = null output          
 --,@GIFTID    int = null output     

)
as
    set nocount on;

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

    -- populate the output parameters, which correspond to fields on the form.  Note that
    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system
    -- will display a "no data loaded" message.  Also note that we fetch the TSLONG so that concurrency
    -- can be considered.
    select
        @DATALOADED = 1,
        @TSLONG = TSLONG,

        @REGISTRANTID = REGISTRANTID, 
        @ADDRESSBOOKFAFID = ADDRESSBOOKFAFID, 
        @DONORNAME = DONORNAME, 
        @AMOUNT = AMOUNT, 
        @PAYMENTTYPECODE = PAYMENTTYPECODE, 
        @CHECKNUMBER = CHECKNUMBER,
            @EXPECTEDDATE = EXPECTEDDATE,
        @LOCALCORPNAME = ISNULL(LOCALCORPNAME, 'none')
       --,@AMOUNTCONFIRMED = AMOUNTCONFIRMED
           --,@GIFTID = GIFTID

    from dbo.REVENUEOFFLINEDONATION
    where ID = @ID

    return 0;