public Rec_InterviewModel Post([Bind]Rec_InterviewModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Rec_InterviewModel>(model, "Rec_Interview", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
ActionService service = new ActionService(UserLogin);
var result = service.UpdateOrCreate<Rec_InterviewEntity, Rec_InterviewModel>(model);
var RecruitmentHisService = new Rec_RecruitmentHistoryServices();
var candService = new Rec_CandidateServices();
var InTerCamDetaiServices = new Rec_InterviewCampaignDetailServices();
Rec_RecruitmentHistoryEntity ObjRecruitmentHistory = null;
Rec_RecruitmentHistoryServices RecruitmentHistoryServices = new Rec_RecruitmentHistoryServices();
Rec_CandidateEntity ObjCandidate = null;
Rec_CandidateServices CandidateServices = new Rec_CandidateServices();
Rec_InterviewCampaignDetailEntity ObjInterviewCampaignDetail = null;
Rec_InterviewCampaignDetailServices InterviewCampaignDetailServices = new Rec_InterviewCampaignDetailServices();
string status = string.Empty;
#region xử lý cap nhat lich su ung vien, cap nhat ung vien
if (result != null)
{
ObjRecruitmentHistory = new Rec_RecruitmentHistoryEntity();
ObjCandidate = new Rec_CandidateEntity();
ObjInterviewCampaignDetail = new Rec_InterviewCampaignDetailEntity();
var IlRecruitmentHistory = RecruitmentHisService.GetData<Rec_RecruitmentHistoryEntity>(result.CandidateID, ConstantSql.hrm_rec_sp_get_RecruitmentHistoryIdByCandidateId,UserLogin, ref status).OrderByDescending(s => s.DateApply).FirstOrDefault();
var IlCandate = candService.GetData<Rec_CandidateEntity>(result.CandidateID, ConstantSql.hrm_rec_sp_get_CandidateById, UserLogin, ref status).FirstOrDefault();
var IlInterviewcampaugnDetail = InTerCamDetaiServices.GetData<Rec_InterviewCampaignDetailEntity>(result.CandidateID, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetailByCddId, UserLogin ,ref status).ToList();
ObjCandidate = IlCandate;
ObjRecruitmentHistory = IlRecruitmentHistory;
if (IlCandate != null)
{
string[] strCondition = model.ConditionTemp.Split('|').ToArray();
foreach (var Objitem in strCondition)
{
string[] item = Objitem.Split(',').ToArray();
if(item[0].ToString() == EnumDropDown.JobCondition.E_HEIGHT.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.Height = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_WEIGHT.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.Weight = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_LEVELEYES.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.LevelEye = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_LEVERIGHTLEYES.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.LevelEyeRight = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_MUSCULOSKELETAL.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.Musculoskeletal = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_BLOODPRESSURE.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.BloodPressure = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_HEARTBEAT.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.HeartBeat = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_GENARALHEALTH.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.GenaralHealth = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_DISEASELISTIDS.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.DiseaseListIDs = item[1].ToString();
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_WRITETEST.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.WriteTest = double.Parse(item[1].ToString());
}
}
else if (item[0].ToString() == EnumDropDown.JobCondition.E_INTERVIEW.ToString())
{
if (item[1] != null && item[1] != "")
{
ObjCandidate.Interview = double.Parse(item[1].ToString());
}
}
}
ObjCandidate.LevelInterview = result.LevelInterview;
if (result.ResultInterview.Equals(HRM.Infrastructure.Utilities.Interview.E_FAIL.ToString()))
{
ObjCandidate.Status = HRM.Infrastructure.Utilities.Interview.E_FAIL.ToString();
ObjCandidate.DateUpdate = DateTime.Now;
}
// Nếu có nhập điểm thì gán ngày đánh giá = ngày phỏng vấn
if (model != null && (model.Score1 != null || model.Score2 != null))
{
ObjCandidate.DateExam = model.DateInterview;
ObjCandidate.DateUpdate = DateTime.Now;
}
if(ObjCandidate.JobVacancyID != null)
{
var entityJobVacancy = service.GetData<Rec_JobVacancyEntity>(Common.DotNetToOracle(ObjCandidate.JobVacancyID.ToString()), ConstantSql.hrm_rec_sp_get_JobVacancyId, ref status).FirstOrDefault();
if (entityJobVacancy.NoLevelInterview == result.LevelInterview && result.ResultInterview.Equals(HRM.Infrastructure.Utilities.Interview.E_PASS.ToString()))
{
if (IlCandate != null)
{
ObjCandidate.Status = HRM.Infrastructure.Utilities.EnumDropDown.CandidateStatus.E_PASS.ToString();
ObjCandidate.DateUpdate = DateTime.Now;
}
if (IlRecruitmentHistory != null)
{
ObjRecruitmentHistory.Status = HRM.Infrastructure.Utilities.Interview.E_PASS.ToString();
ObjRecruitmentHistory.DateUpdate = DateTime.Now;
}
}
}
}
if (IlRecruitmentHistory != null)
{
// Nếu có nhập điểm thì gán ngày đánh giá = ngày phỏng vấn
if (model != null && (model.Score1 != null || model.Score2 != null))
{
IlRecruitmentHistory.DateExam = model.DateInterview;
}
ObjRecruitmentHistory = IlRecruitmentHistory;
ObjRecruitmentHistory.LevelInterview = result.LevelInterview;
if (result.ResultInterview.Equals(HRM.Infrastructure.Utilities.Interview.E_FAIL.ToString()))
{
//cap nhat status cho lich su ung vien
ObjRecruitmentHistory.Status = HRM.Infrastructure.Utilities.Interview.E_FAIL.ToString();
}
}
//Cập nhật level cho intercampaigndetail
if (IlInterviewcampaugnDetail != null)
{
var ObjTemp = IlInterviewcampaugnDetail.Where(s => s.CandidateID == result.CandidateID && s.LevelInterview == null).FirstOrDefault();
if (ObjTemp != null)
{
ObjInterviewCampaignDetail = ObjTemp;
ObjInterviewCampaignDetail.LevelInterview = result.LevelInterview;
}
}
message = InterviewCampaignDetailServices.Edit(ObjInterviewCampaignDetail);
message = RecruitmentHistoryServices.Edit(ObjRecruitmentHistory);
message = CandidateServices.Edit(ObjCandidate);
}
#endregion
return result;
}
public ActionResult ExportIntervieCampaignDetaiByTemplate([DataSourceRequest] DataSourceRequest request, Rec_InterviewCampaignDetailSearchModel model)
{
string status = string.Empty;
var baseService = new BaseService();
ActionService service = new ActionService(UserLogin);
List<object> objs = new List<object>();
List<object> objshis = new List<object>();
List<Rec_InterviewCampaignDetailModel> resultInterviewCampaignDetail = new List<Rec_InterviewCampaignDetailModel>();
var InterviewServices = new Rec_InterviewCampaignDetailServices();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = baseService.GetData<Rec_InterviewCampaignDetailModel>(lstModel, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetail, UserLogin, ref status);
#region Load Chi tiet ke hoach chua phong van
if (result != null)
{
var InTerCamDetaiServices = new Rec_InterviewCampaignDetailServices();
var HistoryServices = new Rec_RecruitmentHistoryServices();
var lstCandidateIDS = result.Select(s => s.CandidateID).Distinct().ToList();
string temp = string.Empty;
foreach (Guid item in lstCandidateIDS)
{
temp += item;
temp += ",";
}
if (temp.Length > 0)
{
temp = temp.Substring(0, temp.Length - 1);
}
var lstCandidateHistory = HistoryServices.GetData<Rec_RecruitmentHistoryEntity>(Common.DotNetToOracle(temp), ConstantSql.hrm_rec_sp_get_RecHisByListCandidateID, UserLogin, ref status).ToList();
foreach (var item in result)
{
//var IlInterviewcampaugnDetail = result.Where(s => s.CandidateID == item.CandidateID).ToList();
var ObjHisCandidate = lstCandidateHistory.Where(s => s.ID == item.RecruitmentHistoryID).FirstOrDefault();
if (ObjHisCandidate == null)
{
continue;
}
Rec_JobVacancyEntity entityJobVacancy = null;
if (ObjHisCandidate != null && ObjHisCandidate.JobVacancyID != Guid.Empty && ObjHisCandidate.JobVacancyID != null)
{
entityJobVacancy = service.GetByIdUseStore<Rec_JobVacancyEntity>(ObjHisCandidate.JobVacancyID.Value, ConstantSql.hrm_rec_sp_get_JobVacancyId, ref status);
}
if (entityJobVacancy != null)
{
if (item.LevelInterview != null && item.LevelInterview == entityJobVacancy.NoLevelInterview)
{
continue;
}
}
if (item.LevelInterview == null && (ObjHisCandidate.Status != HRM.Infrastructure.Utilities.EnumDropDown.CandidateStatus.E_PASS.ToString()
&& ObjHisCandidate.Status != HRM.Infrastructure.Utilities.EnumDropDown.CandidateStatus.E_FAIL.ToString()
))
{
if (ObjHisCandidate != null)
{
if (ObjHisCandidate.LevelInterview == null)
{
item.LevelInterview = 1;
resultInterviewCampaignDetail.Add(item);
}
else
{
item.LevelInterview = ObjHisCandidate.LevelInterview + 1;
resultInterviewCampaignDetail.Add(item);
}
}
}
}
}
resultInterviewCampaignDetail = resultInterviewCampaignDetail.Distinct().ToList();
#endregion
var isDataTable = false;
object obj = new Rec_InterviewCampaignDetailModel();
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateFrom };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateTo };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (model.IsCreateTemplateForDynamicGrid)
{
obj = resultInterviewCampaignDetail;
isDataTable = false;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Rec_InterviewCampaignDetailModel",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, resultInterviewCampaignDetail, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
return Json(resultInterviewCampaignDetail.ToDataSourceResult(request));
}
public JsonResult getRecruitmentHistoryId(Guid ID)
{
string status = string.Empty;
var RecruitmentHisService = new Rec_RecruitmentHistoryServices();
Guid? RecruitmentHistoryId = RecruitmentHisService.GetData<Rec_RecruitmentHistoryEntity>(ID, ConstantSql.hrm_rec_sp_get_RecruitmentHistoryIdByCandidateId, UserLogin, ref status).OrderByDescending(s => s.DateApply).Select(s => s.ID).FirstOrDefault();
return Json(RecruitmentHistoryId);
}
public Rec_InterviewCampaignModel Post([Bind]Rec_InterviewCampaignModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Rec_InterviewCampaignModel>(model, "Rec_InterviewCampaign", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
ActionService service = new ActionService(UserLogin);
var result = service.UpdateOrCreate<Rec_InterviewCampaignEntity, Rec_InterviewCampaignModel>(model);
if (model.listCandidateGuidIds != null)
{
List<Guid> listId = model.listCandidateGuidIds;
Rec_InterviewCampaignDetailEntity OjbInterviewDetail = null;
Rec_InterviewCampaignDetailServices InterviewCampaignDetailService = new Rec_InterviewCampaignDetailServices();
string status = string.Empty;
foreach (Guid item in listId)
{
var RecruitmentHisService = new Rec_RecruitmentHistoryServices();
var ilistRecruitmentHistory = RecruitmentHisService.GetData<Rec_RecruitmentHistoryEntity>(item, ConstantSql.hrm_rec_sp_get_RecruitmentHistoryIdByCandidateId, UserLogin,ref status).ToList();
Guid? RecruitmentHistoryId = ilistRecruitmentHistory.Where(s => s.Status != HRM.Infrastructure.Utilities.Interview.E_FAIL.ToString()
&& s.Status != HRM.Infrastructure.Utilities.Interview.E_PASS.ToString() && s.Status != null).Select(s => s.ID).FirstOrDefault();
OjbInterviewDetail = new Rec_InterviewCampaignDetailEntity();
OjbInterviewDetail.InterviewCampaignID = result.ID;
OjbInterviewDetail.CandidateID = item;
OjbInterviewDetail.DateInterview = model.DateInterviewFrom;
OjbInterviewDetail.RecruitmentHistoryID = RecruitmentHistoryId;
OjbInterviewDetail.LevelInterview = model.LevelInterview;
InterviewCampaignDetailService.Add(OjbInterviewDetail);
}
}
return result;
}
