protected void InsertReleaseGenres(ReleaseBase release, int releaseId, int masterId)
{
int number = 0;
foreach (var genre in release.Genres)
{
cmdReleaseGenre["release"] = releaseId;
cmdReleaseGenre["master"] = masterId;
cmdReleaseGenre["number"] = number++;
cmdReleaseGenre["genre"] = this.genreFinder.Find(genre);
cmdReleaseGenre.Execute();
}
}
protected void InsertReleaseStyles(ReleaseBase release, int releaseId, int masterId)
{
int number = 0;
foreach (var style in release.Styles)
{
cmdReleaseStyle["release"] = releaseId;
cmdReleaseStyle["master"] = masterId;
cmdReleaseStyle["number"] = number++;
cmdReleaseStyle["style"] = this.styleFinder.Find(style);
cmdReleaseStyle.Execute();
}
}
protected void InsertReleaseImages(ReleaseBase release, int releaseId, int masterId)
{
int number = 0;
foreach (var image in release.Images)
{
cmdReleaseImage["release"] = releaseId;
cmdReleaseImage["master"] = masterId;
cmdReleaseImage["number"] = number++;
cmdReleaseImage["type"] = image.Type;
cmdReleaseImage["width"] = image.Width;
cmdReleaseImage["height"] = image.Width;
cmdReleaseImage["uri"] = image.Uri;
cmdReleaseImage["uri150"] = image.Uri150;
cmdReleaseImage.Execute();
}
}
protected void InsertReleaseArtists(ReleaseBase release, int releaseId, int masterId)
{
if (release.Artists == null)
{
return;
}
int number = 0;
foreach (var artist in release.Artists)
{
cmdReleaseArtist["release"] = releaseId;
cmdReleaseArtist["master"] = masterId;
cmdReleaseArtist["number"] = number++;
cmdReleaseArtist["artist"] = this.artistFinder.Find(artist.Name);
cmdReleaseArtist["namevariation"] = artist.NameVariation ?? "";
cmdReleaseArtist["join"] = artist.Join ?? "";
cmdReleaseArtist.Execute();
}
}
protected void InsertReleaseTracks(ReleaseBase release, int releaseId, int masterId)
{
int number = 0;
foreach (var track in release.Tracklist)
{
cmdReleaseTrack["release"] = releaseId;
cmdReleaseTrack["master"] = masterId;
cmdReleaseTrack["number"] = number++;
cmdReleaseTrack["position"] = track.Position;
cmdReleaseTrack["title"] = track.Title;
cmdReleaseTrack["duration"] = (int)track.Aggregate.Duration.TotalSeconds;
long trackId = cmdReleaseTrack.Execute();
if (track.Artists != null)
{
InsertReleaseTrackArtists(track, trackId);
}
if (track.ExtraArtists != null)
{
InsertReleaseTrackExtraArtists(track, trackId);
}
}
}
