public static IQueryable <Employee> GetCompleteCurves(this JamesDbContext context)
{
return(context.Employee
.Include(e => e.Job));
}
public ValuesController(JamesDbContext context, IEmployeeService employeeService, IMapper mapper)
{
this.Context = context;
this.EmployeeService = employeeService;
this.Mapper = mapper;
}
public static Job GetCompleteCurveById(this JamesDbContext context, int id)
{
return(context.Job
.Include(i => i.Employees)
.FirstOrDefault(j => j.JobId == id));
}
public Job GetJobById(JamesDbContext ctx, int id) => ctx.Job.FirstOrDefault(e => e.JobId == id);
public ThreadingExample(JamesDbContext context)
{
this.Context = context;
}
public IEnumerable <Job> GetJobs(JamesDbContext ctx) => ctx.Job;
public IEnumerable <Employee> GetEmployeeByJobName(JamesDbContext ctx, string jobName)
{
var job = ctx.Job.FirstOrDefault(j => j.JobName == jobName);
return(ctx.Employee.Where(e => e.JobId == job.JobId));
}
public IEnumerable <Employee> GetEmployeeById(JamesDbContext ctx, List <int> ids) => ctx.Employee.Where(e => ids.Contains(e.EmployeeId));
public Employee GetEmployeeById(JamesDbContext ctx, int id) => ctx.Employee.FirstOrDefault(e => e.EmployeeId == id);
public IEnumerable <Employee> GetEmployees(JamesDbContext ctx) => ctx.Employee;
