Error while query returns null value?

[sanjeev40084]

In my sqlMap, i have a code that calls stored procedure and returns count of
employee. Anytime employee count is null, my programs seems to fail.

Here is the code.

Employee.cs

        int? employeeCount;
        public int? EmployeeCount
        {
            get { return employeeCount; }
            set { if(value.HasValue)
                    {
                        employeeCount = value;
                    }
                    else
                    {
                        employeeCount = 0;
                    }
                }
        }


SqlMap.xml

<alias>
   <typeAlias alias="Employee" type="Test.Domain.Employee, Test.Domain"/>
   <typeAlias alias="EmployeeParameters"
type="Test.Domain.EmployeeParameters, Test.Domain"/>
</alias>

<parameterMap id ="testParameters" class="EmployeeParameters">
                  <parameter property="EmployeeID"  column="employeeId"/>
                  <parameter property="Year" column="Year"/>
</parameterMap>

<resultMap id="employeeMap"  class="Employee">
       <result property="EmployeeCount"   column="totalCount"/>          
</resultMap>

<procedure id="GetEmployeeCount" parameterMap="testParameters"  resultMap
="employeeMap">
                  test..GetTotalEmployeeCount
</procedure>


Now this is where it is being called:

public int GetEmpCount(EmployeeParameters employeeParameters)
        {
            try
            {
                Employee employee = new Employee();
                employee
=_empDataSource.QueryForObject<Participant>(Constants.GET_EMP_COUNT,
EmployeeParameters );

                int? empCount = employee.employeeCount  <--When the employee
Count is null, employee = null, thus this line breaks)

                if(empCount  > 0)
                {
                    return (int) empCount;
                }
                return 0;
            }
            catch (Exception ex)
            {
                throw new Exception("Unable to retrieve employee counts",
ex);
            }
        }

any suggestions?


-- 
View this message in context: 
http://www.nabble.com/Error-while-query-returns-null-value--tp23855885p23855885.html
Sent from the iBATIS - User - Cs mailing list archive at Nabble.com.