USP_EVENTRESOURCE_DELETE

Executes the "Event Resource Delete" record operation.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	Input parameter indicating the ID of the record being deleted.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the delete.

Definition

Copy



                CREATE procedure dbo.USP_EVENTRESOURCE_DELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin
                    --check deletion rules, if any


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

                    update dbo.[RESOURCE] set
                        [QUANTITY] = dbo.[RESOURCE].[QUANTITY] + dbo.[EVENTRESOURCE].QUANTITYNEEDED,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = getdate()
                    from dbo.[RESOURCE]
                        inner join dbo.[EVENTRESOURCE] on dbo.[RESOURCE].ID = dbo.[EVENTRESOURCE].RESOURCEID
                    where dbo.[EVENTRESOURCE].ID = @ID
                        and dbo.[RESOURCE].ISPERTICKETITEM = 0
                        and dbo.[RESOURCE].TYPECODE = 1

                    -- use the system generated delete routine to allow proper recording of the deleting agent

                    exec USP_EVENTRESOURCE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID                
                    return 0;

                end