public List<Venues> GetAll()
{
VenuesDAC _venuesComponent = new VenuesDAC();
IDataReader reader = _venuesComponent.GetAllVenues().CreateDataReader();
List<Venues> _venuesList = new List<Venues>();
while (reader.Read())
{
if (_venuesList == null)
_venuesList = new List<Venues>();
Venues _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;
_venuesList.Add(_venues);
} reader.Close();
return _venuesList;
}
