USP_DAILYSALEITEM_DELETE

Executes the "Daily Sale Item 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_DAILYSALEITEM_DELETE
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier
                )
                as begin

                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
                    declare @CURRENTDATE datetime = getdate()

                    declare @BUTTONORDER int
                    select @BUTTONORDER = BUTTONORDER from dbo.DAILYSALEITEM where ID = @ID

                    delete from dbo.DAILYSALEITEM where ID = @ID
                    exec USP_DAILYSALEITEM_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID

                    -- Reorder active buttons

                    if @BUTTONORDER > 0
                    begin
                        update dbo.DAILYSALESGENERICACTION
                            set BUTTONORDER -= 1,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                        where BUTTONORDER > @BUTTONORDER

                        update dbo.DAILYSALEITEM
                            set BUTTONORDER -= 1,
                                CHANGEDBYID = @CHANGEAGENTID,
                                DATECHANGED = @CURRENTDATE
                        where BUTTONORDER > @BUTTONORDER
                    end

                    return 0;

                end