private void btnEnr_Click(object sender, EventArgs e) { if (txtCom.Text == "" || cbMateriel.SelectedValue == "" || dtpInter.Text == "") { MessageBox.Show("Veuillez remplir les champs.", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (btnEnr.Text == "Programmer") { var dataInter = new Data_Interventions(dtpInter.Text.Trim(), txtCom.Text.Trim(), cbMateriel.SelectedValue.ToString()); Fcts_Interventions.AjoutInter(dataInter); } else if (btnEnr.Text == "Modifier") { var dataInter = new Data_Interventions(dtpInter.Text, txtCom.Text.Trim(), cbMateriel.SelectedValue.ToString()); Fcts_Interventions.ModifInter(dataInter, id); } } _parent.Display(); }
public static void ModifInter(Data_Interventions dataInter, string id) { // Fonction permettant la modification d'une intervention var sql = "update intervention set dateInter = @dateInter, com = @com ,id_mat = @id_mat where id_intervention = @id"; var con = Fcts_DB.GetConnection(); var cmd = new MySqlCommand(sql, con) { CommandType = CommandType.Text }; cmd.Parameters.Add("@id", MySqlDbType.VarChar).Value = id; cmd.Parameters.Add("@dateinter", MySqlDbType.DateTime).Value = dataInter.DateInter; cmd.Parameters.Add("@com", MySqlDbType.VarChar).Value = dataInter.Com; // Conversion du format text en Int cmd.Parameters.Add("@id_mat", MySqlDbType.Int32).Value = dataInter.Id_mat; try { cmd.ExecuteNonQuery(); MessageBox.Show("Modification de l'intervation N° " + id + " terminé"); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }
public static void AjoutInter(Data_Interventions dataInter) { // Fonction permettant l'insertion d'une nouvelle intervention var sql = "insert into intervention (id_intervention, dateInter, com, id_mat) values (NULL, @dateinter, @com, @id_mat)"; var con = Fcts_DB.GetConnection(); var cmd = new MySqlCommand(sql, con) { CommandType = CommandType.Text }; cmd.Parameters.Add("@dateinter", MySqlDbType.DateTime).Value = dataInter.DateInter; // Date d'intervention cmd.Parameters.Add("@com", MySqlDbType.VarChar).Value = dataInter.Com; // Commentaire cmd.Parameters.Add("@id_mat", MySqlDbType.Int32).Value = dataInter.Id_mat; // Id du materiel try { cmd.ExecuteNonQuery(); MessageBox.Show("Intervention programmée !"); } catch (MySqlException ex) { MessageBox.Show(ex.Message); } }