DP44/DataPRO_sql/.svn/pristine/70/7064012b2d8cf7eb60f2013cbce759f83f2b592e.svn-base

<EFBFBD><EFBFBD>DROP PROCEDURE [dbo].[sp_LabratoryDetailsInsertUpdate]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE [dbo].[sp_LabratoryDetailsInsertUpdate]
		    @Name						nvarchar(255)
           ,@LabratoryName				nvarchar(255)
           ,@LabratoryContactName		nvarchar(255)
           ,@LabratoryContactPhone		nvarchar(255)
           ,@LabratoryContactFax		nvarchar(255)
           ,@LabratoryContactEmail		nvarchar(255)
           ,@LabratoryTestRefNumber		nvarchar(255)
           ,@LabratoryProjectRefNumber	nvarchar(255)
           ,@LastModified				datetime
           ,@LastModifiedBy				nvarchar(50)
           ,@LocalOnly					bit
           ,@Version					int
		   ,@new_id						int			OUTPUT
AS
BEGIN
		SET NOCOUNT ON;
		if(exists(select * from [dbo].[LabratoryDetails] where Name = @Name))
		begin
			exec dbo.sp_LabratoryDetailsUpdate  @Name						
											   ,@LabratoryName				
											   ,@LabratoryContactName		
											   ,@LabratoryContactPhone		
											   ,@LabratoryContactFax		
											   ,@LabratoryContactEmail		
											   ,@LabratoryTestRefNumber		
											   ,@LabratoryProjectRefNumber	
											   ,@LastModified				
											   ,@LastModifiedBy				
											   ,@LocalOnly					
											   ,@Version
		end
		else
		begin
			exec dbo.sp_LabratoryDetailsInsert  @Name						
											   ,@LabratoryName				
											   ,@LabratoryContactName		
											   ,@LabratoryContactPhone		
											   ,@LabratoryContactFax		
											   ,@LabratoryContactEmail		
											   ,@LabratoryTestRefNumber		
											   ,@LabratoryProjectRefNumber	
											   ,@LastModified				
											   ,@LastModifiedBy				
											   ,@LocalOnly					
											   ,@Version
											   ,@new_id  output

		end

END



GO