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); }