public Agence(int idAgence, string wilaya, DRE dre, string adresseAgence, string nomAgence)
{
this.table = "Agence";
this.IdAgence = idAgence;
this.WilayaAgence = wilaya;
this.Dre = dre;
this.AdresseAgence = adresseAgence;
this.NomAgence = nomAgence;
}
// Constructeur 3 :
public TechnicienDre(Utilisateur utilisateur, DRE d)
{
this.table = "TechnicienDre";
this.IdUser = utilisateur.IdUser;
this.Login = utilisateur.Login;
this.Password = utilisateur.Password;
this.EtatUser = utilisateur.EtatUser;
this.Nom = utilisateur.Nom;
this.Prenom = utilisateur.Prenom;
this.Email = utilisateur.Email;
this.Phone = utilisateur.Phone;
this.EtatUser = utilisateur.EtatUser;
this.dre = d;
}
public DRE find_by_id(Dictionary <string, string> data)
{
DRE dre1;
this.table = "DRE";
this.connect();
SqlDataReader result = this.select(data);
while (result.Read())
{
dre1 = new DRE(
result.GetInt32(0),
result.GetString(1),
result.GetString(2),
result.GetString(3)
);
this.disconnect();
return(dre1);
}
return(null);
}
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;
}