C#

class WorkerClass
    {
        public delegate void addToRTBDelegate(String text);
        public event addToRTBDelegate eventRTBadd;
        private SerialPort comport = new SerialPort();

        private void port_DataReceived(object sender, SerialDataReceivedEventArgs e)
        {
            
            Console.WriteLine("Data received on serial port");
        }

        public void openCOMPort()
        {
            comport.DataReceived += new SerialDataReceivedEventHandler(port_DataReceived);
            comport.Open();
            Console.WriteLine("Comport is Open");
            
            for (int i = 1; i < 10; i++)
            {
                Thread.Sleep(1000);
            }
            Console.WriteLine("exited loop");
                
        }

     }

Test-Form-Thread-2.vshost.exe' (Managed): Loaded 'D:\ISS\C-SHarp\Test-From-Worker-1\Test-Form-Thread-2\bin\Debug\Test-Form-Thread-2.exe', Symbols loaded.
Comport is Open
Data received on serial port
The thread 0x27cc has exited with code 0 (0x0).
exited loop
Data received on serial port
Data received on serial port

~	 	15648		[Thread Ended]			
0	 	4736	Worker Thread	<No Name>		Highest	0
0	 	13456	Worker Thread	<No Name>		Normal	0
0	 	13632	Worker Thread	<No Name>		Normal	0
0	 	15912	Worker Thread	<No Name>		Normal	0
0	 	11144	Worker Thread	vshost.RunParkingWindow		Normal	0
0	 	14892	Worker Thread	.NET SystemEvents		Normal	0
0	>	10840	Main Thread	Main Thread	Test_Form_Thread_2.Program.Main	Normal	0

~	 	15648		[Thread Ended]			
0	 	4736	Worker Thread	<No Name>		Highest	0
0	 	13456	Worker Thread	<No Name>		Normal	0
0	 	13632	Worker Thread	<No Name>		Normal	0
0	 	15912	Worker Thread	<No Name>		Normal	0
0	 	11144	Worker Thread	vshost.RunParkingWindow		Normal	0
0	 	14892	Worker Thread	.NET SystemEvents		Normal	0
0	>	10840	Main Thread	Main Thread	Test_Form_Thread_2.Program.Main	Normal	0
0	 	15240	Worker Thread	ThreadClass1	Test_Form_Thread_2.WorkerClass.openCOMPort	Normal	0
0	 	3208	Worker Thread	<No Name>		Normal	0
0	 	12668	Worker Thread	<No Name>		Normal	0

~	 	15648		[Thread Ended]			
0	 	4736	Worker Thread	<No Name>		Highest	0
0	 	13456	Worker Thread	<No Name>		Normal	0
0	 	13632	Worker Thread	<No Name>		Normal	0
0	 	15912	Worker Thread	<No Name>		Normal	0
0	 	11144	Worker Thread	vshost.RunParkingWindow		Normal	0
0	 	14892	Worker Thread	.NET SystemEvents		Normal	0
0	>	10840	Main Thread	Main Thread	Test_Form_Thread_2.Program.Main	Normal	0
0	 	3208	Worker Thread	<No Name>		Normal	0
0	 	12668	Worker Thread	<No Name>		Normal	0

create PROCEDURE [dbo].[Ins_Products] 
	-- Add the parameters for the stored procedure here
	@ProductName nvarchar(max),
	@ProductModel nvarchar(max),
	@ProductColor nvarchar(50),
	@ProductDescription nvarchar(max),
	@ProductPrice bigint,
	@ProductQuantity int


AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for procedure here
declare @ProductID  bigint;
--set @ProductID=-1

	if Not Exists ( Select @ProductID = ProductID From Products 
					Where ProductModel=@ProductModel)
	Begin
		Insert Into Products (ProductName,ProductModel,ProductColor,ProductDescription,ProductPrice,ProductQuantity)
		Values(@ProductName,@ProductModel,@ProductColor,@ProductDescription,@ProductPrice,@ProductQuantity)
	    select @ProductID=@@Identity
	End
	else
	
	Begin
		Update Products 
			Set ProductName=@ProductName ,ProductModel=@ProductModel ,
				ProductColor=@ProductColor,
				ProductDescription=@ProductDescription,
				ProductPrice=@ProductPrice,ProductQuantity=@ProductQuantity
			where (ProductID=@ProductID)
	End
return @ProductID
END

Msg 102, Level 15, State 1, Procedure Ins_Products, Line 26
Incorrect syntax near '='.
Msg 156, Level 15, State 1, Procedure Ins_Products, Line 33
Incorrect syntax near the keyword 'else'.