public Hre_WorkHistoryModel Post([Bind] Hre_WorkHistoryModel model)
{
#region Validate
BaseService BaseService = new BaseService();
string status = string.Empty;
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData <Hre_WorkHistoryModel>(model, "Hre_WorkHistory", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return(model);
}
#endregion
var WorkHistoryServices = new Hre_WorkHistoryServices();
var SalaryClassServices = new Cat_SalaryClassServices();
var OrgStructureServices = new Cat_OrgStructureServices();
var JobTitleServices = new Cat_JobTitleServices();
var PositionServices = new Cat_PositionServices();
var WorkHistoryOld = BaseService.GetData <Hre_WorkHistoryEntity>(Common.DotNetToOracle(model.ProfileID.ToString()), ConstantSql.hrm_hr_sp_get_WorkHistoryByProfileId, UserLogin, ref status).OrderByDescending(s => s.DateEffective).FirstOrDefault();
if (WorkHistoryOld != null)
{
model.SalaryClassNameOld = WorkHistoryOld.SalaryClassName;
model.JobTitleOld = WorkHistoryOld.JobTitleName;
model.PositionOld = WorkHistoryOld.PositionName;
model.OrgStructureOldID = WorkHistoryOld.OrganizationStructureID;
model.WorkLocationOld = WorkHistoryOld.WorkLocation;
}
if (model.SalaryClassID != null)
{
var abilityTitleBySalaryClass = BaseService.GetData <Cat_AbilityTileEntity>(Common.DotNetToOracle(model.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId, UserLogin, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
model.AbilityTileID = abilityTitleBySalaryClass.ID;
}
}
// Son.Vo - 20140107 - Xử lý cập nhật ngược lại bảng profile
if (model.Status == WorkHistoryStatus.E_APPROVED.ToString() && model.DateEffective != null && model.DateEffective <= DateTime.Now.Date)
{
Hre_ProfileServices profileServices = new Hre_ProfileServices();
Hre_ProfileEntity profile = BaseService.GetData <Hre_ProfileEntity>(Common.DotNetToOracle(model.ProfileID.ToString()), ConstantSql.hrm_hr_sp_get_ProfileById, UserLogin, ref status).FirstOrDefault();
if (profile != null)
{
profile.OrgStructureID = model.OrganizationStructureID;
profile.JobTitleID = model.JobTitleID;
profile.PositionID = model.PositionID;
profile.DateOfEffect = model.DateEffective;
profile.LaborType = model.LaborType;
profile.CostCentreID = model.CostCentreID;
profile.FormType = model.FormType;
profile.EmpTypeID = model.EmployeeTypeID;
profile.WorkingPlace = model.WorkLocation;
profile.AbilityTileID = model.AbilityTileID;
profileServices.Edit(profile);
}
}
ActionService service = new ActionService(UserLogin);
return(service.UpdateOrCreate <Hre_WorkHistoryEntity, Hre_WorkHistoryModel>(model));
}
public void AddDataForBasicSalary(string ProfileIDs, string BasicSalary, DateTime DateHire, Guid SalaryRankID,string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
string status = string.Empty;
var repoBasicSalary = new CustomBaseRepository<Sal_BasicSalary>(unitOfWork);
List<Guid> lstProfileIDs = ProfileIDs.Split(',').Select(x => Guid.Parse(x)).ToList();
List<Sal_BasicSalary> lstBasicSalary = new List<Sal_BasicSalary>();
//chua co cach giai quyet nen hard code lay mac dinh la VND
var repoCurrency = new CustomBaseRepository<Cat_Currency>(unitOfWork);
var currency = repoCurrency.FindBy(s => s.IsDelete == null && s.CurrencyName == "VND").FirstOrDefault();
//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 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();
foreach (var item in lstProfileIDs)
{
Sal_BasicSalary objBasicSalary = new Sal_BasicSalary();
objBasicSalary.ProfileID = item;
objBasicSalary.GrossAmount = BasicSalary;
objBasicSalary.Amount = BasicSalary.Encrypt();
objBasicSalary.DateOfEffect = DateHire;
objBasicSalary.RankRateID = SalaryRankID;
objBasicSalary.CurrencyID = currency.ID;
objBasicSalary.ClassRateID = salaryClassEntity == null ? Guid.Empty : salaryClassEntity.ID;
lstBasicSalary.Add(objBasicSalary);
}
repoBasicSalary.Add(lstBasicSalary);
repoBasicSalary.SaveChanges();
}
}
public void AddDataForBasicSalary(string ProfileIDs, string BasicSalary, DateTime DateHire, Guid SalaryRankID, string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
string status = string.Empty;
var repoBasicSalary = new CustomBaseRepository <Sal_BasicSalary>(unitOfWork);
List <Guid> lstProfileIDs = ProfileIDs.Split(',').Select(x => Guid.Parse(x)).ToList();
List <Sal_BasicSalary> lstBasicSalary = new List <Sal_BasicSalary>();
//chua co cach giai quyet nen hard code lay mac dinh la VND
var repoCurrency = new CustomBaseRepository <Cat_Currency>(unitOfWork);
var currency = repoCurrency.FindBy(s => s.IsDelete == null && s.CurrencyName == "VND").FirstOrDefault();
//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 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();
foreach (var item in lstProfileIDs)
{
Sal_BasicSalary objBasicSalary = new Sal_BasicSalary();
objBasicSalary.ProfileID = item;
objBasicSalary.GrossAmount = BasicSalary;
objBasicSalary.Amount = BasicSalary.Encrypt();
objBasicSalary.DateOfEffect = DateHire;
objBasicSalary.RankRateID = SalaryRankID;
objBasicSalary.CurrencyID = currency.ID;
objBasicSalary.ClassRateID = salaryClassEntity == null ? Guid.Empty : salaryClassEntity.ID;
lstBasicSalary.Add(objBasicSalary);
}
repoBasicSalary.Add(lstBasicSalary);
repoBasicSalary.SaveChanges();
}
}
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 ActionResult ActionApplyCandidateGeneral(string selectedIds)
{
string message = NotificationType.Success.ToString();
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var lstCandidateGeneral = actionService.GetData<Hre_CandidateGeneralEntity>(Common.DotNetToOracle(selectedIds), ConstantSql.hrm_hr_sp_get_GeneralCandidateByIds, ref status);
var salaryRankServices = new Cat_SalaryRankServices();
var salaryClassServices = new Cat_SalaryClassServices();
var profileServices = new Hre_ProfileServices();
var contracttypeServices = new Cat_ContractTypeServices();
var workHistoryServices = new Hre_WorkHistoryServices();
var rankEntity = new Cat_SalaryRankEntity();
var salaryClass = new Cat_SalaryClassEntity();
var contractypeentity = new Cat_ContractTypeEntity();
ActionService service = new ActionService(UserLogin);
var salgradeServices = new Sal_GradeServices();
var attgradeservive = new Att_GradeServices();
foreach (var CandidateGeneral in lstCandidateGeneral)
{
#region Code Cũ
//var datecontract = DateTime.Now;
//if (CandidateGeneral.EnteringDate != null)
//{
// datecontract = CandidateGeneral.EnteringDate.Value;
//}
//if (CandidateGeneral.RankRateID != Guid.Empty)
//{
// rankEntity = service.GetByIdUseStore<Cat_SalaryRankEntity>(CandidateGeneral.RankRateID.Value,
// ConstantSql.hrm_cat_sp_get_SalaryRankById, ref status);
//}
//if(CandidateGeneral.ContractTypeID != Guid.Empty)
//{
// contractypeentity = service.GetByIdUseStore<Cat_ContractTypeEntity>(CandidateGeneral.ContractTypeID.Value, ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status);
//}
//var profileEntity = profileServices.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(CandidateGeneral.ProfileID.ToString()),
// ConstantSql.hrm_hr_sp_get_ProfileById, ref status).FirstOrDefault();
//if (contractypeentity != null && contractypeentity.ValueTime != null)
//{
// if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
// {
// datecontract = datecontract.AddMonths(int.Parse(contractypeentity.ValueTime.Value.ToString()));
// }
// else if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
// {
// datecontract = datecontract.AddYears(int.Parse(contractypeentity.ValueTime.Value.ToString()));
// }
//}
//if(profileEntity != null)
//{
// profileEntity.OrgStructureID = CandidateGeneral.OrgStructureID;
// profileEntity.SalaryClassID = CandidateGeneral.SalaryClassID;
// profileEntity.DateHire = CandidateGeneral.EnteringDate;
// profileEntity.DateEndProbation = datecontract;
// profileEntity.WorkPlaceID = CandidateGeneral.WorkPlaceID;
//}
// var workplaceServices = new Cat_WorkPlaceServices();
// Cat_WorkPlaceEntity workplace = null;
//if(CandidateGeneral.WorkPlaceID != Guid.Empty)
//{
//workplace = workplaceServices.GetData<Cat_WorkPlaceEntity>(Common.DotNetToOracle(CandidateGeneral.WorkPlaceID.ToString()), ConstantSql.hrm_cat_sp_get_WorkPlaceById, ref status).FirstOrDefault();
//}
//var WorkHistoryEntity = new Hre_WorkHistoryEntity();
// WorkHistoryEntity.ProfileID = CandidateGeneral.ProfileID.Value;
// WorkHistoryEntity.DateEffective = CandidateGeneral.EnteringDate != null ? CandidateGeneral.EnteringDate.Value ? DateTime.Now;
// WorkHistoryEntity.SalaryClassID = CandidateGeneral.SalaryClassID;
// WorkHistoryEntity.OrganizationStructureID = CandidateGeneral.OrgStructureID;
// WorkHistoryEntity.WorkLocation = workplace != null ? workplace.WorkPlaceName : null;
// workHistoryServices.Add(WorkHistoryEntity);
//}
#endregion
var datecontract = DateTime.Now;
if (CandidateGeneral.ContractTypeID != Guid.Empty)
{
contractypeentity = actionService.GetData<Cat_ContractTypeEntity>(Common.DotNetToOracle(CandidateGeneral.ContractTypeID.ToString()),
ConstantSql.hrm_cat_sp_get_ContractTypeById, ref status).FirstOrDefault();
}
if (contractypeentity != null && contractypeentity.ValueTime != null)
{
if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_MONTH.ToString())
{
datecontract = datecontract.AddMonths(int.Parse(contractypeentity.ValueTime.Value.ToString()));
}
else if (contractypeentity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
datecontract = datecontract.AddYears(int.Parse(contractypeentity.ValueTime.Value.ToString()));
}
}
profileServices.UpdateSalaryClassNameForProfile(null, CandidateGeneral.ProfileID.ToString(), datecontract, CandidateGeneral.EnteringDate.Value,
CandidateGeneral.OrgStructureID.Value, CandidateGeneral.RankRateID.Value, CandidateGeneral.WorkPlaceID.Value, CandidateGeneral.ContractTypeID.Value,
CandidateGeneral.BasicSalary.ToString(), UserLogin);
// profileServices.AddDataForContract(CandidateGeneral.BasicSalary.ToString(), CandidateGeneral.ProfileID.ToString(), CandidateGeneral.ContractTypeID.Value, CandidateGeneral.EnteringDate.Value, CandidateGeneral.RankRateID.Value);
salgradeServices.AddDataForGrade(CandidateGeneral.ProfileID.ToString(), CandidateGeneral.GradePayrollID.Value, CandidateGeneral.EnteringDate.Value);
attgradeservive.AddDataForGrade(CandidateGeneral.ProfileID.ToString(), CandidateGeneral.GradeAttendanceID.Value, CandidateGeneral.EnteringDate.Value);
}
return Json(message, JsonRequestBehavior.AllowGet);
}
public DataTable GetReportTraineeJoinCourse(Guid[] rankIds, string[] courseIds, string orderNumber, bool IsCreateTemplate, DateTime? dateSeniory, string UserLogin)
{
DataTable table = CreateReportTraineeJoinCourseSchema();
if (IsCreateTemplate)
{
return table;
}
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
var dateCheck = DateTime.Now;
//var dateSeniotyConfig = "31/03/N";
// var strDateSeniorty = dateSeniotyConfig.Split('/');
var dateCheckConfig = DateTime.Now;
//if (dateCheckConfig.Day <= int.Parse(strDateSeniorty[0]) && dateCheckConfig.Month <= int.Parse(strDateSeniorty[1]))
//{
// dateCheckConfig = new DateTime(dateCheckConfig.Year - 1, dateCheckConfig.Month, dateCheckConfig.Day);
//}
if (dateSeniory != null)
{
dateCheckConfig = dateSeniory.Value;
}
var profileServices = new Hre_ProfileServices();
var objProfile = new List<object>();
objProfile.AddRange(new object[17]);
objProfile[2] = orderNumber;
objProfile[15] = 1;
objProfile[16] = int.MaxValue - 1;
//objProfile.Add(orderNumber);
//objProfile.Add(null);
//objProfile.Add(null);
var lstProfile = profileServices.GetData<Hre_ProfileEntity>(objProfile, ConstantSql.hrm_hr_sp_get_ProfileAll, UserLogin, ref status).Where(s => s.DateQuit == null).ToList();
//var lstProfile = profileServices.GetData<Hre_ProfileEntity>(objProfile, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrg, ref status).ToList();
var lstProfileID = lstProfile.Select(s => s.ID).ToList();
var orgsService = new Cat_OrgStructureServices();
var objOrg = new List<object>();
objOrg.AddRange(new object[5]);
objOrg[3] = 1;
objOrg[4] = int.MaxValue - 1;
var lstallorgs = orgsService.GetData<Cat_OrgStructureEntity>(objOrg, ConstantSql.hrm_cat_sp_get_OrgStructure, UserLogin, ref status).ToList();
var courseServices = new Tra_CourseServices();
var objCourse = new List<object>();
objCourse.AddRange(new object[11]);
objCourse[9] = 1;
objCourse[10] = int.MaxValue - 1;
var lstCourse = courseServices.GetData<Tra_CourseEntity>(objCourse, ConstantSql.hrm_tra_sp_get_Course, UserLogin, ref status).ToList();
if (courseIds != null)
{
lstCourse = lstCourse.Where(s => courseIds.Contains(s.Code)).ToList();
}
var jobTitleServices = new Cat_JobTitleServices();
var objJobtitle = new List<object>();
objJobtitle.Add(null);
objJobtitle.Add(null);
objJobtitle.Add(null);
objJobtitle.Add(1);
objJobtitle.Add(int.MaxValue - 1);
var lstJobtitle = jobTitleServices.GetData<Cat_JobTitleEntity>(objJobtitle, ConstantSql.hrm_cat_sp_get_JobTitle, UserLogin, ref status).ToList();
var classServices = new Tra_ClassServices();
var objClass = new List<object>();
objClass.Add(null);
objClass.Add(null);
objClass.Add(null);
objClass.Add(null);
objClass.Add(null);
objClass.Add(null);
objClass.Add(null);
objClass.Add(null);
objClass.Add(1);
objClass.Add(int.MaxValue - 1);
var lstClass = classServices.GetData<Tra_ClassEntity>(objClass, ConstantSql.hrm_tra_sp_get_Class, UserLogin, ref status).ToList();
var salaryClassServices = new Cat_SalaryClassServices();
var objSalaryClass = new List<object>();
objSalaryClass.Add(null);
objSalaryClass.Add(1);
objSalaryClass.Add(int.MaxValue - 1);
var lstSalaryClass = salaryClassServices.GetData<Cat_SalaryClassEntity>(objSalaryClass, ConstantSql.hrm_cat_sp_get_SalaryClass, UserLogin, ref status).ToList();
if (rankIds != null)
{
lstSalaryClass = lstSalaryClass.Where(s => rankIds.Contains(s.ID)).ToList();
}
var rankServices = new Cat_SalaryRankServices();
var objRank = new List<object>();
objRank.Add(null);
objRank.Add(null);
objRank.Add(1);
objRank.Add(int.MaxValue - 1);
var lstRank = rankServices.GetData<Cat_SalaryRankEntity>(objRank, ConstantSql.hrm_cat_sp_get_SalaryRank, UserLogin, ref status).ToList();
var traineeServices = new Tra_TraineeServices();
var objTrainee = new List<object>();
objTrainee.AddRange(new object[15]);
objTrainee[13] = 1;
objTrainee[14] = int.MaxValue - 1;
var lstTrainee = rankServices.GetData<Tra_TraineeEntity>(objTrainee, ConstantSql.hrm_tra_sp_get_Trainee, UserLogin, ref status).ToList();
var workingHistoryServices = new Hre_WorkHistoryServices();
var objWorking = new List<object>();
objWorking.AddRange(new object[17]);
objWorking[15] = 1;
objWorking[16] = int.MaxValue - 1;
var lstWorking = workingHistoryServices.GetData<Hre_WorkHistoryEntity>(objWorking, ConstantSql.hrm_hr_sp_get_WorkHistory, UserLogin, ref status).ToList();
var stopWorkingServices = new Hre_StopWorkingServices();
var objStopWorking = new List<object>();
objStopWorking.AddRange(new object[17]);
objStopWorking[15] = 1;
objStopWorking[16] = int.MaxValue - 1;
var lstStopWorking = stopWorkingServices.GetData<Hre_StopWorkingEntity>(objStopWorking, ConstantSql.hrm_hr_sp_get_StopWorking, UserLogin, ref status).ToList();
var traineeCertificateServices = new Tra_TraineeCertificateServices();
var objTraineeCertificate = new List<object>();
objTraineeCertificate.Add(1);
objTraineeCertificate.Add(int.MaxValue - 1);
var lstTraineeCertificate = traineeCertificateServices.GetData<Tra_TraineeCertificateEntity>(objTraineeCertificate, ConstantSql.hrm_tra_sp_get_TraineeCertificate, UserLogin, ref status).ToList();
var lstTraineeIDFromTraineeCertificate = lstTraineeCertificate.Select(s => s.TraineeID).ToList();
var requirmentDetailServices = new Tra_RequirementTrainDetailServices();
var objRequirementDetail = new List<object>();
objRequirementDetail.Add(null);
objRequirementDetail.Add(1);
objRequirementDetail.Add(int.MaxValue - 1);
var lstRequirementDetail = requirmentDetailServices.GetData<Tra_RequirementTrainDetailEntity>(objRequirementDetail, ConstantSql.hrm_tra_sp_get_RequirementDetail, UserLogin, ref status).ToList();
//if(lstTrainee != null)
//{
// lstTrainee = lstTrainee.Where(s => lstProfileID.Contains(s.ProfileID)).ToList();
//}
if (lstTraineeCertificate != null)
{
lstTrainee = lstTrainee.Where(s => !lstTraineeIDFromTraineeCertificate.Contains(s.ID)).ToList();
}
foreach (var item in lstCourse)
{
string[] arrCourse = new string[1];
if (!string.IsNullOrEmpty(item.CourseListID))
{
arrCourse = item.CourseListID.Split(',').ToArray();
}
string[] arrJobtitle = new string[1];
int[] arrOrg = new int[1];
if (!string.IsNullOrEmpty(item.JobTitleListCode1))
{
arrJobtitle = item.JobTitleListCode1.Split(',').ToArray();
}
if (!string.IsNullOrEmpty(item.OrgListCode1))
{
arrOrg = item.OrgListCode1.Split(',').Select(s => int.Parse(s)).ToArray();
}
var lstJobtitleByJobtitleCode = lstJobtitle.Where(s => arrJobtitle.Contains(s.Code)).Select(s => s.ID).ToList();
var lstOrgByOrderNumber = lstallorgs.Where(s => arrOrg.Contains(s.OrderNumber)).Select(s => s.ID).ToList();
string[] _ranklistID = new string[1];
if (!string.IsNullOrEmpty(item.RankListID))
{
_ranklistID = item.RankListID.Split(',').ToArray();
}
// var lstClassByCourseID = lstClass.Where(s => s.CourseID == item.ID && arrCourse.Contains(s.CourseID)).ToList();
var salaryClassEntity = lstSalaryClass.Where(s => _ranklistID.Contains(s.Code)).ToList();
var lstSalaryClassID = salaryClassEntity.Select(s => s.ID).ToList();
var lstTraineePassedCourse = new List<Tra_TraineeEntity>();
// var lstTraineeForProfile = lstProfile.Where(s => s.CodeEmp == "M26423");
if (arrCourse[0] != null)
{
lstTraineePassedCourse = lstTrainee.Where(s => arrCourse.Contains(s.CourseCode) && s.Status == EnumDropDown.TraineeStatus.E_PASSED.ToString()).ToList();
int soLuongKhoaTienQUyet = arrCourse.Count();
var lstCheckTraineePassedCourse = lstTraineePassedCourse.GroupBy(m => m.ProfileID).Where(m => m.Count() >= soLuongKhoaTienQUyet).ToList();
var lstProfileIDPassedCourse = lstCheckTraineePassedCourse.Select(s => s.Key).Distinct().ToList();
lstProfile = lstProfile.Where(s => lstProfileIDPassedCourse.Contains(s.ID)).ToList();
}
foreach (var profileEntity in lstProfile)
{
var traineePassCourse = lstTrainee.Where(s => s.CourseID == item.ID && profileEntity.ID == s.ProfileID && s.Status == EnumDropDown.TraineeStatus.E_PASSED.ToString()).FirstOrDefault();
if (traineePassCourse != null)
{
continue;
}
Guid? orgId = profileEntity.OrgStructureID;
// var org = lstOrg.FirstOrDefault(s => s.ID == profileEntity.OrgStructureID);
// var orgOrg = LibraryService.GetNearestParentEntity(orgId, OrgUnit.E_DEPARTMENT, lstOrg, lstOrgType);
DataRow dr = table.NewRow();
bool flag = false;
var lstTraineeByProfileID = lstTrainee.Where(s => s.ProfileID == profileEntity.ID && arrCourse.Contains(s.CourseCode)).ToList();
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.ID] = profileEntity.ID != null ? profileEntity.ID : Guid.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.CodeEmp] = profileEntity.CodeEmp != null ? profileEntity.CodeEmp : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.TraineeName] = profileEntity.ProfileName != null ? profileEntity.ProfileName : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.IDNo] = profileEntity.IDNo != null ? profileEntity.IDNo : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.OrgStructureName] = profileEntity.OrgStructureName != null ? profileEntity.OrgStructureName : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.E_UNIT] = profileEntity.E_UNIT != null ? profileEntity.E_UNIT : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.E_DIVISION] = profileEntity.E_DIVISION != null ? profileEntity.E_DIVISION : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.E_DEPARTMENT] = profileEntity.E_DEPARTMENT != null ? profileEntity.E_DEPARTMENT : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.E_SECTION] = profileEntity.E_SECTION != null ? profileEntity.E_SECTION : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.E_TEAM] = profileEntity.E_TEAM != null ? profileEntity.E_TEAM : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.JobTitleName] = profileEntity.JobTitleName != null ? profileEntity.JobTitleName : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.PositionName] = profileEntity.PositionName != null ? profileEntity.PositionName : string.Empty;
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.CourseName] = item.CourseName != null ? item.CourseName : string.Empty;
//var profileEntity = lstProfile.Where(s => s.ID == trainee.ProfileID && s.SalaryClassID != null).FirstOrDefault();
var stopWorkingEntity = lstStopWorking.Where(s => s.ProfileID.Value == profileEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
//var workingEntity = new Hre_WorkHistoryEntity();
var lstWorkingByProfileID = lstWorking.Where(s => s.ProfileID == profileEntity.ID && lstSalaryClassID.Contains(s.SalaryClassID == null ? Guid.Empty : s.SalaryClassID.Value)).ToList();
if (lstJobtitleByJobtitleCode.Count > 0)
{
lstWorkingByProfileID = lstWorkingByProfileID.Where(s => lstJobtitleByJobtitleCode.Contains(s.JobTitleID != null ? s.JobTitleID.Value : Guid.Empty)).ToList();
}
if (lstOrgByOrderNumber.Count > 0)
{
lstWorkingByProfileID = lstWorkingByProfileID.Where(s => lstOrgByOrderNumber.Contains(s.OrganizationStructureID != null ? s.OrganizationStructureID.Value : Guid.Empty)).ToList();
}
var workingEntity = lstWorkingByProfileID.OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var dateSuspend = new TimeSpan();
var dateSeniority = new TimeSpan();
double dateResult = 0;
double monthSeniority = 0;
if (profileEntity.DateHire == null)
{
continue;
}
dateSeniority = dateCheckConfig.Subtract(profileEntity.DateHire.Value);
if (stopWorkingEntity != null && stopWorkingEntity.DateStop != null && stopWorkingEntity.DateComeBack != null)
{
dateSuspend = stopWorkingEntity.DateComeBack.Value.Subtract(stopWorkingEntity.DateStop.Value);
dateResult = dateSeniority.Subtract(dateSuspend).TotalDays / 30;
monthSeniority = Math.Floor(dateResult);
}
dateSeniority = dateCheckConfig.Subtract(profileEntity.DateHire.Value);
monthSeniority = Math.Floor(dateSeniority.TotalDays / 30);
dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.Seniority] = monthSeniority;
#region KT điều kiện seniority và maxSeniority != null
if (item.Seniority != null && item.MaxSeniority != null)
{
if (monthSeniority >= item.Seniority && item.MaxSeniority >= monthSeniority)
{
if (salaryClassEntity != null)
{
if (workingEntity != null)
{
// if (profileEntity.SalaryClassID != workingEntity.SalaryClassID)
// {
var dateCheckRank = dateCheck.Subtract(workingEntity.DateEffective).TotalDays / 30;
var monthRank = Math.Floor(dateCheckRank);
if (item.TimeOnCurrentRank != null)
{
if (monthRank < item.TimeOnCurrentRank)
{
flag = true;
// table.Rows.Add(dr);
}
}
//}
}
}
}
else
{
flag = true;
}
}
#endregion
#region KT điều kiện seniority != null && maxSeniority == null
if (item.Seniority != null && item.MaxSeniority == null)
{
if (monthSeniority >= item.Seniority)
{
if (salaryClassEntity != null)
{
if (workingEntity != null)
{
// if (profileEntity.SalaryClassID != workingEntity.SalaryClassID)
// {
var dateCheckRank = dateCheck.Subtract(workingEntity.DateEffective).TotalDays / 30;
var monthRank = Math.Floor(dateCheckRank);
if (item.TimeOnCurrentRank != null)
{
if (monthRank < item.TimeOnCurrentRank)
{
flag = true;
// table.Rows.Add(dr);
}
}
// }
}
}
}
else
{
flag = true;
}
}
#endregion
#region KT điều kiện seniority == && maxSeniority != null
if (item.MaxSeniority != null && item.Seniority == null)
{
if (monthSeniority <= item.MaxSeniority)
{
if (salaryClassEntity != null)
{
if (workingEntity != null)
{
// if (profileEntity.SalaryClassID != workingEntity.SalaryClassID)
// {
var dateCheckRank = dateCheck.Subtract(workingEntity.DateEffective).TotalDays / 30;
var monthRank = Math.Floor(dateCheckRank);
if (item.TimeOnCurrentRank != null)
{
if (item.TimeOnCurrentRank != null)
{
if (monthRank < item.TimeOnCurrentRank)
{
flag = true;
// table.Rows.Add(dr);
}
}
}
//}
}
}
}
else
{
flag = true;
}
}
#endregion
//#region kiem tra dk Seniority == null và MaxSeniority == null
//if (item.Seniority == null && item.MaxSeniority == null)
//{
// if (salaryClassEntity != null)
// {
// if (workingEntity != null)
// {
// // if (profileEntity.SalaryClassID != workingEntity.SalaryClassID)
// // {
// var dateCheckRank = dateCheck.Subtract(workingEntity.DateEffective).TotalDays / 30;
// var monthRank = Math.Floor(dateCheckRank);
// if (item.TimeOnCurrentRank != null)
// {
// if (item.TimeOnCurrentRank != null)
// {
// if (monthRank < item.TimeOnCurrentRank)
// {
// flag = true;
// // table.Rows.Add(dr);
// }
// }
// }
// //}
// }
// }
//}
//#endregion
if (lstTraineeByProfileID.Count > 0)
{
foreach (var traineeEntity in lstTraineeByProfileID)
{
// dr[Tra_ReportTraineeJoinCourseEntity.FieldNames.Note] = traineeEntity.TeacherComment != null ? traineeEntity.TeacherComment : string.Empty;
double monthCourse = Math.Floor(dateCheck.Subtract(traineeEntity.EndDate.Value).TotalDays / 30);
var traineeInRequirementDetail = lstRequirementDetail.Where(s => s.CourseID == traineeEntity.ID && traineeEntity.ID == s.ProfileID && s.YearAnalyze != null && s.YearAnalyze.Value.Year == dateCheckConfig.Year).ToList();
if (traineeInRequirementDetail.Count >= 1)
{
flag = true;
continue;
}
if (traineeEntity.EndDate == null)
{
flag = true;
continue;
}
if (item.DurationMinCourse != null)
{
if (monthCourse < item.DurationMinCourse)
{
flag = true;
continue;
}
}
}
}
else
{
var traineeInRequirementDetail = lstRequirementDetail.Where(s => s.CourseID == item.ID && profileEntity.ID == s.ProfileID && s.YearAnalyze != null && s.YearAnalyze.Value.Year == dateCheckConfig.Year).ToList();
if (traineeInRequirementDetail.Count >= 1)
{
flag = true;
continue;
}
}
if (flag == false)
{
if (salaryClassEntity != null)
{
if (workingEntity != null)
{
// if (profileEntity.SalaryClassID != workingEntity.SalaryClassID)
// {
var dateCheckRank = dateCheck.Subtract(workingEntity.DateEffective).TotalDays / 30;
var monthRank = Math.Floor(dateCheckRank);
if (item.TimeOnCurrentRank != null)
{
if (item.TimeOnCurrentRank != null)
{
if (monthRank >= item.TimeOnCurrentRank)
{
flag = true;
table.Rows.Add(dr);
}
}
}
else
{
table.Rows.Add(dr);
}
// }
}
}
}
}
}
}
return table;
}
/// <summary>
/// BC bảng lương
/// <param name="dateStartCutOffDuration">Ngày bắt đầu của kỳ lương</param>
/// <param name="monthYear">Tháng</param>
/// <param name="listOrgIDs">Ds phòng ban</param>
/// <param name="listPrGroupIDs">Ds nhóm Lương</param>
/// <param name="isIncludeQuitEmp">Bao gồm NV nghỉ việc</param>
/// </sumary>
public DataTable RefreshData(DateTime dateStartCutOffDuration, DateTime dateEndCutOffDuration, DateTime monthYear, List<Hre_ProfileEntity> listProfile, Guid? gradePayrollID, Boolean isIncludeQuitEmp, string codeEmp, string orderNumber, string Transfer, Guid[] workingPlaceID, Guid[] costcenterIds, string UserLogin)
{
try
{
using (var context = new VnrHrmDataContext())
{
#region " Load dữ liệu"
string status = string.Empty;
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
//kỳ lương (hiện tại mặc định đầu tháng -> cuối tháng)
DateTime from = new DateTime(monthYear.Year, monthYear.Month, 1);
DateTime to = new DateTime(monthYear.Year, monthYear.Month, DateTime.DaysInMonth(monthYear.Year, monthYear.Month));
//Ds tất cả phòng ban
var orgServices = new Cat_OrgStructureServices();
var lstObjOrg = new List<object>();
// var reposOrgStructure = new CustomBaseRepository<Cat_OrgStructure>(unitOfWork);
var listOrgAll = orgServices.GetDataNotParam<Cat_OrgStructure>(ConstantSql.hrm_cat_sp_get_AllOrg, UserLogin, ref status).ToList();
var lstObjOrgNumber = new List<object>();
lstObjOrgNumber.Add(orderNumber);
var lstOrgID = orgServices.GetData<Cat_OrgStructureEntity>(lstObjOrgNumber, ConstantSql.hrm_cat_sp_get_OrgStructureByOrderNumber, UserLogin, ref status).Select(s => s.ID).ToList();
//Ds cửa Hàng
var shopServices = new Cat_ShopServices();
var lstObjShop = new List<object>();
lstObjShop.Add(null);
lstObjShop.Add(null);
lstObjShop.Add(null);
lstObjShop.Add(1);
lstObjShop.Add(int.MaxValue - 1);
var lstShop = shopServices.GetData<Cat_ShopEntity>(lstObjShop, ConstantSql.hrm_cat_sp_get_Shop, UserLogin, ref status).ToList();
//Ds tất cả loại PB
var orgTypeServices = new Cat_OrgStructureTypeServices();
var lstObjOrgType = new List<object>();
lstObjOrgType.Add(string.Empty);
lstObjOrgType.Add(string.Empty);
lstObjOrgType.Add(1);
lstObjOrgType.Add(int.MaxValue - 1);
var listOrgType = orgTypeServices.GetData<Cat_OrgStructureType>(lstObjOrgType, ConstantSql.hrm_cat_sp_get_OrgStructureType, UserLogin, ref status).ToList();
//Ds nhân viên
var reposProfile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
var profileServices = new Hre_ProfileServices();
var lstObjProfile = new List<object>();
lstObjProfile.AddRange(new object[17]);
lstObjProfile[15] = 1;
lstObjProfile[16] = int.MaxValue - 1;
var lstModel = new List<object>();
lstModel.AddRange(new object[10]);
//lstModel[4] = CutOffDuration.DateStart;
//lstModel[5] = CutOffDuration.DateEnd;
lstModel[8] = 1;
lstModel[9] = Int32.MaxValue - 1;
List<Sal_HoldSalaryEntity> listHoldSalary = orgTypeServices.GetData<Sal_HoldSalaryEntity>(lstModel, ConstantSql.hrm_sal_sp_get_HoldSalary, UserLogin, ref status).Where(m => m.MonthSalary <= dateEndCutOffDuration && (m.MonthEndSalary == null || m.MonthEndSalary >= dateStartCutOffDuration)).ToList();
//bỏ những nhân viên đang bị hold lương
listProfile = listProfile.Where(m => !listHoldSalary.Any(t => t.ProfileID == m.ID)).ToList();
bool isGroup = profileServices.IsGroupByOrgProfileQuit();
//lọc theo nhóm lương
List<Guid> listProfileID = listProfile.Select(s => s.ID).Distinct().ToList();
//lọc nhân viên nghỉ việc
if (!isIncludeQuitEmp)
{
listProfile = listProfile.Where(pro => pro.DateQuit == null || pro.DateQuit > from).ToList();
}
if (workingPlaceID != null)
{
listProfile = listProfile.Where(pro => pro.WorkPlaceID != null && workingPlaceID.Contains(pro.WorkPlaceID.Value)).ToList();
}
if (costcenterIds != null)
{
listProfile = listProfile.Where(pro => pro.CostCentreID != null && costcenterIds.Contains(pro.CostCentreID.Value)).ToList();
}
//lọc theo tên nhân viên
if (!string.IsNullOrEmpty(codeEmp))
{
listProfile = listProfile.Where(s => s.CodeEmp != null && s.CodeEmp.Contains(codeEmp)).ToList();
}
//ds chế độ lương
var saleGradeServices = new Sal_GradeServices();
var lstObjSalGrade = new List<object>();
lstObjSalGrade.Add(string.Empty);
lstObjSalGrade.Add(string.Empty);
lstObjSalGrade.Add(string.Empty);
lstObjSalGrade.Add(string.Empty);
lstObjSalGrade.Add(string.Empty);
lstObjSalGrade.Add(1);
lstObjSalGrade.Add(int.MaxValue - 1);
var reposSalGrade = new CustomBaseRepository<Sal_Grade>(unitOfWork);
var lstGradeAll = reposSalGrade.FindBy(s => s.IsDelete != true).ToList();
//var lstGradeAll = GetData<Sal_GradeEntity>(lstObjSalGrade, ConstantSql.hrm_sal_sp_get_Sal_Grade, UserLogin,ref status);
//ds thông tin lương
var salInfoServices = new Sal_SalaryInformationServices();
var lstObjSalInfo = new List<object>();
lstObjSalInfo.Add(null);
lstObjSalInfo.Add(null);
lstObjSalInfo.Add(null);
lstObjSalInfo.Add(null);
lstObjSalInfo.Add(null);
lstObjSalInfo.Add(null);
lstObjSalInfo.Add(1);
lstObjSalInfo.Add(int.MaxValue - 1);
var salInfoServices1 = new Sal_SalaryInformationServices();
var lstProfileIDs = new List<Guid>();
var lstSalaryInformation = salInfoServices.GetData<Sal_SalaryInformationEntity>(lstObjSalInfo, ConstantSql.hrm_sal_sp_get_Sal_SalaryInformation, UserLogin, ref status).ToList();
if (Transfer == EnumDropDown.Transfer.E_TRANSFER.ToString())
{
lstSalaryInformation = lstSalaryInformation.Where(s => s.IsCash == true).ToList();
lstProfileIDs = lstSalaryInformation.Select(s => s.ProfileID).ToList();
}
if (Transfer == EnumDropDown.Transfer.E_CASH.ToString())
{
lstSalaryInformation = lstSalaryInformation.Where(s => s.IsCash == false).ToList();
lstProfileIDs = lstSalaryInformation.Select(s => s.ProfileID).ToList();
}
if (Transfer == EnumDropDown.Transfer.E_OTHER.ToString())
{
lstProfileIDs = lstSalaryInformation.Select(s => s.ProfileID).ToList();
}
//ds loại mã lương
var salaryClassServices = new Cat_SalaryClassServices();
var lstObjSalaryClass = new List<object>();
lstObjSalaryClass.Add(null);
lstObjSalaryClass.Add(1);
lstObjSalaryClass.Add(int.MaxValue - 1);
var lstSalaryClass = salaryClassServices.GetData<Cat_SalaryClassEntity>(lstObjSalaryClass, ConstantSql.hrm_cat_sp_get_SalaryClass, UserLogin, ref status).ToList().Translate<Cat_SalaryClass>();
var revenueProfileServices = new Sal_RevenueForProfileServices();
var lstObjRevenueForProfile = new List<object>();
lstObjRevenueForProfile.Add(null);
lstObjRevenueForProfile.Add(1);
lstObjRevenueForProfile.Add(int.MaxValue - 1);
var lstRevenueForProfile = revenueProfileServices.GetData<Sal_RevenueForProfileEntity>(lstObjRevenueForProfile, ConstantSql.hrm_sal_sp_get_RevenueForProfile, UserLogin, ref status).ToList();
//Ds phần tử lương
var elementServices = new Cat_ElementServices();
var methodPayroll = MethodPayroll.E_NORMAL.ToString();
var lstObjElement = new List<object>();
lstObjElement.AddRange(new object[8]);
lstObjElement[6] = 1;
lstObjElement[7] = int.MaxValue - 1;
var reposPayrollElement = new CustomBaseRepository<Cat_Element>(unitOfWork);
var listPayrollElement = elementServices.GetData<Cat_ElementEntity>(lstObjElement, ConstantSql.hrm_cat_sp_get_ElementByMethod, UserLogin, ref status).Where(s => s.MethodPayroll == methodPayroll).ToList().Translate<Cat_Element>();
#region Chọn lấy back up bảng lương - Tung.Ly 20150513
var salComputePayrollService = new Sal_ComputePayrollServices();
var lstSalPayrollTb = new List<Sal_PayrollTableEntity>();
var lstSalPayrollTbItem = new List<Sal_PayrollTableItemEntity>();
#region param store bang luong
var payrollTableServices = new Sal_PayrollTableServices();
var lstObjPayrollTable = new List<object>();
lstObjPayrollTable.Add(null);
lstObjPayrollTable.Add(null);
lstObjPayrollTable.Add(from);
lstObjPayrollTable.Add(to);
lstObjPayrollTable.Add(1);
lstObjPayrollTable.Add(int.MaxValue - 1);
#endregion
#region param store bảng lương chi tiết
var payrollTableItemServices = new Sal_PayrollTableItemServices();
var lstObjPayrollTableItem = new List<object>();
lstObjPayrollTableItem.Add(null);
lstObjPayrollTableItem.Add(null);
lstObjPayrollTableItem.Add(from);
lstObjPayrollTableItem.Add(to);
lstObjPayrollTableItem.Add(null);
lstObjPayrollTableItem.Add(null);
lstObjPayrollTableItem.Add(null);
lstObjPayrollTableItem.Add(1);
lstObjPayrollTableItem.Add(int.MaxValue - 1);
#endregion
//kiem ra co du lieu backup không theo kỳ lương
if (salComputePayrollService.CheckDataIsBackUp(TypeDataBKInScheduleTask.E_PAYROLL_BK.ToString(), dateStartCutOffDuration))
{
//Du liệu backup
#region ds bảng lương(backcup)
lstSalPayrollTb = payrollTableServices.GetData<Sal_PayrollTableEntity>(lstObjPayrollTable, ConstantSql.hrm_sal_sp_get_PayrollTableBK, UserLogin, ref status)
.Where(pr => pr.IsDelete == null && pr.MonthYear == monthYear && listProfileID.Contains(pr.ProfileID)).ToList();
List<Guid> listSalPayrollIDs = lstSalPayrollTb.Select(p => p.ID).ToList();
#endregion
#region ds bảng lương chi tiết(backup)
lstSalPayrollTbItem = payrollTableItemServices.GetData<Sal_PayrollTableItemEntity>(lstObjPayrollTableItem, ConstantSql.hrm_sal_sp_get_PayrollTableItemBK, UserLogin, ref status)
.Where(it => it.IsDelete == null && listSalPayrollIDs.Contains(it.PayrollTableID)).ToList();
#endregion
}
else
{
#region ds bảng lương
// var reposSalPayrollTb = new CustomBaseRepository<Sal_PayrollTable>(unitOfWork);
lstSalPayrollTb = payrollTableServices.GetData<Sal_PayrollTableEntity>(lstObjPayrollTable, ConstantSql.hrm_sal_sp_get_PayrollTable, UserLogin, ref status)
.Where(pr => pr.IsDelete == null && pr.MonthYear == monthYear && listProfileID.Contains(pr.ProfileID)).ToList();
List<Guid> listSalPayrollIDs = lstSalPayrollTb.Select(p => p.ID).ToList();
#endregion
#region ds bảng lương chi tiết
// var reposSalPayrollTbItem = new CustomBaseRepository<Sal_PayrollTableItem>(unitOfWork);
lstSalPayrollTbItem = payrollTableItemServices.GetData<Sal_PayrollTableItemEntity>(lstObjPayrollTableItem, ConstantSql.hrm_sal_sp_get_PayrollTableItem, UserLogin, ref status)
.Where(it => it.IsDelete == null && listSalPayrollIDs.Contains(it.PayrollTableID)).ToList();
#endregion
}
#endregion
// var lstSalPayrollTbItem = reposSalPayrollTbItem.GetAll().Where(it => it.IsDelete == null && listSalPayrollIDs.Contains(it.PayrollTableID)).ToList();
//Tạo cột dữ liệu cho table
DataTable tblData = GetSchemaOverallPayroll();
#endregion
#region " Không có dữ liệu Sal_PayrollTable"
if (lstSalPayrollTb == null || lstSalPayrollTb.Count <= 0)
{
foreach (Hre_ProfileEntity profile in listProfile)
{
var lstRankByProfileId = lstShop.Where(s => s.ID == profile.ShopID).FirstOrDefault();
DataRow dr = tblData.NewRow();
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.MonthYear] = monthYear;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CodeEmp] = profile.CodeEmp;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CodeAttendance] = profile.CodeAttendance;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.ProfileName] = profile.ProfileName;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.LaborType] = profile.LaborType;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.OrgStructureName] = profile.OrgStructureName;
dr["ShopGroupName"] = lstRankByProfileId != null ? lstRankByProfileId.ShopGroupName : string.Empty;
dr["OrgStructureType"] = profile.E_COMPANY_CODE + "->" + profile.E_BRANCH_CODE + "->" + profile.E_UNIT_CODE + "->" + profile.E_DIVISION_CODE + "->" + profile.E_DEPARTMENT_CODE + "->" + profile.E_TEAM_CODE + "->" + profile.E_SECTION_CODE;
//Sal_BasicSalaryEntity BasicSalaryByProfile = listBasicSalary.SingleOrDefault(m => m.ProfileID == profile.ID);
//dr["SalaryRankName"] = BasicSalaryByProfile != null ? BasicSalaryByProfile.SalaryRankName : "";
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.EmployeeType] = profile.Cat_EmployeeType != null ? profile.Cat_EmployeeType.EmployeeTypeName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.EmployeeType] = profile.EmployeeTypeName;
//dr["CostCenterCodePayrollTable"] = profile.CostCentreNamePayrollTable;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Supervisor] = profile.Supervisor != null ? profile.Supervisor : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Supervisor] = profile.Supervisor;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.HighSupervisor] = profile.HighSupervisor != null ? profile.HighSupervisor : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.HighSupervisor] = profile.HighSupervisor;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.WorkPlace] = profile.Cat_WorkPlace != null ? profile.Cat_WorkPlace.WorkPlaceName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.WorkPlace] = profile.WorkPlaceName;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.TaxCode] = profile.CodeTax != null ? profile.CodeTax : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.TaxCode] = profile.CodeTax;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.IDNo] = profile.IDNo != null ? profile.IDNo : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.IDNo] = profile.IDNo;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenter] = profile.Cat_CostCentre != null ? profile.Cat_CostCentre.CostCentreName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenter] = profile.CostCentreName;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenterCode] = profile.Cat_CostCentre != null ? profile.Cat_CostCentre.Code : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenterCode] = profile.CostCentreCode;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PositionName] = profile.Cat_Position != null ? profile.Cat_Position.PositionName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PositionName] = profile.PositionName;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.JobtitleName] = profile.Cat_JobTitle != null ? profile.Cat_JobTitle.JobTitleName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.JobtitleName] = profile.JobTitleName;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Email] = profile.Email != null ? profile.Email : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Email] = profile.Email;
if (profile.DateHire != null)
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DateHire] = profile.DateHire.Value;
if (profile.DateQuit != null)
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DateQuit] = profile.DateQuit;
if (profile.DateEndProbation != null)
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DateEndProbation] = profile.DateEndProbation.Value;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SocialInsNo] = profile.SocialInsNo != null ? profile.SocialInsNo : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SocialInsNo] = profile.SocialInsNo;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PayrollGroup] = profile.Cat_PayrollGroup != null ? profile.Cat_PayrollGroup.PayrollGroupName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PayrollGroup] = profile.PayrollGroupName;
dr["CostSource"] = profile.CostSourceName;
if (profile.SalaryClassID != null)
{
Cat_SalaryClass salClass = lstSalaryClass.Where(s => s.ID == profile.SalaryClassID.Value && s.IsDelete == null).FirstOrDefault();
if (salClass != null)
{
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SalaryClassName] = salClass.SalaryClassName;
}
}
if (profile.OrgStructureID != null)
{
var orgName = GetParentOrg(listOrgAll, listOrgType, profile.OrgStructureID);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 3)
{
orgName.Insert(0, string.Empty);
}
}
dr[Hre_ReportHCSalesEntity.FieldNames.Channel] = orgName[2];
dr[Hre_ReportHCSalesEntity.FieldNames.Region] = orgName[1];
dr[Hre_ReportHCSalesEntity.FieldNames.Area] = orgName[0];
}
// Hre_Contract hrcontract = lstHreContractAll.Where(hr => hr.ProfileID == profile.ID && hr.IsDelete == null).FirstOrDefault();
//if (hrcontract != null && hrcontract.RankRateID != null)
//{
// Cat_SalaryRank salrank = lstSalaryRankAll.Where(rk => rk.ID == hrcontract.RankRateID.Value && rk.IsDelete == null).FirstOrDefault();
// dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SalaryRankName] = salrank != null ? salrank.SalaryRankName : string.Empty;
//}
#region Insurance, Bank
var salaryInformationList = lstSalaryInformation.Where(sal => sal.ProfileID == profile.ID).ToList();
if (salaryInformationList.Count > 0)
{
Sal_SalaryInformationEntity bankSalary = salaryInformationList[0];
string accountTemp = string.Empty;
string accountNo = string.Empty;
string accountNo2 = string.Empty;
string bankNameTemp = string.Empty;
string bankCode = string.Empty;
accountTemp = bankSalary.AccountNo == null ? string.Empty : bankSalary.AccountNo;
accountNo = bankSalary.AccountNo == null ? string.Empty : bankSalary.AccountNo;
accountNo2 = bankSalary.AccountNo2 == null ? string.Empty : bankSalary.AccountNo2;
bankNameTemp = bankSalary.BankName == null ? string.Empty : bankSalary.BankName;
bankCode = bankSalary.BankCode1 == null ? string.Empty : bankSalary.BankCode1;
if (!string.IsNullOrEmpty(accountTemp))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BankAccountNo] = accountTemp.Trim();
if (!string.IsNullOrEmpty(accountNo))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.AccountNo] = accountNo.Trim();
if (!string.IsNullOrEmpty(accountNo2))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.AccountNo2] = accountNo2.Trim();
if (!string.IsNullOrEmpty(bankCode))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BankCode] = bankCode.Trim();
if (!string.IsNullOrEmpty(bankNameTemp))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BankName] = bankNameTemp.Trim();
}
#endregion
tblData.Rows.Add(dr);
}
}
#endregion
#region " Có dữ liệu tính lương Sal_PayrollTable"
else
{
foreach (Sal_PayrollTableEntity payroll in lstSalPayrollTb)
{
if (Transfer != null)
{
listProfile = listProfile.Where(s => lstProfileIDs.Contains(s.ID)).ToList();
}
Hre_ProfileEntity profile = listProfile.Where(s => s.ID == payroll.ProfileID).FirstOrDefault();
if (profile == null)
continue;
var lstRevenueByProfileId = lstRevenueForProfile.Where(s => s.ProfileID == payroll.ProfileID).FirstOrDefault();
var lstRankByProfileId = lstShop.Where(s => s.ID == profile.ShopID).FirstOrDefault();
//var unusualByProfileId = lstUnusual.Where(s => s.ProfileID == profile.ID).FirstOrDefault();
List<Sal_PayrollTableItemEntity> listItem = lstSalPayrollTbItem.Where(pi => pi.PayrollTableID == payroll.ID).ToList();
DataRow dr = tblData.NewRow();
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.ID] = payroll.ID;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.MonthYear] = monthYear;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CodeEmp] = profile.CodeEmp;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CodeAttendance] = profile.CodeAttendance;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.OrgStructureName] = profile.OrgStructureName;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.ProfileName] = profile.ProfileName;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.IsPaid] = payroll.IsPaid == null ? false : payroll.IsPaid.Value;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.LaborType] = profile.LaborType;
dr["OrgStructureType"] = profile.E_COMPANY_CODE + "->" + profile.E_BRANCH_CODE + "->" + profile.E_UNIT_CODE + "->" + profile.E_DIVISION_CODE + "->" + profile.E_DEPARTMENT_CODE + "->" + profile.E_TEAM_CODE + "->" + profile.E_SECTION_CODE;
dr["ShopGroupName"] = lstRankByProfileId != null ? lstRankByProfileId.ShopGroupName : string.Empty;
//Sal_BasicSalaryEntity BasicSalaryByProfile = listBasicSalary.SingleOrDefault(m => m.ProfileID == profile.ID);
//dr["SalaryRankName"] = BasicSalaryByProfile != null ? BasicSalaryByProfile.SalaryRankName : "";
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.EmployeeType] = profile.Cat_EmployeeType != null ? profile.Cat_EmployeeType.EmployeeTypeName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.EmployeeType] = profile.EmployeeTypeName;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Supervisor] = profile.Supervisor != null ? profile.Supervisor : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Supervisor] = profile.Supervisor;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.HighSupervisor] = profile.HighSupervisor != null ? profile.HighSupervisor : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.HighSupervisor] = profile.HighSupervisor;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.WorkPlace] = profile.Cat_WorkPlace != null ? profile.Cat_WorkPlace.WorkPlaceName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.WorkPlace] = profile.WorkPlaceName;
// dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.WorkingPlace] = profile.WorkingPlace != null ? profile.WorkingPlace : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.TaxCode] = profile.CodeTax != null ? profile.CodeTax : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.TaxCode] = profile.CodeTax;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.IDNo] = profile.IDNo;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.IDNo] = profile.IDNo != null ? profile.IDNo : string.Empty;
dr["CostCenterCodePayrollTable"] = payroll.CostCentreNamePayrollTable;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenter] = profile.Cat_CostCentre != null ? profile.Cat_CostCentre.CostCentreName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenter] = profile.CostCentreName;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenterCode] = profile.Cat_CostCentre != null ? profile.Cat_CostCentre.Code : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.CostCenterCode] = profile.CostCentreCode;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PositionName] = profile.Cat_Position != null ? profile.Cat_Position.PositionName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PositionName] = profile.PositionName;
//dr["PositionCode"] = profile.Cat_Position != null ? profile.Cat_Position.Code : string.Empty;
dr["PositionCode"] = profile.PositionCode;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.JobtitleName] = profile.Cat_JobTitle != null ? profile.Cat_JobTitle.JobTitleName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.JobtitleName] = profile.JobTitleName;
//dr["JobtitleCode"] = profile.Cat_JobTitle != null ? profile.Cat_JobTitle.Code : string.Empty;
dr["JobtitleCode"] = profile.JobTitleCode;
dr["CostSource"] = profile.CostSourceName;
//dr["Rank"] = lstRankByProfileId != null ? lstRankByProfileId.Rank : string.Empty;
//dr["Target"] = lstRevenueByProfileId != null ? lstRevenueByProfileId.Target : 0;
//dr["Actual"] = lstRevenueByProfileId != null ? lstRevenueByProfileId.Actual : 0;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.Email] = profile.Email != null ? profile.Email : string.Empty;
if (profile.DateHire != null)
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DateHire] = profile.DateHire.Value;
if (profile.DateQuit != null)
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DateQuit] = profile.DateQuit;
if (profile.DateEndProbation != null)
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DateEndProbation] = profile.DateEndProbation.Value;
//if (unusualByProfileId != null)
//{
// if (unusualByProfileId.MonthStart != null)
// {
// dr["MonthStart"] = unusualByProfileId.MonthStart;
// }
//}
//if (unusualByProfileId != null)
//{
// if (unusualByProfileId.MonthEnd != null)
// {
// dr["MonthEnd"] = unusualByProfileId.MonthEnd;
// }
//}
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SocialInsNo] = profile.SocialInsNo != null ? profile.SocialInsNo : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SocialInsNo] = profile.SocialInsNo;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PayrollGroup] = profile.Cat_PayrollGroup != null ? profile.Cat_PayrollGroup.PayrollGroupName : string.Empty;
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.PayrollGroup] = profile.PayrollGroupName;
if (profile.OrgStructureID != null)
{
var orgName = new List<string>();
var orgCode = new List<string>();
if (isGroup)
{
var orgEntity = listOrgAll.Where(s => s.ID == profile.OrgStructureID).FirstOrDefault();
if (orgEntity != null)
{
orgName = GetParentOrgNameForShiseido(listOrgAll, listOrgType, profile.OrgStructureID);
if (orgName.Count < 5)
{
orgName.Insert(0, string.Empty);
if (orgName.Count < 5)
{
orgName.Insert(0, string.Empty);
}
if (orgName.Count < 5)
{
orgName.Insert(0, string.Empty);
}
if (orgName.Count < 5)
{
orgName.Insert(0, string.Empty);
}
if (orgName.Count < 5)
{
orgName.Insert(0, string.Empty);
}
}
orgCode = GetParentOrgCodeForShiseido(listOrgAll, listOrgType, profile.OrgStructureID);
if (orgCode.Count < 5)
{
orgCode.Insert(0, string.Empty);
if (orgCode.Count < 5)
{
orgCode.Insert(0, string.Empty);
}
if (orgCode.Count < 5)
{
orgCode.Insert(0, string.Empty);
}
if (orgCode.Count < 5)
{
orgCode.Insert(0, string.Empty);
}
if (orgCode.Count < 5)
{
orgCode.Insert(0, string.Empty);
}
}
}
dr["Công Ty"] = orgName[4];
dr["Chi Nhánh"] = orgName[3];
dr[Hre_ReportHCSalesEntity.FieldNames.Channel] = orgName[2];
dr[Hre_ReportHCSalesEntity.FieldNames.Region] = orgName[1];
dr[Hre_ReportHCSalesEntity.FieldNames.Area] = orgName[0];
dr["Mã Công Ty"] = orgCode[4];
dr["Mã Chi Nhánh"] = orgCode[3];
dr["Mã Channel"] = orgCode[2];
dr["Mã Region"] = orgCode[1];
dr["Mã Area"] = orgCode[0];
}
//var orgBranch = LibraryService.GetNearestParent(profile.OrgStructureID, OrgUnit.E_BRANCH, listOrgAll, listOrgType);
//var orgOrg = LibraryService.GetNearestParent(profile.OrgStructureID, OrgUnit.E_DEPARTMENT, listOrgAll, listOrgType);
//var orgTeam = LibraryService.GetNearestParent(profile.OrgStructureID, OrgUnit.E_TEAM, listOrgAll, listOrgType);
//var orgSection = LibraryService.GetNearestParent(profile.OrgStructureID, OrgUnit.E_SECTION, listOrgAll, listOrgType);
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BranchCode] = orgBranch != null ? orgBranch.Code : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DepartmentCode] = orgOrg != null ? orgOrg.Code : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.TeamCode] = orgTeam != null ? orgTeam.Code : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SectionCode] = orgSection != null ? orgSection.Code : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
//dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
}
// Hre_Contract hrcontract = lstHreContractAll.Where(hr => hr.ProfileID == profile.ID && hr.IsDelete == null).FirstOrDefault();
if (profile.SalaryClassID != null)
{
Cat_SalaryClass salClass = lstSalaryClass.Where(s => s.ID == profile.SalaryClassID.Value && s.IsDelete == null).FirstOrDefault();
if (salClass != null)
{
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SalaryClassName] = salClass.SalaryClassName;
}
}
//if (hrcontract != null && hrcontract.RankRateID != null)
//{
// if (profile.SalaryClassID != null)
// {
// Cat_SalaryRank salrank = lstSalaryRankAll.Where(rk => rk.SalaryClassID == profile.SalaryClassID.Value && hrcontract.RankRateID == rk.ID && rk.IsDelete == null).FirstOrDefault();
// if (salrank != null)
// dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.SalaryRankName] = salrank.SalaryRankName;
// }
//}
#region Insurance, Bank
var salaryInformationList = lstSalaryInformation.Where(sal => sal.ProfileID == profile.ID).ToList();
if (salaryInformationList.Count > 0)
{
Sal_SalaryInformationEntity bankSalary = salaryInformationList[0];
string accountTemp = string.Empty;
string accountNo = string.Empty;
string accountNo2 = string.Empty;
string bankNameTemp = string.Empty;
string bankCode = string.Empty;
accountTemp = bankSalary.AccountNo == null ? string.Empty : bankSalary.AccountNo;
accountNo = bankSalary.AccountNo == null ? string.Empty : bankSalary.AccountNo;
accountNo2 = bankSalary.AccountNo2 == null ? string.Empty : bankSalary.AccountNo2;
bankNameTemp = bankSalary.BankName == null ? string.Empty : bankSalary.BankName;
bankCode = bankSalary.BankCode1 == null ? string.Empty : bankSalary.BankCode1;
if (!string.IsNullOrEmpty(accountTemp))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BankAccountNo] = accountTemp.Trim();
if (!string.IsNullOrEmpty(accountNo))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.AccountNo] = accountNo.Trim();
if (!string.IsNullOrEmpty(accountNo2))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.AccountNo2] = accountNo2.Trim();
if (!string.IsNullOrEmpty(bankCode))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BankCode] = bankCode.Trim();
if (!string.IsNullOrEmpty(bankNameTemp))
dr[Sal_ReportBasicSalaryMonthlyEntity.FieldNames.BankName] = bankNameTemp.Trim();
}
#endregion
#region sal grade
Sal_Grade grade = new Sal_Grade();
if (gradePayrollID != null)
{
grade = lstGradeAll.Where(gr => gr.IsDelete == null && gr.ProfileID == profile.ID && gradePayrollID.Value == gr.GradePayrollID
&& gr.MonthStart < to).OrderByDescending(gr => gr.MonthStart).FirstOrDefault();
}
else
{
grade = lstGradeAll.Where(gr => gr.IsDelete == null && gr.ProfileID == profile.ID
&& gr.MonthStart < to).OrderByDescending(gr => gr.MonthStart).FirstOrDefault();
}
if (grade != null)
{
Cat_GradePayroll gradepayroll = grade.Cat_GradePayroll;
if (gradepayroll != null && gradepayroll.IsFormulaSalary == true)
{
try
{
var lstSalPrItem = lstSalPayrollTbItem.Where(sal => sal.PayrollTableID == payroll.ID).ToList();
var lstelement = listPayrollElement.Where(pr => pr.GradePayrollID == gradepayroll.ID).ToList();
if (lstelement != null && lstelement.Count > 0)
{
foreach (Cat_Element payrollElement in lstelement)
{
if (payrollElement != null && !String.IsNullOrEmpty(payrollElement.ElementCode))
{
if (payrollElement.Type == "Nvarchar")
{
//Add phần tử vào cột dữ liệu nếu chưa có
if (!tblData.Columns.Contains(payrollElement.ElementCode))
{
tblData.Columns.Add(payrollElement.ElementCode);
}
}
else
{
//Add phần tử vào cột dữ liệu nếu chưa có
if (!tblData.Columns.Contains(payrollElement.ElementCode))
{
tblData.Columns.Add(payrollElement.ElementCode, typeof(Double));
}
}
//Lấy value của phần tử
if (tblData.Columns.Contains(payrollElement.ElementCode))
{
Sal_PayrollTableItemEntity item = lstSalPrItem.Where(it => it.Code == payrollElement.ElementCode).FirstOrDefault();
Double value = 0;
if (item != null)
{
if (item.ValueType == typeof(Double).Name)
{
Double.TryParse(item.Value, out value);
dr[payrollElement.ElementCode] = value;
}
if (item.ValueType == EnumDropDown.DataType.Nvarchar.ToString())
{
dr[payrollElement.ElementCode] = item.Value;
}
}
}
}
}
}
}
catch { }
}
tblData.Rows.Add(dr);
}
#endregion
}
}
#endregion
var configs = new Dictionary<string, Dictionary<string, object>>();
var config = new Dictionary<string, object>();
config.Add("hidden", true);
configs.Add("ID", config);
return tblData.ConfigTable(configs, true);
}
}
catch (Exception ex)
{
return new DataTable();
}
}
public ActionResult GetDataRankByOrderNumber(string OrderNumber)
{
string status = string.Empty;
var rankServices = new Cat_SalaryClassServices();
var objRank = new List<object>();
objRank.Add(null);
objRank.Add(1);
objRank.Add(int.MaxValue - 1);
var lstRank = rankServices.GetData<Cat_SalaryClassEntity>(objRank, ConstantSql.hrm_cat_sp_get_SalaryClass, UserLogin, ref status).ToList();
var rankDetailServices = new Cat_SalaryClassServices();
var objRankDetail = new List<object>();
objRankDetail.AddRange(new object[4]);
objRankDetail[2] = 1;
objRankDetail[3] = int.MaxValue - 1;
var lstRankDetail = rankDetailServices.GetData<Cat_SalaryRankEntity>(objRankDetail, ConstantSql.hrm_cat_sp_get_SalaryRank, UserLogin, ref status).ToList();
if (lstRank.Count > 0)
{
var entity = lstRank.Where(s => s.OrderNumber == int.Parse(OrderNumber + 1)).FirstOrDefault();
if (entity != null)
{
var lstRankDetailByRankID = lstRankDetail.Where(s => s.SalaryClassID == entity.ID).ToList();
int total = lstRankDetailByRankID.Count;
int count = lstRankDetailByRankID.Count - 1;
var orderNumber = total - count;
var rankDetailEntiy = lstRankDetail.Where(s => s.OrderNumber == orderNumber && entity.ID == s.SalaryClassID).FirstOrDefault();
return Json(rankDetailEntiy, JsonRequestBehavior.AllowGet);
}
}
return null;
}
public ActionResult GetDataRankDetailByOrderNumber(string OrderNumber, string rankCode)
{
string status = string.Empty;
var rankDetailServices = new Cat_SalaryClassServices();
var objRankDetail = new List<object>();
objRankDetail.AddRange(new object[4]);
objRankDetail[2] = 1;
objRankDetail[3] = int.MaxValue - 1;
var lstRankDetail = rankDetailServices.GetData<Cat_SalaryRankEntity>(objRankDetail, ConstantSql.hrm_cat_sp_get_SalaryRank, UserLogin, ref status).ToList();
if (lstRankDetail.Count > 0)
{
var entity = lstRankDetail.Where(s => s.Code == rankCode && s.OrderNumber == int.Parse(OrderNumber + 1)).FirstOrDefault();
return Json(entity, JsonRequestBehavior.AllowGet);
}
return null;
}
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();
}
}
public Hre_WorkHistoryModel Post([Bind]Hre_WorkHistoryModel model)
{
#region Validate
BaseService BaseService = new BaseService();
string status = string.Empty;
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_WorkHistoryModel>(model, "Hre_WorkHistory", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
var WorkHistoryServices = new Hre_WorkHistoryServices();
var SalaryClassServices = new Cat_SalaryClassServices();
var OrgStructureServices = new Cat_OrgStructureServices();
var JobTitleServices = new Cat_JobTitleServices();
var PositionServices = new Cat_PositionServices();
var WorkHistoryOld = BaseService.GetData<Hre_WorkHistoryEntity>(Common.DotNetToOracle(model.ProfileID.ToString()), ConstantSql.hrm_hr_sp_get_WorkHistoryByProfileId, UserLogin, ref status).OrderByDescending(s => s.DateEffective).FirstOrDefault();
if (WorkHistoryOld != null)
{
model.SalaryClassNameOld = WorkHistoryOld.SalaryClassName;
model.JobTitleOld = WorkHistoryOld.JobTitleName;
model.PositionOld = WorkHistoryOld.PositionName;
model.OrgStructureOldID = WorkHistoryOld.OrganizationStructureID;
model.WorkLocationOld = WorkHistoryOld.WorkLocation;
}
if (model.SalaryClassID != null)
{
var abilityTitleBySalaryClass = BaseService.GetData<Cat_AbilityTileEntity>(Common.DotNetToOracle(model.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId,UserLogin, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
model.AbilityTileID = abilityTitleBySalaryClass.ID;
}
}
// Son.Vo - 20140107 - Xử lý cập nhật ngược lại bảng profile
if (model.Status == WorkHistoryStatus.E_APPROVED.ToString() && model.DateEffective != null && model.DateEffective <= DateTime.Now.Date)
{
Hre_ProfileServices profileServices = new Hre_ProfileServices();
Hre_ProfileEntity profile = BaseService.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(model.ProfileID.ToString()), ConstantSql.hrm_hr_sp_get_ProfileById,UserLogin, ref status).FirstOrDefault();
if (profile != null)
{
profile.OrgStructureID = model.OrganizationStructureID;
profile.JobTitleID = model.JobTitleID;
profile.PositionID = model.PositionID;
profile.DateOfEffect = model.DateEffective;
profile.LaborType = model.LaborType;
profile.CostCentreID = model.CostCentreID;
profile.FormType = model.FormType;
profile.EmpTypeID = model.EmployeeTypeID;
profile.WorkingPlace = model.WorkLocation;
profile.AbilityTileID = model.AbilityTileID;
profileServices.Edit(profile);
}
}
ActionService service = new ActionService(UserLogin);
return service.UpdateOrCreate<Hre_WorkHistoryEntity, Hre_WorkHistoryModel>(model);
}
