CREATE PROCEDURE [dbo].[sp_UpdateOrInsertSiparis]
    @stockRef INT,
    @userId INT,
    @amount VARCHAR(50)
AS
BEGIN
	DECLARE @durum SMALLINT
    -- Mevcut kaydi kontrol et
    IF EXISTS (SELECT * FROM STOK_RAPOR_SIPARISLER 
               WHERE STOCKREF = @stockRef AND USERID = @userId AND TYPE_ = 0)
    BEGIN
		SET @durum = 1
        -- Eger mevcut kayit var ve TYPE_ degeri 0 ise, AMOUNT sütununu güncelle
        UPDATE STOK_RAPOR_SIPARISLER
        SET AMOUNT = @amount
        WHERE STOCKREF = @stockRef AND USERID = @userId AND TYPE_ = 0;
    END
    ELSE
    BEGIN
		SET @durum = 2
        -- Aksi takdirde, yeni bir satir ekle
        INSERT INTO STOK_RAPOR_SIPARISLER (STOCKREF, USERID, AMOUNT, TYPE_)
        VALUES (@stockRef, @userId, @amount, 0);
    END
		INSERT INTO STOK_RAPOR_SIPARISLER_LOG (STOCKREF, USERID, AMOUNT, TYPE_)
        VALUES (@stockRef, @userId, @amount, @durum);
END;