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);
}
