public void Modifier_aler_tache_bdd(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_utilis=@id_utilis,Son=@son 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_utilis", alerte.getidutilis().ToString());
cmd.Parameters.AddWithValue("@son", alerte.getson());
cmd.ExecuteNonQuery();
con.Close();
}
public int inserer_alerte_tache(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");
SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\bdd.mdf;Integrated Security=True");
String query = "INSERT INTO Alertes(temps,id_tach,activer,son,id_utilis) output INSERTED.id_alerte VALUES ('" + /*temp*/ alerte.gettemps().ToString("G", culture) + "','" + /*id_tache*/ alerte.getidtach().ToString() + "','" + /*activ*/ alerte.getactiver() + "','" + alerte.getson() + "','" + alerte.getidutilis() + "')";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
id_alerte = (int)cmd.ExecuteScalar();
con.Close();
}
catch (Exception e)
{
MessageBox.Show(string.Concat("Erreur : ", e.Message));
}
setidalerte(id_alerte);
return(id_alerte);
}