private void button3_Click(object sender, EventArgs e)
{
String dt = AddSotr.Text;
String ti = AddVrem.Text;
String ui = Mesto.Text;
String zi = AddRab.Text;
datacon db = new datacon();
MySqlCommand command = new MySqlCommand("INSERT INTO `rab`(sotrudnik, vremya, mesto, vidrab) values (@dt, @ti, @ui, @zi)", db.GetConnection());
command.Parameters.Add("@dt", MySqlDbType.VarChar).Value = dt;
command.Parameters.Add("@ti", MySqlDbType.VarChar).Value = ti;
command.Parameters.Add("@ui", MySqlDbType.VarChar).Value = ui;
command.Parameters.Add("@zi", MySqlDbType.VarChar).Value = zi;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Запись добавлена");
}
else
{
MessageBox.Show("Ошибка");
}
db.closeConnection();
button1.PerformClick();
}
private void button2_Click(object sender, EventArgs e)
{
if (checkBox1.Checked == true)
{
String ti = name.Text;
String ui = pass.Text;
datacon db = new datacon();
MySqlCommand command = new MySqlCommand("INSERT INTO `admins`(login, password) values (@ti, @ui)", db.GetConnection());
command.Parameters.Add("@ti", MySqlDbType.VarChar).Value = ti;
command.Parameters.Add("@ui", MySqlDbType.VarChar).Value = ui;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Пользователь добавлен");
}
else
{
MessageBox.Show("Ошибка");
}
db.closeConnection();
}
else
{
String ti = name.Text;
String ui = pass.Text;
datacon db = new datacon();
MySqlCommand command = new MySqlCommand("INSERT INTO `user`(login, password) values (@ti, @ui)", db.GetConnection());
command.Parameters.Add("@ti", MySqlDbType.VarChar).Value = ti;
command.Parameters.Add("@ui", MySqlDbType.VarChar).Value = ui;
db.openConnection();
if (command.ExecuteNonQuery() == 1)
{
MessageBox.Show("Пользователь добавлен");
}
else
{
MessageBox.Show("Ошибка");
}
db.closeConnection();
}
}
