Example #1
0
 private void button1_Click(object sender, EventArgs e)
 {
     try
     {
         if (!connectionWithDatabase.isConnected())
         {
             connectionWithDatabase.OpenConnection();
         }
         if (searchForMatchByTeams.Checked)
         {
             connectionWithDatabase.searchForMatchByTeamNames(dataGridView1, textBox1, textBox2);
         }
         else if (SearchForMatchByDate.Checked)
         {
             connectionWithDatabase.searchForMatchByDate(dataGridView1, matchDateBox);
         }
         else if (searchForMatchByCompetition.Checked)
         {
             connectionWithDatabase.searchForMatchByCompetition(dataGridView1, competitionID);
         }
         else if (searchForBestScorers.Checked)
         {
             connectionWithDatabase.searchForBestScorers(dataGridView1, comboBox3, comboBox4);
         }
         else if (SearchForTeamsMostGoals.Checked)
         {
             connectionWithDatabase.searchForTeamsMostGoals(dataGridView1, comboBox2);
         }
         else if (SearchForTeamsWithMostWins.Checked)
         {
             connectionWithDatabase.searchForTeamsMostWins(dataGridView1, comboBox6);
         }
         else if (SearchForTeamsWithMostDraws.Checked)
         {
             connectionWithDatabase.searchForTeamsMostDraws(dataGridView1, comboBox1);
         }
         else if (SearchForTeamsWithMostLoses.Checked)
         {
             connectionWithDatabase.searchForTeamsMostLoses(dataGridView1, comboBox5);
         }
     }
     catch (Exception es)
     {
         MessageBox.Show("Error 404 in adding Team. Check DataBaseConnection \r\n" + es.Message + "\r\n" + es.InnerException.Message);
     }
     finally
     {
         connectionWithDatabase.CloseConnection();
     }
 }