public void DeleteLineUpArtiest()
{
if (SelectedLineUp != null)
{
try
{
string sql = "DELETE FROM LineUp WHERE ID=@id";
DbParameter parID = Database.AddParameter("@id", SelectedLineUp.ID);
Database.ModifyData(sql, parID);
string sql2 = "DELETE FROM Bands WHERE ID=@id2";
DbParameter parID2 = Database.AddParameter("@id2", SelectedLineUp.Band.ID);
Database.ModifyData(sql2, parID2);
string sql3 = "DELETE FROM Band_Genre WHERE ID=@bandid";
DbParameter parBandID = Database.AddParameter("@ibandid", SelectedLineUp.Band.ID);
Database.ModifyData(sql3, parBandID);
BandList.Remove(SelectedLineUp.Band);
LineUpList.Remove(SelectedLineUp);
NewLineUp();
MessageBox.Show("Line up en artiest werden succesvol verwijderd");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
public void DeleteLineUp()
{
if (SelectedLineUp != null)
{
try
{
string sql = "DELETE FROM LineUp WHERE ID=@id";
DbParameter par = Database.AddParameter("@id", SelectedLineUp.ID);
Database.ModifyData(sql, par);
LineUpList.Remove(SelectedLineUp);
NewLineUp();
MessageBox.Show("Line up werd succesvol verwijderd");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
