USP_DATAFORMTEMPLATE_EDIT_EVENTSALESMETHOD

The save procedure used by the edit dataform template "Event Sales Method 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.
@SALESMETHODS	xml	IN	Sales types

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_EVENTSALESMETHOD (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
          @SALESMETHODS xml
        )
        as

            set nocount on;

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

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            begin try
                if exists(select * from EVENTSALESMETHOD where EVENTID = @ID) 
              exec dbo.USP_EVENTSALESMETHOD_GETSALESTYPES_UPDATEFROMXML @ID, @SALESMETHODS, @CHANGEAGENTID;
            else
              exec dbo.USP_EVENTSALESMETHOD_GETSALESTYPES_ADDFROMXML @ID, @SALESMETHODS, @CHANGEAGENTID;
            end try
            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch

        return 0;