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