public static void Initialize(SupportCenterDbContext context, bool dropCreateDB = false)
{
if (!hasRunDuringAppExecution)
{
if (dropCreateDB)
{
context.Database.EnsureDeleted();
}
if (context.Database.EnsureCreated())
{
Seed(context);
}
hasRunDuringAppExecution = true;
}
}
public static void Initialize(SupportCenterDbContext context, bool dropCreateDatabase = false)
{
if (!hasRunDuringAppExecution)
{
// Delete database if requesed
if (dropCreateDatabase)
{
context.Database.EnsureDeleted();
}
// Create database and seed dummy-data if needed
if (context.Database.EnsureCreated()) // 'false' if database already exists
// Seed initial (dummy-)data into newly created database
{
Seed(context);
}
hasRunDuringAppExecution = true;
}
}
public TicketRepository()
{
ctx = new SupportCenterDbContext();
}
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;
}
}
// enable dependency injection for testing
public TicketRepository(SupportCenterDbContext ctx)
{
this.ctx = ctx;
}
public TicketRepository()
{
ctx = new SupportCenterDbContext();
ctx.Database.Initialize(false);
}
public TicketRepository()
{
ctx = new SupportCenterDbContext();
ctx.Database.Initialize(false);
}
public TicketRepository()
{
context = new SupportCenterDbContext();
SupportCenterDbInitializer.Initialize(context, true);
}
public TicketRepository()
{
_ctx = new SupportCenterDbContext();
_ctx.Database.Initialize(false); //initializatie enkel uitvoeren indien nog niet eerder uitgevoerd.
}