CREATE PROC [dbo].[SP_URETICI_KODU_KAYIT]
(
@CODE VARCHAR(MAX),
@FIRMA VARCHAR(MAX),
@PCODE VARCHAR(MAX),
@PCODE2 VARCHAR(MAX)
)
AS
BEGIN
DECLARE @ITEMID INT
DECLARE @COMPID INT
DECLARE @PROID INT
DECLARE @PROID2 INT
DECLARE @PRCID INT 
SET @ITEMID = ISNULL((SELECT REF FROM [IHR].[dbo].[ITEMS] WHERE CODE=@CODE),0)
IF @FIRMA<>''
BEGIN
SET @COMPID = ISNULL((SELECT REF FROM [IHR].[dbo].[COMPANIES] WHERE DEFINITION_=@FIRMA),0)
END
ELSE
BEGIN
SET @COMPID = 0;
END

IF @PCODE<>''
BEGIN
INSERT INTO [IHR].[dbo].[PRODUCERCODES] (STOCKREF,CLIENTREF,[PRODUCERCODE],[STS]) VALUES (@ITEMID,@COMPID,@PCODE,1)
SET @PROID = @@IDENTITY
END
ELSE
BEGIN
SET @PROID = 0
END

IF @PCODE2<>''
BEGIN
INSERT INTO [IHR].[dbo].[PRODUCERCODES] (STOCKREF,CLIENTREF,[PRODUCERCODE],[STS]) VALUES (@ITEMID,@COMPID,@PCODE2,2)
SET @PROID2 = @@IDENTITY
END
ELSE
BEGIN
SET @PROID2 = 0
END

SET @PRCID = ISNULL((SELECT TOP 1 REF FROM [IHR].[dbo].[PRCLIST] WHERE [ITEMREF]=@ITEMID ORDER BY REF ASC),0)
IF @PROID <> 0
BEGIN
INSERT INTO [IHR].[dbo].[PRODPRC] ([PRODUCERCODEREF],[PRCLISTREF]) VALUES (@PROID,@PRCID)
END
IF @PROID2 <> 0
BEGIN
INSERT INTO [IHR].[dbo].[PRODPRC] ([PRODUCERCODEREF],[PRCLISTREF]) VALUES (@PROID2,@PRCID)
END
END