//lineup aanpassen
private void EditLineUP()
{
if (SelectedBand == null || SelectedStage == null)
{
MessageBox.Show("Door een bug in het systeem moet je momenteel nog de juiste band en stage selecteren");
}
else
{
LineUp lp = new LineUp();
lp.Date = SelectedLineUP.Date;
lp.From = SelectedLineUP.From;
lp.Until = SelectedLineUP.Until;
lp.Stage = SelectedLineUP.Stage;
lp.Stage.ID = SelectedLineUP.Stage.ID;
lp.Band = SelectedLineUP.Band;
lp.Band.ID = SelectedLineUP.Band.ID;
LineUp.ModifyLineUp(lp);
MessageBox.Show("De LineUP is aangepast");
_LineUP = LineUp.GetLineUp();
OnPropertyChanged("LineUP");
}
}
public LineUpVM()
{
_lineUpList = LineUp.GetLineUp();
_festivaldateList = Festival.GetDatums();
_genreList = Genre.GetGenres();
_stageList = Stage.GetStages();
_bandList = Band.GetBands();
NewStage = new Stage();
NewDate = new Festival();
NewBand = new Band();
SelectedLineUp = new LineUp();
}
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);
}
}
//ophalen gegevens.
public StageVM()
{
_Bands = Band.GetBands();
_Stages = Stage.GetStages();
_LineUP = LineUp.GetLineUp();
}
public void RemoveFilters()
{
SelectedStage = null;
SelectedFestivaldate = null;
LineUpList = LineUp.GetLineUp();
}
//opnieuw inladen datagrid
//dit werkt momenteel niet als een window gesloten wordt.
public void refresh()
{
_tickettypes = TicketType.GetTicketTypes();
_lineUPs = LineUp.GetLineUp();
}
public MainPageVM()
{
_tickettypes = TicketType.GetTicketTypes();
_lineUPs = LineUp.GetLineUp();
}
