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);
}
