USE [LABORATORY]
GO
/****** Object:  StoredProcedure [dbo].[LAB_AssessmentEntry]    Script Date: 11/22/2017 13:10:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO



ALTER PROCEDURE [dbo].[LAB_AssessmentEntry]
	@FullName varchar(50),
	@ItemID varchar(4),
	@Amount float,
	@UserID varchar(8),
	@TransDate DateTime, 
	@intFirstPass int,
	@Quantity float ,
	@RequestDocID varchar(4),
	@PackageCode varchar(3),
	@PackageAmount float,
	@SpecimenId varchar(4),
	@Rush varchar(1),
	@Transplant varchar(1),
	@Dialysis varchar(1),
	@HospNum varchar(10),
	@RefNum varchar(12),
	@IDNum varchar(10),
	@RevenueId varchar(40),
	@OutsideDoctor varchar(50),
	@ProfId1 varchar(10),
	@ProfFee1 float,
	@OPService bit = 0,
 	@Barcode varchar(30) = null,
    @Remarks VARCHAR(200) = ''
AS

DECLARE @RequestNum varchar(12),
	@WithSurcharge bit,
	@WithMarkUp varchar(1),
	@DrCr VARCHAR(1),
	@SummaryCode VARCHAR(2)


If @Revenueid  = 'MD'
	begin
		set @DrCr = 'P';
		SET @SummaryCode = 'LB'
	end;
ELSE
	BEGIN
		set @DrCr = 'D';
		SET @SummaryCode = 'LB'
	END;


Set @WithMarkUp = IsNull(Laboratory.dbo.fn_LabAddMarkup (getdate(), @ItemId, 'O'),'N');

if @WithMarkup = 'N' Set @WithSurcharge = 0 Else Set @WithSurcharge = 1;

If @Transplant='-' Set @Transplant = '0';
If @Dialysis='-' Set @Dialysis = '0';

/* *************************** Assign to Variables ****************** */

--Set @RefNum=(Select 'LB'+Cast(AssessmentNum as Varchar(12)) From billing..tbAssessmentNum);
Set @RequestNum=(Select Cast(RequestNum as Varchar(12)) From Billing..tbAssessmentNum);
Update Billing..tbAssessmentNum
Set RequestNum = RequestNum + 1;

/* ************************ Append to tbCashAssessment ************ */

Insert Into Billing..tbCashAssessment
    (IDNum, [Name], TransDate, AssessNum, DrCr, ItemID, Quantity, RefNum, Amount, UserID, RevenueID, RequestDocID, 
     PackageCode, PackageAmount, Rush, SpecimenID, HospNum, Transplant, Dialysis, DepartmentId, DoctorName, 
     ProfID1, ProfFee1, WithSurcharge, OPService, Barcode)
Values
    (@IdNum,@FullName, getdate(), @RequestNum, @DrCr, @ItemID, @Quantity , 
     @RefNum, @Amount, @UserID, @RevenueId,@RequestDocID,@PackageCode, @PackageAmount,
     @Rush, @SpecimenID, @HospNum, @Transplant, @Dialysis, @SummaryCode, @OutsideDoctor, 
     @ProfID1, @ProfFee1, @WithSurcharge, @OPService, @Barcode);