USP_SALESMETHODDELIVERYMETHOD_SETDEFAULTDELIVERYMETHOD

Executes the "Sales Method Set Default Delivery Method" record operation.

Parameters

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

Definition

Copy



        create procedure dbo.USP_SALESMETHODDELIVERYMETHOD_SETDEFAULTDELIVERYMETHOD
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier
        )
        as 
          set nocount on;
        declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate();

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

        declare @SALESMETHODID uniqueidentifier;
        select @SALESMETHODID = SALESMETHODID
        from
          dbo.SALESMETHODDELIVERYMETHOD
        where 
          ID = @ID;

        declare @PREVIOUSDEFAULTSALESMETHODDELIVERYMETHODID uniqueidentifier;
        select @PREVIOUSDEFAULTSALESMETHODDELIVERYMETHODID = ID
        from
          dbo.SALESMETHODDELIVERYMETHOD
        where
          SALESMETHODID = @SALESMETHODID and ISDEFAULT = 1;

                begin try

                    update dbo.SALESMETHODDELIVERYMETHOD
                    set    
            ISDEFAULT = 0,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where ID = @PREVIOUSDEFAULTSALESMETHODDELIVERYMETHODID;

          update dbo.SALESMETHODDELIVERYMETHOD
                    set    
            ISDEFAULT = 1,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where ID = @ID
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;