/****** Object:  StoredProcedure [dbo].[SAVE_OFFERING_BARCODES]    Script Date: 27.02.2016 11:08:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
IF EXISTS (SELECT * FROM sys.objects WHERE type = 'P' AND OBJECT_ID = OBJECT_ID('dbo.SAVE_OFFERING_BARCODES'))
   exec('DROP PROCEDURE [dbo].[SAVE_OFFERING_BARCODES] ')
GO
CREATE PROCEDURE [dbo].[SAVE_OFFERING_BARCODES]
	@OfferingID uniqueidentifier, 
	@ID  uniqueidentifier, 
	@Barcode  nvarchar(35), 
	@Quantity decimal(15,4)
AS
BEGIN
	SET NOCOUNT ON;
	
	declare @CurrentUserID uniqueidentifier = (SELECT TOP 1 [UserContactID] FROM [dbo].[tbl_AdminUnit] WHERE [Name] = SYSTEM_USER)

	IF (0 = @Quantity OR '' = @Barcode)
	BEGIN
		DELETE FROM [dbo].[tbl_OfferingCodes]
		WHERE 
			[ID] = @ID
		SELECT 1
	END
	ELSE 
	IF (@ID IS NULL AND NOT EXISTS (SELECT 1 FROM [dbo].[tbl_OfferingCodes] WHERE [Code] = @Barcode AND [OfferingID] = @OfferingID ))
	BEGIN
		INSERT INTO [dbo].[tbl_OfferingCodes]
		(
			[CreatedOn],
			[CreatedByID],
			[ModifiedOn],
			[ModifiedByID],
			[OfferingID],
			[Code],
			[Quantity],
			[Type]
		)
		VALUES(
			GETDATE(),
			@CurrentUserID,
			GETDATE(),
			@CurrentUserID,
			@OfferingID,
			@Barcode,
			@Quantity,
			'bt_TSD'
		)
		SELECT 1
	END
	ELSE
	BEGIN
		UPDATE[dbo].[tbl_OfferingCodes]
		SET
			[ModifiedOn] = GETDATE(),
			[ModifiedByID] = @CurrentUserID,
			[Code] = @Barcode,
			[Quantity] = @Quantity
		WHERE
			[ID] = @ID 
		SELECT 1
	END
END


exec SAVE_OFFERING_BARCODES @Barcode=N'4820000191982',@OfferingID='B74BF08E-A9B5-4D34-8074-98D253B26A8A',@ID='402B0FBF-3B11-46F0-B5DF-21D9453FF110',@Quantity=1