//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 !");
}
}
