public static ArtistCollection GetSample()
{
//ArtistCollection collection = new ArtistCollection() { new Artist { ArtistId = 1, Name = "aa" } };
ArtistCollection collection = new ArtistCollection();
collection.Add(new Artist(1, "aaa"));
collection.Add(new Artist(2, "bbb"));
collection.Add(new Artist(3, "cccc"));
return(collection);
}
public SearchResult Find(string query, int maxResults, int page)
{
// Find songs
DataSet tracksResult = MakeDataSet("SELECT * FROM track,artist, release WHERE artist.id = track.artist AND track.album = release.id AND (track.title LIKE '%" + query + "%' OR track.title LIKE '%%') AND (release.title LIKE '%" + query + "%' OR release.title LIKE '%%') AND (artist.title LIKE '%" + query + "%' OR artist.title = '%%')");
SearchResult sr = new SearchResult(this);
sr.Tracks = new TrackCollection(this, sr, new List <Track>());
foreach (DataRow dr in tracksResult.Tables[0].Rows)
{
sr.Tracks.Add(TrackFromDataRow(dr));
}
// Find artists
DataSet artistsResult = MakeDataSet("SELECT * FROM artist WHERE title LIKE '%" + query + "%'");
ArtistCollection ac = new ArtistCollection(this, new List <Artist>());
foreach (DataRow dr in artistsResult.Tables[0].Rows)
{
ac.Add(ArtistFromDataSet(dr));
}
sr.Artists = ac;
// Find albums
DataSet albumsResult = MakeDataSet("SELECT * FROM release, artist WHERE artist.id = release.artist AND release.title LIKE '%" + query + "%'");
ReleaseCollection rc = new ReleaseCollection(this, new List <Release>());
foreach (DataRow dr in albumsResult.Tables[0].Rows)
{
rc.Add(ReleaseFromDataRow(dr));
}
sr.Albums = rc;
return(sr);
}
private Artist CreateArtist(string artistname)
{
var artist = new Artist(artistname);
_artists.Add(artist);
return(artist);
}
/// <summary>
/// Add a new artist to the storage and the local collections
/// </summary>
/// <param name="artistToAdd"></param>
public static async Task AddArtistAsync(Artist artistToAdd)
{
// Need to wait for the Artist to be added so that its Id is available
await DbAccess.InsertAsync(artistToAdd);
ArtistCollection.Add(artistToAdd);
IdLookup[artistToAdd.Id] = artistToAdd;
}
private ArtistViewModel LookupArtist(ArtistModel artist)
{
if (artist == null)
{
return(null);
}
if (ArtistLookupMap.ContainsKey(artist.ArtistId))
{
return(ArtistLookupMap[artist.ArtistId]);
}
else
{
ArtistViewModel newArtistViewModel = new ArtistViewModel(artist);
ArtistLookupMap.Add(newArtistViewModel.ArtistId, newArtistViewModel);
ArtistCollection.Add(newArtistViewModel, newArtistViewModel.SortName);
return(newArtistViewModel);
}
}
public SearchResult Find(string query, int maxResults, int page)
{
// Find songs
DataSet tracksResult = MakeDataSet("SELECT * FROM track,artist, release WHERE artist.id = track.artist AND track.album = release.id AND (track.title LIKE '%" + query + "%' OR track.title LIKE '%%') AND (release.title LIKE '%" + query + "%' OR release.title LIKE '%%') AND (artist.title LIKE '%" + query + "%' OR artist.title = '%%')");
SearchResult sr = new SearchResult(this);
sr.Tracks = new TrackCollection(this, sr, new List<Track>());
foreach (DataRow dr in tracksResult.Tables[0].Rows)
{
sr.Tracks.Add(TrackFromDataRow(dr));
}
// Find artists
DataSet artistsResult = MakeDataSet("SELECT * FROM artist WHERE title LIKE '%" + query + "%'");
ArtistCollection ac = new ArtistCollection(this, new List<Artist>());
foreach (DataRow dr in artistsResult.Tables[0].Rows)
{
ac.Add(ArtistFromDataSet(dr));
}
sr.Artists = ac;
// Find albums
DataSet albumsResult = MakeDataSet("SELECT * FROM release, artist WHERE artist.id = release.artist AND release.title LIKE '%" + query + "%'");
ReleaseCollection rc = new ReleaseCollection(this, new List<Release>());
foreach (DataRow dr in albumsResult.Tables[0].Rows)
{
rc.Add(ReleaseFromDataRow(dr));
}
sr.Albums = rc;
return sr;
}