public HttpResponseMessage StatistiqueFiltered(StatistiquePyramideParamModel statistiquePyramideParamModel) { //Dictionary<string, string> DataTableParameters = new Dictionary<string, string>(); //DataTableParameters = Request.GetQueryNameValuePairs().ToDictionary(kv => kv.Key, kv => kv.Value, StringComparer.OrdinalIgnoreCase); DateTime ParameterDateDebut = statistiquePyramideParamModel.DateDebut; DateTime ParameterDateFin = statistiquePyramideParamModel.DateFin; DateTime DateDebut = ParameterDateDebut; DateTime DateFin = ParameterDateFin.AddDays(+1); var queryNonConformite = from n in db.NonConformites where n.Date >= DateDebut && n.Date <= DateFin && n.ServiceType.Nom.Equals("Qualité R/D") select new NonConformiteStatistique { Id = n.Id, DateEvnmt = n.Date, SiteId = n.SiteId, Site = n.Site.Trigramme, NonConformiteOrigineId = n.NonConformiteOrigineId, NonConformiteDomaineId = n.NonConformiteDomaineId, NonConformiteGraviteId = n.NonConformiteGraviteId, ActionQSEs = n.ActionQSEs, Code = n.Code }; var AllNonConformite = queryNonConformite.ToList(); foreach (var NC in AllNonConformite) { NC.TimeStamp = (Int32)(NC.DateEvnmt.Subtract(new DateTime(1970, 1, 1))).TotalSeconds; } Dictionary <string, Object> Response = new Dictionary <string, Object>(); Response.Add("AllNonConformite", AllNonConformite); return(Request.CreateResponse(HttpStatusCode.OK, AllNonConformite)); }
public HttpResponseMessage StatistiqueFiltered(StatistiquePyramideParamModel statistiquePyramideParamModel) { //Dictionary<string, string> DataTableParameters = new Dictionary<string, string>(); //DataTableParameters = Request.GetQueryNameValuePairs().ToDictionary(kv => kv.Key, kv => kv.Value, StringComparer.OrdinalIgnoreCase); DateTime ParameterDateDebut = statistiquePyramideParamModel.DateDebut; DateTime ParameterDateFin = statistiquePyramideParamModel.DateFin; DateTime DateDebut = ParameterDateDebut; DateTime DateFin = ParameterDateFin.AddDays(+1); var queryFicheSecurite = from f in db.FicheSecurites where f.DateEvenement >= DateDebut && f.DateEvenement <= DateFin select new FicheSecuriteStatistique { Id = f.FicheSecuriteID, DateEvnmt = f.DateEvenement, SiteId = f.SiteId, Site = f.Site.Trigramme, ZoneId = f.ZoneId, ServiceId = f.ServiceId, CauseQSEs = f.CauseQSEs, FicheSecuriteType = f.FicheSecuriteType.Nom, Responsable = f.Responsable, FicheSecurtiteTypeID = f.FicheSecuriteTypeId, WorkFlowASEValidee = f.WorkFlowASEValidee, WorkFlowFicheSecuriteCloturee = f.WorkFlowFicheSecuriteCloturee, WorkFlowCloturee = f.WorkFlowCloturee }; var AllFicheSecurite = queryFicheSecurite.ToList(); foreach (var FS in AllFicheSecurite) { FS.TimeStamp = (Int32)(FS.DateEvnmt.Subtract(new DateTime(1970, 1, 1))).TotalSeconds; } Dictionary <string, Object> Response = new Dictionary <string, Object>(); Response.Add("AllFicheSecurite", AllFicheSecurite); return(Request.CreateResponse(HttpStatusCode.OK, AllFicheSecurite)); }
/// <summary> /// Filtre les fiches sécurités en fonction des paramètres. /// </summary> /// <param name="statistiquePyramideParamModel">Paramètre de filtre.</param> /// <returns>Reponse http.</returns> public HttpResponseMessage StatistiqueFiltered(StatistiquePyramideParamModel statistiquePyramideParamModel) { try { DateTime dateDebut = statistiquePyramideParamModel.DateDebut; DateTime dateFin = statistiquePyramideParamModel.DateFin.AddDays(1); var queryFicheSecurite = from f in db.FicheSecurites where f.DateEvenement >= dateDebut && f.DateEvenement <= dateFin select new FicheSecuriteStatistique { Id = f.FicheSecuriteID, DateEvnmt = f.DateEvenement, //TimeStamp = (int)f.DateEvenement.Subtract(new DateTime(1970, 1, 1)).TotalSeconds, SiteId = f.SiteId, Site = f.Site.Trigramme, ZoneId = f.ZoneId, CauseQSEs = f.CauseQSEs, FicheSecuriteType = f.FicheSecuriteType.Nom, Responsable = f.Responsable, FicheSecurtiteTypeID = f.FicheSecuriteTypeId, WorkFlowASEValidee = f.WorkFlowASEValidee, WorkFlowFicheSecuriteCloturee = f.WorkFlowFicheSecuriteCloturee, WorkFlowCloturee = f.WorkFlowCloturee, ServiceId = f.ServiceId, Service = f.Service.ServiceType.Nom, // Service Danger = f.Danger.Nom, // Danger DangerId = f.Danger.DangerID, // Danger CorpsHumainZoneId = f.CorpsHumainZoneId, // Lésions CorpsHumainZoneCode = f.CorpsHumainZone.Code, // Lésions CorpsHumainZone = f.CorpsHumainZone.Nom, // Lésions }; var allFicheSecurite = queryFicheSecurite.ToList(); var groupDangers = GetDangers(allFicheSecurite); var groupServices = GetServices(allFicheSecurite); var groupCorpsHumainZones = GetCorpsHumainZones(allFicheSecurite); Dictionary <string, object> response = new Dictionary <string, object> { { "AllFicheSecurite", allFicheSecurite }, { "GroupDangers", groupDangers }, { "GroupServices", groupServices }, { "GroupCorpsHumainZones", groupCorpsHumainZones } }; return(Request.CreateResponse(HttpStatusCode.OK, response)); } catch (Exception ex) { Console.WriteLine(ex); throw; } }
public HttpResponseMessage DialogueSecuriteStatistiqueFiltered(StatistiquePyramideParamModel statistiquePyramideParamModel) { //Dictionary<string, string> DataTableParameters = new Dictionary<string, string>(); //DataTableParameters = Request.GetQueryNameValuePairs().ToDictionary(kv => kv.Key, kv => kv.Value, StringComparer.OrdinalIgnoreCase); DateTime ParameterDateDebut = statistiquePyramideParamModel.DateDebut; DateTime ParameterDateFin = statistiquePyramideParamModel.DateFin; DateTime DateDebut = ParameterDateDebut; DateTime DateFin = ParameterDateFin.AddDays(+1); var queryDialogueSecurite = from d in db.DialogueSecurites where d.Date >= DateDebut && d.Date <= DateFin select new DialogueSecuriteStatistique { Id = d.Id, Date = d.Date, SiteId = d.SiteId, Site = d.Site.Trigramme, ZoneId = d.ZoneId, Dialogueur1Id = d.Dialogueur1Id, Dialogueur2Id = d.Dialogueur2Id, Dialogueur3Id = d.Dialogueur3Id, Entretenu1Id = d.Entretenu1Id, Entretenu2Id = d.Entretenu2Id, Entretenu3Id = d.Entretenu3Id, Dialogueur1 = d.Dialogueur1, Dialogueur2 = d.Dialogueur2, Dialogueur3 = d.Dialogueur3, Entretenu1 = d.Entretenu1, Entretenu2 = d.Entretenu2, Entretenu3 = d.Entretenu3 }; var AllDialogueSecurite = queryDialogueSecurite.ToList(); foreach (var DS in AllDialogueSecurite) { DS.TimeStamp = (Int32)(DS.Date.Subtract(new DateTime(1970, 1, 1))).TotalSeconds; } Dictionary <string, Object> Response = new Dictionary <string, Object>(); Response.Add("AllDialogueSecurite", AllDialogueSecurite); return(Request.CreateResponse(HttpStatusCode.OK, AllDialogueSecurite)); }
/// <summary> /// Filtre des dialogues sécurités en fonction des paramètres. /// </summary> /// <param name="statistiquePyramideParamModel">Paramètres de filtre.</param> /// <returns>Reponse http.</returns> public HttpResponseMessage DialogueSecuriteFiltered(StatistiquePyramideParamModel statistiquePyramideParamModel) { DateTime dateDebut = statistiquePyramideParamModel.DateDebut; DateTime dateFin = statistiquePyramideParamModel.DateFin.AddDays(1); var queryDialogueSecurite = from ds in db.DialogueSecurites where ds.Date >= dateDebut && ds.Date <= dateFin select new { Id = ds.Id, Site = ds.Site.Trigramme, SiteId = ds.SiteId, ZoneId = ds.ZoneId }; return(Request.CreateResponse(HttpStatusCode.OK, queryDialogueSecurite.ToList())); }