public List <Nummer> ViewNummerOpAlbum(int albumid) { SqlConnection con = new SqlConnection(Connectionstring); string query = "SELECT NummerID FROM Nummeropalbum WHERE AlbumID = @albumid"; List <int> nummerid = new List <int>(); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@albumid", albumid); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { nummerid.Add(rdr.GetInt32(0)); } con.Close(); var model = new List <Nummer>(); foreach (int i in nummerid) { con.Open(); string querynummer = "SELECT * FROM Nummer WHERE NummerID = @nummerid"; SqlCommand cmd2 = new SqlCommand(querynummer, con); cmd2.Parameters.AddWithValue("@nummerid", i); SqlDataReader rdr2 = cmd2.ExecuteReader(); while (rdr2.Read()) { model.Add(Lijsten.GetNummerData(rdr2)); } con.Close(); } return(model); }
public List <Nummer> ViewNummer() { string sql = "SELECT * FROM Nummer"; var model = new List <Nummer>(); using (SqlConnection con = new SqlConnection(Connectionstring)) { con.Open(); SqlCommand cmd = new SqlCommand(sql, con); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { model.Add(Lijsten.GetNummerData(rdr)); } con.Close(); } return(model); }
public List <Nummer> SearchNummer(string searchinput) { string query = "SELECT * FROM Nummer WHERE Naam = @naam"; SqlConnection con = new SqlConnection(Connectionstring); con.Open(); SqlCommand cmd = new SqlCommand(query, con); cmd.Parameters.AddWithValue("@naam", searchinput); cmd.ExecuteScalar(); var model = new List <Nummer>(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { model.Add(Lijsten.GetNummerData(rdr)); } con.Close(); return(model); }
public List <Nummer> ViewNummersInLijst(int playlistid) { DeleteNull(); string sql = "SELECT NummerID FROM Nummerperlijst WHERE PlaylistID = @playlistid"; List <int> nummerid = new List <int>(); SqlConnection con = new SqlConnection(Connectionstring); SqlCommand cmd = new SqlCommand(sql, con); con.Open(); cmd.Parameters.AddWithValue("@playlistid", playlistid); cmd.ExecuteNonQuery(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { nummerid.Add(rdr.GetInt32(0)); } con.Close(); var model = new List <Nummer>(); foreach (int i in nummerid) { con.Open(); string sql2 = "SELECT * FROM Nummer WHERE NummerID = @nummerid"; SqlCommand cmd2 = new SqlCommand(sql2, con); cmd2.Parameters.AddWithValue("@nummerid", i); cmd2.ExecuteNonQuery(); SqlDataReader rdr2 = cmd2.ExecuteReader(); while (rdr2.Read()) { model.Add(Lijsten.GetNummerData(rdr2)); } con.Close(); } return(model); }