USP_DATAFORMTEMPLATE_ADD_TAX

The save procedure used by the add dataform template "Tax Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@TAXITEMS	xml	IN	Items
@APPLIESTOMERCHANDISE	bit	IN	Applies to taxable merchandise
@DEFAULTFORMERCHANDISE	bit	IN

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_TAX
        (
            @ID uniqueidentifier = null output,
            @CHANGEAGENTID uniqueidentifier = null,
            @NAME nvarchar(100) = '',
            @DESCRIPTION nvarchar(255) = '',
            @TAXITEMS xml = null,
            @APPLIESTOMERCHANDISE bit = 1,
            @DEFAULTFORMERCHANDISE bit = 0
        )
        as

        set nocount on;

        if @ID is null
            set @ID = newid()

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

        declare @CURRENTDATE datetime
        set @CURRENTDATE = getdate()

        begin try
        if @DEFAULTFORMERCHANDISE = 1
        begin
            update dbo.TAX
            set 
            DEFAULTFORMERCHANDISE = 0
        end

            insert into dbo.TAX
            (
                ID, 
                NAME, 
                DESCRIPTION,
                APPLIESTOMERCHANDISE,
                ADDEDBYID, 
                CHANGEDBYID, 
                DATEADDED, 
                DATECHANGED,
                DEFAULTFORMERCHANDISE
            )
            values
            (
                @ID, 
                @NAME, 
                @DESCRIPTION,
                @APPLIESTOMERCHANDISE,
                @CHANGEAGENTID, 
                @CHANGEAGENTID, 
                @CURRENTDATE, 
                @CURRENTDATE,
                @DEFAULTFORMERCHANDISE
            )

        exec dbo.USP_TAX_GETTAXITEMS_ADDFROMXML @ID, @TAXITEMS, @CHANGEAGENTID;

        end try


        begin catch
            exec dbo.USP_RAISE_ERROR
            return 1
        end catch

        return 0