private void groupNumber_comboBox_SelectedIndexChanged_1(object sender, EventArgs e)
{
if (Path_textBox.Text != "")
{
try
{
SecretaryController.myConnection.Open();
duetNumber_textBox.Text = "";
//duetNumber_textBox.Text = (SecretaryController.TakeMax("Номер", "duets", Path_textBox.Text) + 1).ToString();
duetNumber_textBox.Text = (SecretaryController.TakeMax("Номер", "duets", "Номер_Группы", groupNumber_comboBox.SelectedIndex + 1, Path_textBox.Text) + 1).ToString();
GroupAgeCategoryList.Clear();
string retstr = "";
//MessageBox.Show(tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList.Count.ToString());
for (int i = 0; i < tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList.Count; i++)
{
GroupAgeCategoryList.Add(tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList[i].Replace(" ", string.Empty));
retstr += tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList[i].Replace(" ", string.Empty);
}
groupName_textBox.Text = tournir.groups[groupNumber_comboBox.SelectedIndex].name;
MessageBox.Show(retstr);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void groupNumber_comboBox_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
duetNumber_textBox.Text = "";
duetNumber_textBox.Text = SecretaryController.TakeMax("Номер", "duets", Path_textBox.Text).ToString();
for (int i = 0; i < tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList.Count; i++)
{
AgeCategoryList.Add(tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList[i]);
//AgeCategory2_comboBox.Items.Add(tournir.groups[groupNumber_comboBox.SelectedIndex].CategoryList[i]);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void registr_button_Click(object sender, EventArgs e)
{
Judge judge = new Judge();
judge.Surname = JudgeSurname_textBox.Text;
judge.Name = JudgeName_textBox.Text;
judge.Patronymic = JudgePatronymic_textBox.Text;
judge.JudgeClass = JudgeClass_textBox.Text;
if (Path_textBox.Text != "")
{
SecretaryController.insertInJudges(judge, Path_textBox.Text);
judge.Number = (ushort)(SecretaryController.TakeMax("Номер", "judges", Path_textBox.Text));
judge.judgeChar = (char)(64 + judge.Number);
tournir.judges.Add(judge);
MessageBox.Show("Новый судья: \n" + judge.Surname + "\n" + judge.Name + "\n" + judge.Patronymic + "\n" + judge.JudgeClass + "\n" + judge.Number + " " + judge.judgeChar + "\n" + "Успешно зарегистрирован!");
}
else
{
MessageBox.Show("Необходимо выбрать базу Турнира!");
}
}
