USE [RADIOLOGY]
GO
/****** Object:  StoredProcedure [dbo].[spRadio_SaveExamBuild]    Script Date: 08/07/24 10:57:34 AM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spRadio_SaveExamBuild]--'XR','00','ACCUMULATED RADIOLOGY','1','1','2','3','4','5','1','B','',''
@RevenueID varchar(2),
@ExamID varchar(10),
@Exam varchar(50),
@SectionID varchar(3),
@RateA varchar(20),--float,
@RateB varchar(20),--float,
@RateC varchar(20),--float,
@RateD varchar(20),--float,
@RateE varchar(20),--float,
@RateF varchar(20),
@RateG varchar(20) = '',
@RateH varchar(20) = '',
@RateI varchar(20) = '',
@RateJ varchar(20) = '',
@RateK varchar(20) = '',
@RateL varchar(20) = '',
@RateM varchar(20) = '',
@RateN varchar(20) = '',
@Status varchar(1),
@Classification varchar(1),
@FormType varchar(2) = '',
@FilmCode varchar(20) = ''


AS

declare @NewExamID varchar(10),
		@sql as varchar(8000),
		@examField as varchar(15),
		@examSectionField as varchar(15),
		@examIDField as varchar(15),
		@examTableField as varchar(15)
		
		--@RevenueID AS varchar(2),
		--@ExamID AS varchar(10), 
		--@Exam AS varchar(50),
		--@SectionID AS varchar(3),
		--@RateA AS varchar(3),
		--@RateB AS varchar(3),
		--@RateC AS varchar(3),
		--@RateD AS varchar(3),
		--@RateE AS varchar(3),
		--@Status AS varchar(1),
		--@Classification AS varchar(1),
		--@FormType AS varchar(2),
		--@FilmCode AS varchar(20)	

		--set @RevenueID  = 'XR' -- varchar(2),
		--set @ExamID  = '1' -- varchar(10),
		--set @Exam  = 'TEST' -- varchar(50),
		--set @SectionID  = '1' -- varchar(3),
		--set @RateA  = '1' -- varchar(3),
		--set @RateB  = '2' -- varchar(3),
		--set @RateC  = '3' -- varchar(3),
		--set @RateD  = '4' -- varchar(3),
		--set @RateE  = '5' -- varchar(3),
		--set @Status  = '6' -- varchar(1),
		--set @Classification  = 'B' -- varchar(1),
		--set @FormType  = '1' -- varchar(2),
		--set @FilmCode  = '2' -- varchar(20)	

if @RevenueID = 'XR'
begin
	set @examField = 'XRayExam'
	set @examSectionField = 'XRaySectionID'
	set @examIDField = 'XRayExamID'
	set @examTableField = 'tbcoxrayExam'
end

else if @RevenueID = 'CT'
begin
	set @examField = 'CTExam'
	set @examSectionField = 'CTSectionID'
	set @examIDField = 'CTExamID'
	set @examTableField = 'tbcoctexam'
	
end

else if @RevenueID = 'US'
begin
	set @examField = 'UltraExam'
	set @examSectionField = 'UltraSectionID'
	set @examIDField = 'UltraExamID'
	set @examTableField = 'tbcoultraexam'	
end

else if @RevenueID = 'NU'
begin
	set @examField = 'NucExam'
	set @examSectionField = 'NucSectionID'
	set @examIDField = 'NucExamID'
	set @examTableField = 'tbconucexam'	
end

else 
begin
	set @examField = 'OtherRevenue'
	set @examSectionField = 'SectionID'
	set @examIDField = 'OtherRevenueID'
	set @examTableField = 'tbcootherexam'	
end

begin
	set @sql = 'if exists(select * from BUILD_FILE..' + @examTableField + ' where ' + @examIDField + ' = ''' + @ExamID + ''')
 
    begin
      update BUILD_FILE..' + @examTableField + '
       set  ' + @examField + ' = ''' + @Exam + ''',
			' + @examSectionField + ' = ''' + @SectionID + ''','
			
			if @Classification = 'B'
				begin
					set @sql = @sql + '		
						  ReaderFeeA = ''' + @RateA + ''',
						  ReaderFeeB = ''' + @RateB + ''',
						  ReaderFeeC = ''' + @RateC + ''',
						  ReaderFeeD = ''' + @RateD + ''',
						  ReaderFeeE = ''' + @RateE + ''',
						  ReaderFeeF = ''' + @RateF + ''',
						  ReaderFeeG = ''' + @RateG + ''',
						  ReaderFeeH = ''' + @RateH + ''',
						  ReaderFeeI = ''' + @RateI + ''',
						  ReaderFeeJ = ''' + @RateJ + ''',
						  ReaderFeeK = ''' + @RateK + ''',
						  ReaderFeeL = ''' + @RateL + ''',
						  ReaderFeeM = ''' + @RateM + ''',
						  ReaderFeeN = ''' + @RateN + ''','
				end
			else if @Classification = 'C'
				begin
					set @sql = @sql + '		
						  HMORateA = ''' + @RateA + ''',
						  HMORateB = ''' + @RateB + ''',
						  HMORateC = ''' + @RateC + ''',
						  HMORateD = ''' + @RateD + ''',
						  HMORateE = ''' + @RateE + ''',
						  HMORateF = ''' + @RateF + ''',
						  HMORateG = ''' + @RateG + ''',
						  HMORateH = ''' + @RateH + ''',
						  HMORateI = ''' + @RateI + ''',
						  HMORateJ = ''' + @RateJ + ''',
						  HMORateK = ''' + @RateK + ''',
						  HMORateL = ''' + @RateL + ''',
						  HMORateM = ''' + @RateM + ''',
						  HMORateN = ''' + @RateN + ''',' --REYMARK
				end

			else if @Classification = 'D'
				begin
					set @sql = @sql + '		
						  HMOReaderFeeA = ''' + @RateA + ''',
						  HMOReaderFeeB = ''' + @RateB + ''',
						  HMOReaderFeeC = ''' + @RateC + ''',
						  HMOReaderFeeD = ''' + @RateD + ''',
						  HMOReaderFeeE = ''' + @RateE + ''',
						  HMOReaderFeeF = ''' + @RateF + ''',
						  HMOReaderFeeG = ''' + @RateG + ''',
						  HMOReaderFeeH = ''' + @RateH + ''',
						  HMOReaderFeeI = ''' + @RateI + ''',
						  HMOReaderFeeJ = ''' + @RateJ + ''',
						  HMOReaderFeeK = ''' + @RateK + ''',
						  HMOReaderFeeL = ''' + @RateL + ''',
						  HMOReaderFeeM = ''' + @RateM + ''',
						  HMOReaderFeeN = ''' + @RateN + ''','
						  
				end


			else 
				begin
					set @sql = @sql + '		
						  RateA = ''' + @RateA + ''',
						  RateB = ''' + @RateB + ''',
						  RateC = ''' + @RateC + ''',
						  RateD = ''' + @RateD + ''',
						  RateE = ''' + @RateE + ''',
						  RateF = ''' + @RateF + ''',
						  RateG = ''' + @RateG + ''',
						  RateH = ''' + @RateH + ''',
						  RateI = ''' + @RateI + ''',
						  RateJ = ''' + @RateJ + ''',
						  RateK = ''' + @RateK + ''',
						  RateL = ''' + @RateL + ''',
						  RateM = ''' + @RateM + ''',
						  RateN = ''' + @RateN + ''',' --REYMARK
				end
		
		SET @sql = @sql + '
          status = ''' + @Status + ''',
          Classification = ''' + @Classification + ''',
          FormType = ''' + @FormType + '''
          

      where ' + @examIDField + ' = ''' + @ExamID + ''' 
    end
  else
    begin
      insert into BUILD_FILE..' + @examTableField + '
        (' + @examIDField + ', ' + @examField + ', ' + @examSectionField + ','
			
			if @Classification = 'B'
				begin
					set @sql = @sql + 'ReaderFeeA, ReaderFeeb, ReaderFeeC, ReaderFeeD,ReaderFeeE,ReaderFeeF,ReaderFeeG,ReaderFeeH,ReaderFeeI,ReaderFeeJ,ReaderFeeK,ReaderFeeL,ReaderFeeM,ReaderFeeN,'
				end
			else if @Classification = 'C'
				begin
					set @sql = @sql + 'HMORateA, HMORateB, HMORateC, HMORateD, HMORateE, HMORateF, HMORateG,HMORateH,HMORateI,HMORateJ,HMORateK,HMORateL,HMORateM,HMORateN,' --REYMARK
				end				
			else if @Classification = 'D'
				begin
					set @sql = @sql + 'HMOReaderFeeA, HMOReaderFeeB, HMOReaderFeeC, HMOReaderFeeD, HMOReaderFeeE, HMOReaderFeeF, HMOReaderFeeG,HMOReaderFeeH,HMOReaderFeeI, HMOReaderFeeJ, HMOReaderFeeK,HMOReaderFeeL,HMOReaderFeeM,HMOReaderFeeN,'
				end				

			else
				begin
					set @sql = @sql + 'RateA, RateB, RateC, RateD,RateE,RateF,RateG,RateH,RateI,RateJ,RateK,RateL,RateM,RateN,' --REYMARK
				end				
        
        SET @sql = @sql + 'Status,Classification, FormType)
      values
        (
        (select max(cast(' + @examIDField + ' as int)) + 1 
          from BUILD_FILE..' + @examTableField + ' 
          where isnumeric(' + @examIDField + ') = 1),''' + @Exam + ''', ''' 
          + @SectionID +  ''' , ''' +  @RateA +  ''' , ''' +  @RateB +  ''' , ''' 
          +  @RateC +  ''' , ''' +  @RateD +  ''' , ''' +  @RateE +  ''' , ''' +   @RateF +  ''' , ''' +   @RateG +  ''' , ''' +   @RateH +  ''' , ''' +   @RateI +  ''' , ''' + @RateJ +  ''' , ''' + @RateK + @RateL +  ''' , ''' + @RateM +  ''' , ''' + @RateN + ''' , ''' +  @Status 
          +  ''' , ''' +  @Classification +  ''' , ''' +  @FormType + ''' ) 
    end' --REYMARK 
--*/
--[spRadio_SaveExamBuild2]
end
--PRINT (@sql)
EXECUTE (@SQL)