}//fin getMatiere ()
public List<Matiere> getAllMatieres()
{
List<Matiere> matieres = null;
using (var dbConnection = new SqlConnection(MasterProgramDbConnectionString))
{
dbConnection.Open();
using (SqlCommand sqlCommand = dbConnection.CreateCommand())
{
sqlCommand.CommandText = "SELECT * FROM formation.MATIERE";
SqlDataReader reader = sqlCommand.ExecuteReader();
matieres = new List<Matiere>();
String intitule = null;
while (reader.Read())
{
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
else
{
intitule = null;
}
var matiere = new Matiere
{
IdMatiere = (String)reader["IdMatiere"],
Intitule = intitule
};
matieres.Add(matiere);
}// fin While
}//fin SqlCommand
dbConnection.Close();
}
return matieres;
}//fin getMatiere ()
}//fin getAllModules()
public Matiere getMatiere(String IdMatiere)
{
var select = "SELECT matiere.IdMatiere, matiere.Intitule" + "\n";
var from = "FROM formation.Matiere matiere " + "\n";
var where = "WHERE matiere.IdMatiere = '{0}'";
var matiere = new Matiere();
using (var dbConnection = new SqlConnection(MasterProgramDbConnectionString))
{
dbConnection.Open();
using (SqlCommand sqlCommand = dbConnection.CreateCommand())
{
sqlCommand.CommandText = String.Format(select + from + where, IdMatiere);
SqlDataReader reader = sqlCommand.ExecuteReader();
reader.Read();
String intitule = null;
int nbCM = -1;
int nbTD = -1;
int nbTP = -1;
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
if (!reader.IsDBNull(2))
{
nbCM = (int)reader["nbCM"];
}
if (!reader.IsDBNull(3))
{
nbTD = (int)reader["nbTD"];
}
if (!reader.IsDBNull(4))
{
nbTP = (int)reader["nbTP"];
}
String id = (String)reader["IdMatiere"];
String idModule = (String)reader["IdModules"];
reader.Close();
matiere.IdMatiere = id;
matiere.Intitule = intitule;
matiere.NbCM = nbCM;
matiere.NbTD = nbTD;
matiere.NbTP = nbTP;
matiere.ModuleAssocie = getModule(id);
}//fin SqlCommand
dbConnection.Close();
}//fin dbConnection
return matiere;
}//fin getMatiere ()
