private void button1_Click(object sender, EventArgs e)
{
Hide();
Form8DobNP form8 = new Form8DobNP();
form8.ShowDialog();
}
private void button1_Click(object sender, EventArgs e)
{
using (MySqlConnection mysqlCon = new MySqlConnection(connectionString))
{
int _kol_tovara = 0;
mysqlCon.Open();
MySqlCommand mySqlCmd = new MySqlCommand("tovar1AddOrEdit", mysqlCon);
mySqlCmd.CommandType = CommandType.StoredProcedure;
mySqlCmd.Parameters.AddWithValue("__id_tovara", _id_tovara);
mySqlCmd.Parameters.AddWithValue("_name", textBox1.Text.Trim());
mySqlCmd.Parameters.AddWithValue("__id_otdela", comboBox1.SelectedValue);
mySqlCmd.Parameters.AddWithValue("_kol_tovara", _kol_tovara);
mySqlCmd.Parameters.AddWithValue("_edinica_izmereniay", textBox4.Text.Trim());
mySqlCmd.Parameters.AddWithValue("_cena_na_prod", textBox3.Text.Trim());
mySqlCmd.ExecuteNonQuery();
MessageBox.Show("Запись добавлена");
Clear();
//GridFill();
Hide();
Form8DobNP form8 = new Form8DobNP();
form8.ShowDialog();
}
}
private void button2_Click(object sender, EventArgs e)
{
using (MySqlConnection mysqlCon = new MySqlConnection(connectionString))
{
mysqlCon.Open();
MySqlCommand mySqlCmd = new MySqlCommand("postav_N", mysqlCon);
mySqlCmd.CommandType = CommandType.StoredProcedure;
mySqlCmd.Parameters.AddWithValue("__id_post", _id_post);
mySqlCmd.Parameters.AddWithValue("_name_post", textBox1.Text.Trim());
mySqlCmd.Parameters.AddWithValue("_adres", textBox2.Text.Trim());
mySqlCmd.Parameters.AddWithValue("_telefon", textBox3.Text.Trim());
mySqlCmd.ExecuteNonQuery();
MessageBox.Show("Запись добавлена");
dataGridView1.Refresh();
Clear();
GridFill2();
}
Hide();
Form8DobNP form8 = new Form8DobNP();
form8.ShowDialog();
}