Returning Value From Sql To C#

hello,

I have a small problem. i'm adding records into the DB. the primary key
is the company name which is abviously unique. before saving the record
i check in the stored procedure if the company code is unique or not.
if unique then the record is added & an output parameter is set to
2 & should b returned to the data access layer. if not unique then
3 should be returned. but everytime it seems to be returning 2 whether
it is unique or not. can u plz help me? here is the code of the data
access layer:

cmd.Parameters.Add("@Status", SqlDbType.Int);

cmd.Parameters["@Status"].Value = ParameterDirection.ReturnValue;



//cmd.UpdatedRowSource = UpdatedRowSource.OutputParameters;

cmd.ExecuteNonQuery();

status = (int)cmd.Parameters["@Status"].Value;




here is the stored procedure:

CREATE PROCEDURE spOrganizationAdd(

@OrgCode varchar(10),

@OrgName varchar(50),

@AddressLine1 varchar(30),

@AddressLine2 varchar(30),

@City varchar(15),

@State varchar(15),

@Country varchar(15),

@PinCode varchar(7),

@Phone varchar(20),

@Fax varchar(20),

@Website varchar(30),

@Email varchar(50),

@CreatedBy int,

@LastModifiedBy int,

@Status INTEGER OUTPUT) AS

BEGIN TRAN

IF EXISTS(SELECT OrgCode FROM tblOrganizationMaster WHERE OrgCode = @OrgCode)

BEGIN

SET @Status = 3



END

ELSE

BEGIN

INSERT INTO tblOrganizationMaster VALUES(

@OrgCode,

@OrgName,

@AddressLine1 ,

@AddressLine2 ,

@City ,

@State,

@Country,

@PinCode,

@Phone,

@Fax ,

@Website,

@Email,

@CreatedBy ,

GETDATE(),

@LastModifiedBy ,

GETDATE())

SET @Status = 2

END

IF @@ERROR = 0 COMMIT TRAN

ELSE ROLLBACK TRAN



plz reply as soon as possible.