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 void remove(Dictionary <string, string> data)
{
Ticket_Historique ticket_historique = new Ticket_Historique();
ticket_historique.connect();
ticket_historique.delete(data);
this.connect();
this.delete(data);
this.disconnect();
}
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;
}