public Probleme find_by_id(Dictionary <string, string> data)
{
Probleme probleme;
Dictionary <string, string> id = new Dictionary <string, string>();
this.categorie = new Categorie();
this.connect();
SqlDataReader result = this.select(data);
while (result.Read())
{
id["IdCategorie"] = "" + result.GetInt32(3);
this.categorie = this.categorie.find_by_id(id);
probleme = new Probleme(
result.GetInt32(0),
result.GetString(1),
result.GetString(2),
this.categorie
);
this.disconnect();
return(probleme);
}
return(null);
}
public List <Solution> find_all()
{
List <Solution> solutions = new List <Solution>();
Dictionary <string, string> id = new Dictionary <string, string>();
this.probleme = new Probleme();
this.connect();
SqlDataReader result = this.select();
while (result.Read())
{
id["IdProbleme"] = "" + result.GetInt32(2);
this.probleme = this.probleme.find_by_id(id);
solutions.Add(new Solution(
result.GetInt32(0),
result.GetString(1),
this.probleme
));
}
this.disconnect();
return(solutions);
}
public Solution find_by_id(Dictionary <string, string> data)
{
Solution solution;
Dictionary <string, string> id = new Dictionary <string, string>();
Dictionary <string, string> id2 = new Dictionary <string, string>();
this.probleme = new Probleme();
this.connect();
id2[IdSolutionColmn] = "" + this.IdSolution;
SqlDataReader result = this.select(id2);
while (result.Read())
{
id["IdProbleme"] = "" + result.GetInt32(2);
this.probleme = this.probleme.find_by_id(id);
solution = new Solution(
result.GetInt32(0),
result.GetString(1),
this.probleme
);
this.disconnect();
return(solution);
}
return(null);
}
public List <StatByProbleme> find_all(String dat)
{
Probleme p = new Probleme();
Dictionary <string, string> id2 = new Dictionary <string, string>();
Dictionary <string, string> id3 = new Dictionary <string, string>();
List <StatByProbleme> stat = new List <StatByProbleme>();
this.connect();
SqlDataReader result = this.select(dat);
while (result.Read())
{
id2["IdProbleme"] = "" + result.GetInt32(0);
p = p.find_by_id(id2);
stat.Add(new StatByProbleme(
p,
result.GetInt32(1)
));
}
return(stat);
}
// Constructeur 2:
public Solution(int idSolution, string descriptionSolution, Probleme probleme)
{
this.table = "Solution";
this.IdSolution = idSolution;
this.Description = descriptionSolution;
this.probleme = probleme;
}
public void save(Probleme probleme)
{
this.connect();
this.table = "[dbo].[Ticket_Probleme]";
Dictionary <string, string> data = new Dictionary <string, string>();
data[IdTicketColmn] = "" + this.IdTicket;
data["[IdProbleme]"] = "" + probleme.IdProbleme;
data["[date_p]"] = "'" + this.DateFermeture + "'";
this.insert(data);
this.disconnect();
}
public void save(Probleme probleme, Solution solution)
{
this.connect();
this.table = "[dbo].[Ticket_Proleme_Solution]";
Dictionary <string, string> data = new Dictionary <string, string>();
data[IdTicketColmn] = "" + this.IdTicket;
data["[IdProbleme]"] = "" + probleme.IdProbleme;
data["[IdSolution]"] = "" + solution.IdSolution;
this.insert(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;
}
public List <Solution> find_solution(SqlDataReader sql)
{
List <Solution> solutions = new List <Solution>();
Dictionary <string, string> id = new Dictionary <string, string>();
Probleme p = new Probleme();
this.connect();
SqlDataReader result = sql;
while (result.Read())
{
id["IdProbleme"] = "" + result.GetInt32(2);
p = p.find_by_id(id);
solutions.Add(new Solution(
result.GetInt32(0),
result.GetString(1),
p
));
}
this.disconnect();
return(solutions);
}
public StatByProbleme(Probleme p, int nb)
{
this.probleme = p;
this.Nbp = nb;
}