USP_AMPROIMPORT_ADDBATCHROWMESSAGE

Adds a system message to a row in an AuctionMaestro Pro import batch.
Parameters

Parameter	Parameter Type	Mode
@BATCHROWID	uniqueidentifier	IN
@MESSAGE	nvarchar(2000)	IN
@ISERROR	bit	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN
Definition

Copy


            create procedure dbo.USP_AMPROIMPORT_ADDBATCHROWMESSAGE
            (
                @BATCHROWID uniqueidentifier,
                @MESSAGE nvarchar(2000),
                @ISERROR bit,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
            set nocount on;

            declare @CURRENTMESSAGE nvarchar(2000);

            if @ISERROR = 1 
            begin
                if exists(select ID from dbo.BATCHAMPROIMPORTBATCHSYSTEMMESSAGE where ID = @BATCHROWID)
                begin
                    select top 1 @CURRENTMESSAGE = MESSAGETEXT
                    from dbo.BATCHAMPROIMPORTBATCHSYSTEMMESSAGE
                    where ID = @BATCHROWID;

                    if @CURRENTMESSAGE is null
                        set @CURRENTMESSAGE = @MESSAGE;
                    else
                        set @CURRENTMESSAGE = @CURRENTMESSAGE + '; ' + @MESSAGE;

                    update dbo.BATCHAMPROIMPORTBATCHSYSTEMMESSAGE
                        set MESSAGETEXT = @CURRENTMESSAGE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CHANGEDATE
                    where ID = @BATCHROWID;
                end
                else
                    insert into dbo.BATCHAMPROIMPORTBATCHSYSTEMMESSAGE(ID, MESSAGETEXT, MESSAGETYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values(@BATCHROWID, @MESSAGE, 0, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end
            else
            begin
                if exists(select ID from dbo.BATCHAMPROIMPORTBATCHUSERMESSAGE where ID = @BATCHROWID)
                begin
                    select top 1 @CURRENTMESSAGE = MESSAGETEXT
                    from dbo.BATCHAMPROIMPORTBATCHUSERMESSAGE
                    where ID = @BATCHROWID;

                    if @CURRENTMESSAGE is null
                        set @CURRENTMESSAGE = @MESSAGE;
                    else
                        set @CURRENTMESSAGE = @CURRENTMESSAGE + '; ' + @MESSAGE;

                    update dbo.BATCHAMPROIMPORTBATCHUSERMESSAGE
                        set MESSAGETEXT = @CURRENTMESSAGE,
                            CHANGEDBYID = @CHANGEAGENTID,
                            DATECHANGED = @CHANGEDATE
                    where ID = @BATCHROWID;
                end
                else
                    insert into dbo.BATCHAMPROIMPORTBATCHUSERMESSAGE(ID, MESSAGETEXT, MESSAGETYPECODE, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
                        values(@BATCHROWID, @MESSAGE, 0, @CHANGEAGENTID, @CHANGEAGENTID, @CHANGEDATE, @CHANGEDATE);
            end