public static fsg_gpao.Acteurs.GroupeDeTravail GetProduit(int id)
{
GroupeDeTravail V = new GroupeDeTravail();
try
{
Connexion con = new Connexion();
con.OpenConnection();
string req = " SELECT id, nom,prenom, idAtelier, Date, Remarque FROM groupedetravail WHERE id =" + id;
MySqlCommand cmd = new MySqlCommand(req, con.connexion);
MySqlDataReader dt = cmd.ExecuteReader();
while (dt.Read())
{
V.ID = dt.GetInt16(0);
V.NOM = dt.GetString(1);
V.PRENOM = dt.GetString(2);
V.IDATELIER = dt.GetInt16(3);
V.DATE = dt.GetString(4);
V.REMARQUE = dt.GetString(5);
}
con.CloseConnection();
return(V);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(null);
}
}
public static int Modifiergroupedetravail(GroupeDeTravail art)
{
try
{
Connexion con = new Connexion();
con.OpenConnection();
string req = "UPDATE groupedetravail SET nom ='" + art.NOM + "',prenom='" + art.PRENOM + "', idAtelier=" + art.IDATELIER + ", Date='" + art.DATE + "', Remarque='" + art.REMARQUE + "' WHERE id=" + art.ID + " ";
MySqlCommand cmd = new MySqlCommand(req, con.connexion);
cmd.ExecuteNonQuery();
con.CloseConnection();
return(1);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
return(0);
}
}
public static int Ajoutergroupedetravail(GroupeDeTravail art)
{
try
{
Connexion con = new Connexion();
con.OpenConnection();
string req = "INSERT INTO groupedetravail (nom,prenom, idAtelier, Date, Remarque) VALUES ('" + art.NOM + "', '" + art.PRENOM + "', " + art.IDATELIER + ", '" + art.DATE + "', '" + art.REMARQUE + "'); ";
MySqlCommand cmd = new MySqlCommand(req, con.connexion);
cmd.ExecuteNonQuery();
con.CloseConnection();
return(1);
}
catch (Exception e)
{
MessageBox.Show(e.Message + "" + e.ToString());
return(0);
}
}