public void CreateCoalition(CoalitionDTO coalition)
 {
     try
     {
         using (connection = DataConnection.GetConnection())
         {
             connection.Open();
             using (MySqlCommand command = new MySqlCommand("INSERT INTO Coalition(ElectionID, PrimeMinister) VALUES (@ElectionID, @PrimeMinister)", connection))
             {
                 command.Parameters.AddWithValue("@ElectionID", coalition.election.ID);
                 command.Parameters.AddWithValue("@PrimeMinister", coalition.PrimeMinister);
                 command.ExecuteNonQuery();
             }
         }
     }
     catch (MySqlException)
     {
         throw new CreatingElectionFailedException("Coalitie maken mislukt.");
     }
 }
 public void CreateCoalition(CoalitionDTO coalition)
 {
     Context.CreateCoalition(coalition);
 }