USP_DAILYSALEITEM_UPDATEDAILYSALEITEMRECORD

Updates a daily sale item record.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@ISACTIVE	bit	IN
@DESCRIPTIONFIELD1	nvarchar(20)	IN
@DESCRIPTIONFIELD2	nvarchar(20)	IN
@DESCRIPTIONFIELD3	nvarchar(20)	IN
@DESCRIPTIONFIELD1TYPECODE	tinyint	IN
@DESCRIPTIONFIELD2TYPECODE	tinyint	IN
@DESCRIPTIONFIELD3TYPECODE	tinyint	IN

Definition

Copy



        create procedure dbo.USP_DAILYSALEITEM_UPDATEDAILYSALEITEMRECORD
        (
            @ID uniqueidentifier,
            @CHANGEAGENTID uniqueidentifier = null,
            @ISACTIVE bit = 1,
            @DESCRIPTIONFIELD1 nvarchar(20) = null,
            @DESCRIPTIONFIELD2 nvarchar(20) = null,
            @DESCRIPTIONFIELD3 nvarchar(20) = null,
            @DESCRIPTIONFIELD1TYPECODE tinyint = null,
            @DESCRIPTIONFIELD2TYPECODE tinyint = 0,
            @DESCRIPTIONFIELD3TYPECODE tinyint = 0
        )
        as
        begin
            if @CHANGEAGENTID is null  
                exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            declare @CURRENTDATE datetime
            set @CURRENTDATE = getdate()

            if @DESCRIPTIONFIELD2TYPECODE is null set @DESCRIPTIONFIELD2TYPECODE = 0
            if @DESCRIPTIONFIELD3TYPECODE is null set @DESCRIPTIONFIELD3TYPECODE = 0

            declare @DESCRIPTION1 nvarchar(20)
            set @DESCRIPTION1 = ''
            if @DESCRIPTIONFIELD1TYPECODE = 1
            begin
                if @DESCRIPTIONFIELD1 = '' or @DESCRIPTIONFIELD1 is null
                    raiserror('ERR_INVALID_DESCRIPTIONROW1', 13, 1)
                else
                    set @DESCRIPTION1 = @DESCRIPTIONFIELD1
            end

            declare @DESCRIPTION2 nvarchar(20)
            set @DESCRIPTION2 = ''
            if @DESCRIPTIONFIELD2TYPECODE = 1 set @DESCRIPTION2 = @DESCRIPTIONFIELD2

            declare @DESCRIPTION3 nvarchar(20)
            set @DESCRIPTION3 = ''
            if @DESCRIPTIONFIELD3TYPECODE = 1 set @DESCRIPTION3 = @DESCRIPTIONFIELD3

            update dbo.DAILYSALEITEM set
                DESCRIPTIONFIELD1 = @DESCRIPTION1,
                DESCRIPTIONFIELD2 = @DESCRIPTION2,
                DESCRIPTIONFIELD3 = @DESCRIPTION3,
                DESCRIPTIONFIELD1TYPECODE = @DESCRIPTIONFIELD1TYPECODE,
                DESCRIPTIONFIELD2TYPECODE = @DESCRIPTIONFIELD2TYPECODE,
                DESCRIPTIONFIELD3TYPECODE = @DESCRIPTIONFIELD3TYPECODE,
                ISACTIVE = @ISACTIVE,
                CHANGEDBYID = @CHANGEAGENTID,
                DATECHANGED = @CURRENTDATE
            where ID = @ID
        end