public Genre GetWithAlbums(string genreName)
{
using (var cn = MusicStoreConnection)
{
var dr = cn.ExecuteReader(
"SELECT * " +
" FROM Genre G" +
" JOIN Album A ON A.GenreId = G.GenreId" +
" WHERE G.Name = @Name", new {Name = genreName});
Genre genre = null;
while (dr.Read())
{
if (genre == null)
{
genre = new Genre
{
GenreId = Convert.ToInt32(dr["GenreId"]),
Name = dr["Name"].ToString(),
Description = dr["Description"].ToString()
};
}
genre.Albums.Add(new Album
{
AlbumId = Convert.ToInt32(dr["AlbumId"]),
Title = dr["Title"].ToString(),
Price = Convert.ToDecimal(dr["Price"]),
AlbumArtUrl = dr["AlbumArtUrl"].ToString(),
GenreId = Convert.ToInt32(dr["GenreId"]),
Genre = genre
});
}
return genre;
}
}
public static GenreMenuViewModel ToViewModel(Genre genre)
{
return Mapper.Map<GenreMenuViewModel>(genre);
}