}//fin constructeur
#region Service Methods
public Diplome getDiplome(String IdDiplome)
{
List<UniteEnseignement> ues = null;
var select = "SELECT diplome.Intitule" + "\n";
var from = "FROM formation.Diplome diplome" + "\n";
var where = "WHERE diplome.IdDiplome = '{0}'";
var diplome = new Diplome();
using (var dbConnection = new SqlConnection(MasterProgramDbConnectionString))
{
dbConnection.Open();
using (SqlCommand sqlCommand = dbConnection.CreateCommand())
{
ues = getUEs(IdDiplome, sqlCommand);
sqlCommand.CommandText = String.Format(select + from + where, IdDiplome);
SqlDataReader reader = sqlCommand.ExecuteReader();
reader.Read();
String id = IdDiplome;
String intitule;
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
else
{
intitule = null;
}
reader.Close();
diplome.IdDiplome = id;
diplome.Intitule = intitule;
diplome.UEs = ues;
}//fin SqlCommand
dbConnection.Close();
}//fin dbConnection
return diplome;
}//fin getDiplome()
}//fin getDiplome()
public List<Diplome> getAllDiplomes()
{
var diplomes = new List<Diplome>();
List<UniteEnseignement> ues = null;
using (var dbConnection = new SqlConnection(MasterProgramDbConnectionString))
{
dbConnection.Open();
using (SqlCommand sqlCommand = dbConnection.CreateCommand())
{
sqlCommand.CommandText = "SELECT * FROM formation.Diplome";
SqlDataReader reader = sqlCommand.ExecuteReader();
String intitule = null;
while (reader.Read())
{
var id = (String)reader["IdDiplome"];
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
else
{
intitule = null;
}
var diplome = new Diplome
{
IdDiplome = (String)reader["IdDiplome"],
Intitule = intitule,
UEs = ues
};
if (diplome!=null) {
diplomes.Add(diplome);
}
}// fin While
reader.Close();
foreach (Diplome diplome in diplomes)
{
var id = diplome.IdDiplome;
diplome.UEs = getUEs(id, sqlCommand);
}
}//fin SqlCommand
dbConnection.Close();
}
return diplomes;
}//fin getMatiere ()
}//fin getIdUEs()
protected List<Diplome> getDiplomes(String IdUE, SqlCommand sqlCommand)
{
var select = "SELECT diplome.Intitule ";
var from = "FROM formation.DIPLOME diplome ";
var where = "WHERE diplome.IdDiplome = '{0}' ";
var IdDiplomes = getIdDiplomes(IdUE, sqlCommand);
var Diplomes = new List<Diplome>();
String intitule = null;
foreach (String id in IdDiplomes)
{
sqlCommand.CommandText = String.Format(select + from + where, id);
SqlDataReader reader = sqlCommand.ExecuteReader();
reader.Read();
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
else
{
intitule = null;
}
var diplome = new Diplome
{
IdDiplome = id,
Intitule = intitule,
UEs = null
};
reader.Close();
Diplomes.Add(diplome);
}
return Diplomes;
}//fin getDiplomes()