private void Backbutton_Click(object sender, EventArgs e)
{
ExceptionCase exceptionCase = new ExceptionCase();
exceptionCase.Show();
this.Hide();
}
private void Injuredbutton_Click(object sender, EventArgs e)
{
if (NametextBox.Text == "")
{
MessageBox.Show("Player Name Can't Be Empty", "ERROR");
}
else if (PositioncomboBox.Text == "")
{
MessageBox.Show("Player Position Can't Be Empty", "ERROR");
}
else if (EventcomboBox.Text == "")
{
MessageBox.Show("Event Must Be Selected", "ERROR");
}
else
{
SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString);
connection.Open();
string sql = "Insert into Injuries(name,dateofBirth,photo,height,foot,wage,wageCurrency,price,priceCurrency,position,playerId,event) values('" + NametextBox.Text + "','" + DateOfBirthdateTimePicker.Text + "',@photo,'" + HeighttextBox.Text + "','" + PreferredFootcomboBox.Text + "','" + WagetextBox.Text + "','" + CurrencycomboBox1.Text + "','" + PricetextBox.Text + "','" + CurrencycomboBox2.Text + "','" + PositioncomboBox.Text + "','" + PlayerIdtextBox.Text + "','" + EventcomboBox.Text + "') ";
SqlCommand command = new SqlCommand(sql, connection);
command.Parameters.AddWithValue("photo", ConvertImageToByte(InjuryPlayerpictureBox.Image));
int flag1 = command.ExecuteNonQuery();
connection.Close();
SqlConnection connection2 = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString);
connection2.Open();
string sql2 = "delete from active where playerId = '" + PlayerIdtextBox.Text + "'";
SqlCommand command2 = new SqlCommand(sql2, connection2);
int flag = command2.ExecuteNonQuery();
if (flag == 0 && flag1 == 0)
{
MessageBox.Show("Player Not Added To The Exception Case List!", "ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show("Player Added To The Exception Case List", "SUCCESSFUL");
ExceptionCase exceptionCase = new ExceptionCase();
exceptionCase.Show();
this.Hide();
}
connection2.Close();
}
}
private void Casesbutton_Click(object sender, EventArgs e)
{
ExceptionCase exceptionCase = new ExceptionCase();
exceptionCase.Show();
}
