public void Insert(Release release)
{
cmdRelease["id"] = release.Id;
cmdRelease["master_id"] = release.MasterId;
cmdRelease["status"] = release.Status.ToString();
cmdRelease["title"] = release.Title;
cmdRelease["joined_artists"] = release.Aggregate.JoinedArtistsFixed;
cmdRelease["country"] = release.Country ?? "";
cmdRelease["releasedate"] = release.ReleaseDate ?? "";
cmdRelease["notes"] = release.Notes ?? "";
cmdRelease.Execute();
this.InsertReleaseArtists(release, release.Id, 0);
this.InsertReleaseFormats(release, release.Id);
if (release.Genres != null)
{
this.InsertReleaseGenres(release, release.Id, 0);
}
if (release.Images != null)
{
this.InsertReleaseImages(release, release.Id, 0);
}
if (release.Labels != null)
{
this.InsertReleaseLabels(release, release.Id);
}
if (release.Identifiers != null)
{
this.InsertReleaseIdentifiers(release, release.Id);
}
if (release.Styles != null)
{
this.InsertReleaseStyles(release, release.Id, 0);
}
this.InsertReleaseTracks(release, release.Id, 0);
}
public void Insert(Label label)
{
cmdInsertLabel["name"] = label.Name;
cmdInsertLabel["contactinfo"] = label.ContactInfo ?? "";
cmdInsertLabel["profile"] = label.Profile ?? "";
cmdInsertLabel["parentlabel"] = label.ParentLabel ?? "";
long labelId = cmdInsertLabel.Execute();
if (label.Images != null)
{
InsertLabelImages(label, labelId);
}
if (label.Urls != null)
{
InsertLabelUrls(label, labelId);
}
}
public void InsertFts(Release release)
{
cmdReleaseFts["id"] = release.Id;
StringBuilder fts = new StringBuilder();
fts.Append(release.Aggregate.JoinedArtistsFixed);
fts.Append(" ");
fts.Append(release.Title);
foreach (ReleaseLabel label in release.Labels)
{
fts.Append(" ");
fts.Append(label.Name);
fts.Append(" ");
fts.Append(label.CatalogNumber);
}
cmdReleaseFts["fts"] = fts.ToString();
cmdReleaseFts.Execute();
}
public long Find(string name)
{
if (styleCache.ContainsKey(name))
{
return(styleCache[name]);
}
cmdSelectStyle.Parameters["style"].Value = name;
using (var reader = cmdSelectStyle.ExecuteReader())
{
if (reader.Read())
{
return(styleCache[name] = reader.GetInt64("id"));
}
}
cmdInsertStyle["style"] = name;
return(styleCache[name] = cmdInsertStyle.Execute());
}
public void Insert(Artist artist)
{
try
{
cmdArtist["name"] = artist.Name;
cmdArtist["realname"] = artist.RealName ?? "";
cmdArtist["profile"] = artist.Profile ?? "";
long artistId = cmdArtist.Execute();
if (artist.Aliases != null)
{
InsertAliases(artist, artistId);
}
if (artist.Groups != null)
{
InsertGroups(artist, artistId);
}
if (artist.Images != null)
{
InsertImages(artist, artistId);
}
if (artist.Members != null)
{
InsertMembers(artist, artistId);
}
if (artist.NameVariations != null)
{
InsertNameVariations(artist, artistId);
}
if (artist.Urls != null)
{
InsertUrls(artist, artistId);
}
}
catch (Exception ex)
{
Console.WriteLine("Error inserting artist: " + ex.Message);
}
}
