public AverageElementFunctionnementDTO GetAverage()
{
var nbBornes = _serviceNbBorne.GetItemsAsync("select COUNT(1) as NbreBorne " +
"from c " +
"where c.Document = \"borne\"").GetAwaiter().GetResult().ToList();
var deltaYear = 5;
var limitDate = "\"" + DateTime.Now.AddYears(-deltaYear).ToString("yyyy-mm-dd") + "\"";
var changementElement = _serviceChangementElements.GetItemsAsync("select c.Details as Element, COUNT(1) as NbreChangement " +
"from c " +
"join(select * from c where c.Document = \"incident\") d " +
"join(select * from d where d.OperationRecharge.DateHeureFin >= " + limitDate + " ) e " +
"group by c.Details").GetAwaiter().GetResult().ToList();
var averageElement = new AverageElementFunctionnement
{
NbreBorne = nbBornes[0].NbreBorne,
ChangementElements = changementElement
};
var response = _mapper.Map <AverageElementFunctionnementDTO>(averageElement);
return(response);
}
private List <StatElementDefectueux> RequestLaunch()
{
var deltaYear = 5;
var limitDate = "\"" + DateTime.Now.AddYears(-deltaYear).ToString("yyyy-mm-dd") + "\"";
var statsDefectivesElements = _serviceTopFive.GetItemsAsync("select c.Details as Element, COUNT(1) as NbreIncidents " +
"from c " +
"join(select * from c where c.Document = \"incident\") d " +
"join(select * from d where d.OperationRecharge.DateHeureFin >= " + limitDate + " ) e " +
"group by c.Details").GetAwaiter().GetResult().ToList();
return(statsDefectivesElements);
}
