//Ajoute Technicien public static void ajouteTech(technicien unTech) { MySqlConnection conn = new MySqlConnection(connexion); conn.Open(); MySqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "INSERT INTO technicien(mdp_tech,nom_tech,prenom_tech,adresse_tech,matricule_tech,date_embauche_tech,region_tech,niveau_tech,formation_tech,competence_tech,id_resp)" + "VALUES(@mdpTech, @nomTech, @prenomTech, @adresseTech, @matriculeTech, @dateTech, @regionTech, @nivTech, @formationTech, @competenceTech,@idResp)"; cmd.Parameters.AddWithValue("@mdpTech", unTech.MdpTech); cmd.Parameters.AddWithValue("@nomTech", unTech.NomTech); cmd.Parameters.AddWithValue("@prenomTech", unTech.PrenomTech); cmd.Parameters.AddWithValue("@adresseTech", unTech.AdresseTech); cmd.Parameters.AddWithValue("@matriculeTech", unTech.MatriculeTech); cmd.Parameters.AddWithValue("@dateTech", unTech.DateTech); cmd.Parameters.AddWithValue("@regionTech", unTech.RegionTech); cmd.Parameters.AddWithValue("@nivTech", unTech.NivInter); cmd.Parameters.AddWithValue("@formationTech", unTech.Formation); cmd.Parameters.AddWithValue("@competenceTech", unTech.Competence); cmd.Parameters.AddWithValue("@idResp", unTech.IdResp); cmd.ExecuteNonQuery(); conn.Close(); }
private void button1_Click(object sender, EventArgs e) { //MessageBox.Show(Convert.ToString(id)); if (radioUser.Checked) { user unUser = new user(TBmdp.Text, TBnom.Text, TBprenom.Text, TBadresse.Text, TBmatricule.Text, dateTimePicker1.Value.ToString(), TBregion.Text, TBobjectif.Text, Convert.ToInt32(TBprime.Text), TBavantage.Text, Convert.ToInt32(TBbudget.Text), id); BD.ajouteUser(unUser); MessageBox.Show("Ajout Réussi !"); } else if (radioTech.Checked) { technicien unTech = new technicien(TBmdp.Text, TBnom.Text, TBprenom.Text, TBadresse.Text, TBmatricule.Text, dateTimePicker1.Value.ToString(), TBregion.Text, Convert.ToInt32(TBniv.Text), TBformation.Text, TBcompetence.Text, id); BD.ajouteTech(unTech); MessageBox.Show("Ajout Réussi !"); } else { MessageBox.Show("Veuillez choisir le type d'ajout !"); } }