USP_DATAFORMTEMPLATE_EDIT_SALESORDERONLINEDELIVERYMETHOD

The save procedure used by the edit dataform template "SalesOrderDeliveryMethodOnline Edit Data Form".

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.
@DELIVERYMETHODID	uniqueidentifier	IN	Delivery Method ID

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_SALESORDERONLINEDELIVERYMETHOD (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @DELIVERYMETHODID uniqueidentifier
            )
            as

                set nocount on;

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

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try
                    -- handle updating the data

                    update dbo.SALESORDER set
                        DELIVERYMETHODID = @DELIVERYMETHODID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where ID = @ID

                    exec dbo.USP_SALESORDER_CALCULATEFEES @ID, @CHANGEAGENTID;

                    exec dbo.USP_SALESORDER_CALCULATETAXES @ID, @CHANGEAGENTID;

                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

            return 0;