DP44/DataPRO_sql/dbo.Alter_sp_TestSetupsInsert.sql

<EFBFBD><EFBFBD>USE [DataPRO]
GO
/****** Object:  StoredProcedure [dbo].[sp_TestSetupsInsert]    Script Date: 5/23/2019 4:26:33 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[sp_TestSetupsInsert]
            @TestSetupName					nvarchar(50) = Null
           ,@SetupDescription				nvarchar(50)
           ,@AutomaticTestProgression		bit
           ,@AutomaticProgressionDelayMS	int
           ,@InvertTrigger					bit
           ,@InvertStart					bit
           ,@ViewDiagnostics				bit
           ,@VerifyChannels					bit
           ,@AutoVerifyChannels				bit
           ,@VerifyChannelsDelayMS			int
           ,@RecordingMode					smallint
           ,@SamplesPerSecond				float
           ,@PreTriggerSeconds				float
           ,@PostTriggerSeconds				float
           ,@StrictDiagnostics				bit
           ,@RequireConfirmationOnErrors	bit
           ,@ROIDownload					bit
           ,@ViewROIDownload				bit
           ,@DownloadAll					bit
           ,@ViewRealtime					bit
           ,@RealtimePlotCount				smallint
		   ,@RegionsOfInterest				nvarchar(MAX)
           ,@ROIStart						float
           ,@ROIEnd							float
           ,@ViewDownloadAll				bit
           ,@Export							bit
           ,@ExportFormat					bigint
           ,@LabDetails						nvarchar(50)
           ,@UseLabDetails					bit
           ,@CustomerDetails				nvarchar(50)
           ,@UseCustomerDetails				bit
           ,@AllowMissingSensors			bit
           ,@AllowSensorIdToBlankChannel	bit
		   ,@CalibrationBehavior			smallint
           ,@LocalOnly						bit
           ,@LastModified					datetime
           ,@LastModifiedBy					nvarchar(50)
           ,@TurnOffExcitation				bit
           ,@TriggerCheckRealtime			bit
           ,@TriggerCheckStep				bit
           ,@PostTestDiagnostics			int
           ,@ExportFolder					nvarchar(150)
           ,@DownloadFolder					nvarchar(150)
           ,@CommonStatusLine				bit
           ,@SameAsDownloadFolder			bit
           ,@UploadData						bit
           ,@UploadDataFolder				nvarchar(150)
		   ,@UploadExportsOnly				bit
           ,@Settings						nvarchar(4000)
           ,@WarnOnBatteryFail				bit
           ,@Dirty							bit
           ,@Complete						bit
           ,@Error							nvarchar(255)
           ,@TestEngineerDetails			nvarchar(50)
           ,@UseTestEngineerDetails			bit
           ,@UserTags						varbinary(max)
           ,@DoAutoArm						bit
           ,@CheckoutMode					bit
           ,@ISFFile						nvarchar(4000)
           ,@QuitTestWithoutWarning			bit
           ,@NotAllChannelsRealTime			bit
           ,@NotAllChannelsViewer			bit
           ,@SuppressMissingSensorsWarning  bit
           ,@DoStreaming					bit
		   ,@TestSetup						varbinary(MAX)
		   ,@new_id							int output
		   ,@errorNumber					int				output
		   ,@errorMessage					nvarchar(250)	output 
AS
BEGIN
set @errorNumber = 0; 	set @errorMessage = space(0);

/* Table (and stored procedure) is too big... */
	begin try
		if(@TestSetupName is null)
		begin 
			set @errorMessage	= 'An invalid parameter or option was specified for procedure'
			set @errorNumber	= 15600
		end	
		else
		begin
			SET NOCOUNT ON;
			declare @TestEngineerId	int
			declare @LabratoryId	int 
			declare @CustomerId		int

			set @CustomerId		= dbo.foo_IdGetCustomer(@CustomerDetails)
			IF @CustomerId <= 0
			BEGIN
				SET @CustomerId = null
			END
			set @LabratoryId	= dbo.foo_IdGetLabratory(@LabDetails)
			IF @LabratoryId <= 0
			BEGIN
				SET @LabratoryId = null
			END
			set @TestEngineerId	= dbo.foo_IdGetEngineer(@TestEngineerDetails);
			IF @TestEngineerId <= 0
			BEGIN
				SET @TestEngineerId = null
			END

			insert into [dbo].[TestSetups]
				([TestSetupName]
				,[SetupDescription]
				,[AutomaticTestProgression]
				,[AutomaticProgressionDelayMS]
				,[InvertTrigger]
				,[InvertStart]
				,[ViewDiagnostics]
				,[VerifyChannels]
				,[AutoVerifyChannels]
				,[VerifyChannelsDelayMS]
				,[RecordingMode]
				,[SamplesPerSecond]
				,[PreTriggerSeconds]
				,[PostTriggerSeconds]
				,[StrictDiagnostics]
				,[RequireConfirmationOnErrors]
				,[ROIDownload]
				,[ViewROIDownload]
				,[DownloadAll]
				,[ViewRealtime]
				,[RealtimePlotCount]
				,[RegionsOfInterest]
				,[ROIStart]
				,[ROIEnd]
				,[ViewDownloadAll]
				,[Export]
				,[ExportFormat]

				,[CustomerId]
				,[LabratoryId]
				,[TestEngineerId]
				,[LabDetails]
				,[UseLabDetails]
				,[CustomerDetails]
				,[UseCustomerDetails]
				,[TestEngineerDetails]
				,[UseTestEngineerDetails]
           
				,[AllowMissingSensors]
				,[AllowSensorIdToBlankChannel]
				,[CalibrationBehavior]
				,[LocalOnly]
				,[LastModified]
				,[LastModifiedBy]
				,[TurnOffExcitation]
				,[TriggerCheckRealtime]
				,[TriggerCheckStep]
				,[PostTestDiagnostics]
				,[ExportFolder]
				,[DownloadFolder]
				,[CommonStatusLine]
				,[SameAsDownloadFolder]
				,[UploadData]
				,[UploadDataFolder]
				,[UploadExportsOnly]
				,[Settings]
				,[WarnOnBatteryFail]
				,[Dirty]
				,[Complete]
				,[ErrorMessage]
				,[UserTags]
				,[DoAutoArm]
				,[CheckoutMode]
				,[ISFFile]
				,[QuitTestWithoutWarning]
				,[NotAllChannelsRealTime]
				,[NotAllChannelsViewer]
				,[SuppressMissingSensorsWarning]
				,[DoStreaming]
				,[TestSetup])
		 VALUES
			   ( @TestSetupName						
				,@SetupDescription				
				,@AutomaticTestProgression		
				,@AutomaticProgressionDelayMS	
				,@InvertTrigger					
				,@InvertStart					
				,@ViewDiagnostics				
				,@VerifyChannels					
				,@AutoVerifyChannels				
				,@VerifyChannelsDelayMS			
				,@RecordingMode					
				,@SamplesPerSecond				
				,@PreTriggerSeconds				
				,@PostTriggerSeconds				
				,@StrictDiagnostics				
				,@RequireConfirmationOnErrors	
				,@ROIDownload					
				,@ViewROIDownload				
				,@DownloadAll					
				,@ViewRealtime					
				,@RealtimePlotCount
				,@RegionsOfInterest				
				,@ROIStart						
				,@ROIEnd							
				,@ViewDownloadAll				
				,@Export							
				,@ExportFormat	

				,@CustomerId
				,@LabratoryId
				,@TestEngineerId
				,@LabDetails						
				,@UseLabDetails					
				,@CustomerDetails				
				,@UseCustomerDetails				
				,@TestEngineerDetails			
				,@UseTestEngineerDetails	

				,@AllowMissingSensors			
				,@AllowSensorIdToBlankChannel
				,@CalibrationBehavior	
				,@LocalOnly						
				,@LastModified					
				,@LastModifiedBy					
				,@TurnOffExcitation				
				,@TriggerCheckRealtime			
				,@TriggerCheckStep				
				,@PostTestDiagnostics			
				,@ExportFolder					
				,@DownloadFolder					
				,@CommonStatusLine				
				,@SameAsDownloadFolder			
				,@UploadData						
				,@UploadDataFolder
				,@UploadExportsOnly				
				,@Settings						
				,@WarnOnBatteryFail				
				,@Dirty							
				,@Complete						
				,@Error					
		
				,@UserTags						
				,@DoAutoArm						
				,@CheckoutMode					
				,@ISFFile						
				,@QuitTestWithoutWarning			
				,@NotAllChannelsRealTime			
				,@NotAllChannelsViewer			
				,@SuppressMissingSensorsWarning
				,@DoStreaming
				,@TestSetup)
		
			set @new_id = scope_identity()
		end
		end try
		begin catch
			set @errorMessage	= error_message()
			set @errorNumber	= error_number()
		end catch;

END