public Artiest ArtiestMetId(int artiestId) { ConnectionString.Open(); Artiest artiest = null; string query = "SELECT * FROM Artiest WHERE ArtiestId = @ArtiestId"; using (var cmd = new SqlCommand(query, ConnectionString)) { cmd.Parameters.AddWithValue("@ArtiestId", artiestId); using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { if (reader.Read()) { artiest = new Artiest() { ArtiestId = (int)reader["ArtiestId"], Naam = (string)reader["Naam"], Beschikbaar = (bool)reader["Beschikbaar"], Prijs = (decimal)reader["Prijs"] }; } } } } return(artiest); }
public List <Artiest> AlleArtiesten() { List <Artiest> artiesten = new List <Artiest>(); ConnectionString.Open(); string query = @"SELECT * FROM [dbo].[Artiest]"; using (var cmd = new SqlCommand(query, ConnectionString)) { using (var reader = cmd.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { Artiest artiest = new Artiest { ArtiestId = (int)reader["ArtiestId"], Naam = (string)reader["Naam"], Beschikbaar = (bool)reader["Beschikbaar"], Prijs = (decimal)reader["Prijs"] }; artiesten.Add(artiest); } } } } return(artiesten); }