could any one show what's wrong with my stored procedure?

 

  public int Update(int iEmpIndex, string strPassword, string 
strFirstName,
                            
string strLastName, int iDesigIndex, int 
iUsedAnnualLeaves,
                            
int iUsedSickLeaves, DateTime enteredate, DateTime 
updatedDate)
        
{
            
try
            
{
                
//updating the DB: VALUES PASSED CORRECTLY BUT DOESNT PERFORM THE 
TASK
                
return empAdapter.Update(strPassword, strFirstName, strLastName, 
iDesigIndex,
                    
iUsedAnnualLeaves, iUsedSickLeaves, enteredate, updatedDate, 
this.OldEmpIndex,
                    
this.OldPassword, this.OldFirstName, this.OldLastName, 
this.OldDesigIndex,
                    
this.OldUsedAnnualLeaves, this.OldUsedSickLeaves, this.OldEnteredDate, 

                    
this.OldUpdatedDate);
            
}
            
catch
            
{
                
throw;
            
}
        }

thsi update satement maps to the stored procedure that has the followin SQL 
query: 
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER 
PROCEDURE [dbo].[ProcUpdateEmployee]
(
 @Password 
nvarchar(50),
 @FirstName nvarchar(50),
 @LastName 
nvarchar(50),
 @DesigIndex int,
 @UsedAnnualLeaves 
int,
 @UsedSickLeaves int,
 @EntryDate 
datetime,
 @UpdatedDate datetime,
 @Original_EmpIndex 
int,
 @Original_Password nvarchar(50),
 @Original_FirstName 
nvarchar(50),
 @Original_LastName 
nvarchar(50),
 @Original_DesigIndex 
int,
 @Original_UsedAnnualLeaves int,
 @Original_UsedSickLeaves 
int,
 @Original_EntryDate datetime,
 @Original_UpdatedDate 
datetime,
 @EmpIndex int
)
AS
 SET NOCOUNT OFF;
UPDATE 
[tblEmployees] 
SET 
[Password] = @Password, 
[FirstName] = @FirstName, 

[LastName] = @LastName, 
[DesigIndex] = @DesigIndex, 

[UsedAnnualLeaves] = @UsedAnnualLeaves, 
[UsedSickLeaves] = 
@UsedSickLeaves, 
[EntryDate] = @EntryDate, 
[UpdatedDate] = @UpdatedDate 

WHERE (([EmpIndex] = @Original_EmpIndex) 
AND 
([Password] = 
@Original_Password) 
AND 
([FirstName] = @Original_FirstName) 
AND 

([LastName] = @Original_LastName) 
AND 
([DesigIndex] = 
@Original_DesigIndex) 
AND
([UsedAnnualLeaves] = 
@Original_UsedAnnualLeaves) 
AND 
([UsedSickLeaves] = 
@Original_UsedSickLeaves) 
AND 
([EntryDate] = @Original_EntryDate) 

AND 
([UpdatedDate] = @Original_UpdatedDate));
 
SELECT 
EmpIndex, Password, FirstName, LastName, DesigIndex, UsedAnnualLeaves, 
UsedSickLeaves, EntryDate, UpdatedDate FROM tblEmployees WHERE (EmpIndex = 
@EmpIndex)