USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEINVENTORYBATCHROW_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@SEQUENCE	int	IN
@ACTIONTYPECODE	tinyint	IN
@MERCHANDISEPRODUCTID	uniqueidentifier	IN
@MERCHANDISEPRODUCTINSTANCEID	uniqueidentifier	IN
@QUANTITY	int	IN
@COST	money	IN
@PRICE	money	IN
@VENDORID	uniqueidentifier	IN
@LOOKUPCODE	nvarchar(25)	IN
@MERCHANDISEADJUSTMENTREASONCODEID	uniqueidentifier	IN
@COMMENTS	nvarchar(255)	IN
@UPDATECURRENTCOST	bit	IN
@LOOKUPITEMS	xml	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_MERCHANDISEINVENTORYBATCHROW_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEQUENCE int,
    @ACTIONTYPECODE tinyint,
    @MERCHANDISEPRODUCTID uniqueidentifier,
    @MERCHANDISEPRODUCTINSTANCEID uniqueidentifier,    
    @QUANTITY int,
    @COST money,
    @PRICE money,
    @VENDORID uniqueidentifier,
    @LOOKUPCODE nvarchar(25),
    @MERCHANDISEADJUSTMENTREASONCODEID uniqueidentifier,
    @COMMENTS nvarchar(255),
    @UPDATECURRENTCOST bit,
    @LOOKUPITEMS xml
)
as
    set nocount on;

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

    declare @CURRENTDATE datetime = getdate();

    begin try        

        update dbo.BATCHMERCHANDISEINVENTORY set
            SEQUENCE = @SEQUENCE,
            ACTIONTYPECODE = @ACTIONTYPECODE,
            MERCHANDISEPRODUCTID = @MERCHANDISEPRODUCTID,
            MERCHANDISEPRODUCTINSTANCEID = @MERCHANDISEPRODUCTINSTANCEID,
            QUANTITY = @QUANTITY,
            COST = @COST,
            PRICE = @PRICE,
            VENDORID = @VENDORID,
            LOOKUPCODE = coalesce(@LOOKUPCODE, ''),
            MERCHANDISEADJUSTMENTREASONCODEID = @MERCHANDISEADJUSTMENTREASONCODEID,
            COMMENTS = coalesce(@COMMENTS, ''),
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE,
            UPDATECURRENTCOST = @UPDATECURRENTCOST
        where ID = @ID;


        exec dbo.USP_BATCHMERCHANDISEINVENTORY_GETLOOKUPITEMS_UPDATEFROMXML @ID, @LOOKUPITEMS, @CHANGEAGENTID;

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

return 0;