public LibraryPage() { InitializeComponent(); List <Database.Band> bands = datOp.GetBandsForKeyword("").ToList(); foreach (var band in bands) { BandsList.Items.Add(band.BandName); } NumBands.Content = "Bands: " + bands.Count(); }
public static void test() { Database.DatabaseOperations datOp = new Database.DatabaseOperations(); //datOp.LoadFromCSV("C:/File export/database.csv"); Guid bandId1 = datOp.AddBand("Amon Amarth"); Guid bandId2 = datOp.AddBand("Alestorm"); Guid albumId1 = datOp.AddAlbum("Berserker"); Guid albumId2 = datOp.AddAlbum("Curse of the Crystal Coconut"); datOp.AddBandAlbumSong(bandId1, albumId1, datOp.AddSong("Fafner's Gold")); datOp.AddBandAlbumSong(bandId1, albumId1, datOp.AddSong("Crack the Sky")); datOp.AddBandAlbumSong(bandId1, albumId1, datOp.AddSong("Shield Wall")); datOp.AddBandAlbumSong(bandId1, null, datOp.AddSong("Burning Creation")); datOp.AddBandAlbumSong(bandId1, null, datOp.AddSong("The Arrival of the Fimbul Winter")); datOp.AddBandAlbumSong(bandId2, albumId2, datOp.AddSong("Tortuga")); datOp.AddBandAlbumSong(bandId2, null, datOp.AddSong("Big Ship Little Ship")); var a = datOp.GetAlbumsForBand(bandId1); var b = datOp.GetSinglesForBand(bandId1); var c = datOp.GetSongsForAlbum(albumId1); var d = datOp.GetBandsForKeyword(""); var e = datOp.GetSongsForKeyword("t"); //datOp.SaveToCSV("C:/File export/database.csv"); }
public BandPage() { InitializeComponent(); Songs.Items.Clear(); Albums.Items.Clear(); try { List <Database.Band> bands = datOp.GetBandsForKeyword(((MainWindow)System.Windows.Application.Current.MainWindow).SelectedBand).ToList(); bandObj = bands[0]; BandLabel.Content = bandObj.BandName; FoundationYearLabel.Content = "Foundation year: " + bandObj.FoundationYear.Value.Year; List <Database.Album> albums = datOp.GetAlbumsForBand(bandObj.IdBand).ToList(); foreach (var album in albums) { Albums.Items.Add(album.AlbumName); } } catch { bandObj = null; } AlbumsLabel.Content = ("Albums: " + Albums.Items.Count); }