USP_DATAFORMTEMPLATE_EDIT_ANALYTICSPROJECT_2

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@DATE	date	IN
@RECALIBRATION	bit	IN
@RECORDSSCORED	int	IN
@SPECIFIEDRECORDCOUNT	bit	IN
@RECORDSBOUGHT	int	IN
@DESCRIPTION	nvarchar(max)	IN
@DISTRIBUTION	varbinary	IN
@DISTRIBUTIONFILENAME	nvarchar(255)	IN
@DISTRIBUTIONFILECHANGED	bit	IN
@MODELSANDFREQUENCIES	xml	IN
@PRESENTATION1	varbinary	IN
@PRESENTATION2	varbinary	IN
@PRESENTATION3	varbinary	IN
@PRESENTATION4	varbinary	IN
@PRESENTATION5	varbinary	IN
@PRESENTATION1FILECHANGED	bit	IN
@PRESENTATION2FILECHANGED	bit	IN
@PRESENTATION3FILECHANGED	bit	IN
@PRESENTATION4FILECHANGED	bit	IN
@PRESENTATION5FILECHANGED	bit	IN
@PRESENTATION1FILENAME	nvarchar(255)	IN
@PRESENTATION2FILENAME	nvarchar(255)	IN
@PRESENTATION3FILENAME	nvarchar(255)	IN
@PRESENTATION4FILENAME	nvarchar(255)	IN
@PRESENTATION5FILENAME	nvarchar(255)	IN
@PRESENTATION1INDEX	tinyint	IN
@PRESENTATION2INDEX	tinyint	IN
@PRESENTATION3INDEX	tinyint	IN
@PRESENTATION4INDEX	tinyint	IN
@PRESENTATION5INDEX	tinyint	IN

Definition

Copy


                    create procedure dbo.USP_DATAFORMTEMPLATE_EDIT_ANALYTICSPROJECT_2 (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @DATE date,
                        @RECALIBRATION bit,
                        @RECORDSSCORED integer,
                        @SPECIFIEDRECORDCOUNT bit,
                        @RECORDSBOUGHT integer,
                        @DESCRIPTION nvarchar(max),
                        @DISTRIBUTION varbinary(max),
                        @DISTRIBUTIONFILENAME nvarchar(255),
                        @DISTRIBUTIONFILECHANGED bit,
                        @MODELSANDFREQUENCIES xml,
                        @PRESENTATION1 varbinary(max),
                        @PRESENTATION2 varbinary(max),
                        @PRESENTATION3 varbinary(max),
                        @PRESENTATION4 varbinary(max),
                        @PRESENTATION5 varbinary(max),
                        @PRESENTATION1FILECHANGED bit,
                        @PRESENTATION2FILECHANGED bit,
                        @PRESENTATION3FILECHANGED bit,
                        @PRESENTATION4FILECHANGED bit,
                        @PRESENTATION5FILECHANGED bit,
                        @PRESENTATION1FILENAME nvarchar(255),
                        @PRESENTATION2FILENAME nvarchar(255),
                        @PRESENTATION3FILENAME nvarchar(255),
                        @PRESENTATION4FILENAME nvarchar(255),
                        @PRESENTATION5FILENAME nvarchar(255),
                        @PRESENTATION1INDEX tinyint,
                        @PRESENTATION2INDEX tinyint,
                        @PRESENTATION3INDEX tinyint,
                        @PRESENTATION4INDEX tinyint,
                        @PRESENTATION5INDEX tinyint
                    )
                    as

                        set nocount on;

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

                        declare @CURRENTDATE datetime
                        set @CURRENTDATE = getdate()

                        if @SPECIFIEDRECORDCOUNT = 1 and @RECORDSBOUGHT <= 0
                            raiserror('BBERR_RECORDSBOUGHT_MUSTBEPOSITIVE',13,1);

                        if @RECORDSSCORED < 0
                            raiserror('BBERR_RECORDSSCORED_MUSTBENONNEGATIVE',13,1);

                        begin try
                            update dbo.ANALYTICSPROJECT set
                                ANALYTICSPROJECT.DATE = @DATE,
                                ANALYTICSPROJECT.RECALIBRATION = @RECALIBRATION,
                                ANALYTICSPROJECT.RECORDSSCORED = @RECORDSSCORED,
                                ANALYTICSPROJECT.RECORDSBOUGHT = @RECORDSBOUGHT,
                                ANALYTICSPROJECT.DESCRIPTION = @DESCRIPTION,
                                ANALYTICSPROJECT.DISTRIBUTION = case when @DISTRIBUTIONFILECHANGED = 1 then @DISTRIBUTION else ANALYTICSPROJECT.DISTRIBUTION end,
                                ANALYTICSPROJECT.DISTRIBUTIONFILENAME = case when @DISTRIBUTIONFILECHANGED = 1 then @DISTRIBUTIONFILENAME else ANALYTICSPROJECT.DISTRIBUTIONFILENAME end,
                                ANALYTICSPROJECT.PRESENTATION1 = case when @PRESENTATION1FILECHANGED = 1 then @PRESENTATION1 else ANALYTICSPROJECT.PRESENTATION1 end,
                                ANALYTICSPROJECT.PRESENTATION2 = case when @PRESENTATION2FILECHANGED = 1 then @PRESENTATION2 else ANALYTICSPROJECT.PRESENTATION2 end,
                                ANALYTICSPROJECT.PRESENTATION3 = case when @PRESENTATION3FILECHANGED = 1 then @PRESENTATION3 else ANALYTICSPROJECT.PRESENTATION3 end,
                                ANALYTICSPROJECT.PRESENTATION4 = case when @PRESENTATION4FILECHANGED = 1 then @PRESENTATION4 else ANALYTICSPROJECT.PRESENTATION4 end,
                                ANALYTICSPROJECT.PRESENTATION5 = case when @PRESENTATION5FILECHANGED = 1 then @PRESENTATION5 else ANALYTICSPROJECT.PRESENTATION5 end,
                                ANALYTICSPROJECT.PRESENTATION1FILENAME = case when @PRESENTATION1FILECHANGED = 1 then @PRESENTATION1FILENAME else ANALYTICSPROJECT.PRESENTATION1FILENAME end,
                                ANALYTICSPROJECT.PRESENTATION2FILENAME = case when @PRESENTATION2FILECHANGED = 1 then @PRESENTATION2FILENAME else ANALYTICSPROJECT.PRESENTATION2FILENAME end,
                                ANALYTICSPROJECT.PRESENTATION3FILENAME = case when @PRESENTATION3FILECHANGED = 1 then @PRESENTATION3FILENAME else ANALYTICSPROJECT.PRESENTATION3FILENAME end,
                                ANALYTICSPROJECT.PRESENTATION4FILENAME = case when @PRESENTATION4FILECHANGED = 1 then @PRESENTATION4FILENAME else ANALYTICSPROJECT.PRESENTATION4FILENAME end,
                                ANALYTICSPROJECT.PRESENTATION5FILENAME = case when @PRESENTATION5FILECHANGED = 1 then @PRESENTATION5FILENAME else ANALYTICSPROJECT.PRESENTATION5FILENAME end,
                                ANALYTICSPROJECT.PRESENTATION1INDEX = @PRESENTATION1INDEX,
                                ANALYTICSPROJECT.PRESENTATION2INDEX = @PRESENTATION2INDEX,
                                ANALYTICSPROJECT.PRESENTATION3INDEX = @PRESENTATION3INDEX,
                                ANALYTICSPROJECT.PRESENTATION4INDEX = @PRESENTATION4INDEX,
                                ANALYTICSPROJECT.PRESENTATION5INDEX = @PRESENTATION5INDEX,
                                ANALYTICSPROJECT.CHANGEDBYID = @CHANGEAGENTID,
                                ANALYTICSPROJECT.DATECHANGED = @CURRENTDATE
                            where ANALYTICSPROJECT.ID = @ID

                            if @DISTRIBUTIONFILECHANGED = 1
                            begin
                                exec dbo.USP_ANALYTICSPROJECTDISTRIBUTION_GETMODELSANDFREQUENCIES_UPDATEFROMXML @ID, @MODELSANDFREQUENCIES, @CHANGEAGENTID, @CURRENTDATE;
                            end


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

                    return 0;