public new TechnicienHelpDesk find_by_id(Dictionary <string, string> data) { TechnicienHelpDesk tech; Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Dictionary <string, string> id3 = new Dictionary <string, string>(); Utilisateur utilisateur = new Utilisateur(); this.direction = new Direction(); this.categorie = new Categorie(); this.connect(); SqlDataReader result = this.select(data); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(0); utilisateur = utilisateur.find_by_id(id2); id["IdDirection"] = "" + result.GetInt32(1); this.direction = this.direction.find_by_id(id); id3["[IdCategorie]"] = "" + result.GetInt32(3); this.categorie = this.categorie.find_by_id(id3); tech = new TechnicienHelpDesk( utilisateur, this.direction, this.categorie, result.GetString(2)); this.disconnect(); return(tech); } 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; }