//This is our method that's creating our Employee definition from DataReader.
private Employee PopulateEmployeeDataReader(SqlDataReader dr)
{
Employee employee = new Employee();
employee.EmployeeId = (int) dr["EmployeeID"];
employee.LastName = dr["LastName"].ToString();
employee.FirstName = dr["FirstName"].ToString();
return employee;
}
private Employee PopulateFromDataReader(SqlDataReader dr)
{
Employee employee = new Employee();
EmployeeTerritories et = new EmployeeTerritories();
employee.EmployeeId = (int)dr["EmployeeID"];
employee.LastName = dr["LastName"].ToString();
employee.FirstName = dr["FirstName"].ToString();
employee.EmpTerr = et;
// Convert from the Database into a string, then Parse it out as an int.
// Avoids problems with Visual Studio automatically assigning.
employee.EmpTerr.TerritoryId = int.Parse(dr["TerritoryID"].ToString());
employee.EmpTerr.EmployeeId = int.Parse(dr["EmployeeID"].ToString());
return employee;
}