USP_DATAFORMTEMPLATE_EDITSAVE_SALESMETHODDISCOUNT

The save procedure used by the edit dataform template "Edit Sales Method Discounts".

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.
@DISCOUNTS xml IN Discounts

Definition

Copy


                CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_SALESMETHODDISCOUNT
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,
                    @DISCOUNTS xml
                )
                as

                    set nocount on;

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

                    begin try
                        exec dbo.USP_SALESMETHODDISCOUNT_GETDISCOUNTS_UPDATEFROMXML @ID, @DISCOUNTS, @CHANGEAGENTID;
                    end try
                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0;