public List <AlbumHasGenre> GetGenres(int albumId)
{
using (var conn = CreateConnection())
{
List <AlbumHasGenre> album = new List <AlbumHasGenre>();
SqlCommand cmd = new SqlCommand("getGenresFromAlbum", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@albumId", SqlDbType.Int, 4).Value = albumId;
conn.Open();
using (var reader = cmd.ExecuteReader())
{
int albumHasGenreIdIndex = reader.GetOrdinal("Album_has_GenreId");
int albumIdIndex = reader.GetOrdinal("AlbumId");
int genreIndex = reader.GetOrdinal("Genre");
int genreIdIndex = reader.GetOrdinal("GenreId");
while (reader.Read())
{
AlbumHasGenre ahg = new AlbumHasGenre();
ahg.Genre = reader.GetString(genreIndex);
ahg.Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex);
ahg.GenreId = reader.GetInt32(genreIdIndex);
ahg.AlbumId = reader.GetInt32(albumIdIndex);
album.Add(ahg);
/*album.Add( new AlbumHasGenre
* {
* Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex),
* GenreId = reader.GetInt32(genreIdIndex),
* AlbumId = reader.GetInt32(albumIdIndex),
* Genre = reader.GetString(genreIdIndex)
* });*/
}
return(album);
}
}
}
public List<AlbumHasGenre> GetGenres(int albumId)
{
using (var conn = CreateConnection())
{
List<AlbumHasGenre> album = new List<AlbumHasGenre>();
SqlCommand cmd = new SqlCommand("getGenresFromAlbum", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@albumId", SqlDbType.Int, 4).Value = albumId;
conn.Open();
using (var reader = cmd.ExecuteReader())
{
int albumHasGenreIdIndex = reader.GetOrdinal("Album_has_GenreId");
int albumIdIndex = reader.GetOrdinal("AlbumId");
int genreIndex = reader.GetOrdinal("Genre");
int genreIdIndex= reader.GetOrdinal("GenreId");
while (reader.Read())
{
AlbumHasGenre ahg = new AlbumHasGenre();
ahg.Genre = reader.GetString(genreIndex);
ahg.Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex);
ahg.GenreId = reader.GetInt32(genreIdIndex);
ahg.AlbumId = reader.GetInt32(albumIdIndex);
album.Add(ahg);
/*album.Add( new AlbumHasGenre
{
Album_has_GenreId = reader.GetInt32(albumHasGenreIdIndex),
GenreId = reader.GetInt32(genreIdIndex),
AlbumId = reader.GetInt32(albumIdIndex),
Genre = reader.GetString(genreIdIndex)
});*/
}
return album;
}
}
}
