public UnitOfWork(JobDBContext _context)
{
context = _context;
Awards = new AwardRepository(context);
FamilyMembers = new FamilyMemberRepository(context);
FamilyMemberRoles = new FamilyMemberRoleRepository(context);
Families = new FamilyRepository(context);
Goals = new GoalRepository(context);
JobCategories = new JobCategoryRepository(context);
Jobs = new JobRepository(context);
JobTemplates = new JobTemplateRepository(context);
MemberJobs = new MemberJobRepository(context);
MemberGoals = new MemberGoalRepository(context);
}
public IEnumerable <Job> GetRevelantJobs(int jobID2)
{
List <Job> jobList = new List <Job>();
var categories = JobCategoryRepository.Get(filter: m => m.JobID == jobID2).ToArray();
foreach (var item in categories)
{
var jobIDList = JobCategoryRepository.Get(filter: m => m.CategoryID == item.CategoryID).ToArray();
foreach (var job in jobIDList)
{
if (job.JobID != jobID2)
{
var jobItem = JobRepository.Get(filter: a => (a.JobID == job.JobID) && (a.IsPublic) && (a.StartedDate <= DateTime.Now) && (a.EndedDate >= DateTime.Now)).FirstOrDefault();
if (jobItem != null)
{
jobList.Add(jobItem);
}
}
}
}
return(jobList.OrderByDescending(m => m.StartedDate).Take(5).Distinct());
}
