private void toolStripMenuItem4_Owner_Click(object sender, EventArgs e)
{
try
{
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(OwnerForm))
{
form.Activate();
return;
}
}
OwnerForm frm = new OwnerForm(role);
tabControl1.Show();
TabPage OwnerTabPage = new TabPage("Собственники");
tabControl1.TabPages.Add(OwnerTabPage);
tabControl1.SelectedTab = OwnerTabPage;
frm.TopLevel = false;
frm.Visible = true;
frm.FormBorderStyle = FormBorderStyle.None;
frm.Dock = DockStyle.Fill;
OwnerTabPage.Controls.Add(frm);
}
catch (Exception exp)
{
MessageBox.Show(exp.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
logger.Error(exp, "toolStripMenuItem4_Owner_Click");
}
}
//изменить
private void btnOk_Click(object sender, EventArgs e)
{
try
{
string UpdateCurrentOwner = "update d__Owner set Name = '" + textBox1.Text.Trim() + "', FullName = '" + textBox2.Text.Trim() + "' where ID = " + selectID;
DataTable dtbl = new DataTable();
dtbl = DbConnection.DBConnect(UpdateCurrentOwner);
this.Close();
MessageBox.Show("Запись изменена!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
OwnerForm main = this.Owner as OwnerForm;
main.btnOwnerReffresh_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);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
try
{
string AddNewOwner = "insert into d__Owner " +
"values ('" + textBox1.Text.Trim() + "','" + textBox2.Text.Trim() + "',NULL)";
DataTable dataTable = new DataTable();
dataTable = DbConnection.DBConnect(AddNewOwner);
this.Close();
MessageBox.Show("Запись добавлена!", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
OwnerForm main = this.Owner as OwnerForm;
main.btnOwnerReffresh_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);
}
}
