public static Commercial FindByAuthentication(string aUsername, string aPassword)
{
using (var db = new LearningCompanyContext())
{
return((from oCommcecial in db.Commerciaux
where oCommcecial.NomUtilisateur == aUsername &&
oCommcecial.MotDePasse == aPassword
select oCommcecial).FirstOrDefault());
}
}
public List <DemandeClient> GetListeDemandesClientsEnAttente()
{
using (var db = new LearningCompanyContext())
{
return((from oDemandeClient in db.DemandesClients
where oDemandeClient.Client.Commercial.CommercialID == this.CommercialID &&
oDemandeClient.DateTraitement == null
select oDemandeClient).ToList());
}
}