private void Add_Click(object sender, Windows.UI.Xaml.RoutedEventArgs e)
{
if (nodeSelectionne == null)
{
Annee nouvelleAnne = new Annee {
Nom = "Nouvelle annee", Departement = depart.find(departementSelectionne.Id), NavigationDestination = typeof(AnneeVue), Description = ""
};
annee.create(nouvelleAnne);
annees.Add(nouvelleAnne);
}
else if (nodeSelectionne.GetType() == typeof(Annee))
{
PartieAnnee nouvellePartieAnnee = new PartieAnnee {
Nom = "Nouveau semestre", Annee = (Annee)nodeSelectionne, NavigationDestination = typeof(PartieAnneeVue), Description = "", Parent = nodeSelectionne
};
partieAnnee.create(nouvellePartieAnnee);
nodeSelectionne.Children.Add(nouvellePartieAnnee);
}
else if (nodeSelectionne.GetType() == typeof(PartieAnnee))
{
Enseignement nouvelEnseignement = new Enseignement {
Nom = "Nouveau enseignement", PartieAnnee = (PartieAnnee)nodeSelectionne, NavigationDestination = typeof(EnseignementVue), Description = "", Parent = nodeSelectionne
};
enseignement.create(nouvelEnseignement);
nodeSelectionne.Children.Add(nouvelEnseignement);
}
// nodeSelectionne.Nom = "fffsdfds";
}
public static List <ElementConstitutif> findByUniteEnseignement(long id)
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
MySqlDataReader reader = null;
List <ElementConstitutif> resultats = new List <ElementConstitutif>();
try
{
sql = "SELECT element_constitutif.id as elemConstID, element_constitutif.libelle as elemConstLibelle, "
+ "unite_enseignement.id as uniteEnsID, unite_enseignement.libelle as uniteEnsLibelle, "
+ "periode.id AS periodeID, periode.libelle AS periodeLibelle, "
+ "annee.id AS anneeId, annee.libelle AS anneeLibelle, "
+ "diplome.id AS diplomeID, diplome.libelle AS diplomeLibelle "
+ "FROM element_constitutif "
+ "JOIN unite_enseignement on element_constitutif.ue_id = unite_enseignement.id "
+ "JOIN periode ON unite_enseignement.periode_id = periode.id "
+ "JOIN annee ON periode.annee_id = annee.id "
+ "JOIN diplome ON annee.diplome_id = diplome.id "
+ "WHERE unite_enseignement.id = @id";
_cmd.CommandText = sql;
_cmd.Parameters.AddWithValue("@id", id);
reader = _cmd.ExecuteReader();
while (reader.Read())
{
Diplome tempDiplome = DiplomeDAO.populateDiplome(reader);
Annee tempAnnee = AnneeDAO.populateAnnee(reader);
tempAnnee.diplome = tempDiplome;
Periode tempPeriode = PeriodeDAO.populatePeriode(reader);
tempPeriode.annee = tempAnnee;
UniteEnseignement tempUnite = UniteEnseignementDAO.populateUniteEnseignement(reader);
tempUnite.periode = tempPeriode;
ElementConstitutif tempElementConstitutif = populateElementConstitutif(reader);
tempElementConstitutif.uniteEnseignement = tempUnite;
resultats.Add(tempElementConstitutif);
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
return(resultats);
}
public override PartieAnnee find(string nom)
{
PartieAnnee annee = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_annee, description FROM partie_annee 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 <Annee> TPSQL = factoSQL.getAnneeDAO();
Annee annee2 = TPSQL.find(reader_f.GetInt32(2));
annee = new PartieAnnee(reader_f.GetInt32(0), reader_f.GetString(1), annee2, reader_f.GetString(3));
}
}
reader_f.Close();
}
// Connexion.getInstance().Close();
return(annee);
}
}
public static Annee update(Annee obj)
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
try
{
sql = "UPDATE annee set libelle = @libelle, diplome_id = @diplome_id WHERE id = @id";
_cmd.CommandText = sql;
_cmd.Parameters.AddWithValue("@id", obj.id);
_cmd.Parameters.AddWithValue("@libelle", obj.libelle);
_cmd.Parameters.AddWithValue("@diplome_id", obj.diplome.id);
_cmd.ExecuteNonQuery();
obj.id = _cmd.LastInsertedId;
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
return(obj);
}
public override List <PartieAnnee> findAll()
{
List <PartieAnnee> ans = new List <PartieAnnee>();
using (SqlCommand command_f = new SqlCommand("SELECT * FROM partie_annee;", 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 <Annee> TPSQL = factoSQL.getAnneeDAO();
Annee annee2 = TPSQL.find(reader_f.GetInt32(2));
ans.Add(new PartieAnnee(reader_f.GetInt32(0), reader_f.GetString(1), annee2, reader_f.GetString(3)));
}
}
}
}
return(ans);
}
public override PartieAnnee find(int id)
{
PartieAnnee annee = null;
using (SqlCommand command_f = new SqlCommand("SELECT id, nom, id_annee, description FROM partie_annee 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 <Annee> TPSQL = factoSQL.getAnneeDAO();
Annee annee2 = TPSQL.find(reader_f.GetInt32(2));
annee = new PartieAnnee(reader_f.GetInt32(0), reader_f.GetString(1), annee2, reader_f.GetString(3));
reader_f.NextResult();
}
}
else
{
throw new Exception("Aucun objet avec cet id n'a été trouvé.");
}
reader_f.Close();
}
}
return(annee);
}
public InputModifPeriodeForm(String name, Annee a)
{
input = true;
this.Text = name;
this.a = a;
InitializeComponent();
}
public static void delete(Annee obj)
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
try
{
sql = "DELETE FROM annee WHERE id = @id";
_cmd.CommandText = sql;
_cmd.Parameters.AddWithValue("@id", obj.id);
_cmd.ExecuteNonQuery();
obj.id = _cmd.LastInsertedId;
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
}
public static Annee create(Annee obj)
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
try
{
sql = "INSERT INTO annee (id, libelle, diplome_id) VALUES (@id,@libelle,@diplome) ";
_cmd.CommandText = sql;
_cmd.Parameters.AddWithValue("@id", obj.id);
_cmd.Parameters.AddWithValue("@libelle", obj.libelle);
_cmd.Parameters.AddWithValue("@diplome", obj.diplome.id);
_cmd.ExecuteNonQuery();
obj.id = _cmd.LastInsertedId;
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
return(obj);
}
public ActionResult AJouter_Annee(Annee an)
{
Debug.WriteLine(an);
var j = dao.create(an);
Debug.WriteLine(j);
return(RedirectToAction("Index"));
}
public static void supprimerAnnee(Annee annee)
{
if (annee != null && annee.diplome != null)
{
DiplomeTest.supprimerDiplome(annee.diplome);
}
AnneeDAO.delete(annee);
}
public InputModifAnneeForm(String name, Diplome d, Annee a)
{
input = false;
this.Text = name;
this.modifId = a.id;
this.d = d;
InitializeComponent();
this.nomBox.Text = a.libelle;
}
public InputModifPeriodeForm(String name, Annee a, Periode p)
{
input = false;
this.Text = name;
this.modifId = p.id;
this.a = a;
InitializeComponent();
this.nomBox.Text = p.libelle;
}
/// <summary>
/// Évènement changement de sélection diplome
/// </summary>
private void anneeGridView_SelectionChanged(object sender, EventArgs e)
{
Annee a = getCurrentAnnee();
if (a != null)
{
periodeGridViewLoad();
}
}
public static List <UniteEnseignement> findByLibelle(String libelle)
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
MySqlDataReader reader = null;
List <UniteEnseignement> resultats = new List <UniteEnseignement>();
try
{
sql = "SELECT unite_enseignement.id as uniteEnsID, unite_enseignement.libelle as uniteEnsLibelle, "
+ "periode.id AS periodeID, periode.libelle AS periodeLibelle, "
+ "annee.id AS anneeId, annee.libelle AS anneeLibelle, "
+ "diplome.id AS diplomeID, diplome.libelle AS diplomeLibelle "
+ "FROM unite_enseignement "
+ "JOIN periode ON unite_enseignement.periode_id = periode.id "
+ "JOIN annee ON periode.annee_id = annee.id "
+ "JOIN diplome ON annee.diplome_id = diplome.id "
+ "WHERE unite_enseignement.libelle LIKE @libelle";
_cmd.CommandText = sql;
_cmd.Parameters.AddWithValue("@libelle", libelle);
reader = _cmd.ExecuteReader();
while (reader.Read())
{
UniteEnseignement tempUnite = populateUniteEnseignement(reader);
Diplome tempDiplome = DiplomeDAO.populateDiplome(reader);
Annee tempAnnee = AnneeDAO.populateAnnee(reader);
tempAnnee.diplome = tempDiplome;
Periode tempPeriode = PeriodeDAO.populatePeriode(reader);
tempPeriode.annee = tempAnnee;
tempUnite.periode = tempPeriode;
resultats.Add(tempUnite);
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
return(resultats);
}
/**
* Methodes pour aider aux tests
* **/
public static Annee creerAnnee(String libelle)
{
Annee annee = new Annee();
annee.libelle = libelle;
annee.diplome = DiplomeTest.creerDiplome(libelle);
Annee resultat = AnneeDAO.create(annee);
return(resultat);
}
public void TestFind()
{
// test du find simple
Annee resultat = creerAnnee("TEST_ANNEE_FIND");
Annee resultatFind = AnneeDAO.find(resultat.id);
Assert.AreEqual("TEST_ANNEE_FIND", resultatFind.libelle);
Assert.AreNotEqual(0, resultatFind.diplome.id);
}
public void TestCreationAnnee()
{
// test la création d'une annee et la recherche grace à son libelle
Annee resultat = creerAnnee("TEST_ANNEE");
Assert.AreNotEqual("", resultat.libelle);
Assert.AreEqual("TEST_ANNEE", resultat.libelle);
Assert.IsTrue(resultat.id > 0);
Assert.IsTrue(resultat.diplome.id > 0);
}
/// <summary>
/// Supression d'une annee
/// </summary>
private void supprimerAnnee(object sender, EventArgs e)
{
Annee a = getCurrentAnnee();
if (a != null)
{
AnneeDAO.delete(a);
anneeGridViewLoad();
}
}
/// <summary>
/// ajouter d'un periode
/// </summary>
private void ajouterPeriode(object sender, EventArgs e)
{
Annee a = getCurrentAnnee();
if (a != null)
{
var formPopup = new InputModifPeriodeForm("Ajouter Periode", a);
formPopup.ShowDialog(this);
periodeGridViewLoad();
}
}
public ActionResult Update(Annee annee)
{
var annn = dao.getById(annee.AnneeId);
annn.Libelle = annee.Libelle;
annn.DateDebut = annee.DateDebut;
annn.DateFin = annee.DateFin;
dao.update(annn);
return(RedirectToAction("Index"));
}
/// <summary>
/// Modifier d'un periode
/// </summary>
private void modifierPeriode(object sender, EventArgs e)
{
Periode p = getCurrentPeriode();
Annee a = getCurrentAnnee();
if (p != null && a != null)
{
var formPopup = new InputModifPeriodeForm("Modifier Periode", a, p);
formPopup.ShowDialog(this);
periodeGridViewLoad();
}
}
/// <summary>
/// Modifier d'un annee
/// </summary>
private void modifierAnnee(object sender, EventArgs e)
{
Annee a = getCurrentAnnee();
Diplome d = getCurrentDiplome();
if (a != null && d != null)
{
var formPopup = new InputModifAnneeForm("Modifier Annee", d, a);
formPopup.ShowDialog(this);
anneeGridViewLoad();
}
}
public static Annee populateAnnee(MySqlDataReader reader)
{
Annee resultat = new Annee();
if (reader.IsDBNull(reader.GetOrdinal("anneeId")) || reader.IsDBNull(reader.GetOrdinal("anneeLibelle")))
{
return(null);
}
resultat.id = Convert.ToInt64(reader["anneeId"]);
resultat.libelle = (String)reader["anneeLibelle"];
return(resultat);
}
/// <summary>
/// Année sélectionnée
/// </summary>
/// <returns>ue</returns>
private Annee getCurrentAnnee()
{
if (anneeGridView.SelectedCells.Count > 0)
{
int selectedRowIndex = anneeGridView.SelectedCells[0].RowIndex;
Annee a = ((ObjectView <Annee>)anneeGridView.Rows[selectedRowIndex].DataBoundItem).Object;
return(a);
}
else
{
return(null);
}
}
/// <summary>
/// Supression d'une annee
/// </summary>
private void supprimerAnnee(object sender, EventArgs e)
{
Annee a = getCurrentAnnee();
if (a != null)
{
AnneeDAO.delete(a);
anneeGridViewLoad();
}
else
{
DiplomeView.afficherPopup("Aucune année selectionnée");
}
}
public static List <Periode> findAll()
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
MySqlDataReader reader = null;
List <Periode> resultats = new List <Periode>();
try
{
sql = "SELECT periode.id as periodeID, periode.libelle as periodeLibelle, "
+ "annee.id as anneeId, annee.libelle as anneeLibelle ,"
+ "diplome.id as diplomeID, diplome.libelle as diplomeLibelle "
+ "FROM periode "
+ "join annee on periode.annee_id = annee.id "
+ "join diplome on annee.diplome_id = diplome.id";
_cmd.CommandText = sql;
reader = _cmd.ExecuteReader();
while (reader.Read())
{
Periode temp = populatePeriode(reader);
Diplome tempDiplome = DiplomeDAO.populateDiplome(reader);
Annee tempAnnee = AnneeDAO.populateAnnee(reader);
tempAnnee.diplome = tempDiplome;
temp.annee = tempAnnee;
resultats.Add(temp);
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
return(resultats);
}
/// <summary>
/// ajouter d'un periode
/// </summary>
private void ajouterPeriode(object sender, EventArgs e)
{
Annee a = getCurrentAnnee();
if (a != null)
{
var formPopup = new InputModifPeriodeForm("Ajouter Periode", a);
formPopup.ShowDialog(this);
periodeGridViewLoad();
}
else
{
DiplomeView.afficherPopup("Aucune année selectionnée");
}
}
public static Periode find(long id)
{
MySqlConnection _connection = ConnectionMySql.getInstance();
MySqlCommand _cmd = new MySqlCommand();
_cmd.Connection = _connection;
String sql = "";
MySqlDataReader reader = null;
Periode resultat = new Periode();
try
{
sql = "SELECT periode.id AS periodeID, periode.libelle AS periodeLibelle, "
+ "annee.id AS anneeId, annee.libelle AS anneeLibelle, "
+ "diplome.id AS diplomeID, diplome.libelle AS diplomeLibelle "
+ "FROM periode "
+ "JOIN annee ON periode.annee_id = annee.id "
+ "JOIN diplome ON annee.diplome_id = diplome.id "
+ "WHERE periode.id = @id";
_cmd.CommandText = sql;
_cmd.Parameters.AddWithValue("@id", id);
reader = _cmd.ExecuteReader();
while (reader.Read())
{
resultat = populatePeriode(reader);
Diplome tempDiplome = DiplomeDAO.populateDiplome(reader);
Annee tempAnnee = AnneeDAO.populateAnnee(reader);
tempAnnee.diplome = tempDiplome;
resultat.annee = tempAnnee;
}
reader.Close();
}
catch (Exception e)
{
Console.WriteLine("Exception : " + e);
}
_cmd.Dispose();
return(resultat);
}
/// <summary>
/// Modifier d'un periode
/// </summary>
private void modifierPeriode(object sender, EventArgs e)
{
Periode p = getCurrentPeriode();
Annee a = getCurrentAnnee();
if (p != null && a != null)
{
var formPopup = new InputModifPeriodeForm("Modifier Periode", a, p);
formPopup.ShowDialog(this);
periodeGridViewLoad();
}
else
{
DiplomeView.afficherPopup("Aucune période selectionnée");
}
}
