public ActionResult GetExpiryContract([DataSourceRequest] DataSourceRequest request, Hre_ReportExpiryContractModel Model)
{
string status = string.Empty;
var service = new Hre_ReportServices();
var actionServices = new ActionService(UserLogin);
var profileServices = new Hre_ProfileServices();
var contractServices = new Hre_ContractServices();
BaseService baseServices = new BaseService();
bool isshowloopcontract = profileServices.IsNotUseExpiryContractLoop();
var ShowAfterDate1 = actionServices.GetData<Sys_AllSettingEntity>("HRM_HRE_CONTRACT_ALERT_EXPRIDAY_VALUEAFTE", ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status).FirstOrDefault();
var ShowBeforDate1 = actionServices.GetData<Sys_AllSettingEntity>("HRM_HRE_CONTRACT_ALERT_EXPRIDAY_VALUEBEFOR", ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status).FirstOrDefault();
DateTime? dateTo = null;
DateTime? dateFrom = null;
if (isshowloopcontract == false)
{
dateTo = DateTime.Now.AddDays(Convert.ToDouble(ShowAfterDate1.Value1));
dateFrom = DateTime.Now.AddDays(-Convert.ToDouble(ShowBeforDate1.Value1));
}
var isDataTable = false;
object obj = new Hre_ReportExpiryContractModel();
//var lstProfile = new List<Hre_ProfileEntity>();
var objProfile = new List<object>();
objProfile.AddRange(new object[2]);
objProfile[0] = 1;
objProfile[1] = int.MaxValue - 1;
var lstProfile = actionServices.GetData<Hre_ProfileEntity>(objProfile, ConstantSql.hrm_hr_sp_get_ProfileDataAll, ref status).ToList();
var lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(int.MaxValue - 1);
var lstContractType = actionServices.GetData<CatContractTypeModel>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
List<object> listObj = new List<object>();
listObj.Add(Model.OrgStructureID);
listObj.Add(Model.Status);
listObj.Add(dateFrom);
listObj.Add(dateTo);
listObj.Add(Model.CodeEmp);
listObj.Add(Model.ProfileName);
listObj.Add(Model.IDNo);
listObj.Add(Model.WorkPlaceID);
listObj.Add(Model.DateSignedFrom);
listObj.Add(Model.DateSignedTo);
listObj.Add(Model.ContractNo);
listObj.Add(1);
listObj.Add(int.MaxValue - 1);
var result = actionServices.GetData<Hre_ReportExpiryContractEntity>(listObj, ConstantSql.hrm_hr_sp_get_RptExpireContract, ref status).Where(s => s.StatusEvaluation != WorkdayStatus.E_APPROVED.ToString()).ToList().Translate<Hre_ReportExpiryContractModel>();
var objContract = new List<object>();
objContract.AddRange(new object[21]);
objContract[19] = 1;
objContract[20] = int.MaxValue - 1;
var lstContracts = actionServices.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status).ToList();
Guid[] _RankDetailForNextContract = null;
if (!string.IsNullOrEmpty(Model.RankDetailForNextContractIds))
{
_RankDetailForNextContract = Model.RankDetailForNextContractIds.Split(',').Select(s => Guid.Parse(s)).ToArray();
}
if (Model.ContractTypeID != null)
{
result = result.Where(s => s.ContractTypeID == Model.ContractTypeID).ToList();
}
if (!string.IsNullOrEmpty(Model.Status))
{
result = result.Where(s => s.Status == Model.Status).ToList();
}
var lstModel = new List<Hre_ReportExpiryContractModel>();
if (_RankDetailForNextContract != null)
{
result = result.Where(s => _RankDetailForNextContract.Contains(s.RankDetailForNextContract != null ? s.RankDetailForNextContract.Value : Guid.Empty)).ToList();
}
if (Model.EvaType == EnumDropDown.EvaExpiryContract.E_EVA_CONTRACT.ToString())
{
result = result.Where(s => s.StatusEvaluation != WorkdayStatus.E_APPROVED.ToString() && s.ContractResult != null).ToList();
if (isshowloopcontract == false)
{
var model = new Hre_ReportExpiryContractModel();
foreach (var item in result)
{
var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault();
if (ContractByProfileID != null)
{
if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
else
{
foreach (var item in result)
{
var dateSenior = new TimeSpan();
double monthSenior = 0;
var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null)
{
dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value);
monthSenior = Math.Floor(dateSenior.TotalDays / 30);
}
item.MonthSenior = (double?)monthSenior;
var dateCheck = DateTime.Now;
var model = new Hre_ReportExpiryContractModel();
var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault();
if (item.ContractResult == null)
{
if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null)
{
var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value);
if (item.DateExtend != null && item.DateExtend <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
}
else if (Model.EvaType == EnumDropDown.EvaExpiryContract.E_NONEEVA_CONTRACT.ToString())
{
result = result.Where(s => s.ContractResult == null).ToList();
if (isshowloopcontract == false)
{
var model = new Hre_ReportExpiryContractModel();
foreach (var item in result)
{
var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault();
if (ContractByProfileID != null)
{
if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
else
{
foreach (var item in result)
{
var dateSenior = new TimeSpan();
double monthSenior = 0;
var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null)
{
dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value);
monthSenior = Math.Floor(dateSenior.TotalDays / 30);
}
item.MonthSenior = (double?)monthSenior;
var dateCheck = DateTime.Now;
var model = new Hre_ReportExpiryContractModel();
var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault();
if (item.ContractResult == null)
{
if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null)
{
var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value);
if (item.DateExtend != null && item.DateExtend <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
}
else
{
if (isshowloopcontract == false)
{
var model = new Hre_ReportExpiryContractModel();
foreach (var item in result)
{
var ContractByProfileID = lstContracts.Where(s => s.ProfileID == item.ProfileID).OrderByDescending(s => s.DateCreate).FirstOrDefault();
if (ContractByProfileID != null)
{
if (ContractByProfileID.DateCreate != null && ContractByProfileID.DateCreate.Value.ToShortDateString() != DateTime.Now.ToShortDateString())
{
if (item.DateExtend != null && item.DateExtend >= dateFrom && item.DateExtend <= dateTo)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd >= dateFrom && item.DateEnd <= dateTo)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
else
{
foreach (var item in result)
{
var dateSenior = new TimeSpan();
double monthSenior = 0;
var profileEntity = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (profileEntity != null && profileEntity.DateHire != null && Model.DateEnd != null)
{
dateSenior = Model.DateEnd.Value.Subtract(profileEntity.DateHire.Value);
monthSenior = Math.Floor(dateSenior.TotalDays / 30);
}
item.MonthSenior = (double?)monthSenior;
var dateCheck = DateTime.Now;
var model = new Hre_ReportExpiryContractModel();
var contractTypeEntity = lstContractType.Where(s => item.ContractTypeID == s.ID).FirstOrDefault();
if (contractTypeEntity != null && contractTypeEntity.ExpiryContractLoop != null)
{
var dateExpiry = dateCheck.AddDays(contractTypeEntity.ExpiryContractLoop.Value);
if (item.DateExtend != null && item.DateExtend <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
if (item.DateExtend == null && item.DateEnd != null && item.DateEnd.Value <= dateExpiry)
{
model = item;
lstModel.Add(model);
}
}
}
}
}
#region Lấy phụ lục hợp đông
var _ReportService = new Hre_ContractServices();
var lisEntity = result.Translate<Hre_ContractEntity>();
DataTable tb = _ReportService.GetDataContract(lisEntity, UserLogin);
#endregion
#region Xuất template
if (Model != null && Model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = tb,
FileName = "Hre_ContractEntity",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
#endregion
if (Model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(Model.ExportID, tb, Model.ExportType);
return Json(fullPath);
}
return Json(lstModel.ToDataSourceResult(request));
}
public ActionResult ExportContractListByTemplate([DataSourceRequest] DataSourceRequest request, Hre_ContractSearchModel model)
{
string status = string.Empty;
var contractServices = new Hre_ContractServices();
var isDataTable = false;
object obj = new Hre_ProfileModel();
var result = GetListData<Hre_ContractModel, Hre_ContractEntity, Hre_ContractSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ContractList, ref status);
DataTable tb = new DataTable();
var actionServices = new ActionService(UserLogin);
var _ConstractSearchModel = new Hre_ContractSearchModel();
var _lsContractAll = GetListData<Hre_ContractModel, Hre_ContractEntity, Hre_ContractSearchModel>(request, _ConstractSearchModel, ConstantSql.hrm_hr_sp_get_Contract, ref status);
var Lstobj = new List<object>();
Lstobj.AddRange(new object[18]);
Lstobj[16] = 1;
Lstobj[17] = (int.MaxValue - 1);
var _profileAll = actionServices.GetData<Hre_ProfileEntity>(Lstobj, ConstantSql.hrm_hr_sp_get_Profile, ref status);
#region lay thong tin hop dong
for (int i = 0; i < result.Count; i++)
{
#region Lay thong tin Profile
var _profile = _profileAll.Where(s => s.ID == result[i].ProfileID && result[i].ProfileID != null).FirstOrDefault();
if (_profile != null)
{
if (_profile.PAddress != null)
result[i].PAddress = _profile.PAddress;
if (_profile.PDistrictName != null)
result[i].PDistrictName = _profile.PDistrictName;
if (_profile.PCountryName != null)
result[i].PCountryName = _profile.PCountryName;
if (_profile.PProvinceName != null)
result[i].PProvinceName = _profile.PProvinceName;
if (result[i].ProfileName != null)
{
var _profilename = result[i].ProfileName.Split(' ');
if (_profilename.Count() == 1)
{
result[i].FristName = result[i].ProfileName;
}
else
{
if (_profilename.Count() == 2)
{
result[i].FristName = _profilename[0];
result[i].LastName = _profilename[1];
}
else
{
result[i].FristName = _profilename[0];
result[i].LastName = _profilename[_profilename.Count() - 1];
for (int j = 1; j < _profilename.Count() - 1; j++)
{
result[i].TenDem = result[i].TenDem + _profilename[j];
}
}
}
}
}
#endregion
#region Lay thong tin hopn dong truoc do
var _lsContract = _lsContractAll.Where(s => s.ID == result[i].ID && result[i].ID != null).ToList();
if (_lsContract != null && _lsContract.Count >= 2)
{
_lsContract = _lsContract.Where(m => m.DateSigned <= result[i].DateSigned).ToList();
if (_lsContract.Count >= 2)
{
Hre_ContractModel _contract = new Hre_ContractModel();
_lsContract = _lsContract.OrderByDescending(m => m.DateSigned).ToList();
_contract = _lsContract[0];
if (_contract.DateStart != null)
{
result[i].DateStartOld = _contract.DateStart;
result[i].DateStartOld_Day = _contract.DateStart.Day.ToString();
result[i].DateStartOld_Month = _contract.DateStart.Month.ToString();
result[i].DateStartOld_Year = _contract.DateStart_Year.ToString();
}
if (_contract.DateEnd != null)
{
result[i].DateEndOld = _contract.DateEnd;
result[i].DateEndOld_Day = _contract.DateEnd.Value.Day.ToString();
result[i].DateEndOld_Month = _contract.DateEnd.Value.Month.ToString();
result[i].DateEndOld_Year = _contract.DateEnd.Value.Year.ToString();
}
if (_contract.DateSigned != null)
{
result[i].DateSignedOld = _contract.DateSigned;
result[i].DateSignedOld_Day = _contract.DateSigned.Value.Day.ToString();
result[i].DateSignedOld_Month = _contract.DateSigned.Value.Month.ToString();
result[i].DateSignedOld_Year = _contract.DateSigned.Value.Year.ToString();
}
}
}
#endregion
}
#endregion
var lstEntity = result.Translate<Hre_ContractEntity>();
tb = contractServices.GetDataContract(lstEntity, UserLogin);
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = tb,
FileName = "Hre_Contract",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, lstEntity, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult GetEvaluationContractWaitingList([DataSourceRequest] DataSourceRequest request, Hre_EvaluationContractWaitingApprovedSearchModel model)
{
int _page = request.Page;
var service = new Hre_ReportServices();
var ActionService = new ActionService(UserLogin);
var contractServices = new Hre_ContractServices();
string status = string.Empty;
request.Page = 1;
request.PageSize = int.MaxValue - 1;
var result = GetListData<Hre_ContractModel, Hre_ContractEntity, Hre_EvaluationContractWaitingApprovedSearchModel>(request, model,
ConstantSql.hrm_hr_sp_get_EvaluationContractWaitingApprove, ref status);
if (result != null)
{
result = result.Where(s => s.StatusEvaluation != "E_APPROVED" && s.ContractResult != null).ToList();
}
var lstObjContractType = new List<object>();
lstObjContractType.AddRange(new object[6]);
lstObjContractType[4] = 1;
lstObjContractType[5] = int.MaxValue - 1;
var lstContractType = ActionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status);
if (model.IsMissingInformation == true)
{
result = result.Where(s => s.DateEndNextContract == null).ToList();
}
var lstContractEntity = result.Translate<Hre_ContractEntity>();
DataTable tableData = contractServices.GetDataContract(lstContractEntity, UserLogin);
HeaderInfo headerInfo1 = new HeaderInfo() { Name = "DateFrom", Value = model.DateStart == null ? DateTime.Now : model.DateStart };
HeaderInfo headerInfo2 = new HeaderInfo() { Name = "DateTo", Value = model.DateEnd == null ? DateTime.Now : model.DateEnd };
List<HeaderInfo> listHeaderInfo = new List<HeaderInfo>() { headerInfo1, headerInfo2 };
var isDataTable = false;
DataTable obj = null;
if (model.IsCreateTemplateForDynamicGrid)
{
obj = tableData;
isDataTable = true;
}
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = obj,
FileName = "Hre_ContractEntity",
OutPutPath = path,
HeaderInfo=listHeaderInfo,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportID, tableData, listHeaderInfo, model.ExportType);
return Json(fullPath);
}
var listModel = new List<Hre_ContractModel>();
if (result != null)
{
request.Page = _page;
foreach (var item in result)
{
var newModle = (Hre_ContractModel)typeof(Hre_ContractModel).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 = result.Count;
}
return Json(dataSourceResult, JsonRequestBehavior.AllowGet);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult ExportAllContractEndList([DataSourceRequest] DataSourceRequest request, Hre_ContractEndSearchModel model)
{
Hre_ContractServices ActionServices = new Hre_ContractServices();
string status = string.Empty;
var result = GetListData<Hre_ContractModel, Hre_ContractEntity, Hre_ContractEndSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ContractEnd, ref status);
var lstEntity = result.Translate<Hre_ContractEntity>();
DataTable tb = ActionServices.GetDataContract(lstEntity, UserLogin);
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = tb,
FileName = "Hre_ContractEntity",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportId != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportId, tb, null, model.ExportType);
return Json(fullPath);
}
return Json(result.ToDataSourceResult(request));
}
public ActionResult ExportAllContractWaitingList([DataSourceRequest] DataSourceRequest request, Hre_ContractWaitingSearchModel model)
{
var contractServices = new Hre_ContractServices();
string status = string.Empty;
var result = GetListData<Hre_ContractEntity, Hre_ContractModel, Hre_ContractWaitingSearchModel>(request, model, ConstantSql.hrm_hr_sp_get_ContractWaiting, ref status);
DataTable tableData = contractServices.GetDataContract(result, UserLogin);
var isDataTable = false;
if (model != null && model.IsCreateTemplate)
{
var path = Common.GetPath("Templates");
ExportService exportService = new ExportService();
ConfigExport cfgExport = new ConfigExport()
{
Object = tableData,
FileName = "Hre_ContractEntity",
OutPutPath = path,
DownloadPath = Hrm_Main_Web + "Templates",
IsDataTable = true
};
var str = exportService.CreateTemplate(cfgExport);
return Json(str);
}
if (model.ExportID != Guid.Empty)
{
var fullPath = ExportService.Export(model.ExportID, tableData, null, model.ExportType);
return Json(fullPath);
}
var listModel = new List<Hre_ContractModel>();
if (result != null)
{
request.Page = 1;
foreach (var item in result)
{
var newModle = (Hre_ContractModel)typeof(Hre_ContractModel).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);
}
return Json(result.ToDataSourceResult(request));
}