public override Enseignement find(string nom)
{
Enseignement ens = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_partie_annee, description FROM enseignement WHERE nom='" + nom + "';", Connexion.getInstance()))
{
using (SqlDataReader reader_f = command_f.ExecuteReader())
{
if (reader_f.HasRows)
{
while (reader_f.Read())
{
AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY);
DAO <PartieAnnee> TPSQL = factoSQL.getPartieAnneeDAO();
PartieAnnee partannee2 = TPSQL.find(reader_f.GetInt32(2));
ens = new Enseignement(reader_f.GetInt32(0), reader_f.GetString(1), partannee2, reader_f.GetString(3));
reader_f.NextResult();
}
}
reader_f.Close();
}
}
return(ens);
}
public override List <Enseignement> findAll()
{
List <Enseignement> enses = new List <Enseignement>();
using (SqlCommand command_f = new SqlCommand("SELECT * FROM enseignement;", Connexion.getInstance()))
{
using (SqlDataReader reader_f = command_f.ExecuteReader())
{
if (reader_f.HasRows)
{
while (reader_f.Read())
{
AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY);
DAO <PartieAnnee> TPSQL = factoSQL.getPartieAnneeDAO();
PartieAnnee partannee2 = TPSQL.find(reader_f.GetInt32(2));
enses.Add(new Enseignement(reader_f.GetInt32(0), reader_f.GetString(1), partannee2, reader_f.GetString(3)));
}
}
}
}
return(enses);
}
public override Enseignement find(int id)
{
Enseignement ens = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_partie_annee, description FROM enseignement WHERE id=" + id + ";", Connexion.getInstance()))
{
using (SqlDataReader reader_f = command_f.ExecuteReader())
{
if (reader_f.HasRows)
{
while (reader_f.Read())
{
AbstractDAOFactory factoSQL = AbstractDAOFactory.getFactory(types.SQL_FACTORY);
DAO <PartieAnnee> TPSQL = factoSQL.getPartieAnneeDAO();
PartieAnnee partannee2 = TPSQL.find(reader_f.GetInt32(2));
ens = new Enseignement(reader_f.GetInt32(0), reader_f.GetString(1), partannee2, reader_f.GetString(3));
reader_f.NextResult();
}
}
else
{
throw new Exception("Aucun objet avec cet id n'a été trouvé.");
}
reader_f.Close();
}
}
return(ens);
}
