DP44/DataPRO/Modules/Database/DatabaseMigrationScripts/.svn/pristine/b1/b18988d66929ce766d5a51daa1c67d036708632f.svn-base

<EFBFBD><EFBFBD>ALTER PROCEDURE [dbo].[sp_TestSetupObjectsInsert]
				 @TestSetupId				int = 0
				,@TestObjectId				int = 0
				,@TestObjectName			nvarchar(255) = null
				,@TestSetupName				nvarchar(255) = null
				,@TargetSampleRate			float
				,@ExcitationWarmupTimeMS	int
				,@LocalOnly					bit
				,@TestObjectType			nvarchar(50)
				,@TestObjectPosition		nvarchar(50)
				,@DisplayOrder				int
				,@new_id					int				output
				,@errorNumber				int				output
				,@errorMessage				nvarchar(250)	output
AS
BEGIN
	set @errorNumber = 0; 	set @errorMessage = space(0); set @new_id = 0;

	begin try
		if(@TestObjectName is null)
		begin 
			set @errorMessage	= 'An invalid parameter or option was specified for procedure'
			set @errorNumber	= 15600
		end	
		else
		begin
			if (@TestSetupId =0)
			begin
				set @TestSetupId = dbo.foo_IdGetTestSetup(@TestSetupName)
			end
		
			if(@TestObjectId =0)
			begin
				set @TestObjectId = dbo.foo_IdGetTestObject(@TestObjectName)
			end
			INSERT INTO [dbo].[TestSetupObjects]
				   ([TestSetupId]
				   ,[TestObjectId]
				   ,[TargetSampleRate]
				   ,[ExcitationWarmupTimeMS]
				   ,[LocalOnly]
				   ,[TestObjectType]
				   ,[TestObjectPosition]
				   ,[DisplayOrder])
			 VALUES
				   (@TestSetupId
				   ,@TestObjectId
				   ,@TargetSampleRate
				   ,@ExcitationWarmupTimeMS
				   ,@LocalOnly
				   ,@TestObjectType
				   ,@TestObjectPosition
				   ,@DisplayOrder)
		
			set @new_id = scope_identity();
		end
		end try
		begin catch
			set @errorMessage	= error_message()
			set @errorNumber	= error_number()
		end catch;
END