AMS - VB

/*

CAR_MAINTAIN_Del '' 

*/

ALTER PROCEDURE dbo.CM_EMPLOYEE_Del

@EMP_ID	varchar(15)

AS

	DECLARE @ERRORSYS NVARCHAR(15) = '' 

	IF ( NOT EXISTS ( SELECT * FROM CM_EMPLOYEE WHERE  EMP_ID= @EMP_ID))

		SET @ERRORSYS = ''

--	IF( EXISTS (SELECT * FROM CM_EMPLOYEE WHERE RECORD_STATUS = '1' AND AUTH_STATUS = 'A' AND [EMP_ID] = @EMP_ID))

--		SET @ERRORSYS = '241'

	IF @ERRORSYS <> ''

	BEGIN

		SELECT ErrorCode Result, ErrorDesc ErrorDesc FROM SYS_ERROR WHERE ErrorCode = @ERRORSYS 

		RETURN '0'

	END

BEGIN TRANSACTION

	--LUCTV: 24-06-2019 : KHONG KIEM TRA AUTH_STATUS MA TIEN HANH KIEM TRA CHECKER_ID

	--IF( (SELECT AUTH_STATUS FROM CM_EMPLOYEE WHERE  EMP_ID= @EMP_ID) = 'A')

--	IF( (SELECT CHECKER_ID FROM CM_EMPLOYEE WHERE  EMP_ID= @EMP_ID) IS NOT NULL)

--	BEGIN

--		UPDATE CM_EMPLOYEE SET RECORD_STATUS = '0' WHERE  EMP_ID= @EMP_ID

--		IF @@Error <> 0 GOTO ABORT

--	END

--	ELSE

--	BEGIN

		Delete FROM CM_EMPLOYEE WHERE EMP_ID= @EMP_ID

		IF @@Error <> 0 GOTO ABORT

--	END

COMMIT TRANSACTION

SELECT '0' as Result, '' ErrorDesc

RETURN '0'

ABORT:

BEGIN

		ROLLBACK TRANSACTION

		SELECT '-1' as Result, '' ErrorDesc

		RETURN '-1'

End