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; }