}//fin getIdDiplome()
protected UniteEnseignement getUE(String IdModule, SqlCommand sqlCommand)
{
var select = "SELECT ue.Intitule, ue.Descriptif, ue.Semestre ";
var from = "FROM formation.UE ue ";
var where = "WHERE ue.IdUE = '{0}'";
var id = getIdUE(IdModule, sqlCommand);
var diplomes = getDiplomes(id, sqlCommand);
sqlCommand.CommandText = String.Format(select + from + where, id);
SqlDataReader reader = sqlCommand.ExecuteReader();
reader.Read();
String intitule = null;
String descriptif = null;
int semestre = -1;
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
if (!reader.IsDBNull(2))
{
descriptif = (String)reader["Descriptif"];
}
if (!reader.IsDBNull(3))
{
semestre = (int)reader["Semestre"];
}
reader.Close();
var ue = new UniteEnseignement
{
IdUE = id,
Intitule = intitule,
Descriptif = descriptif,
Semestre = semestre,
Diplomes = diplomes
};
return ue;
}//fin get UE
}//fin getUE()
public List<UniteEnseignement> getAllUEs()
{
List<UniteEnseignement> ues = null;
List<Diplome> diplomes = null;
using (var dbConnection = new SqlConnection(MasterProgramDbConnectionString))
{
dbConnection.Open();
using (SqlCommand sqlCommand = dbConnection.CreateCommand())
{
sqlCommand.CommandText = "SELECT * FROM formation.UE";
SqlDataReader reader = sqlCommand.ExecuteReader();
ues = new List<UniteEnseignement>();
String intitule = null;
String descriptif = null;
int semestre = -1;
while (reader.Read())
{
var id = (String)reader["IdUE"];
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
else
{
intitule = null;
}
if (!reader.IsDBNull(2))
{
descriptif = (String)reader["Descriptif"];
}
else
{
descriptif = null;
}
if (!reader.IsDBNull(3))
{
semestre = (int)reader["Semestre"];
}
else
{
semestre = -1;
}
var ue = new UniteEnseignement
{
IdUE = (String)reader["IdUE"],
Intitule = intitule,
Descriptif = descriptif,
Semestre = semestre,
Diplomes = diplomes
};
ues.Add(ue);
}// fin While
reader.Close();
foreach (UniteEnseignement ue in ues)
{
var id = ue.IdUE;
ue.Diplomes = getDiplomes(id, sqlCommand);
}
}//fin SqlCommand
dbConnection.Close();
}
return ues;
}//fin getAllUEs()
}//fin getMatiere ()
#endregion
#region Helper Methods
protected List<UniteEnseignement> getUEs(String IdDiplome, SqlCommand sqlCommand)
{
var select = "SELECT ue.Intitule, ue.Descriptif, ue.Semestre ";
var from = "FROM formation.UE ue ";
var where = "WHERE ue.IdUE = '{0}'";
var IdUEs = new List<String>();
IdUEs = getIdUEs(IdDiplome, sqlCommand);
var UEs = new List<UniteEnseignement>();
String intitule = null;
String descriptif = null;
int semestre = -1;
foreach (String id in IdUEs)
{
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;
}
if (!reader.IsDBNull(2))
{
descriptif = (String)reader["Intitule"];
}
else
{
descriptif = null;
}
if (!reader.IsDBNull(3))
{
semestre = (int)reader["Intitule"];
}
else
{
semestre = -1;
}
var ue = new UniteEnseignement
{
IdUE = id,
Intitule = intitule,
Descriptif =descriptif,
Semestre = semestre,
Diplomes = null
};
reader.Close();
if (ue != null)
{
UEs.Add(ue);
}
}//fin foreach
return UEs;
}//fin getUEs()
}//fin getMatiere ()
public UniteEnseignement getUE(String IdUE)
{
var select = "SELECT ue.IdUE, ue.Intitule, ue.Descriptif, ue.Semestre " + "\n";
var from = "FROM formation.UE ue " + "\n";
var where = "WHERE ue.IdUE = '{0}'";
var ue = new UniteEnseignement();
List<Diplome> diplomes = null;
using (var dbConnection = new SqlConnection(MasterProgramDbConnectionString))
{
dbConnection.Open();
using (SqlCommand sqlCommand = dbConnection.CreateCommand())
{
diplomes = getDiplomes(IdUE, sqlCommand);
sqlCommand.CommandText = String.Format(select + from + where, IdUE);
SqlDataReader reader = sqlCommand.ExecuteReader();
String intitule = null;
String descriptif = null;
int semestre = -1;
reader.Read();
String id = (String)reader["IdUE"];
if (!reader.IsDBNull(1))
{
intitule = (String)reader["Intitule"];
}
if (!reader.IsDBNull(2))
{
descriptif = (String)reader["Descriptif"];
}
if (!reader.IsDBNull(3))
{
semestre = (int)reader["Semestre"];
}
reader.Close();
ue.IdUE = id;
ue.Intitule = intitule;
ue.Descriptif = descriptif;
ue.Semestre = semestre;
ue.Diplomes = diplomes;
}//fin SqlCommand
dbConnection.Close();
}//fin dbConnection
return ue;
}//fin getUE()