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");
}
private void AddButton_Click(object sender, RoutedEventArgs e)
{
try
{
if ((BandNameBox.Text != null))
{
if ((FoundationYearBox.Text != "Year") && (FoundationYearBox.Text != ""))
{
if ((0 < Int32.Parse(FoundationYearBox.Text)) && (Int32.Parse(FoundationYearBox.Text) < 5000))
{
datOp.AddBand(BandNameBox.Text, Int32.Parse(FoundationYearBox.Text));
MessageBox.Show("Added to library!", "Added");
}
else
{
datOp.AddBand(BandNameBox.Text);
MessageBox.Show("Added to library!", "Added");
}
}
else
{
datOp.AddBand(BandNameBox.Text);
MessageBox.Show("Added to library!", "Added");
}
}
else
{
MessageBox.Show("Invalid Data", "Data error");
}
}
catch
{
MessageBox.Show("Invalid Data", "Data error");
}
}