public static EventListView FromSearchHits(IEnumerable<ConcertSearchHit> hits)
{
var city = new City();
var view = new EventListView()
{
ConcertsList = hits.Select(h => new Concert
{
ConcertId = int.Parse(h.ConcertId),
ConcertName = h.ConcertName,
ConcertDate = h.ConcertDate.LocalDateTime,
Performer = new Performer
{
PerformerId = h.PerformerId, ShortName = h.PerformerName
},
PerformerId = h.PerformerId,
Venue = new Venue
{
VenueId = h.VenueId, VenueName = h.VenueName, Description = h.PerformerName, VenueCity = new City
{
CityName = h.VenueCity
}
},
VenueId = h.VenueId
}).ToList(),
VenuesList = hits.Select(h => new
{
h.VenueId, h.VenueName, h.VenueCity, h.VenueState
})
.Distinct()
.Select(v => new Venue
{
VenueId = v.VenueId, VenueName = v.VenueName, VenueCity = new City
{
CityName = v.VenueCity, State = new State
{
StateName = v.VenueState
}
}
})
.ToList()
};
return view;
}
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;
}