USP_DATAFORMTEMPLATE_EDIT_BATCHMEMBERSHIPBATCHROW

The save procedure used by the edit dataform template "Membership Batch Row Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@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_EDIT_BATCHMEMBERSHIPBATCHROW
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier,
                    @SEQUENCE int,
                    @MEMBERSHIPPROGRAMID uniqueidentifier,
                    @COMMENTS nvarchar(1000),
                    @TRANSACTIONS xml,
                    @MEMBERS xml,
                    @STATUSCODE int,
                    @SENDRENEWALCODE int
                ) 
                as
                    set nocount on;

                    declare @CURRENTDATE datetime = getdate();

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

                    begin try
                        update dbo.[BATCHMEMBERSHIP]
                            set 
                                [SEQUENCE] = @SEQUENCE,
                                [CHANGEDBYID] = @CHANGEAGENTID,
                                [DATECHANGED] = @CURRENTDATE,
                                [MEMBERSHIPPROGRAMID] = @MEMBERSHIPPROGRAMID,
                                [COMMENTS] = coalesce(@COMMENTS, ''),
                                [STATUSCODE] = coalesce(@STATUSCODE, 0),
                                [SENDRENEWALCODE] = coalesce(@SENDRENEWALCODE, 1)
                            where
                                [BATCHMEMBERSHIP].[ID] = @ID;

                        exec dbo.[USP_BATCHMEMBERSHIP_GETTRANSACTIONS_UPDATEFROMXML] @ID, @TRANSACTIONS, @CHANGEAGENTID;
                        exec dbo.[USP_BATCHMEMBERSHIP_GETMEMBERS_UPDATEFROMXML] @ID, @MEMBERS, @CHANGEAGENTID;

                    end try
                    begin catch
                        exec dbo.[USP_RAISE_ERROR];
                        return 1;
                    end catch

                    return 0;