public Covid_Results()
{
db = new COVID_19_DBEntities();
reg = new RegionModel();
}
public APIModel API()
{
int casC = 0, casM = 0, casR = 0, casT = 0;
foreach (var reg in db.Regions.ToList())
{
RegionModel Region_ = new RegionModel();
Region_.UID = reg.UID;
Region_.Nom = reg.Nom;
foreach (var vil in db.Villes.Where(x => x.UID_Region == reg.UID).ToList())
{
VilleModel Ville_ = new VilleModel();
Ville_.UID = vil.UID;
Ville_.Nom = vil.Nom;
foreach (var e in db.Enumerations.Where(e => e.UID_V == vil.UID).ToList())
{
StatistiquesModel Statistique_ = new StatistiquesModel()
{
UID = e.UID,
Cas_Confirmer = (int)e.Cas_Confirmer,
Cas_Mort = (int)e.Cas_Mort,
Cas_Retablis = (int)e.Cas_Retablis,
Date_Ins = ConvertDate.ConverDate((DateTime)e.Date_Ins)
};
//verify if there is some date to show or show 0
if (e.Cas_Confirmer > 0)
casC += (int)e.Cas_Confirmer;
if (e.Cas_Retablis > 0)
casR += (int)e.Cas_Retablis;
if (e.Cas_Mort > 0)
casM += (int)e.Cas_Mort;
if (Statistique_.UID != null)
Ville_.Statistiques.Add(Statistique_);
}
// add villes with stat in region
Region_.Villes.Add(Ville_);
}
// return Region statis if exists
var RegStat = ReturnRegStat(Region_.UID);
if (RegStat == null)
{
RegionStatistique rgS = new RegionStatistique()
{
UID = GestionGlobal.GetUID("REGSTAT"),
Cas_Confirmer = casC,
Cas_Mort = casM,
Cas_Retablis = casR,
Date_Ins = DateTime.Now,
UID_R = Region_.UID
};
//db.RegionStatistiques.Add(rgS);
//db.Entry(rgS).State = System.Data.Entity.EntityState.Added;
//db.SaveChanges();
Region_.Statistiques = ReturnRegStat(Region_.UID);
}
else
{
RegStat = ReturnRegStat(Region_.UID);
Region_.Statistiques = RegStat;
}
Data.api.Add(Region_);
casC = casM = casR = casT = 0;
}
return Data;
}