public static void Initialize(IServiceProvider serviceProvider)
{
using (var _context = new TaskerDbContext(
serviceProvider.GetRequiredService <DbContextOptions <TaskerDbContext> >()))
{
if (_context.Users.Any() && _context.Users.Any())
{
_context.Database.EnsureDeleted();
_context.Database.EnsureCreated();
}
List <User> users = new List <User>();
List <Work> works = new List <Work>();
for (int i = 0; i < 5; i++)
{
users.Add(GenerateUser(i));
}
for (int i = 0; i < 25; i++)
{
works.Add(GenerateTask(i));
}
_context.Users.AddRange(users);
_context.Works.AddRange(works);
_context.SaveChanges();
var rnd = new Random();
foreach (var w in works)
{
int userIndex = rnd.Next(0, 5);
int orderIndex = rnd.Next(0, 25);
int execIndex = rnd.Next(0, 25);
users[userIndex].UserOrders.Add(new UserOrder {
UserId = users[userIndex].Id, OrderId = works[orderIndex].Id
});
users[userIndex].UserExecutes.Add(new UserExec {
UserId = users[userIndex].Id, ExecuteId = works[execIndex].Id
});
_context.SaveChanges();
}
}
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IWebHostEnvironment env, TaskerDbContext dbContext)
{
if (env.IsDevelopment())
{
app.UseDeveloperExceptionPage();
}
else
{
app.UseExceptionHandler("/Error");
}
app.UseStaticFiles();
app.UseRouting();
app.UseEndpoints(endpoints =>
{
endpoints.MapBlazorHub();
endpoints.MapFallbackToPage("/_Host");
});
dbContext.Database.Migrate();
}
public TaskerController(ILogger <TaskerController> logger, TaskerDbContext context)
{
_logger = logger;
_db = context;
}
public TaskRepository(TaskerDbContext context) : base(context)
{
}
public PeopleRepository(TaskerDbContext context) : base(context)
{
}
public TodosViewModel(TaskerDbContext dbContext)
{
_dbContext = dbContext;
Todos = _dbContext.TodoItems.ToList();
}
public UsersController(TaskerDbContext context)
{
_context = context;
}
public static void Initialize(IServiceProvider serviceProvider)
{
using (var context = new TaskerDbContext(
serviceProvider.GetRequiredService <DbContextOptions <TaskerDbContext> >()))
{
if (context.Tasks.Any())
{
return;
}
else
{
var person = new Person
{
FirstName = "Juan David",
LastName = "Pareja Soto",
Email = "*****@*****.**",
PhoneNumber = "3214914812"
};
context.Person.Add(person);
context.SaveChanges();
var anotherPerson = new Person
{
FirstName = "John",
LastName = "Doe",
Email = "*****@*****.**",
PhoneNumber = "3588887441"
};
context.Person.Add(anotherPerson);
context.SaveChanges();
var project = new Project
{
ProjectName = "Curso .NET"
};
context.Projects.Add(project);
context.SaveChanges();
context.Tasks.AddRange(
new MyTask
{
Name = "Preparar mas café",
Description = "Es necesario comprar mas café para el proximo sabado",
DueDate = new DateTime(2018, 8, 15),
ProjectId = project.ProjectId,
CreatedById = person.PersonId
},
new MyTask
{
Name = "Preparar Pan",
Description = "Es necesario comprar mas pan para el proximo sabado",
DueDate = new DateTime(2018, 8, 15),
ProjectId = project.ProjectId,
CreatedById = person.PersonId
}
);
context.SaveChanges();
foreach (var tasks in context.Tasks)
{
context.PersonTasks.Add(new PersonTasks
{
MyTaskId = tasks.MyTaskId,
PersonId = anotherPerson.PersonId
});
}
context.SaveChanges();
}
}
}
public BaseRepository(TaskerDbContext context)
{
this.Context = context;
}
