public ActionResult ExportAllEnrolledCanList([DataSourceRequest] DataSourceRequest request, Rec_EnrolledCandidateSearchModel model)
{
//return ExportAllAndReturn<Rec_CandidateEntity, Rec_CandidateModel, Rec_EnrolledCandidateSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_EnrolledCandidates);
model.IsExport = true;
model.ValueFields = model.ValueFields.Replace("Gender", "udGender");
model.ValueFields = model.ValueFields.Replace("Status", "udStatus");
string fullPath = string.Empty, status = string.Empty;
var listModel = GetListData<Rec_CandidateEntity, Rec_CandidateModel, Rec_EnrolledCandidateSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_EnrolledCandidates, ref status);
if (status == NotificationType.Success.ToString())
{
status = ExportService.Export(listModel, model.ValueFields.Split(','));
}
return Json(status);
}
public ActionResult GetEnrolledCandidates([DataSourceRequest] DataSourceRequest request, Rec_EnrolledCandidateSearchModel model)
{
// return GetListDataAndReturn<Rec_CandidateModel, Rec_CandidateEntity, Rec_EnrolledCandidateSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_EnrolledCandidates);
string status = string.Empty;
var service = new BaseService();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var listEntity = service.GetData<Rec_CandidateEntity>(lstModel, ConstantSql.hrm_rec_sp_get_EnrolledCandidates, UserLogin, ref status);
var listModel = new List<Rec_CandidateModel>();
if (listEntity != null)
{
var ObjResultInterview = new List<object>();
ObjResultInterview.AddRange(new object[24]);
ObjResultInterview[22] = 1;
ObjResultInterview[23] = int.MaxValue - 1;
var lstResultInterview = service.GetData<Rec_InterviewEntity>(ObjResultInterview, ConstantSql.hrm_rec_sp_get_Interview, UserLogin, ref status).ToList();
request.Page = 1;
foreach (var item in listEntity)
{
var resultInterviewByCandidate = lstResultInterview.Where(s => s.CandidateID == item.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (resultInterviewByCandidate != null)
{
item.Score1 = resultInterviewByCandidate.Score1;
item.Score2 = resultInterviewByCandidate.Score2;
item.Score3 = resultInterviewByCandidate.Score3;
item.ResultInterview = resultInterviewByCandidate.ResultInterviewView;
}
var newModle = (Rec_CandidateModel)typeof(Rec_CandidateModel).CreateInstance();
foreach (var property in item.GetType().GetProperties())
{
newModle.SetPropertyValue(property.Name, item.GetPropertyValue(property.Name));
}
listModel.Add(newModle);
}
var dataSourceResult = listModel.ToDataSourceResult(request);
if (listModel.FirstOrDefault().GetPropertyValue("TotalRow") != null)
{
dataSourceResult.Total = listModel.Count() <= 0 ? 0 : (int)listModel.FirstOrDefault().GetPropertyValue("TotalRow");
}
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
var listModelNull = new List<Rec_CandidateModel>();
ModelState.AddModelError("Id", status);
return Json(listModelNull.ToDataSourceResult(request, ModelState));
}
public ActionResult ExportEnrolledCandidateListByTemplate([DataSourceRequest] DataSourceRequest request, Rec_EnrolledCandidateSearchModel model)
{
var actionservices = new ActionService(UserLogin);
string status = string.Empty;
var isDataTable = false;
object obj = new Rec_CandidateModel();
var result = GetListData<Rec_CandidateModel, Rec_CandidateEntity, Rec_EnrolledCandidateSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_EnrolledCandidates, ref status);
if (model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = false;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Rec_CandidateModel",
OutPutPath = path,
// HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
var objInterview = new List<object>();
objInterview.AddRange(new object[2]);
objInterview[0] = 1;
objInterview[1] = int.MaxValue - 1;
var lstInterView = actionservices.GetData<Rec_InterviewModel>(objInterview, ConstantSql.hrm_rec_sp_get_InterviewDataReport, ref status).ToList();
if (model.ExportId != Guid.Empty)
{
foreach (var item in result)
{
var dataLevel1 = lstInterView.Where(s => s.CandidateID == item.ID && s.LevelInterview == 1).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel2 = lstInterView.Where(s => s.CandidateID == item.ID && s.LevelInterview == 2).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel3 = lstInterView.Where(s => s.CandidateID == item.ID && s.LevelInterview == 3).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel4 = lstInterView.Where(s => s.CandidateID == item.ID && s.LevelInterview == 4).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel5 = lstInterView.Where(s => s.CandidateID == item.ID && s.LevelInterview == 5).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (dataLevel1 != null)
{
item.Score1_1 = dataLevel1.Score1;
item.Score1_2 = dataLevel1.Score2;
item.Score1_3 = dataLevel1.Score3;
item.KQ1 = dataLevel1.ResultInterviewView;
item.LanguageCode1 = dataLevel1.LanguageCode;
item.DateInterview1 = dataLevel1.DateInterview;
}
if (dataLevel2 != null)
{
item.Score2_1 = dataLevel2.Score1;
item.Score2_2 = dataLevel2.Score2;
item.Score2_3 = dataLevel2.Score3;
item.KQ2 = dataLevel2.ResultInterviewView;
item.LanguageCode2 = dataLevel2.LanguageCode;
item.DateInterview2 = dataLevel2.DateInterview;
}
if (dataLevel3 != null)
{
item.Score3_1 = dataLevel3.Score1;
item.Score3_2 = dataLevel3.Score2;
item.Score3_3 = dataLevel3.Score3;
item.KQ3 = dataLevel3.ResultInterviewView;
item.LanguageCode3 = dataLevel3.LanguageCode;
item.DateInterview3 = dataLevel3.DateInterview;
}
if (dataLevel4 != null)
{
item.Score4_1 = dataLevel4.Score1;
item.Score4_2 = dataLevel4.Score2;
item.Score4_3 = dataLevel4.Score3;
item.KQ4 = dataLevel4.ResultInterviewView;
item.LanguageCode4 = dataLevel4.LanguageCode;
item.DateInterview4 = dataLevel4.DateInterview;
}
if (dataLevel5 != null)
{
item.Score5_1 = dataLevel5.Score1;
item.Score5_2 = dataLevel5.Score2;
item.Score5_3 = dataLevel5.Score3;
item.KQ5 = dataLevel5.ResultInterviewView;
item.LanguageCode5 = dataLevel5.LanguageCode;
item.DateInterview5 = dataLevel5.DateInterview;
}
var fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
return Json(fullPath);
}
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult ExportAllFailJobList([DataSourceRequest] DataSourceRequest request, Rec_EnrolledCandidateSearchModel model)
{
return ExportAllAndReturn<Rec_CandidateEntity, Rec_CandidateModel, Rec_EnrolledCandidateSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_CandidatesFailToGetTheJob);
}
