public static int modifierRemarque(JournalP journal)
{
try
{
Connexion cnx = new Connexion();
cnx.OpenConnection();
String requette = "UPDATE journaladmin SET remarque ='" + journal.REMARQUE + "' WHERE id=" + journal.ID + " ";
MySqlCommand cmd = new MySqlCommand(requette, cnx.connexion);
cmd.ExecuteNonQuery();
cnx.CloseConnection();
return(1);
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
return(0);
}
}
public static void ajouterJournal(JournalP journal)
{
try
{
Connexion cnx = new Connexion();
cnx.OpenConnection();
String requette = "INSERT INTO journaladmin (idAdmin, heure, action, remarque) VALUES (" + journal.IDADMIN + ",'" + journal.HEURE + "','" + journal.ACTION + "','" + journal.REMARQUE + "')";
//MySql.Data.MySqlClient.MySqlCommand m1 = new MySql.Data.MySqlClient.MySqlCommand(requette, cnx.connexion);
//m1.Connection.Open();
MySqlCommand cmd = new MySqlCommand(requette, cnx.connexion);
cmd.ExecuteNonQuery();
cnx.CloseConnection();
//m1.Connection.Close();
}
catch (Exception e)
{
//MessageBox.Show(e.Message);
}
}
