USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED	tinyint	IN
@CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE	tinyint	IN
@CONTRIBUTIONINCLUDEEVENTTYPECODE	tinyint	IN
@CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE	tinyint	IN
@WHATHAPPENSIFTHEYGIVEMORECODE	tinyint	IN
@WHATDATETOCALCULATEEXPIRATIONDATECODE	tinyint	IN
@CONTRIBUTIONMEMBERSHIPPROGRAMID	uniqueidentifier	IN
@CONTRIBUTIONEVENTCATEGORYCODEID	uniqueidentifier	IN
@CONTRIBUTIONDESIGNATIONID	uniqueidentifier	IN
@CONTRIBUTIONISEVENTREGISTRATIONCOUNTED	bit	IN
@CONTRIBUTIONISMEMBERSHIPDUECOUNTED	bit	IN
@CONTRIBUTIONISPAYMENTCOUNTED	bit	IN
@CONTRIBUTIONISPLEDGECOUNTED	bit	IN
@CONTRIBUTIONISRECURRINGGIFTCOUNTED	bit	IN
@CONTRIBUTIONIDSETREGISTERID	uniqueidentifier	IN
@CONTRIBUTIONCRITERIADEFINITIONTYPECODE	tinyint	IN
@CONTRIBUTIONAPPLICATIONSELECTIONID	uniqueidentifier	IN

Definition

Copy


create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES_2 
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED tinyint,
    @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE tinyint,
    @CONTRIBUTIONINCLUDEEVENTTYPECODE tinyint,
    @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE tinyint,
    @WHATHAPPENSIFTHEYGIVEMORECODE tinyint,
    @WHATDATETOCALCULATEEXPIRATIONDATECODE tinyint,
    @CONTRIBUTIONMEMBERSHIPPROGRAMID uniqueidentifier,
    @CONTRIBUTIONEVENTCATEGORYCODEID uniqueidentifier,
    @CONTRIBUTIONDESIGNATIONID uniqueidentifier,
    @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED bit,
    @CONTRIBUTIONISMEMBERSHIPDUECOUNTED bit,
    @CONTRIBUTIONISPAYMENTCOUNTED bit,
    @CONTRIBUTIONISPLEDGECOUNTED bit,
    @CONTRIBUTIONISRECURRINGGIFTCOUNTED bit,
    @CONTRIBUTIONIDSETREGISTERID uniqueidentifier,
    @CONTRIBUTIONCRITERIADEFINITIONTYPECODE tinyint,
    @CONTRIBUTIONAPPLICATIONSELECTIONID uniqueidentifier
)
as

    set nocount on;

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

    declare @CURRENTDATE datetime
    set @CURRENTDATE = getdate()

    begin try
        if @CONTRIBUTIONCRITERIADEFINITIONTYPECODE = 1
        begin
            select
                @CONTRIBUTIONISPAYMENTCOUNTED = 0,
                @CONTRIBUTIONISPLEDGECOUNTED = 0,
                @CONTRIBUTIONISRECURRINGGIFTCOUNTED = 0,
                @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE = 0,
                @CONTRIBUTIONDESIGNATIONID = null,
                @CONTRIBUTIONIDSETREGISTERID = null,
                @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED = 0,
                @CONTRIBUTIONINCLUDEEVENTTYPECODE = 0,
                @CONTRIBUTIONEVENTCATEGORYCODEID = null,
                @CONTRIBUTIONISMEMBERSHIPDUECOUNTED = 0,
                @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE = 0,
                @CONTRIBUTIONMEMBERSHIPPROGRAMID = null;
        end
        else
        begin
            select
                @CONTRIBUTIONAPPLICATIONSELECTIONID = null,
                @CONTRIBUTIONCRITERIADEFINITIONTYPECODE = 0;
        end

        update dbo.MEMBERSHIPPROGRAMCONTRIBUTION set
            ISPAYMENTCOUNTED = @CONTRIBUTIONISPAYMENTCOUNTED,
            ISPLEDGECOUNTED = @CONTRIBUTIONISPLEDGECOUNTED,
            ISRECURRINGGIFTCOUNTED = @CONTRIBUTIONISRECURRINGGIFTCOUNTED,
            INCLUDEPAYMENTACTIVITYTYPECODE = @CONTRIBUTIONINCLUDEPAYMENTACTIVITYTYPECODE,
            DESIGNATIONID = @CONTRIBUTIONDESIGNATIONID,
            IDSETREGISTERID = @CONTRIBUTIONIDSETREGISTERID,
            ISEVENTREGISTRATIONCOUNTED = @CONTRIBUTIONISEVENTREGISTRATIONCOUNTED,
            INCLUDEEVENTTYPECODE = @CONTRIBUTIONINCLUDEEVENTTYPECODE,
            EVENTCATEGORYCODEID = @CONTRIBUTIONEVENTCATEGORYCODEID,
            ISMEMBERSHIPDUECOUNTED = @CONTRIBUTIONISMEMBERSHIPDUECOUNTED,
            INCLUDEMEMBERSHIPTYPECODE = @CONTRIBUTIONINCLUDEMEMBERSHIPTYPECODE,
            MEMBERSHIPPROGRAMID = @CONTRIBUTIONMEMBERSHIPPROGRAMID,
            ISMULTIPLEREVENUETRANSACTIONSCOUNTED = @CONTRIBUTIONISMULTIPLEREVENUETRANSACTIONSCOUNTED,
            WHATHAPPENSIFTHEYGIVEMORECODE = @WHATHAPPENSIFTHEYGIVEMORECODE,
            WHATDATETOCALCULATEEXPIRATIONDATECODE = @WHATDATETOCALCULATEEXPIRATIONDATECODE,
            CRITERIADEFINITIONTYPECODE = isnull(@CONTRIBUTIONCRITERIADEFINITIONTYPECODE, 0),
            APPLICATIONSELECTIONID = @CONTRIBUTIONAPPLICATIONSELECTIONID,
            ADDEDBYID = @CHANGEAGENTID,
            CHANGEDBYID = @CHANGEAGENTID,
            DATEADDED = @CURRENTDATE,
            DATECHANGED = @CURRENTDATE
        where
            ID = @ID
    end try
    begin catch
        exec dbo.USP_RAISE_ERROR
        return 1
    end catch

    return 0;