public EFRepository(LoggerPLCDbContext ctx) { context = ctx; }
public static void EnsurePopulated(IApplicationBuilder app) { LoggerPLCDbContext context = app.ApplicationServices.GetRequiredService <LoggerPLCDbContext>(); context.Database.Migrate(); if (!context.Errors.Any() & !context.Datas.Any() && !context.Tasks.Any()) { Task t1 = new Task { TaskName = "Task1", IpPLC = "10.10.10.11", TagName = "Tag1", TaskInterval = 21, IsActive = true }; Task t2 = new Task { TaskName = "Task2", IpPLC = "10.10.10.12", TagName = "Tag2", TaskInterval = 22, IsActive = true }; Task t3 = new Task { TaskName = "Task3", IpPLC = "10.10.10.13", TagName = "Tag3", TaskInterval = 23, IsActive = true }; Task t4 = new Task { TaskName = "Task4", IpPLC = "10.10.10.14", TagName = "Tag4", TaskInterval = 24, IsActive = true }; Task t5 = new Task { TaskName = "Task5", IpPLC = "10.10.10.15", TagName = "Tag5", TaskInterval = 25, IsActive = true }; Task t6 = new Task { TaskName = "Task6", IpPLC = "10.10.10.16", TagName = "Tag6", TaskInterval = 26, IsActive = true }; Task t7 = new Task { TaskName = "Task7", IpPLC = "10.10.10.17", TagName = "Tag7", TaskInterval = 27, IsActive = true }; Task t8 = new Task { TaskName = "Task8", IpPLC = "10.10.10.18", TagName = "Tag8", TaskInterval = 28, IsActive = true }; Task t9 = new Task { TaskName = "Task9", IpPLC = "10.10.10.19", TagName = "Tag9", TaskInterval = 29, IsActive = true }; context.Tasks.Add(t1); context.Tasks.Add(t2); context.Tasks.Add(t3); context.Tasks.Add(t4); context.Tasks.Add(t5); context.Tasks.Add(t6); context.Tasks.Add(t7); context.Tasks.Add(t8); context.Tasks.Add(t9); Error e1 = new Error { Task = t1, Descryption = "Error 1" }; Error e2 = new Error { Task = t2, Descryption = "Error 2" }; Error e3 = new Error { Task = t3, Descryption = "Error 3" }; Error e4 = new Error { Task = t4, Descryption = "Error 4" }; Error e5 = new Error { Task = t5, Descryption = "Error 5" }; Error e6 = new Error { Task = t6, Descryption = "Error 6" }; Error e7 = new Error { Task = t7, Descryption = "Error 7" }; Error e8 = new Error { Task = t8, Descryption = "Error 8" }; Error e9 = new Error { Task = t9, Descryption = "Error 9" }; context.Errors.Add(e1); context.Errors.Add(e2); context.Errors.Add(e3); context.Errors.Add(e4); context.Errors.Add(e5); context.Errors.Add(e6); context.Errors.Add(e7); context.Errors.Add(e8); context.Errors.Add(e9); Random rnd = new Random(); for (int i = 0; i < 100; i++) { context.Datas.Add(new Data { Date = DateTime.Now, Task = t1, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t2, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t3, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t4, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t5, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t6, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t7, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t8, Value = rnd.Next(-100, 100) }); context.Datas.Add(new Data { Date = DateTime.Now, Task = t9, Value = rnd.Next(-100, 100) }); } context.SaveChanges(); } }