public async Task SeedAsync() { if (_context.Set <Department>().Any()) { return; } var employees = GetEmployees(); var departments = GetDepartments(); var jobs = GetJobs(); employees[0].AssignJob(departments[0], jobs[0], DateTime.Parse("2018-07-01")); employees[1].AssignJob(departments[1], jobs[1], DateTime.Parse("2018-07-01")); employees[2].AssignJob(departments[2], jobs[2], DateTime.Parse("2018-07-01")); employees[3].AssignJob(departments[3], jobs[2], DateTime.Parse("2018-07-15")); employees[4].AssignJob(departments[4], jobs[2], DateTime.Parse("2018-08-04")); employees[5].AssignJob(departments[1], jobs[3], DateTime.Parse("2018-08-04")); employees[6].AssignJob(departments[2], jobs[6], DateTime.Parse("2018-08-04")); employees[7].AssignJob(departments[3], jobs[4], DateTime.Parse("2018-08-04")); employees[8].AssignJob(departments[3], jobs[4], DateTime.Parse("2018-08-04")); employees[9].AssignJob(departments[3], jobs[4], DateTime.Parse("2018-08-04")); employees[10].AssignJob(departments[4], jobs[5], DateTime.Parse("2018-08-04")); employees[11].AssignJob(departments[4], jobs[5], DateTime.Parse("2018-08-04")); _context.Set <Employee>().AddRange(employees); _context.Set <Department>().AddRange(departments); _context.Set <Job>().AddRange(jobs); _context.LogEvents(); await _context.SaveChangesAsync(); }
public async Task <List <T> > GetAll() { var task = await Task.Run(() => { return(db.Set <T>() .AsNoTracking() .ToList()); }); return(task); }
public JobRepository(HRContext context) { _context = context ?? throw new ArgumentNullException(nameof(context)); _jobs = context.Set <Job>(); }
public EmployeeRepository(HRContext context) { _context = context ?? throw new ArgumentNullException(nameof(context)); _employees = context.Set <Employee>(); }
public async Task <ActionResult <T> > GetById(int id) { return(await _context.Set <T>().FindAsync(id)); }
public DepartmentRepository(HRContext context) { _context = context ?? throw new ArgumentNullException(nameof(context)); _departments = context.Set <Department>(); }