public Position GetByID(int _positionID) { PositionDAC _positionComponent = new PositionDAC(); IDataReader reader = _positionComponent.GetByIDPosition(_positionID); Position _position = null; while (reader.Read()) { _position = new Position(); if (reader["PositionID"] != DBNull.Value) _position.PositionID = Convert.ToInt32(reader["PositionID"]); if (reader["SiteID"] != DBNull.Value) _position.SiteID = Convert.ToInt32(reader["SiteID"]); if (reader["Name"] != DBNull.Value) _position.Name = Convert.ToString(reader["Name"]); if (reader["Code"] != DBNull.Value) _position.Code = Convert.ToString(reader["Code"]); _position.NewRecord = false; } reader.Close(); return _position; }