public Ticket CreateTicket(Ticket ticket) { ctx.Tickets.Add(ticket); ctx.SaveChanges(); return(ticket); }
public Ticket CreateTicket(Ticket ticket) { ctx.Tickets.Add(ticket); ctx.SaveChanges(); return(ticket); // 'TicketNumber' has been created by the database! }
private static void Seed(SupportCenterDbContext context) { // Create first ticket with three responses Ticket t1 = new Ticket() { AccountId = 1, Text = "Ik kan mij niet aanmelden op de webmail", DateOpened = new DateTime(2017, 9, 9, 13, 5, 59), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t1); TicketResponse t1r1 = new TicketResponse() { Ticket = t1, Text = "Account was geblokkeerd", Date = new DateTime(2017, 9, 9, 13, 24, 48), IsClientResponse = false }; t1.Responses.Add(t1r1); TicketResponse t1r2 = new TicketResponse() { Ticket = t1, Text = "Account terug in orde en nieuw paswoord ingesteld", Date = new DateTime(2017, 9, 9, 13, 29, 11), IsClientResponse = false }; t1.Responses.Add(t1r2); TicketResponse t1r3 = new TicketResponse() { Ticket = t1, Text = "Aanmelden gelukt en paswoord gewijzigd", Date = new DateTime(2017, 9, 10, 7, 22, 36), IsClientResponse = true }; t1.Responses.Add(t1r3); t1.State = TicketState.Closed; // Create second ticket with one response Ticket t2 = new Ticket() { AccountId = 1, Text = "Geen internetverbinding", DateOpened = new DateTime(2017, 11, 5, 9, 45, 13), State = TicketState.Open, Responses = new List <TicketResponse>() }; context.Tickets.Add(t2); TicketResponse t2r1 = new TicketResponse() { Ticket = t2, Text = "Controleer of de kabel goed is aangesloten", Date = new DateTime(2017, 11, 5, 11, 25, 42), IsClientResponse = false }; t2.Responses.Add(t2r1); t2.State = TicketState.Answered; // Create hardware ticket without response HardwareTicket ht1 = new HardwareTicket() { AccountId = 2, Text = "Blue screen!", DateOpened = new DateTime(2017, 12, 14, 19, 5, 2), State = TicketState.Open, DeviceName = "PC-123456" }; context.Tickets.Add(ht1); // Save the changes in the context to the database context.SaveChanges(); // Detach all entities from the context, // else this data stays attached to context and should be read from the db when needed! foreach (EntityEntry entry in context.ChangeTracker.Entries().ToList()) { entry.State = EntityState.Detached; } }
public Ticket CreateTicket(Ticket ticket) { context.Tickets.Add(ticket); context.SaveChanges(); return(ticket); }