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); }
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); } } } }