store procedure in asp.net

See more:

C#

ASP.NET

i have used triger on table.This triger is fire when i insert data in LeaveFrom Table.In My Stored procedure if condition i have put.when i put if condition code in if condition is not working.If i remove if codition then insert work successfully.My I have try this code in Query builder.data is comming when if is fire.but what is problem in storeprocedure code,that i dont know.

My Triger is:

ALTER TRIGGER Trigger2
ON dbo.LeaveForm

AFTER INSERT

AS
Begin
EXEC Biometrics_InsertFrom_LeaveForm
End

My Storeprocedure is..

ALTER PROCEDURE dbo.Biometrics_InsertFrom_LeaveForm
	

AS


Declare @Count int
Declare @LeaveFrom datetime
Declare @LeaveTo datetime
Declare @Approve bit
set @Approve='True'
		select @Count=count(*) from LeaveForm where Approve=@Approve and (convert(varchar,@LeaveFrom,101)=convert(varchar,getdate(),101) or convert(varchar,@LeaveTo,101)=convert(varchar,getdate(),101))
	
		if(@Count > 0)
			   begin
			INSERT INTO Biometrics (PCL,PLE)
			VALUES        (getdate(),getdate())

end
	RETURN