public string ActionPassing(string selectedIds, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
BaseService service = new BaseService();
Rec_InterviewServices services = new Rec_InterviewServices();
Rec_InterviewCampaignDetailServices InterviewCampaignDetailServices = new Rec_InterviewCampaignDetailServices();
Rec_RecruitmentHistoryServices RecruitmentHistoryServices = new Rec_RecruitmentHistoryServices();
Rec_CandidateServices CandidateServices = new Rec_CandidateServices();
string status = string.Empty;
string message = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Rec_InterviewCampaignDetailRepository(unitOfWork);
var InterviewRepository = new Rec_InterviewRepository(unitOfWork);
var InterviewCampaignDetailRepository = new Rec_InterviewCampaignDetailRepository(unitOfWork);
List<Guid> lstIds = selectedIds.Split(',').Select(x => Guid.Parse(x)).ToList();
var lstInterviewCampaignDetail = repo.FindBy(m => m.ID != null && lstIds.Contains(m.ID)).ToList();
var lstcandidateid = lstInterviewCampaignDetail.Select(s => s.CandidateID).ToList();
var objs = new List<object>();
string strIDs = string.Empty;
foreach (var item in lstcandidateid)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
strIDs = strIDs.Substring(0, strIDs.Length - 1);
objs.Add(strIDs);
var lstcandidate = service.GetData<Rec_CandidateEntity>(strIDs, ConstantSql.hrm_rec_sp_get_CandidateByIds, userLogin, ref status).ToList();
var lstrecruimenthistory = service.GetData<Rec_RecruitmentHistoryEntity>(strIDs, ConstantSql.hrm_hr_sp_get_RecHisByCandidateIds, userLogin, ref status).ToList();
var lstinterviewbycandidateids = service.GetData<Rec_InterviewEntity>(strIDs, ConstantSql.hrm_hr_sp_get_InterViewByCandidateIds, userLogin, ref status).ToList();
List<Rec_InterviewEntity> lstinterview = new List<Rec_InterviewEntity>();
List<Rec_InterviewCampaignDetail> lstAllInterviewCampaignDetail = new List<Rec_InterviewCampaignDetail>();
var lstJobVaCancyIDs = lstcandidate.Select(s => s.JobVacancyID).ToList();
string strJobVacancyIds = string.Empty;
foreach (Guid item in lstJobVaCancyIDs)
{
strJobVacancyIds += item;
strJobVacancyIds += ",";
}
if (strJobVacancyIds.Length > 0)
{
strJobVacancyIds = strJobVacancyIds.Substring(0, strJobVacancyIds.Length - 1);
}
var lstJobVacancy = service.GetData<Rec_JobVacancyEntity>(Common.DotNetToOracle(strJobVacancyIds), ConstantSql.hrm_rec_sp_get_JobVacancyByIds, userLogin, ref status).ToList();
Rec_InterviewCampaignDetail ObjRecInterviewDt = null;
foreach (var candidate in lstcandidate)
{
ObjRecInterviewDt = new Rec_InterviewCampaignDetail();
Rec_InterviewEntity Interview = new Rec_InterviewEntity();
var hisbycandidate = lstrecruimenthistory.Where(s => s.CandidateID == candidate.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
Interview.CandidateID = candidate.ID;
Interview.RecruitmentHistoryID = hisbycandidate.ID;
var interviewbycan = lstinterviewbycandidateids.Where(s => s.RecruitmentHistoryID == hisbycandidate.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
int? level = 0;
if (interviewbycan != null && interviewbycan.LevelInterview != null)
{
level = interviewbycan.LevelInterview + 1;
}
else
{
level = 1;
}
var InterviewCampaignDetail = lstInterviewCampaignDetail.Where(s => s.RecruitmentHistoryID == hisbycandidate.ID && s.LevelInterview == null).FirstOrDefault();
if (InterviewCampaignDetail == null)
{
continue;
}
ObjRecInterviewDt = InterviewCampaignDetail;
ObjRecInterviewDt.LevelInterview = level;
var jobVacancybyCandidate = lstJobVacancy.Where(s => s.ID == candidate.JobVacancyID).FirstOrDefault();
var rechisbycandidate = lstrecruimenthistory.Where(s => s.CandidateID == candidate.ID).OrderByDescending(s => s.DateApply).FirstOrDefault();
// nếu là vòng phỏng vấn cuối cùng thì cập nhật lại trạng thái.
if (jobVacancybyCandidate != null && jobVacancybyCandidate.NoLevelInterview == level)
{
rechisbycandidate.Status = "E_PASS";
candidate.Status = "E_PASS";
}
candidate.LevelInterview = level;
rechisbycandidate.LevelInterview = level;
rechisbycandidate.CandidateID = candidate.ID;
Interview.Status = "E_PASS";
Interview.ResultInterview = "E_PASS";
Interview.LevelInterview = level;
lstinterview.Add(Interview);
lstAllInterviewCampaignDetail.Add(ObjRecInterviewDt);
RecruitmentHistoryServices.Edit(rechisbycandidate);
CandidateServices.Edit(candidate);
}
services.Add(lstinterview);
InterviewCampaignDetailServices.Edit(lstAllInterviewCampaignDetail);
InterviewRepository.SaveChanges();
InterviewCampaignDetailRepository.SaveChanges();
message = NotificationType.Success.ToString();
return message;
}
}
public string ActionPassing(string selectedIds, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
BaseService service = new BaseService();
Rec_InterviewServices services = new Rec_InterviewServices();
Rec_InterviewCampaignDetailServices InterviewCampaignDetailServices = new Rec_InterviewCampaignDetailServices();
Rec_RecruitmentHistoryServices RecruitmentHistoryServices = new Rec_RecruitmentHistoryServices();
Rec_CandidateServices CandidateServices = new Rec_CandidateServices();
string status = string.Empty;
string message = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Rec_InterviewCampaignDetailRepository(unitOfWork);
var InterviewRepository = new Rec_InterviewRepository(unitOfWork);
var InterviewCampaignDetailRepository = new Rec_InterviewCampaignDetailRepository(unitOfWork);
List <Guid> lstIds = selectedIds.Split(',').Select(x => Guid.Parse(x)).ToList();
var lstInterviewCampaignDetail = repo.FindBy(m => m.ID != null && lstIds.Contains(m.ID)).ToList();
var lstcandidateid = lstInterviewCampaignDetail.Select(s => s.CandidateID).ToList();
var objs = new List <object>();
string strIDs = string.Empty;
foreach (var item in lstcandidateid)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
{
strIDs = strIDs.Substring(0, strIDs.Length - 1);
}
objs.Add(strIDs);
var lstcandidate = service.GetData <Rec_CandidateEntity>(strIDs, ConstantSql.hrm_rec_sp_get_CandidateByIds, userLogin, ref status).ToList();
var lstrecruimenthistory = service.GetData <Rec_RecruitmentHistoryEntity>(strIDs, ConstantSql.hrm_hr_sp_get_RecHisByCandidateIds, userLogin, ref status).ToList();
var lstinterviewbycandidateids = service.GetData <Rec_InterviewEntity>(strIDs, ConstantSql.hrm_hr_sp_get_InterViewByCandidateIds, userLogin, ref status).ToList();
List <Rec_InterviewEntity> lstinterview = new List <Rec_InterviewEntity>();
List <Rec_InterviewCampaignDetail> lstAllInterviewCampaignDetail = new List <Rec_InterviewCampaignDetail>();
var lstJobVaCancyIDs = lstcandidate.Select(s => s.JobVacancyID).ToList();
string strJobVacancyIds = string.Empty;
foreach (Guid item in lstJobVaCancyIDs)
{
strJobVacancyIds += item;
strJobVacancyIds += ",";
}
if (strJobVacancyIds.Length > 0)
{
strJobVacancyIds = strJobVacancyIds.Substring(0, strJobVacancyIds.Length - 1);
}
var lstJobVacancy = service.GetData <Rec_JobVacancyEntity>(Common.DotNetToOracle(strJobVacancyIds), ConstantSql.hrm_rec_sp_get_JobVacancyByIds, userLogin, ref status).ToList();
Rec_InterviewCampaignDetail ObjRecInterviewDt = null;
foreach (var candidate in lstcandidate)
{
ObjRecInterviewDt = new Rec_InterviewCampaignDetail();
Rec_InterviewEntity Interview = new Rec_InterviewEntity();
var hisbycandidate = lstrecruimenthistory.Where(s => s.CandidateID == candidate.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
Interview.CandidateID = candidate.ID;
Interview.RecruitmentHistoryID = hisbycandidate.ID;
var interviewbycan = lstinterviewbycandidateids.Where(s => s.RecruitmentHistoryID == hisbycandidate.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
int?level = 0;
if (interviewbycan != null && interviewbycan.LevelInterview != null)
{
level = interviewbycan.LevelInterview + 1;
}
else
{
level = 1;
}
var InterviewCampaignDetail = lstInterviewCampaignDetail.Where(s => s.RecruitmentHistoryID == hisbycandidate.ID && s.LevelInterview == null).FirstOrDefault();
if (InterviewCampaignDetail == null)
{
continue;
}
ObjRecInterviewDt = InterviewCampaignDetail;
ObjRecInterviewDt.LevelInterview = level;
var jobVacancybyCandidate = lstJobVacancy.Where(s => s.ID == candidate.JobVacancyID).FirstOrDefault();
var rechisbycandidate = lstrecruimenthistory.Where(s => s.CandidateID == candidate.ID).OrderByDescending(s => s.DateApply).FirstOrDefault();
// nếu là vòng phỏng vấn cuối cùng thì cập nhật lại trạng thái.
if (jobVacancybyCandidate != null && jobVacancybyCandidate.NoLevelInterview == level)
{
rechisbycandidate.Status = "E_PASS";
candidate.Status = "E_PASS";
}
candidate.LevelInterview = level;
rechisbycandidate.LevelInterview = level;
rechisbycandidate.CandidateID = candidate.ID;
Interview.Status = "E_PASS";
Interview.ResultInterview = "E_PASS";
Interview.LevelInterview = level;
lstinterview.Add(Interview);
lstAllInterviewCampaignDetail.Add(ObjRecInterviewDt);
RecruitmentHistoryServices.Edit(rechisbycandidate);
CandidateServices.Edit(candidate);
}
services.Add(lstinterview);
InterviewCampaignDetailServices.Edit(lstAllInterviewCampaignDetail);
InterviewRepository.SaveChanges();
InterviewCampaignDetailRepository.SaveChanges();
message = NotificationType.Success.ToString();
return(message);
}
}