public List <CompetencyDomainObject> RetrieveCompetency(int id)
{
using (RecruitingManagerEntities entities = new Data.RecruitingManagerEntities())
{
return(entities.Competencies
.Where(competency => competency.Id == id)
.Select(competency => new CompetencyDomainObject()
{
ReviewCategory = competency.ReviewCategory,
Area = (CompetencyArea)competency.CompetencyArea,
CompetencyDescription = competency.CompetencyDescription,
Id = competency.Id
}).ToList());
}
}
public void CreateCompetency(CompetencyFeedbackDomainObject createCompetencyFeedback)
{
using (RecruitingManagerEntities entities = new Data.RecruitingManagerEntities())
{
entities.CompetencyFeedbacks.AddObject(new CompetencyFeedback()
{
CandidateId = createCompetencyFeedback.CandidateId,
CompetencyId = createCompetencyFeedback.CompetencyId,
InterviewerId = createCompetencyFeedback.InterviewerId,
Note = createCompetencyFeedback.Note,
CompetencyLevel = (int)createCompetencyFeedback.ExperienceLevel
});
entities.SaveChanges();
}
}
public List <CompetencyFeedbackDomainObject> RetrieveCompetencyFeedbackList(int candidateId)
{
using (RecruitingManagerEntities entities = new Data.RecruitingManagerEntities())
{
return(entities.CompetencyFeedbacks
.Where(competencyFeedback => competencyFeedback.CandidateId == candidateId)
.Select(competencyFeedback => new CompetencyFeedbackDomainObject()
{
CandidateId = competencyFeedback.CandidateId,
CompetencyId = competencyFeedback.CompetencyId,
ExperienceLevel = (ExperienceLevel)competencyFeedback.CompetencyLevel.Value,
Id = competencyFeedback.Id,
InterviewerId = competencyFeedback.InterviewerId.Value,
Note = competencyFeedback.Note
}).ToList());
}
}
public DomainObjects.Candidate.CandidateDomainObject RetrieveCandidate(int id)
{
using (RecruitingManager.Data.RecruitingManagerEntities entities = new Data.RecruitingManagerEntities())
{
return(entities.Candidates
.Where(candidate => candidate.Id == id)
.Select(candidate =>
new CandidateDomainObject()
{
EmailAddress = candidate.EmailAddress,
FirstName = candidate.FirstName,
HireCandidate = candidate.HireCandidate,
Id = candidate.Id,
InterviewComplete = candidate.InterviewComplete,
LastName = candidate.LastName,
ResumeAddress = new Uri(candidate.ResumeAddress)
}
).FirstOrDefault());
}
}
