public Zaal GetById(int id)
{
using (SqlConnection conn = new SqlConnection(ConnectionString))
{
StoelRepository SRep = new StoelRepository(new MssqlStoelContext());
conn.Open();
string query = "SELECT * FROM dbo.zaal WHERE ID = @ID";
SqlCommand cmd = new SqlCommand(query, conn);
cmd.Parameters.AddWithValue("ID", id);
SqlDataReader reader = cmd.ExecuteReader();
Zaal z = new Zaal();
while (reader.Read())
{
z.Id = id;
z.Grootte = reader.GetInt32(reader.GetOrdinal("grootte"));
z.Nummer = reader.GetInt32(reader.GetOrdinal("nummer"));
z.Stoelen = SRep.GetByZaalId(reader.GetInt32(reader.GetOrdinal("ID")));
}
conn.Close();
return(z);
}
}
