USP_DATAFORMTEMPLATE_EDITSAVE_CHARITYCLAIMREFERENCENUMBERNOSITE

The save procedure used by the edit dataform template "Charity Claim Information No Site Edit Form".

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@CCRNID	uniqueidentifier	IN
@REFERENCENUMBER	nvarchar(20)	IN	Reference number
@DESCRIPTION	nvarchar(50)	IN	Description
@CLASSIFICATIONCODE	tinyint	IN	Classification
@WAITINGPERIOD	smallint	IN	Days to wait
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



            create procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_CHARITYCLAIMREFERENCENUMBERNOSITE
            (
                @CHANGEAGENTID uniqueidentifier,    
                @CCRNID uniqueidentifier,
                @REFERENCENUMBER nvarchar(20),
                @DESCRIPTION nvarchar(50),
                @CLASSIFICATIONCODE tinyint,
                @WAITINGPERIOD smallint,
                @CURRENTAPPUSERID uniqueidentifier
            )
            as
            begin
                set nocount on;

                declare @CURRENTDATE datetime                                        

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

                set @CURRENTDATE = getdate()

                if @WAITINGPERIOD is null
                    set @WAITINGPERIOD = 0

                begin try                                   

                    IF @CCRNID is null
                    begin
                        insert into dbo.CHARITYCLAIMREFERENCENUMBER (
                            ID,
                            REFERENCENUMBER,
                            DESCRIPTION,
                            CLASSIFICATIONCODE,
                            WAITINGPERIOD,
                            ADDEDBYID,
                            CHANGEDBYID,
                            DATEADDED,
                            DATECHANGED
                            )
                        values (
                            newid(),
                            @REFERENCENUMBER,
                            @DESCRIPTION,
                            @CLASSIFICATIONCODE,
                            @WAITINGPERIOD,
                            @CHANGEAGENTID,
                            @CHANGEAGENTID,
                            @CURRENTDATE,
                            @CURRENTDATE
                            )
                    end
                    else
                        update dbo.CHARITYCLAIMREFERENCENUMBER set
                            ID = @CCRNID,
                            REFERENCENUMBER = @REFERENCENUMBER,
                            DESCRIPTION = @DESCRIPTION,
                            CLASSIFICATIONCODE = @CLASSIFICATIONCODE,
                            WAITINGPERIOD = @WAITINGPERIOD,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CURRENTDATE
                        where ID = @CCRNID

                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0

            end