private void асценкиToolStripMenuItem_Click(object sender, EventArgs e) { try { foreach (Form form in Application.OpenForms) { if (form.GetType() == typeof(ServiceCostForm)) { form.Activate(); return; } } ServiceCostForm ServiceCostForm = new ServiceCostForm(role); tabControl1.Show(); TabPage CarriageTabPage = new TabPage("Расценки"); tabControl1.TabPages.Add(CarriageTabPage); tabControl1.SelectedTab = CarriageTabPage; ServiceCostForm.TopLevel = false; ServiceCostForm.Visible = true; ServiceCostForm.FormBorderStyle = FormBorderStyle.None; ServiceCostForm.Dock = DockStyle.Fill; CarriageTabPage.Controls.Add(ServiceCostForm); } catch (Exception exp) { MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); logger.Error(exp, "РасценкиToolStripMenuItem_Click"); } }
private void button1_Click(object sender, EventArgs e) { try { string FillServiceCost = "exec dbo.FillServiceCost '" + textBox2.Text.Trim() + "','" + dateTimePicker1.Value.Date.ToString() + "','" + dateTimePicker2.Value.Date.ToString() + "'," + textBox1.Text.Replace(",", ".") + "," + comboBox2.SelectedValue.ToString(); DbConnection.DBConnect(FillServiceCost); this.Close(); MessageBox.Show("Запись добавлена!", "", MessageBoxButtons.OK, MessageBoxIcon.Information); ServiceCostForm main = this.Owner as ServiceCostForm; main.Btn_Refresh_Click(null, null); } catch (SqlException ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } catch (Exception exp) { MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }