/// <summary> /// Retrieve all Famille /// </summary> /// <returns>List of Famille</returns> public static List<Famille> GetAll() { List<Famille> listFamille = new List<Famille>(); using (SqlConnection db = DbConnexion.connect()) { string sql = "SELECT NumFamille, LibelleFamille FROM Famille"; using (SqlCommand req = new SqlCommand(sql, db)) { SqlDataReader row = req.ExecuteReader(); while (row.Read()) { Famille famille = new Famille(); famille.Num = int.Parse(row.GetValue(0).ToString()); famille.Libelle = row.GetValue(1).ToString(); listFamille.Add(famille); } } } return listFamille; }
/// <summary> /// Retrieve all Categories of the Famille /// </summary> /// <param name="famille"></param> /// <returns>List of Categorie</returns> public static List<Categorie> GetByFamille(Famille famille) { List<Categorie> listTickets = new List<Categorie>(); using (SqlConnection db = DbConnexion.connect()) { string sql = "SELECT NumCategorie, LibelleCategorie, NumFamille FROM Categorie c WHERE c.NumFamille = @NumFamille"; using (SqlCommand req = new SqlCommand(sql, db)) { req.Parameters.Add(new SqlParameter("NumFamille", famille.Num)); SqlDataReader row = req.ExecuteReader(); while (row.Read()) { Categorie categorie = new Categorie(); categorie.Num = int.Parse(row.GetValue(0).ToString()); categorie.Libelle = row.GetValue(1).ToString(); categorie.Famille = famille; listTickets.Add(categorie); } } } return listTickets; }
/// <summary> /// Retrieve the Famille by its num /// </summary> /// <param name="numFamille"></param> /// <returns>Famille</returns> public static Famille Get(int numFamille) { Famille famille = new Famille(); using (SqlConnection db = DbConnexion.connect()) { string sql = "SELECT NumFamille, LibelleFamille FROM Famille f WHERE f.numFamille = @NumFamille"; using (SqlCommand req = new SqlCommand(sql, db)) { req.Parameters.Add(new SqlParameter("NumFamille", numFamille)); SqlDataReader row = req.ExecuteReader(); if (row.Read()) { famille.Num = int.Parse(row.GetValue(0).ToString()); famille.Libelle = row.GetValue(1).ToString(); } } } return famille; }
public void Fill() { // Initialize the Family's List List<Famille> listFamilles = FamilleDAO.GetAll(); Famille blankRow = new Famille(); blankRow.Libelle = ""; listFamilles.Insert(0, blankRow); // Family ComboBox Data Source _view.Familles = listFamilles; // Articles Default Data Source _view.Articles = source; source.ResetBindings(false); }