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