USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED	tinyint	INOUT
@CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE	tinyint	INOUT
@CONTRIBUTIONINCLUDEEVENTTYPECODE	tinyint	INOUT
@CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE	tinyint	INOUT
@WHATHAPPENSIFTHEYGIVEMORECODE	tinyint	INOUT
@WHATDATETOCALCULATEEXPIRATIONDATECODE	tinyint	INOUT
@CONTRIBUTIONMEMBERSHIPPROGRAMID	uniqueidentifier	INOUT
@CONTRIBUTIONEVENTCATEGORYCODEID	uniqueidentifier	INOUT
@CONTRIBUTIONDESIGNATIONID	uniqueidentifier	INOUT
@CONTRIBUTIONISEVENTREGISTRATIONCOUNTED	bit	INOUT
@CONTRIBUTIONISMEMBERSHIPDUECOUNTED	bit	INOUT
@CONTRIBUTIONISPAYMENTCOUNTED	bit	INOUT
@CONTRIBUTIONISPLEDGECOUNTED	bit	INOUT
@CONTRIBUTIONISRECURRINGGIFTCOUNTED	bit	INOUT
@CONTRIBUTIONIDSETREGISTERID	uniqueidentifier	INOUT
@DESIGNATIONRECORDTYPEID	uniqueidentifier	INOUT
@CONTRIBUTIONCRITERIADEFINITIONTYPECODE	tinyint	INOUT
@CONTRIBUTIONAPPLICATIONSELECTIONID	uniqueidentifier	INOUT
@FINANCIALLINEITEMRECORDTYPEID	uniqueidentifier	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @TSLONG bigint = 0 output,
    @CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED tinyint = null output,
    @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE tinyint = null output,
    @CONTRIBUTIONINCLUDEEVENTTYPECODE tinyint = null output,
    @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE tinyint = null output,
    @WHATHAPPENSIFTHEYGIVEMORECODE tinyint = null output,
    @WHATDATETOCALCULATEEXPIRATIONDATECODE tinyint = null output,
    @CONTRIBUTIONMEMBERSHIPPROGRAMID uniqueidentifier = null output,
    @CONTRIBUTIONEVENTCATEGORYCODEID uniqueidentifier = null output,
    @CONTRIBUTIONDESIGNATIONID uniqueidentifier = null output,
    @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED bit = null output,
    @CONTRIBUTIONISMEMBERSHIPDUECOUNTED bit = null output,
    @CONTRIBUTIONISPAYMENTCOUNTED bit = null output,
    @CONTRIBUTIONISPLEDGECOUNTED bit = null output,
    @CONTRIBUTIONISRECURRINGGIFTCOUNTED bit = null output,
    @CONTRIBUTIONIDSETREGISTERID uniqueidentifier = null output,
    @DESIGNATIONRECORDTYPEID uniqueidentifier = null output,
    @CONTRIBUTIONCRITERIADEFINITIONTYPECODE tinyint = null output,
    @CONTRIBUTIONAPPLICATIONSELECTIONID uniqueidentifier = null output,
    @FINANCIALLINEITEMRECORDTYPEID uniqueidentifier = 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 = MPC.TSLONG,
        @CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED = MPC.ISMULTIPLEREVENUETRANSACTIONSCOUNTED,
        @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE = MPC.INCLUDEPAYMENTACTIVITYTYPECODE,
        @CONTRIBUTIONINCLUDEEVENTTYPECODE = MPC.INCLUDEEVENTTYPECODE,
        @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE = MPC.INCLUDEMEMBERSHIPTYPECODE,
        @WHATHAPPENSIFTHEYGIVEMORECODE = MPC.WHATHAPPENSIFTHEYGIVEMORECODE,
        @WHATDATETOCALCULATEEXPIRATIONDATECODE = MPC.WHATDATETOCALCULATEEXPIRATIONDATECODE,
        @CONTRIBUTIONMEMBERSHIPPROGRAMID = MPC.MEMBERSHIPPROGRAMID,
        @CONTRIBUTIONEVENTCATEGORYCODEID = MPC.EVENTCATEGORYCODEID,
        @CONTRIBUTIONDESIGNATIONID = MPC.DESIGNATIONID,
        @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED = MPC.ISEVENTREGISTRATIONCOUNTED,
        @CONTRIBUTIONISMEMBERSHIPDUECOUNTED = MPC.ISMEMBERSHIPDUECOUNTED,
        @CONTRIBUTIONISPAYMENTCOUNTED = MPC.ISPAYMENTCOUNTED,
        @CONTRIBUTIONISPLEDGECOUNTED = MPC.ISPLEDGECOUNTED,
        @CONTRIBUTIONISRECURRINGGIFTCOUNTED = MPC.ISRECURRINGGIFTCOUNTED,
        @CONTRIBUTIONIDSETREGISTERID = MPC.IDSETREGISTERID,
        @CONTRIBUTIONCRITERIADEFINITIONTYPECODE = MPC.CRITERIADEFINITIONTYPECODE,
        @CONTRIBUTIONAPPLICATIONSELECTIONID = MPC.APPLICATIONSELECTIONID
    from 
        MEMBERSHIPPROGRAM MP
    left outer join
        MEMBERSHIPPROGRAMCONTRIBUTION MPC on MPC.ID = MP.ID
    where 
        MP.ID = @ID

    select @DESIGNATIONRECORDTYPEID = ID
    from dbo.RECORDTYPE
    where upper(NAME) = 'DESIGNATION'

    select
        @FINANCIALLINEITEMRECORDTYPEID = ID
    from dbo.RECORDTYPE
    where upper(NAME) = 'FINANCIAL TRANSACTION LINE ITEM'

    return 0;