public cls_Comptable(long pID, string pNom, DateTime pDatedeNaissance, cls_Agence pAgence) : base(pID) { c_ID = pID; c_Nom = pNom; c_DatedeNaissance = pDatedeNaissance; c_Agence = pAgence; }
private void ChargementAgenceBase() { string Query = "SELECT a.ID, a.Nom, a.ID_Commune, a.ID_Directeur FROM agence a, commune com, comptable cmp WHERE a.ID_Commune = com.ID AND a.ID_Directeur = cmp.ID"; var cmdAgence = new MySqlCommand(Query, c_cnn); var reader = cmdAgence.ExecuteReader(); Dictionary <long, cls_Agence> l_ListeAgence = new Dictionary <long, cls_Agence>(); Dictionary <long, cls_Commune> l_ListeCommune = cls_Commune.getListeCommune; cls_Agence l_Agence; while (reader.Read()) { l_Agence = new cls_Agence(reader.GetInt64(0), reader.GetString(1), l_ListeCommune[reader.GetInt64(2)]); l_ListeAgence.Add(reader.GetInt64(0), l_Agence); } cls_Agence.setListeAgence(l_ListeAgence); reader.Close(); }
public void setAgence(cls_Agence pAgence) { c_Agence = pAgence; }