public void drawTournirEnding(GroupClass inputGroup) { ComboBox comboBoxOfJudge = new ComboBox(); Label newLabel = new Label(); graduatePanel.Controls.Clear(); graduatePanel.Visible = true; graduatePanel.Visible = true; List <int> positionsInComboBoxList = new List <int>(); int height = 0; int weidh = 0; height += 45; weidh += 30; for (int i = 0; i < inputGroup.JudgeList.Count; i++) { graduatePanel.Controls.Add(newLabel = new Label() { Text = inputGroup.JudgeList[i].judgeChar.ToString(), Location = new Point(105 + 80 * i, 15), Size = new Size(30, 25), Font = new Font("", 12) }); t.SetToolTip(newLabel, inputGroup.JudgeList[i].ToString()); } int j = 0; foreach (Duet duetItem in inputGroup.duetList) { graduatePanel.Controls.Add(newLabel = new Label() { Text = "Пара" + Convert.ToString(duetItem.number), Location = new Point(10, height), Size = new Size(90, 25), Font = new Font("", 12), }); t.SetToolTip(newLabel, duetItem.ToString()); for (int i = 0; i < inputGroup.JudgeList.Count; i++) { graduatePanel.Controls.Add(comboBoxOfJudge = new ComboBox() { Location = new Point(105 + 80 * i, height), Size = new Size(45, 33), Font = new Font("", 12) }); for (int g = 1; g <= 5 /*countsOfPositionsNumericUpDown.Value*/; g++) { comboBoxOfJudge.Items.Add(g); } comboBoxOfJudge.BringToFront(); //tourList[currentMark.tourNumber].groupList[currentMark.groupNumber].resultOfGroup_list.Add(new tournirResultComboBox(markerForCheckList, comboBoxOfJudge)); resultOfTournir_list.Add(comboBoxOfJudge); } height += 30; j++; } }
private void CreateGroupSecond_button_Click(object sender, EventArgs e) { GroupClass group_new = new GroupClass(); if (NumberOfGroup_textBox.Text != "") { group_new.number = Convert.ToInt32(NumberOfGroup_textBox.Text); CheckBox[] CategoriesList = new CheckBox[] { D0_checkBox, D1_checkBox, D2_checkBox, M_checkBox, M2_checkBox, U1_checkBox, U2_checkBox, Vz_checkBox, other_checkBox }; CheckBox[] DancesList = new CheckBox[] { W_dance_checkBox, V_dance_checkBox, T_dance_checkBox, F_dance_checkBox, Q_dance_checkBox, S_dance_checkBox, Ch_dance_checkBox, R_dance_checkBox, P_dance_checkBox, J_dance_checkBox }; string str = ""; foreach (CheckBox item in DancesList) { if (item.Checked) { group_new.DancesList.Add(item.Text); str += item.Text; } } //MessageBox.Show(str); foreach (CheckBox item in CategoriesList) { if (item.Checked) { group_new.CategoryList.Add(item.Text); str += item.Text; } } MessageBox.Show(str); group_new.tournir_name = tournir.name; group_new.name = categoryNameTextBox.Text; if (Path_textBox.Text != "") { try { OleDbConnection cn = new OleDbConnection($"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={folderName}"); cn.Open(); OleDbCommand com1 = new OleDbCommand(); OleDbCommand com2 = new OleDbCommand(); com1 = new OleDbCommand("INSERT INTO groups(Название_Турнира, Номер_Группы, Категория, Категории, Танцы)" + "VALUES (@tournir_name, @group_number, @category, @categories, @dances)", cn); com1.Parameters.AddWithValue("tournir_name", group_new.tournir_name); com1.Parameters.AddWithValue("group_number", group_new.number); com1.Parameters.AddWithValue("category", group_new.name); string testStr = ""; for (int i = 0; i < CategoriesList.Length; i++) { if (CategoriesList[i].Checked == true) { switch (i) { case 0: testStr += "Д-0;"; group_new.CategoryList.Add("Д-0"); break; case 1: testStr += "Д-1;"; group_new.CategoryList.Add("Д-1"); break; case 2: testStr += "Д-2;"; group_new.CategoryList.Add("Д-2"); break; case 3: testStr += "М;"; group_new.CategoryList.Add("М"); break; case 4: testStr += "М-2;"; group_new.CategoryList.Add("М-2"); break; case 5: testStr += "Ю-1;"; group_new.CategoryList.Add("Ю-1"); break; case 6: testStr += "Ю-2;"; group_new.CategoryList.Add("Ю-2"); break; case 7: testStr += "Вз;"; group_new.CategoryList.Add("Вз"); break; default: testStr += "Другая;"; group_new.CategoryList.Add("Другая"); break; } } } com1.Parameters.AddWithValue("categories", testStr); string testStr1 = ""; for (int i = 0; i < DancesList.Length; i++) { if (DancesList[i].Checked == true) { switch (i) { case 0: testStr1 += "W;"; group_new.DancesList.Add("W"); break; case 1: testStr1 += "V;"; group_new.DancesList.Add("V"); break; case 2: testStr1 += "T;"; group_new.DancesList.Add("T"); break; case 3: testStr1 += "F;"; group_new.DancesList.Add("F"); break; case 4: testStr1 += "Q;"; group_new.DancesList.Add("Q"); break; case 5: testStr1 += "S;"; group_new.DancesList.Add("S"); break; case 6: testStr1 += "Ch;"; group_new.DancesList.Add("Ch"); break; case 7: testStr1 += "R;"; group_new.DancesList.Add("R"); break; case 8: testStr1 += "P;"; group_new.DancesList.Add("P"); break; case 9: testStr1 += "J;"; group_new.DancesList.Add("J"); break; } } } com1.Parameters.AddWithValue("dances", testStr1); try { com1.ExecuteNonQuery(); tournir.groups.Add(group_new); } catch (Exception ex) { MessageBox.Show($"Возникла непредвиденная проблема при обращении к базе:\n{ex.Message}", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } for (int i = 0; i < CategoriesList.Length; i++) { com2 = new OleDbCommand("INSERT INTO categories(Номер, Номер_Группы, Категория)" + "VALUES (@number, @group_number, @category)", cn); com2.Parameters.AddWithValue("number", i + 1); com2.Parameters.AddWithValue("group_number", group_new.number); if (CategoriesList[i].Checked == true) { switch (i) { case 0: com2.Parameters.AddWithValue("category", "Д-0"); com2.ExecuteNonQuery(); break; case 1: com2.Parameters.AddWithValue("category", "Д-1"); com2.ExecuteNonQuery(); break; case 2: com2.Parameters.AddWithValue("category", "Д-2"); com2.ExecuteNonQuery(); break; case 3: com2.Parameters.AddWithValue("category", "М"); com2.ExecuteNonQuery(); break; case 4: com2.Parameters.AddWithValue("category", "М-2"); com2.ExecuteNonQuery(); break; case 5: com2.Parameters.AddWithValue("category", "Ю-1"); com2.ExecuteNonQuery(); break; case 6: com2.Parameters.AddWithValue("category", "Ю-2"); com2.ExecuteNonQuery(); break; case 7: com2.Parameters.AddWithValue("category", "Вз"); com2.ExecuteNonQuery(); break; default: com2.Parameters.AddWithValue("category", "Другая"); com2.ExecuteNonQuery(); break; } } } for (int i = 0; i < DancesList.Length; i++) { com2 = new OleDbCommand("INSERT INTO dances(Номер_Группы, Танец)" + "VALUES (@group_number, @dance)", cn); com2.Parameters.AddWithValue("group_number", group_new.number); if (DancesList[i].Checked == true) { switch (i) { case 0: com2.Parameters.AddWithValue("dance", "W"); com2.ExecuteNonQuery(); break; case 1: com2.Parameters.AddWithValue("dance", "V"); com2.ExecuteNonQuery(); break; case 2: com2.Parameters.AddWithValue("dance", "T"); com2.ExecuteNonQuery(); break; case 3: com2.Parameters.AddWithValue("dance", "F"); com2.ExecuteNonQuery(); break; case 4: com2.Parameters.AddWithValue("dance", "Q"); com2.ExecuteNonQuery(); break; case 5: com2.Parameters.AddWithValue("dance", "S"); com2.ExecuteNonQuery(); break; case 6: com2.Parameters.AddWithValue("dance", "Ch"); com2.ExecuteNonQuery(); break; case 7: com2.Parameters.AddWithValue("dance", "R"); com2.ExecuteNonQuery(); break; case 8: com2.Parameters.AddWithValue("dance", "P"); com2.ExecuteNonQuery(); break; case 9: com2.Parameters.AddWithValue("dance", "J"); com2.ExecuteNonQuery(); break; } } } NumberOfGroup_textBox.Text = Convert.ToString(tournir.groups.Count + 1); MessageBox.Show("Новая группа успешно создана!\nУказаны категории: " + testStr); } catch (Exception ex) { MessageBox.Show("Упс...Что-то пошло не так\n" + ex.Message); } } else { MessageBox.Show("Необходимо выбрать базу турнира!"); } } else { MessageBox.Show("Поле номера группы не может быть пустым!"); } }
public static List <string> TakeDances(GroupClass input_group, string cn) { connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}"; myConnection = new OleDbConnection(connectString); myConnection.Open(); List <string> CategoryList_New = new List <string>(); try { int i = 1; int max = 0; int counter = 0; BitArray checkArray = Controller.GapCounter("Номер", "dances", "Номер_Группы", input_group.number, myConnection); command = new OleDbCommand("", myConnection); command.CommandText = "SELECT MAX(Номер) FROM dances WHERE Номер_Группы = @id"; command.Parameters.AddWithValue("id", input_group.number); if (command.ExecuteScalar() != DBNull.Value && checkArray != null) { max = Convert.ToInt32(command.ExecuteScalar()); //MessageBox.Show($"MAX в группе {input_group.number}: " + Convert.ToString(max)); foreach (bool item in checkArray) { if (i <= max) { if (checkArray[i - 1]) { command = new OleDbCommand("", myConnection); command.CommandText = "SELECT Танец FROM dances WHERE Номер = @id AND Номер_Группы = @num"; command.Parameters.AddWithValue("id", i); command.Parameters.AddWithValue("num", input_group.number); string category = command.ExecuteScalar().ToString(); //MessageBox.Show(category); CategoryList_New.Add(category); //ДОРАБОТКА } else { counter++; } } i++; } } else { MessageBox.Show("Нулевой результат запроса"); } } catch (Exception ex) { MessageBox.Show("Упс, что-то пошло не так при определении списка танцев\nError: " + ex.Message); } myConnection.Close(); return(CategoryList_New); }
public static List <Judge> TakeJudges(GroupClass input_group, string cn) { connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}"; myConnection = new OleDbConnection(connectString); myConnection.Open(); Judge new_judge = new Judge(); List <Judge> judgeList = new List <Judge>(); try { string judgesString = ""; string[] judgesStringList; command = new OleDbCommand("", myConnection); command.CommandText = "SELECT Судьи FROM groups WHERE Номер_Группы = @id"; command.Parameters.AddWithValue("id", input_group.number); judgesString = command.ExecuteScalar().ToString().Replace(" ", ""); judgesStringList = judgesString.Split(new char[] { ';' }); //MessageBox.Show(judgesString); judgeList = new List <Judge>(); for (int i = 0; i < judgesStringList.Length - 1; i++) { new_judge = new Judge(); int number = Convert.ToInt32(judgesStringList[i]); //MessageBox.Show(number.ToString()); OleDbCommand command1 = new OleDbCommand("", myConnection); command1.CommandText = "SELECT ФИО FROM judges WHERE Номер = @num"; command1.Parameters.AddWithValue("num", number); string jSNP = command1.ExecuteScalar().ToString(); command1 = new OleDbCommand("", myConnection); command1.CommandText = "SELECT Категория_Судейства FROM judges WHERE Номер = @num"; command1.Parameters.AddWithValue("num", number); string jcategory = command1.ExecuteScalar().ToString().Replace(" ", ""); string[] jSNPList = jSNP.Split(new char[] { ' ' }); if (jSNPList.Length >= 3) { new_judge.Surname = jSNPList[0]; new_judge.Name = jSNPList[1]; new_judge.Patronymic = jSNPList[2]; } new_judge.JudgeClass = jcategory; new_judge.Number = (ushort)number; new_judge.judgeChar = (char)(64 + number); //MessageBox.Show(new_judge.ToString()); judgeList.Add(new_judge); } } catch (Exception ex) { MessageBox.Show("Упс, что-то пошло не так при определении списка судей\nError: " + ex.Message); } myConnection.Close(); return(judgeList); }
public static List <Duet> TakeDuets(GroupClass input_group, string cn) { connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}"; myConnection = new OleDbConnection(connectString); myConnection.Open(); List <Duet> DuetList_New = new List <Duet>(); try { int max = 0; command = new OleDbCommand("", myConnection); command.CommandText = "SELECT Count(Номер) FROM duets WHERE Номер_Группы = @id"; command.Parameters.AddWithValue("id", input_group.number); max = Convert.ToInt32(command.ExecuteScalar()); //MessageBox.Show(max.ToString()); for (int i = 0; i < max; i++) { string Type; string SNP1; string SNP2; int number; Duet set_new = new Duet(); OleDbCommand command1 = new OleDbCommand("", myConnection); OleDbCommand command2 = new OleDbCommand("", myConnection); OleDbCommand command3 = new OleDbCommand("", myConnection); OleDbCommand command4 = new OleDbCommand("", myConnection); command1.CommandText = "SELECT Номер FROM duets WHERE Номер_Группы = @num AND Номер = @id"; command1.Parameters.AddWithValue("num", input_group.number); command1.Parameters.AddWithValue("id", i + 1); number = Convert.ToInt32(command1.ExecuteScalar()); //MessageBox.Show(number.ToString()); command2 = new OleDbCommand("", myConnection); command2.CommandText = "SELECT Тип FROM duets WHERE Номер_Группы = @num AND Номер = @id"; command2.Parameters.AddWithValue("num", input_group.number); command2.Parameters.AddWithValue("id", i + 1); Type = command2.ExecuteScalar().ToString().Replace(" ", ""); //MessageBox.Show(Type); command3 = new OleDbCommand("", myConnection); command3.CommandText = "SELECT ФИО1 FROM duets WHERE Номер_Группы = @num AND Номер = @id"; command3.Parameters.AddWithValue("num", input_group.number); command3.Parameters.AddWithValue("id", i + 1); SNP1 = command3.ExecuteScalar().ToString().Replace(" ", ""); //SNP1 = command3.ExecuteScalar().ToString(); //MessageBox.Show(SNP1); if (Type == "Пара") { command4 = new OleDbCommand("", myConnection); command4.CommandText = "SELECT ФИО2 FROM duets WHERE Номер_Группы = @num AND Номер = @id"; command4.Parameters.AddWithValue("num", input_group.number); command4.Parameters.AddWithValue("id", i + 1); SNP2 = command4.ExecuteScalar().ToString().Replace(" ", ""); //MessageBox.Show(SNP2); set_new = new Duet(number, input_group.number, SNP1, SNP2); } else { set_new = new Duet(number, input_group.number, SNP1); } DuetList_New.Add(set_new); //ДОРАБОТКА } } catch (Exception ex) { MessageBox.Show("Упс, что-то пошло не так при определении списка пар\nError: " + ex.Message); } myConnection.Close(); return(DuetList_New); }
public static List <SetClass> TakeSet(GroupClass input_group, string cn) { connectString = $"Provider=Microsoft.Jet.OLEDB.4.0;Data Source={cn}"; myConnection = new OleDbConnection(connectString); myConnection.Open(); List <SetClass> SetList_New = new List <SetClass>(); try { int i = 1; int max = 0; int counter = 0; BitArray checkArray = Controller.GapCounter("Номер_Захода", "sets", "Номер_Группы", input_group.number, myConnection); command = new OleDbCommand("", myConnection); command.CommandText = "SELECT MAX(Номер_Захода) FROM sets WHERE Номер_Группы = @id"; command.Parameters.AddWithValue("id", input_group.number); if (command.ExecuteScalar() != DBNull.Value && checkArray != null) { max = Convert.ToInt32(command.ExecuteScalar()); //MessageBox.Show($"MAX в группе {input_group.number}: " + Convert.ToString(max)); foreach (bool item in checkArray) { if (i <= max) { if (checkArray[i - 1]) { command = new OleDbCommand("", myConnection); command.CommandText = "SELECT Категория FROM categories WHERE Номер_Группы = @num"; command.Parameters.AddWithValue("id", i); command.Parameters.AddWithValue("num", input_group.number); OleDbDataReader reader = command.ExecuteReader(); 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 { counter++; } } i++; } } else { MessageBox.Show("Нулевой результат запроса"); } } catch (Exception ex) { MessageBox.Show("Упс, что-то пошло не так при определении списка заходов\nError: " + ex.Message); } myConnection.Close(); return(SetList_New); }