USP_DATAFORMTEMPLATE_ADD_ANALYTICSPROJECT

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	INOUT
@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
@MODELSANDFREQUENCIES	xml	IN
@PRESENTATION1	varbinary	IN
@PRESENTATION2	varbinary	IN
@PRESENTATION3	varbinary	IN
@PRESENTATION4	varbinary	IN
@PRESENTATION5	varbinary	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_ADD_ANALYTICSPROJECT
                    (
                        @ID uniqueidentifier = null output,
                        @CHANGEAGENTID uniqueidentifier = null,
                        @DATE date = null,
                        @RECALIBRATION bit = null,
                        @RECORDSSCORED integer = null,
                        @SPECIFIEDRECORDCOUNT bit = null,
                        @RECORDSBOUGHT integer = null,
                        @DESCRIPTION nvarchar(max) = null,
                        @DISTRIBUTION varbinary(max) = null,
                        @DISTRIBUTIONFILENAME nvarchar(255) = null,
                        @MODELSANDFREQUENCIES xml = null,
                        @PRESENTATION1 varbinary(max) = null,
                        @PRESENTATION2 varbinary(max) = null,
                        @PRESENTATION3 varbinary(max) = null,
                        @PRESENTATION4 varbinary(max) = null,
                        @PRESENTATION5 varbinary(max) = null,
                        @PRESENTATION1FILENAME nvarchar(255) = null,
                        @PRESENTATION2FILENAME nvarchar(255) = null,
                        @PRESENTATION3FILENAME nvarchar(255) = null,
                        @PRESENTATION4FILENAME nvarchar(255) = null,
                        @PRESENTATION5FILENAME nvarchar(255) = null,
                        @PRESENTATION1INDEX tinyint = 0,
                        @PRESENTATION2INDEX tinyint = 1,
                        @PRESENTATION3INDEX tinyint = 2,
                        @PRESENTATION4INDEX tinyint = 3,
                        @PRESENTATION5INDEX tinyint = 4
                    )
                    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()

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

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

                    begin try

                        insert into dbo.ANALYTICSPROJECT (
                            ANALYTICSPROJECT.ID, 
                            ANALYTICSPROJECT.DATE, 
                            ANALYTICSPROJECT.RECALIBRATION, 
                            ANALYTICSPROJECT.RECORDSSCORED, 
                            ANALYTICSPROJECT.RECORDSBOUGHT, 
                            ANALYTICSPROJECT.DESCRIPTION, 
                            ANALYTICSPROJECT.DISTRIBUTION, 
                            ANALYTICSPROJECT.DISTRIBUTIONFILENAME, 
                            ANALYTICSPROJECT.PRESENTATION1,
                            ANALYTICSPROJECT.PRESENTATION2,
                            ANALYTICSPROJECT.PRESENTATION3,
                            ANALYTICSPROJECT.PRESENTATION4,
                            ANALYTICSPROJECT.PRESENTATION5,
                            ANALYTICSPROJECT.PRESENTATION1FILENAME,
                            ANALYTICSPROJECT.PRESENTATION2FILENAME,
                            ANALYTICSPROJECT.PRESENTATION3FILENAME,
                            ANALYTICSPROJECT.PRESENTATION4FILENAME,
                            ANALYTICSPROJECT.PRESENTATION5FILENAME,
                            ANALYTICSPROJECT.PRESENTATION1INDEX,
                            ANALYTICSPROJECT.PRESENTATION2INDEX,
                            ANALYTICSPROJECT.PRESENTATION3INDEX,
                            ANALYTICSPROJECT.PRESENTATION4INDEX,
                            ANALYTICSPROJECT.PRESENTATION5INDEX,
                            ANALYTICSPROJECT.ADDEDBYID,
                            ANALYTICSPROJECT.CHANGEDBYID, 
                            ANALYTICSPROJECT.DATEADDED, 
                            ANALYTICSPROJECT.DATECHANGED
                        ) values (
                            @ID, 
                            @DATE, 
                            @RECALIBRATION, 
                            @RECORDSSCORED, 
                            @RECORDSBOUGHT, 
                            @DESCRIPTION, 
                            @DISTRIBUTION,
                            @DISTRIBUTIONFILENAME,
                            @PRESENTATION1,
                            @PRESENTATION2,
                            @PRESENTATION3,
                            @PRESENTATION4,
                            @PRESENTATION5,
                            @PRESENTATION1FILENAME,
                            @PRESENTATION2FILENAME,
                            @PRESENTATION3FILENAME,
                            @PRESENTATION4FILENAME,
                            @PRESENTATION5FILENAME,
                            @PRESENTATION1INDEX,
                            @PRESENTATION2INDEX,
                            @PRESENTATION3INDEX,
                            @PRESENTATION4INDEX,
                            @PRESENTATION5INDEX,
                            @CHANGEAGENTID, 
                            @CHANGEAGENTID,
                            @CURRENTDATE, 
                            @CURRENTDATE
                        )

                        exec dbo.USP_ANALYTICSPROJECTDISTRIBUTION_GETMODELSANDFREQUENCIES_ADDFROMXML @ID, @MODELSANDFREQUENCIES, @CHANGEAGENTID, @CURRENTDATE;

                    end try

                    begin catch
                        exec dbo.USP_RAISE_ERROR
                        return 1
                    end catch

                    return 0