public List<Att_WorkdayEntity> ComputeWorkdayAdjust(ListQueryModel lstModel, string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
string status = string.Empty;
#region xử lý lấy lstProfileIds theo OrgStructureID
//List<Hre_ProfileEntity> lstProfile = new List<Hre_ProfileEntity>();
//List<Guid> lstProfileIDs = new List<Guid>();
//List<object> lstObj = new List<object>();
//lstObj.Add(search.OrgStructureID);
//lstObj.Add(null);
//lstObj.Add(null);
//if (search.ProfileName != null && search.OrgStructureID == null)
//{
//}
//else
//{
// lstProfile = GetData<Hre_ProfileEntity>(lstObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status);
// lstProfileIDs = lstProfile.Select(s => s.ID).ToList();
//}
#endregion
var lstWorkday = GetData<Att_WorkdayEntity>(lstModel, ConstantSql.hrm_att_sp_get_WorkDay, UserLogin, ref status);
SetStatusLeaveOnWorkday(lstWorkday, unitOfWork);
return lstWorkday;
}
}
public void NUnit_Domain_GetCatRelativeType(ListQueryModel model)
{
Cat_RelativeTypeServices service = new Cat_RelativeTypeServices();
//int count = service.Get().Count();
int count = service.GetAllUseEntity<Cat_RelativeType>(ref status).Count();
//NUnit.Framework.Assert.AreNotEqual(0, count);
Console.Write("Total Record: " + count);
}
public void NUnit_Domain_GetCatBanks(ListQueryModel model)
{
Cat_BankServices service = new Cat_BankServices();
string status = string.Empty;
int count = service.GetAllUseEntity<Cat_Bank>(ref status).Count();
//NUnit.Framework.Assert.AreNotEqual(0, count);
Console.Write("Total Record: " + count);
}
public ActionResult ExportHistoryApproveECLAIMByTemplate([DataSourceRequest] DataSourceRequest request, FIN_HistoryApproveECLAIMSearchModel model)
{
string status = string.Empty;
var baseService = new BaseService();
var isDataTable = false;
object obj = new FIN_HistoryApproveECLAIMModel();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = baseService.GetData<FIN_HistoryApproveECLAIMModel>(lstModel, ConstantSql.hrm_hr_sp_get_HistoryApprovedClaim, UserLogin, ref status);
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new FIN_HistoryApproveECLAIMModel(),
FileName = "FIN_HistoryApproveECLAIM",
OutPutPath = path,
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, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportDetailCard([DataSourceRequest] DataSourceRequest request, Can_ReportDetailCardSearchModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
if (Model.CanteenID != null) Model.CanteenIDs.Add(Model.CanteenID);
if (Model.CateringID != null) Model.CateringIDs.Add(Model.CateringID);
if (Model.LineID != null) Model.LineIDs.Add(Model.LineID);
var result = service.ReportDetailCard(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, From, To, Model.OrgStructureID);
var rs = result.Translate<Can_ReportDetailCardModel>();
#region xử lý xuất báo cáo
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, rs);
return Json(fullPath);
}
#endregion
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
return Json(rs.ToDataSourceResult(request));
}
public ActionResult GetReportAdjustmentMealAllowancePayment([DataSourceRequest] DataSourceRequest request, Can_ReportAdjustmentMealAllowancePaymentModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
var Actionservices = new ActionService(UserLogin);
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
List<Guid?> OrgIds = new List<Guid?>();
if (Model.OrgStructureID != null && Model.OrgStructureID.Count() > 0)
{
OrgIds = Model.OrgStructureID;
}
string strOrgIDs = Common.ListToString(OrgIds);
string profileName = string.Empty;
string codeEmp = string.Empty;
if (Model.ProfileName != string.Empty)
{
profileName = Model.ProfileName;
}
if (Model.CodeEmp != string.Empty)
{
codeEmp = Model.CodeEmp;
}
List<Guid> lstProfileIDs = new List<Guid>();
List<Object> Lstsearch = new List<object>();
Lstsearch.Add(strOrgIDs);
Lstsearch.Add(profileName);
Lstsearch.Add(codeEmp);
if (Model.OrgStructureID != null)
{
string status = string.Empty;
lstProfileIDs = Actionservices.GetData<Hre_ProfileIdEntity>(Lstsearch, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList();
}
var result = service.ReportAdjustmentMealAllowancePayment(From, To, lstProfileIDs);
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetProfileQuitList([DataSourceRequest] DataSourceRequest request, Hre_ProfileQuitSearchModel model)
{
var profileServices = new Hre_ProfileServices();
var service = new ActionService(UserLogin);
bool isGroup = profileServices.IsGroupByOrgProfileQuit();
if (isGroup == true)
{
#region Group theo DS phòng ban - DDF
var rptServices = new Hre_ReportServices();
string status = string.Empty;
var orgServices = new Cat_OrgStructureServices();
var lstObjOrg = new List<object>();
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(null);
lstObjOrg.Add(1);
lstObjOrg.Add(int.MaxValue - 1);
var lstOrg = service.GetData<Cat_OrgStructureEntity>(lstObjOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, ref status).ToList();
var orgTypeService = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(null);
lstObjOrgType.Add(null);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var lstOrgType = service.GetData<Cat_OrgStructureTypeEntity>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, ref status).ToList();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var lstEntity = service.GetData<Hre_ProfileEntity>(lstModel, ConstantSql.hrm_hr_sp_get_ProfileQuit, ref status);
var lstProfileEntity = new List<Hre_ProfileEntity>();
var lstProfileModel = new List<Hre_ProfileModel>();
if (lstEntity != null)
{
request.Page = 1;
foreach (var item in lstEntity)
{
var profileEntity = new Hre_ProfileEntity();
var orgName = new List<string>();
if (item.OrgStructureID != null)
{
orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID);
}
// orgName = rptServices.GetParentOrgName(lstOrg, lstOrgType, item.OrgStructureID);
if (orgName.Count == 0)
continue;
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
profileEntity = item.CopyData<Hre_ProfileEntity>();
profileEntity.Channel = orgName[2];
profileEntity.Region = orgName[1];
profileEntity.Area = orgName[0];
lstProfileEntity.Add(profileEntity);
}
lstProfileModel = lstProfileEntity.Translate<Hre_ProfileModel>();
var dataSourceResult = lstProfileModel.ToDataSourceResult(request);
if (lstProfileModel.FirstOrDefault().GetPropertyValue("TotalRow") != null)
{
dataSourceResult.Total = lstProfileModel.Count() <= 0 ? 0 : (int)lstProfileModel.FirstOrDefault().GetPropertyValue("TotalRow");
}
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
#endregion
}
return GetListDataAndReturn<Hre_ProfileModel, Hre_ProfileEntity, Hre_ProfileQuitSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileQuit);
}
public ActionResult ExportProfileIsBackList([DataSourceRequest] DataSourceRequest request, Hre_ProfileSearchIsBackListModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ProfileSearchIsBackListModel>(model, "Hre_ReportProfileIsBackList", ref message);
if (!checkValidate)
{
return Json(message);
}
#endregion
var service = new Hre_ReportServices();
var hrService = new Hre_ProfileServices();
string status = string.Empty;
object obj = new Hre_ProfileSearchIsBackListModel();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = GetListData<Hre_ReportProfileIsBackListModel, Hre_ReportProfileIsBackListEntity, Hre_ProfileSearchIsBackListModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileIsBackList, ref status);
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_ReportProfileIsBackListModel(),
FileName = "Hre_ReportProfileIsBackList",
OutPutPath = path,
//HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = false
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportID, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult ExportWorkHistoryByListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_WorkHistorySearchModel model)
{
string status = string.Empty;
var actionService = new ActionService(UserLogin);
var isDataTable = false;
object obj = new Hre_ProfileModel();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = actionService.GetData<Hre_WorkHistoryModel>(lstModel, ConstantSql.hrm_hr_sp_get_WorkHistory, ref status);
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateFrom != null ? model.DateFrom : DateTime.Now };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateTo != null ? model.DateTo : DateTime.Now };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = new Hre_WorkHistoryModel(),
FileName = "Hre_WorkHistory",
OutPutPath = path,
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, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportSummaryDependantList([DataSourceRequest] DataSourceRequest request, Hre_ReportSummaryDependantModel model)
{
string status = string.Empty;
var service = new BaseService();
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "MonthOfExpiry", Value = model.MonthOfExpiry };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1 };
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var ReportServices = new Hre_ReportServices();
var actionService = new ActionService(UserLogin);
List<object> paraDependant = new List<object>();
paraDependant.AddRange(new object[11]);
paraDependant[0] = model.ProfileName;
paraDependant[1] = model.CodeEmp;
paraDependant[2] = model.OrgStructureID;
paraDependant[3] = model.JobTitleID;
paraDependant[4] = model.PositionID;
paraDependant[5] = model.DependantName;
paraDependant[6] = model.RelationID;
paraDependant[7] = null;
paraDependant[8] = null;
paraDependant[9] = 1;
paraDependant[10] = int.MaxValue - 1;
var lstDependant = actionService.GetData<Hre_DependantEntity>(paraDependant, ConstantSql.hrm_hr_sp_get_Dependant, ref status);
if (model.MonthOfExpiry != null && lstDependant != null)
{
lstDependant = lstDependant.Where(s => (s.MonthOfEffect <= model.MonthOfExpiry && model.MonthOfExpiry <= s.MonthOfExpiry)
|| (s.MonthOfEffect <= model.MonthOfExpiry && s.MonthOfExpiry == null)).ToList();
}
var result = ReportServices.GetReportSummaryDependant(lstDependant, model.IsCreateTemplate);
var isDataTable = false;
object obj = new DataTable();
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportSummaryDependantEntity",
OutPutPath = path,
HeaderInfo = listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = isDataTable
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#region Validate
string message = string.Empty;
var checkValidate = ValidatorService.OnValidateData<Hre_ReportSummaryDependantModel>(model, "Hre_ReportSummaryDependant", ref message);
if (!checkValidate)
{
return Json(message, JsonRequestBehavior.AllowGet);
}
#endregion
if (model.ExportId != Guid.Empty)
{
string fullPath = "";
if (model.MonthOfExpiry != null)
{
fullPath = ExportService.Export(model.ExportId, result, listHeaderInfo, model.ExportType);
}
else
{
fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
}
return Json(fullPath);
}
#region mapping dataTable to dataList
List<Hre_ReportSummaryDependantModel> dataList = new List<Hre_ReportSummaryDependantModel>();
Hre_ReportSummaryDependantModel aTSource = null;
if (result.Rows.Count > 0)
{
const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
var objFieldNames = (from PropertyInfo aProp in typeof(Hre_ReportSummaryDependantModel).GetProperties(flags)
select new
{
Name = aProp.Name,
Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
}).ToList();
var dataTblFieldNames = (from DataColumn aHeader in result.Columns
select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();
var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();
foreach (DataRow dataRow in result.AsEnumerable().ToList())
{
aTSource = new Hre_ReportSummaryDependantModel();
foreach (var aField in commonFields)
{
PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);
if (dataRow[aField.Name] == DBNull.Value)
continue;
propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);
}
dataList.Add(aTSource);
}
}
#endregion
return Json(dataList.ToDataSourceResult(request));
}
public ActionResult GetCandidateList([DataSourceRequest] DataSourceRequest request, Rec_CandidateSearchModel model)
{
if (model.Evaluated == HRM.Infrastructure.Utilities.EnumDropDown.StatusHealth.E_ACCEPT.ToString())
{
model.IsEvaluated = true;
}
else if (model.Evaluated == HRM.Infrastructure.Utilities.EnumDropDown.StatusHealth.E_NOTACCEPT.ToString())
{
model.IsEvaluated = false;
}
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_Candidate, UserLogin, ref status);
var listModel = new List<Rec_CandidateModel>();
if (listEntity != null)
{
request.Page = 1;
foreach (var item in listEntity)
{
if (item.ReasonFailFilter != null)
{
List<string> lsititem = item.ReasonFailFilter.Split(',').ToList();
string Stringresult = string.Empty;
foreach (var itemstring in lsititem)
{
Stringresult += itemstring.TranslateString() + ',';
}
Stringresult = Stringresult.Substring(0, Stringresult.Length - 1);
item.ReasonFailFilter = Stringresult;
}
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 ExportAllInterviewDetailListNew([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);
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();
var lstCandidateHistory = new List<Rec_RecruitmentHistoryEntity>();
int _total = lstCandidateIDS.Count;
int _totalPage = _total / 100 + 1;
int _pageSize = 100;
for (int _page = 1; _page <= _totalPage; _page++)
{
int _skip = _pageSize * (_page - 1);
var _listCurrenPage = lstCandidateIDS.Skip(_skip).Take(_pageSize).ToList();
string _strselectedIDs = Common.DotNetToOracle(string.Join(",", _listCurrenPage));
var lstRecruitmentHistory = baseService.GetData<Rec_RecruitmentHistoryEntity>(_strselectedIDs, ConstantSql.hrm_rec_sp_get_RecHisByListCandidateID, UserLogin, ref status).ToList();
if (lstRecruitmentHistory != null && lstRecruitmentHistory.Count > 0)
{
lstCandidateHistory.AddRange(lstRecruitmentHistory);
}
}
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();
if (status == NotificationType.Success.ToString())
{
status = ExportService.Export(resultInterviewCampaignDetail, model.GetPropertyValue("ValueFields").TryGetValue<string>().Split(','));
}
return Json(status);
}
public ActionResult GetIntervieCampaignDetailList([DataSourceRequest] DataSourceRequest request, Rec_InterviewCampaignDetailSearchModel model)
{
List<Rec_InterviewCampaignDetailModel> resultInterviewCampaignDetail = new List<Rec_InterviewCampaignDetailModel>();
string status = string.Empty;
var baseService = new BaseService();
var actionService = new ActionService(UserLogin);
List<object> objs = new List<object>();
List<object> objshis = new List<object>();
var InterviewServices = new Rec_InterviewCampaignDetailServices();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
int? level = (model != null && model.LevelInterview != 0) ? model.LevelInterview : null;
List<object> lstModels = new List<object>();
lstModels.AddRange(new object[16]);
lstModels[0] = model.CandidateName;
lstModels[1] = model.DateFrom;
lstModels[2] = model.DateTo;
lstModels[3] = model.CodeCandidate;
lstModels[4] = model.RankID;
lstModels[5] = model.OrgStructureID;
lstModels[6] = model.JobVacancyID;
lstModels[7] = model.PositionID;
lstModels[8] = level;
lstModels[13] = model.WorkPlaceID;
lstModels[14] = 1;
lstModels[15] = Int32.MaxValue - 1;
var result = actionService.GetData<Rec_InterviewCampaignDetailModel>(lstModels, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetail, 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();
var lstCandidateHistory = new List<Rec_RecruitmentHistoryEntity>();
int _total = lstCandidateIDS.Count;
int _totalPage = _total / 100 + 1;
int _pageSize = 100;
for (int _page = 1; _page <= _totalPage; _page++)
{
int _skip = _pageSize * (_page - 1);
var _listCurrenPage = lstCandidateIDS.Skip(_skip).Take(_pageSize).ToList();
string _strselectedIDs = Common.DotNetToOracle(string.Join(",", _listCurrenPage));
var lstRecruitmentHistory = baseService.GetData<Rec_RecruitmentHistoryEntity>(_strselectedIDs, ConstantSql.hrm_rec_sp_get_RecHisByListCandidateID, UserLogin, ref status).ToList();
if (lstRecruitmentHistory != null && lstRecruitmentHistory.Count > 0)
{
lstCandidateHistory.AddRange(lstRecruitmentHistory);
}
}
foreach (var item in result)
{
bool IsAdd = false;
//var IlInterviewcampaugnDetail = result.Where(s => s.CandidateID == item.CandidateID).ToList();
var ObjHisCandidate = lstCandidateHistory.Where(s => s.ID == item.RecruitmentHistoryID).FirstOrDefault();
if (ObjHisCandidate == null)
{
continue;
}
if (item.LevelInterview == null)
{
IsAdd = true;
}
Rec_JobVacancyEntity entityJobVacancy = null;
if (ObjHisCandidate != null && ObjHisCandidate.JobVacancyID != Guid.Empty && ObjHisCandidate.JobVacancyID != null)
{
entityJobVacancy = actionService.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;
}
else
{
item.LevelInterview = ObjHisCandidate.LevelInterview + 1;
}
if (IsAdd == true)
{
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);
}
var objInterview = new List<object>();
objInterview.AddRange(new object[2]);
objInterview[0] = 1;
objInterview[1] = int.MaxValue - 1;
var lstInterView = baseService.GetData<Rec_InterviewModel>(objInterview, ConstantSql.hrm_rec_sp_get_InterviewDataReport, UserLogin, ref status).ToList();
if (model.ExportId != Guid.Empty)
{
foreach (var item in resultInterviewCampaignDetail)
{
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, resultInterviewCampaignDetail, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
// return Json(resultInterviewCampaignDetail.ToDataSourceResult(request));
return Json(resultInterviewCampaignDetail.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
//var result = GetListDataAndReturn<Rec_InterviewCampaignDetailModel, Rec_InterviewCampaignDetailEntity, Rec_InterviewCampaignDetailSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetail);
//return result;
}
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 ExportAllWaitingInterviewList([DataSourceRequest] DataSourceRequest request, Rec_WaitingInterviewSearchModel model)
{
string status = string.Empty;
var baseService = new BaseService();
ActionService service = new ActionService(UserLogin);
List<object> objs = new List<object>();
List<Rec_RecruitmentHistoryModel> resultRecruitmentHistory = new List<Rec_RecruitmentHistoryModel>();
Rec_RecruitmentHistoryModel ObjRecruitmentHistory = null;
var InterviewServices = new Rec_InterviewServices();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var lstWaitingInterview = baseService.GetData<Rec_RecruitmentHistoryModel>(lstModel, ConstantSql.hrm_rec_sp_get_WaitingInterList, UserLogin, ref status);
if (lstWaitingInterview == null || lstWaitingInterview.Count == 0)
{
return null;
}
lstWaitingInterview = lstWaitingInterview.Where(s => s.JobVacancyID != null).ToList();
var lstrechisids = lstWaitingInterview.Select(s => s.ID).ToList();
var resultCampaignDetail = new List<Rec_InterviewCampaignDetailModel>();
int _total = lstrechisids.Count;
int _totalPage = _total / 100 + 1;
int _pageSize = 100;
for (int _page = 1; _page <= _totalPage; _page++)
{
int _skip = _pageSize * (_page - 1);
var _listCurrenPage = lstrechisids.Skip(_skip).Take(_pageSize).ToList();
string _strselectedIDs = Common.DotNetToOracle(string.Join(",", _listCurrenPage));
var lstCampaignDetail = baseService.GetData<Rec_InterviewCampaignDetailModel>(_strselectedIDs, ConstantSql.hrm_rec_sp_get_InCamDetailByLstRechisIDs, UserLogin, ref status).ToList();
if (lstCampaignDetail != null && lstCampaignDetail.Count > 0)
{
resultCampaignDetail.AddRange(lstCampaignDetail);
}
}
var lstjobvacancyids = lstWaitingInterview.Where(s => s.JobVacancyID != null).Select(s => s.JobVacancyID).Distinct().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 = baseService.GetData<Rec_JobVacancyEntity>(Common.DotNetToOracle(strJobVacancyIds), ConstantSql.hrm_rec_sp_get_JobVacancyByIds, UserLogin, ref status);
foreach (var his in lstWaitingInterview)
{
ObjRecruitmentHistory = new Rec_RecruitmentHistoryModel();
var lstresultCampaignDetail = resultCampaignDetail.Where(s => s.RecruitmentHistoryID == his.ID && s.LevelInterview == null).ToList();
if (his.JobVacancyID.HasValue)
{
var entityJobVacancy = lstJobVacancy.Where(s => s.ID == his.JobVacancyID).FirstOrDefault();
if (his.LevelInterview == null)
his.LevelInterview = 0;
if (entityJobVacancy != null && his.LevelInterview != entityJobVacancy.NoLevelInterview && lstresultCampaignDetail.Count == 0 && his.Status != HRM.Infrastructure.Utilities.Interview.E_PASS.ToString())
{
ObjRecruitmentHistory = his;
resultRecruitmentHistory.Add(ObjRecruitmentHistory);
}
}
}
status = ExportService.Export(resultRecruitmentHistory, model.GetPropertyValue("ValueFields").TryGetValue<string>().Split(','));
return Json(status);
}
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 ActionResult GetReportProfileIsWaitingStopWorkingList([DataSourceRequest] DataSourceRequest request, Hre_ReportProfileWaitingStopWorkingSearchModel model)
{
string status = string.Empty;
//var isDataTable = false;
var actionService = new ActionService(UserLogin);
//object obj = new Hre_ProfileModel();
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 };
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
if ((model.IsCreateTemplate == true && model.IsCreateTemplateForDynamicGrid == true) || model.ExportId != Guid.Empty)
{
lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
}
var listProfile = actionService.GetData<Hre_ProfileEntity>(lstModel, ConstantSql.hrm_hr_sp_get_ProfileWaitingStopWoking, ref status);
var ReportServices = new Hre_ReportServices();
var result = ReportServices.GetReportProfileWaitingStopWorking(listProfile);
var isDataTable = false;
object obj = new DataTable();
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ReportProfileWaitingStopWorkingEntity",
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 = string.Empty;
if (headerInfo1.Value == null || headerInfo2.Value == null)
{
fullPath = ExportService.Export(model.ExportId, result, null, model.ExportType);
}
else
{
fullPath = ExportService.Export(model.ExportId, result, listHeaderInfo, model.ExportType);
}
return Json(fullPath);
}
//return new JsonResult() { Data = result.ToDataSourceResult(request), MaxJsonLength = int.MaxValue };
#region mapping dataTable to dataList
List<Hre_ReportProfileWaitingStopWorkingModel> dataList = new List<Hre_ReportProfileWaitingStopWorkingModel>();
Hre_ReportProfileWaitingStopWorkingModel aTSource = null;
if (result.Rows.Count > 0)
{
const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
var objFieldNames = (from PropertyInfo aProp in typeof(Hre_ReportProfileWaitingStopWorkingModel).GetProperties(flags)
select new
{
Name = aProp.Name,
Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
}).ToList();
var dataTblFieldNames = (from DataColumn aHeader in result.Columns
select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();
var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();
foreach (DataRow dataRow in result.AsEnumerable().ToList())
{
aTSource = new Hre_ReportProfileWaitingStopWorkingModel();
foreach (var aField in commonFields)
{
PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);
if (dataRow[aField.Name] == DBNull.Value)
continue;
propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);
}
dataList.Add(aTSource);
}
}
#endregion
return Json(dataList.ToDataSourceResult(request));
}
public ActionResult ExportAllCandidateList([DataSourceRequest] DataSourceRequest request, Rec_CandidateSearchModel model)
{
string status = string.Empty;
var service = new BaseService();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = int.MaxValue - 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var listEntity = service.GetData<Rec_CandidateEntity>(lstModel, ConstantSql.hrm_rec_sp_get_Candidate, UserLogin, ref status);
if (model.Evaluated == HRM.Infrastructure.Utilities.EnumDropDown.StatusHealth.E_ACCEPT.ToString())
{
listEntity = listEntity.Where(s => s.PassFilterResume == true).ToList();
}
if (model.Evaluated == HRM.Infrastructure.Utilities.EnumDropDown.StatusHealth.E_NOTACCEPT.ToString())
{
listEntity = listEntity.Where(s => s.PassFilterResume == false).ToList();
}
var listModel = new List<Rec_CandidateModel>();
if (listEntity != null)
{
foreach (var item in listEntity)
{
if (item.ReasonFailFilter != null)
{
List<string> lsititem = item.ReasonFailFilter.Split(',').ToList();
string Stringresult = string.Empty;
foreach (var itemstring in lsititem)
{
Stringresult += itemstring.TranslateString() + ',';
}
Stringresult = Stringresult.Substring(0, Stringresult.Length - 1);
item.ReasonFailFilter = Stringresult;
}
}
}
status = ExportService.Export(listEntity, model.GetPropertyValue("ValueFields").TryGetValue<string>().Split(','));
return Json(status);
}
public ActionResult GetApproverList([DataSourceRequest] DataSourceRequest request, FIN_ApproverECLAIMSearchModel model)
{
if (model != null)
{
model.ProfileID = Common.DotNetToOracle(model.ProfileID);
}
//#region lay ds approver hiển thị trên 1 dòng ứng với profile
var actionService = new ActionService(UserLogin);
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = 1,
PageSize = int.MaxValue - 1,//request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var status = string.Empty;
var listEntity = actionService.GetData<FIN_ApproverECLAIMEntity>(lstModel, ConstantSql.hrm_fin_sp_get_ApproverECLAIM, ref status).ToList();
if (model.OrderNo.HasValue)
{
listEntity = listEntity.Where(s => s.OrderNo != null && s.OrderNo.Value == model.OrderNo.Value).ToList();
}
if (listEntity != null)
{
// request.Page = 1;
//var listModel = listEntity.Translate<FIN_ApproverECLAIMModel>();
var listModel = listEntity;
var profileIds = listModel.GroupBy(p => new { p.ProfileID, p.ApprovedType }).ToList();
var approverReturn = new List<FIN_ApproverECLAIMModel>();
var approverNames = string.Empty;
foreach (var profileId in profileIds)
{
var approvers = listModel.Where(p => p.ProfileID == profileId.Key.ProfileID && p.ApprovedType == profileId.Key.ApprovedType).OrderBy(p => p.OrderNo).ToList();
var approver = approvers.FirstOrDefault();
approverNames = string.Empty;
foreach (var finApproverModel in approvers)
{
approverNames += finApproverModel.OrderNo + " - " + finApproverModel.ApprovedName + " , ";
}
var fin = new FIN_ApproverECLAIMModel();
if (approver != null)
{
fin.ID = approver.ID;
fin.ProfileName = approver.ProfileName;
fin.ApprovedType = approver.ApprovedType;
fin.ApprovedTypeView = approver.ApprovedTypeView;
fin.ProfileID = profileId.Key.ProfileID;
}
fin.ApprovedName = approverNames.Substring(0, approverNames.Length - 2);
approverReturn.Add(fin);
}
var dataSourceResult = approverReturn.ToDataSourceResult(request);
dataSourceResult.Total = approverReturn.Count();
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
var listModelNull = new List<FIN_ApproverECLAIMModel>();
ModelState.AddModelError("Id", status);
return Json(listModelNull.ToDataSourceResult(request, ModelState));
}
//[Tho.Bui] - Load theo lich su ung vien
public ActionResult GetWaitingInterList([DataSourceRequest] DataSourceRequest request, Rec_WaitingInterviewSearchModel model)
{
string status = string.Empty;
var baseService = new BaseService();
ActionService service = new ActionService(UserLogin);
List<object> objs = new List<object>();
List<Rec_RecruitmentHistoryModel> resultRecruitmentHistory = new List<Rec_RecruitmentHistoryModel>();
Rec_RecruitmentHistoryModel ObjRecruitmentHistory = null;
var InterviewServices = new Rec_InterviewServices();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var lstWaitingInterview = baseService.GetData<Rec_RecruitmentHistoryModel>(lstModel, ConstantSql.hrm_rec_sp_get_WaitingInterList, UserLogin, ref status);
if (lstWaitingInterview == null || lstWaitingInterview.Count == 0)
{
return null;
}
lstWaitingInterview = lstWaitingInterview.Where(s => s.JobVacancyID != null).ToList();
var lstrechisids = lstWaitingInterview.Select(s => s.ID).Distinct().ToList();
var objCampaignDetail = new List<object>();
objCampaignDetail.AddRange(new object[16]);
objCampaignDetail[14] = 1;
objCampaignDetail[15] = int.MaxValue - 1;
var resultCampaignDetail = baseService.GetData<Rec_InterviewCampaignDetailModel>(objCampaignDetail, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetail, UserLogin, ref status);
resultCampaignDetail = resultCampaignDetail.Where(s => s.RecruitmentHistoryID != null && lstrechisids.Contains(s.RecruitmentHistoryID.Value)).ToList();
var lstjobvacancyids = lstWaitingInterview.Where(s => s.JobVacancyID != null).Select(s => s.JobVacancyID).Distinct().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 = baseService.GetData<Rec_JobVacancyEntity>(Common.DotNetToOracle(strJobVacancyIds), ConstantSql.hrm_rec_sp_get_JobVacancyByIds, UserLogin, ref status);
#region Kết quả là rớt hoặc vỏng phỏng vấn = cuối thì KHÔNG load vào danh sách chờ phỏng vấn
foreach (var his in lstWaitingInterview)
{
ObjRecruitmentHistory = new Rec_RecruitmentHistoryModel();
var lstresultCampaignDetail = resultCampaignDetail.Where(s => s.RecruitmentHistoryID == his.ID && s.LevelInterview == null).ToList();
if (his.JobVacancyID.HasValue)
{
var entityJobVacancy = lstJobVacancy.Where(s => s.ID == his.JobVacancyID).FirstOrDefault();
if (entityJobVacancy != null && his.LevelInterview != entityJobVacancy.NoLevelInterview && lstresultCampaignDetail.Count == 0 && his.Status != HRM.Infrastructure.Utilities.Interview.E_PASS.ToString())
{
ObjRecruitmentHistory = his;
resultRecruitmentHistory.Add(ObjRecruitmentHistory);
}
}
}
#endregion
return Json(resultRecruitmentHistory.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public ActionResult ExportProfileAllListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_ProfileAllSearchModel model)
{
string status = string.Empty;
var isDataTable = false;
var service = new BaseService();
object obj = new Hre_ProfileModel();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = GetListData<Hre_ProfileModel, Hre_ProfileEntity, Hre_ProfileAllSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ProfileAll, 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 = "Hre_ProfileModel",
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, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetRecruitmentCampaignList([DataSourceRequest] DataSourceRequest request, Rec_RecruitmentCampaignSearchModel model)
{
//return GetListDataAndReturn<Rec_RecruitmentCampaignModel, Rec_RecruitmentCampaignEntity, Rec_RecruitmentCampaignSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_RecruitmentCampaign);
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_RecruitmentCampaignEntity>(lstModel, ConstantSql.hrm_rec_sp_get_RecruitmentCampaign, UserLogin, ref status);
List<object> lstObjCosDetail = new List<object>();
lstObjCosDetail.Add(1);
lstObjCosDetail.Add(int.MaxValue - 1);
var listRecCosDetail = service.GetData<Rec_RecCostDetailEntity>(lstObjCosDetail, ConstantSql.hrm_rec_sp_get_RecCosDetail, UserLogin,ref status);
var listModel = new List<Rec_RecruitmentCampaignModel>();
if (listEntity != null)
{
request.Page = 1;
foreach (var item in listEntity)
{
var lstCosdetailByRecruimentcampain = listRecCosDetail.Where(s => s.RecCampaignID == item.ID).Sum(s => s.Amount);
if (lstCosdetailByRecruimentcampain != null && lstCosdetailByRecruimentcampain != 0)
{
item.Budget = lstCosdetailByRecruimentcampain;
}
var newModle = (Rec_RecruitmentCampaignModel)typeof(Rec_RecruitmentCampaignModel).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_RecruitmentCampaignModel>();
ModelState.AddModelError("Id", status);
return Json(listModelNull.ToDataSourceResult(request, ModelState));
}
public ActionResult ExportPersionalInformation([DataSourceRequest] DataSourceRequest request, Hre_PersionalInfoSearchModel model)
{
var service = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
var isDataTable = false;
object obj = new DataTable();
var result = service.GetPersionalInfo(model.id, UserLogin, model.IsCreateTemplate);
if (model.IsCreateTemplateForDynamicGrid)
{
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_PersionalInformationModel",
OutPutPath = path,
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, result, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetWaitingInterviewList([DataSourceRequest] DataSourceRequest request, Rec_WaitingInterviewSearchModel model)
{
string status = string.Empty;
var baseService = new BaseService();
ActionService service = new ActionService(UserLogin);
List<object> objs = new List<object>();
List<Rec_CandidateModel> resultCandidate = new List<Rec_CandidateModel>();
Rec_CandidateModel ObjCandidate = null;
var InterviewServices = new Rec_InterviewServices();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var result = baseService.GetData<Rec_CandidateModel>(lstModel, ConstantSql.hrm_rec_sp_get_WaitingInterviewList, UserLogin, ref status);
#region Kết quả là rớt hoặc vỏng phỏng vấn = cuối thì KHÔNG load vào danh sách chờ phỏng vấn
result = result.Where(s => s.Status != HRM.Infrastructure.Utilities.Interview.E_FAIL.ToString()).ToList();
foreach (var item in result)
{
ObjCandidate = new Rec_CandidateModel();
objs = new List<object>();
objs.Add(item.ID);
objs.Add(1);
objs.Add(10000);
//var resultInterview = baseService.GetData<Rec_InterviewModel>(objs, ConstantSql.hrm_rec_sp_get_InterviewByCandidateID, ref status);
//Danh sach ke hoach cua ung vien
var resultCampaignDetail = baseService.GetData<Rec_InterviewCampaignDetailModel>(objs, ConstantSql.hrm_rec_sp_get_InCamDetailByCddId, UserLogin, ref status).ToList();
if (item.JobVacancyID.HasValue)
{
var entityJobVacancy = service.GetByIdUseStore<Rec_JobVacancyEntity>(item.JobVacancyID.Value, ConstantSql.hrm_rec_sp_get_JobVacancyId, ref status);
if (item.LevelInterview == null)
item.LevelInterview = 0;
if (item.LevelInterview != entityJobVacancy.NoLevelInterview && item.LevelInterview == resultCampaignDetail.Count)
{
ObjCandidate = item;
resultCandidate.Add(ObjCandidate);
}
}
}
#endregion
return Json(resultCandidate.ToDataSourceResult(request), JsonRequestBehavior.AllowGet);
}
public ActionResult GetReportMealTimeSummary([DataSourceRequest] DataSourceRequest request, Can_ReportMealTimeSummaryModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = DateTime.Now.AddMonths(-1);
DateTime To = DateTime.Now;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
string status = string.Empty;
var result = service.ReportMealTimeSummary(Model.CateringIDs,
Model.CanteenIDs,
Model.LineIDs,
From,
To,
Model.OrgIDs);
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
//var result = GetListDataAndReturn<Rec_CandidateModel, Rec_CandidateEntity, Rec_CandidateSearchModel>(request, model, ConstantSql.hrm_rec_sp_get_WaitingInterviewList);
//return result;
//}
public ActionResult ExportWatingInterviewByTemplate([DataSourceRequest] DataSourceRequest request, Rec_WaitingInterviewSearchModel model)
{
string status = string.Empty;
var baseService = new BaseService();
ActionService service = new ActionService(UserLogin);
List<object> objs = new List<object>();
List<Rec_RecruitmentHistoryModel> resultRecruitmentHistory = new List<Rec_RecruitmentHistoryModel>();
Rec_RecruitmentHistoryModel ObjRecruitmentHistory = null;
var InterviewServices = new Rec_InterviewServices();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
var lstWaitingInterview = baseService.GetData<Rec_RecruitmentHistoryModel>(lstModel, ConstantSql.hrm_rec_sp_get_WaitingInterList, UserLogin, ref status);
if (lstWaitingInterview == null || lstWaitingInterview.Count == 0)
{
return null;
}
lstWaitingInterview = lstWaitingInterview.Where(s => s.JobVacancyID != null).ToList();
var lstrechisids = lstWaitingInterview.Select(s => s.ID).Distinct().ToList();
var objCampaignDetail = new List<object>();
objCampaignDetail.AddRange(new object[16]);
objCampaignDetail[14] = 1;
objCampaignDetail[15] = int.MaxValue - 1;
var resultCampaignDetail = baseService.GetData<Rec_InterviewCampaignDetailModel>(objCampaignDetail, ConstantSql.hrm_rec_sp_get_InterviewCampaignDetail, UserLogin, ref status);
resultCampaignDetail = resultCampaignDetail.Where(s => s.RecruitmentHistoryID != null && lstrechisids.Contains(s.RecruitmentHistoryID.Value)).ToList();
var lstjobvacancyids = lstWaitingInterview.Where(s => s.JobVacancyID != null).Select(s => s.JobVacancyID).Distinct().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 = baseService.GetData<Rec_JobVacancyEntity>(Common.DotNetToOracle(strJobVacancyIds), ConstantSql.hrm_rec_sp_get_JobVacancyByIds, UserLogin, ref status);
#region Kết quả là rớt hoặc vỏng phỏng vấn = cuối thì KHÔNG load vào danh sách chờ phỏng vấn
foreach (var his in lstWaitingInterview)
{
ObjRecruitmentHistory = new Rec_RecruitmentHistoryModel();
var lstresultCampaignDetail = resultCampaignDetail.Where(s => s.RecruitmentHistoryID == his.ID && s.LevelInterview == null).ToList();
if (his.JobVacancyID.HasValue)
{
var entityJobVacancy = lstJobVacancy.Where(s => s.ID == his.JobVacancyID).FirstOrDefault();
if (entityJobVacancy != null && his.LevelInterview != entityJobVacancy.NoLevelInterview && lstresultCampaignDetail.Count == 0 && his.Status != HRM.Infrastructure.Utilities.Interview.E_PASS.ToString())
{
ObjRecruitmentHistory = his;
resultRecruitmentHistory.Add(ObjRecruitmentHistory);
}
}
}
#endregion
var isDataTable = false;
object obj = new Rec_RecruitmentHistoryModel();
if (model.IsCreateTemplateForDynamicGrid)
{
obj = resultRecruitmentHistory;
isDataTable = false;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Rec_RecruitmentHistoryModel",
OutPutPath = path,
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 = baseService.GetData<Rec_InterviewModel>(objInterview, ConstantSql.hrm_rec_sp_get_InterviewDataReport, UserLogin, ref status).ToList();
foreach (var item in resultRecruitmentHistory)
{
if (lstInterView.Count > 0)
{
var dataLevel1 = lstInterView.Where(s => s.CandidateID == item.CandidateID && s.LevelInterview == 1).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel2 = lstInterView.Where(s => s.CandidateID == item.CandidateID && s.LevelInterview == 2).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel3 = lstInterView.Where(s => s.CandidateID == item.CandidateID && s.LevelInterview == 3).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel4 = lstInterView.Where(s => s.CandidateID == item.CandidateID && s.LevelInterview == 4).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dataLevel5 = lstInterView.Where(s => s.CandidateID == item.CandidateID && 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;
}
}
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, resultRecruitmentHistory, null, model.ExportType);
return Json(fullPath);
}
return Json(resultRecruitmentHistory.ToDataSourceResult(request));
}
public ActionResult GetReportMultiSlideCard([DataSourceRequest] DataSourceRequest request, Can_ReportMultiSlideCardSearchModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
var Actionservices = new ActionService(UserLogin);
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
List<Guid?> OrgIds = new List<Guid?>();
if (Model.OrgStructureID != null && Model.OrgStructureID.Count() > 0)
{
OrgIds = Model.OrgStructureID;
}
string strOrgIDs = Common.ListToString(OrgIds);
string status = string.Empty;
string profilename = null;
string codeemp = null;
List<object> objectsearch = new List<object>();
objectsearch.Add(strOrgIDs);
objectsearch.Add(profilename);
objectsearch.Add(codeemp);
List<Guid> lstProfileIDs = Actionservices.GetData<Hre_ProfileIdEntity>(objectsearch, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).Select(s => s.ID).ToList();
var result = service.ReportMultiSlideCard(Model.CateringID, Model.CanteenID, Model.LineID, Model.WorkPlaceID, From, To, lstProfileIDs, Model.IsIncludeQuitEmp);
var rs = result.Translate<Can_ReportMultiSlideCardModel>();
#region xử lý xuất báo cáo
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, rs);
return Json(fullPath);
}
#endregion
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
return Json(rs.ToDataSourceResult(request));
}
public void NUnit_CutOffDuration_Domain_Get(ListQueryModel model)
{
Att_CutOffDurationServices service = new Att_CutOffDurationServices();
var repo = service.GetDataCondition<Att_CutOffDurationEntity>(model, ConstantSql.hrm_att_sp_get_CutOffDurations, ref status);
Console.Write("Total Record: " + repo.Count());
}
public ActionResult GetReportSumaryReturnMoneyEat([DataSourceRequest] DataSourceRequest request, Can_ReportSumaryReturnMoneyEatSearchModel Model)
{
var service = new Can_ReportServices();
var hrService = new Hre_ProfileServices();
ListQueryModel lstModel = new ListQueryModel
{
PageIndex = request.Page,
PageSize = request.PageSize,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request)
};
DateTime From = SqlDateTime.MinValue.Value;
DateTime To = SqlDateTime.MaxValue.Value;
if (Model.DateFrom != null)
{
From = Model.DateFrom.Value;
}
if (Model.DateTo != null)
{
To = Model.DateTo.Value;
}
var result = service.GetReportSumaryReturnMoneyEat(Model.CateringIDs, Model.CanteenIDs, Model.LineIDs, Model.WorkPlaceID, From, To, Model.OrgStructureID, Model.CodeEmp, Model.IsIncludeQuitEmp);
#region xử lý xuất báo cáo
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, result);
return Json(fullPath);
}
#endregion
request.Page = 1;
var dataSourceResult = result.ToDataSourceResult(request);
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetReportInsuranceList([DataSourceRequest] DataSourceRequest request, Ins_ReportInsuranceTotalSearchModel model)
{
string status = string.Empty;
//var isDataTable = false;
var service = new BaseService();
//object obj = new Hre_ProfileModel();
ListQueryModel lstModel = new ListQueryModel
{
PageSize = int.MaxValue - 1,
PageIndex = 1,
Filters = ExtractFilterAttributes(request),
Sorts = ExtractSortAttributes(request),
AdvanceFilters = ExtractAdvanceFilterAttributes(model)
};
// List<Hre_ProfileEntity> listProfile = service.GetData<Hre_ProfileEntity>(lstModel, ConstantSql.hrm_sal_sp_getdata_Profile, ref status);
var ReportServices = new Ins_InsuranceReportServices();
DateTime _DateFrom = DateTime.MinValue;
DateTime _DateTo = DateTime.MaxValue;
if (model != null && model.DateFrom != null)
{
_DateFrom = model.DateFrom.Value;
}
if (model != null && model.DateTo != null)
{
_DateTo = model.DateTo.Value;
}
var result = ReportServices.BC_INSURANCETOTAL(_DateFrom, _DateTo, model.OrgStructureIDs, model.SocialInsPlaceIDs, UserLogin);
var isDataTable = false;
object obj = new DataTable();
if (model.IsCreateTemplateForDynamicGrid)
{
var col = result.Columns.Count;
result.Columns.RemoveAt(col - 1);
obj = result;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Ins_ReportInsuranceTotalEntity",
OutPutPath = path,
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, result, null, model.ExportType);
return Json(fullPath);
}
//return new JsonResult() { Data = result.ToDataSourceResult(request), MaxJsonLength = int.MaxValue };
#region mapping dataTable to dataList
List<Ins_ReportInsuranceTotalModel> dataList = new List<Ins_ReportInsuranceTotalModel>();
Ins_ReportInsuranceTotalModel aTSource = null;
if (result.Rows.Count > 0)
{
const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance | BindingFlags.NonPublic;
var objFieldNames = (from PropertyInfo aProp in typeof(Ins_ReportInsuranceTotalModel).GetProperties(flags)
select new
{
Name = aProp.Name,
Type = Nullable.GetUnderlyingType(aProp.PropertyType) ?? aProp.PropertyType
}).ToList();
var dataTblFieldNames = (from DataColumn aHeader in result.Columns
select new { Name = aHeader.ColumnName, Type = aHeader.DataType }).ToList();
var commonFields = objFieldNames.Intersect(dataTblFieldNames).ToList();
foreach (DataRow dataRow in result.AsEnumerable().ToList())
{
aTSource = new Ins_ReportInsuranceTotalModel();
foreach (var aField in commonFields)
{
PropertyInfo propertyInfos = aTSource.GetType().GetProperty(aField.Name);
if (dataRow[aField.Name] == DBNull.Value)
continue;
propertyInfos.SetValue(aTSource, dataRow[aField.Name], null);
}
dataList.Add(aTSource);
}
}
#endregion
return Json(dataList.ToDataSourceResult(request));
}
