USP_DATAFORMTEMPLATE_ADD_R68

The save procedure used by the add dataform template "R68 Process Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@REFERENCENUMBER	nvarchar(20)	IN	Charity claim reference number
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@STARTDATE	date	IN	Start date
@ENDDATE	date	IN	End date
@UPDATEGIFTAIDSTATUS	bit	IN	Update Gift Aid status
@TAXCLAIMNUMBER	nvarchar(10)	IN	Tax claim number
@RUNGIFTAIDSPONSORSHIPSONLY	bit	IN	Process only Gift Aid sponsorships

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_R68
                    (
                        @ID uniqueidentifier output,
                        @CHANGEAGENTID uniqueidentifier,
                        @CURRENTAPPUSERID uniqueidentifier,
                        @NAME nvarchar(100),
                        @DESCRIPTION nvarchar(255) = '',
                        @REFERENCENUMBER nvarchar(20) = null,
                        @IDSETREGISTERID uniqueidentifier = null,
                        @STARTDATE date = null,
                        @ENDDATE date = null,
                        @UPDATEGIFTAIDSTATUS bit = 1,
                        @TAXCLAIMNUMBER nvarchar(10) = null,
                        @RUNGIFTAIDSPONSORSHIPSONLY bit = 0
                    )
                    as
                    set nocount on;

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

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

                    if @STARTDATE > @ENDDATE
                        raiserror('BBERR_ADDR68_STARTDATEAFTERENDDATE', 13, 1)

                    declare @DATE as datetime;
                    set @DATE = getdate();

                    begin try

                        insert into dbo.R68(
                                ID, 
                                NAME, 
                                DESCRIPTION, 
                                REFERENCENUMBER, 
                                IDSETREGISTERID, 
                                STARTDATE, 
                                ENDDATE, 
                                UPDATEGIFTAIDSTATUS, 
                                TAXCLAIMNUMBER,
                                RUNGIFTAIDSPONSORSHIPSONLY,
                                ADDEDBYID, 
                                CHANGEDBYID, 
                                DATEADDED, 
                                DATECHANGED)
                            values(
                                @ID, 
                                @NAME, 
                                @DESCRIPTION, 
                                @REFERENCENUMBER, 
                                @IDSETREGISTERID, 
                                @STARTDATE, 
                                @ENDDATE, 
                                @UPDATEGIFTAIDSTATUS, 
                                @TAXCLAIMNUMBER,
                                @RUNGIFTAIDSPONSORSHIPSONLY,
                                @CHANGEAGENTID, 
                                @CHANGEAGENTID, 
                                @DATE, 
                                @DATE);

                        exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
                                @CHANGEAGENTID = @CHANGEAGENTID, 
                                @BUSINESSPROCESSCATALOGID = '5F83E4C6-7CAD-4b2c-95A6-506BB18130AB', 
                                @BUSINESSPROCESSPARAMETERSETID = @ID, 
                                @OWNERID = @CURRENTAPPUSERID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR;
                        return 1;
                    end catch

                    return 0;