private void removeMatchListBox_SelectedIndexChanged(object sender, EventArgs e)
{
TextBox[] idBoxesAway = { PlayerID1Away, PlayerID2Away, PlayerID3Away, PlayerID4Away, PlayerID5Away, PlayerID6Away, PlayerID7Away, PlayerID8Away, PlayerID9Away, PlayerID10Away, PlayerID11Away };
TextBox[] noBoxesAway = { PlayerNo1Away, PlayerNo2Away, PlayerNo3Away, PlayerNo4Away, PlayerNo5Away, PlayerNo6Away, PlayerNo7Away, PlayerNo8Away, PlayerNo9Away, PlayerNo10Away, PlayerNo11Away };
ComboBox[] positionBoxesAway = { PlayerPosition1Away, PlayerPosition2Away, PlayerPosition3Away, PlayerPosition4Away, PlayerPosition5Away, PlayerPosition6Away, PlayerPosition7Away, PlayerPosition8Away, PlayerPosition9Away, PlayerPosition10Away, PlayerPosition11Away };
MaskedTextBox[] goalBoxesAway = { Goals1Away, Goals2Away, Goals3Away, Goals4Away, Goals5Away, Goals6Away, Goals7Away, Goals8Away, Goals9Away, Goals10Away, Goals11Away };
TextBox[] idBoxesHome = { PlayerID1Home, PlayerID2Home, PlayerID3Home, PlayerID4Home, PlayerID5Home, PlayerID6Home, PlayerID7Home, PlayerID8Home, PlayerID9Home, PlayerID10Home, PlayerID11Home };
TextBox[] noBoxesHome = { PlayerNo1Home, PlayerNo2Home, PlayerNo3Home, PlayerNo4Home, PlayerNo5Home, PlayerNo6Home, PlayerNo7Home, PlayerNo8Home, PlayerNo9Home, PlayerNo10Home, PlayerNo11Home };
ComboBox[] positionBoxesHome = { PlayerPosition1Home, PlayerPosition2Home, PlayerPosition3Home, PlayerPosition4Home, PlayerPosition5Home, PlayerPosition6Home, PlayerPosition7Home, PlayerPosition8Home, PlayerPosition9Home, PlayerPosition10Home, PlayerPosition11Home };
MaskedTextBox[] goalBoxesHome = { Goals1Home, Goals2Home, Goals3Home, Goals4Home, Goals5Home, Goals6Home, Goals7Home, Goals8Home, Goals9Home, Goals10Home, Goals11Home };
try
{
if (!connectionWithDatabase.isConnected())
{
connectionWithDatabase.OpenConnection();
}
object[] tab = new object[2];
tab = connectionWithDatabase.returnIdOfTeams(removeMatchListBox);
connectionWithDatabase.loadMatch(matchDateBox, matchTimeBox, competitionID, removeMatchListBox);
connectionWithDatabase.loadPlayersToBoxes(tab[0], idBoxesHome, noBoxesHome, positionBoxesHome, goalBoxesHome, removeMatchListBox);
connectionWithDatabase.loadPlayersToBoxes(tab[1], idBoxesAway, noBoxesAway, positionBoxesAway, goalBoxesAway, removeMatchListBox);
totalHome.Text = sumOfGoals(goalBoxesHome).ToString();
totalAway.Text = sumOfGoals(goalBoxesAway).ToString();
}
catch (Exception es)
{
MessageBox.Show("Error 404 in adding Team. Check DataBaseConnection \r\n" + es.Message + "\r\n" + es.InnerException.Message);
}
finally
{
connectionWithDatabase.CloseConnection();
}
}
private void button1_Click(object sender, EventArgs e)
{
DBConnect con = new DBConnect();
con.OpenConnection();
string query = "insert into bcpark354.Customer(CustomerID, Name, Address, AccountBalance)";
SqlDataAdapter Da = new SqlDataAdapter();
try
{
Da.InsertCommand = new SqlCommand(query + "values (@CustomerID, @Name, @Address, @AccountBalance)", con.connection);
Da.InsertCommand.Parameters.Add("@CustomerID", SqlDbType.Char).Value = textBox1.Text;
Da.InsertCommand.Parameters.Add("@Name", SqlDbType.Char).Value = textBox2.Text;
Da.InsertCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = textBox3.Text;
Da.InsertCommand.Parameters.Add("@AccountBalance", SqlDbType.Decimal).Value = decimal.Parse(textBox4.Text);
Da.InsertCommand.ExecuteNonQuery();
MessageBox.Show("The customer has been entered into the system");
}
catch (Exception q)
{
MessageBox.Show(q.Message, "Could not create customer", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
con.CloseConnection();
}
private void homeTeamComboBox_Click(object sender, EventArgs e)
{
try
{
if (!connectionWithDatabase.isConnected())
{
connectionWithDatabase.OpenConnection();
}
connectionWithDatabase.loadTeams(homeTeamComboBox);
}
catch (Exception es)
{
MessageBox.Show("Error 404 in adding Team. Check DataBaseConnection \r\n" + es.Message + "\r\n" + es.InnerException.Message);
}
finally
{
connectionWithDatabase.CloseConnection();
}
}
private void addTeamButton_Click(object sender, EventArgs e)
{
this.Hide();
addTeam form = new addTeam();
form.ShowDialog();
connectionWithDatabase.CloseConnection();
this.Show();
}
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();
}
}
private void loginButton_Click(object sender, EventArgs e)
{
connectionWithDatabase = new DBConnect();
if (connectionWithDatabase.isConnected())
{
this.Hide();
MessageBox.Show("Succesfully connected to database");
defaultMenu form = new defaultMenu();
form.ShowDialog();
connectionWithDatabase.CloseConnection();
this.Show();
}
else
{
MessageBox.Show("Error with connecting to Database. \nCheck if it's available, your username and password.");
}
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text.Equals("9999"))
{
Admin next = new Admin();
MessageBox.Show("Welcome Admin");
next.Show();
this.Hide();
}
else if (textBox1.TextLength > 4)
{
MessageBox.Show(textBox1.Text, "Incorrect Input", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
else
{
DBConnect con = new DBConnect();
con.OpenConnection();
try
{
string query = "SELECT * FROM bcpark354.Customer";
SqlDataReader Data = con.getData(query);
while (Data.Read())
{
if (textBox1.Text.Equals(Data["CustomerID"].ToString()))
{
Program.custID = textBox1.Text;
Cust next = new Cust();
MessageBox.Show("Welcome Customer");
next.Show();
this.Hide();
}
}
Data.Close();
con.CloseConnection();
}
catch (Exception x)
{
MessageBox.Show(x.Message, "Customer Retrival Failed", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
}
}
private void button1_Click(object sender, EventArgs e)
{
DBConnect con = new DBConnect();
con.OpenConnection();
string query = "update bcpark354.Customer set Name = @Name, Address = @Address, AccountBalance = @AccountBalance where CustomerID = @CustomerID";
SqlDataAdapter Da = new SqlDataAdapter();
try
{
Da.UpdateCommand = new SqlCommand(query, con.connection);
Da.UpdateCommand.Parameters.Add("@CustomerID", SqlDbType.Char).Value = textBox1.Text;
Da.UpdateCommand.Parameters.Add("@Name", SqlDbType.Char).Value = textBox2.Text;
Da.UpdateCommand.Parameters.Add("@Address", SqlDbType.VarChar).Value = textBox3.Text;
Da.UpdateCommand.Parameters.Add("@AccountBalance", SqlDbType.Decimal).Value = decimal.Parse(textBox4.Text);
Da.UpdateCommand.ExecuteNonQuery();
MessageBox.Show("The customer has been updated");
}
catch (Exception i)
{
MessageBox.Show(i.Message, "Could not update customer", MessageBoxButtons.OK, MessageBoxIcon.Hand);
}
con.CloseConnection();
}
private void returnButton_Click(object sender, EventArgs e)
{
this.DialogResult = DialogResult.OK;
connectionWithDatabase.CloseConnection();
}