public Duet(int Num, int GroupNum, Sportsman Sportsman1, Sportsman Sportsman2)
{
this.number = Num;
this.sportsman1 = Sportsman1;
this.sportsman2 = Sportsman2;
this.groupNumber = GroupNum;
}
public Duet(int Num, int GroupNum, Sportsman Sportsman1)
{
this.number = Num;
this.sportsman1 = Sportsman1;
this.sportsman2 = new Sportsman(-1);
this.groupNumber = GroupNum;
}
public static void insertInSportDB(Sportsman sportsman)
{
OleDbCommand command = new OleDbCommand("", myConnection);
command.CommandText = "INSERT INTO Sportsmans(НомерКнижки, Фамилия, Имя, Отчество, НазваниеКлуба, Город, ДатаРождения, СпортивныйКласс, Разряд)" + "VALUES (@BookNumber,@Surname,@Name,@Patronymic,@ClubName,@City,@BirthDate,@SportClass,@SportCategory)";
command.Parameters.AddWithValue("BookNumber", sportsman.BookNumber);
command.Parameters.AddWithValue("Surname", sportsman.Surname);
command.Parameters.AddWithValue("Name", sportsman.Name);
command.Parameters.AddWithValue("Patronymic", sportsman.Patronymic);
command.Parameters.AddWithValue("ClubName", sportsman.ClubName);
command.Parameters.AddWithValue("City", sportsman.City);
command.Parameters.AddWithValue("BirthDate", sportsman.BirthDate.ToString());
command.Parameters.AddWithValue("SportClass", sportsman.SportClass);
command.Parameters.AddWithValue("SportCategory", sportsman.SportCategory);
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show($"Попытка повторного ввода номера книжки:\n{sportsman.BookNumber}\n{ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public static void insertInParticipants(Sportsman sportsman, string path)
{
//try
//{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={path}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
OleDbCommand command = new OleDbCommand("", myConnection);
command.CommandText = "INSERT INTO participants(Номер, Фамилия, Имя, Отчество, Категория, Номер_Группы)" + "VALUES (@Number, @Surname, @Name, @Patronymic, @AgeCategory, @GroupNumber)";
command.Parameters.AddWithValue("Number", sportsman.NumberInTournir);
command.Parameters.AddWithValue("Surname", sportsman.Surname);
command.Parameters.AddWithValue("Name", sportsman.Name);
command.Parameters.AddWithValue("Patronymic", sportsman.Patronymic);
command.Parameters.AddWithValue("AgeCategory", sportsman.AgeCategory);
command.Parameters.AddWithValue("GroupNumber", sportsman.GroupNumber);
command.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
// MessageBox.Show($"Упс, что-то пошло не так...\n{ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
myConnection.Close();
}
public static void insertParticipantsInSet(int number, Sportsman sportsman1, Sportsman sportsman2, int groupNumber, string path)
{
try
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={path}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
OleDbCommand command = new OleDbCommand("", myConnection);
command.CommandText = "INSERT INTO duets(Номер, Номер_Группы, Номер_Книжки1, Номер_Книжки2, Тип)" + "VALUES (@Number, @GroupNumber, @BookNumber1, @BookNumber2, @Type)";
command.Parameters.AddWithValue("Number", number);
command.Parameters.AddWithValue("GroupNumber", groupNumber);
command.Parameters.AddWithValue("BookNumber1", sportsman1.BookNumber);
command.Parameters.AddWithValue("BookNumber2", sportsman2.BookNumber);
command.Parameters.AddWithValue("Type", "Пара");
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show($"Упс, что-то пошло не так при записи очередного пары...\n{ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
myConnection.Close();
}
public static void insertParticipantsInDuet(int number, Sportsman sportsman, int groupNumber, string path)
{
//try
//{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={path}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
command = new OleDbCommand("", myConnection);
command.CommandText = "INSERT INTO duets(Номер, Номер_Группы, ФИО1, Тип)" + "VALUES (@Number, @GroupNumber, @SNP, @Type)";
command.Parameters.AddWithValue("Number", number);
command.Parameters.AddWithValue("GroupNumber", groupNumber);
command.Parameters.AddWithValue("SNP", sportsman.Surname + ";" + sportsman.Name + ";" + sportsman.Patronymic + ";");
command.Parameters.AddWithValue("Type", "Соло");
MessageBox.Show($"Новый Солист:\n{sportsman.BookNumber}\nГруппа: {groupNumber}");
command.ExecuteNonQuery();
//}
//catch (Exception ex)
//{
// MessageBox.Show($"Упс, что-то пошло не так при записи очередного солиста...\n{ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
//}
myConnection.Close();
}
public registrFormSolo()
{
InitializeComponent();
sportsman = new Sportsman();
if (FirstTrainer_checkBox.Checked == false)
{
FirstTrainer_groupBox.ForeColor = Color.Gray;
}
if (SecondTrainer_checkBox.Checked == false)
{
SecondTrainer_groupBox.ForeColor = Color.Gray;
}
//danceCheckList.Add(danceCheckBox1);
//danceCheckList.Add(danceCheckBox2);
//danceCheckList.Add(danceCheckBox3);
//danceCheckList.Add(danceCheckBox4);
//danceCheckList.Add(danceCheckBox5);
//danceCheckList.Add(danceCheckBox6);
//danceCheckList.Add(danceCheckBox7);
//danceCheckList.Add(danceCheckBox8);
//danceCheckList.Add(danceCheckBox9);
//danceCheckList.Add(danceCheckBox10);
}
public static Sportsman SearchByBookNumberShort(int BookNumber)
{
Sportsman sportsman = new Sportsman();
OleDbCommand command1 = new OleDbCommand("", myConnection);
OleDbCommand command2 = new OleDbCommand("", myConnection);
OleDbCommand command3 = new OleDbCommand("", myConnection);
OleDbCommand command4 = new OleDbCommand("", myConnection);
OleDbCommand command5 = new OleDbCommand("", myConnection);
OleDbCommand command6 = new OleDbCommand("", myConnection);
OleDbCommand command7 = new OleDbCommand("", myConnection);
command1.CommandText = "SELECT Фамилия FROM Sportsmans WHERE НомерКнижки = @BookNum";
command1.Parameters.AddWithValue("BookNum", BookNumber);
command2.CommandText = "SELECT Имя FROM Sportsmans WHERE НомерКнижки = @BookNum";
command2.Parameters.AddWithValue("BookNum", BookNumber);
command3.CommandText = "SELECT Отчество FROM Sportsmans WHERE НомерКнижки = @BookNum";
command3.Parameters.AddWithValue("BookNum", BookNumber);
command4.CommandText = "SELECT НазваниеКлуба FROM Sportsmans WHERE НомерКнижки = @BookNum";
command4.Parameters.AddWithValue("BookNum", BookNumber);
command5.CommandText = "SELECT Город FROM Sportsmans WHERE НомерКнижки = @BookNum";
command5.Parameters.AddWithValue("BookNum", BookNumber);
command6.CommandText = "SELECT СпортивныйКласс FROM Sportsmans WHERE НомерКнижки = @BookNum";
command6.Parameters.AddWithValue("BookNum", BookNumber);
command7.CommandText = "SELECT Разряд FROM Sportsmans WHERE НомерКнижки = @BookNum";
command7.Parameters.AddWithValue("BookNum", BookNumber);
try
{
sportsman.Surname = command1.ExecuteScalar().ToString();
sportsman.Name = command2.ExecuteScalar().ToString();
sportsman.Patronymic = command3.ExecuteScalar().ToString();
sportsman.ClubName = command4.ExecuteScalar().ToString();
sportsman.City = command5.ExecuteScalar().ToString();
//MessageBox.Show(sportsman.BirthDate.ToString());
sportsman.SportClass = command6.ExecuteScalar().ToString();
sportsman.SportCategory = command7.ExecuteScalar().ToString();
}
catch (/*System.NullReferenceException*/ Exception ex)
{
MessageBox.Show("Что-то пошло не так! \n" + ex.Message);
}
return(sportsman);
}
private void searchByBook_2_Button_Click(object sender, EventArgs e)
{
if (BookNumber2_textBox.Text != "")
{
try
{
sportsman_second = Controller.SearchByBookNumber(Convert.ToInt32(BookNumber2_textBox.Text));
autoFilling_second(sportsman_second);
}
catch (Exception ex)
{
MessageBox.Show($"{ex.Message}");
}
}
else
{
MessageBox.Show("Заполните поле 'Номер Книжки' для второго спортсмена!");
}
}
public static void insertParticipantsInSet(int number, Sportsman sportsman, int groupNumber, int setNumber, string path)
{
try
{
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={path}";
myConnection = new OleDbConnection(connectString);
myConnection.Open();
OleDbCommand command = new OleDbCommand("", myConnection);
if (setNumber != -1)
{
command.CommandText = "INSERT INTO duets(Номер, Номер_Группы, Номер_Захода, Номер_Книжки1, Тип)" + "VALUES (@Number, @GroupNumber, @SetNumber, @BookNumber, @Type)";
//command.CommandText = "INSERT INTO duets(Номер, Номер_Группы, Номер_Книжки1, Тип)" + "VALUES (@Number, @GroupNumber, @BookNumber, @Type)";
command.Parameters.AddWithValue("Number", number);
command.Parameters.AddWithValue("GroupNumber", groupNumber);
command.Parameters.AddWithValue("SetNumber", setNumber);
command.Parameters.AddWithValue("BookNumber", sportsman.BookNumber);
command.Parameters.AddWithValue("Type", "Соло");
}
else
{
command.CommandText = "INSERT INTO duets(Номер, Номер_Группы, Номер_Книжки1, Тип)" + "VALUES (@Number, @GroupNumber, @BookNumber, @Type)";
command.Parameters.AddWithValue("Number", number);
command.Parameters.AddWithValue("GroupNumber", groupNumber);
command.Parameters.AddWithValue("BookNumber", sportsman.BookNumber);
command.Parameters.AddWithValue("Type", "Соло");
}
MessageBox.Show($"Новый Солист:\n{sportsman.BookNumber}\nГруппа: {groupNumber}\nЗаход: {setNumber}");
command.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show($"Упс, что-то пошло не так при записи очередного солиста...\n{ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
myConnection.Close();
}
private void formingSets_button_Click(object sender, EventArgs e)
{
if (this.tournir.name != "" && Path_textBox.Text != "" && duetCountTextBox.Text != "")
{
//Constants
//int setCountInGroup = Convert.ToInt32(setCountTextBox.Text);
int duetCountInSet = Convert.ToInt32(duetCountTextBox.Text);
//задать количество участников в каждом заходе
connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={folderName}";
OleDbConnection con = new OleDbConnection(connectString);
con.Open();
List <Duet> DuetList_New = new List <Duet>();
List <Duet> SoloList_New = new List <Duet>();
//Sportsman sportsman1 = new Sportsman();
//Sportsman sportsman2 = new Sportsman();
int countOfElements = 0;
Random rnd = new Random();
Controller.myConnection.Open();
for (int i = 0; i < tournir.groups.Count; i++)
{
DuetList_New.Clear();
SoloList_New.Clear();
int index = 0;
OleDbCommand command = new OleDbCommand("SELECT COUNT(Номер_Книжки1) From duets WHERE Номер_Группы = @id", con);
command.Parameters.AddWithValue("id", i + 1);
countOfElements = Convert.ToInt32(command.ExecuteScalar().ToString());
//MessageBox.Show(Convert.ToString(countOfElements));
//List<Duet> newDuetList = new List<Duet>();
//List<int> newBookNumDuetList = new List<int>();
//List<int> newBookNumSoloList = new List<int>();
string outStr = "Пары группы номер" + (i + 1).ToString() + "\n";
string outStr1 = "Солисты группы номер" + (i + 1).ToString() + "\n";
OleDbCommand command1 = new OleDbCommand("SELECT Номер, Номер_Книжки1, Номер_Книжки2 From duets WHERE Номер_Группы = @id", con);
command1.Parameters.AddWithValue("id", i + 1);
OleDbDataReader reader = command1.ExecuteReader();
int j = 0;
int j1 = 0;
int Num1 = 0, Num2 = 0;
while (reader.Read())
{
if (reader["Номер_Книжки2"].ToString() != "")
{
Sportsman sportsman1 = new Sportsman();
Sportsman sportsman2 = new Sportsman();
outStr += " ";
Num1 = (Convert.ToInt32(reader["Номер_Книжки1"]));
Num2 = (Convert.ToInt32(reader["Номер_Книжки2"]));
sportsman1 = Controller.SearchByBookNumberShort(Num1);
sportsman1.BookNumber = Num1;
sportsman1.GroupNumber = i + 1;
sportsman2 = Controller.SearchByBookNumberShort(Num2);
sportsman2.BookNumber = Num2;
sportsman2.GroupNumber = i + 1;
DuetList_New.Add(new Duet(Convert.ToInt32(reader["Номер"]) - 1, i, sportsman1, sportsman2));
outStr += DuetList_New[j1].ToString() + "\n";
j1++;
}
else
{
Sportsman sportsman1 = new Sportsman();
//newBookNumSoloList.Add(Convert.ToInt32(reader["Номер_Книжки1"]));
Num1 = (Convert.ToInt32(reader["Номер_Книжки1"]));
sportsman1 = Controller.SearchByBookNumberShort(Num1);
sportsman1.BookNumber = Num1;
sportsman1.GroupNumber = i + 1;
SoloList_New.Add(new Duet(Convert.ToInt32(reader["Номер"]) - 1, i, sportsman1));
outStr1 += SoloList_New[j].ToString() + "\n";
j++;
}
outStr += "\n";
outStr1 += "\n";
}
//MessageBox.Show(outStr);
outStr = "(Пара)Сортировка\n";
//DuetList_New.OrderBy(x => rnd.Next());
randomSort(DuetList_New);
foreach (Duet duetItem in DuetList_New)
{
outStr += duetItem.ToString();
}
//MessageBox.Show(outStr);
//MessageBox.Show(outStr1);
outStr1 = "(Соло)Сортировка\n";
//SoloList_New.OrderBy(x => rnd.Next());
randomSort(SoloList_New);
foreach (Duet soloItem in SoloList_New)
{
outStr1 += soloItem.ToString();
}
//MessageBox.Show(outStr1);
outStr = "";
tournir.groups[i].SetList.Clear();
//Заходы для пар
int setCountInGroup = DuetList_New.Count / duetCountInSet;
int remainder = DuetList_New.Count % duetCountInSet;
int h = 0;
outStr += "Группа " + (i + 1).ToString() + "\n";
for (h = 0; h < setCountInGroup; h++)
{
tournir.groups[i].SetList.Add(new SetClass(i, h + 1 /*Добавить категорию*/));
outStr += "Заход " + (tournir.groups[i].SetList.Count).ToString() + "\n";
for (int h1 = 0; h1 < duetCountInSet; h1++)
{
if (index <= DuetList_New.Count - 1)
{
tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Add(DuetList_New[index]);
outStr += "Пара " + (tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Count).ToString() + "\n";
outStr += DuetList_New[index].ToString() + "\n";
index++;
}
else
{
break;
}
}
}
tournir.groups[i].SetList.Add(new SetClass(i, h + 1 /*Добавить категорию*/));
outStr += "Заход " + (tournir.groups[i].SetList.Count).ToString() + "\n";
for (int h1 = 0; h1 < remainder; h1++)
{
if (index <= DuetList_New.Count - 1)
{
tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Add(DuetList_New[index]);
outStr += "Пара " + (tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Count).ToString() + "\n";
outStr += DuetList_New[index].ToString() + "\n";
index++;
}
else
{
break;
}
}
////Заходы для солистов
//setCountInGroup = DuetList_New.Count / duetCountInSet;
//remainder = DuetList_New.Count % duetCountInSet;
//int g = h;
//outStr += "Группа " + (i + 1).ToString() + "\n";
//for (h = 0; h < setCountInGroup; h++)
//{
// tournir.groups[i].SetList.Add(new SetClass(i, g + h/*Добавить категорию*/));
// outStr += "Заход " + (tournir.groups[i].SetList.Count).ToString() + "\n";
// for (int h1 = 0; h1 < duetCountInSet; h1++)
// {
// if (index <= SoloList_New.Count - 1)
// {
// tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Add(SoloList_New[index]);
// outStr += "Пара " + (tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Count).ToString() + "\n";
// outStr += SoloList_New[index].ToString() + "\n";
// index++;
// }
// else
// break;
// }
//}
//tournir.groups[i].SetList.Add(new SetClass(i, g + h + 1/*Добавить категорию*/));
//outStr += "Заход " + (tournir.groups[i].SetList.Count).ToString() + "\n";
//for (int h1 = 0; h1 < remainder; h1++)
//{
// if (index <= DuetList_New.Count - 1)
// {
// tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Add(SoloList_New[index]);
// outStr += "Пара " + (tournir.groups[i].SetList[tournir.groups[i].SetList.Count - 1].DuetList.Count).ToString() + "\n";
// outStr += SoloList_New[index].ToString() + "\n";
// index++;
// }
// else
// break;
//}
MessageBox.Show(outStr);
//for (int i1 = 0; i1 < DuetList_New.Count; i1++)
//{
// if(index % duetCountInSet)
// tournir.groups[i].SetList[index];
// if ()
//}
}
con.Close();
Controller.myConnection.Close();
}
else
{
MessageBox.Show("Не все поля заполнены!");
}
}
public void autoFilling_second(Sportsman sportsman_second)
{
Name2textBox.Text = sportsman_second.Name;
Surname2textBox.Text = sportsman_second.Surname;
Patronymic2textBox.Text = sportsman_second.Patronymic;
DayOfBirth2_comboBox.SelectedIndex = sportsman_second.BirthDate.Day - 1;
MounthOfBirth2_comboBox.SelectedIndex = sportsman_second.BirthDate.Mounth - 1;
if (sportsman_second.BirthDate.Year > 0)
{
YearOfBirth2_comboBox.SelectedIndex = 2020 - sportsman_second.BirthDate.Year;
}
ClubName_textBox.Text = sportsman_second.ClubName;
City_textBox.Text = sportsman_second.City;
SurnameOfDuetTrainer_textBox.Text = sportsman_second.OlderTrainer.Surname;
NameOfDuetTrainer_textBox.Text = sportsman_second.OlderTrainer.Name;
PatronymicOfDuetTrainer_textBox.Text = sportsman_second.OlderTrainer.Patronymic;
switch (sportsman_second.SportCategory)
{
case "Ю-I":
SportCategory2_comboBox.SelectedIndex = 0;
break;
case "Ю-II":
SportCategory2_comboBox.SelectedIndex = 1;
break;
case "Ю-III":
SportCategory2_comboBox.SelectedIndex = 2;
break;
case "Вз-I":
SportCategory2_comboBox.SelectedIndex = 3;
break;
case "Вз-II":
SportCategory2_comboBox.SelectedIndex = 4;
break;
case "Вз-III":
SportCategory2_comboBox.SelectedIndex = 5;
break;
case "КМС":
SportCategory2_comboBox.SelectedIndex = 6;
break;
case "МС":
SportCategory2_comboBox.SelectedIndex = 7;
break;
case "МСМК":
SportCategory2_comboBox.SelectedIndex = 8;
break;
}
switch (sportsman_second.SportClass)
{
case "H":
case "Н":
SportClass2_comboBox.SelectedIndex = 0;
break;
case "E":
case "Е":
SportClass2_comboBox.SelectedIndex = 1;
break;
case "Д":
SportClass2_comboBox.SelectedIndex = 2;
break;
case "C":
case "С":
SportClass2_comboBox.SelectedIndex = 3;
break;
case "B":
case "В":
SportClass2_comboBox.SelectedIndex = 4;
break;
case "A":
case "А":
SportClass2_comboBox.SelectedIndex = 5;
break;
case "S":
SportClass2_comboBox.SelectedIndex = 6;
break;
case "M":
case "М":
SportClass2_comboBox.SelectedIndex = 7;
break;
}
}
public static Sportsman SearchByBookNumber(int BookNumber)
{
Sportsman sportsman = new Sportsman();
OleDbCommand command1 = new OleDbCommand("", myConnection);
OleDbCommand command2 = new OleDbCommand("", myConnection);
OleDbCommand command3 = new OleDbCommand("", myConnection);
OleDbCommand command4 = new OleDbCommand("", myConnection);
OleDbCommand command5 = new OleDbCommand("", myConnection);
OleDbCommand command6 = new OleDbCommand("", myConnection);
OleDbCommand command7 = new OleDbCommand("", myConnection);
OleDbCommand command8 = new OleDbCommand("", myConnection);
OleDbCommand command9 = new OleDbCommand("", myConnection); //OldTrainer.Surname
OleDbCommand command10 = new OleDbCommand("", myConnection); //OldTrainer.Name
OleDbCommand command11 = new OleDbCommand("", myConnection); //OldTrainer.Patronymic
command1.CommandText = "SELECT Фамилия FROM Sportsmans WHERE НомерКнижки = @BookNum";
command1.Parameters.AddWithValue("BookNum", BookNumber);
command2.CommandText = "SELECT Имя FROM Sportsmans WHERE НомерКнижки = @BookNum";
command2.Parameters.AddWithValue("BookNum", BookNumber);
command3.CommandText = "SELECT Отчество FROM Sportsmans WHERE НомерКнижки = @BookNum";
command3.Parameters.AddWithValue("BookNum", BookNumber);
command4.CommandText = "SELECT НазваниеКлуба FROM Sportsmans WHERE НомерКнижки = @BookNum";
command4.Parameters.AddWithValue("BookNum", BookNumber);
command5.CommandText = "SELECT Город FROM Sportsmans WHERE НомерКнижки = @BookNum";
command5.Parameters.AddWithValue("BookNum", BookNumber);
command6.CommandText = "SELECT ДатаРождения FROM Sportsmans WHERE НомерКнижки = @BookNum";
command6.Parameters.AddWithValue("BookNum", BookNumber);
command7.CommandText = "SELECT СпортивныйКласс FROM Sportsmans WHERE НомерКнижки = @BookNum";
command7.Parameters.AddWithValue("BookNum", BookNumber);
command8.CommandText = "SELECT Разряд FROM Sportsmans WHERE НомерКнижки = @BookNum";
command8.Parameters.AddWithValue("BookNum", BookNumber);
command9.CommandText = "SELECT Фамилия FROM Trainers WHERE НомерКнижки = @BookNum";
command9.Parameters.AddWithValue("BookNum", BookNumber);
command10.CommandText = "SELECT Имя FROM Trainers WHERE НомерКнижки = @BookNum";
command10.Parameters.AddWithValue("BookNum", BookNumber);
command11.CommandText = "SELECT Отчество FROM Trainers WHERE НомерКнижки = @BookNum";
command11.Parameters.AddWithValue("BookNum", BookNumber);
try
{
sportsman.Surname = command1.ExecuteScalar().ToString();
sportsman.Name = command2.ExecuteScalar().ToString();
sportsman.Patronymic = command3.ExecuteScalar().ToString();
sportsman.ClubName = command4.ExecuteScalar().ToString();
sportsman.City = command5.ExecuteScalar().ToString();
sportsman.BirthDate.ToInt(command6.ExecuteScalar().ToString());
MessageBox.Show(sportsman.BirthDate.ToString());
sportsman.SportClass = command7.ExecuteScalar().ToString();
sportsman.SportCategory = command8.ExecuteScalar().ToString();
sportsman.OlderTrainer.Surname = command9.ExecuteScalar().ToString();
sportsman.OlderTrainer.Name = command10.ExecuteScalar().ToString();
sportsman.OlderTrainer.Patronymic = command11.ExecuteScalar().ToString();
}
catch (System.NullReferenceException ex)
{
MessageBox.Show("Спортсмен не найден!\n" + ex.Message);
}
return(sportsman);
}
public void autoFillingCategoryAndClasses_second(Sportsman sportsman_second)
{
switch (sportsman_second.SportCategory)
{
case "Ю-I":
SportCategory2_comboBox.SelectedIndex = 0;
break;
case "Ю-II":
SportCategory2_comboBox.SelectedIndex = 1;
break;
case "Ю-III":
SportCategory2_comboBox.SelectedIndex = 2;
break;
case "Вз-I":
SportCategory2_comboBox.SelectedIndex = 3;
break;
case "Вз-II":
SportCategory2_comboBox.SelectedIndex = 4;
break;
case "Вз-III":
SportCategory2_comboBox.SelectedIndex = 5;
break;
case "КМС":
SportCategory2_comboBox.SelectedIndex = 6;
break;
case "МС":
SportCategory2_comboBox.SelectedIndex = 7;
break;
case "МСМК":
SportCategory2_comboBox.SelectedIndex = 8;
break;
}
switch (sportsman_second.SportClass)
{
case "H":
case "Н":
SportClass2_comboBox.SelectedIndex = 0;
break;
case "E":
case "Е":
SportClass2_comboBox.SelectedIndex = 1;
break;
case "Д":
SportClass2_comboBox.SelectedIndex = 2;
break;
case "C":
case "С":
SportClass2_comboBox.SelectedIndex = 3;
break;
case "B":
case "В":
SportClass2_comboBox.SelectedIndex = 4;
break;
case "A":
case "А":
SportClass2_comboBox.SelectedIndex = 5;
break;
case "S":
SportClass2_comboBox.SelectedIndex = 6;
break;
case "M":
case "М":
SportClass2_comboBox.SelectedIndex = 7;
break;
}
}