public Editor(HandleFormAdd handleForm)
{
InitializeComponent();
FormLoad();
hf = handleForm;
hf.Enabled = false;
}
private void AddBtnClick(object sender, EventArgs e)
{
string query = null;
int ID = 1;
using (OleDbCommand command = new OleDbCommand("SELECT MAX([Код]) FROM телефоны ", connection))
{
OleDbDataReader reader = command.ExecuteReader();
reader.Read();
ID += int.Parse(reader[0].ToString());
reader.Close();
}
using (hf = new HandleFormAdd(this))
{
hf.ShowDialog();
if (hf.DialogResult == DialogResult.OK)
{
hf.Close();
if (phone_numb == "")
{
query = $"INSERT INTO [телефоны] VALUES ('{ID}', '{name}', NULL, '{int.Parse(mob_phone_numb)}', {birthday}, '{email}', '{peop_type}', '{adress}', '{remark}'); ";
}
else if (mob_phone_numb == "")
{
query = $"INSERT INTO [телефоны] VALUES ('{ID}', '{name}', '{int.Parse(phone_numb)}', NULL, {birthday}, '{email}', '{peop_type}', '{adress}', '{remark}'); ";
}
else
{
query = $"INSERT INTO [телефоны] VALUES ('{ID}', '{name}', '{int.Parse(phone_numb)}', '{int.Parse(mob_phone_numb)}', {birthday}, '{email}', '{peop_type}', '{adress}', '{remark}'); ";
}
try
{
using (OleDbCommand command = new OleDbCommand(query, connection))
{
int i = command.ExecuteNonQuery();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
DataGridLoad();
}