USP_DATAFORMTEMPLATE_ADD_BATCHMEMBERSHIPBATCHROW

The save procedure used by the add dataform template "Membership Batch Row Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@BATCHID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEQUENCE	int	IN	Sequence
@MEMBERSHIPPROGRAMID	uniqueidentifier	IN	Program
@COMMENTS	nvarchar(1000)	IN	Comments
@TRANSACTIONS	xml	IN	Transactions
@MEMBERS	xml	IN	Members
@STATUSCODE	int	IN	Status
@SENDRENEWALCODE	int	IN	Send renewal notice to

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHMEMBERSHIPBATCHROW
                (
                    @ID uniqueidentifier = null output,
                    @BATCHID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                    @SEQUENCE int,
                    @MEMBERSHIPPROGRAMID uniqueidentifier = null,
                    @COMMENTS nvarchar(1000) = '',
                    @TRANSACTIONS xml = null,
                    @MEMBERS xml = null,
                    @STATUSCODE int = 0,
                    @SENDRENEWALCODE int = 1
                ) 
                as
                    set nocount on;

                    declare @CURRENTDATE datetime = getdate();

                    if @ID is null
                        set @ID = newid();

                    if @CHANGEAGENTID is null
                        exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;


                    begin try
                        insert into dbo.BATCHMEMBERSHIP
                        (
                            [ID],
                            [BATCHID],
                            [SEQUENCE],
                            [ADDEDBYID],
                            [CHANGEDBYID],
                            [DATEADDED],
                            [DATECHANGED],
                            [MEMBERSHIPPROGRAMID],
                            [COMMENTS],
                            [STATUSCODE],
                            [SENDRENEWALCODE]
                        ) 
                        values 
                        (
                            @ID,
                            @BATCHID,
                            @SEQUENCE,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE,
                            @MEMBERSHIPPROGRAMID,
                            coalesce(@COMMENTS, ''),
                            coalesce(@STATUSCODE, 0),
                            coalesce(@SENDRENEWALCODE, 1)
                        );

                        exec dbo.[USP_BATCHMEMBERSHIP_GETTRANSACTIONS_ADDFROMXML] @ID, @TRANSACTIONS, @CHANGEAGENTID;
                        exec dbo.[USP_BATCHMEMBERSHIP_GETMEMBERS_ADDFROMXML] @ID, @MEMBERS, @CHANGEAGENTID;
                    end try
                    begin catch
                        exec dbo.[USP_RAISE_ERROR];
                        return 1;
                    end catch

                    return 0;