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;
}
public Categorie find_by_id(Dictionary <string, string> data)
{
Categorie _categorie;
Dictionary <string, string> id = new Dictionary <string, string>();
Dictionary <string, string> id2 = new Dictionary <string, string>();
this.connect();
SqlDataReader result = this.select(data);
while (result.Read())
{
this.ParentCategorie = new Categorie();
this.direction = new Direction();
if (result.GetInt32(2) != 0)
{
id["IdCategorie"] = "" + result.GetInt32(2);
this.ParentCategorie = this.ParentCategorie.find_by_id(id);
}
id2["IdDirection"] = "" + result.GetInt32(4);
this.direction = this.direction.find_by_id(id2);
_categorie = new Categorie(
result.GetInt32(0),
result.GetString(1),
this.ParentCategorie,
result.GetString(3),
this.direction
);
this.disconnect();
return(_categorie);
}
return(null);
}
public List <Ticket> find_ticket(SqlDataReader sql)
{
Utilisateur utilisateur = new Utilisateur();
Categorie c = 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 = sql;
while (result.Read())
{
id2["IdUser"] = "" + result.GetInt32(7);
utilisateur = utilisateur.find_by_id(id2);
id3["[IdCategorie]"] = "" + result.GetInt32(6);
c = c.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,
c,
result.GetString(8)
));
}
this.disconnect();
return(tickets);
}
// Constructeur 3:
public Probleme(int idProblme, string objetProbleme, string descriptionProbleme, Categorie categorie)
{
this.table = "Probleme";
this.IdProbleme = idProblme;
this.ObjetProbleme = objetProbleme;
this.DescreptionProbleme = descriptionProbleme;
this.categorie = categorie;
}
public Ticket(int idTicket, DateTime dateOuverture, DateTime dateFermeture, String objet, String description, String priorite, Utilisateur expediteur, Categorie categorie, string etatTicket)
{
this.table = "[dbo].[Ticket]";
this.IdTicket = idTicket;
this.DateOuverture = dateOuverture;
this.DateFermeture = dateFermeture;
this.Objet = objet;
this.Description = description;
this.Priorite = priorite;
this.Expediteur = expediteur;
this.Categorie = categorie;
this.EtatTicket = etatTicket;
}