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 void Band(string band) //{ // List<Database.Band> bands = datOp.GetBandsForKeyword(band).ToList(); // bandObj = bands[0]; // BandLabel.Content = bandObj.BandName; // FoundationYearLabel.Content = "Foundation year: " + bandObj.FoundationYear; // List<Database.Album> albums = datOp.GetAlbumsForBand(bandObj.IdBand).ToList(); // foreach (var album in albums) // { // Albums.Items.Add(album.AlbumName); // } //} //private void Albums_MouseDoubleClick(object sender, MouseButtonEventArgs e) //{ // if (Albums.SelectedItem != null) // { // Songs.Items.Clear(); // List<Database.Album> albums = datOp.GetAlbumsForKeyword(Albums.SelectedItem.ToString()).ToList(); // albumObj = albums[0]; // List<Database.Song> songs = datOp.GetSongsForAlbum(albumObj.IdAlbum).ToList(); // foreach (var song in songs) // { // Songs.Items.Add(song.SongName); // } // } //} private void AddAlbumButton_Click(object sender, RoutedEventArgs e) { if (AlbumNameBox != null) { Songs.Items.Clear(); datOp.AddAlbum(AlbumNameBox.Text); Songs.Items.Clear(); List <Database.Song> songs = datOp.GetSongsForAlbum(albumObj.IdAlbum).ToList(); Songs.Items.Clear(); foreach (var song in songs) { Songs.Items.Add(song.SongName); } Albums.Items.Add(AlbumNameBox.Text); Albums.SelectedIndex = Albums.Items.Count - 1; AlbumsLabel.Content = ("Albums: " + Albums.Items.Count); AlbumNameBox.Text = "AlbumName"; } }