public new EmployeAgence find_by_id(Dictionary <string, string> data)
        {
            EmployeAgence employeAgence;
            Dictionary <string, string> id  = new Dictionary <string, string>();
            Dictionary <string, string> id2 = new Dictionary <string, string>();

            Utilisateur utilisateur = new Utilisateur();

            this.agence = new Agence();


            this.connect();
            SqlDataReader result = this.select(data);

            while (result.Read())
            {
                id2[IdUserColmn] = "" + result.GetInt32(0);
                utilisateur      = utilisateur.find_by_id(id2);

                id[NumeroAgenceColmn] = "" + result.GetInt32(1);
                this.agence           = this.agence.find_by_id(id);

                employeAgence = new EmployeAgence(
                    utilisateur,
                    this.agence
                    );
                this.disconnect();
                return(employeAgence);
            }
            return(null);
        }
 public allobjet()
 {
     agence           = new Agence();
     dre              = new DRE();
     categorie        = new Categorie();
     ticket           = new Ticket();
     probleme         = new Probleme();
     user             = new Utilisateur();
     techhelp         = new TechnicienHelpDesk();
     techdre          = new TechnicienDre();
     direction        = new Direction();
     employer         = new EmployeAgence();
     stat             = new Statistic();
     ticket_his       = new Ticket_Historique();
     solution         = new Solution();
     super            = new Superviseur();
     StatByTicket     = new StatByTicket();
     StatByTechnicien = new StatByTechnicien();
     StatByProbleme   = new StatByProbleme();
     day              = null;
     month            = null;
     year             = null;
 }