sql query basis of confirmation box click

See more:

SQL-Server-2005

C#

ASP.NET

, +

In attendance system,when I enter first time ,user name and password INTIME is calculated.When I enter second time a confirmation message box should be open and ask you have already time-in .Do you want to timeout(punch out)?
If I click 'yes' , timeout should be calculated and inserted into table. If I click 'no' no value inserted into row.

My Sql code is

ALTER PROCEDURE dbo.InOutRegisterSP
	
	(
	@loccation varchar(40),
	@name varchar(30),
	@password varchar(30),
	@remark varchar(50)
	)
	
AS
begin
declare @empcode int,@loccode int,@TimeIn datetime,@TimeOut datetime --declaration section
--select @empcode=EmpCode from MstUser where UserName=@name and UserPass=@password
if(exists(select @empcode=EmpCode from MstUser where UserName=@name and UserPass=@password))
begin
     if(exists(select max(TimeIn) from InOutRegister where PunchDate=getdate()and EmpCode=@empcode ))
     return 0;
     else
     begin
     select @loccode=LocCode from MstLocation where LocName=@loccation
     insert into InOutRegister values(@empcode,@loccode,getdate(),convert(varchar, getdate(), 8),'',@remark)
     end
end   
else
return -1;




	RETURN
	end