ERROR: EXECUTENONQUERY return -1 value in C# ?

See more:

C#

Hi,

Below are my method-->

public static bool SaveXmlInfo(Sales1 sales1)
{
   int recordsAffected = 0;
   XElement planPropertyElement = XElement.Parse(orderXml);
   
   using (SqlConnection conn = new SqlConnection(ConnectionString1))
   {
      conn.Open();
      SqlParameter[] parms = new SqlParameter[2];
      parms[0] = new SqlParameter("@RCustId", sales1.RCustId);
      parms[1] = new SqlParameter("@SesId", sales1.SesId);
      parms[2] = new SqlParameter
                     {   ParameterName = "@CenXml",
                         SqlDbType = SqlDbType.Xml,
                         Value = new SqlXml(planPropertyElement.CreateReader())
                     };
      recordsAffected = SqlHelper.ExecuteNonQuery(conn, CommandType.StoredProcedure, "usp_PurchXml", parms);

      salesPurchase = null;
   }
   
   return recordsAffected > 0 ? true : false;
}

In my Stored Procedure, I am checking SesId available or not.If it is available then i am updating record else I am inserting new record into table.
Below are my Stored Procedure

IF EXISTS(SELECT * FROM Cust1 WITH(NOLOCK) WHERE Cust1.SesId=@SesId)  
   BEGIN  
      UPDATE Cust1
         SET Cust1.OrderXml=@CenXml  
        FROM Cust1 INNER JOIN Cust ON Cust1.CustomerId=Cust.RepCustId  
       WHERE Cust1.CustomerId=@RCustId
   END  
ELSE  
   BEGIN  
      INSERT INTO Cust1(CustomerId,SessionId,OrderDateTime,colXml)
      VALUES(@RCustId,@SesId,GETDATE(),@CenXml);  
   END

Error:
Everytime variable recordsAffected set to -1 I want to set it 1 if any transaction has been made.
[Edit]Code block added, shouting removed[/Edit]