insert, update store procedure in sqlserver

 hi, Khan Abrar Ahmed -

not update quantity insert but next query not work

Hi Devandra,

 

can you please try the below script

Declare @count int,@ReturnValue int
BEGIN
Set @count=(Select COUNT(1) from dbo.MyCart where SessionId=@SessionId and Product_Fkid=@Product_Fkid AND ISNULL(Qty,0)=0 )
if(@count=0)
begin
Insert into dbo.MyCart(SessionId,Product_Fkid,Qty,size_Fkid) values (@SessionId,@Product_Fkid,@Qty,@size_Fkid)
Set @ReturnValue=1
return @ReturnValue
END

set @count =(select COUNT(1) from dbo.MyCart where Product_Fkid=@Product_Fkid and SessionId=@SessionId and ISNULL(Qty,0)!=0 )
if(@count =1)
begin
set @ReturnValue =3
end
else
begin
update dbo.MyCart
Set Qty=@Qty
where SessionId=@SessionId and Product_Fkid=@Product_Fkid
Set @ReturnValue=2
end
return @ReturnValue
 

Hi Devendra Kumar thanks for writing below links i hope helpful for you..

http://www.c-sharpcorner.com/UploadFile/rohatash/select-insert-update-delete-using-stored-procedure-in-sql/

 

http://www.aspsnippets.com/Articles/Single-Stored-Procedure-for-Select-Insert-Update-Delete-in-SQL-Server.aspx

 

http://www.codeproject.com/Questions/429775/Creating-stored-procedure-for-insert-and-update-in 

 

if find helpful answer mark as correct 

my procedure work in case : insert and update proper 

 

i want when any product  already add in my cart  and when click same product to add my cart then it prevents not add i.e i add  x product in my cart and when i click again x product then it not add in my cart:  for that i use this sp:

 

Hi Devandra,

 

Could you please be a bit more elaborative as to what part of the procedure is working and which part is not working and also in what case.

That would help is solving the problem.

 

Thanks