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