insert update query in sql server

Question

hi any buddy help please

 

i have one sp in which i will insert and update up product like this:

 

 

 

Create PROCEDURE [dbo].[Sp_AddToMyCart]

@SessionId varchar(500),

@Product_Fkid int,

@size_Fkid int,

@Qty int

AS

Declare @count int,@ReturnValue int

BEGIN

Set @count=(Select COUNT(1) from dbo.MyCart where SessionId=@SessionId and Product_Fkid=@Product_Fkid)

if(@count=0)

begin

Insert into dbo.MyCart(SessionId,Product_Fkid,Qty,size_Fkid) values (@SessionId,@Product_Fkid,@Qty,@size_Fkid)

Set @ReturnValue=1

end

 

 

else

begin

update dbo.MyCart

Set Qty=@Qty

where SessionId=@SessionId and Product_Fkid=@Product_Fkid

Set @ReturnValue=2

end

return @ReturnValue

END

 

 

 

insert update work properly but i face a problem when

i want insert same product then it return this product already add in your cart