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); } } }
public void SaveLineUp() { try { string sql = "INSERT INTO LineUp(Start,Finish,BandID,StageID,FestivaldagID) VALUES(@Start,@Finish,@BandID,@StageID,@FestivaldagID)"; DbParameter parStart = Database.AddParameter("@Start", SelectedLineUp.From); DbParameter parFinish = Database.AddParameter("@Finish", SelectedLineUp.Until); DbParameter parBandID = Database.AddParameter("@BandID", SelectedLineUp.Band.ID); DbParameter parStageID = Database.AddParameter("@StageID", SelectedLineUp.Stage.ID); DbParameter parDateID = Database.AddParameter("@FestivaldagID", SelectedLineUp.Date.ID); Database.ModifyData(sql, parStart, parFinish, parBandID, parStageID, parDateID); LineUpList.Add(SelectedLineUp); LineUpList = LineUp.GetLineUp(); NewLineUp(); MessageBox.Show("Artiest werd succesvol toegevoegd aan de line up"); } catch (Exception ex) { MessageBox.Show(ex.Message); } }