Exemple #1
0
 public List<Travel> GetAllByConferenceID(int ConferenceID)
 {
     TravelDAC _travelComponent = new TravelDAC();
     IDataReader reader = _travelComponent.GetAllTravel("ConferenceID = " + ConferenceID).CreateDataReader();
     List<Travel> _travelList = new List<Travel>();
     while (reader.Read())
     {
         if (_travelList == null)
             _travelList = new List<Travel>();
         Travel _travel = new Travel();
         if (reader["ID"] != DBNull.Value)
             _travel.ID = Convert.ToInt32(reader["ID"]);
         if (reader["Name"] != DBNull.Value)
             _travel.Name = Convert.ToString(reader["Name"]);
         if (reader["TransportationTypeID"] != DBNull.Value)
             _travel.TransportationTypeID = Convert.ToInt32(reader["TransportationTypeID"]);
         if (reader["Description"] != DBNull.Value)
             _travel.Description = Convert.ToString(reader["Description"]);
         if (reader["ConferenceID"] != DBNull.Value)
             _travel.ConferenceID = Convert.ToInt32(reader["ConferenceID"]);
         _travel.NewRecord = false;
         _travelList.Add(_travel);
     } reader.Close();
     return _travelList;
 }