public WCFWebServiceJson()
{
SqlAccountRepository = new SqlAccountRepository(ConnectionString);
SqlAlbumRepository = new SqlAlbumRepository(ConnectionString);
SqlAlbumGenreRepository = new SqlAlbumGenreRepository(ConnectionString);
SqlAlbumSongRepository = new SqlAlbumSongRepository(ConnectionString);
SqlArtistRepository = new SqlArtistRepository(ConnectionString);
SqlArtistAlbumRepository = new SqlArtistAlbumRepository(ConnectionString);
SqlArtistGenreRepository = new SqlArtistGenreRepository(ConnectionString);
SqlBusinessTypeRepository = new SqlBusinessTypeRepository(ConnectionString);
SqlBusinessUserRepository = new SqlBusinessUserRepository(ConnectionString);
SqlCountyCityRepository = new SqlCountyCityRepository(ConnectionString);
SqlGenreRepository = new SqlGenreRepository(ConnectionString);
SqlMediaAssetFormatRepository = new SqlMediaAssetFormatRepository(ConnectionString);
SqlMediaAssetLocationRepository = new SqlMediaAssetLocationRepository(ConnectionString);
SqlMediaAssetRepository = new SqlMediaAssetRepository(ConnectionString);
SqlMediaAssetTypeRepository = new SqlMediaAssetTypeRepository(ConnectionString);
SqlPlaylistRepository = new SqlPlaylistRepository(ConnectionString);
SqlPlaylistSongRepository = new SqlPlaylistSongRepository(ConnectionString);
SqlProtocolRepository = new SqlProtocolRepository(ConnectionString);
SqlPurchasedSongRepository = new SqlPurchasedSongRepository(ConnectionString);
SqlSongRepository = new SqlSongRepository(ConnectionString);
SqlSongGenreRepository = new SqlSongGenreRepository(ConnectionString);
SqlSongMediaAssetRepository = new SqlSongMediaAssetRepository(ConnectionString);
SqlUserRepository = new SqlUserRepository(ConnectionString);
SqlUserPlaylistRepository = new SqlUserPlaylistRepository(ConnectionString);
}
private List<Genre> GetArtistGenreCollection(int userId)
{
var artistGenreRepository = new SqlArtistGenreRepository(ConnectionString);
var genreRepository = new SqlGenreRepository(ConnectionString);
var userGenres = artistGenreRepository.GetArtistGenresByArtistId(userId);
var genres = userGenres.Select(userGenre => genreRepository.Genre.FirstOrDefault(x => x.GenreId == userGenre.GenreId)).ToList();
return genres;
}