public void Modifier(int id_alerte, alerte_class alerte) { CultureInfo culture = CultureInfo.CreateSpecificCulture("en-En"); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); String query = "update Alertes set temps=@temps,id_tach=@id_tach,id_évèn=@id_even,id_utilis=@id_utilis,Son=@son,activer=@activer WHERE id_alerte=@id"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); cmd.Parameters.AddWithValue("@id", id_alerte.ToString()); cmd.Parameters.AddWithValue("@temps", alerte.gettemps().ToString("G", culture)); cmd.Parameters.AddWithValue("@id_tach", alerte.getidtach().ToString()); cmd.Parameters.AddWithValue("@id_even", alerte.getidévèn().ToString()); cmd.Parameters.AddWithValue("@id_utilis", alerte.getidutilis().ToString()); cmd.Parameters.AddWithValue("@son", alerte.getson()); cmd.Parameters.AddWithValue("@activer", alerte.getactiver()); cmd.ExecuteNonQuery(); con.Close(); }
public int inserer_alerte_even(alerte_class alerte) { int id_alerte = 0; try { CultureInfo culture = CultureInfo.CreateSpecificCulture("en-En"); SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True"); String query = "INSERT INTO Alertes(temps,id_évèn,activer,son,id_utilis) output INSERTED.id_alerte VALUES ('" + alerte.gettemps().ToString("G", culture) + "','" + alerte.getidévèn().ToString() + "','" + /*activ*/ alerte.getactiver() + "','" + alerte.getson() + "','" + alerte.getidutilis() + "')"; SqlCommand cmd = new SqlCommand(query, con); con.Open(); id_alerte = (int)cmd.ExecuteScalar(); con.Close(); MessageBox.Show("Données enregistrées"); } catch (Exception e) { MessageBox.Show(string.Concat("Erreur : ", e.Message)); } setidalerte(id_alerte); return(id_alerte); }