public ActionResult Index(Models.Model_Ticket_Attente models) { if (ModelState.IsValid) { models.DateDebut = DateTime.Now; models.DateFinTicket = DateTime.Now; var ticketAttente = AutoMapper.Mapper.Map <Ticket_Attente>(models); contexteEF.Ticket_Attente.Add(ticketAttente); contexteEF.SaveChanges(); return(RedirectToAction("Index", "Home", new { confirm = "ok" })); } var sqlTicket = (from s in contexteEF.Ticket_Attente where s.Validation == 1 orderby s.Id descending select new Models.Model_Ticket_Attente { Id = s.Id, Nom = s.Nom, Prenom = s.Prenom, Sujet = s.Sujet, Message = s.Message, DateDebut = s.DateDebut, Suivie = s.Suivie, Commentaire = s.Commentaire }).Take(5).ToList(); ViewBag.Ticket = sqlTicket; return(View()); }
public ActionResult Ticket_Attente(Models.Model_Ticket_Attente models) { var sqlTicket = (from s in contexteEF.Ticket_Attente where s.Validation != 1 select new Models.Model_Ticket_Attente { Id = s.Id, Nom = s.Nom, Prenom = s.Prenom, Sujet = s.Sujet, Message = s.Message, DateDebut = s.DateDebut, Suivie = s.Suivie }).ToList(); //Affiche le nombre de ticket en attente de validation. var sqlTicketPresent = (from s in contexteEF.Ticket_Attente where s.Validation != 1 select new Models.Model_Ticket_Attente { Id = s.Id, }); int ticketPresent = 0; foreach (var item in sqlTicketPresent) { ticketPresent += 1; } //Envoie de la présence ou non de ticket en attente. ViewBag.ticketPresent = ticketPresent; Session["ticketPresent"] = ticketPresent; return(View(sqlTicket)); }
public ActionResult Modal_Validation(int id) { Ticket_Attente editTicket = contexteEF.Ticket_Attente.Single(p => p.Id == id); Models.Model_Ticket_Attente editTick = AutoMapper.Mapper.Map <Models.Model_Ticket_Attente>(editTicket); return(View(editTick)); }