public ActionResult SaveContractAndBasicSalary([Bind]Hre_ContractModel model)
{
#region Validate
string message_Error = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "Hre_Contract", ref message_Error);
if (!checkValidate)
{
model.ActionStatus = message_Error;
return Json(message_Error, JsonRequestBehavior.AllowGet);
}
#endregion
string status = string.Empty;
Guid convertProfileID = Guid.Empty;
var insuranceServices = new Sal_InsuranceSalaryServices();
string message = string.Empty;
List<Guid> lstProfileID = new List<Guid>();
var ContractServices = new Hre_ContractServices();
if (model.ProfileIDs != null && model.ProfileIDs.IndexOf(',') > 1)
{
var lstID = model.ProfileIDs.Split(',');
for (int i = 0; i < lstID.Length; i++)
{
convertProfileID = Common.ConvertToGuid(lstID[i]);
lstProfileID.Add(convertProfileID);
}
}
else
{
convertProfileID = Common.ConvertToGuid(model.ProfileIDs);
lstProfileID.Add(convertProfileID);
}
List<object> lstObjProfile = new List<object>();
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(1);
lstObjProfile.Add(int.MaxValue - 1);
var actionService = new ActionService(UserLogin);
var lstProfile = actionService.GetData<Hre_ProfileEntity>(lstObjProfile, ConstantSql.hrm_hr_sp_get_ProfileAll, ref status).ToList();
lstProfile = lstProfile.Where(s => lstProfileID.Contains(s.ID) && s.IsDelete == null).ToList();
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();
foreach (var profile in lstProfile)
{
model.ProfileID = profile.ID;
var contractTypeEntity = lstContractType.Where(s => s.ID == model.ContractTypeID).FirstOrDefault();
#region Xử Lý Lương BHXH
if (contractTypeEntity != null && contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = model.ProfileID,
InsuranceAmount = model.InsuranceAmount,
DateEffect = model.DateStart,
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = model.CurenncyID1
};
message = insuranceServices.Add(insuranceEntity);
}
#endregion
if (model.CreateBasicSalary == true)
{
Sal_BasicSalaryServices salaryservices = new Sal_BasicSalaryServices();
Sal_BasicSalaryEntity basicSalaryBycontract = new Sal_BasicSalaryEntity();
basicSalaryBycontract.ProfileID = profile.ID;
basicSalaryBycontract.GrossAmount = model.Salary != null ? model.Salary.ToString() : "0";
basicSalaryBycontract.CurrencyID = model.CurenncyID != null ? model.CurenncyID.Value : Guid.Empty;
basicSalaryBycontract.PersonalRate = model.PersonalRate;
basicSalaryBycontract.DateOfEffect = model.DateStart;
basicSalaryBycontract.InsuranceAmount = model.InsuranceAmount != null ? model.InsuranceAmount.Value : 0;
basicSalaryBycontract.CurrencyID1 = model.CurenncyID1;
basicSalaryBycontract.ClassRateID = model.ClassRateID;
basicSalaryBycontract.RankRateID = model.RankRateID;
basicSalaryBycontract.AllowanceType1ID = model.AllowanceID1;
basicSalaryBycontract.AllowanceAmount1 = model.Allowance1;
basicSalaryBycontract.CurrencyID2 = model.CurenncyID2;
basicSalaryBycontract.AllowanceType2ID = model.AllowanceID2;
basicSalaryBycontract.AllowanceAmount2 = model.Allowance2;
basicSalaryBycontract.CurrencyID3 = model.CurenncyID3;
basicSalaryBycontract.AllowanceType3ID = model.AllowanceID3;
basicSalaryBycontract.AllowanceAmount3 = model.Allowance3;
basicSalaryBycontract.CurrencyID4 = model.CurenncyIDSalary;
salaryservices.Add(basicSalaryBycontract);
}
if (model.BasicSalaryForPerson == true)
{
List<object> listObj = new List<object>();
listObj.Add(1);
listObj.Add(1000);
var BasicSalaryServices = new Sal_BasicSalaryServices();
var lstBasicSalary = actionService.GetData<Sal_BasicSalaryEntity>(listObj, ConstantSql.hrm_sal_sp_get_BasicPayrollGetAll, ref status).Where(s => s.ProfileID == profile.ID && s.DateOfEffect != null).FirstOrDefault();
Hre_ContractEntity contractgetNo = new Hre_ContractEntity();
model.CopyData(contractgetNo);
Hre_ContractEntity contract = new Hre_ContractEntity
{
ID = model.ID,
Allowance = model.Allowance,
Allowance1 = model.Allowance1,
Allowance3 = model.Allowance3,
Allowance2 = model.Allowance2,
Allowance4 = model.Allowance4,
AllowanceID1 = lstBasicSalary.AllowanceType1ID,
AllowanceID2 = lstBasicSalary.AllowanceType2ID,
AllowanceID3 = lstBasicSalary.AllowanceType3ID,
AllowanceID4 = lstBasicSalary.AllowanceType4ID,
ClassRateID = lstBasicSalary.ClassRateID,
Code = model.Code,
CodeEmp = model.CodeEmp,
//ContractNo = getContractNo(contractgetNo, contractgetNo.DateSigned),
ContractTypeID = model.ContractTypeID,
CurenncyID = lstBasicSalary.CurrencyID,
CurenncyID1 = lstBasicSalary.CurrencyID1,
CurenncyID2 = lstBasicSalary.CurrencyID2,
CurenncyID3 = lstBasicSalary.CurrencyID3,
CurenncyID4 = lstBasicSalary.CurrencyID4,
CurenncyID5 = lstBasicSalary.CurrencyID5,
CurenncyIDSalary = model.CurenncyIDSalary,
CurenncyInsName = model.CurenncyInsName,
CurenncyOAllowanceName = model.CurenncyOAllowanceName,
CurrencySalName = model.CurrencySalName,
DateAuthorize = model.DateAuthorize,
DateCreate = model.DateCreate,
DateUpdate = DateTime.Now,
DateEnd = model.DateEnd,
DateSigned = model.DateSigned,
DateStart = model.DateStart,
FollowNo = model.FollowNo,
FormPaySalary = model.FormPaySalary,
HourWorkInMonth = model.HourWorkInMonth,
InsuranceAmount = model.InsuranceAmount,
IPCreate = model.IPCreate,
IPUpdate = model.IPUpdate,
JobTitleID = model.JobTitleID,
PersonalRate = model.PersonalRate,
PositionID = model.PositionID,
ProfileID = model.ProfileID,
ProfileSingID = model.ProfileSingID,
ProfileName = model.ProfileName,
ProfileSingName = model.ProfileSingName,
QualificationID = model.QualificationID,
RankRateID = lstBasicSalary.RankRateID,
Salary = lstBasicSalary == null ? (double?)null : Convert.ToDouble(lstBasicSalary.GrossAmount),
SalaryClassTypeID = lstBasicSalary.ClassRateID,
ServerCreate = model.ServerCreate,
ServerUpdate = model.ServerUpdate,
WorkPlaceID = model.WorkPlaceID,
};
if (contract.ID == Guid.Empty)
{
contract.ActionStatus = ContractServices.Add(contract);
}
else
{
contract.ActionStatus = ContractServices.Edit(contract);
}
return Json(contract, JsonRequestBehavior.AllowGet);
}
Hre_ContractEntity contractgetNoGetBasicSalary = new Hre_ContractEntity();
model.CopyData(contractgetNoGetBasicSalary);
Hre_ContractEntity contractNoGetBasicSalary = new Hre_ContractEntity
{
ID = model.ID,
Allowance = model.Allowance,
Allowance1 = model.Allowance1,
Allowance3 = model.Allowance3,
Allowance2 = model.Allowance2,
Allowance4 = model.Allowance4,
AllowanceID1 = model.AllowanceID1,
AllowanceID2 = model.AllowanceID2,
AllowanceID3 = model.AllowanceID3,
AllowanceID4 = model.AllowanceID4,
ClassRateID = model.ClassRateID,
ClassRateName = model.ClassRateName,
Code = model.Code,
CodeEmp = model.CodeEmp,
// ContractNo = getContractNo(contractgetNoGetBasicSalary, contractgetNoGetBasicSalary.DateSigned),
ContractTypeID = model.ContractTypeID,
CurenncyID = model.CurenncyID,
CurenncyID1 = model.CurenncyID1,
CurenncyID2 = model.CurenncyID2,
CurenncyID3 = model.CurenncyID3,
CurenncyID4 = model.CurenncyID4,
CurenncyID5 = model.CurenncyID5,
CurenncyIDSalary = model.CurenncyIDSalary,
CurenncyInsName = model.CurenncyInsName,
CurenncyOAllowanceName = model.CurenncyOAllowanceName,
CurrencySalName = model.CurrencySalName,
DateAuthorize = model.DateAuthorize,
DateCreate = model.DateCreate,
DateEnd = model.DateEnd,
DateSigned = model.DateSigned,
DateStart = model.DateStart,
DateUpdate = DateTime.Now,
FollowNo = model.FollowNo,
FormPaySalary = model.FormPaySalary,
HourWorkInMonth = model.HourWorkInMonth,
InsuranceAmount = model.InsuranceAmount,
IPCreate = model.IPCreate,
IPUpdate = model.IPUpdate,
JobTitleID = model.JobTitleID,
PersonalRate = model.PersonalRate,
PositionID = model.PositionID,
ProfileID = model.ProfileID,
ProfileSingID = model.ProfileSingID,
ProfileName = model.ProfileName,
ProfileSingName = model.ProfileSingName,
QualificationID = model.QualificationID,
RankRateID = model.RankRateID,
Salary = model.Salary,
SalaryClassTypeID = model.SalaryClassTypeID,
ServerCreate = model.ServerCreate,
ServerUpdate = model.ServerUpdate,
WorkPlaceID = model.WorkPlaceID,
};
if (contractNoGetBasicSalary.ID == Guid.Empty)
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Add(contractNoGetBasicSalary);
}
else
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Edit(contractNoGetBasicSalary);
}
return Json(contractNoGetBasicSalary, JsonRequestBehavior.AllowGet);
}
return Json(message, JsonRequestBehavior.AllowGet);
}
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 Hre_ContractEntity SetNewCodeContract(Hre_ContractEntity contractEntity, string strIdConstract)
{
if (contractEntity != null)
{
var actionService = new ActionService(UserLogin);
var status = string.Empty;
var objContractType1 = actionService.GetFirstData<Cat_ContractTypeEntity>(Common.DotNetToOracle(contractEntity.ContractTypeID.ToString()), ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status);
var objProfile1 = actionService.GetFirstData<Hre_ProfileEntity>(Common.DotNetToOracle(contractEntity.ProfileID.ToString()), ConstantSql.hrm_hr_sp_get_ProfileById, ref status);
if (objContractType1 != null)
{
var contractType = (Cat_ContractTypeEntity)objContractType1;
var profileEntity = (Hre_ProfileEntity)objProfile1;
if (!string.IsNullOrEmpty(contractType.Type))
{
var objSysConfig = actionService.GetFirstData<Sys_AllSettingEntity>(AppConfig.HRM_HRE_GENERATE_CODE_CONTRACT.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, ref status);
if (objSysConfig != null)
{
var sysConfig = (Sys_AllSettingEntity)objSysConfig;
if (sysConfig != null && !string.IsNullOrEmpty(sysConfig.Value1))
{
ElementFormula elementContactType = new ElementFormula("ContactType", contractType.Type, 0);
ElementFormula elementCodeEmp = new ElementFormula("CodeEmp", profileEntity.CodeEmp, 0);
ElementFormula elementOrdinal = new ElementFormula("Ordinal", 1, 0);
var result = FormulaHelper.ParseFormula(sysConfig.Value1, new List<ElementFormula>() { elementContactType, elementCodeEmp });
if (result != null && string.IsNullOrEmpty(result.ErrorMessage))
{
var value = result.Value;
if (value != null)
{
string newCode = value.ToString();
if (newCode.EndsWith("Ordinal"))
{
var strNewCode = newCode.Substring(0, newCode.Length - 7);
if (!string.IsNullOrEmpty(strIdConstract))
{
var listContractType = actionService.GetData<Cat_ContractTypeEntity>(Common.DotNetToOracle(strIdConstract), ConstantSql.hrm_cat_sp_get_ContractTypeByIds, ref status);
if (listContractType != null)
{
var listContractTypeById = listContractType.Where(d => d.Type == contractType.Type).FirstOrDefault();
if (listContractTypeById != null)
{
var listId = strIdConstract.Split(',').ToList();
var count = listId.Where(s => listContractTypeById.ID.ToString() == s).Select(d => d == listContractTypeById.ToString()).Count();
//var count = listContractTypeById.Count();
newCode = strNewCode + "-" + (count + 1);
}
else
{
//var listId = strIdConstract.Split(',').ToList();
//var count = listId.Select(d => d == listContractTypeById.ID.ToString()).Count();
newCode = strNewCode + "-" + "1";
}
}
else
{
newCode = strNewCode + "-" + 1;
}
}
else
{
newCode = strNewCode + "-" + 1;
}
}
contractEntity.ContractNo = newCode;
}
}
}
}
}
}
contractEntity.ActionStatus = status;
}
return contractEntity;
}
public Hre_ContractEntity SetNewDateEndNextContractByContractAndNextContractID(Hre_ContractEntity contractEntity, Guid nextContractID)
{
if (contractEntity != null)
{
var actionService = new ActionService(UserLogin);
var status = string.Empty;
var objContractType = actionService.GetFirstData<Cat_ContractTypeEntity>(Common.DotNetToOracle(nextContractID.ToString()), ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status);
if (objContractType != null)
{
var contractTypeEntity = (Cat_ContractTypeEntity)objContractType;
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
var formula = contractTypeEntity.Formula.Replace("\n", "").Replace("\t", "").Replace("\r", "");
ElementFormula elementContactType = new ElementFormula("ContractType", contractTypeEntity.Type, 0);
ElementFormula elementUnitType = new ElementFormula("UnitType", contractTypeEntity.UnitTime, 0);
ElementFormula elementValueTime = new ElementFormula("ValueTime", contractTypeEntity.ValueTime, 0);
ElementFormula elementDateStart = new ElementFormula("DateStart", contractEntity.DateStart, 0);
var result = FormulaHelper.ParseFormula(formula, new List<ElementFormula>() { elementContactType, elementUnitType, elementDateStart, elementValueTime });
if (result != null && string.IsNullOrEmpty(result.ErrorMessage))
{
if (result.Value.GetType().Name == "DateTime")
{
contractEntity.DateEndNextContract = (DateTime)result.Value;
}
else
{
contractEntity.ErrorMessage = contractEntity.ProfileName;
}
}
}
}
}
return contractEntity;
}
public ActionResult SaveProfileIDs([Bind]Hre_ContractModel model)
{
#region Validate
string message_Error = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "Hre_Contract", ref message_Error);
if (!checkValidate)
{
model.ActionStatus = message_Error;
return Json(message_Error, JsonRequestBehavior.AllowGet);
}
if (model.ContractEvaType == "E_ANNUAL_EVALUATION")
{
checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "EvaContractinfo", "Hre_Contract", ref message_Error);
if (!checkValidate)
{
model.ActionStatus = message_Error;
return Json(message_Error, JsonRequestBehavior.AllowGet);
}
}
#endregion
string status = string.Empty;
Guid convertProfileID = Guid.Empty;
string message = string.Empty;
List<Guid> lstProfileID = new List<Guid>();
var insuranceServices = new Sal_InsuranceSalaryServices();
var ContractServices = new Hre_ContractServices();
var hrService = new Hre_ProfileServices();
var actionService = new ActionService(UserLogin);
if (model.ID == Guid.Empty)
{
model.DateExtend = model.DateEnd;
}
if (model.ProfileIDs != null && model.ProfileIDs.IndexOf(',') > 1)
{
var lstID = model.ProfileIDs.Split(',');
for (int i = 0; i < lstID.Length; i++)
{
convertProfileID = Common.ConvertToGuid(lstID[i]);
lstProfileID.Add(convertProfileID);
}
}
else
{
convertProfileID = Common.ConvertToGuid(model.ProfileIDs);
lstProfileID.Add(convertProfileID);
}
var lstProfile = new List<Hre_ProfileEntity>();
if (model.ProfileIDs != null)
{
lstProfile = actionService.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(model.ProfileIDs), ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status).ToList();
}
if (!string.IsNullOrEmpty(model.OrgStructureIDs))
{
List<Guid> listGuid = new List<Guid>();
if (model.ProfileIDs != null)
{
var listStr = model.ProfileIDs.Split(',');
if (listStr[0] != "")
{
foreach (var item in listStr)
{
listGuid.Add(Guid.Parse(item));
}
}
}
string strIDs = string.Empty;
List<object> listObj = new List<object>();
listObj.Add(model.OrgStructureIDs);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
var lstProfileids = actionService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList();
if (listGuid != null)
{
lstProfileids = lstProfileids.Where(s => !listGuid.Contains(s)).ToList();
foreach (var item in lstProfileids)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
strIDs = strIDs.Substring(0, strIDs.Length - 1);
var lstProfileadd = actionService.GetData<Hre_ProfileEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status);
lstProfile.AddRange(lstProfileadd);
}
if (lstProfileids.Count == 0 && model.ProfileID == Guid.Empty)
{
model.ActionStatus = ConstantDisplay.HRM_Common_NotEmployee.TranslateString();
return Json(model.ActionStatus, JsonRequestBehavior.AllowGet);
lstProfile = lstProfile.Where(s => lstProfileids.Contains(s.ID)).ToList();
}
}
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();
foreach (var profile in lstProfile)
{
model.ProfileID = profile.ID;
var objContract = new List<object>();
objContract.Add(model.ProfileID);
var lstContractByProfileID = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var contractTypeEntity = lstContractType.Where(s => s.ID == model.ContractTypeID).FirstOrDefault();
#region Xử Lý Lương BHXH
if (contractTypeEntity != null && contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = model.ProfileID,
InsuranceAmount = model.InsuranceAmount,
DateEffect = model.DateStart,
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = model.CurenncyID1
};
message = insuranceServices.Add(insuranceEntity);
}
if (contractTypeEntity != null && contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID == model.ContractTypeID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = model.ProfileID,
InsuranceAmount = model.InsuranceAmount,
DateEffect = model.DateStart,
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = model.CurenncyID1
};
message = insuranceServices.Add(insuranceEntity);
}
}
#endregion
if (model.CreateBasicSalary == true)
{
Sal_BasicSalaryServices salaryservices = new Sal_BasicSalaryServices();
Sal_BasicSalaryEntity basicSalaryBycontract = new Sal_BasicSalaryEntity();
basicSalaryBycontract.ProfileID = profile.ID;
basicSalaryBycontract.GrossAmount = model.Salary != null ? model.Salary.ToString() : "0";
basicSalaryBycontract.CurrencyID = model.CurenncyID != null ? model.CurenncyID.Value : Guid.Empty;
basicSalaryBycontract.PersonalRate = model.PersonalRate;
basicSalaryBycontract.DateOfEffect = model.DateStart;
basicSalaryBycontract.InsuranceAmount = model.InsuranceAmount != null ? model.InsuranceAmount.Value : 0;
basicSalaryBycontract.CurrencyID1 = model.CurenncyID1;
basicSalaryBycontract.ClassRateID = model.ClassRateID;
basicSalaryBycontract.RankRateID = model.RankRateID;
basicSalaryBycontract.AllowanceType1ID = model.AllowanceID1;
basicSalaryBycontract.AllowanceAmount1 = model.Allowance1;
basicSalaryBycontract.CurrencyID2 = model.CurenncyID2;
basicSalaryBycontract.AllowanceType2ID = model.AllowanceID2;
basicSalaryBycontract.AllowanceAmount2 = model.Allowance2;
basicSalaryBycontract.CurrencyID3 = model.CurenncyID3;
basicSalaryBycontract.AllowanceType3ID = model.AllowanceID3;
basicSalaryBycontract.AllowanceAmount3 = model.Allowance3;
basicSalaryBycontract.CurrencyID4 = model.CurenncyIDSalary;
salaryservices.Add(basicSalaryBycontract);
}
if (model.BasicSalaryForPerson == true)
{
List<object> listObj = new List<object>();
listObj.Add(1);
listObj.Add(1000);
var BasicSalaryServices = new Sal_BasicSalaryServices();
var basicSalaryByProfile = actionService.GetData<Sal_BasicSalaryEntity>(Common.DotNetToOracle(profile.ID.ToString()), ConstantSql.hrm_sal_sp_get_BasicSalaryByProfileIds, ref status).FirstOrDefault();
Hre_ContractEntity contractgetNo = new Hre_ContractEntity();
model.CopyData(contractgetNo);
Hre_ContractEntity contract = new Hre_ContractEntity();
contract.Allowance = model.Allowance;
contract.Allowance1 = model.Allowance1;
contract.Allowance2 = model.Allowance2;
contract.Allowance3 = model.Allowance3;
contract.Allowance4 = model.Allowance4;
if (basicSalaryByProfile != null)
{
contract.AllowanceID1 = basicSalaryByProfile.AllowanceType1ID != null ? basicSalaryByProfile.AllowanceType1ID : null;
contract.AllowanceID2 = basicSalaryByProfile.AllowanceType2ID != null ? basicSalaryByProfile.AllowanceType2ID : null;
contract.AllowanceID3 = basicSalaryByProfile.AllowanceType3ID != null ? basicSalaryByProfile.AllowanceType3ID : null;
contract.AllowanceID4 = basicSalaryByProfile.AllowanceType4ID != null ? basicSalaryByProfile.AllowanceType4ID : null;
contract.ClassRateID = basicSalaryByProfile.ClassRateID != null ? basicSalaryByProfile.ClassRateID : null;
contract.CurenncyID = basicSalaryByProfile.CurrencyID;
contract.CurenncyID1 = basicSalaryByProfile.CurrencyID1 != null ? basicSalaryByProfile.CurrencyID1 : null;
contract.CurenncyID2 = basicSalaryByProfile.CurrencyID2 != null ? basicSalaryByProfile.CurrencyID2 : null;
contract.CurenncyID3 = basicSalaryByProfile.CurrencyID3 != null ? basicSalaryByProfile.CurrencyID3 : null;
contract.CurenncyID4 = basicSalaryByProfile.CurrencyID4 != null ? basicSalaryByProfile.CurrencyID4 : null;
contract.CurenncyID5 = basicSalaryByProfile.CurrencyID5 != null ? basicSalaryByProfile.CurrencyID5 : null;
}
contract.Code = model.Code;
contract.CodeEmp = model.CodeEmp;
contract.ContractTypeID = model.ContractTypeID;
contract.CurenncyIDSalary = model.CurenncyIDSalary;
contract.CurenncyInsName = model.CurenncyInsName;
contract.CurenncyOAllowanceName = model.CurenncyOAllowanceName;
contract.CurrencySalName = model.CurrencySalName;
contract.DateAuthorize = model.DateAuthorize;
contract.DateCreate = model.DateCreate;
contract.DateUpdate = DateTime.Now;
contract.DateEnd = model.DateEnd;
contract.DateSigned = model.DateSigned;
contract.DateStart = model.DateStart;
contract.FollowNo = model.FollowNo;
contract.FormPaySalary = model.FormPaySalary;
contract.HourWorkInMonth = model.HourWorkInMonth;
contract.InsuranceAmount = model.InsuranceAmount;
contract.IPCreate = model.IPCreate;
contract.IPUpdate = model.IPUpdate;
contract.JobTitleID = model.JobTitleID;
contract.PersonalRate = model.PersonalRate;
contract.PositionID = model.PositionID;
contract.ProfileID = model.ProfileID;
contract.ProfileSingID = model.ProfileSingID;
contract.ProfileName = model.ProfileName;
contract.ProfileSingName = model.ProfileSingName;
contract.QualificationID = model.QualificationID;
contract.RankRateID = basicSalaryByProfile.RankRateID;
contract.Salary = basicSalaryByProfile == null ? (double?)null : Convert.ToDouble(basicSalaryByProfile.GrossAmount);
contract.ClassRateID = basicSalaryByProfile.ClassRateID;
contract.SalaryClassTypeID = model.SalaryClassTypeID;
contract.ServerCreate = model.ServerCreate;
contract.ServerUpdate = model.ServerUpdate;
contract.WorkPlaceID = model.WorkPlaceID;
contract.NextContractTypeID = model.NextContractTypeID;
contract.Remark = model.Remark;
contract.RankDetailForNextContract = model.RankDetailForNextContract;
contract.ContractEvaType = model.ContractEvaType;
contract.DateOfContractEva = model.DateOfContractEva;
contract.EvaluationResult = model.EvaluationResult;
contract.ContractResult = model.ContractResult;
contract.TypeOfPass = model.TypeOfPass;
contract.DateEndNextContract = model.DateEndNextContract;
contract.DateExtend = model.DateEnd;
contract.Status = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contract = SetNewDateEndContract(contract);
}
//Tạo mã cho hợp đồng
// contract = SetNewCodeContract(contract, listIdContract);
if (contract.ID == Guid.Empty)
{
contract.ActionStatus = ContractServices.Add(contract);
}
else
{
contract.ActionStatus = ContractServices.Edit(contract);
}
return Json(contract, JsonRequestBehavior.AllowGet);
}
Hre_ContractEntity contractgetNoGetBasicSalary = new Hre_ContractEntity();
model.CopyData(contractgetNoGetBasicSalary);
Hre_ContractEntity contractNoGetBasicSalary = new Hre_ContractEntity();
contractNoGetBasicSalary.Allowance = model.Allowance;
contractNoGetBasicSalary.Allowance1 = model.Allowance1;
contractNoGetBasicSalary.Allowance3 = model.Allowance3;
contractNoGetBasicSalary.Allowance2 = model.Allowance2;
contractNoGetBasicSalary.Allowance4 = model.Allowance4;
contractNoGetBasicSalary.AllowanceID1 = model.AllowanceID1;
contractNoGetBasicSalary.AllowanceID2 = model.AllowanceID2;
contractNoGetBasicSalary.AllowanceID3 = model.AllowanceID3;
contractNoGetBasicSalary.AllowanceID4 = model.AllowanceID4;
contractNoGetBasicSalary.ClassRateID = model.ClassRateID;
contractNoGetBasicSalary.ClassRateName = model.ClassRateName;
contractNoGetBasicSalary.Code = model.Code;
contractNoGetBasicSalary.CodeEmp = model.CodeEmp;
contractNoGetBasicSalary.ContractTypeID = model.ContractTypeID;
contractNoGetBasicSalary.CurenncyID = model.CurenncyID;
contractNoGetBasicSalary.CurenncyID1 = model.CurenncyID1;
contractNoGetBasicSalary.CurenncyID2 = model.CurenncyID2;
contractNoGetBasicSalary.CurenncyID3 = model.CurenncyID3;
contractNoGetBasicSalary.CurenncyID4 = model.CurenncyID4;
contractNoGetBasicSalary.CurenncyID5 = model.CurenncyID5;
contractNoGetBasicSalary.CurenncyIDSalary = model.CurenncyIDSalary;
contractNoGetBasicSalary.CurenncyInsName = model.CurenncyInsName;
contractNoGetBasicSalary.CurenncyOAllowanceName = model.CurenncyOAllowanceName;
contractNoGetBasicSalary.CurrencySalName = model.CurrencySalName;
contractNoGetBasicSalary.DateAuthorize = model.DateAuthorize;
contractNoGetBasicSalary.DateCreate = model.DateCreate;
contractNoGetBasicSalary.DateEnd = model.DateEnd;
contractNoGetBasicSalary.DateSigned = model.DateSigned;
contractNoGetBasicSalary.DateStart = model.DateStart;
contractNoGetBasicSalary.DateUpdate = DateTime.Now;
contractNoGetBasicSalary.FollowNo = model.FollowNo;
contractNoGetBasicSalary.FormPaySalary = model.FormPaySalary;
contractNoGetBasicSalary.HourWorkInMonth = model.HourWorkInMonth;
contractNoGetBasicSalary.InsuranceAmount = model.InsuranceAmount;
contractNoGetBasicSalary.IPCreate = model.IPCreate;
contractNoGetBasicSalary.IPUpdate = model.IPUpdate;
contractNoGetBasicSalary.JobTitleID = model.JobTitleID;
contractNoGetBasicSalary.PersonalRate = model.PersonalRate;
contractNoGetBasicSalary.PositionID = model.PositionID;
contractNoGetBasicSalary.ProfileID = model.ProfileID;
contractNoGetBasicSalary.ProfileSingID = model.ProfileSingID;
contractNoGetBasicSalary.ProfileName = model.ProfileName;
contractNoGetBasicSalary.ProfileSingName = model.ProfileSingName;
contractNoGetBasicSalary.QualificationID = model.QualificationID;
contractNoGetBasicSalary.RankRateID = model.RankRateID;
contractNoGetBasicSalary.Salary = model.Salary;
contractNoGetBasicSalary.SalaryClassTypeID = model.SalaryClassTypeID;
contractNoGetBasicSalary.ServerCreate = model.ServerCreate;
contractNoGetBasicSalary.ServerUpdate = model.ServerUpdate;
contractNoGetBasicSalary.WorkPlaceID = model.WorkPlaceID;
contractNoGetBasicSalary.NextContractTypeID = model.NextContractTypeID;
contractNoGetBasicSalary.Remark = model.Remark;
contractNoGetBasicSalary.RankDetailForNextContract = model.RankDetailForNextContract;
contractNoGetBasicSalary.ContractEvaType = model.ContractEvaType;
contractNoGetBasicSalary.DateOfContractEva = model.DateOfContractEva;
contractNoGetBasicSalary.EvaluationResult = model.EvaluationResult;
contractNoGetBasicSalary.ContractResult = model.ContractResult;
contractNoGetBasicSalary.TypeOfPass = model.TypeOfPass;
contractNoGetBasicSalary.DateEndNextContract = model.DateEndNextContract;
contractNoGetBasicSalary.DateExtend = model.DateEnd;
contractNoGetBasicSalary.Status = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractNoGetBasicSalary = SetNewDateEndContract(contractNoGetBasicSalary);
}
//Tạo mã cho hợp đồng
// contractNoGetBasicSalary = SetNewCodeContract(contractNoGetBasicSalary, listIdContract);
if (contractNoGetBasicSalary.ID == Guid.Empty)
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Add(contractNoGetBasicSalary);
}
else
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Edit(contractNoGetBasicSalary);
}
message = contractNoGetBasicSalary.ActionStatus;
return Json(contractNoGetBasicSalary, JsonRequestBehavior.AllowGet);
}
return Json(null, JsonRequestBehavior.AllowGet);
}
public ActionResult EditContractByEvaContract([Bind]Hre_ContractModel model)
{
string status = string.Empty;
Guid convertProfileID = Guid.Empty;
string message = string.Empty;
var lstContractEidt = new List<Hre_ContractEntity>();
List<Guid> lstIDs = new List<Guid>();
var insuranceServices = new Sal_InsuranceSalaryServices();
var contractServices = new Hre_ContractServices();
if (model.selectedIds != null && model.selectedIds.IndexOf(',') > 1)
{
var lstID = model.selectedIds.Split(',');
for (int i = 0; i < lstID.Length; i++)
{
convertProfileID = Common.ConvertToGuid(lstID[i]);
lstIDs.Add(convertProfileID);
}
}
else
{
convertProfileID = Common.ConvertToGuid(model.selectedIds);
lstIDs.Add(convertProfileID);
}
var actionService = new ActionService(UserLogin);
var appendixContractServices = new Hre_AppendixContractServices();
var objContract = new List<object>();
objContract.AddRange(new object[21]);
objContract[19] = 1;
objContract[20] = int.MaxValue - 1;
var lstContract = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status).ToList();
if (lstIDs != null)
{
lstContract = lstContract.Where(s => lstIDs.Contains(s.ID)).ToList();
}
var objAppendixContarct = new List<object>();
objAppendixContarct.AddRange(new object[7]);
objAppendixContarct[5] = 1;
objAppendixContarct[6] = int.MaxValue - 1;
var lstAppendixContract = actionService.GetData<Hre_AppendixContractEntity>(objAppendixContarct, ConstantSql.hrm_hr_sp_get_AppendixContract, ref status).ToList();
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();
foreach (var item in lstContract)
{
if (item.DateExtend == null)
{
item.DateExtend = item.DateEnd;
}
item.ContractResult = model.ContractResult;
item.ContractEvaType = model.ContractEvaType;
item.ContractEvaType = model.ContractEvaType;
item.DateOfContractEva = model.DateOfContractEva;
item.EvaluationResult = model.EvaluationResult;
item.TypeOfPass = model.TypeOfPass;
item.RankDetailForNextContract = model.RankDetailForNextContract;
item.NextContractTypeID = model.NextContractTypeID;
item.StatusEvaluation = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
var nextContracttype = lstContractType.Where(s => s.ID == model.NextContractTypeID).FirstOrDefault();
var contractEntity = new Hre_ContractEntity();
contractEntity = item.CopyData<Hre_ContractEntity>();
if (item.DateEnd != null)
{
contractEntity.DateStart = item.DateEnd.Value.AddDays(1);
}
SetNewDateEndNextContractByContractAndNextContractID(contractEntity, model.NextContractTypeID.Value);
item.DateEndNextContract = contractEntity.DateEndNextContract;
message = contractServices.Edit(item);
}
return Json(message, JsonRequestBehavior.AllowGet);
}
public string getContractNo(Hre_ContractEntity contract, DateTime? DateSigned)
{
var profileService = new Hre_ProfileServices();
var actionService = new ActionService(UserLogin);
string status = string.Empty;
List<object> lstObjProfile = new List<object>();
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(1);
lstObjProfile.Add(100000000);
var profile = actionService.GetData<Hre_ProfileEntity>(contract.ProfileID, ConstantSql.hrm_hr_sp_get_ProfileById, ref status).FirstOrDefault();
if (profile == null)
return "";
//string contractNo = GetNewCode(contract, Hre_Contract.FieldNames.ContractNo);
//if (contractNo.IsNotNullOrEmpty())
//{
// return contractNo;
//}
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 = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status);
string contractNo = "HD/" + profile.CodeEmp + "/" + (DateSigned == null ? string.Empty : DateSigned.Value.Year.ToString());
int contractNumber = lstContracts.Count(s => s.IsDelete == null);
if (contractNumber > 1)
{
contractNo += "-" + contractNumber;
}
return contractNo;
}
public ActionResult GetContractTypeByID(string ContractTypeID, string ProfileID)
{
string status = string.Empty;
var contractTypeID = Guid.Empty;
var profileID = Guid.Empty;
if (!string.IsNullOrEmpty(ContractTypeID))
{
contractTypeID = Common.ConvertToGuid(ContractTypeID);
}
if (!string.IsNullOrEmpty(ProfileID))
{
if (ProfileID.IndexOf(',') > 1)
{
var profileIDs = ProfileID.Split(',');
profileID = Common.ConvertToGuid(profileIDs[0]);
}
else
{
profileID = Common.ConvertToGuid(ProfileID);
}
}
var actionService = new ActionService(UserLogin);
var lstContractType = actionService.GetData<Cat_ContractTypeEntity>(contractTypeID, ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status).FirstOrDefault();
var profileServices = new Hre_ProfileServices();
var profile = actionService.GetData<Hre_ProfileEntity>(profileID, ConstantSql.hrm_hr_sp_get_ProfileById, ref status).FirstOrDefault();
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 = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_Contract, ref status);
var contractByprofile = lstContracts.Where(s => s.ProfileID == profileID).OrderByDescending(s => s.DateEnd).FirstOrDefault();
if (lstContractType != null)
{
int month = 0;
if (lstContractType.Type == EnumDropDown.TypeContract.E_PROBATION.ToString() && profile != null)
{
if (profile.DateEndProbation != null)
{
lstContractType.DateStart = profile.DateHire;
lstContractType.DateSigned = profile.DateHire;
lstContractType.DateEnd = profile.DateEndProbation;
}
else
{
lstContractType.DateStart = DateTime.Now;
}
}
else
{
if (contractByprofile != null && contractByprofile.DateEnd != null)
{
lstContractType.DateStart = contractByprofile.DateEnd.Value.Date.AddDays(1);
lstContractType.DateSigned = lstContractType.DateStart;
}
else
{
lstContractType.DateStart = profile.DateHire;
lstContractType.DateSigned = profile.DateHire;
}
}
if (lstContractType.ValueTime != null)
{
month = (int)lstContractType.ValueTime.Value;
if (lstContractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
lstContractType.DateEnd = lstContractType.DateStart.Value.AddMonths(month);
}
if (!string.IsNullOrEmpty(lstContractType.Formula))
{
if (contractByprofile != null)
{
contractByprofile = SetNewDateEndContract(contractByprofile);
lstContractType.DateEnd = contractByprofile.DateEnd;
}
else
{
Hre_ContractEntity contractEntity = new Hre_ContractEntity();
contractEntity.DateStart = profile.DateHire.Value;
contractEntity.ContractTypeID = lstContractType.ID;
contractEntity = SetNewDateEndContract(contractEntity);
lstContractType.DateEnd = contractEntity.DateEnd;
}
}
}
return Json(lstContractType, JsonRequestBehavior.AllowGet);
}
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 UpdateDataForProfileWaiting(string SalaryClassName, string ProfileIDs, DateTime? DateEndProbation,
DateTime DateHire, Guid OrgStructureID, Guid? SalaryRankID, Guid? WorkPlaceID, Guid ContractTypeID, string BasicSalary,
Guid? GradePayrollID, Guid? GradeAttendanceID,
Guid? jobTitleID, Guid? positionID, Guid? allowanceID1, Guid? allowanceID2, Guid? allowanceID3, Guid? allowanceID4, Guid? allowanceID5,
double? allowance1, double? allowance2, double? allowance3, double? allowance4, double? allowance5, Guid? currencyID, double? insuranceSalary, string codeEmp)
{
var profileSevices = new Hre_ProfileServices();
string message = string.Empty;
string status = string.Empty;
var actionService = new ActionService(UserLogin);
var workingHistoryServices = new Hre_WorkHistoryServices();
var basicSalaryServices = new Sal_BasicSalaryServices();
var insServices = new Sal_InsuranceSalaryServices();
var attGradeServices = new Att_GradeServices();
var salGradeServices = new Sal_GradeServices();
var contractServices = new Hre_ContractServices();
var contractTypeServices = new Cat_ContractTypeServices();
var currencyServices = new Cat_CurrencyServices();
var settingServices = new Sys_AllSettingServices();
var lstProfiles = actionService.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status);
var candidateServices = new Hre_CandidateGeneralServices();
var lstCandidateGeneral = actionService.GetData<Hre_CandidateGeneralEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_hr_sp_get_CandidateGeneralByProfileIDs, ref status).ToList();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjRank = new List<object>();
lstObjRank.Add(null);
lstObjRank.Add(null);
lstObjRank.Add(1);
lstObjRank.Add(int.MaxValue - 1);
var lstRank = actionService.GetData<Cat_SalaryRankEntity>(lstObjRank, ConstantSql.hrm_cat_sp_get_SalaryRank, ref status).ToList();
var rankEntity = lstRank.Where(s => s.ID == SalaryRankID).FirstOrDefault();
Cat_SalaryClassEntity salaryClassEntity = null;
if (rankEntity != null)
{
var salaryClassServices = new Cat_SalaryClassServices();
var lstObjClass = new List<object>();
lstObjClass.Add(null);
lstObjClass.Add(1);
lstObjClass.Add(int.MaxValue - 1);
var salaryClass = actionService.GetData<Cat_SalaryClassEntity>(lstObjClass, ConstantSql.hrm_cat_sp_get_SalaryClass, ref status).ToList();
salaryClassEntity = salaryClass.Where(s => rankEntity.SalaryClassID == s.ID).FirstOrDefault();
}
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).ToList();
var lstProfile = new List<Hre_ProfileEntity>();
var workplaceServices = new Cat_WorkPlaceServices();
var workplace = actionService.GetData<Cat_WorkPlaceEntity>(Common.DotNetToOracle(WorkPlaceID.ToString()), ConstantSql.hrm_cat_sp_get_WorkPlaceById, ref status).FirstOrDefault();
var lstAttGrade = actionService.GetData<Att_GradeEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_sal_sp_get_Att_GradeByProfileIds, ref status).ToList();
var lstSalGrade = actionService.GetData<Sal_GradeEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_sal_sp_get_Sal_GradeByProfileIds, ref status).ToList();
var lstBasicSalary = actionService.GetData<Sal_BasicSalaryEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_sal_sp_get_BasicSalaryByProfileIds, ref status).ToList();
var lstInsuranceSalary = actionService.GetData<Sal_InsuranceSalaryEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_sal_sp_get_InsuranceSalaryByProfileIds, ref status).ToList();
var lstWorkingHistory = actionService.GetData<Hre_WorkHistoryEntity>(Common.DotNetToOracle(ProfileIDs), ConstantSql.hrm_hr_sp_get_WorkHistoryByProfileIds, ref status).ToList();
foreach (var item in lstProfiles)
{
var candidateGeneralByProfile = lstCandidateGeneral.Where(s => s.ProfileID.Value == item.ID).FirstOrDefault();
var objContract = new List<object>();
var lstContractByProfileID = actionService.GetData<Hre_ContractEntity>(Common.DotNetToOracle(item.ID.ToString()), ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var listIdContract = string.Empty;
if (lstContractByProfileID != null)
{
listIdContract = string.Join(",", lstContractByProfileID.Select(d => d.ContractTypeID));
}
var contractType = lstContractType.Where(s => s.ID == ContractTypeID).FirstOrDefault();
DateTime dateEnd = DateHire;
if (contractType != null)
{
if (contractType.ValueTime != null)
{
if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
{
dateEnd = DateHire.AddMonths(int.Parse(contractType.ValueTime.Value.ToString()));
}
else if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
dateEnd = DateHire.AddYears(int.Parse(contractType.ValueTime.Value.ToString()));
}
}
}
double Salary = 0;
if (!string.IsNullOrEmpty(BasicSalary))
Salary = double.Parse(BasicSalary);
if (candidateGeneralByProfile == null)
{
#region Add CandidateGeneral
Hre_CandidateGeneralEntity candidateGeneral = new Hre_CandidateGeneralEntity();
candidateGeneral.ProfileID = item.ID;
candidateGeneral.BasicSalary = Salary;
candidateGeneral.RankRateID = SalaryRankID;
if (salaryClassEntity != null)
{
candidateGeneral.SalaryClassID = salaryClassEntity.ID;
}
candidateGeneral.ContractTypeID = ContractTypeID;
candidateGeneral.EnteringDate = DateHire;
candidateGeneral.OrgStructureID = OrgStructureID;
candidateGeneral.GradeAttendanceID = GradeAttendanceID;
candidateGeneral.GradePayrollID = GradePayrollID;
candidateGeneral.WorkPlaceID = WorkPlaceID;
candidateGeneral.JobTitleID = jobTitleID;
candidateGeneral.PositionID = positionID;
candidateGeneral.AllowanceID1 = allowanceID1;
candidateGeneral.AllowanceID2 = allowanceID2;
candidateGeneral.AllowanceID3 = allowanceID3;
candidateGeneral.AllowanceID4 = allowanceID4;
candidateGeneral.AllowanceID5 = allowanceID5;
candidateGeneral.Allowance1 = allowance1;
candidateGeneral.Allowance2 = allowance2;
candidateGeneral.Allowance3 = allowance3;
candidateGeneral.Allowance4 = allowance4;
candidateGeneral.Allowance5 = allowance5;
candidateGeneral.CurrencyID = currencyID;
candidateGeneral.CodeEmp = codeEmp;
message = candidateServices.Add(candidateGeneral);
#endregion
#region Add Contract
//Add new contract
Hre_ContractEntity Contract = new Hre_ContractEntity();
Contract.ProfileID = item.ID;
Contract.Salary = Salary;
Contract.ContractTypeID = ContractTypeID;
Contract.DateStart = DateHire;
Contract.DateSigned = DateHire;
Contract.RankRateID = SalaryRankID;
if (salaryClassEntity != null)
{
Contract.ClassRateID = salaryClassEntity.ID;
}
Contract.InsuranceAmount = insuranceSalary;
Contract.AllowanceID1 = allowanceID1;
Contract.AllowanceID2 = allowanceID2;
Contract.AllowanceID3 = allowanceID3;
Contract.AllowanceID4 = allowanceID4;
Contract.Allowance1 = allowance1;
Contract.Allowance2 = allowance2;
Contract.Allowance3 = allowance3;
Contract.Allowance4 = allowance4;
Contract.Allowance = allowance5;
Contract.CurenncyID = currencyID;
Contract.CurenncyID1 = currencyID;
Contract.CurenncyID2 = currencyID;
Contract.CurenncyID3 = currencyID;
Contract.CurenncyIDSalary = currencyID;
Contract.CurenncyID4 = currencyID;
Contract.CurenncyID5 = currencyID;
Contract.Status = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
Contract.JobTitleID = jobTitleID;
Contract.PositionID = positionID;
if (!string.IsNullOrEmpty(contractType.Formula))
{
Contract = SetNewDateEndContract(Contract);
}
Contract.DateExtend = Contract.DateEnd;
// Contract = SetNewCodeContract(Contract, listIdContract);
message = contractServices.Add(Contract);
#endregion
#region Edit Profile
//Edit Profile
item.OrgStructureID = OrgStructureID;
if (salaryClassEntity != null)
{
item.SalaryClassID = salaryClassEntity.ID;
}
item.DateOfEffect = DateHire;
item.DateHire = DateHire;
item.DateEndProbation = Contract.DateEnd.Value;
item.WorkPlaceID = WorkPlaceID;
item.ContractTypeID = ContractTypeID;
item.CodeEmp = codeEmp;
item.StatusSyn = ProfileStatusSyn.E_WAITING.ToString();
message = profileSevices.Edit(item);
#endregion
#region Add Sal_Insurance
// Add Insurance
if (contractType != null && contractType.NoneTypeInsuarance == true)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ID,
InsuranceAmount = insuranceSalary,
DateEffect = DateHire,
IsSocialIns = contractType.IsSocialInsurance == null ? null : contractType.IsSocialInsurance,
IsUnimploymentIns = contractType.IsUnEmployInsurance == null ? null : contractType.IsUnEmployInsurance,
IsMedicalIns = contractType.IsHealthInsurance == null ? null : contractType.IsHealthInsurance,
CurrencyID = currencyID
};
message = insServices.Add(insuranceEntity);
}
#endregion
#region Add Sal_BasicSalary
Sal_BasicSalaryEntity basicSalaryEntity = new Sal_BasicSalaryEntity();
basicSalaryEntity.ProfileID = item.ID;
basicSalaryEntity.GrossAmount = BasicSalary;
basicSalaryEntity.Amount = BasicSalary.Encrypt();
basicSalaryEntity.DateOfEffect = DateHire;
basicSalaryEntity.RankRateID = SalaryRankID;
basicSalaryEntity.CurrencyID = currencyID.Value;
if (salaryClassEntity != null)
{
basicSalaryEntity.ClassRateID = salaryClassEntity.ID;
}
basicSalaryEntity.AllowanceType1ID = allowanceID1;
basicSalaryEntity.AllowanceType2ID = allowanceID2;
basicSalaryEntity.AllowanceType3ID = allowanceID3;
basicSalaryEntity.AllowanceType4ID = allowanceID4;
basicSalaryEntity.AllowanceTypeID5 = allowanceID5;
basicSalaryEntity.AllowanceAmount1 = allowance1;
basicSalaryEntity.AllowanceAmount2 = allowance2;
basicSalaryEntity.AllowanceAmount3 = allowance3;
basicSalaryEntity.AllowanceAmount4 = allowance4;
basicSalaryEntity.AllowanceAmount5 = allowance5;
basicSalaryEntity.CurrencyID5 = currencyID;
basicSalaryEntity.CurrencyID2 = currencyID;
basicSalaryEntity.CurrencyID3 = currencyID;
basicSalaryEntity.CurrencyID4 = currencyID;
if (insuranceSalary != null)
{
basicSalaryEntity.InsuranceAmount = insuranceSalary.Value;
}
message = basicSalaryServices.Add(basicSalaryEntity);
#endregion
#region Add WorkHistory
Hre_WorkHistoryEntity workHistory = new Hre_WorkHistoryEntity();
workHistory.ProfileID = item.ID;
workHistory.DateEffective = DateHire;
if (salaryClassEntity != null)
{
workHistory.SalaryClassID = salaryClassEntity.ID;
}
workHistory.OrganizationStructureID = OrgStructureID;
workHistory.WorkLocation = workplace != null ? workplace.WorkPlaceName : null;
workHistory.JobTitleID = jobTitleID;
workHistory.PositionID = positionID;
message = workingHistoryServices.Add(workHistory);
#endregion
#region Add Att_Grade
Att_GradeEntity attGradeEntity = new Att_GradeEntity();
attGradeEntity.ProfileID = item.ID;
attGradeEntity.GradeAttendanceID = GradeAttendanceID;
attGradeEntity.MonthStart = DateHire;
message = attGradeServices.Add(attGradeEntity);
#endregion
#region Add Sal_Grade
Sal_GradeEntity salGradeEntity = new Sal_GradeEntity();
salGradeEntity.ProfileID = item.ID;
salGradeEntity.GradePayrollID = GradePayrollID;
salGradeEntity.MonthStart = DateHire;
message = salGradeServices.Add(salGradeEntity);
#endregion
}
else
{
#region Edit CandidateGeneral
candidateGeneralByProfile.ProfileID = item.ID;
candidateGeneralByProfile.BasicSalary = Salary;
candidateGeneralByProfile.RankRateID = SalaryRankID;
if (salaryClassEntity != null)
{
candidateGeneralByProfile.SalaryClassID = salaryClassEntity.ID;
}
candidateGeneralByProfile.ContractTypeID = ContractTypeID;
candidateGeneralByProfile.EnteringDate = DateHire;
candidateGeneralByProfile.OrgStructureID = OrgStructureID;
candidateGeneralByProfile.GradeAttendanceID = GradeAttendanceID;
candidateGeneralByProfile.GradePayrollID = GradePayrollID;
candidateGeneralByProfile.WorkPlaceID = WorkPlaceID;
candidateGeneralByProfile.JobTitleID = jobTitleID;
candidateGeneralByProfile.PositionID = positionID;
candidateGeneralByProfile.AllowanceID1 = allowanceID1;
candidateGeneralByProfile.AllowanceID2 = allowanceID2;
candidateGeneralByProfile.AllowanceID3 = allowanceID3;
candidateGeneralByProfile.AllowanceID4 = allowanceID4;
candidateGeneralByProfile.AllowanceID5 = allowanceID5;
candidateGeneralByProfile.Allowance1 = allowance1;
candidateGeneralByProfile.Allowance2 = allowance2;
candidateGeneralByProfile.Allowance3 = allowance3;
candidateGeneralByProfile.Allowance4 = allowance4;
candidateGeneralByProfile.Allowance5 = allowance5;
candidateGeneralByProfile.CurrencyID = currencyID;
candidateGeneralByProfile.CodeEmp = codeEmp;
message = candidateServices.Edit(candidateGeneralByProfile);
#endregion
#region Edit Contract
if (lstContractByProfileID != null)
{
var contractEntityByProfileID = lstContractByProfileID.FirstOrDefault();
if (contractEntityByProfileID != null)
{
contractEntityByProfileID.Salary = Salary;
contractEntityByProfileID.ContractTypeID = ContractTypeID;
contractEntityByProfileID.DateStart = DateHire;
contractEntityByProfileID.DateSigned = DateHire;
contractEntityByProfileID.DateEnd = dateEnd;
contractEntityByProfileID.RankRateID = SalaryRankID;
if (salaryClassEntity != null)
{
contractEntityByProfileID.ClassRateID = salaryClassEntity.ID;
}
contractEntityByProfileID.InsuranceAmount = insuranceSalary;
contractEntityByProfileID.AllowanceID1 = allowanceID1;
contractEntityByProfileID.AllowanceID2 = allowanceID2;
contractEntityByProfileID.AllowanceID3 = allowanceID3;
contractEntityByProfileID.AllowanceID4 = allowanceID4;
contractEntityByProfileID.Allowance1 = allowance1;
contractEntityByProfileID.Allowance2 = allowance2;
contractEntityByProfileID.Allowance3 = allowance3;
contractEntityByProfileID.Allowance4 = allowance4;
contractEntityByProfileID.Allowance = allowance5;
contractEntityByProfileID.CurenncyID = currencyID;
contractEntityByProfileID.CurenncyID1 = currencyID;
contractEntityByProfileID.CurenncyID2 = currencyID;
contractEntityByProfileID.CurenncyID3 = currencyID;
contractEntityByProfileID.CurenncyIDSalary = currencyID;
contractEntityByProfileID.CurenncyID4 = currencyID;
contractEntityByProfileID.CurenncyID5 = currencyID;
contractEntityByProfileID.Status = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
contractEntityByProfileID.JobTitleID = jobTitleID;
contractEntityByProfileID.PositionID = positionID;
if (!string.IsNullOrEmpty(contractType.Formula))
{
contractEntityByProfileID = SetNewDateEndContract(contractEntityByProfileID);
}
if (contractEntityByProfileID.DateExtend == null)
{
contractEntityByProfileID.DateExtend = dateEnd;
}
message = contractServices.Edit(contractEntityByProfileID);
if (contractEntityByProfileID.DateEnd != null)
{
item.DateEndProbation = contractEntityByProfileID.DateEnd.Value;
}
}
}
#endregion
#region Edit Profile
//Edit Profile
item.OrgStructureID = OrgStructureID;
if (salaryClassEntity != null)
{
item.SalaryClassID = salaryClassEntity.ID;
}
item.DateOfEffect = DateHire;
item.DateHire = DateHire;
item.WorkPlaceID = WorkPlaceID;
item.ContractTypeID = ContractTypeID;
item.StatusSyn = ProfileStatusSyn.E_WAITING.ToString();
item.CodeEmp = codeEmp;
message = profileSevices.Edit(item);
#endregion
#region Edit Sal_Insurance
var insSalaryEntityByProfileID = lstInsuranceSalary.Where(s => s.ProfileID == item.ID).OrderBy(s => s.DateUpdate).FirstOrDefault();
if (insSalaryEntityByProfileID != null)
{
if (contractType != null && contractType.NoneTypeInsuarance == true)
{
insSalaryEntityByProfileID.InsuranceAmount = insuranceSalary;
insSalaryEntityByProfileID.DateEffect = DateHire;
insSalaryEntityByProfileID.IsSocialIns = contractType.IsSocialInsurance == null ? null : contractType.IsSocialInsurance;
insSalaryEntityByProfileID.IsUnimploymentIns = contractType.IsUnEmployInsurance == null ? null : contractType.IsUnEmployInsurance;
insSalaryEntityByProfileID.IsMedicalIns = contractType.IsHealthInsurance == null ? null : contractType.IsHealthInsurance;
insSalaryEntityByProfileID.CurrencyID = currencyID;
message = insServices.Edit(insSalaryEntityByProfileID);
}
}
#endregion
#region Edit Sal_BasicSalary
var basicSalaryEntityByProfileID = lstBasicSalary.Where(s => s.ProfileID == item.ID).FirstOrDefault();
if (basicSalaryEntityByProfileID != null)
{
basicSalaryEntityByProfileID.GrossAmount = BasicSalary;
basicSalaryEntityByProfileID.Amount = BasicSalary.Encrypt();
basicSalaryEntityByProfileID.DateOfEffect = DateHire;
basicSalaryEntityByProfileID.RankRateID = SalaryRankID;
if (salaryClassEntity != null)
{
basicSalaryEntityByProfileID.ClassRateID = salaryClassEntity.ID;
}
basicSalaryEntityByProfileID.CurrencyID = currencyID.Value;
basicSalaryEntityByProfileID.AllowanceType1ID = allowanceID1;
basicSalaryEntityByProfileID.AllowanceType2ID = allowanceID2;
basicSalaryEntityByProfileID.AllowanceType3ID = allowanceID3;
basicSalaryEntityByProfileID.AllowanceType4ID = allowanceID4;
basicSalaryEntityByProfileID.AllowanceTypeID5 = allowanceID5;
basicSalaryEntityByProfileID.AllowanceAmount1 = allowance1;
basicSalaryEntityByProfileID.AllowanceAmount2 = allowance2;
basicSalaryEntityByProfileID.AllowanceAmount3 = allowance3;
basicSalaryEntityByProfileID.AllowanceAmount4 = allowance4;
basicSalaryEntityByProfileID.AllowanceAmount5 = allowance5;
basicSalaryEntityByProfileID.CurrencyID5 = currencyID;
basicSalaryEntityByProfileID.CurrencyID2 = currencyID;
basicSalaryEntityByProfileID.CurrencyID3 = currencyID;
basicSalaryEntityByProfileID.CurrencyID4 = currencyID;
if (insuranceSalary != null)
{
basicSalaryEntityByProfileID.InsuranceAmount = insuranceSalary.Value;
}
message = basicSalaryServices.Edit(basicSalaryEntityByProfileID);
}
#endregion
#region Edit WorkingHistory
var workingByProfileID = lstWorkingHistory.Where(s => s.ProfileID == item.ID).FirstOrDefault();
if (workingByProfileID != null)
{
workingByProfileID.DateEffective = DateHire;
if (salaryClassEntity != null)
{
workingByProfileID.SalaryClassID = salaryClassEntity.ID;
}
workingByProfileID.OrganizationStructureID = OrgStructureID;
workingByProfileID.WorkLocation = workplace != null ? workplace.WorkPlaceName : null;
workingByProfileID.JobTitleID = jobTitleID;
workingByProfileID.PositionID = positionID;
message = workingHistoryServices.Edit(workingByProfileID);
}
#endregion
#region Edit Att_Grade
var attGradeEntityByProfileID = lstAttGrade.Where(s => s.ProfileID == item.ID).FirstOrDefault();
if (attGradeEntityByProfileID != null)
{
attGradeEntityByProfileID.GradeAttendanceID = GradeAttendanceID;
attGradeEntityByProfileID.MonthStart = DateHire;
message = attGradeServices.Edit(attGradeEntityByProfileID);
}
#endregion
#region Edit Sal_Grade
var salGradeEntityByProfileID = lstSalGrade.Where(s => s.ProfileID == item.ID).FirstOrDefault();
if (salGradeEntityByProfileID != null)
{
salGradeEntityByProfileID.GradePayrollID = GradePayrollID;
salGradeEntityByProfileID.MonthStart = DateHire;
message = salGradeServices.Edit(salGradeEntityByProfileID);
}
#endregion
}
}
return Json(message, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// HieuVan
/// Hàm xử lý tự động send mail hợp đồng đến hạn
/// </summary>
public static void SendMailContract()
{
BaseService _base = new BaseService();
string status = string.Empty;
string fullPath = string.Empty;
List<Hre_ContractSendMailEntity> lstProbation = new List<Hre_ContractSendMailEntity>();
List<Hre_ContractEntity> lstAttach = new List<Hre_ContractEntity>();
Hre_ContractEntity attach = new Hre_ContractEntity();
DateTime DS = DateTime.Now;
DateTime DE = DateTime.Now;
List<object> lstParam = new List<object>();
lstParam.AddRange(new object[3]);
var dataProfile = _base.GetData<Hre_ProfileEntity>(lstParam, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, string.Empty, ref status);
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoHre_Contract = new CustomBaseRepository<Hre_Contract>(unitOfWork);
var repoCat_ContractType = new CustomBaseRepository<Cat_ContractType>(unitOfWork);
var repoCat_Export = new CustomBaseRepository<Cat_Export>(unitOfWork);
var repoCat_OrgStructure = new CustomBaseRepository<Cat_OrgStructure>(unitOfWork);
var repoCat_OrgStructureType = new CustomBaseRepository<Cat_OrgStructureType>(unitOfWork);
var repoSys_TemplateSendMail = new CustomBaseRepository<Sys_TemplateSendMail>(unitOfWork);
string _typeTemplate = EnumDropDown.EmailType.E_WARNINGCONTRACT.ToString();
var template = repoSys_TemplateSendMail.FindBy(s => s.Type == _typeTemplate).FirstOrDefault();
if (template == null)
return;
var dataContractType = repoCat_ContractType.FindBy(s => s.ID != null).ToList();
var dataContract = repoHre_Contract.FindBy(s => s.IsDelete == null).ToList();
var dataOrgStructure = repoCat_OrgStructure.FindBy(s => s.IsDelete == null).ToList();
var dataOrgStructureType = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList();
// lọc từng hợp đồng, kiểm tra những hợp đồng nào đến hạn
Hre_ContractSendMailEntity entity = new Hre_ContractSendMailEntity();
List<string> lstTemp = new List<string>();
foreach (var item in dataContract)
{
lstTemp = new List<string>();
entity = new Hre_ContractSendMailEntity();
if (item.DateEnd == null)
continue;
var contractType = dataContractType.Where(s => s.ID == item.ContractTypeID).FirstOrDefault();
int loop = contractType.ExpiryContractLoop != null ? contractType.ExpiryContractLoop.Value : 0;
int dbd = contractType.ExpiryContractDayByDay != null ? contractType.ExpiryContractDayByDay.Value : 0;
DateTime loopStart = DateTime.Now.AddDays(loop);
DateTime dbdStart = DateTime.Now.AddDays(dbd);
if ((dbdStart >= item.DateEnd.Value || item.DateEnd.Value <= DateTime.Now) && item.ContractResult == null)
{
attach = item.Copy<Hre_ContractEntity>();
var profile = dataProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
entity.ContractID = item.ID;
entity.DayDue = item.DateEnd;
entity.ProfileName = profile.ProfileName;
attach.ProfileName = profile.ProfileName;
attach.CodeEmp = profile.CodeEmp;
entity.Type = EnumDropDown.ExpiredContractType.E_DayByDay.ToString();
if (contractType.EmailToList != null)
{
var lstCodeOrg = contractType.EmailToList.Split(',').ToList();
foreach (var itemCO in lstCodeOrg)
{
var temp = LibraryService.GetNearestParent(profile.OrgStructureID, (OrgUnit)Enum.Parse(typeof(OrgUnit), itemCO, true), dataOrgStructure, dataOrgStructureType);
if (temp == null || temp.Email == null)
continue;
var mailOfOrg = temp.Email.Split(',').ToList();
lstTemp.AddRange(mailOfOrg);
}
}
if (!string.IsNullOrEmpty(contractType.EmailOther))
{
var lstEmailOther = contractType.EmailOther.Split(',').ToList();
lstTemp.AddRange(lstEmailOther);
}
if (lstTemp != null)
entity.lstEmail = lstTemp;
lstAttach.Add(attach);
lstProbation.Add(entity);
}
else if ((loopStart >= item.DateEnd.Value || item.DateEnd.Value <= DateTime.Now) && item.ContractResult == null)
{
attach = item.Copy<Hre_ContractEntity>();
if (DateTime.Now.Day != contractType.DayInMonthLoop1 && DateTime.Now.Day != contractType.DayInMonthLoop2 && DateTime.Now.Day != contractType.DayInMonthLoop3)
continue;
var profile = dataProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
entity.ContractID = item.ID;
entity.DayDue = item.DateEnd;
entity.ProfileName = profile.ProfileName;
attach.ProfileName = profile.ProfileName;
attach.CodeEmp = profile.CodeEmp;
entity.Type = EnumDropDown.ExpiredContractType.E_Loop.ToString();
if (contractType.EmailToList != null)
{
var lstCodeOrg = contractType.EmailToList.Split(',').ToList();
foreach (var itemCO in lstCodeOrg)
{
var temp = LibraryService.GetNearestParent(profile.OrgStructureID, (OrgUnit)Enum.Parse(typeof(OrgUnit), itemCO, true), dataOrgStructure, dataOrgStructureType);
if (temp == null || temp.Email == null)
continue;
var mailOfOrg = temp.Email.Split(',').ToList();
lstTemp.AddRange(mailOfOrg);
}
}
if (!string.IsNullOrEmpty(contractType.EmailOther))
{
var lstEmailOther = contractType.EmailOther.Split(',').ToList();
lstTemp.AddRange(lstEmailOther);
}
if (lstTemp != null)
entity.lstEmail = lstTemp;
lstAttach.Add(attach);
lstProbation.Add(entity);
}
}
if (lstAttach.Count > 0)
{
var lstExport = repoCat_Export.FindBy(s => s.IsDelete == null && s.ScreenName == EnumDropDown.EmailType.E_WARNINGCONTRACT.ToString()).ToList();
if (lstExport.Count > 0)
{
var export = lstExport.FirstOrDefault();
fullPath = ExportService.Export(export.ID, lstAttach, null, ExportFileType.Excel);
}
}
List<Hre_ContractBodyEntity> lstSM = new List<Hre_ContractBodyEntity>();
Hre_ContractBodyEntity SM = new Hre_ContractBodyEntity();
List<Guid> lstGC = new List<Guid>();
foreach (var item in lstProbation)
{
string _type = "Theo Chu Kỳ";
if (item.Type == EnumDropDown.ExpiredContractType.E_DayByDay.ToString())
_type = "Hàng Ngày";
if (item.lstEmail == null)
continue;
string value = "<tr><td> " + item.ProfileName + " </td><td> " + item.DayDue + "</td><td> " + _type + "</td></tr>";
foreach (var email in item.lstEmail)
{
lstGC = new List<Guid>();
SM = new Hre_ContractBodyEntity();
var exits = lstSM.Where(m => m.Email == email).FirstOrDefault();
if (exits != null && !exits.lstGContract.Contains(item.ContractID))
{
if (SM.lstGContract != null)
lstGC = SM.lstGContract;
lstGC.Add(item.ContractID);
exits.lstGContract = lstGC;
exits.Body += value;
}
else if (exits == null || !exits.lstGContract.Contains(item.ContractID))
{
if (SM.lstGContract != null)
lstGC = SM.lstGContract;
lstGC.Add(item.ContractID);
SM.lstGContract = lstGC;
SM.Email = email;
SM.Body = value;
lstSM.Add(SM);
}
}
}
foreach (var item in lstSM)
{
string title = template.Subject;
var name = item.Email.Split('@');
#region magreData
string[] strsParaKey = null;
string[] strsParaValues = null;
strsParaKey = new string[]
{
EnumDropDown.EmailType_WARNINGCONTRACT.E_PROFILENAME.ToString(),
EnumDropDown.EmailType_WARNINGCONTRACT.E_TABLECONTENT.ToString(),
};
strsParaValues = new string[]
{
name[0].ToString(),
item.Body
};
string body = LibraryService.ReplaceContentFile(template.Content, strsParaKey, strsParaValues);
#endregion
//string body = "<html><head><title></title></head><body class='scayt-enabled'>Dear " + name[0].ToString() + " ,<br /><br />"
// + "This is email warning about contract probation:<br /> <br /><table border='1' cellpadding='1' cellspacing='1' style='width: 500px;'>"
// + "<tr><td> Nhân Viên </td><td> Ngày Hết Hạn </td><td> Loại Hết Hạn </td></tr>"
// + item.Body
// + "</tbody></table><tbody>"
// + "</body></html>";
_base.SendMail(title, item.Email, body, fullPath);
}
}
}
public Hre_ContractEntity SetNewDateEndContract(Hre_ContractEntity contractEntity,string userLogin)
{
if (contractEntity != null)
{
var service = new BaseService();
var status = string.Empty;
var objContractType = service.GetFirstData<Cat_ContractTypeEntity>(contractEntity.ContractTypeID, ConstantSql.hrm_cat_sp_get_ContractTypeById, userLogin, ref status);
if (objContractType != null)
{
var contractTypeEntity = (Cat_ContractTypeEntity)objContractType;
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
var formula = contractTypeEntity.Formula.Replace("\n", "").Replace("\t", "").Replace("\r", "");
ElementFormula elementContactType = new ElementFormula("ContractType", contractTypeEntity.Type, 0);
ElementFormula elementUnitType = new ElementFormula("UnitType", contractTypeEntity.UnitTime, 0);
ElementFormula elementValueTime = new ElementFormula("ValueTime", contractTypeEntity.ValueTime, 0);
ElementFormula elementDateStart = new ElementFormula("DateStart", contractEntity.DateStart, 0);
var result = FormulaHelper.ParseFormula(formula, new List<ElementFormula>() { elementContactType, elementUnitType, elementDateStart, elementValueTime });
if (result != null && string.IsNullOrEmpty(result.ErrorMessage))
{
if (result.Value.GetType().Name == "DateTime")
{
contractEntity.DateEnd = (DateTime)result.Value;
}
else
{
contractEntity.ErrorMessage += contractEntity.ProfileName + ",";
contractEntity.ActionStatus = ConstantMessages.WrongFormulaInContractType.ToString();
}
}
}
}
}
return contractEntity;
}
public void UpdateSalaryClassNameForProfile(string SalaryClassName, string ProfileIDs, DateTime DateEndProbation, DateTime DateHire, Guid OrgStructureID, Guid SalaryRankID, Guid WorkPlaceID, Guid ContractTypeID, string BasicSalary, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
string status = string.Empty;
var repo = new Hre_ProfileRepository(unitOfWork);
var profileSevices = new Hre_ProfileServices();
var repoWorkHistory = new CustomBaseRepository<Hre_WorkHistory>(unitOfWork);
var workingHistoryServices = new Hre_WorkHistoryServices();
// var insuranceServices = new Sal_InsuranceSalaryServices();
var ObjProfile = new List<object>();
ObjProfile.AddRange(new object[17]);
ObjProfile[15] = 1;
ObjProfile[16] = int.MaxValue - 1;
List<Guid> lstProfileIDs = ProfileIDs.Split(',').Select(x => Guid.Parse(x)).ToList();
var lstProfiles = profileSevices.GetData<Hre_ProfileEntity>(ObjProfile, ConstantSql.hrm_hr_sp_get_ProfileAll, userLogin, ref status).Where(s => lstProfileIDs.Contains(s.ID)).ToList();
var contractServices = new Hre_ContractServices();
var repoContract = new Hre_ContractRepository(unitOfWork);
List<Hre_ContractEntity> lstContract = new List<Hre_ContractEntity>();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjRank = new List<object>();
lstObjRank.Add(null);
lstObjRank.Add(null);
lstObjRank.Add(1);
lstObjRank.Add(int.MaxValue - 1);
var lstRank = salaryRankServices.GetData<Cat_SalaryRankEntity>(lstObjRank, ConstantSql.hrm_cat_sp_get_SalaryRank, userLogin, ref status).ToList().Translate<Cat_SalaryRank>();
var rankEntity = lstRank.Where(s => s.ID == SalaryRankID).FirstOrDefault();
var salaryClassServices = new Cat_SalaryClassServices();
var lstObjClass = new List<object>();
lstObjClass.Add(null);
lstObjClass.Add(1);
lstObjClass.Add(int.MaxValue - 1);
var salaryClass = salaryClassServices.GetData<Cat_SalaryClassEntity>(lstObjClass, ConstantSql.hrm_cat_sp_get_SalaryClass, userLogin, ref status).ToList().Translate<Cat_SalaryClass>();
var salaryClassEntity = salaryClass.Where(s => rankEntity.SalaryClassID == s.ID).FirstOrDefault();
var lstObjContractType = new List<object>();
lstObjContractType.AddRange(new object[6]);
lstObjContractType[4] = 1;
lstObjContractType[5] = int.MaxValue - 1;
var lstContractType = GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, userLogin, ref status).ToList();
var candidateServices = new Hre_CandidateGeneralServices();
var objCan = new List<object>();
objCan.AddRange(new object[14]);
objCan[12] = 1;
objCan[13] = int.MaxValue - 1;
var lstCan = candidateServices.GetData<Hre_CandidateGeneralEntity>(objCan, ConstantSql.hrm_hr_sp_get_CandidateGeneral, userLogin, ref status).ToList();
var lstProfile = new List<Hre_ProfileEntity>();
var workplaceServices = new Cat_WorkPlaceServices();
var workplace = workplaceServices.GetData<Cat_WorkPlaceEntity>(Common.DotNetToOracle(WorkPlaceID.ToString()), ConstantSql.hrm_cat_sp_get_WorkPlaceById, userLogin, ref status).FirstOrDefault();
foreach (var item in lstProfiles)
{
var canEntity = lstCan.Where(s => s.ProfileID.Value == item.ID).FirstOrDefault();
if (canEntity == null)
{
//Add new contract
var objContract = new List<object>();
objContract.Add(item.ID);
var lstContractByProfileID = contractServices.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, userLogin, ref status);
var listIdContract = string.Empty;
if (lstContractByProfileID != null)
{
listIdContract = string.Join(",", lstContractByProfileID.Select(d => d.ContractTypeID));
}
var contractType = lstContractType.Where(s => s.ID == ContractTypeID).FirstOrDefault();
DateTime dateEnd = DateHire;
if (contractType != null)
{
if (contractType.ValueTime != null)
{
//month = (int)contractType.ValueTime.Value;
//if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
//{
// month = month * 12;
//}
if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
{
dateEnd = DateHire.AddMonths(int.Parse(contractType.ValueTime.Value.ToString()));
}
else if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
dateEnd = DateHire.AddYears(int.Parse(contractType.ValueTime.Value.ToString()));
}
}
}
double Salary = 0;
if (!string.IsNullOrEmpty(BasicSalary))
Salary = double.Parse(BasicSalary);
Hre_ContractEntity Contract = new Hre_ContractEntity();
Contract.ProfileID = item.ID;
Contract.Salary = Salary;
Contract.ContractTypeID = ContractTypeID;
Contract.DateStart = DateHire;
Contract.DateSigned = DateHire;
Contract.DateEnd = dateEnd;
Contract.RankRateID = SalaryRankID;
Contract.ClassRateID = salaryClassEntity.ID;
if (!string.IsNullOrEmpty(contractType.Formula))
{
Contract = SetNewDateEndContract(Contract, userLogin);
}
Contract = SetNewCodeContract(Contract, listIdContract, userLogin);
contractServices.Add(Contract);
//Edit Profile
item.OrgStructureID = OrgStructureID;
item.SalaryClassID = salaryClassEntity == null ? Guid.Empty : salaryClassEntity.ID;
item.DateOfEffect = DateHire;
item.DateHire = DateHire;
item.DateEndProbation = Contract.DateEnd.Value;
item.WorkPlaceID = WorkPlaceID;
item.ContractTypeID = ContractTypeID;
profileSevices.Edit(item);
//// Add Insurance
//if (contractType != null && contractType.NoneTypeInsuarance == true)
//{
// var insuranceEntity = new Sal_InsuranceSalaryEntity
// {
// ProfileID = item.ID,
// InsuranceAmount = model.InsuranceAmount,
// DateEffect = DateHire,
// IsSocialIns = contractType.IsSocialInsurance == null ? null : contractType.IsSocialInsurance,
// IsUnimploymentIns = contractType.IsUnEmployInsurance == null ? null : contractType.IsUnEmployInsurance,
// IsMedicalIns = contractType.IsHealthInsurance == null ? null : contractType.IsHealthInsurance,
// CurrencyID = model.CurenncyID1
// };
// insuranceServices.Add(insuranceEntity);
//}
Hre_WorkHistoryEntity workHistory = new Hre_WorkHistoryEntity();
workHistory.ProfileID = item.ID;
workHistory.DateEffective = DateHire;
workHistory.SalaryClassID = salaryClassEntity == null ? Guid.Empty : salaryClassEntity.ID;
workHistory.OrganizationStructureID = OrgStructureID;
workHistory.WorkLocation = workplace != null ? workplace.WorkPlaceName : null;
workingHistoryServices.Add(workHistory);
}
}
}
}
public void AddDataForContract(string BasicSalary, string ProfileIDs, Guid ContractTypeID, DateTime DateHire, Guid SalaryRankID, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var repoContract = new Hre_ContractRepository(unitOfWork);
List<Hre_ContractEntity> lstContract = new List<Hre_ContractEntity>();
var contractServices = new Hre_ContractServices();
List<Guid> lstProfileIDs = ProfileIDs.Split(',').Select(x => Guid.Parse(x)).ToList();
var repoSalaryRank = new CustomBaseRepository<Cat_SalaryRank>(unitOfWork);
var repoSalaryClass = new CustomBaseRepository<Cat_SalaryClass>(unitOfWork);
// var salaryRank = repoSalaryRank.FindBy(s => s.IsDelete == null && s.ID == SalaryRankID).FirstOrDefault();
// var salaryClass = repoSalaryClass.FindBy(s => s.IsDelete == null && s.ID == salaryRank.SalaryClassID).FirstOrDefault();
var lstObjContractType = new List<object>();
lstObjContractType.AddRange(new object[6]);
lstObjContractType[4] = 1;
lstObjContractType[5] = int.MaxValue - 1;
var lstContractType = GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, userLogin, ref status).ToList();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjRank = new List<object>();
lstObjRank.Add(null); lstObjRank.Add(null);
lstObjRank.Add(1);
lstObjRank.Add(int.MaxValue - 1);
var lstRank = salaryRankServices.GetData<Cat_SalaryRankEntity>(lstObjRank, ConstantSql.hrm_cat_sp_get_SalaryRank, userLogin, ref status).ToList().Translate<Cat_SalaryRank>();
var rankEntity = lstRank.Where(s => s.ID == SalaryRankID).FirstOrDefault();
var salaryClassServices = new Cat_SalaryClassServices();
var lstObjClass = new List<object>();
lstObjClass.Add(null);
lstObjClass.Add(1);
lstObjClass.Add(int.MaxValue - 1);
var salaryClass = salaryClassServices.GetData<Cat_SalaryClassEntity>(lstObjClass, ConstantSql.hrm_cat_sp_get_SalaryClass, userLogin, ref status).ToList().Translate<Cat_SalaryClass>();
var salaryClassEntity = salaryClass.Where(s => rankEntity.SalaryClassID == s.ID).FirstOrDefault();
// var contractType = lstContractType.Where(s => s.ID == ContractTypeID).FirstOrDefault();
foreach (var item in lstProfileIDs)
{
//model.ProfileID = profile.ID;
var objContract = new List<object>();
objContract.Add(item);
var lstContractByProfileID = contractServices.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, userLogin, ref status);
var listIdContract = string.Empty;
if (lstContractByProfileID != null)
{
listIdContract = string.Join(",", lstContractByProfileID.Select(d => d.ContractTypeID));
}
var contractType = lstContractType.Where(s => s.ID == ContractTypeID).FirstOrDefault();
DateTime dateEnd = DateHire;
if (contractType != null)
{
if (contractType.ValueTime != null)
{
//month = (int)contractType.ValueTime.Value;
//if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
//{
// month = month * 12;
//}
if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
{
dateEnd = DateHire.AddMonths(int.Parse(contractType.ValueTime.Value.ToString()));
}
else if (contractType.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
dateEnd = DateHire.AddYears(int.Parse(contractType.ValueTime.Value.ToString()));
}
}
}
double Salary = 0;
if (!string.IsNullOrEmpty(BasicSalary))
Salary = double.Parse(BasicSalary);
Hre_ContractEntity Contract = new Hre_ContractEntity();
Contract.ProfileID = item;
Contract.Salary = Salary;
Contract.ContractTypeID = ContractTypeID;
Contract.DateStart = DateHire;
Contract.DateSigned = DateHire;
Contract.DateEnd = dateEnd;
Contract.RankRateID = SalaryRankID;
Contract.ClassRateID = salaryClassEntity.ID;
if (!string.IsNullOrEmpty(contractType.Formula))
{
Contract = SetNewDateEndContract(Contract, userLogin);
}
Contract = SetNewCodeContract(Contract, listIdContract, userLogin);
lstContract.Add(Contract);
}
contractServices.Add(lstContract);
repoContract.SaveChanges();
}
}