public void AddLastEmployeeNameToTickets()
{
using (var db = new OcecomTicketsContext())
{
foreach (var ticket in db.Tickets.ToList())
{
if (ticket.TicketHourRecords.Any())
{
ticket.LastEmployeeName = ticket.TicketHourRecords.OrderBy(t => t.Date).Last().Employee.Name;
}
}
db.SaveChanges();
}
}
public ActionResult Create(Client client)
{
if (UserEmailExists(client.Email))
{
ModelState.AddModelError("Email", "El correo ya existe para otro usuario.");
}
if (ModelState.IsValid)
{
if (CreateUser(client.Email, client.Password))
{
db.Clients.Add(client);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ModelState.AddModelError("", "Error: No se pudo crear el usuario.");
}
}
return(View(client));
}
public ActionResult Create(Ticket ticket, int linkId = 0)
{
ticket.CreationDate = DateTime.Now;
ticket.Status = "Abierto";
ticket.ClientId = db.Clients.Where(c => c.Email == User.Identity.Name).Select(c => c.Id).First();
ModelState["Status"].Errors.Clear();
if (ModelState.IsValid)
{
if (linkId > 0)
{
ticket.LinkedTicketId = linkId;
}
db.Tickets.Add(ticket);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(ticket));
}
