private void ToolStripMenuItem3_Brigade_Click(object sender, EventArgs e) { try { foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(BrigadeForm)) { form.Activate(); return; } } BrigadeForm frm = new BrigadeForm(role); tabControl1.Show(); TabPage BrigadeTabPage = new TabPage("Бригадиры"); tabControl1.TabPages.Add(BrigadeTabPage); tabControl1.SelectedTab = BrigadeTabPage; frm.TopLevel = false; frm.Visible = true; frm.FormBorderStyle = FormBorderStyle.None; frm.Dock = DockStyle.Fill; BrigadeTabPage.Controls.Add(frm); } catch (Exception exp) { MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); logger.Error(exp, "ToolStripMenuItem3_Brigade_Click"); } }
private void Button1_Click(object sender, EventArgs e) { try { UpdateCurrentBrigade = "update d__Brigade " + "set Name = '" + textBox1.Text.Trim() + "', " + "Surname = '" + textBox2.Text.Trim() + "'," + "Lastname = '" + textBox3.Text.Trim() + "', " + "FIO = '" + textBox2.Text.Trim() + ' ' + textBox1.Text.Substring(0, 1) + '.' + textBox3.Text.Substring(0, 1) + '.' + "'" + "where ID = " + selectID; DataTable dtbl = new DataTable(); dtbl = DbConnection.DBConnect(UpdateCurrentBrigade); this.Close(); MessageBox.Show("Запись изменена!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); BrigadeForm main = this.Owner as BrigadeForm; main.Refreshh(); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exp) { MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void BtnAdd_Click(object sender, EventArgs e) { try { AddNewBrigade = "insert into d__Brigade values('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "','" + textBox3.Text.Trim() + "','" + textBox2.Text.Trim() + ' ' + textBox1.Text.Substring(0, 1) + '.' + textBox3.Text.Substring(0, 1) + '.' + "')"; DataTable dataTable = new DataTable(); dataTable = DbConnection.DBConnect(AddNewBrigade); this.Close(); MessageBox.Show("Сотрудник добавлен!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); BrigadeForm main = this.Owner as BrigadeForm; main.Refreshh(); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exp) { MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }