private void Save_Click(object sender, EventArgs e)
{
using (MySqlConnection mysqlCon = new MySqlConnection(Var.Sqlmy))
{
string combo = comboBox1.Text;
string selectQueray = "SELECT * FROM Mario.Machine WHERE MachineNom = '" + combo + "';";
mysqlCon.Open();
MySqlCommand mySqlCmd = new MySqlCommand(selectQueray, mysqlCon);
MySqlDataReader reader = mySqlCmd.ExecuteReader();
while (reader.Read())
{
idnom = (int)reader["idMachine"];
}
mysqlCon.Close();
}
using (MySqlConnection mysqlCon1 = new MySqlConnection(Var.Sqlmy))
{
string valeur1 = valeurtxt.Text;
string nom1 = nomtxt.Text;
string description1 = descriptiontxt.Text;
string statut1 = statuttxt.Text;
string img1 = imgTxt.Text;
string dossier1 = dossierTxt.Text;
string id1 = idtxt.Text;
string selectQueray1 = "INSERT INTO Mario.Equipement (idMachine, EquipementValeur, EquipementNom, EquipementDescription, EquipementStatut, photo, folder, idReAchat) VALUES ('" + idnom + "','" + valeur1 + "','" + nom1 + "','" + description1 + "','" + statut1 + "','" + img1 + "','" + dossier1 + "','" + id1 + "');";
mysqlCon1.Open();
MySqlCommand mySqlCmd1 = new MySqlCommand(selectQueray1, mysqlCon1);
mySqlCmd1.ExecuteNonQuery();
MessageBox.Show("Ajout Réussi");
mysqlCon1.Close();
}
MLMachine f3 = new MLMachine(); // Instantiate a Form3 object.
f3.Show(); // Show Form3 and
}
private void button7_Click(object sender, EventArgs e)
{
MLMachine f3 = new MLMachine();
f3.Show();
}
private void button_WOC3_Click(object sender, EventArgs e)
{
MLMachine f3 = new MLMachine(); // Instantiate a Form3 object.
f3.Show(); // Show Form3 and
}
