public List <Activite> RecupererListeActivites()
{
List <Activite> listeSortante = new List <Activite>();
string maRequete = "SELECT * FROM activite";
SqlCommand cmd = new SqlCommand();
AccesBDD accesBDD = new AccesBDD();
accesBDD.OuvertureBDD();
cmd.Connection = accesBDD.Cnx;
cmd.CommandText = maRequete;
SqlDataReader resultat = cmd.ExecuteReader();
if (!resultat.HasRows)
{
}
while (resultat.Read())
{
Activite actTemp = new Activite(resultat);
listeSortante.Add(actTemp);
}
resultat.Close();
accesBDD.FermetureBDD();
return(listeSortante);
}
public Activite IdToActivite(int id_activite)
{
Activite monActivite = new Activite();
string maRequete = "SELECT * FROM Activite where id_activite = " + id_activite.ToString();
//Faire une méthode qui à partir d'un requete renvoit une commande SQL
SqlCommand cmd = new SqlCommand();
AccesBDD monAccesBDD = new AccesBDD();
monAccesBDD.OuvertureBDD();
cmd.Connection = monAccesBDD.Cnx;
cmd.CommandText = maRequete;
cmd.CommandType = System.Data.CommandType.Text;
//Jusque là
SqlDataReader dr = cmd.ExecuteReader();
dr.Read();
monActivite.Id_activite = (int)dr["id_activite"];
monActivite.Id_domaine_activite = (int)dr["id_domaine_activite"];
monActivite.Nom_activite = (string)dr["nom_activite"];
if (!dr.IsDBNull(2))
{
monActivite.Id_materiel = (int)dr["id_materiel"];
}
return(monActivite);
}
