public Vaccin GetVaccin(int idConsultation)
{
Vaccin vac = new Vaccin();
using (var cp = new Clinic2Entities())
{
var obj = cp.Vaccins
.Where(vaccin => vaccin.ID_Consultation == idConsultation)
.Select(st => new {
Description = st.description,
Date = st.date
});
vac.description = obj.Select(x => x.Description).DefaultIfEmpty("").First();
vac.date = obj.Select(x => x.Date).DefaultIfEmpty().First();
}
return(vac);
}
public Ordonnance GetOrdonnance(int idConsultation)
{
Ordonnance ord = new Ordonnance();
using (var cp = new Clinic2Entities())
{
var obj = cp.Ordonnances
.Where(ordonnance => ordonnance.ID_Consultation == idConsultation)
.Select(st => new {
Prescription = st.prescription,
Medicament = st.medicament
});
ord.prescription = obj.Select(x => x.Prescription).DefaultIfEmpty("").First();
ord.medicament = obj.Select(x => x.Medicament).DefaultIfEmpty("").First();
}
return(ord);
}
public Adresse GetAdress(int idStaff)
{
Adresse adr = new Adresse();
DateTime maxDate = new DateTime(9999, 12, 31);
using (var cp = new Clinic2Entities())
{
var obj = cp.Adresses
.Where(adresse => adresse.ID_Staff == idStaff && adresse.dateFin == maxDate)
.Select(st => new {
Pays = st.pays,
Ville = st.ville,
Prefecture = st.prefecture,
Village = st.village
});
adr.pays = obj.Select(x => x.Pays).DefaultIfEmpty("").First();
adr.ville = obj.Select(x => x.Ville).DefaultIfEmpty("").First();
adr.prefecture = obj.Select(x => x.Prefecture).DefaultIfEmpty("").First();
adr.village = obj.Select(x => x.Village).DefaultIfEmpty("").First();
}
return(adr);
}
