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