public DialogueSecuriteViewModel(DialogueSecurite dialogueSecurite, List <Zone> AllZone, List <Lieu> AllLieu) { this.DialogueSecurite = dialogueSecurite; this.AllSite = db.Sites.ToList(); this.AllZone = AllZone; this.AllLieu = AllLieu; this.AllThematique = db.Thematiques.ToList(); this.AllServiceType = db.ServiceTypes.ToList(); }
public HttpResponseMessage Get(int id) { _activeDirectoryUtilisateurRepository = new ActiveDirectoryUtilisateurRepository(); _dialogueSecuriteRepository = new DialogueSecuriteRepository(); DialogueSecurite DialogueSecurite; List <Zone> AllZone; List <Lieu> AllLieu; if (id == -1) { Site SiteUser = _activeDirectoryUtilisateurRepository.GetCurrentUserSite(); DialogueSecurite = new DialogueSecurite() { SiteId = (SiteUser == null) ? 0 : SiteUser.SiteID }; var queryZone = from a in db.Zones where a.SiteId == SiteUser.SiteID select a; AllZone = queryZone.ToList(); AllLieu = new List <Lieu>(); } else { DialogueSecurite = _dialogueSecuriteRepository.Get(id); if (DialogueSecurite == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } var queryZone = from a in db.Zones where a.SiteId == DialogueSecurite.SiteId select a; AllZone = queryZone.ToList(); var queryLieu = from a in db.Lieux where a.ZoneId == DialogueSecurite.ZoneId orderby a.Rang select a; AllLieu = queryLieu.ToList(); } var DialogueSecuriteViewModel = new DialogueSecuriteViewModel(DialogueSecurite, AllZone, AllLieu); return(Request.CreateResponse(HttpStatusCode.OK, DialogueSecuriteViewModel)); }
public HttpResponseMessage Delete(int id) { DialogueSecurite dialogueSecurite = db.DialogueSecurites.Find(id); if (dialogueSecurite == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } db.DialogueSecurites.Remove(dialogueSecurite); db.SaveChanges(); return(Request.CreateResponse(HttpStatusCode.OK)); }
public HttpResponseMessage Put(int id, DialogueSecurite dialogueSecurite) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } if (id != dialogueSecurite.Id) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } var currentdialogueSecurite = db.DialogueSecurites.Find(dialogueSecurite.Id); db.Entry(currentdialogueSecurite).CurrentValues.SetValues(dialogueSecurite); db.Entry(currentdialogueSecurite).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException) { if (!DialogueSecuriteExists(id)) { return(Request.CreateResponse(HttpStatusCode.NotFound, currentdialogueSecurite)); } else { throw; } } return(Request.CreateResponse(HttpStatusCode.OK, currentdialogueSecurite)); }
public DialogueSecurite Get(Int32 id) { DialogueSecurite DialogueSecurite = _db.DialogueSecurites.SingleOrDefault(r => r.Id == id); return(DialogueSecurite); }
public DialogueSecurite Get(int id) { DialogueSecurite dialogueSecurite = _db.DialogueSecurites.SingleOrDefault(r => r.Id == id); return(dialogueSecurite); }
public HttpResponseMessage Post(DialogueSecurite dialogueSecurite) { // DialogueSecurite.DateCreation = DateTime.Now; dialogueSecurite.CompteurAnnuelSite = 1; var QueryLastDialogueSecuriteForSiteAnnee = from ds in db.DialogueSecurites where ds.SiteId == dialogueSecurite.SiteId && ds.Date.Year == dialogueSecurite.Date.Year orderby ds.CompteurAnnuelSite descending select ds; DialogueSecurite LastDialogueSecuriteForSiteAnnee = QueryLastDialogueSecuriteForSiteAnnee.FirstOrDefault(); if (LastDialogueSecuriteForSiteAnnee != null) { if (LastDialogueSecuriteForSiteAnnee.Date.Year == dialogueSecurite.Date.Year) { dialogueSecurite.CompteurAnnuelSite = LastDialogueSecuriteForSiteAnnee.CompteurAnnuelSite + 1; } } Site site = db.Sites.First(s => s.SiteID == dialogueSecurite.SiteId); dialogueSecurite.Code += site.Trigramme + "-" + dialogueSecurite.Date.Year + "-" + dialogueSecurite.CompteurAnnuelSite; dialogueSecurite.Dialogueur1 = _personneAnnuaireService.GetPersonneFromAllAnnuaireOrCreate( dialogueSecurite.Dialogueur1.Nom, dialogueSecurite.Dialogueur1.Prenom, dialogueSecurite.Dialogueur1Id, db ); dialogueSecurite.Dialogueur2 = _personneAnnuaireService.GetPersonneFromAllAnnuaireOrCreate( dialogueSecurite.Dialogueur2.Nom, dialogueSecurite.Dialogueur2.Prenom, dialogueSecurite.Dialogueur2Id, db ); dialogueSecurite.Dialogueur3 = _personneAnnuaireService.GetPersonneFromAllAnnuaireOrCreate( dialogueSecurite.Dialogueur3.Nom, dialogueSecurite.Dialogueur3.Prenom, dialogueSecurite.Dialogueur3Id, db ); dialogueSecurite.Entretenu1 = _personneAnnuaireService.GetPersonneFromAllAnnuaireOrCreate( dialogueSecurite.Entretenu1.Nom, dialogueSecurite.Entretenu1.Prenom, dialogueSecurite.Entretenu1Id, db ); dialogueSecurite.Entretenu2 = _personneAnnuaireService.GetPersonneFromAllAnnuaireOrCreate( dialogueSecurite.Entretenu2.Nom, dialogueSecurite.Entretenu2.Prenom, dialogueSecurite.Entretenu2Id, db ); dialogueSecurite.Entretenu3 = _personneAnnuaireService.GetPersonneFromAllAnnuaireOrCreate( dialogueSecurite.Entretenu3.Nom, dialogueSecurite.Entretenu3.Prenom, dialogueSecurite.Entretenu3Id, db ); db.DialogueSecurites.Add(dialogueSecurite); //try //{ db.SaveChanges(); DialogueSecurite dbDialogueSecurite = db.DialogueSecurites .Where(ds => ds.Id == dialogueSecurite.Id) .Include(ds => ds.Thematique) .Include(ds => ds.ServiceType) .Include(ds => ds.ServiceType1) .Include(ds => ds.ServiceType2) .Include(ds => ds.ServiceType3) .Include(ds => ds.ServiceType4) .Include(ds => ds.ServiceType5) .FirstOrDefault(); _emailService.SendEmailDiffusionDialogueSecurite(dbDialogueSecurite); return(Request.CreateResponse(HttpStatusCode.OK, dbDialogueSecurite)); //} //catch (Exception e) //{ // return Request.CreateResponse(HttpStatusCode.InternalServerError, e); //} }
public void SendEmailDiffusionDialogueSecurite(DialogueSecurite dialogueSecurite) { Site site = db.Sites.First(s => s.SiteID == dialogueSecurite.SiteId); string to = GetEmailFor("DiffusionFicheSecurite", db.Sites.Find(dialogueSecurite.SiteId).Trigramme); UrlHelper url = new UrlHelper(HttpContext.Current.Request.RequestContext); string urlToDialogueSecurite = url.Action("Edit", "DialogueSecurite", new System.Web.Routing.RouteValueDictionary(new { id = dialogueSecurite.Id }), "http", HttpContext.Current.Request.Url.Host); MailAddress from = new MailAddress("*****@*****.**"); //Contournement, je n'arrive pas à charger les objets "lieu" dans le "DialogueSecurite", alors que l'ID est bien présent ... Lieu lieu = db.Lieux.Find(dialogueSecurite.LieuId); Zone zone = db.Zones.Find(dialogueSecurite.ZoneId); string subject = "Nouveau Dialogue Sécurité " + dialogueSecurite.Code; string body = "<div style='font-family: Verdana, sans-serif;'><H2 style='background-color:#FD9910;color:#FFFFFF;text-align:center;border-radius: 25px;'>Le Dialogue Sécurité " + dialogueSecurite.Code + " vient d'être diffusé.</H2></div>" + "<br/>" + "<table><tbody>"; body += "<tr><td>Dialogués : </td><td>1 / </td><td>" + dialogueSecurite.Entretenu1.Prenom + "</td><td>" + dialogueSecurite.Entretenu1.Nom + "</td><td> du service : </td><td>" + dialogueSecurite.ServiceType3.Nom + "</td></tr>"; if (dialogueSecurite.Entretenu2.Nom != null) { body += "<tr><td></td><td>2 / </td><td>" + dialogueSecurite.Entretenu2.Prenom + "</td><td>" + dialogueSecurite.Entretenu2.Nom + "</td><td> du service : </td><td>" + dialogueSecurite.ServiceType4.Nom + "</td></tr>"; } if (dialogueSecurite.Entretenu3.Nom != null) { body += "<tr><td></td><td>3 / </td><td>" + dialogueSecurite.Entretenu3.Prenom + "</td><td>" + dialogueSecurite.Entretenu3.Nom + "</td><td> du service : </td><td>" + dialogueSecurite.ServiceType5.Nom + "</td></tr>"; } body += "<tr></tr>"; body += "<tr><td>Dialogueurs :</td><td>1 / </td><td>" + dialogueSecurite.Dialogueur1.Prenom + "</td><td>" + dialogueSecurite.Dialogueur1.Nom + "</td><td> du service : </td><td>" + dialogueSecurite.ServiceType.Nom + "</td></tr>"; if (dialogueSecurite.Dialogueur2.Nom != null) { body += "<tr><td></td><td>2 / </td><td>" + dialogueSecurite.Dialogueur2.Prenom + "</td><td>" + dialogueSecurite.Dialogueur2.Nom + "</td><td> du service : </td><td>" + dialogueSecurite.ServiceType1.Nom + "</td></tr>"; } if (dialogueSecurite.Dialogueur3.Nom != null) { body += "<tr><td></td><td>3 / </td><td>" + dialogueSecurite.Dialogueur3.Prenom + "</td><td>" + dialogueSecurite.Dialogueur3.Nom + "</td><td> du service : </td><td>" + dialogueSecurite.ServiceType2.Nom + "</td></tr>"; } body += "</tbody></table>"; body += "<br/>"; body += "<div> Thématique : " + dialogueSecurite.Thematique.Nom + "</div>"; body += "<br/>"; body += "<table><tbody>" + "<tr><td>SITUER</td><td>" + dialogueSecurite.Contexte + "</td></tr>" + "<tr><td>OBSERVER</td><td>" + dialogueSecurite.Observation + "</td></tr>" + "<tr><td>REFLECHIR</td><td>" + dialogueSecurite.Reflexion + "</td></tr>" + "<tr><td>AGIR</td><td>" + dialogueSecurite.Action + "</td></tr>" + "</table></tbody>"; body += "<br/>"; body += "<div> Zone : " + zone.ZoneType.Nom + "</div>"; body += "<div> Lieu : " + lieu.Nom + "</div>"; body += "<br/>"; body += "<div> Lien vers le dialogue : " + urlToDialogueSecurite + "</div>"; if (to != "" && to != null) { SendEmail(from, subject, body, to); } }