private DepartmentHazard.DepartmentHazardSelectCommandRow getDepartmentPerson(int departmentPersonId)
 {
     DepartmentHazard.DepartmentHazardSelectCommandRow dataRow = null;
     DepartmentHazardTableAdapters.DepartmentHazardSelectCommandTableAdapter tableAdapter = new DepartmentHazardTableAdapters.DepartmentHazardSelectCommandTableAdapter();
     IEnumerator iEnumerator = tableAdapter.GetDepartmentHazardById(departmentPersonId, loggedInUserCoId).GetEnumerator();
     if (iEnumerator.MoveNext())
     {
         dataRow = (DepartmentHazard.DepartmentHazardSelectCommandRow)iEnumerator.Current;
     }
     return dataRow;
 }