//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; }