예제 #1
0
 public Venues GetByID(int _iD)
 {
     VenuesDAC _venuesComponent = new VenuesDAC();
     IDataReader reader = _venuesComponent.GetByIDVenues(_iD);
     Venues _venues = null;
     while (reader.Read())
     {
         _venues = new Venues();
         if (reader["ID"] != DBNull.Value)
             _venues.ID = Convert.ToInt32(reader["ID"]);
         if (reader["Name"] != DBNull.Value)
             _venues.Name = Convert.ToString(reader["Name"]);
         if (reader["Description"] != DBNull.Value)
             _venues.Description = Convert.ToString(reader["Description"]);
         if (reader["Location"] != DBNull.Value)
             _venues.Location = Convert.ToString(reader["Location"]);
         if (reader["Star"] != DBNull.Value)
             _venues.Star = Convert.ToInt32(reader["Star"]);
         if (reader["URL"] != DBNull.Value)
             _venues.URL = Convert.ToString(reader["URL"]);
         if (reader["Phone"] != DBNull.Value)
             _venues.Phone = Convert.ToString(reader["Phone"]);
         if (reader["Fax"] != DBNull.Value)
             _venues.Fax = Convert.ToString(reader["Fax"]);
         if (reader["Email"] != DBNull.Value)
             _venues.Email = Convert.ToString(reader["Email"]);
         _venues.NewRecord = false;
     } reader.Close();
     return _venues;
 }