// [Test]
public void NUnit_Domain_GetByIdCatContractType()
{
string status = string.Empty;
Cat_ContractTypeServices service = new Cat_ContractTypeServices();
var ContractType = new Cat_ContractTypeEntity { Id = 2 };
var result = service.GetById<Cat_ContractTypeEntity>(ContractType.Id, ref status) as Cat_ContractTypeEntity;
NUnit.Framework.Assert.IsNotNull(result);
Console.Write("SearchResult: " + result.Id + " | " + result.ContractTypeCode + " | " + result.ContractTypeName + " | " + result.Description);
}
public ActionResult SaveContractAndSaslary(DateTime? dateStart, DateTime? dateEnd, string orgStructureID, string contractTypeID, string RankDetailForNextContract, List<Guid> selectedIds, string statusContract, bool IsEvaluation)
{
var hrService = new Hre_ProfileServices();
string message = string.Empty;
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var lstObjProfile = new List<object>();
lstObjProfile.AddRange(new object[16]);
lstObjProfile[14] = 1;
lstObjProfile[15] = int.MaxValue - 1;
var lstProfile = actionService.GetData<Hre_ProfileEntity>(lstObjProfile, ConstantSql.hrm_hr_sp_get_Profile, ref status).ToList();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjSalaryRank = new List<object>();
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(1);
lstObjSalaryRank.Add(int.MaxValue - 1);
var lstSalaryRank = actionService.GetData<Cat_SalaryRankEntity>(lstObjSalaryRank, ConstantSql.hrm_cat_sp_get_SalaryRank, ref status).ToList();
var contractServices = new Hre_ContractServices();
var lisobjContract = new List<object>();
string strIDs = string.Empty;
foreach (var item in selectedIds)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
strIDs = strIDs.Substring(0, strIDs.Length - 1);
lisobjContract.Add(strIDs);
var lstContractByProfileID = actionService.GetData<Hre_ContractEntity>(lisobjContract, ConstantSql.hrm_hr_sp_get_ContractsByListId, ref status).ToList();
var workhistoryService = new Hre_WorkHistoryServices();
var lstObjWorkhistory = new List<object>();
lstObjWorkhistory.AddRange(new object[17]);
lstObjWorkhistory[15] = 1;
lstObjWorkhistory[16] = int.MaxValue - 1;
var lstWorkhistory = actionService.GetData<Hre_WorkHistoryEntity>(lstObjWorkhistory, ConstantSql.hrm_hr_sp_get_WorkHistory, ref status).ToList();
var basicSalaryService = new Sal_BasicSalaryServices();
var attGradeService = new Att_GradeServices();
var lstObjAttGrade = new List<object>();
lstObjAttGrade.AddRange(new object[6]);
lstObjAttGrade[4] = 1;
lstObjAttGrade[5] = int.MaxValue - 1;
var lstAttGrade = actionService.GetData<Att_GradeEntity>(lstObjAttGrade, ConstantSql.hrm_att_sp_get_Att_Grade, ref status).ToList();
var gradeService = new Sal_GradeServices();
var lstObjSalGrade = new List<object>();
lstObjSalGrade.AddRange(new object[7]);
lstObjSalGrade[5] = 1;
lstObjSalGrade[6] = int.MaxValue - 1;
var lstSalGrade = actionService.GetData<Sal_GradeEntity>(lstObjSalGrade, ConstantSql.hrm_sal_sp_get_Sal_Grade, ref status).ToList();
var gradePayrollService = new Cat_GradePayrollServices();
var lstObjGradePayroll = new List<object>();
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(1);
lstObjGradePayroll.Add(int.MaxValue - 1);
var lstGradePayroll = actionService.GetData<Cat_GradePayrollEntity>(lstObjGradePayroll, ConstantSql.hrm_cat_sp_get_GradePayroll, ref status).ToList();
var gradeAttService = new Cat_GradeAttendanceServices();
var lstObjGradeAtt = new List<object>();
lstObjGradeAtt.AddRange(new object[10]);
lstObjGradeAtt[8] = 1;
lstObjGradeAtt[9] = int.MaxValue - 1;
var lstGradeAtt = actionService.GetData<Cat_GradeAttendanceEntity>(lstObjGradeAtt, ConstantSql.hrm_cat_sp_get_Cat_GradeAttendance, ref status).ToList();
var currencyServices = new Cat_CurrencyServices();
var lstObjCurrency = new List<object>();
lstObjCurrency.Add(null);
lstObjCurrency.Add(null);
lstObjCurrency.Add(1);
lstObjCurrency.Add(int.MaxValue - 1);
var lstCurrency = actionService.GetData<Cat_CurrencyEntity>(lstObjCurrency, ConstantSql.hrm_cat_sp_get_Currency, ref status).ToList();
var lstCurrencyNew = lstCurrency.Where(s => s.CurrencyName == "VND").FirstOrDefault();
var contractTypeService = new Cat_ContractTypeServices();
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 = actionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
var insuranceConfigServices = new Cat_InsuranceConfigServices();
var objInsuranceConfig = new List<object>();
objInsuranceConfig.Add(1);
objInsuranceConfig.Add(int.MaxValue - 1);
var lstInsuranceConfig = actionService.GetData<Cat_InsuranceConfigEntity>(objInsuranceConfig, ConstantSql.hrm_cat_sp_get_InsuranceConfig, ref status).ToList();
var insuranceServices = new Sal_InsuranceSalaryServices();
var objInsurance = new List<object>();
objInsurance.AddRange(new object[9]);
objInsurance[7] = 1;
objInsurance[8] = int.MaxValue - 1;
var lstInsurance = actionService.GetData<Sal_InsuranceSalaryEntity>(objInsurance, ConstantSql.hrm_sal_sp_get_InsuranceSalary, ref status).ToList();
foreach (var item in lstContractByProfileID)
{
var contractTypeEntity = new Cat_ContractTypeEntity();
var objContract = new List<object>();
objContract.Add(item.ProfileID);
var lstContractIdByProfileID = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var listIdContract = string.Empty;
if (lstContractIdByProfileID != null)
{
listIdContract = string.Join(",", lstContractIdByProfileID.Select(d => d.ContractTypeID));
}
var profile = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (item.NextContractTypeID != null)
{
contractTypeEntity = lstContractType.Where(s => item.NextContractTypeID.Value == s.ID).FirstOrDefault();
}
else
{
message = ConstantMessages.WarningContractHaveNotNextContract.ToString().TranslateString();
return Json(message, JsonRequestBehavior.AllowGet);
// contractTypeEntity = lstContractType.Where(s => Guid.Parse(Common.DotNetToOracle(item.ContractNextID.ToString())) == s.ID).FirstOrDefault();
}
var workingHistoryEntity = lstWorkhistory.Where(s => s.ProfileID == item.ProfileID).FirstOrDefault();
var objSalGrade = new List<object>();
objSalGrade.Add(item.ProfileID);
objSalGrade.Add(null);
objSalGrade.Add(1);
objSalGrade.Add(int.MaxValue - 1);
var salGradeByProfileIDEntity = actionService.GetData<Sal_GradeEntity>(objSalGrade, ConstantSql.hrm_sal_sp_get_GradeAndAllownaceByProId, ref status).FirstOrDefault();
var objAttGrade = new List<object>();
objAttGrade.Add(item.ProfileID);
objAttGrade.Add(null);
objAttGrade.Add(1);
objAttGrade.Add(int.MaxValue - 1);
var attGradeByProfileIDEntity = actionService.GetData<Att_GradeEntity>(objAttGrade, ConstantSql.hrm_att_sp_get_GradeAttendanceByProIdCutID, ref status).FirstOrDefault();
if (contractTypeEntity == null)
{
continue;
}
if (item.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
if (item.ContractEvaType == EnumDropDown.ContractEvaType.E_EXPIRED_APPRENTICE.ToString())
{
//chưa tìm dc cách xử lý nên hard code
var lstSalaryRankNew = new Cat_SalaryRankEntity();
// var lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
if (item.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankRateID != null && s.ID == item.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
if (item.TypeOfPass == EnumDropDown.TypeOfPass.E_SIGNED_NEXTCONTRACT.ToString())
{
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = item.DateEnd.Value.AddDays(1),
DateSigned = item.DateEnd.Value.AddDays(1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = item.DateEnd.Value.AddDays(1),
DateSigned = item.DateEnd.Value.AddDays(1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
// DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? item.RankRateID : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
}
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = item.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = item.DateEnd.Value.AddDays(1),
CurrencyID = lstCurrencyNew.ID,
Note = item.Remark
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = item.DateEnd.Value.AddDays(1)
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = item.DateEnd.Value.AddDays(1)
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstAttGradeByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
// return Json(message, JsonRequestBehavior.AllowGet);
}
if (item.ContractEvaType == EnumDropDown.ContractEvaType.E_ANNUAL_EVALUATION.ToString() && item.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
var lstSalaryRankNew = new Cat_SalaryRankEntity();
// var lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
if (item.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankRateID != null && s.ID == item.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
// DateEnd = null,
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = item.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = new DateTime(DateTime.Now.Year, 6, 1),
CurrencyID = lstCurrencyNew.ID,
Note = item.Remark
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
message = hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = new DateTime(DateTime.Now.Year, 6, 1)
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = new DateTime(DateTime.Now.Year, 6, 1)
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
}
}
}
return Json(message, JsonRequestBehavior.AllowGet);
// return null;
}
public string SaveContractAndNextSalaryApprovedEvaluation(Hre_ContractEntity contract)
{
if (contract.DateEndNextContract == null)
{
return string.Empty;
}
// Lấy biến Dateend này gắn cho quá trình công tác khi cập nhật quá trinh công tác ở dưới
DateTime? dateEnd = contract.DateEnd;
string message = string.Empty;
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var profile = actionService.GetData<Hre_ProfileEntity>(contract.ProfileID, ConstantSql.hrm_hr_sp_get_ProfileById, ref status).FirstOrDefault();
var hrService = new Hre_ProfileServices();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjSalaryRank = new List<object>();
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(1);
lstObjSalaryRank.Add(int.MaxValue - 1);
var lstSalaryRank = actionService.GetData<Cat_SalaryRankEntity>(lstObjSalaryRank, ConstantSql.hrm_cat_sp_get_SalaryRank, ref status).ToList();
var contractServices = new Hre_ContractServices();
var workhistoryService = new Hre_WorkHistoryServices();
var lstObjWorkhistory = new List<object>();
lstObjWorkhistory.AddRange(new object[17]);
lstObjWorkhistory[15] = 1;
lstObjWorkhistory[16] = int.MaxValue - 1;
var lstWorkhistory = actionService.GetData<Hre_WorkHistoryEntity>(lstObjWorkhistory, ConstantSql.hrm_hr_sp_get_WorkHistory, ref status).ToList();
var basicSalaryService = new Sal_BasicSalaryServices();
var attGradeService = new Att_GradeServices();
var lstObjAttGrade = new List<object>();
lstObjAttGrade.AddRange(new object[6]);
lstObjAttGrade[4] = 1;
lstObjAttGrade[5] = int.MaxValue - 1;
var lstAttGrade = actionService.GetData<Att_GradeEntity>(lstObjAttGrade, ConstantSql.hrm_att_sp_get_Att_Grade, ref status).ToList();
var gradeService = new Sal_GradeServices();
var lstObjSalGrade = new List<object>();
lstObjSalGrade.AddRange(new object[7]);
lstObjSalGrade[5] = 1;
lstObjSalGrade[6] = int.MaxValue - 1;
var lstSalGrade = actionService.GetData<Sal_GradeEntity>(lstObjSalGrade, ConstantSql.hrm_sal_sp_get_Sal_Grade, ref status).ToList();
var gradePayrollService = new Cat_GradePayrollServices();
var lstObjGradePayroll = new List<object>();
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(1);
lstObjGradePayroll.Add(int.MaxValue - 1);
var lstGradePayroll = actionService.GetData<Cat_GradePayrollEntity>(lstObjGradePayroll, ConstantSql.hrm_cat_sp_get_GradePayroll, ref status).ToList();
var gradeAttService = new Cat_GradeAttendanceServices();
var lstObjGradeAtt = new List<object>();
lstObjGradeAtt.AddRange(new object[10]);
lstObjGradeAtt[8] = 1;
lstObjGradeAtt[9] = int.MaxValue - 1;
var lstGradeAtt = actionService.GetData<Cat_GradeAttendanceEntity>(lstObjGradeAtt, ConstantSql.hrm_cat_sp_get_Cat_GradeAttendance, ref status).ToList();
var currencyServices = new Cat_CurrencyServices();
var lstObjCurrency = new List<object>();
lstObjCurrency.Add(null);
lstObjCurrency.Add(null);
lstObjCurrency.Add(1);
lstObjCurrency.Add(int.MaxValue - 1);
var lstCurrency = actionService.GetData<Cat_CurrencyEntity>(lstObjCurrency, ConstantSql.hrm_cat_sp_get_Currency, ref status).ToList();
var lstCurrencyNew = lstCurrency.Where(s => s.CurrencyName == "VND").FirstOrDefault();
var contractTypeService = new Cat_ContractTypeServices();
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 = actionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
var insuranceConfigServices = new Cat_InsuranceConfigServices();
var objInsuranceConfig = new List<object>();
objInsuranceConfig.Add(1);
objInsuranceConfig.Add(int.MaxValue - 1);
var lstInsuranceConfig = actionService.GetData<Cat_InsuranceConfigEntity>(objInsuranceConfig, ConstantSql.hrm_cat_sp_get_InsuranceConfig, ref status).ToList();
var insuranceServices = new Sal_InsuranceSalaryServices();
var objInsurance = new List<object>();
objInsurance.AddRange(new object[9]);
objInsurance[7] = 1;
objInsurance[8] = int.MaxValue - 1;
var lstInsurance = actionService.GetData<Sal_InsuranceSalaryEntity>(objInsurance, ConstantSql.hrm_sal_sp_get_InsuranceSalary, ref status).ToList();
var contractTypeEntity = new Cat_ContractTypeEntity();
var objContract = new List<object>();
objContract.Add(contract.ProfileID);
var lstContractIdByProfileID = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var listIdContract = string.Empty;
if (lstContractIdByProfileID != null)
{
listIdContract = string.Join(",", lstContractIdByProfileID.Select(d => d.ContractTypeID));
}
if (contract.NextContractTypeID != null)
{
contractTypeEntity = lstContractType.Where(s => contract.NextContractTypeID.Value == s.ID).FirstOrDefault();
}
else
{
message = ConstantMessages.WarningContractHaveNotNextContract.ToString().TranslateString();
return message;
}
if (contractTypeEntity != null)
{
if (contractTypeEntity.Type == EnumDropDown.TypeContract.E_NODURATION.ToString())
{
return string.Empty;
}
}
var workingHistoryEntity = lstWorkhistory.Where(s => s.ProfileID == contract.ProfileID).FirstOrDefault();
var objSalGrade = new List<object>();
objSalGrade.Add(contract.ProfileID);
objSalGrade.Add(null);
objSalGrade.Add(1);
objSalGrade.Add(int.MaxValue - 1);
var salGradeByProfileIDEntity = actionService.GetData<Sal_GradeEntity>(objSalGrade, ConstantSql.hrm_sal_sp_get_GradeAndAllownaceByProId, ref status).FirstOrDefault();
var objAttGrade = new List<object>();
objAttGrade.Add(contract.ProfileID);
objAttGrade.Add(null);
objAttGrade.Add(1);
objAttGrade.Add(int.MaxValue - 1);
var attGradeByProfileIDEntity = actionService.GetData<Att_GradeEntity>(objAttGrade, ConstantSql.hrm_att_sp_get_GradeAttendanceByProIdCutID, ref status).FirstOrDefault();
if (contractTypeEntity == null)
{
return string.Empty;
}
var contracttypeByContract = lstContractType.Where(s => s.ID == contract.ContractTypeID).FirstOrDefault();
if (contract.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
if (contract.ContractEvaType == EnumDropDown.ContractEvaType.E_EXPIRED_APPRENTICE.ToString())
{
//chưa tìm dc cách xử lý nên hard code
var lstSalaryRankNew = new Cat_SalaryRankEntity();
if (contract.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankDetailForNextContract != null && s.ID == contract.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankRateID != null && s.ID == contract.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
if (contract.TypeOfPass == EnumDropDown.TypeOfPass.E_SIGNED_NEXTCONTRACT.ToString())
{
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = contract.DateEnd.Value.AddDays(1),
DateSigned = contract.DateEnd.Value.AddDays(1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID,
DateEndNextContract = contract.DateEndNextContract,
};
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity = SetNewCodeContract(contractEntity, listIdContract);
#region Nếu là loại hđ xác định thời hạn thì update lại cột TimesContract theo task 0049731
if (contracttypeByContract != null && contracttypeByContract.Type == HRM.Infrastructure.Utilities.EnumDropDown.TypeContract.E_DURATION.ToString())
{
try
{
string times = contractEntity.ContractNo.Substring(contractEntity.ContractNo.Length - 1, 1);
int Year = int.Parse(times);
contractEntity.TimesContract = Year;
}
catch
{
}
}
#endregion
contractEntity.Status = "E_APPROVED";
contractEntity.StatusEvaluation = "E_APPROVED";
contractEntity.DateExtend = contract.DateEnd;
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = contract.DateEnd.Value.AddDays(1),
DateSigned = contract.DateEnd.Value.AddDays(1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
// DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? contract.RankRateID : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
//if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
//{
// contractEntity = SetNewDateEndContract(contractEntity);
//}
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity.DateExtend = contract.DateEnd;
contractEntity.StatusEvaluation = "E_APPROVED";
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
}
//Edit lai StatusEvaluation
contract.StatusEvaluation = "E_APPROVED";
message = contractServices.Edit(contract);
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = contract.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = contract.DateSigned != null ? contract.DateSigned.Value : DateTime.Now,
CurrencyID = lstCurrencyNew.ID,
Note = contract.Remark,
Status = "E_APPROVED"
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
Guid? _AbilityTileID = null;
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
if (profileEntity.SalaryClassID != null)
{
var abilityTitleBySalaryClass = hrService.GetData<Cat_AbilityTileEntity>(Common.DotNetToOracle(profileEntity.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId, UserLogin, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
_AbilityTileID = abilityTitleBySalaryClass.ID;
profileEntity.AbilityTileID = _AbilityTileID;
}
}
hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
AbilityTileID = _AbilityTileID,
Status = "E_APPROVED"
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
Status = "E_APPROVED",
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstAttGradeByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateSigned != null ? contract.DateSigned.Value : DateTime.Now,
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateSigned != null ? contract.DateSigned.Value : DateTime.Now,
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
}
if (contract.ContractEvaType == EnumDropDown.ContractEvaType.E_ANNUAL_EVALUATION.ToString() && contract.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
var lstSalaryRankNew = new Cat_SalaryRankEntity();
if (contract.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankDetailForNextContract != null && s.ID == contract.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankRateID != null && s.ID == contract.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
//if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
//{
// contractEntity = SetNewDateEndContract(contractEntity);
//}
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity = SetNewCodeContract(contractEntity, listIdContract);
#region Nếu là loại hđ xác định thời hạn thì update lại cột TimesContract theo task 0049731
if (contracttypeByContract != null && contracttypeByContract.Type == HRM.Infrastructure.Utilities.EnumDropDown.TypeContract.E_DURATION.ToString())
{
try
{
string times = contractEntity.ContractNo.Substring(contractEntity.ContractNo.Length - 1, 1);
int Year = int.Parse(times);
contractEntity.TimesContract = Year;
}
catch
{
}
}
#endregion
contractEntity.Status = "E_APPROVED";
contractEntity.DateExtend = contract.DateEnd;
contractEntity.StatusEvaluation = "E_APPROVED";
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
// DateEnd = null,
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
//if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
//{
// contractEntity = SetNewDateEndContract(contractEntity);
//}
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity.DateExtend = contract.DateEnd;
contractEntity.StatusEvaluation = "E_APPROVED";
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
//Edit lai StatusEvaluation
contract.StatusEvaluation = "E_APPROVED";
message = contractServices.Edit(contract);
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = contract.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = new DateTime(DateTime.Now.Year, 6, 1),
CurrencyID = lstCurrencyNew.ID,
Note = contract.Remark,
Status = "E_APPROVED"
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
Guid? _AbilityTileID = null;
if (profileEntity.SalaryClassID != null)
{
var abilityTitleBySalaryClass = actionService.GetData<Cat_AbilityTileEntity>(Common.DotNetToOracle(profileEntity.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
_AbilityTileID = abilityTitleBySalaryClass.ID;
profileEntity.AbilityTileID = _AbilityTileID;
}
}
message = hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
AbilityTileID = _AbilityTileID,
Status = "E_APPROVED"
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
Status = "E_APPROVED"
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1),
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateEnd.Value.AddDays(1),
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = lstCurrencyNew.ID,
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateEnd.Value.AddDays(1),
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
}
}
return message;
// return null;
}
public ActionResult CheckAddNextContract(string ContractTypeID, string ContractID)
{
string status = string.Empty;
var contractTypeID = Guid.Empty;
Guid convertContractID = Guid.Empty;
string AddMessage = string.Empty;
List<Guid> lstContractID = new List<Guid>();
if (!string.IsNullOrEmpty(ContractTypeID))
{
contractTypeID = Guid.Parse(ContractTypeID);
}
if (ContractID.IndexOf(",") > 1)
{
var lstID = ContractID.Split(',');
for (int i = 0; i < lstID.Length; i++)
{
convertContractID = Common.ConvertToGuid(lstID[i]);
lstContractID.Add(convertContractID);
}
}
else
{
convertContractID = Common.ConvertToGuid(ContractID);
lstContractID.Add(convertContractID);
}
ActionService service = new ActionService(UserLogin);
var actionServices = new ActionService(UserLogin);
var contractServices = new Hre_ContractServices();
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).Where(s => lstContractID.Contains(s.ID)).ToList();
var lstContract = service.GetData<Hre_ContractEntity>(convertContractID, ConstantSql.hrm_hr_sp_get_ContractById, ref status).FirstOrDefault();
var contractTypeServices = new Cat_ContractTypeServices();
List<object> lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(10000000);
var lstContractType = actionServices.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status);
List<object> listObj = new List<object>();
listObj.Add(1);
listObj.Add(1000);
var BasicSalaryServices = new Sal_BasicSalaryServices();
var lstBasicSalary = actionServices.GetData<Sal_BasicSalaryEntity>(listObj, ConstantSql.hrm_sal_sp_get_BasicPayrollGetAll, ref status).Where(s => s.ProfileID == lstContract.ProfileID && s.DateOfEffect <= lstContract.DateEnd).OrderByDescending(s => s.DateOfEffect).FirstOrDefault();
foreach (var hreContract in lstContracts)
{
// lstContractType = lstContractType.Where( s=> s.ID == hreContract.ContractTypeID).ToList();
string contractnextID = lstContractType.Where(s => s.ID == hreContract.ContractTypeID).Select(s => s.ContractNextID).FirstOrDefault();
if (contractnextID == null)
{
AddMessage = "Error";
return Json(AddMessage);
}
else
{
Guid contractTypeIDbyContractnext = Common.OracleToDotNet(contractnextID);
Hre_ContractEntity contract = new Hre_ContractEntity();
hreContract.CopyData(contract);
contract.ContractTypeID = contractTypeIDbyContractnext;
// contract.ContractNo = getContractNo(contract, contract.DateSigned ?? DateTime.Now);
if (contract.DateEnd != null)
{
contract.DateSigned = contract.DateStart = contract.DateEnd.Value.AddDays(1);
}
Cat_ContractTypeEntity catContractType = new Cat_ContractTypeEntity();
catContractType = lstContractType.Where(s => s.ID == contractTypeIDbyContractnext).FirstOrDefault();
if (catContractType != null)
{
int month = 0;
if (catContractType.ValueTime != null)
{
month = (int)catContractType.ValueTime.Value;
}
if (catContractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
if (hreContract.DateEnd != null)
{
contract.DateStart = hreContract.DateEnd.Value.AddDays(1);
contract.DateEnd = contract.DateStart.AddMonths(month);
}
}
else
{
contract.DateEnd = null;
}
if (lstBasicSalary != null)
{
contract.InsuranceAmount = lstBasicSalary.InsuranceAmount;
contract.CurenncyID1 = lstBasicSalary.CurrencyID1;
contract.ClassRateID = lstBasicSalary.ClassRateID;
contract.RankRateID = lstBasicSalary.RankRateID;
}
//Add new
AddMessage = contractServices.Add(contract);
//AddMessage = "Success";
}
}
return Json(AddMessage);
}
public ActionResult ActionApplyCandidateGeneral(string selectedIds)
{
string message = NotificationType.Success.ToString();
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var lstCandidateGeneral = actionService.GetData<Hre_CandidateGeneralEntity>(Common.DotNetToOracle(selectedIds), ConstantSql.hrm_hr_sp_get_GeneralCandidateByIds, ref status);
var salaryRankServices = new Cat_SalaryRankServices();
var salaryClassServices = new Cat_SalaryClassServices();
var profileServices = new Hre_ProfileServices();
var contracttypeServices = new Cat_ContractTypeServices();
var workHistoryServices = new Hre_WorkHistoryServices();
var rankEntity = new Cat_SalaryRankEntity();
var salaryClass = new Cat_SalaryClassEntity();
var contractypeentity = new Cat_ContractTypeEntity();
ActionService service = new ActionService(UserLogin);
var salgradeServices = new Sal_GradeServices();
var attgradeservive = new Att_GradeServices();
foreach (var CandidateGeneral in lstCandidateGeneral)
{
#region Code Cũ
//var datecontract = DateTime.Now;
//if (CandidateGeneral.EnteringDate != null)
//{
// datecontract = CandidateGeneral.EnteringDate.Value;
//}
//if (CandidateGeneral.RankRateID != Guid.Empty)
//{
// rankEntity = service.GetByIdUseStore<Cat_SalaryRankEntity>(CandidateGeneral.RankRateID.Value,
// ConstantSql.hrm_cat_sp_get_SalaryRankById, ref status);
//}
//if(CandidateGeneral.ContractTypeID != Guid.Empty)
//{
// contractypeentity = service.GetByIdUseStore<Cat_ContractTypeEntity>(CandidateGeneral.ContractTypeID.Value, ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status);
//}
//var profileEntity = profileServices.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(CandidateGeneral.ProfileID.ToString()),
// ConstantSql.hrm_hr_sp_get_ProfileById, ref status).FirstOrDefault();
//if (contractypeentity != null && contractypeentity.ValueTime != null)
//{
// if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
// {
// datecontract = datecontract.AddMonths(int.Parse(contractypeentity.ValueTime.Value.ToString()));
// }
// else if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
// {
// datecontract = datecontract.AddYears(int.Parse(contractypeentity.ValueTime.Value.ToString()));
// }
//}
//if(profileEntity != null)
//{
// profileEntity.OrgStructureID = CandidateGeneral.OrgStructureID;
// profileEntity.SalaryClassID = CandidateGeneral.SalaryClassID;
// profileEntity.DateHire = CandidateGeneral.EnteringDate;
// profileEntity.DateEndProbation = datecontract;
// profileEntity.WorkPlaceID = CandidateGeneral.WorkPlaceID;
//}
// var workplaceServices = new Cat_WorkPlaceServices();
// Cat_WorkPlaceEntity workplace = null;
//if(CandidateGeneral.WorkPlaceID != Guid.Empty)
//{
//workplace = workplaceServices.GetData<Cat_WorkPlaceEntity>(Common.DotNetToOracle(CandidateGeneral.WorkPlaceID.ToString()), ConstantSql.hrm_cat_sp_get_WorkPlaceById, ref status).FirstOrDefault();
//}
//var WorkHistoryEntity = new Hre_WorkHistoryEntity();
// WorkHistoryEntity.ProfileID = CandidateGeneral.ProfileID.Value;
// WorkHistoryEntity.DateEffective = CandidateGeneral.EnteringDate != null ? CandidateGeneral.EnteringDate.Value ? DateTime.Now;
// WorkHistoryEntity.SalaryClassID = CandidateGeneral.SalaryClassID;
// WorkHistoryEntity.OrganizationStructureID = CandidateGeneral.OrgStructureID;
// WorkHistoryEntity.WorkLocation = workplace != null ? workplace.WorkPlaceName : null;
// workHistoryServices.Add(WorkHistoryEntity);
//}
#endregion
var datecontract = DateTime.Now;
if (CandidateGeneral.ContractTypeID != Guid.Empty)
{
contractypeentity = actionService.GetData<Cat_ContractTypeEntity>(Common.DotNetToOracle(CandidateGeneral.ContractTypeID.ToString()),
ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status).FirstOrDefault();
}
if (contractypeentity != null && contractypeentity.ValueTime != null)
{
if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
{
datecontract = datecontract.AddMonths(int.Parse(contractypeentity.ValueTime.Value.ToString()));
}
else if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
datecontract = datecontract.AddYears(int.Parse(contractypeentity.ValueTime.Value.ToString()));
}
}
profileServices.UpdateSalaryClassNameForProfile(null, CandidateGeneral.ProfileID.ToString(), datecontract, CandidateGeneral.EnteringDate.Value,
CandidateGeneral.OrgStructureID.Value, CandidateGeneral.RankRateID.Value, CandidateGeneral.WorkPlaceID.Value, CandidateGeneral.ContractTypeID.Value,
CandidateGeneral.BasicSalary.ToString(), UserLogin);
// profileServices.AddDataForContract(CandidateGeneral.BasicSalary.ToString(), CandidateGeneral.ProfileID.ToString(), CandidateGeneral.ContractTypeID.Value, CandidateGeneral.EnteringDate.Value, CandidateGeneral.RankRateID.Value);
salgradeServices.AddDataForGrade(CandidateGeneral.ProfileID.ToString(), CandidateGeneral.GradePayrollID.Value, CandidateGeneral.EnteringDate.Value);
attgradeservive.AddDataForGrade(CandidateGeneral.ProfileID.ToString(), CandidateGeneral.GradeAttendanceID.Value, CandidateGeneral.EnteringDate.Value);
}
return Json(message, JsonRequestBehavior.AllowGet);
}
