USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@ISMULTIPLEREVENUETRANSACTIONSCOUNTED	int	INOUT
@INCLUDEPAYMENTACTIVITYTYPECODE	int	INOUT
@INCLUDEEVENTTYPECODE	int	INOUT
@INCLUDEMEMBERSHIPTYPECODE	int	INOUT
@WHATHAPPENSIFTHEYGIVEMORECODE	int	INOUT
@WHATDATETOCALCULATEEXPIRATIONDATECODE	int	INOUT
@MEMBERSHIPPROGRAMNAME	nvarchar(100)	INOUT
@EVENTCATEGORYCODETEXT	nvarchar(100)	INOUT
@DESIGNATIONTEXT	nvarchar(512)	INOUT
@ISEVENTREGISTRATIONCOUNTED	bit	INOUT
@ISMEMBERSHIPDUECOUNTED	bit	INOUT
@ISPAYMENTCOUNTED	bit	INOUT
@ISPLEDGECOUNTED	bit	INOUT
@ISRECURRINGGIFTCOUNTED	bit	INOUT
@CONTRIBUTIONCRITERIACODE	tinyint	INOUT
@APPLICATIONSELECTIONNAME	nvarchar(max)	INOUT

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPPROGRAMCONTRIBUTIONBASEDRULES
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
  @ISMULTIPLEREVENUETRANSACTIONSCOUNTED integer = null output,
  @INCLUDEPAYMENTACTIVITYTYPECODE integer = null output,
  @INCLUDEEVENTTYPECODE integer = null output,
  @INCLUDEMEMBERSHIPTYPECODE integer = null output,
  @WHATHAPPENSIFTHEYGIVEMORECODE integer = null output,
  @WHATDATETOCALCULATEEXPIRATIONDATECODE integer = null output,
  @MEMBERSHIPPROGRAMNAME nvarchar(100) = null output,
  @EVENTCATEGORYCODETEXT nvarchar(100) = null output,
  @DESIGNATIONTEXT nvarchar(512) = null output,
  @ISEVENTREGISTRATIONCOUNTED bit = null output,
  @ISMEMBERSHIPDUECOUNTED bit = null output,
  @ISPAYMENTCOUNTED bit = null output,
  @ISPLEDGECOUNTED bit = null output,
  @ISRECURRINGGIFTCOUNTED bit = null output,
  @CONTRIBUTIONCRITERIACODE tinyint = null output,
  @APPLICATIONSELECTIONNAME nvarchar(max) = null output
)
as

    set nocount on;

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

    declare @APPLICATIONSELECTIONID uniqueidentifier = null;

    -- 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.
        select
            @DATALOADED = 1,
            @ISMULTIPLEREVENUETRANSACTIONSCOUNTED = MPC.ISMULTIPLEREVENUETRANSACTIONSCOUNTED,
            @INCLUDEPAYMENTACTIVITYTYPECODE = MPC.INCLUDEPAYMENTACTIVITYTYPECODE,
            @INCLUDEEVENTTYPECODE = MPC.INCLUDEEVENTTYPECODE,
            @INCLUDEMEMBERSHIPTYPECODE = MPC.INCLUDEMEMBERSHIPTYPECODE,
            @WHATHAPPENSIFTHEYGIVEMORECODE = MPC.WHATHAPPENSIFTHEYGIVEMORECODE,
            @WHATDATETOCALCULATEEXPIRATIONDATECODE = MPC.WHATDATETOCALCULATEEXPIRATIONDATECODE,
            @MEMBERSHIPPROGRAMNAME = MPID.NAME,
            @EVENTCATEGORYCODETEXT = ECC.DESCRIPTION,
            @DESIGNATIONTEXT = D.NAME,
            @ISEVENTREGISTRATIONCOUNTED = MPC.ISEVENTREGISTRATIONCOUNTED,
            @ISMEMBERSHIPDUECOUNTED = MPC.ISMEMBERSHIPDUECOUNTED,
            @ISPAYMENTCOUNTED = MPC.ISPAYMENTCOUNTED,
            @ISPLEDGECOUNTED = MPC.ISPLEDGECOUNTED,
            @ISRECURRINGGIFTCOUNTED = MPC.ISRECURRINGGIFTCOUNTED,
            @CONTRIBUTIONCRITERIACODE = MPC.CRITERIADEFINITIONTYPECODE,
            @APPLICATIONSELECTIONID = MPC.APPLICATIONSELECTIONID
        from 
            MEMBERSHIPPROGRAM MP
            left outer join MEMBERSHIPPROGRAMCONTRIBUTION MPC on MPC.ID = MP.ID
            left outer join MEMBERSHIPPROGRAM MPID on MPID.ID = MPC.MEMBERSHIPPROGRAMID
            left outer join EVENTCATEGORYCODE ECC on MPC.EVENTCATEGORYCODEID = ECC.ID
            left outer join DESIGNATION D on MPC.DESIGNATIONID = D.ID
      where MP.ID = @ID

      if @APPLICATIONSELECTIONID is not null
      begin
        select
            @APPLICATIONSELECTIONNAME = NAME
        from
            dbo.IDSETREGISTER
        where
            ID = @APPLICATIONSELECTIONID
      end

    return 0;