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