/// <summary>
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Att_ChangeRosterGroupTableModel GetById(string id)
{
Att_ChangeRosterGroupTableModel result = new Att_ChangeRosterGroupTableModel();
string status = string.Empty;
var services = new Sys_AllSettingServices();
var configEntity = services.GetData<Sys_AllSettingEntity>(id, ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).ToList().FirstOrDefault();
return null;
}
/// <summary>
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Att_ChangeRosterGroupTableModel GetById(string id)
{
Att_ChangeRosterGroupTableModel result = new Att_ChangeRosterGroupTableModel();
List<Guid> SelectedIds = new List<Guid>();
var rosterGroupServices = new Att_RosterGroupServices();
string status = string.Empty;
var date = DateTime.Now;
var services = new Sys_AllSettingServices();
var key = AppConfig.HRM_ATT_CONFIG_NAME_ROSTERGROUP.ToString();
var configEntity = services.GetData<Sys_AllSettingEntity>(key, ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).ToList().FirstOrDefault();
if (!string.IsNullOrEmpty(id))
{
if (id.IndexOf('-') > 1)
{
SelectedIds = id.Split(',').Select(s => Guid.Parse(s)).ToList();
if (SelectedIds != null && SelectedIds.Count > 0)
{
if (id != "Create")
{
var rosterGroupEntity = services.GetData<Att_RosterGroupEntity>(Common.DotNetToOracle(id), ConstantSql.hrm_att_sp_get_RosterGroupById, UserLogin, ref status).FirstOrDefault();
if (rosterGroupEntity != null && rosterGroupEntity.DateStart != null)
{
date = rosterGroupEntity.DateStart.Value;
}
result.Table = rosterGroupServices.GetTableRosterGroupByMonth(date, ModifyType.E_EDIT);
if (configEntity != null)
{
result.lstType = configEntity.Name.Split(',').ToList();
}
return result;
}
}
}
else {
if (configEntity != null)
{
result.lstType = configEntity.Value1.Split(',').ToList();
}
result.Table = rosterGroupServices.GetTableRosterGroupByMonth(date, ModifyType.E_CREATE);
return result;
}
}
return null;
}
// GET api/<controller>/5
public Sys_AllSettingModel Get(Guid id)
{
string status = string.Empty;
var service = new Sys_AllSettingServices();
var result = service.GetById<Sys_AllSettingEntity>(id, ref status);
var Sys_AllSetting = new Sys_AllSettingModel
{
ID = result.ID,
Name = result.Name,
Value1 = result.Value1,
Value2 = result.Value2,
ModuleName = result.ModuleName
};
return Sys_AllSetting;
}
//// GET api/<controller>
///// <summary>
///// Lấy tất cả dữ liệu
///// </summary>
///// <returns></returns>
public IEnumerable<Sys_AllSettingModel> Get()
{
string status = string.Empty;
var service = new Sys_AllSettingServices();
var list = service.GetAllUseEntity<Sys_AllSettingEntity>(ref status);
return list.Select(item => new Sys_AllSettingModel
{
ID = item.ID,
Name = item.Name,
Value1 = item.Value1,
Value2 = item.Value2,
ModuleName = item.ModuleName
});
}
public Sys_AllSettingModel Put(Sys_AllSettingModel model)
{
var sysAllSetting = new Sys_AllSettingEntity
{
ID = model.ID,
Name = model.Name,
Value1 = model.Value1,
Value2 = model.Value2,
ModuleName = model.ModuleName,
UserID = model.UserID
};
var service = new Sys_AllSettingServices();
if (model.ID != Guid.Empty)
{
sysAllSetting.ID = model.ID;
service.Edit<Sys_AllSettingEntity>(sysAllSetting);
}
else
{
service.Add<Sys_AllSettingEntity>(sysAllSetting);
}
return model;
}
// DELETE api/<controller>/5
public void Delete(Guid id)
{
var service = new Sys_AllSettingServices();
var result = service.Remove<Sys_AllSettingEntity>(id);
}
public void Post(List<Dictionary<string,string>> lstModel)
{
Sys_AllSettingServices service = new Sys_AllSettingServices();
service.SaveConfig(lstModel);
}
//// GET api/<controller>
///// <summary>
///// Lấy tất cả dữ liệu
///// </summary>
///// <returns></returns>
public Sys_ConfigDBModel Get(string id)
{
var service = new Sys_AllSettingServices();
string status = string.Empty;
var listConfig = service.GetData<Sys_AllSettingEntity>(id, ConstantSql.hrm_cat_sp_get_GetAllSettings, UserLogin, ref status);
Sys_ConfigDBModel config = new Sys_ConfigDBModel();
foreach (var item in listConfig)
{
// Config Attendance
// Sever 1
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.SERVERNAME.ToString())
{
config.Att_ServerName1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.USERID.ToString())
{
config.Att_UserID1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.PASSWORD.ToString())
{
config.Att_Password1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.DBNAME.ToString())
{
config.Att_DBName1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.TABLENAME.ToString())
{
config.Att_TableName1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.CARDCOLNAME.ToString())
{
config.Att_CardColName1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.DATACOLNAME.ToString())
{
config.Att_DataColName1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.MACHINECODE.ToString())
{
config.Att_SerialNumber1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.TYPE.ToString())
{
config.Att_In_Out1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.FILTERDATA.ToString())
{
config.Att_FilterData1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.FILTERDATASPLIT.ToString())
{
config.Att_FilterDataSplit1 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.ISCODEEMP.ToString())
{
config.Att_IsCodeEmp1 = item.Value1 == bool.TrueString ? true : false;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_1_.ToString() + AppConfig.ISACTIVATED.ToString())
{
config.Att_IsActive1 = item.Value1 == bool.TrueString ? true : false;
continue;
}
// Sever 2
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.SERVERNAME.ToString())
{
config.Att_ServerName2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.USERID.ToString())
{
config.Att_UserID2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.PASSWORD.ToString())
{
config.Att_Password2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.DBNAME.ToString())
{
config.Att_DBName2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.TABLENAME.ToString())
{
config.Att_TableName2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.CARDCOLNAME.ToString())
{
config.Att_CardColName2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.DATACOLNAME.ToString())
{
config.Att_DataColName2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.MACHINECODE.ToString())
{
config.Att_SerialNumber2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.TYPE.ToString())
{
config.Att_In_Out2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.FILTERDATA.ToString())
{
config.Att_FilterData2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.FILTERDATASPLIT.ToString())
{
config.Att_FilterDataSplit2 = item.Value1;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.ISCODEEMP.ToString())
{
config.Att_IsCodeEmp2 = item.Value1 == bool.TrueString ? true : false;
continue;
}
if (item.Name == AppConfig.HRM_SYS_TAMSCANLOG_2_.ToString() + AppConfig.ISACTIVATED.ToString())
{
config.Att_IsActive2 = item.Value1 == bool.TrueString ? true : false;
continue;
}
}
return config;
}
public Sys_ConfigDBLauModel Post(Sys_ConfigDBLauModel model)
{
Dictionary<object, object> dic = new Dictionary<object, object>();
//SERVER1
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.SERVERNAME.ToString(), model.Lau_ServerName1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.USERID.ToString(), model.Lau_UserID1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.PASSWORD.ToString(), model.Lau_Password1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.DBNAME.ToString(), model.Lau_DBName1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.TABLENAME.ToString(), model.Lau_TableName1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.CARDCOLNAME.ToString(), model.Lau_CardColName1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.DATACOLNAME.ToString(), model.Lau_DataColName1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.MACHINECODE.ToString(), model.Lau_SerialNumber1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.TYPE.ToString(), model.Lau_In_Out1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.FILTERDATA.ToString(), model.Lau_FilterData1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.FILTERDATASPLIT.ToString(), model.Lau_FilterDataSplit1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.ISCODEEMP.ToString(), model.Lau_IsCodeEmp1);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_1_.ToString() + AppConfig.ISACTIVATED.ToString(), model.Lau_IsActive1.ToString());
//SERVER2
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.SERVERNAME.ToString(), model.Lau_ServerName2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.USERID.ToString(), model.Lau_UserID2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.PASSWORD.ToString(), model.Lau_Password2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.DBNAME.ToString(), model.Lau_DBName2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.TABLENAME.ToString(), model.Lau_TableName2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.CARDCOLNAME.ToString(), model.Lau_CardColName2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.DATACOLNAME.ToString(), model.Lau_DataColName2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.MACHINECODE.ToString(), model.Lau_SerialNumber2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.TYPE.ToString(), model.Lau_In_Out2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.FILTERDATA.ToString(), model.Lau_FilterData2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.FILTERDATASPLIT.ToString(), model.Lau_FilterDataSplit2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.ISCODEEMP.ToString(), model.Lau_IsCodeEmp2);
dic.Add(AppConfig.HRM_SYS_LAU_TAMSCANLOG_2_.ToString() + AppConfig.ISACTIVATED.ToString(), model.Lau_IsActive2.ToString());
var service = new Sys_AllSettingServices();
service.SaveData<Sys_AllSettingEntity>(dic, ConstantSql.hrm_cat_sp_get_UpdateAllSettingByName);
return model;
}
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 Att_RosterModel Post([Bind]Att_RosterModel model)
{
ActionService service = new ActionService(UserLogin);
var baseService = new BaseService();
string status = string.Empty;
var hrService = new Hre_ProfileServices();
string strMessages = string.Empty;
var rosterService = new Att_RosterServices();
var sysAllSetttingService = new Sys_AllSettingServices();
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Att_RosterModel>(model, "Att_Roster", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Att_RosterModel>(model, "Att_ProfileNotRoster", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
if (string.IsNullOrEmpty(model.OrgStructureIDs) && string.IsNullOrEmpty(model.ProfileIds) && model.ProfileID == Guid.Empty)
{
message = string.Format(ConstantMessages.FieldNotAllowNull.TranslateString(), ("ProfileID").TranslateString());
model.ActionStatus = message;
return model;
}
#endregion
List<Guid> lstProfileIDs = new List<Guid>();
if(!string.IsNullOrEmpty(model.OrgStructureIDs))
{
List<object> listObj = new List<object>();
listObj.Add(model.OrgStructureIDs);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
var lstProfile = hrService.GetData<Hre_ProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure,UserLogin, ref status).Select(s => s.ID).ToList();
lstProfileIDs.AddRange(lstProfile);
}
else if (model.ProfileIds != null && model.ProfileIds!="")
{
var listGuid = model.ProfileIds.Split(',').Select(s => Guid.Parse(s)).ToArray();
lstProfileIDs.AddRange(listGuid);
}
var lstRosterEntity_Validate = new List<Att_RosterEntity>();
foreach (var item in lstProfileIDs)
{
Att_RosterEntity rosterEntity = model.CopyData<Att_RosterEntity>();
rosterEntity.ProfileID = item;
if (rosterEntity.ID != null && rosterEntity.ID!= Guid.Empty)
{
}
else
{
rosterEntity.ID = Guid.NewGuid();
}
lstRosterEntity_Validate.Add(rosterEntity);
}
var key = AppConfig.HRM_ATT_ALLOWSAVEDUPLICATE.ToString();
var lstSysAllSetting = sysAllSetttingService.GetData<Sys_AllSettingEntity>(key,ConstantSql.hrm_sys_sp_get_AllSettingByKey,UserLogin, ref status).FirstOrDefault();
var ValidateLess12Hour = AppConfig.HRM_ATT_VALIDATE_ROSTER_NON_CONTINUE_12HOUR.ToString();
var lstSysSetting_ValidateLess12Hour = sysAllSetttingService.GetData<Sys_AllSettingEntity>(ValidateLess12Hour, ConstantSql.hrm_sys_sp_get_AllSettingByKey,UserLogin, ref status).FirstOrDefault();
if (lstSysSetting_ValidateLess12Hour != null && lstSysSetting_ValidateLess12Hour.Value1==bool.TrueString)
{
string Err = string.Empty;
Err = rosterService.ValidateShiftHourContinue(lstRosterEntity_Validate);
if (Err != string.Empty)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + "," + Err);
return model;
}
}
if (!string.IsNullOrEmpty(model.OrgStructureIDs))
{
List<object> listObj = new List<object>();
listObj.Add(model.OrgStructureIDs);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
var lstProfile = hrService.GetData<Hre_ProfileEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure,UserLogin, ref status).Select(s => s.ID).ToList();
if(lstProfile.Count==0 || lstProfile == null)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Info + "," + strMessages + ConstantMessages.FieldDuplicate);
return model;
}
if(lstProfile != null && model.ProfileIds != null)
{
Guid[] listGuid = null;
listGuid = model.ProfileIds.Split(',').Select(s => Guid.Parse(s)).ToArray();
lstProfile = lstProfile.Where(s => !listGuid.Contains(s)).ToList();
}
List<Att_RosterEntity> lstRosterEntity = new List<Att_RosterEntity>();
List<object> paraRoster = new List<object>();
paraRoster.AddRange(new object[4]);
paraRoster[0]=(object)model.OrgStructureIDs;
paraRoster[1]=null;
paraRoster[2]=null;
paraRoster[3]=null;
var listRosterData = rosterService.GetData<Att_RosterEntity>(paraRoster, ConstantSql.hrm_att_getdata_Roster,UserLogin, ref status);
foreach (var item in lstProfile)
{
Att_RosterModel modelSave = model.CopyData<Att_RosterModel>();
var listRoster = listRosterData.Where(s => s.ProfileID == item);
if (modelSave.Type != RosterType.E_CHANGE_SHIFT.ToString()
&& modelSave.Type != RosterType.E_TIME_OFF.ToString()
&& listRoster != null
&& listRoster.Any(d => d.DateStart <= model.DateEnd && d.DateEnd >= model.DateStart))
{
strMessages += listRoster.FirstOrDefault().ProfileName + ", ";
continue;
}
modelSave.ProfileID = item;
Att_RosterEntity rosterEntity = modelSave.CopyData<Att_RosterEntity>();
lstRosterEntity.Add(rosterEntity);
}
if (strMessages == "" && lstRosterEntity.Count > 0)
{
model.ActionStatus = rosterService.Add(lstRosterEntity);
}
else
{
if (lstSysAllSetting != null && lstSysAllSetting.Value1 == bool.TrueString && lstRosterEntity.Count > 0)
{
model.ActionStatus = rosterService.Add(lstRosterEntity);
}
else if (lstSysAllSetting.Value1 == bool.FalseString)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + "," + strMessages + ConstantMessages.FieldDuplicate);
return model;
}
else if(lstRosterEntity.Count == 0)
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Info + "," + strMessages + ConstantMessages.FieldDuplicate);
return model;
}
}
return model;
}
//Xử lý khi chọn nhiều nhân viên
if (model.ProfileIds != null && model.ProfileIds.IndexOf(',') > 0 && model.OrgStructureIDs == null)
{
Guid[] listGuid = null;
listGuid = model.ProfileIds.Split(',').Select(s => Guid.Parse(s)).ToArray();
List<Att_RosterEntity> lstRosterEntity = new List<Att_RosterEntity>();
foreach (var item in listGuid)
{
Att_RosterModel modelSave = model.CopyData<Att_RosterModel>();
var listRoster = service.GetData<Att_RosterEntity>(item, ConstantSql.hrm_att_sp_get_RosterByProfileId, ref status);
if (modelSave.Type != RosterType.E_CHANGE_SHIFT.ToString()
&& modelSave.Type != RosterType.E_TIME_OFF.ToString()
&& listRoster != null
&& listRoster.Any(d => d.DateStart <= model.DateEnd && d.DateEnd >= model.DateStart))
{
strMessages += listRoster.FirstOrDefault().ProfileName + ", ";
continue;
}
modelSave.ProfileID = item;
Att_RosterEntity rosterEntity = modelSave.CopyData<Att_RosterEntity>();
lstRosterEntity.Add(rosterEntity);
}
if(strMessages == "")
{
model.ActionStatus = rosterService.Add(lstRosterEntity);
}
else
{
if (lstSysAllSetting != null && lstSysAllSetting.Value1 == bool.TrueString)
{
model.ActionStatus = rosterService.Add(lstRosterEntity);
}
else
{
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + "," + strMessages + ConstantMessages.FieldDuplicate);
return model;
}
}
return model;
}
//Xử lý khi chỉ chọn 1 nhân viên
if(model.ID == Guid.Empty){
var lstRoster = service.GetData<Att_RosterEntity>(model.ProfileID, ConstantSql.hrm_att_sp_get_RosterByProfileId, ref status);
if (model.Type != RosterType.E_CHANGE_SHIFT.ToString()
&& model.Type != RosterType.E_TIME_OFF.ToString()
&& lstRoster != null
&& lstRoster.Any(d => d.DateStart <= model.DateEnd && d.DateEnd >= model.DateStart))
{
strMessages = lstRoster.FirstOrDefault().ProfileName + ",";
model.SetPropertyValue(Constant.ActionStatus, NotificationType.Error + "," + strMessages + ConstantMessages.FieldDuplicate);
return model;
}
return service.UpdateOrCreate<Att_RosterEntity, Att_RosterModel>(model);
}
return service.UpdateOrCreate<Att_RosterEntity, Att_RosterModel>(model);
}
public bool ComputePayrollEstimate(List<Sal_PayrollEstimateDetailEntity> listPayrollEstimateDetail, Sal_PayrollEstimateEntity model, string userLogin)
{
try
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
var repoCutOffDuration = new CustomBaseRepository<Att_CutOffDuration>(unitOfWork);
var repoPayrollEstimateDetail = new CustomBaseRepository<Sal_PayrollEstimateDetail>(unitOfWork);
var repoPayrollEstimate = new CustomBaseRepository<Sal_PayrollEstimate>(unitOfWork);
List<Att_CutOffDuration> listCutoffDuration = repoCutOffDuration.FindBy(m => m.IsDelete != true && m.MonthYear <= model.MonthEnd && m.MonthYear >= model.MonthStart).ToList();
#region Delete Sal_PayrollEstimate và Sal_PayrollEstimateDetail
List<Sal_PayrollEstimateDetail> ListPayrollEstimateDetailDelete = new List<Sal_PayrollEstimateDetail>();
List<Sal_PayrollEstimate> ListPayrollEstimateDelete = new List<Sal_PayrollEstimate>();
ListPayrollEstimateDelete = repoPayrollEstimate.FindBy(m => m.IsDelete != true && m.OrgStructureID == model.OrgStructureID).ToList();
ListPayrollEstimateDelete = ListPayrollEstimateDelete.Where(m => listCutoffDuration.Any(t => t.ID == m.CutOffDurationID)).ToList();
ListPayrollEstimateDetailDelete = repoPayrollEstimateDetail.FindBy(m => m.IsDelete != true).ToList();
ListPayrollEstimateDetailDelete = ListPayrollEstimateDetailDelete.Where(m => ListPayrollEstimateDelete.Any(t => t.ID == m.PayrollEstimateID)).ToList();
ListPayrollEstimateDelete.ForEach(m => m.IsDelete = true);
ListPayrollEstimateDetailDelete.ForEach(m => m.IsDelete = true);
unitOfWork.SaveChanges();
#endregion
//Giờ công chuẩn lấy trong web config
double TotalAmount = 0;
//lay du lieu cau hinh
string status = string.Empty;
Sys_AllSettingServices sysServices = new Sys_AllSettingServices();
var AllSetting = sysServices.GetData<Sys_AllSettingEntity>("HRM_SAL_PAYROLL_ESTIMATE_SALRYAVERAGE", ConstantSql.hrm_sys_sp_get_AllSettingByKey, userLogin, ref status).FirstOrDefault();
double StandardHour = 200;
Double.TryParse(AllSetting != null ? AllSetting.Value2 : "a", out StandardHour);
foreach (var CutOff in listCutoffDuration)
{
//reset tổng tiền master
TotalAmount = 0;
//tạo dữ liệu master
Sal_PayrollEstimate Master = new Sal_PayrollEstimate();
Master.ID = Guid.NewGuid();
Master.OrgStructureID = model.OrgStructureID;
Master.CutOffDurationID = CutOff.ID;
Master.PayrollGroupID = model.PayrollGroupID;
Master.RateAdjust = model.RateAdjust;
Master.OrgStructureType = model.OrgStructureType;
Master.BonusBudget = model.BonusBudget;
Master.StatusEmp = model.StatusEmp;
foreach (var i in listPayrollEstimateDetail)
{
#region Check null value
i.SalaryAverage = i.SalaryAverage != null ? (double)i.SalaryAverage : 0;
i.QuantityEmp = i.QuantityEmp != null ? (double)i.QuantityEmp : 0;
i.LeaveUnpaid = i.LeaveUnpaid != null ? (double)i.LeaveUnpaid : 0;
i.OvertimeNormal = i.OvertimeNormal != null ? (double)i.OvertimeNormal : 0;
i.OvertimeNightNormal = i.OvertimeNightNormal != null ? (double)i.OvertimeNightNormal : 0;
i.OvertimeWeekend = i.OvertimeWeekend != null ? (double)i.OvertimeWeekend : 0;
i.OvertimeNightWeekend = i.OvertimeNightWeekend != null ? (double)i.OvertimeNightWeekend : 0;
i.OvertimeHoliday = i.OvertimeHoliday != null ? (double)i.OvertimeHoliday : 0;
i.OvertimeNightHoliday = i.OvertimeNightHoliday != null ? (double)i.OvertimeNightHoliday : 0;
model.RateAdjust = model.RateAdjust != null ? (double)model.RateAdjust : 0;
model.BonusBudget = model.BonusBudget != null ? (double)model.BonusBudget : 0;
#endregion
#region Tính toán số liệu
double AmountHour = (double)i.SalaryAverage * (double)i.QuantityEmp;
double AmountLeaveDay = (double)i.SalaryAverage * (double)i.LeaveUnpaid != 0 ? ((double)i.LeaveUnpaid / StandardHour) : 1;
double AmountOvertime = 0;
AmountOvertime += (double)i.SalaryAverage * 1.5 * (double)i.OvertimeNormal;
AmountOvertime += (double)i.SalaryAverage * 1.95 * (double)i.OvertimeNightNormal;
AmountOvertime += (double)i.SalaryAverage * 2.0 * (double)i.OvertimeWeekend;
AmountOvertime += (double)i.SalaryAverage * 2.6 * (double)i.OvertimeNightWeekend;
AmountOvertime += (double)i.SalaryAverage * 3.0 * (double)i.OvertimeHoliday;
AmountOvertime += (double)i.SalaryAverage * 3.9 * (double)i.OvertimeNightHoliday;
double Percent = (double)model.RateAdjust != 0 ? (double)model.RateAdjust / 100 : 1;
double AmountTotal = ((AmountHour - AmountLeaveDay + AmountOvertime) * Percent) + (double)model.BonusBudget;
//cập nhật tổng tiền cho master
TotalAmount += AmountTotal;
#endregion
//tạo dữ liệu detail
Sal_PayrollEstimateDetail Detail = new Sal_PayrollEstimateDetail();
Detail.ID = Guid.NewGuid();
Detail.SalaryAverage = i.SalaryAverage;
Detail.PayrollEstimateID = Master.ID;
Detail.OrgStructureID = i.OrgStructureID;
Detail.LeaveUnpaid = i.LeaveUnpaid;
Detail.OvertimeHoliday = i.OvertimeHoliday;
Detail.OvertimeNightHoliday = i.OvertimeNightHoliday;
Detail.OvertimeNightNormal = i.OvertimeNightNormal;
Detail.OvertimeNightWeekend = i.OvertimeNightWeekend;
Detail.QuantityEmp = i.QuantityEmp;
Detail.OvertimeNormal = i.OvertimeNormal;
Detail.OvertimeWeekend = i.OvertimeWeekend;
Detail.AmountHour = AmountHour;
Detail.AmountLeaveDay = AmountLeaveDay;
Detail.AmountOvertime = AmountOvertime;
Detail.AmountTotal = AmountTotal;
repoPayrollEstimateDetail.Add(Detail);
}
//update tổng tiền
Master.AmountTotal = TotalAmount;
repoPayrollEstimate.Add(Master);
}
unitOfWork.SaveChanges();
return true;
}
}
catch
{
return false;
}
}
