public List <Reservering> Select(Account acc)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
VoorstellingRepository VRep = new VoorstellingRepository(new MssqlVoorstellingContext());
conn.Open();
string query = "SELECT * FROM dbo.reservering WHERE account_ID = @accId";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("accId", acc.Id);
SqlDataReader reader = cmd.ExecuteReader();
List <Reservering> reserveringen = new List <Reservering>();
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
Reservering res = new Reservering();
res.Id = reader.GetInt32(reader.GetOrdinal("ID"));
res.Prijs = reader.GetSqlMoney(reader.GetOrdinal("prijs"));
res.Voorstelling = VRep.GetById(reader.GetInt32(reader.GetOrdinal("voorstelling_ID")));
reserveringen.Add(res);
}
}
cmd.ExecuteReader();
return(reserveringen);
}
}
public VoorstellingController()
{
_voorstellingRepository = new VoorstellingRepository();
_cultuurhuisRepository = new CultuurhuisRepository();
}
