private void Insert_String() { if (identify == "kartochka") { Kartochka kartochka = new Kartochka(MySqlQueries, MySqlOperations, null); string output = string.Empty; kartochka.button1.Visible = true; kartochka.button3.Visible = false; kartochka.button4.Visible = false; kartochka.button5.Visible = false; kartochka.button6.Visible = false; kartochka.button7.Visible = false; kartochka.button8.Visible = false; kartochka.label6.Visible = false; kartochka.label7.Visible = false; kartochka.dataGridView1.Visible = false; kartochka.dataGridView2.Visible = false; MySqlOperations.Select_Text(MySqlQueries.Select_Otdely_ComboBox_by_ID, ref output, ID); MySqlOperations.Search_In_ComboBox(output, kartochka.comboBox1); kartochka.comboBox1.DropDownStyle = ComboBoxStyle.Simple; kartochka.comboBox1.Enabled = false; kartochka.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Kartochka_Otdela, dataGridView1, ID); } }
private void Update_String() { if (identify == "othody") { Othody othody = new Othody(MySqlOperations, MySqlQueries, dataGridView1.SelectedRows[0].Cells[0].Value.ToString()); othody.button3.Visible = true; othody.button1.Visible = false; othody.textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); MySqlOperations.Search_In_ComboBox(dataGridView1.SelectedRows[0].Cells[2].Value.ToString(), othody.comboBox2); MySqlOperations.Search_In_ComboBox(dataGridView1.SelectedRows[0].Cells[3].Value.ToString(), othody.comboBox1); othody.AcceptButton = othody.button3; othody.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Othody, dataGridView1); } else if (identify == "sotrudniki") { Sotrudniki sotrudniki = new Sotrudniki(MySqlOperations, MySqlQueries, dataGridView1.SelectedRows[0].Cells[0].Value.ToString()); sotrudniki.button3.Visible = true; sotrudniki.button1.Visible = false; sotrudniki.textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString().Split(' ')[0]; sotrudniki.textBox2.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString().Split(' ')[1]; sotrudniki.textBox3.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString().Split(' ')[2]; MySqlOperations.Search_In_ComboBox(dataGridView1.SelectedRows[0].Cells[2].Value.ToString(), sotrudniki.comboBox1); sotrudniki.textBox4.Text = dataGridView1.SelectedRows[0].Cells[3].Value.ToString(); sotrudniki.AcceptButton = sotrudniki.button3; sotrudniki.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Sotrudniki, dataGridView1); } else if (identify == "otdely") { Otdely otdely = new Otdely(MySqlOperations, MySqlQueries, dataGridView1.SelectedRows[0].Cells[0].Value.ToString()); otdely.button3.Visible = true; otdely.button1.Visible = false; otdely.textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); otdely.AcceptButton = otdely.button3; otdely.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Otdely, dataGridView1); } else if (identify == "organizacii") { Organizacii organizacii = new Organizacii(MySqlOperations, MySqlQueries, dataGridView1.SelectedRows[0].Cells[0].Value.ToString()); organizacii.button3.Visible = true; organizacii.button1.Visible = false; organizacii.textBox1.Text = dataGridView1.SelectedRows[0].Cells[1].Value.ToString(); organizacii.AcceptButton = organizacii.button3; organizacii.ShowDialog(); MySqlOperations.Select_DataGridView(MySqlQueries.Select_Organizacii, dataGridView1); } }