public MainPageVM()
{
_bands = Band.getBands();
_uniekeDagen = Festival.aantalDagen();
// _stagesPerDag = Stage.GetStagesByDay(SelectedDag);
_podiums = Stage.GetStages();
_lineUp = new LineUp();
}
private static LineUp CreateLineUp(DbDataReader reader)
{
LineUp lineup = new LineUp();
lineup.ID = Convert.ToString(reader["lineup_id"]);
lineup.Date = Convert.ToDateTime(reader["lineup_date"]);
lineup.From = Convert.ToDateTime(reader["lineup_from"]);
lineup.Until = Convert.ToDateTime(reader["lineup_until"]);
//lineup.Stage = //een methode die de stage name ophaalt -> enkel name (string) is genoeg
lineup.band = Band.GetBandByID(Convert.ToInt32(reader["lineup_band"]));
return lineup;
}
public static LineUp GetLineUpByID(int id)
{
LineUp gevondenLineUp = new LineUp();
DbParameter paramid = Database.AddParameter("@ID", id);
string sql = "SELECT * FROM lineup WHERE lineup_id = @ID";
DbDataReader reader = Database.GetData(sql,paramid);
while (reader.Read())
{
gevondenLineUp = CreateLineUp(reader);
}
return gevondenLineUp;
}
public static void AddLineUp(LineUp lineup)
{
string sql = "INSERT INTO lineup(lineup_date, lineup_from, lineup_until, lineup_stage, lineup_band) VALUES (@date, @from, @until, @stageid, @bandid);";
string from = lineup.From.ToShortTimeString();
string until = lineup.Until.ToShortTimeString();
DbParameter par1 = Database.AddParameter("@date", lineup.Date);
DbParameter par2 = Database.AddParameter("@from", from);
DbParameter par3 = Database.AddParameter("@until",until );
DbParameter par4 = Database.AddParameter("@stageid", lineup.stage.ID);
DbParameter par5 = Database.AddParameter("@bandid", lineup.band.ID);
int i = Database.ModifyData(sql, par1, par2, par3, par4, par5);
if (i == 0)
{
MessageBox.Show("Toevoegen mislukt", "Error", System.Windows.MessageBoxButton.OK, System.Windows.MessageBoxImage.Error, System.Windows.MessageBoxResult.OK);
}
Console.WriteLine(i + " row(s) are affected");
}