USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAM_2

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@SITEID	uniqueidentifier	IN	Site
@CARDFORMAT	nvarchar(255)	IN	Card format
@EXPIRESONCODE	tinyint	IN	Expiration date
@BACKDATEMEMBERSHIPS	bit	IN
@ALLOWMULTIPLEMEMBERSHIPS	bit	IN	Allow multiple memberships
@CUTOFFDAY	tinyint	IN	Cutoff day
@CUTOFFDATEFORYEAR	char(4)	IN	Cutoff day
@EXPIRATIONDATES	xml	IN	Expiration dates
@LETTERTEMPLATEID	uniqueidentifier	IN	Letter template to use

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAM_2
(
    @ID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @SITEID uniqueidentifier,
    @CARDFORMAT nvarchar(255),
    @EXPIRESONCODE tinyint,
    @BACKDATEMEMBERSHIPS bit,
    @ALLOWMULTIPLEMEMBERSHIPS bit,
    @CUTOFFDAY tinyint,
    @CUTOFFDATEFORYEAR char(4),
    @EXPIRATIONDATES xml,
    @LETTERTEMPLATEID uniqueidentifier
)

as
  set nocount on;

    declare @ALLOWADDONADULT bit;
    declare @ADDONADULTPRICE money;
    declare @ALLOWADDONGUEST bit;
    declare @ADDONGUESTPRICE money;
    declare @REPORTCATALOGID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_MEMBERSHIPPROGRAM
        @ID = @ID,
        @ALLOWADDONADULT = @ALLOWADDONADULT output,
        @ADDONADULTPRICE = @ADDONADULTPRICE output,
        @ALLOWADDONGUEST = @ALLOWADDONGUEST output,
        @ADDONGUESTPRICE = @ADDONGUESTPRICE output,
        @REPORTCATALOGID = @REPORTCATALOGID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_MEMBERSHIPPROGRAM_3
        @ID,
        @CURRENTAPPUSERID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @SITEID,
        @CARDFORMAT,
        @EXPIRESONCODE,
        @BACKDATEMEMBERSHIPS,
        @ALLOWMULTIPLEMEMBERSHIPS,
        @CUTOFFDAY,
        @CUTOFFDATEFORYEAR,
        @EXPIRATIONDATES,
        @LETTERTEMPLATEID,
        @ALLOWADDONADULT,
        @ADDONADULTPRICE,
        @ALLOWADDONGUEST,
        @ADDONGUESTPRICE,
        @REPORTCATALOGID

  return 0;