public async Task <ContaClient> getAllCas()
{
var s = appliactionDbContext.contaminations.Count();
ContaClient ct = new ContaClient {
nom = "Nombre De Cas Dans Kenitra",
nombre = s
};
return(ct);
}
public async Task <ContaClient> GetEnfantCas()
{
int i = 0;
var ff = from s in appliactionDbContext.Clients
join co in appliactionDbContext.contaminations
on s.codeClient equals co.codeClient
select s.age;
foreach (var item in ff)
{
if (Convert.ToInt16(item) >= 1 && Convert.ToInt16(item) <= 18)
{
i++;
}
}
ContaClient c = new ContaClient {
nom = "Enfants",
nombre = i
};
return(c);
}
public async Task <ContaClient> GetFemmeCas()
{
int i = 0;
var ff = from s in appliactionDbContext.Clients
join co in appliactionDbContext.contaminations
on s.codeClient equals co.codeClient
where s.sexeClient.Equals("Femme")
select new ContaClient {
nom = "Femme",
nombre = co.codeContamination.Count()
};
foreach (var item in ff)
{
i++;
}
ContaClient c = new ContaClient {
nom = "Femme",
nombre = i
};
return(c);
}
