private static LineUp CreateLineUp(DbDataReader reader)
{
LineUp lineup = new LineUp();
lineup.ID = Convert.ToString(reader["lineup_id"]);
lineup.Date = Convert.ToDateTime(reader["lineup_date"]).ToShortDateString();
lineup.From = reader["lineup_from"].ToString();
lineup.Until = reader["lineup_until"].ToString() ;
//lineup.Stage = //een methode die de stage name ophaalt -> enkel name (string) is genoeg
lineup.band = BandRepository.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;
}