private void btnViewParty_Click(object sender, EventArgs e) { leden = lidRepo.GetAll(); partijen = partijRepo.GetAll(); if (listView.CheckedItems.Count > 1) { MessageBox.Show("U kunt maar één partij selecteren om te bekijken"); } else if (listView.CheckedItems.Count != 0) { Party pForm = new Party(CreatePartijFromLv()[0]); pForm.ShowDialog(); } }
public List <Coalitie> GetAll() { List <Coalitie> coalities = new List <Coalitie>(); List <Partij> partijen = partijRepo.GetAll(); try { Database.Conn.Open(); //string queryLid = "SELECT * FROM Lid"; //using(SqlCommand cmd = new SqlCommand(queryLid, Database.Conn)) //{ // using(SqlDataReader r = cmd.ExecuteReader()) // { // while (r.Read()) // { // leden.Add(CreateLidFromReader(r)); // } // } //} //string queryPartij = "SELECT * FROM Partij"; //using (SqlCommand cmd = new SqlCommand(queryPartij, Database.Conn)) //{ // using (SqlDataReader r = cmd.ExecuteReader()) // { // while (r.Read()) // { // partijen.Add(CreatePartijFromReader(r, leden)); // } // } //} //foreach (Partij p in partijen) //{ // foreach (Lid l in leden) // { // if (l.PartijId == p.Id) // { // p.Leden.Add(l); // } // } //} string queryCoalitie = "SELECT * FROM Coalitie c INNER JOIN Coalitie_Partij CP ON c.CoalitieID = CP.CoalitieID INNER JOIN Partij P ON P.PartijID = CP.PartijID"; using (SqlCommand cmd = new SqlCommand(queryCoalitie, Database.Conn)) { using (SqlDataReader r = cmd.ExecuteReader()) { while (r.Read()) { coalities.Add(CreateCoalitieFromReader(r, partijen)); } } } return(coalities); } catch (Exception e) { Console.WriteLine(e.ToString()); return(null); } finally { Database.Conn.Close(); } }