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);
}
}
