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