private Venue populateSingleVenueFromDbReader(SqlDataReader dbReader) { var venueCountry = new Country { CountryName = dbReader.GetString(dbReader.GetOrdinal(@"countryName")) }; var venueState = new State { StateName = dbReader.GetString(dbReader.GetOrdinal(@"stateName")), Description = (dbReader.IsDBNull(dbReader.GetOrdinal(@"stateDescription"))) ? "": dbReader.GetString(dbReader.GetOrdinal(@"stateDescription")), Country = venueCountry }; var venueCity = new City { CityName = dbReader.GetString(dbReader.GetOrdinal(@"cityName")), CityId = dbReader.GetInt32(dbReader.GetOrdinal("cityId")), Description = (dbReader.IsDBNull(dbReader.GetOrdinal(@"cityDescription"))) ? "" : dbReader.GetString(dbReader.GetOrdinal(@"cityDescription")), State = venueState }; var venueToReturn = new Venue { VenueName = dbReader.GetString(dbReader.GetOrdinal(@"venueName")), Capacity = dbReader.GetInt32(dbReader.GetOrdinal(@"venueCapacity")), Description = (dbReader.IsDBNull(dbReader.GetOrdinal(@"venueDescription"))) ? "" : dbReader.GetString(dbReader.GetOrdinal(@"venueDescription")), VenueCity = venueCity, VenueId = dbReader.GetInt32(dbReader.GetOrdinal(@"venueId")) }; return venueToReturn; }
private List<City> getCitiesInternal() { List<City> citiesList = new List<City>(); try { using (var conn = new SqlConnection(constructVenuesConnectString())) { conn.Open(); using (var queryCommand = new SqlCommand(CONST_GetAllCities, conn)) using (SqlDataReader reader = queryCommand.ExecuteReader()) { while (reader.Read()) { Country cityCountry = new Country { CountryName = reader.GetString(reader.GetOrdinal("countryName")), CountryId = reader.GetInt32(reader.GetOrdinal("countryId")) }; State cityState = new State { StateName = reader.GetString(reader.GetOrdinal("stateName")), StateId = reader.GetInt32(reader.GetOrdinal("stateId")), Country = cityCountry }; City cityToAdd = new City { CityId = reader.GetInt32(reader.GetOrdinal("cityId")), CityName = reader.GetString(reader.GetOrdinal("cityName")), Description = (reader.IsDBNull(reader.GetOrdinal("cityDescription"))) ? "" : reader.GetString(reader.GetOrdinal("cityDescription")), State = cityState }; citiesList.Add(cityToAdd); } } } } catch { } return citiesList; }