public new List <Superviseur> find_all() { List <Superviseur> superviseurs = new List <Superviseur>(); Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Utilisateur utilisateur = new Utilisateur(); this.direction = new Direction(); this.connect(); SqlDataReader result = this.select(); 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); superviseurs.Add(new Superviseur( utilisateur, this.direction )); } this.disconnect(); return(superviseurs); }
public new List <TechnicienDre> find_all() { List <TechnicienDre> TechnicienDres = new List <TechnicienDre>(); Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Utilisateur utilisateur = new Utilisateur(); this.dre = new DRE(); this.connect(); SqlDataReader result = this.select(); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(0); utilisateur = utilisateur.find_by_id(id2); id["[NumeroDRE]"] = "" + result.GetInt32(1); this.dre = this.dre.find_by_id(id); TechnicienDres.Add(new TechnicienDre( utilisateur, this.dre )); } this.disconnect(); return(TechnicienDres); }
public new Superviseur find_by_id(Dictionary <string, string> data) { Superviseur superviseur; Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Utilisateur utilisateur = new Utilisateur(); this.direction = new Direction(); this.connect(); SqlDataReader result = this.select(data); while (result.Read()) { id2[IdUserColmn] = "" + result.GetInt32(0); utilisateur = utilisateur.find_by_id(id2); id[IdDirectionColmn] = "" + result.GetInt32(1); this.direction = this.direction.find_by_id(id); superviseur = new Superviseur( utilisateur, this.direction ); this.disconnect(); return(superviseur); } return(null); }
public List <Ticket_Historique> find_all() { List <Ticket_Historique> ticket_historiques = new List <Ticket_Historique>(); Utilisateur technicienHD = new Utilisateur(); Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); this.Ticket = new Ticket(); this.connect(); SqlDataReader result = this.select(); while (result.Read()) { id["[IdUser]"] = "" + result.GetInt32(0); technicienHD = technicienHD.find_by_id(id); id2["[IdTicket]"] = "" + result.GetInt32(1); this.Ticket = this.Ticket.find_by_id(id2); ticket_historiques.Add(new Ticket_Historique( technicienHD, this.Ticket, result.GetString(2), result.GetString(3) )); } this.disconnect(); return(ticket_historiques); }
public new TechnicienDre find_by_id(Dictionary <string, string> data) { TechnicienDre TechnicienDre; Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Utilisateur utilisateur = new Utilisateur(); this.dre = new DRE(); this.connect(); SqlDataReader result = this.select(data); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(0); utilisateur = utilisateur.find_by_id(id2); id["[NumeroDRE]"] = "" + result.GetInt32(1); this.dre = this.dre.find_by_id(id); TechnicienDre = new TechnicienDre( utilisateur, this.dre ); this.disconnect(); return(TechnicienDre); } return(null); }
public new List <EmployeAgence> find_all() { List <EmployeAgence> employeAgences = new List <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(); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(0); utilisateur = utilisateur.find_by_id(id2); id["NumeroAgence"] = "" + result.GetInt32(1); this.agence = this.agence.find_by_id(id); employeAgences.Add(new EmployeAgence( utilisateur, this.agence )); } this.disconnect(); return(employeAgences); }
public Ticket_Historique find_by_id(Dictionary <string, string> data) { Ticket_Historique ticket_historique = new Ticket_Historique(); Utilisateur technicienHD = new Utilisateur(); Dictionary <string, string> id = new Dictionary <string, string>(); Dictionary <string, string> id2 = new Dictionary <string, string>(); this.Ticket = new Ticket(); this.connect(); SqlDataReader result = this.select(); while (result.Read()) { id["[IdUser]"] = "" + result.GetInt32(0); technicienHD = technicienHD.find_by_id(id); id2["[IdTicket]"] = "" + result.GetInt32(1); this.Ticket = this.Ticket.find_by_id(id2); ticket_historique = new Ticket_Historique( technicienHD, this.Ticket, result.GetString(2), result.GetString(3) ); this.disconnect(); return(ticket_historique); } return(null); }
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 IEnumerable <Ticket> GetAllTickets() { var tickets = new List <Ticket>(); using (this.connexion = new SqlConnection(_connString)) { this.connexion.Open(); using (var command = new SqlCommand(@"SELECT [IdTicket],[DateOuverture],[DateFermeture],[Objet],[Description],[Priorite],[IdCategorie],[IdUser],[EtatTicket] FROM [dbo].[Ticket] ORDER BY [IdTicket] DESC", this.connexion)) { command.Notification = null; var dependency = new SqlDependency(command); dependency.OnChange += new OnChangeEventHandler(dependency_OnChange); if (this.connexion.State == System.Data.ConnectionState.Closed) { this.connexion.Open(); } var reader = command.ExecuteReader(); while (reader.Read()) { Utilisateur utilisateur = new Utilisateur(); Categorie categorie = new Categorie(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Dictionary <string, string> id3 = new Dictionary <string, string>(); id2["IdUser"] = "" + (int)reader["IdUser"]; utilisateur = utilisateur.find_by_id(id2); id3["[IdCategorie]"] = "" + (int)reader["IdCategorie"]; categorie = categorie.find_by_id(id3); tickets.Add(new Ticket((int)reader["IdTicket"], Convert.ToDateTime(reader["DateOuverture"]), Convert.ToDateTime(reader["DateFermeture"]), (string)reader["Objet"], (string)reader["Description"], (string)reader["Priorite"], utilisateur, categorie, (string)reader["EtatTicket"])); // tickets.Add(item: new Ticket { IdTicket = (int)reader["IdTicket"],DateOuverture = Convert.ToDateTime(reader["DateOuverture"]),DateFermeture = Convert.ToDateTime(reader["DateFermeture"]),Objet = (string)reader["Objet"],Description = (string)reader["Description"] }); } this.connexion.Close(); this.connexion.Dispose(); SqlConnection.ClearPool(this.connexion); } } return(tickets); }
public IEnumerable <Message> GetAllMessages() { var messages = new List <Message>(); using (this.connexion = new SqlConnection(_connString)) { this.connexion.Open(); using (var command = new SqlCommand(@"SELECT [IdMessage],[ContentMessage],[EtatMessage],[DateMessage],[IdUser],[IdTicket] FROM [dbo].[Message] ORDER BY [IdMessage] DESC", this.connexion)) { command.Notification = null; var dependency = new SqlDependency(command); dependency.OnChange += new OnChangeEventHandler(dependency_OnChange); if (this.connexion.State == System.Data.ConnectionState.Closed) { this.connexion.Open(); } var reader = command.ExecuteReader(); while (reader.Read()) { Utilisateur utilisateur = new Utilisateur(); Ticket ticket = new Ticket(); Dictionary <string, string> _id2 = new Dictionary <string, string>(); Dictionary <string, string> _id3 = new Dictionary <string, string>(); _id2["IdUser"] = "" + (int)reader["IdUser"]; utilisateur = utilisateur.find_by_id(_id2); _id3["[IdTicket]"] = "" + (int)reader["IdTicket"]; ticket = ticket.find_by_id(_id3); messages.Add(new Message((int)reader["IdMessage"], (string)reader["ContentMessage"], (string)reader["EtatMessage"], Convert.ToDateTime(reader["DateMessage"]), utilisateur, ticket)); } this.connexion.Close(); this.connexion.Dispose(); SqlConnection.ClearPool(this.connexion); } } return(messages); }
public Ticket find_by_id(Dictionary <string, string> data) { Utilisateur utilisateur = new Utilisateur(); this.Categorie = new Categorie(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Dictionary <string, string> id3 = new Dictionary <string, string>(); Ticket ticket; this.connect(); SqlDataReader result = this.select(data); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(7); utilisateur = utilisateur.find_by_id(id2); id3["[IdCategorie]"] = "" + result.GetInt32(6); this.Categorie = this.Categorie.find_by_id(id3); ticket = new Ticket( result.GetInt32(0), result.GetDateTime(1), result.GetDateTime(2), result.GetString(3), result.GetString(4), result.GetString(5), utilisateur, this.Categorie, result.GetString(8) ); this.disconnect(); return(ticket); } return(null); }
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 List <Ticket> find_all() { Utilisateur utilisateur = new Utilisateur(); this.Categorie = new Categorie(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Dictionary <string, string> id3 = new Dictionary <string, string>(); List <Ticket> tickets = new List <Ticket>(); this.connect(); SqlDataReader result = this.select(); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(7); utilisateur = utilisateur.find_by_id(id2); id3["[IdCategorie]"] = "" + result.GetInt32(6); this.Categorie = this.Categorie.find_by_id(id3); tickets.Add(new Ticket( result.GetInt32(0), result.GetDateTime(1), result.GetDateTime(2), result.GetString(3), result.GetString(4), result.GetString(5), utilisateur, this.Categorie, result.GetString(8) )); } this.disconnect(); return(tickets); }
public List <StatByTechnicien> find_all(String dat) { Utilisateur tech = new Utilisateur(); Dictionary <string, string> id2 = new Dictionary <string, string>(); Dictionary <string, string> id3 = new Dictionary <string, string>(); List <StatByTechnicien> stat = new List <StatByTechnicien>(); this.connect(); SqlDataReader result = this.select(dat); while (result.Read()) { id2["IdUser"] = "" + result.GetInt32(0); tech = tech.find_by_id(id2); stat.Add(new StatByTechnicien( tech, result.GetInt32(1) )); } return(stat); }