public static Object TConseiller_All()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from c in db.T_CONSEILLER
select c;
return q;
}
public static Object TConseiller_byId(int aId)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from c in db.T_CONSEILLER where c.ID_CONSEILLER == aId
select c;
return q;
}
public static Object TEmploi_All()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_EMPLOI
select e;
return q;
}
public static Object TConseiller_byPrenom(string aPrenom)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from c in db.T_CONSEILLER
where c.PRENOM_CONSEILLER == aPrenom
select c;
return q;
}
public static Object TEmploi_byIdPersonne(int aId)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_EMPLOI
where e.ID_PERSONNE == aId
select e;
return q;
}
public static Object TEmploi_byIdMetier(int aId)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_EMPLOI
where e.ID_METIER == aId
select e;
return q;
}
public static List<TConseiller> findAll()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from c in db.T_CONSEILLER
select c;
List<TConseiller> mesConseiller = new List<TConseiller>();
foreach (var c in q)
{
TConseiller mC = new TConseiller((int)c.ID_CONSEILLER);
mC.nom_conseiller = c.NOM_CONSEILLER;
mC.prenom_conseiller = c.PRENOM_CONSEILLER;
mesConseiller.Add(mC);
}
return mesConseiller;
}
public static List<TEtudiant> findAll()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_ETUDIANT
select e;
List<TEtudiant> mesEtudiants = new List<TEtudiant>();
foreach (var e in q)
{
TEtudiant mE = new TEtudiant((int)e.ID_ETUDIANT);
mE.id_personne = (int)e.ID_PERSONNE;
mE.n_carte = (int)e.N_CARTE;
}
return mesEtudiants;
}
public static List<TMetier> findAll()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from m in db.T_METIER
select m;
List<TMetier> mesMetiers = new List<TMetier>();
foreach (var m in q)
{
TMetier mM = new TMetier((int)m.ID_METIER);
mM.id_type_metier = (int)m.ID_TYPE_METIER;
mM.metier = m.METIER;
mM.typeMetier = TTypeMetier.findById((int)mM.id_type_metier)[0];
mesMetiers.Add(mM);
}
return mesMetiers;
}
public static List<TEmploi> findAll()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_EMPLOI
select e;
List<TEmploi> mesEmplois = new List<TEmploi>();
foreach (var e in q)
{
TEmploi mE = new TEmploi((int)e.ID_EMPLOI);
mE.id_metier = (int)e.ID_METIER;
mE.id_personne = (int)e.ID_PERSONNE;
mE.nom_emploi = e.NOM_EMPLOI;
mE.personnesLiees = TPersonne.findByIdPersonne((int)mE.id_personne);
mE.metierLiees = TMetier.findByIdMetier(mE.id_metier);
mesEmplois.Add(mE);
}
return mesEmplois;
}
public List<InfoPersonne> recherchePersonnes(InfoPersonne ip)
{
List<InfoPersonne> liste = new List<InfoPersonne>();
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
select p;
q = q.Where(p => p.NOM.Contains((ip.Nom != null) ? ip.Nom : ""));
q = q.Where(p => p.PRENOM.Contains((ip.Prenom != null) ? ip.Prenom : ""));
DateTime dt;
if (DateTime.TryParse(ip.DateNaissance, out dt))
{
q = q.Where(p => p.DATE_DE_NAISSANCE.Equals(dt));
}
q = q.Where(p => p.SEXE.Equals((ip.Sexe) ? '1' : '0'));
foreach (var p in q)
{
liste.Add(new InfoPersonne(TPersonne.findByIdPersonne((int)p.ID_PERSONNE)[0]));
}
return liste;
}
public static Object TMetier_All()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from m in db.T_METIER
select m;
return q;
}
public static List<TConseiller> findByNom(string aNom)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from c in db.T_CONSEILLER
where c.NOM_CONSEILLER == aNom
select c;
List<TConseiller> mesConseiller = new List<TConseiller>();
foreach (var c in q)
{
TConseiller mC = new TConseiller();
mC.id_conseiller = (int)c.ID_CONSEILLER;
mC.nom_conseiller = c.NOM_CONSEILLER;
mC.prenom_conseiller = c.PRENOM_CONSEILLER;
mesConseiller.Add(mC);
}
return mesConseiller;
}
public static Object TEtudiant_byIdPersonne(int aId)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_ETUDIANT
where e.ID_PERSONNE == aId
select e;
return q;
}
public static Object TPersonne_byPrenom(string aPrenom)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
where p.PRENOM == aPrenom
select p;
return q;
}
public static Object TEtudiant_byNoCarte(int aNoCarte)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_ETUDIANT
where e.N_CARTE == aNoCarte
select e;
return q;
}
public static Object TPersonne_byNom(bool aSexe)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
where p.SEXE == ((aSexe == false) ? '0' : '1')
select p;
return q;
}
public static Object TPersonne_byNom(DateTime aDate)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
where p.DATE_DE_NAISSANCE == aDate
select p;
return q;
}
public static Object TEtudiant_All()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_ETUDIANT
select e;
return q;
}
public static Object TEmploi_byNom(string aNom)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from e in db.T_EMPLOI
where e.NOM_EMPLOI == aNom
select e;
return q;
}
public static Object TPersonne_All()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
select p;
return q;
}
public static List<TPersonne> findAll()
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
select p;
List<TPersonne> mesPersonnes = new List<TPersonne>();
foreach (var p in q)
{
TPersonne mP = new TPersonne((int)p.ID_PERSONNE);
mP.id_conseiller = (int)p.ID_CONSEILLER;
mP.nom = p.NOM;
mP.prenom = p.PRENOM;
mP.date_de_naissance = (DateTime)p.DATE_DE_NAISSANCE;
mP.sexe = ((p.SEXE == '0') ? false : true);
mP.conseillerLie = TConseiller.findById((int)p.ID_CONSEILLER)[0];
mP.etudiantLies = TEtudiant.findByIdPersonne((int)mP.id_personne);
mesPersonnes.Add(mP);
}
return mesPersonnes;
}
public static Object TPersonne_byIdConseiller(int aId)
{
DataSQLDataContext db = new DataSQLDataContext();
var q = from p in db.T_PERSONNE
where p.ID_CONSEILLER == aId
select p;
return q;
}
