/// <summary>
/// Hàm lấy các phần tử là Enum
/// </summary>
/// <param name="TotalData">Class chứa tất cả các dữ liệu lấy lên để xử lý</param>
/// <param name="listElementFormula">Lưu giá trị các thông thức đã tính rồi</param>
/// <param name="profileItem">Nhân viên hiện tại được tính</param>
/// <param name="CutOffDuration">Kỳ tính lương</param>
/// <param name="formula">Công thức tính</param>
/// <param name="listTmpDeduction">Biến tạm phục vụ cho tiền khấu trừ thâm niên của dự án SCV</param>
/// <param name="DateClose">Ngày chốt lương</param>
/// <returns></returns>
public List<ElementFormula> GetStaticValues(ComputePayrollDataModel TotalData, List<ElementFormula> listElementFormula, Hre_ProfileEntity profileItem, Att_CutOffDurationEntity CutOffDuration, string ElementCode, Dictionary<Guid, ValueCount> listTmpDeduction)
{
Cat_ElementEntity formula = TotalData.listElement_All.Where(m => m.ElementCode == ElementCode).FirstOrDefault();
ElementFormula item = new ElementFormula();
#region Thêm các phần tử là loại phụ cấp
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUsualAllowance.Select(m => m.Code).ToArray()))
{
foreach (var t in TotalData.listUsualAllowance)
{
listElementFormula.Add(new ElementFormula(t.Code, t.Formula, 0));
}
}
#endregion
#region Quy đổi tiền tệ
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listCurrency.Select(m => m.Code + "_BUYING").ToArray()))
{
//list lưu các element
var ListExChangeRateElement = TotalData.listElement_All.Where(m => m.ElementCode.EndsWith("_BUYING") && m.GradePayrollID == null).ToList();
//list lưu giá trị tiền tệ
var ListExChangeRateByGrade = TotalData.listExchangeRate.Where(m => m.MonthOfEffect >= CutOffDuration.DateStart && m.MonthOfEffect <= CutOffDuration.DateEnd).ToList();
foreach (var i in ListExChangeRateElement)
{
string[] arrCurrencyCode = i.ElementCode.Split('_').ToArray();
if (arrCurrencyCode.Count() != 3)
{
var ExChangeRateItem = ListExChangeRateByGrade.Where(m => m.CurrencyBaseCode == arrCurrencyCode[0] && m.CurrencyDestCode == arrCurrencyCode[1]).OrderByDescending(m => m.MonthOfEffect).FirstOrDefault();
if (ExChangeRateItem != null)
{
item = new ElementFormula(i.ElementCode, ExChangeRateItem.BuyingRate != null ? ExChangeRateItem.BuyingRate : 0, 0);
listElementFormula.Add(item);
}
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listCurrency.Select(m => m.Code + "_SELLING").ToArray()))
{
//list lưu các element
var ListExChangeRateElement = TotalData.listElement_All.Where(m => m.ElementCode.EndsWith("_SELLING") && m.GradePayrollID == null).ToList();
//list lưu giá trị tiền tệ
var ListExChangeRateByGrade = TotalData.listExchangeRate.Where(m => m.MonthOfEffect >= CutOffDuration.DateStart && m.MonthOfEffect <= CutOffDuration.DateEnd).ToList();
foreach (var i in ListExChangeRateElement)
{
string[] arrCurrencyCode = i.ElementCode.Split('_').ToArray();
if (arrCurrencyCode.Count() != 3)
{
var ExChangeRateItem = ListExChangeRateByGrade.Where(m => m.CurrencyBaseCode == arrCurrencyCode[0] && m.CurrencyDestCode == arrCurrencyCode[1]).OrderByDescending(m => m.MonthOfEffect).FirstOrDefault();
if (ExChangeRateItem != null)
{
item = new ElementFormula(i.ElementCode, ExChangeRateItem.SellingRate != null ? ExChangeRateItem.SellingRate : 0, 0);
listElementFormula.Add(item);
}
}
}
}
#endregion
#region Kiểm tra xem nhân viên này có phụ cấp phát sinh trong tháng đang tính lương hay không ?
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_T3").ToArray()))//đã lấy lên chưa ?
{
List<Sal_UnusualAllowanceEntity> listSal_UnusualT3 = new List<Sal_UnusualAllowanceEntity>();
listSal_UnusualT3 = TotalData.listUnusualAllowanceT3.Where(m => m.ProfileID == profileItem.ID).ToList();
ElementFormula _tmpitem = new ElementFormula();
for (int j = 0; j < TotalData.listUnusualAllowanceCfg.Count; j++)
{
//lay phu cap thang 3
_tmpitem = new ElementFormula();
_tmpitem.VariableName = TotalData.listUnusualAllowanceCfg[j].Code + "_T3";
var Sal_UnusualItem = listSal_UnusualT3.Where(m => m.UnusualEDTypeID == TotalData.listUnusualAllowanceCfg[j].ID && m.MonthStart <= CutOffDuration.DateEnd && (m.MonthEnd == null || m.MonthEnd >= CutOffDuration.DateStart)).ToList();
if (Sal_UnusualItem != null)
{
_tmpitem.Value = Sal_UnusualItem.Sum(m => m.Amount != null ? m.Amount : 0);
listElementFormula.Add(_tmpitem);
}
else
{
_tmpitem.Value = "0";
_tmpitem.ErrorMessage = "Không Có Phụ Cấp Trong Tháng 3";
listElementFormula.Add(_tmpitem);
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_DAYCLOSE_N_1").ToArray()))
{
DateTime Dateform = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateTo = CutOffDuration.DateEnd.AddMonths(-1);
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, Dateform, DateTo);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//ngày bắt đầu chốt lương
DateTime DateClose = new DateTime(CutOffDuration.MonthYear.AddMonths(-1).Year, CutOffDuration.MonthYear.AddMonths(-1).Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1).AddDays(1).AddMonths(-1);
//ngày kết thúc chốt lương
DateTime DateEndClose = new DateTime(CutOffDuration.MonthYear.AddMonths(-1).Year, CutOffDuration.MonthYear.AddMonths(-1).Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1);
List<Sal_UnusualAllowanceEntity> ListUnusualAllowanceByProfile = TotalData.listSalUnusualAllowance.Where(m => m.ProfileID == profileItem.ID && m.MonthStart != null && m.MonthStart <= DateEndClose && (m.MonthEnd == null || m.MonthEnd >= DateClose)).ToList();
ElementFormula _item = new ElementFormula();
foreach (var i in TotalData.listUnusualAllowanceCfg)
{
var listValue = ListUnusualAllowanceByProfile.Where(m => m.UnusualEDTypeID == i.ID).OrderByDescending(m => m.MonthStart).FirstOrDefault();
if (listValue != null)
{
_item = new ElementFormula(i.Code + "_DAYCLOSE_N_1", listValue.Amount != null ? listValue.Amount : 0, 0);
listElementFormula.Add(_item);
}
else
{
_item = new ElementFormula(i.Code + "_DAYCLOSE_N_1", 0, 0);
listElementFormula.Add(_item);
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_DAYCLOSE").ToArray()))
{
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//ngày bắt đầu chốt lương
DateTime DateClose = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1).AddDays(1).AddMonths(-1);
//ngày kết thúc chốt lương
DateTime DateEndClose = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1);
List<Sal_UnusualAllowanceEntity> ListUnusualAllowanceByProfile = TotalData.listSalUnusualAllowance.Where(m => m.ProfileID == profileItem.ID && m.MonthStart != null && m.MonthStart <= DateEndClose && (m.MonthEnd == null || m.MonthEnd >= DateClose)).ToList();
ElementFormula _item = new ElementFormula();
foreach (var i in TotalData.listUnusualAllowanceCfg)
{
var listValue = ListUnusualAllowanceByProfile.Where(m => m.UnusualEDTypeID == i.ID).OrderByDescending(m => m.MonthStart).FirstOrDefault();
if (listValue != null)
{
_item = new ElementFormula(i.Code + "_DAYCLOSE", listValue.Amount != null ? listValue.Amount : 0, 0);
listElementFormula.Add(_item);
}
else
{
_item = new ElementFormula(i.Code + "_DAYCLOSE", 0, 0);
listElementFormula.Add(_item);
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_AMOUNTOFOFFSET_N_1").ToArray()))
{
DateTime Dateform = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateTo = CutOffDuration.DateEnd.AddMonths(-1);
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, Dateform, DateTo);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//ngày bắt đầu chốt lương
DateTime DateClose = new DateTime(CutOffDuration.MonthYear.AddMonths(-1).Year, CutOffDuration.MonthYear.AddMonths(-1).Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1).AddDays(1).AddMonths(-1);
//ngày kết thúc chốt lương
DateTime DateEndClose = new DateTime(CutOffDuration.MonthYear.AddMonths(-1).Year, CutOffDuration.MonthYear.AddMonths(-1).Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1);
List<Sal_UnusualAllowanceEntity> listUnusualAllowanceByDateClose = TotalData.listSalUnusualAllowance.Where(m => m.MonthStart <= DateEndClose && (m.MonthEnd >= DateClose || m.MonthEnd == null) && m.ProfileID == profileItem.ID).ToList();
ElementFormula _item = new ElementFormula();
foreach (var i in TotalData.listUnusualAllowanceCfg)
{
var listValue = listUnusualAllowanceByDateClose.Where(m => m.UnusualEDTypeID == i.ID).ToList();
if (listValue != null)
{
_item = new ElementFormula(i.Code + "_AMOUNTOFOFFSET_N_1", listValue.Sum(m => m.AmountOfOffSet != null ? m.AmountOfOffSet : 0), 0);
listElementFormula.Add(_item);
}
else
{
_item = new ElementFormula(i.Code + "_AMOUNTOFOFFSET_N_1", 0, 0);
listElementFormula.Add(_item);
}
}
}
//lấy mức phụ cấp theo timeline tháng n-1
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_TIMELINE_N_1").ToArray()))
{
DateTime Dateform = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateTo = CutOffDuration.DateEnd.AddMonths(-1);
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, Dateform, DateTo);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//ngày bắt đầu chốt lương
DateTime DateClose = new DateTime(CutOffDuration.MonthYear.AddMonths(-1).Year, CutOffDuration.MonthYear.AddMonths(-1).Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1).AddDays(1).AddMonths(-1);
//ngày kết thúc chốt lương
DateTime DateEndClose = new DateTime(CutOffDuration.MonthYear.AddMonths(-1).Year, CutOffDuration.MonthYear.AddMonths(-1).Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1);
List<Cat_UnAllowCfgAmountEntity> listUnAllowCfgAmount = TotalData.listUnAllowCfgAmount.Where(m => m.FromDate <= DateEndClose && m.ToDate >= DateClose).ToList();
ElementFormula _item = new ElementFormula();
foreach (var i in TotalData.listUnusualAllowanceCfg)
{
var listValue = listUnAllowCfgAmount.Where(m => m.UnusualAllowanceID != null && (Guid)m.UnusualAllowanceID == i.ID).ToList();
if (listValue != null)
{
_item = new ElementFormula(i.Code + "_TIMELINE_N_1", listValue.Sum(m => m.Amount != null ? m.Amount : 0), 0);
listElementFormula.Add(_item);
}
else
{
_item = new ElementFormula(i.Code + "_TIMELINE_N_1", 0, 0);
listElementFormula.Add(_item);
}
}
}
//lấy mức phụ cấp theo timeline
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_TIMELINE").ToArray()))
{
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//ngày bắt đầu chốt lương
DateTime DateClose = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1).AddDays(1).AddMonths(-1);
//ngày kết thúc chốt lương
DateTime DateEndClose = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1);
List<Cat_UnAllowCfgAmountEntity> listUnAllowCfgAmount = TotalData.listUnAllowCfgAmount.Where(m => m.FromDate <= DateEndClose && m.ToDate >= DateClose).ToList();
ElementFormula _item = new ElementFormula();
foreach (var i in TotalData.listUnusualAllowanceCfg)
{
var listValue = listUnAllowCfgAmount.Where(m => m.UnusualAllowanceID != null && (Guid)m.UnusualAllowanceID == i.ID).ToList();
if (listValue != null)
{
_item = new ElementFormula(i.Code + "_TIMELINE", listValue.Sum(m => m.Amount != null ? m.Amount : 0), 0);
listElementFormula.Add(_item);
}
else
{
_item = new ElementFormula(i.Code + "_TIMELINE", 0, 0);
listElementFormula.Add(_item);
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code + "_N_1").ToArray()))//đã lấy lên chưa ?
{
List<Sal_UnusualAllowanceEntity> listSal_Unusual = new List<Sal_UnusualAllowanceEntity>();
ElementFormula _tmpitem = new ElementFormula();
listSal_Unusual = TotalData.listSalUnusualAllowance.Where(m => m.ProfileID == profileItem.ID).ToList();
//lấy các loại phụ cấp của 6 tháng trước tháng tính lương (Honda)
for (int j = 0; j < TotalData.listUnusualAllowanceCfg.Count; j++)
{
for (int t = 1; t <= 6; t++)
{
_tmpitem = new ElementFormula();
_tmpitem.VariableName = TotalData.listUnusualAllowanceCfg[j].Code + "_N_" + t.ToString();
var Sal_UnusualItem = listSal_Unusual.Where(m => m.UnusualEDTypeID == TotalData.listUnusualAllowanceCfg[j].ID && m.MonthStart <= CutOffDuration.DateEnd.AddMonths(t * -1) && (m.MonthEnd == null || m.MonthEnd >= CutOffDuration.DateStart.AddMonths(t * -1))).ToList();
if (Sal_UnusualItem != null)
{
_tmpitem.Value = Sal_UnusualItem.Sum(m => m.Amount != null ? m.Amount : 0);
listElementFormula.Add(_tmpitem);
}
else
{
_tmpitem.Value = "0";
_tmpitem.ErrorMessage = "Không Có Phụ Cấp Trong Tháng";
listElementFormula.Add(_tmpitem);
}
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, TotalData.listUnusualAllowanceCfg.Select(m => m.Code).ToArray()))//đã lấy lên chưa ?
{
List<Sal_UnusualAllowanceEntity> listSal_Unusual = new List<Sal_UnusualAllowanceEntity>();
// List<Sal_UnusualAllowanceEntity> listSal_UnusualT3 = new List<Sal_UnusualAllowanceEntity>();
listSal_Unusual = TotalData.listSalUnusualAllowance.Where(m => m.ProfileID == profileItem.ID).ToList();
// listSal_UnusualT3 = TotalData.listUnusualAllowanceT3.Where(m => m.ProfileID == profileItem.ID).ToList();
//add loại phụ cấp bất thường vào list phần tử(listElement), các loại phụ cấp nào không có thì cho formula = 0
for (int j = 0; j < TotalData.listUnusualAllowanceCfg.Count; j++)
{
ElementFormula _tmpitem = new ElementFormula();
_tmpitem.VariableName = TotalData.listUnusualAllowanceCfg[j].Code;
var Sal_UnusualItem = listSal_Unusual.Where(m => m.UnusualEDTypeID == TotalData.listUnusualAllowanceCfg[j].ID && m.MonthStart <= CutOffDuration.DateEnd && (m.MonthEnd == null || m.MonthEnd >= CutOffDuration.DateStart)).ToList();
if (Sal_UnusualItem != null)
{
_tmpitem.Value = Sal_UnusualItem.Sum(m => m.Amount != null ? m.Amount : 0);
listElementFormula.Add(_tmpitem);
}
else
{
_tmpitem.Value = "0";
_tmpitem.ErrorMessage = "Không Có Phụ Cấp Trong Tháng";
listElementFormula.Add(_tmpitem);
}
}
}
#endregion
#region Lấy giá trị các phần tử là Enum
var listAttendanceTableProCut = TotalData.listAttendanceTable.Where(m => m.ProfileID == profileItem.ID && m.DateStart <= CutOffDuration.DateEnd && m.DateEnd >= CutOffDuration.DateStart).FirstOrDefault();
#region Enum HRE
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.HR_WORKINGDAY.ToString(), PayrollElement.HR_LEAVEDAY.ToString(), PayrollElement.HR_IS_LEAVEDAY.ToString(), PayrollElement.HR_IS_WORKINGDAY.ToString() }))
{
//Ngày vào làm
item = new ElementFormula(PayrollElement.HR_WORKINGDAY.ToString(), profileItem.DateHire, 0);
listElementFormula.Add(item);
//Ngày nghỉ việc
item = new ElementFormula(PayrollElement.HR_LEAVEDAY.ToString(), profileItem.DateQuit != null ? profileItem.DateQuit : DateTime.MinValue, 0, profileItem.DateQuit != null ? "" : "Null");
listElementFormula.Add(item);
//NV có ngày nghỉ việc trong tháng
item = new ElementFormula(PayrollElement.HR_IS_LEAVEDAY.ToString(), (profileItem.DateQuit <= CutOffDuration.DateEnd && profileItem.DateQuit >= CutOffDuration.DateStart) == true ? 0 : 1, 0);
listElementFormula.Add(item);
//NV có ngày vào làm trong tháng
item = new ElementFormula(PayrollElement.HR_IS_WORKINGDAY.ToString(), (profileItem.DateHire <= CutOffDuration.DateEnd && profileItem.DateHire >= CutOffDuration.DateStart) == true ? 1 : 0, 0);
listElementFormula.Add(item);
}
////Bậc / Hệ số lương (Code)
//item = new ElementFormula(PayrollElement.HR_SALARYCLASSNAME.ToString(), profileItem.SalaryClassID != null ? profileItem.SalaryClassName : "", 0);
//listElementFormula.Add(item);
//Số ngày từ ngày vào đến cuối tháng, không tính những ngày dayoff từ ngày vào đến cuối tháng (VD: vào ngày 05/01, số ngày dayoff từ mùng 5 đến 31 = 6 => trả về: 31 (số ngày trong tháng) - 5 (ngày vào) + 1 (từ 5 đến 31 là 27 ngày nên phải + thêm 1) - 6 (số ngày dayoff từ ngày 05/01 đến 31/01) = 21)
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_COUNT_DAY_TO_DATEEND_CUTOFF.ToString()))
{
if (profileItem.DateHire != null && profileItem.DateHire >= new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, 1))
{
DateTime DateStart = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, 1);
DateTime DateEnd = DateStart.AddMonths(1).AddDays(-1);
//số ngày trong tháng
double dayInCutoff = DateEnd.Subtract(profileItem.DateHire.Value).TotalDays + 1;
double dayOff = TotalData.listDayOff.Where(m => m.DateOff <= DateEnd && m.DateOff >= profileItem.DateHire.Value).Count();
item = new ElementFormula(PayrollElement.HR_COUNT_DAY_TO_DATEEND_CUTOFF.ToString(), dayInCutoff - dayOff, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.HR_COUNT_DAY_TO_DATEEND_CUTOFF.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
//Số ngày trong tháng tính lương - tổng số ngày dayoff trong tháng tính lương (VD: tháng 1 có 31 ngày - 8 ngày dayoff = 23)
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_COUNT_DAY_IN_CUTOFF.ToString()))
{
DateTime DateStart = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, 1);
DateTime DateEnd = DateStart.AddMonths(1).AddDays(-1);
double dayInCutoff = DateEnd.Subtract(DateStart).TotalDays + 1;
double dayOff = TotalData.listDayOff.Where(m => m.DateOff <= DateEnd && m.DateOff >= DateStart).Count();
item = new ElementFormula(PayrollElement.HR_COUNT_DAY_IN_CUTOFF.ToString(), dayInCutoff - dayOff, 0);
listElementFormula.Add(item);
}
//Số ngày dayoff từ ngày 1 tháng tính lương đến ngày vào làm (VD: vào làm ngày 05/01, 01/01, 02/01 là ngày dayoff => trả về 2)
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_COUNT_DAYOFF_TO_DATEHIRE.ToString()))
{
//ngày đầu tháng tính lương
DateTime DateStart = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, 1);
//nếu ngày làm việc lớn hơn ngày đầu tháng
if (profileItem.DateHire != null && profileItem.DateHire >= DateStart)
{
int DayNumber = TotalData.listDayOff.Where(m => m.DateOff <= profileItem.DateHire.Value && m.DateOff >= DateStart).Count();
item = new ElementFormula(PayrollElement.HR_COUNT_DAYOFF_TO_DATEHIRE.ToString(), DayNumber, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.HR_COUNT_DAYOFF_TO_DATEHIRE.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
//Nhân viên có ngày vào làm hoặc ngày đi làm lại trong khoảng từ ngày 1 đến ngày chốt lương trong tháng tính lương thì trả về 1, nếu không trả về 0
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_IS_BACK_TO_WORK.ToString()))
{
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//kiểm tra ngày đi làm
if (profileItem.DateHire != null && profileItem.DateHire.Value.Month == CutOffDuration.MonthYear.Month && profileItem.DateHire.Value.Year == CutOffDuration.MonthYear.Year)
{
if (CatGrade.SalaryDayClose != null && profileItem.DateHire.Value.Day <= CatGrade.SalaryDayClose)
{
item = new ElementFormula(PayrollElement.HR_IS_BACK_TO_WORK.ToString(), 1, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.HR_IS_BACK_TO_WORK.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
else//kiểm tra có ngày vào làm lại hay không
{
if (CatGrade.SalaryDayClose != null)
{
List<Hre_WorkHistoryEntity> listWorkHistoryByProfile = TotalData.listWorkHistory.Where(m => m.ProfileID == profileItem.ID && m.DateComeBack != null && m.DateComeBack <= new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, (int)CatGrade.SalaryDayClose)).ToList();
if (listWorkHistoryByProfile.Count > 0)
{
item = new ElementFormula(PayrollElement.HR_IS_BACK_TO_WORK.ToString(), 1, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.HR_IS_BACK_TO_WORK.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
else
{
item = new ElementFormula(PayrollElement.HR_IS_BACK_TO_WORK.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
}
//Nhân viên có trong doanh sách kỷ luật trong tháng tính lương
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_NUMBER_DAY_BEFORE_WORK.ToString()))
{
double CountDay = 0;
//nếu ngày vào làm lớn hơn
if (profileItem.DateHire != null && profileItem.DateHire > CutOffDuration.DateStart && profileItem.DateHire <= CutOffDuration.DateEnd)
{
DateTime dateStart = new DateTime(profileItem.DateHire.Value.Year, profileItem.DateHire.Value.Month, 1);
CountDay = profileItem.DateHire.Value.Subtract(dateStart).TotalDays;
int DayOff = TotalData.listDayOff.Where(m => ((m.OrgStructureID == null || m.OrgStructureID == profileItem.OrgStructureID) || m.OrgStructureID == profileItem.OrgStructureID) && m.DateOff >= dateStart && m.DateOff < profileItem.DateHire).Count();
CountDay -= DayOff;
}
//kiểm tra xem có vào làm lại hay không
Hre_StopWorkingEntity StopWorkingByProfile = TotalData.listHre_StopWorking.Where(m => m.ProfileID != null && m.DateComeBack != null && m.ProfileID == profileItem.ID && m.DateComeBack >= CutOffDuration.DateStart && m.DateComeBack <= CutOffDuration.DateEnd).OrderByDescending(m => m.DateComeBack).FirstOrDefault();
if (StopWorkingByProfile != null && StopWorkingByProfile.DateComeBack != null)
{
DateTime dateStart = new DateTime(StopWorkingByProfile.DateComeBack.Value.Year, StopWorkingByProfile.DateComeBack.Value.Month, 1);
CountDay = StopWorkingByProfile.DateComeBack.Value.Subtract(dateStart).TotalDays;
int DayOff = TotalData.listDayOff.Where(m => (m.OrgStructureID == null || m.OrgStructureID == profileItem.OrgStructureID) && m.DateOff >= dateStart && m.DateOff < profileItem.DateHire).Count();
CountDay -= DayOff;
}
item = new ElementFormula(PayrollElement.HR_NUMBER_DAY_BEFORE_WORK.ToString(), CountDay, 0);
listElementFormula.Add(item);
}
//Nhân viên có trong doanh sách kỷ luật trong tháng tính lương
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_NUMBER_DAY_BEFORE_WORK_PREV.ToString()))
{
DateTime DateStartPrev = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndPrev = CutOffDuration.DateEnd.AddMonths(-1);
double CountDay = 0;
int DayClose = 1;
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd);
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
if (CatGrade != null && CatGrade.SalaryDayClose != null)
{
DayClose = (int)CatGrade.SalaryDayClose;
}
//nếu ngày vào làm lớn hơn
if (profileItem.DateHire != null && profileItem.DateHire > DateStartPrev && profileItem.DateHire <= DateEndPrev && profileItem.DateHire.Value.Day > DayClose)
{
CountDay = new DateTime(profileItem.DateHire.Value.Year, profileItem.DateHire.Value.Month, 1).AddMonths(1).AddDays(-1).Subtract(profileItem.DateHire.Value).TotalDays + 1;
DateStartPrev = new DateTime(profileItem.DateHire.Value.Year, profileItem.DateHire.Value.Month, 1).AddMonths(1).AddDays(-1);
int DayOff = TotalData.listDayOff.Where(m => (m.OrgStructureID == null || m.OrgStructureID == profileItem.OrgStructureID) && m.DateOff <= DateStartPrev && m.DateOff >= profileItem.DateHire).Count();
CountDay -= DayOff;
}
//kiểm tra xem có vào làm lại hay không
Hre_StopWorkingEntity StopWorkingByProfile = TotalData.listHre_StopWorking.Where(m => m.ProfileID != null && m.DateComeBack != null && m.ProfileID == profileItem.ID && m.DateComeBack >= DateStartPrev && m.DateComeBack <= DateEndPrev).OrderByDescending(m => m.DateComeBack).FirstOrDefault();
if (StopWorkingByProfile != null && StopWorkingByProfile.DateComeBack != null)
{
CountDay = new DateTime(StopWorkingByProfile.DateComeBack.Value.Year, StopWorkingByProfile.DateComeBack.Value.Month, 1).AddMonths(1).AddDays(-1).Subtract(StopWorkingByProfile.DateComeBack.Value).TotalDays + 1;
DateStartPrev = new DateTime(profileItem.DateHire.Value.Year, profileItem.DateHire.Value.Month, 1).AddMonths(1).AddDays(-1);
int DayOff = TotalData.listDayOff.Where(m => (m.OrgStructureID == null || m.OrgStructureID == profileItem.OrgStructureID) && m.DateOff <= DateStartPrev && m.DateOff >= profileItem.DateHire).Count();
CountDay -= DayOff;
}
item = new ElementFormula(PayrollElement.HR_NUMBER_DAY_BEFORE_WORK_PREV.ToString(), CountDay, 0);
listElementFormula.Add(item);
}
//Nhân viên có trong doanh sách kỷ luật trong tháng tính lương
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_IS_DISCIPLINE.ToString()))//đã lấy lên chưa ?
{
DateTime datefrom = new DateTime(CutOffDuration.MonthYear.Year - 1, 4, 1);
DateTime dateto = new DateTime(CutOffDuration.MonthYear.Year, 3, 31);
var listDisciplineProfile = TotalData.listDiscipline.Where(m => m.ProfileID == profileItem.ID && m.DateOfEffective >= datefrom && m.DateOfEffective <= dateto).FirstOrDefault();
item = new ElementFormula(PayrollElement.HR_IS_DISCIPLINE.ToString(), listDisciplineProfile != null ? 1 : 0, 0);
listElementFormula.Add(item);
}
//Phần tử tổng thời gian tạm hoãn công việc tính tới cuối kỳ lương
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_TOTAL_DAY_STOP_WORKING.ToString()))//đã lấy lên chưa ?
{
item = new ElementFormula(PayrollElement.HR_TOTAL_DAY_STOP_WORKING.ToString(), SumStopWorkingDay(TotalData.listHre_StopWorking.Where(m => m.ProfileID == profileItem.ID).ToList(), CutOffDuration.DateEnd), 0);
listElementFormula.Add(item);
}
//Nhân viên có được tính trợ cấp hay không (Có ngày vào làm từ 1996<=N<=31/12/2008)
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_IS_COMPUTE_SUBSIDIZE.ToString()))
{
DateTime from = new DateTime(1996, 1, 1);
DateTime to = new DateTime(2008, 12, 31);
item = new ElementFormula(PayrollElement.HR_IS_COMPUTE_SUBSIDIZE.ToString(), (profileItem.DateHire <= to && profileItem.DateHire >= from) == true ? 1 : 0, 0);
listElementFormula.Add(item);
}
//Lấy thông tin hợp đồng
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_CONSTRACT_TYPE.ToString()))
{
//TotalData.
}
#region HDT JOB
#region Ngày vào làm và ngày kết thúc HDT JOB tháng N
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_START_DATE_HDTJOB.ToString()) || CheckIsExistFormula(listElementFormula, formula, PayrollElement.HR_END_DATE_HDTJOB.ToString()))//đã lấy lên chưa ?
{
Hre_HDTJobEntity HDTJOB_DateFrom = new Hre_HDTJobEntity();
//Ngày vào làm HDT JOB
HDTJOB_DateFrom = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.DateFrom <= CutOffDuration.DateEnd && (m.DateTo >= CutOffDuration.DateStart || m.DateTo == null) && m.Status == HDTJobStatus.E_APPROVE.ToString()).OrderBy(m => m.DateFrom).FirstOrDefault();
if (HDTJOB_DateFrom != null)
{
DateTime form = HDTJOB_DateFrom.DateFrom != null ? (DateTime)HDTJOB_DateFrom.DateFrom : DateTime.MinValue;
DateTime to = HDTJOB_DateFrom.DateTo != null ? (DateTime)HDTJOB_DateFrom.DateTo : CutOffDuration.DateEnd;
item = new ElementFormula(PayrollElement.HR_START_DATE_HDTJOB.ToString(), form, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.HR_END_DATE_HDTJOB.ToString(), to, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.HR_START_DATE_HDTJOB.ToString(), DateTime.MinValue, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.HR_END_DATE_HDTJOB.ToString(), DateTime.MinValue, 0, "Null");
listElementFormula.Add(item);
}
}
#endregion
#region Ngày vào làm và ngày kết thúc HDT JOB tháng N-1
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.HR_END_DATE_HDTJOB_PREV.ToString(), PayrollElement.HR_START_DATE_HDTJOB_PREV.ToString() }))
{
var CutOffDuration_Prev = TotalData.listCutOffDuration.Where(m => m.MonthYear == CutOffDuration.MonthYear.AddMonths(-1)).OrderByDescending(m => m.MonthYear).FirstOrDefault();
if (CutOffDuration_Prev != null)
{
List<Hre_HDTJobEntity> listHre_HDTJob_Prev = new List<Hre_HDTJobEntity>();
Hre_HDTJobEntity HDTJOB_DateFrom = new Hre_HDTJobEntity();
//Ngày vào làm HDT JOB
HDTJOB_DateFrom = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.DateFrom <= CutOffDuration_Prev.DateEnd && (m.DateTo >= CutOffDuration_Prev.DateStart || m.DateTo == null) && m.Status == HDTJobStatus.E_APPROVE.ToString()).OrderBy(m => m.DateFrom).FirstOrDefault();
if (HDTJOB_DateFrom != null)
{
DateTime form = HDTJOB_DateFrom.DateFrom != null ? (DateTime)HDTJOB_DateFrom.DateFrom : DateTime.MinValue;
DateTime to = HDTJOB_DateFrom.DateTo != null ? (DateTime)HDTJOB_DateFrom.DateTo : CutOffDuration.DateEnd;
item = new ElementFormula(PayrollElement.HR_START_DATE_HDTJOB_PREV.ToString(), form, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.HR_END_DATE_HDTJOB_PREV.ToString(), to, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.HR_START_DATE_HDTJOB_PREV.ToString(), DateTime.MinValue, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.HR_END_DATE_HDTJOB_PREV.ToString(), DateTime.MinValue, 0, "Null");
listElementFormula.Add(item);
}
}
else
{
item = new ElementFormula(PayrollElement.HR_START_DATE_HDTJOB_PREV.ToString(), DateTime.MinValue, 0, "Không tồn tại kỳ N-1");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.HR_END_DATE_HDTJOB_PREV.ToString(), DateTime.MinValue, 0, "Không tồn tại kỳ N-1");
listElementFormula.Add(item);
}
}
#endregion
#region Tính số ngày công đi làm HDT JOB Tháng N
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.ATT_WORKDAY_HDTJOB_4.ToString()) || CheckIsExistFormula(listElementFormula, formula, PayrollElement.ATT_WORKDAY_HDTJOB_5.ToString()))//đã lấy lên chưa ?
{
double HDTJobDay = 0;
if (listAttendanceTableProCut != null)
{
if (listAttendanceTableProCut.HDTJobType1 != null && listAttendanceTableProCut.HDTJobType1 == EnumDropDown.HDTJobType.E_TYPE4.ToString())
{
HDTJobDay += listAttendanceTableProCut.HDTJobDayCount1 != null ? (int)listAttendanceTableProCut.HDTJobDayCount1 : 0;
}
if (listAttendanceTableProCut.HDTJobType2 != null && listAttendanceTableProCut.HDTJobType2 == EnumDropDown.HDTJobType.E_TYPE4.ToString())
{
HDTJobDay += listAttendanceTableProCut.HDTJobDayCount2 != null ? (int)listAttendanceTableProCut.HDTJobDayCount2 : 0;
}
if (listAttendanceTableProCut.HDTJobType3 != null && listAttendanceTableProCut.HDTJobType3 == EnumDropDown.HDTJobType.E_TYPE4.ToString())
{
HDTJobDay += listAttendanceTableProCut.HDTJobDayCount3 != null ? (int)listAttendanceTableProCut.HDTJobDayCount3 : 0;
}
}
//Số ngày công làm HDT Job Loại 4 (tháng N)
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDTJOB_4.ToString(), HDTJobDay, 0);
listElementFormula.Add(item);
HDTJobDay = 0;
if (listAttendanceTableProCut != null)
{
if (listAttendanceTableProCut.HDTJobType1 != null && listAttendanceTableProCut.HDTJobType1 == EnumDropDown.HDTJobType.E_TYPE5.ToString())
{
HDTJobDay += listAttendanceTableProCut.HDTJobDayCount1 != null ? (int)listAttendanceTableProCut.HDTJobDayCount1 : 0;
}
if (listAttendanceTableProCut.HDTJobType2 != null && listAttendanceTableProCut.HDTJobType2 == EnumDropDown.HDTJobType.E_TYPE5.ToString())
{
HDTJobDay += listAttendanceTableProCut.HDTJobDayCount2 != null ? (int)listAttendanceTableProCut.HDTJobDayCount2 : 0;
}
if (listAttendanceTableProCut.HDTJobType3 != null && listAttendanceTableProCut.HDTJobType3 == EnumDropDown.HDTJobType.E_TYPE5.ToString())
{
HDTJobDay += listAttendanceTableProCut.HDTJobDayCount3 != null ? (int)listAttendanceTableProCut.HDTJobDayCount3 : 0;
}
}
//Số ngày công làm HDT Job Loại 5 (tháng N)
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDTJOB_5.ToString(), HDTJobDay, 0);
listElementFormula.Add(item);
}
#endregion
#region Tính số ngày công đi làm HDT JOB Tháng N-1
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKDAY_HDTJOB_PREV_4.ToString(), PayrollElement.ATT_WORKDAY_HDTJOB_PREV_5.ToString() }))
{
//lấy dữ liệu công tháng N-1
var listAttendanceTableProCut_Prev = TotalData.Att_AttendanceTable_Prev.Where(m => m.ProfileID == profileItem.ID).FirstOrDefault();
double HDTJobDay = 0;
if (listAttendanceTableProCut_Prev != null && listAttendanceTableProCut_Prev.HDTJobType1 != null && listAttendanceTableProCut_Prev.HDTJobType1 == EnumDropDown.HDTJobType.E_TYPE4.ToString())
{
HDTJobDay += listAttendanceTableProCut_Prev.HDTJobDayCount1 != null ? (int)listAttendanceTableProCut_Prev.HDTJobDayCount1 : 0;
}
if (listAttendanceTableProCut_Prev != null && listAttendanceTableProCut_Prev.HDTJobType2 != null && listAttendanceTableProCut_Prev.HDTJobType2 == EnumDropDown.HDTJobType.E_TYPE4.ToString())
{
HDTJobDay += listAttendanceTableProCut_Prev.HDTJobDayCount2 != null ? (int)listAttendanceTableProCut_Prev.HDTJobDayCount2 : 0;
}
if (listAttendanceTableProCut_Prev != null && listAttendanceTableProCut_Prev.HDTJobType3 != null && listAttendanceTableProCut_Prev.HDTJobType3 == EnumDropDown.HDTJobType.E_TYPE4.ToString())
{
HDTJobDay += listAttendanceTableProCut_Prev.HDTJobDayCount3 != null ? (int)listAttendanceTableProCut_Prev.HDTJobDayCount3 : 0;
}
//Số ngày công làm HDT Job Loại 4 (tháng N)
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDTJOB_PREV_4.ToString(), HDTJobDay, 0);
listElementFormula.Add(item);
HDTJobDay = 0;
if (listAttendanceTableProCut_Prev != null && listAttendanceTableProCut_Prev.HDTJobType1 != null && listAttendanceTableProCut_Prev.HDTJobType1 == EnumDropDown.HDTJobType.E_TYPE5.ToString())
{
HDTJobDay += listAttendanceTableProCut_Prev.HDTJobDayCount1 != null ? (int)listAttendanceTableProCut_Prev.HDTJobDayCount1 : 0;
}
if (listAttendanceTableProCut_Prev != null && listAttendanceTableProCut_Prev.HDTJobType2 != null && listAttendanceTableProCut_Prev.HDTJobType2 == EnumDropDown.HDTJobType.E_TYPE5.ToString())
{
HDTJobDay += listAttendanceTableProCut_Prev.HDTJobDayCount2 != null ? (int)listAttendanceTableProCut_Prev.HDTJobDayCount2 : 0;
}
if (listAttendanceTableProCut_Prev != null && listAttendanceTableProCut_Prev.HDTJobType3 != null && listAttendanceTableProCut_Prev.HDTJobType3 == EnumDropDown.HDTJobType.E_TYPE5.ToString())
{
HDTJobDay += listAttendanceTableProCut_Prev.HDTJobDayCount3 != null ? (int)listAttendanceTableProCut_Prev.HDTJobDayCount3 : 0;
}
//Số ngày công làm HDT Job Loại 5 (tháng N)
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDTJOB_PREV_5.ToString(), HDTJobDay, 0);
listElementFormula.Add(item);
}
#endregion
#region Phần tử kiểm tra có ngày ra HDT hay không tháng N và tháng N-1
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_HDT_IS_DATE_END.ToString(), PayrollElement.ATT_HDT_IS_DATE_END_N_1.ToString() }))
{
#region Tháng N
List<Hre_HDTJobEntity> HDTJOBByProfile = new List<Hre_HDTJobEntity>();
HDTJOBByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.DateFrom <= CutOffDuration.DateEnd && (m.DateTo >= CutOffDuration.DateStart || m.DateTo == null) && m.Status == HDTJobStatus.E_APPROVE.ToString()).ToList();
if (HDTJOBByProfile.Any(m => m.DateTo == null))
{
item = new ElementFormula(PayrollElement.ATT_HDT_IS_DATE_END.ToString(), 1, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_HDT_IS_DATE_END.ToString(), 0, 0);
listElementFormula.Add(item);
}
#endregion
#region Tháng N-1
DateTime DateStartN1 = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndN1 = CutOffDuration.DateEnd.AddMonths(-1);
HDTJOBByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.DateFrom <= DateEndN1 && (m.DateTo >= DateStartN1 || m.DateTo == null) && m.Status == HDTJobStatus.E_APPROVE.ToString()).ToList();
if (HDTJOBByProfile.Any(m => m.DateTo == null))
{
item = new ElementFormula(PayrollElement.ATT_HDT_IS_DATE_END.ToString(), 1, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_HDT_IS_DATE_END.ToString(), 0, 0);
listElementFormula.Add(item);
}
#endregion
}
#endregion
#region Số ngày làm HDT loại 4 và 5 trừ ngày DayOff (tháng N và tháng N-1)
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_4.ToString(), PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_5.ToString(), PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_4_N_1.ToString(), PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_5_N_1.ToString() }))
{
DateTime DateStartN1 = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndN1 = CutOffDuration.DateEnd.AddMonths(-1);
List<Hre_HDTJobEntity> ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString()).ToList();
List<Hre_HDTJobEntity> ListHDTByProfileN = ListHDTByProfile.Where(m => m.DateFrom <= CutOffDuration.DateEnd && (m.DateTo >= CutOffDuration.DateStart || m.DateTo == null)).ToList();
List<Hre_HDTJobEntity> ListHDTByProfileN1 = ListHDTByProfile.Where(m => m.DateFrom <= DateEndN1 && (m.DateTo >= DateStartN1 || m.DateTo == null)).ToList();
double ListDayOff = TotalData.listDayOff.Count(m => m.DateOff <= CutOffDuration.DateEnd && m.DateOff >= CutOffDuration.DateStart);
double ListDayOffN1 = TotalData.listDayOff.Count(m => m.DateOff <= DateEndN1 && m.DateOff >= DateStartN1);
#region tính số ngày làm HDT loại 4
List<Hre_HDTJobEntity> ListHDTByProfileN_Type4 = ListHDTByProfileN.Where(m => m.Type == EnumDropDown.HDTJobType.E_TYPE4.ToString()).ToList();
double Day_Type4 = 0;
DateTime _tmp = new DateTime();
foreach (var i in ListHDTByProfileN_Type4)
{
_tmp = i.DateTo != null ? i.DateTo.Value : CutOffDuration.DateEnd;
if (i.DateFrom != null)
{
Day_Type4 += _tmp.Subtract(i.DateFrom.Value).TotalDays + 1;
}
}
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_4.ToString(), Day_Type4, 0);
listElementFormula.Add(item);
#endregion
#region tính số ngày làm HDT loại 5
List<Hre_HDTJobEntity> ListHDTByProfileN_Type5 = ListHDTByProfileN.Where(m => m.Type == EnumDropDown.HDTJobType.E_TYPE5.ToString()).ToList();
double Day_Type5 = 0;
foreach (var i in ListHDTByProfileN_Type5)
{
_tmp = i.DateTo != null ? i.DateTo.Value : CutOffDuration.DateEnd;
if (i.DateFrom != null)
{
Day_Type5 += _tmp.Subtract(i.DateFrom.Value).TotalDays + 1;
}
}
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_5.ToString(), Day_Type5, 0);
listElementFormula.Add(item);
#endregion
#region tính số ngày làm HDT loại 4 tháng N-1
ListHDTByProfileN_Type4 = ListHDTByProfileN1.Where(m => m.Type == EnumDropDown.HDTJobType.E_TYPE4.ToString()).ToList();
Day_Type4 = 0;
_tmp = new DateTime();
foreach (var i in ListHDTByProfileN_Type4)
{
_tmp = i.DateTo != null ? i.DateTo.Value : CutOffDuration.DateEnd;
if (i.DateFrom != null)
{
Day_Type4 += _tmp.Subtract(i.DateFrom.Value).TotalDays + 1;
}
}
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_4_N_1.ToString(), Day_Type4, 0);
listElementFormula.Add(item);
#endregion
#region tính số ngày làm HDT loại 5 tháng N-1
ListHDTByProfileN_Type5 = ListHDTByProfileN1.Where(m => m.Type == EnumDropDown.HDTJobType.E_TYPE5.ToString()).ToList();
Day_Type5 = 0;
foreach (var i in ListHDTByProfileN_Type5)
{
_tmp = i.DateTo != null ? i.DateTo.Value : CutOffDuration.DateEnd;
if (i.DateFrom != null)
{
Day_Type5 += _tmp.Subtract(i.DateFrom.Value).TotalDays + 1;
}
}
item = new ElementFormula(PayrollElement.ATT_WORKDAY_HDT_NOT_DAYOFF_5_N_1.ToString(), Day_Type5, 0);
listElementFormula.Add(item);
#endregion
}
#endregion
#region Số ngày Day Off từ đầu tháng đến ngày vào HDT
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_DAYOFF_STARTMONTH_STARTHDT.ToString(), PayrollElement.ATT_DAYOFF_STARTMONTH_STARTHDT_N_1.ToString() }))
{
#region Tháng N
Hre_HDTJobEntity ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= CutOffDuration.DateEnd && m.DateTo >= CutOffDuration.DateStart).OrderBy(m => m.DateFrom).FirstOrDefault();
if (ListHDTByProfile != null)
{
double DayOff = TotalData.listDayOff.Count(m => m.DateOff <= ListHDTByProfile.DateFrom && m.DateOff >= CutOffDuration.DateStart);
item = new ElementFormula(PayrollElement.ATT_DAYOFF_STARTMONTH_STARTHDT.ToString(), DayOff, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_DAYOFF_STARTMONTH_STARTHDT.ToString(), 0, 0, "null");
listElementFormula.Add(item);
}
#endregion
#region Tháng N-1
DateTime DateStartN1 = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndN1 = CutOffDuration.DateEnd.AddMonths(-1);
ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= DateEndN1 && m.DateTo >= DateStartN1).OrderBy(m => m.DateFrom).FirstOrDefault();
if (ListHDTByProfile != null)
{
double DayOff = TotalData.listDayOff.Count(m => m.DateOff <= ListHDTByProfile.DateFrom && m.DateOff >= DateStartN1);
item = new ElementFormula(PayrollElement.ATT_DAYOFF_STARTMONTH_STARTHDT_N_1.ToString(), DayOff, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_DAYOFF_STARTMONTH_STARTHDT_N_1.ToString(), 0, 0, "null");
listElementFormula.Add(item);
}
#endregion
}
#endregion
#region số ngày từ ngày vào hdt đến cuối tháng trừ số ngày dayoff từ ngày vào đến cuối tháng(tháng N và tháng N-1)
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKDAY_STARTHDT_MONTHEND.ToString(), PayrollElement.ATT_WORKDAY_STARTHDT_MONTHEND_N_1.ToString() }))
{
double WorkDay = 0;
double DayOff = 0;
#region Tháng N
List<Hre_HDTJobEntity> ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= CutOffDuration.DateEnd && m.DateTo >= CutOffDuration.DateStart).OrderBy(m => m.DateFrom).ToList();
if (ListHDTByProfile.Count > 0)
{
foreach (var i in ListHDTByProfile)
{
if (i.DateFrom != null && i.DateTo != null)
{
if (i.DateTo < CutOffDuration.DateEnd)
{
WorkDay += i.DateTo.Value.Subtract(i.DateFrom.Value).TotalDays + 1;
}
else
{
WorkDay += CutOffDuration.DateEnd.Subtract(i.DateFrom.Value).TotalDays + 1;
}
}
}
DayOff = TotalData.listDayOff.Count(m => m.DateOff >= ListHDTByProfile.FirstOrDefault().DateFrom && m.DateOff <= CutOffDuration.DateEnd);
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_MONTHEND.ToString(), WorkDay - DayOff, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_MONTHEND.ToString(), 0, 0, "null");
listElementFormula.Add(item);
}
#endregion
#region Tháng N-1
DateTime DateStartN1 = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndN1 = CutOffDuration.DateEnd.AddMonths(-1);
WorkDay = 0;
DayOff = 0;
ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= DateEndN1 && m.DateTo >= DateStartN1).OrderBy(m => m.DateFrom).ToList();
if (ListHDTByProfile.Count > 0)
{
foreach (var i in ListHDTByProfile)
{
if (i.DateFrom != null && i.DateTo != null)
{
if (i.DateTo < CutOffDuration.DateEnd)
{
WorkDay += i.DateTo.Value.Subtract(i.DateFrom.Value).TotalDays + 1;
}
else
{
WorkDay += CutOffDuration.DateEnd.Subtract(i.DateFrom.Value).TotalDays + 1;
}
}
}
DayOff = TotalData.listDayOff.Count(m => m.DateOff >= ListHDTByProfile.FirstOrDefault().DateFrom && m.DateOff <= CutOffDuration.DateEnd);
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_MONTHEND_N_1.ToString(), WorkDay - DayOff, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_MONTHEND_N_1.ToString(), 0, 0, "null");
listElementFormula.Add(item);
}
#endregion
}
#endregion
#region số ngày từ ngày vào hdt tháng N-1 đến ngày ra hdt tháng N-1 trừ ngày dayoff tháng N-1 và N-2
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_1.ToString(), PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_2.ToString() }))
{
DateTime DateStartN1 = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndN1 = CutOffDuration.DateEnd.AddMonths(-1);
DateTime DateStartN2 = CutOffDuration.DateStart.AddMonths(-2);
DateTime DateEndN2 = CutOffDuration.DateEnd.AddMonths(-2);
double workDayHDT = 0;
double DayOff = TotalData.listDayOff.Count(m => m.DateOff <= DateEndN1 && m.DateOff >= DateStartN1);
#region Tháng N-1
List<Hre_HDTJobEntity> ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= DateEndN1 && m.DateTo >= DateStartN1).OrderBy(m => m.DateFrom).ToList();
foreach (var i in ListHDTByProfile)
{
workDayHDT += i.DateTo.Value.Subtract(i.DateFrom.Value).TotalDays + 1;
}
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_1.ToString(), workDayHDT - DayOff, 0);
listElementFormula.Add(item);
#endregion
#region Tháng N-2
workDayHDT = 0;
DayOff = TotalData.listDayOff.Count(m => m.DateOff <= DateEndN2 && m.DateOff >= DateStartN2);
ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= DateEndN2 && m.DateTo >= DateStartN2).OrderBy(m => m.DateFrom).ToList();
foreach (var i in ListHDTByProfile)
{
workDayHDT += i.DateTo.Value.Subtract(i.DateFrom.Value).TotalDays + 1;
}
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_2.ToString(), workDayHDT - DayOff, 0);
listElementFormula.Add(item);
#endregion
}
#endregion
#region Ngày vào HDT tháng N-1 và N-2
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_STARTDATE_HDT_N_1.ToString(), PayrollElement.ATT_STARTDATE_HDT_N_2.ToString() }))
{
DateTime DateStartN1 = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEndN1 = CutOffDuration.DateEnd.AddMonths(-1);
DateTime DateStartN2 = CutOffDuration.DateStart.AddMonths(-2);
DateTime DateEndN2 = CutOffDuration.DateEnd.AddMonths(-2);
Hre_HDTJobEntity ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= DateEndN1 && m.DateTo >= DateStartN1).OrderBy(m => m.DateFrom).FirstOrDefault();
if (ListHDTByProfile != null)
{
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_1.ToString(), ListHDTByProfile.DateFrom, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_1.ToString(), 0, 0);
listElementFormula.Add(item);
}
ListHDTByProfile = TotalData.listHre_HDTJob_All.Where(m => m.ProfileID == profileItem.ID && m.Status == HDTJobStatus.E_APPROVE.ToString() && m.DateTo != null && m.DateFrom != null && m.DateFrom <= DateEndN2 && m.DateTo >= DateStartN2).OrderBy(m => m.DateFrom).FirstOrDefault();
if (ListHDTByProfile != null)
{
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_2.ToString(), ListHDTByProfile.DateFrom, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKDAY_STARTHDT_ENDHDT_N_2.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
#endregion
#endregion
#endregion
#region Enum phần tử lương
//Có tham gia công đoàn
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.IS_HRE_TRADEUNION.ToString()))
{
var ProfilePartyUnion = TotalData.listProfilePartyUnion.Where(m => m.ProfileID == profileItem.ID && m.IsTradeUnionist == true && m.TradeUnionistEnrolledDate != null && m.TradeUnionistEnrolledDate.Value <= CutOffDuration.DateEnd).FirstOrDefault();
item = new ElementFormula(PayrollElement.IS_HRE_TRADEUNION.ToString(), ProfilePartyUnion != null ? 1 : 0, 0);
listElementFormula.Add(item);
}
//Người phụ thuộc
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_DEPENDENT.ToString()))
{
item = new ElementFormula(PayrollElement.SAL_DEPENDENT.ToString(), GetDependantNumber(TotalData.listDependant, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd), 0);
listElementFormula.Add(item);
}
//Mức lương HDT
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_SALARY_HDT.ToString(), PayrollElement.SAL_SALARY_HDT_N_1.ToString() }))
{
var Insurence = TotalData.listInsurance.Where(m => m.ProfileID == profileItem.ID && m.MonthYear != null && m.MonthYear.Value.Year == CutOffDuration.MonthYear.Year && m.MonthYear.Value.Month == CutOffDuration.MonthYear.Month).FirstOrDefault();
item = new ElementFormula(PayrollElement.SAL_SALARY_HDT.ToString(), Insurence != null && Insurence.AmountChargeIns != null ? Insurence.AmountChargeIns : 0, 0);
listElementFormula.Add(item);
DateTime MonthYearPrev = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CutOffDuration.MonthYear.Day).AddMonths(-1);
Insurence = TotalData.listInsurance.Where(m => m.ProfileID == profileItem.ID && m.MonthYear != null && m.MonthYear.Value.Year == MonthYearPrev.Year && m.MonthYear.Value.Month == MonthYearPrev.Month).FirstOrDefault();
item = new ElementFormula(PayrollElement.SAL_SALARY_HDT_N_1.ToString(), Insurence != null && Insurence.AmountChargeIns != null ? Insurence.AmountChargeIns : 0, 0);
listElementFormula.Add(item);
}
//Luong co ban thang 3
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_BASIC_SALARY_T3.ToString()))
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_T3.ToString(), TotalData.listBasicSalaryT3.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
//Bậc lương
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_SALARY_RANK_NAME.ToString()))
{
Sal_BasicSalaryEntity BasicSalarybyProfile = new Sal_BasicSalaryEntity();
BasicSalarybyProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).FirstOrDefault();
item = new ElementFormula(PayrollElement.SAL_SALARY_RANK_NAME.ToString(), BasicSalarybyProfile != null ? BasicSalarybyProfile.SalaryRankName : "", 0);
listElementFormula.Add(item);
}
//Bậc lương (class)
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_SALARY_CLASS_NAME.ToString()))
{
Sal_BasicSalaryEntity BasicSalarybyProfile = new Sal_BasicSalaryEntity();
BasicSalarybyProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).FirstOrDefault();
item = new ElementFormula(PayrollElement.SAL_SALARY_CLASS_NAME.ToString(), BasicSalarybyProfile != null ? BasicSalarybyProfile.SalaryClassName : "", 0);
listElementFormula.Add(item);
}
//Hệ số lương nhân viên
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_BASIC_PERSONALRATE.ToString()))
{
List<Sal_BasicSalaryEntity> SalaryProfile = new List<Sal_BasicSalaryEntity>();
SalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
item = new ElementFormula(PayrollElement.SAL_BASIC_PERSONALRATE.ToString(), SalaryProfile.FirstOrDefault().PersonalRate != null ? SalaryProfile.FirstOrDefault().PersonalRate : 0, 0, "Null");
listElementFormula.Add(item);
}
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_BASIC_SALARY_DATECLOSE.ToString(), PayrollElement.SAL_BASIC_SALARY_DATECLOSE_N_1.ToString() }))
{
List<Sal_BasicSalaryEntity> ListSalaryProfile = new List<Sal_BasicSalaryEntity>();
ListSalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
if (ListSalaryProfile.Count > 0)
{
//Lấy các phần tử tính lương nằm trong Grade của nhân viên
Sal_GradeEntity Grade = FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd);
//loại bỏ nhân viên có ngày vào làm sau ngày chốt lương
Cat_GradePayrollEntity CatGrade = TotalData.listCat_GradePayroll.Where(m => m.ID == Grade.GradePayrollID).FirstOrDefault();
//ngày bắt đầu chốt lương
DateTime DateClose = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1).AddDays(1).AddMonths(-1);
//ngày kết thúc chốt lương
DateTime DateEndClose = new DateTime(CutOffDuration.MonthYear.Year, CutOffDuration.MonthYear.Month, CatGrade.SalaryDayClose != null ? (int)CatGrade.SalaryDayClose : 1);
//lọc lại lương cơ bản theo kỳ chốt
ListSalaryProfile = ListSalaryProfile.Where(m => m.DateOfEffect <= DateEndClose).ToList();
//lương cơ bản gần nhất
Sal_BasicSalaryEntity SalaryProfile = ListSalaryProfile.FirstOrDefault();
//nếu ngày thay đổi lương nằm trong kỳ chốt lương thì lấy 2 mức
if (SalaryProfile.DateOfEffect >= DateClose && SalaryProfile.DateOfEffect <= DateEndClose)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_DATECLOSE.ToString(), SalaryProfile.GrossAmount, 0);
listElementFormula.Add(item);
Sal_BasicSalaryEntity SalaryProfile_Prev = ListSalaryProfile.Where(m => m.DateOfEffect < DateClose).OrderByDescending(m => m.DateOfEffect).FirstOrDefault();
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_DATECLOSE_N_1.ToString(), SalaryProfile_Prev != null ? SalaryProfile_Prev.GrossAmount : "0", 0);
listElementFormula.Add(item);
}
else//chỉ áp dụng 1 mức lương
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_DATECLOSE.ToString(), SalaryProfile.GrossAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_DATECLOSE_N_1.ToString(), SalaryProfile.GrossAmount, 0);
listElementFormula.Add(item);
}
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_DATECLOSE.ToString(), 0, 0, "Không có lương cơ bản !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_DATECLOSE_N_1.ToString(), 0, 0, "Không có thay đổi lương trong tháng !");
listElementFormula.Add(item);
}
}
//Lương cơ bản
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_BASIC_SALARY.ToString(), PayrollElement.HR_SALARYCLASSNAME.ToString(), PayrollElement.SAL_BASIC_SALARY2.ToString(), PayrollElement.SAL_BASIC_SALARY1.ToString(), PayrollElement.SAL_BASIC_SALARY_N_1.ToString(), PayrollElement.SAL_BASIC_SALARY_N_2.ToString(), PayrollElement.SAL_BASIC_SALARY_N_3.ToString(), PayrollElement.SAL_BASIC_SALARY_N_4.ToString(), PayrollElement.SAL_BASIC_SALARY_N_5.ToString(), PayrollElement.SAL_BASIC_SALARY_N_6.ToString(), PayrollElement.SAL_INCENTIVE.ToString() }))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
List<Sal_BasicSalaryEntity> SalaryProfile = new List<Sal_BasicSalaryEntity>();
SalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
if (SalaryProfile != null && SalaryProfile.Count > 0)//có lương cơ bản
{
//bật lương
item = new ElementFormula(PayrollElement.HR_SALARYCLASSNAME.ToString(), SalaryProfile.FirstOrDefault().SalaryClassCode, 0, "Null");
listElementFormula.Add(item);
//lương cơ bản tháng hiện tại
if (SalaryProfile.FirstOrDefault().DateOfEffect <= CutOffDuration.DateStart)//chỉ có 1 mức lương trong tháng
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY.ToString(), SalaryProfile.OrderByDescending(m => m.DateOfEffect).FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_INCENTIVE.ToString(), 0, 0);
listElementFormula.Add(item);
}
else//2 mức lương trong tháng
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY2.ToString(), SalaryProfile.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
if (SalaryProfile.Count > 1)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY1.ToString(), SalaryProfile[1].GrossAmount, 0);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY1.ToString(), 0, 0, "Null");
}
listElementFormula.Add(item);
#region Tính số ngày thay đổi lương
List<Att_RosterEntity> listRosterProfile = new List<Att_RosterEntity>();
//Lọc ra các roster thuộc nhân viên và nằm trong tháng tính lương
listRosterProfile = TotalData.listRoster.Where(m => m.ProfileID == profileItem.ID).ToList();
int totalLeave = 0;
foreach (var j in listRosterProfile)
{
DateTime _tmp = j.DateStart;
while (true)
{
if (_tmp > CutOffDuration.DateEnd)
{
break;
}
if (_tmp >= SalaryProfile.FirstOrDefault().DateOfEffect)
{
int day = (int)_tmp.DayOfWeek;
switch (day)
{
case 0://CN
if (j.SunShiftID != null)
{
totalLeave++;
}
break;
case 1://T2
if (j.MonShiftID != null)
{
totalLeave++;
}
break;
case 2:
if (j.TueShiftID != null)
{
totalLeave++;
}
break;
case 3:
if (j.WedShiftID != null)
{
totalLeave++;
}
break;
case 4:
if (j.ThuShiftID != null)
{
totalLeave++;
}
break;
case 5:
if (j.FriShiftID != null)
{
totalLeave++;
}
break;
case 6:
if (j.SatShiftID != null)
{
totalLeave++;
}
break;
default:
break;
}
}
_tmp = _tmp.AddDays(1);
}
}
//cập nhật lại giá trị cho enum số ngày thay đổi lương
int days = (CutOffDuration.DateEnd - SalaryProfile.FirstOrDefault().DateOfEffect).Days;
days = days - totalLeave;
item = new ElementFormula(PayrollElement.SAL_INCENTIVE.ToString(), days, 0);
listElementFormula.Add(item);
//item = listElementFormula.Where(m => m.VariableName == PayrollElement.SAL_INCENTIVE.ToString()).FirstOrDefault();
//item.Value = days;
#endregion
}
#region lương cơ bản 6 tháng trước đó
var _basicsalaryPrevCurrentMonth = SalaryProfile.Where(m => m.DateOfEffect <= CutOffDuration.DateEnd.AddMonths(-1)).OrderByDescending(m => m.DateOfEffect).ToList();
if (_basicsalaryPrevCurrentMonth.Count > 0)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_1.ToString(), _basicsalaryPrevCurrentMonth.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_1.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
_basicsalaryPrevCurrentMonth = SalaryProfile.Where(m => m.DateOfEffect <= CutOffDuration.DateEnd.AddMonths(-2)).OrderByDescending(m => m.DateOfEffect).ToList();
if (_basicsalaryPrevCurrentMonth.Count > 0)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_2.ToString(), _basicsalaryPrevCurrentMonth.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_2.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
_basicsalaryPrevCurrentMonth = SalaryProfile.Where(m => m.DateOfEffect <= CutOffDuration.DateEnd.AddMonths(-3)).OrderByDescending(m => m.DateOfEffect).ToList();
if (_basicsalaryPrevCurrentMonth.Count > 0)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_3.ToString(), _basicsalaryPrevCurrentMonth.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_3.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
_basicsalaryPrevCurrentMonth = SalaryProfile.Where(m => m.DateOfEffect <= CutOffDuration.DateEnd.AddMonths(-4)).OrderByDescending(m => m.DateOfEffect).ToList();
if (_basicsalaryPrevCurrentMonth.Count > 0)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_4.ToString(), _basicsalaryPrevCurrentMonth.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_4.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
_basicsalaryPrevCurrentMonth = SalaryProfile.Where(m => m.DateOfEffect <= CutOffDuration.DateEnd.AddMonths(-5)).OrderByDescending(m => m.DateOfEffect).ToList();
if (_basicsalaryPrevCurrentMonth.Count > 0)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_5.ToString(), _basicsalaryPrevCurrentMonth.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_5.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
_basicsalaryPrevCurrentMonth = SalaryProfile.Where(m => m.DateOfEffect <= CutOffDuration.DateEnd.AddMonths(-6)).OrderByDescending(m => m.DateOfEffect).ToList();
if (_basicsalaryPrevCurrentMonth.Count > 0)
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_6.ToString(), _basicsalaryPrevCurrentMonth.FirstOrDefault().GrossAmount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_6.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
#endregion
}
else//không có lương cơ bản
{
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY.ToString(), 0, 0, "Không có lương cơ bản tháng N");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_1.ToString(), 0, 0, "Không có lương cơ bản tháng N-1");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_2.ToString(), 0, 0, "Không có lương cơ bản tháng N-2");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_3.ToString(), 0, 0, "Không có lương cơ bản tháng N-3");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_4.ToString(), 0, 0, "Không có lương cơ bản tháng N-4");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_5.ToString(), 0, 0, "Không có lương cơ bản tháng N-5");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY_N_6.ToString(), 0, 0, "Không có lương cơ bản tháng N-6");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY1.ToString(), 0, 0, "Không có lương cơ bản tháng N");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_BASIC_SALARY2.ToString(), 0, 0, "Không có lương cơ bản tháng N");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_INCENTIVE.ToString(), 0, 0, "Không có thay đổi lương tháng N");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.HR_SALARYCLASSNAME.ToString(), 0, 0, "Không có Bậc / Hệ số lương tháng N");
listElementFormula.Add(item);
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_UNUSUALALLOWANCE_MONTHSTART.ToString(), PayrollElement.SAL_UNUSUALALLOWANCE_MONTHEND.ToString(), PayrollElement.SAL_UNUSUALALLOWANCE_YEARSTART.ToString(), PayrollElement.SAL_UNUSUALALLOWANCE_YEAREND.ToString(), PayrollElement.SAL_UNUSUALALLOWANCE_NOCOMPENSATION.ToString() }))
{
Sal_UnusualAllowanceEntity SalUnusualAllowanceProfile = TotalData.listSalUnusualAllowance.Where(m => m.ProfileID == profileItem.ID && m.MonthStart <= CutOffDuration.DateEnd && (m.MonthEnd == null || m.MonthEnd >= CutOffDuration.DateStart)).FirstOrDefault();
//Tháng bắt đầu hưởng PC
item = new ElementFormula(PayrollElement.SAL_UNUSUALALLOWANCE_MONTHSTART.ToString(), SalUnusualAllowanceProfile != null ? SalUnusualAllowanceProfile.MonthStart != null ? SalUnusualAllowanceProfile.MonthStart : DateTime.MinValue : DateTime.MinValue, 0);
listElementFormula.Add(item);
//Tháng kết thúc hưởng PC
item = new ElementFormula(PayrollElement.SAL_UNUSUALALLOWANCE_MONTHEND.ToString(), SalUnusualAllowanceProfile != null ? SalUnusualAllowanceProfile.MonthEnd != null ? SalUnusualAllowanceProfile.MonthEnd : DateTime.MinValue : DateTime.MinValue, 0);
listElementFormula.Add(item);
//Năm bắt đầu hưởng PC
item = new ElementFormula(PayrollElement.SAL_UNUSUALALLOWANCE_YEARSTART.ToString(), SalUnusualAllowanceProfile != null ? SalUnusualAllowanceProfile.MonthStart != null ? SalUnusualAllowanceProfile.MonthStart.Value.Year : 0 : 0, 0);
listElementFormula.Add(item);
//Năm kết thúc hưởng PC
item = new ElementFormula(PayrollElement.SAL_UNUSUALALLOWANCE_YEAREND.ToString(), SalUnusualAllowanceProfile != null ? SalUnusualAllowanceProfile.MonthEnd != null ? SalUnusualAllowanceProfile.MonthEnd.Value.Year : 0 : 0, 0);
listElementFormula.Add(item);
//Số tháng bù
item = new ElementFormula(PayrollElement.SAL_UNUSUALALLOWANCE_NOCOMPENSATION.ToString(), SalUnusualAllowanceProfile != null ? SalUnusualAllowanceProfile.NoCompensation != null ? SalUnusualAllowanceProfile.NoCompensation : 0 : 0, 0);
listElementFormula.Add(item);
}
//// Mức phụ cấp con nhỏ mỗi tháng
//item = new ElementFormula(PayrollElement.SAL_UNUSUALALLOWANCE_NOCOMPENSATION.ToString(), 0, 0);
//listElementFormula.Add(item);
//Thánh tính lương
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.ATT_CUTOFFDURATION_MONTH.ToString()))
{
item = new ElementFormula(PayrollElement.ATT_CUTOFFDURATION_MONTH.ToString(), CutOffDuration.DateStart, 0);
listElementFormula.Add(item);
}
//Tổng lương bộ phận của nhân viên
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_SALARY_DEPARTMENT.ToString()))
{
if (TotalData.listSal_SalaryDepartmentItem.Any(m => m.ProfileID == profileItem.ID))
{
var AmountSalary = TotalData.listSal_SalaryDepartmentItem.Where(m => m.ProfileID == profileItem.ID).FirstOrDefault().AmoutSalary;
item = new ElementFormula(PayrollElement.SAL_SALARY_DEPARTMENT.ToString(), AmountSalary != null ? AmountSalary : 0, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_SALARY_DEPARTMENT.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_SALARY_DATE_CLOSE.ToString()))
{
Cat_GradePayrollEntity CatGradePayrollItem = TotalData.listCat_GradePayroll.Where(m => m.ID == FindGradePayrollByProfileAndMonthYear(TotalData.listGrade, profileItem.ID, CutOffDuration.DateStart, CutOffDuration.DateEnd).ID).FirstOrDefault();
if (CatGradePayrollItem != null && CatGradePayrollItem.SalaryDayClose != null)
{
item = new ElementFormula(PayrollElement.SAL_SALARY_DATE_CLOSE.ToString(), CatGradePayrollItem.SalaryDayClose, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_SALARY_DATE_CLOSE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
//Giữ lương
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_HOLD_SALARY.ToString(), PayrollElement.SAL_HOLD_SALARY_AFTERTAX.ToString() }))
{
DateTime _tmpCutoffDuration = CutOffDuration.MonthYear.AddMonths(-1);
Sal_HoldSalaryEntity holdSalaryItem = TotalData.listSal_HoldSalary.Where(m => m.ProfileID == profileItem.ID
&& m.MonthEndSalary != null
&& m.Status == EnumDropDown.WorkdayStatus.E_APPROVED.ToString()
&& m.MonthEndSalary.Value.Month == _tmpCutoffDuration.Month
&& m.MonthEndSalary.Value.Year == _tmpCutoffDuration.Year).FirstOrDefault();
if (holdSalaryItem != null)
{
item = new ElementFormula(PayrollElement.SAL_HOLD_SALARY.ToString(), holdSalaryItem.AmountSalary, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_HOLD_SALARY_AFTERTAX.ToString(), holdSalaryItem.AmountSalaryAfterTax, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_HOLD_SALARY.ToString(), 0, 0, "null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_HOLD_SALARY_AFTERTAX.ToString(), 0, 0, "null");
listElementFormula.Add(item);
}
}
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_SALARY_ACCOUNT_NO.ToString(), PayrollElement.SAL_SALARY_GROUP_BANK.ToString(), PayrollElement.SAL_SALARY_BANK_NAME.ToString() }))
{
Sal_SalaryInformationEntity SalaryInfomationByProfile = TotalData.listSalaryInformation.FirstOrDefault(m => m.ProfileID == profileItem.ID);
if (SalaryInfomationByProfile != null)
{
item = new ElementFormula(PayrollElement.SAL_SALARY_ACCOUNT_NO.ToString(), SalaryInfomationByProfile.AccountNo, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_SALARY_GROUP_BANK.ToString(), SalaryInfomationByProfile.GroupBank, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_SALARY_BANK_NAME.ToString(), SalaryInfomationByProfile.BankName, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_SALARY_ACCOUNT_NO.ToString(), "", 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_SALARY_GROUP_BANK.ToString(), "", 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_SALARY_BANK_NAME.ToString(), "", 0, "Null");
listElementFormula.Add(item);
}
}
#endregion
#region Enum phần tử công
#region Phần tử công tháng trước (N-1)
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKING_DAY_PREV.ToString(), PayrollElement.ATT_STD_DAY_PREV.ToString() }))
{
if (TotalData.Att_AttendanceTable_Prev != null)
{
Att_AttendanceTableEntity _tmp = TotalData.Att_AttendanceTable_Prev.Where(m => m.ProfileID == profileItem.ID).FirstOrDefault();
if (_tmp != null)
{
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY_PREV.ToString(), _tmp.RealWorkDayCount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_STD_DAY_PREV.ToString(), _tmp.StdWorkDayCount, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY_PREV.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_STD_DAY_PREV.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY_PREV.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_STD_DAY_PREV.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
#endregion
#region Ngày công đi làm thực tế
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKING_DAY.ToString(), PayrollElement.ATT_WORKING_DAY_AFTER.ToString() }))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//lấy lương cơ bản của nhân viên
List<Sal_BasicSalaryEntity> SalaryProfile = new List<Sal_BasicSalaryEntity>();
SalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
if (SalaryProfile.Count > 0 && SalaryProfile.FirstOrDefault().DateOfEffect > CutOffDuration.DateStart)//có thay đổi lương trong tháng
{
//ngày bắt đầu mức lương 1 và ngày bắt đầu mức lương 2
DateTime dateStart1 = CutOffDuration.DateStart;
DateTime dateStart2 = SalaryProfile.FirstOrDefault().DateOfEffect;
//lấy dữ liệu công theo cutoff
List<Att_AttendanceTableItemEntity> listAttTableItem = TotalData.listAttendanceTableItem.Where(m => m.ProfileID == profileItem.ID).ToList();
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY.ToString(), listAttTableItem.Where(m => m.WorkDate < dateStart2).Count(), 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY_AFTER.ToString(), listAttTableItem.Where(m => m.WorkDate >= dateStart2).Count(), 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY.ToString(), listAttendanceTableProCut.RealWorkDayCount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_WORKING_DAY_AFTER.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
}
#endregion
#region Ngày công đi làm tính lương
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_WORKING_PAIDLEAVE_DAY.ToString(), PayrollElement.ATT_WORKING_PAIDLEAVE_DAY_AFTER.ToString() }))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//lấy lương cơ bản của nhân viên
List<Sal_BasicSalaryEntity> SalaryProfile = new List<Sal_BasicSalaryEntity>();
SalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
if (SalaryProfile.Count > 0 && SalaryProfile.FirstOrDefault().DateOfEffect > CutOffDuration.DateStart)//có thay đổi lương trong tháng
{
//ngày bắt đầu mức lương 1 và ngày bắt đầu mức lương 2
DateTime dateStart1 = CutOffDuration.DateStart;
DateTime dateStart2 = SalaryProfile.FirstOrDefault().DateOfEffect;
//lưu số ngày công tính lương trước và sau khi thay đổi lương
double workpaid = 0;
double workpaid_after = 0;
//lấy dữ liệu công theo cutoff
List<Att_AttendanceTableItemEntity> listAttTableItem = TotalData.listAttendanceTableItem.Where(m => m.ProfileID == profileItem.ID).ToList();
//duyệt wa tất cả các dòng
foreach (var tableItem in listAttTableItem)
{
if (tableItem.WorkDate < dateStart2)//trước khi điều chỉnh
{
workpaid += tableItem.WorkPaidHours / tableItem.AvailableHours;
}
if (tableItem.WorkDate >= dateStart2)//sau khi điều chỉnh
{
workpaid_after += tableItem.WorkPaidHours / tableItem.AvailableHours;
}
}
item = new ElementFormula(PayrollElement.ATT_WORKING_PAIDLEAVE_DAY.ToString(), listAttTableItem.Where(m => m.WorkDate < dateStart2).Count(), 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_WORKING_PAIDLEAVE_DAY_AFTER.ToString(), listAttTableItem.Where(m => m.WorkDate >= dateStart2).Count(), 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_WORKING_PAIDLEAVE_DAY.ToString(), listAttendanceTableProCut.RealWorkDayCount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_WORKING_PAIDLEAVE_DAY_AFTER.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
}
#endregion
#region Số ngày phép năm cộng dồn - Số ngày phép ốm cộng dồn
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_ANNUAL_INCREMENTAL.ToString(), PayrollElement.ATT_SICK_INCREMENTAL.ToString() }))
{
List<Att_AnnualDetailEntity> AnnualDetailByProfile = TotalData.listAnnualDetail.Where(m => m.ProfileID == profileItem.ID).ToList();
if (AnnualDetailByProfile != null && AnnualDetailByProfile.Count <= 0)
{
var ANNUAL = AnnualDetailByProfile.FirstOrDefault(m => m.Type == AnnualLeaveDetailType.E_ANNUAL_LEAVE.ToString());
var SICK = AnnualDetailByProfile.FirstOrDefault(m => m.Type == AnnualLeaveDetailType.E_SICK_LEAVE.ToString());
item = new ElementFormula(PayrollElement.ATT_ANNUAL_INCREMENTAL.ToString(), ANNUAL != null ? ANNUAL.InitAvailable != null ? ANNUAL.InitAvailable : 0 : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_SICK_INCREMENTAL.ToString(), SICK != null ? SICK.InitAvailable != null ? SICK.InitAvailable : 0 : 0, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.ATT_ANNUAL_INCREMENTAL.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_SICK_INCREMENTAL.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
#endregion
//Phần tử công tháng hiện tại
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_STD_DAY.ToString(), PayrollElement.ATT_HOURS_PER_DAY.ToString(), PayrollElement.ATT_OVERTIME_PIT_HOURS.ToString(), PayrollElement.ATT_TOTAL_ANNUALLEAVE_AVAILABLE.ToString(), PayrollElement.ATT_ANNUALLEAVE_ADJACENT.ToString(), PayrollElement.ATT_TOTAL_SICK_AVAILABLE.ToString(), PayrollElement.ATT_SICK_ADJACENT.ToString(), PayrollElement.ATT_ANNUALLEAVE.ToString(), PayrollElement.ATT_SICKLEAVE.ToString(), PayrollElement.ATT_WORKING_NIGHTSHIFT.ToString() }))
{
if (listAttendanceTableProCut != null)
{
//item = new ElementFormula(PayrollElement.ATT_WORKING_DAY.ToString(), listAttendanceTableProCut.RealWorkDayCount, 0);
//listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_STD_DAY.ToString(), listAttendanceTableProCut.StdWorkDayCount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_HOURS_PER_DAY.ToString(), listAttendanceTableProCut.HourPerDay, 0);
listElementFormula.Add(item);
//item = new ElementFormula(PayrollElement.ATT_WORKING_PAIDLEAVE_DAY.ToString(), listAttendanceTableProCut.TotalPaidWorkDayCount, 0);
//listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_WORKING_NIGHTSHIFT.ToString(), listAttendanceTableProCut.NightShiftHours, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_TOTAL_ANNUALLEAVE_AVAILABLE.ToString(), listAttendanceTableProCut.TotalAnlDayAvailable != null ? listAttendanceTableProCut.TotalAnlDayAvailable : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_ANNUALLEAVE_ADJACENT.ToString(), listAttendanceTableProCut.AnlDayAdjacent, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_ANNUALLEAVE.ToString(), listAttendanceTableProCut.AnlDayTaken, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_SICKLEAVE.ToString(), listAttendanceTableProCut.SickDayTaken, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_TOTAL_SICK_AVAILABLE.ToString(), listAttendanceTableProCut.TotalSickDayAvailable, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_SICK_ADJACENT.ToString(), listAttendanceTableProCut.SickDayAdjacent, 0);
listElementFormula.Add(item);
}
else
{
//item = new ElementFormula(PayrollElement.ATT_WORKING_DAY.ToString(), 0, 0, "Null");
//listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_STD_DAY.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_HOURS_PER_DAY.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
//item = new ElementFormula(PayrollElement.ATT_WORKING_PAIDLEAVE_DAY.ToString(), 0, 0, "Null");
//listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_WORKING_NIGHTSHIFT.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_TOTAL_ANNUALLEAVE_AVAILABLE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_ANNUALLEAVE_ADJACENT.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_TOTAL_SICK_AVAILABLE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_SICK_ADJACENT.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_SICKLEAVE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_ANNUALLEAVE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
//Số ngày nghỉ có trả lương
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_DAY.ToString(), PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_DAY_NOT_PAY.ToString() }))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//Guid AttendanceTableItemByAttID = Guid.Empty;
double Total_LeaveDay = 0;
double Total_LeaveDay_NotPay = 0;
if (listAttendanceTableProCut != null)
{
// AttendanceTableItemByAtt = repoAttendanceTable.FindBy(m => m.IsDelete != true && m.ID == listAttendanceTableProCut.ID).FirstOrDefault();
//AttendanceTableItemByAttID = unitOfWork.CreateQueryable<Att_AttendanceTable>(m => m.ID == listAttendanceTableProCut.ID).Select(m => m.ID).FirstOrDefault();
// var AttendanceTableItem = repoAttendanceTableItem.FindBy(m => m.IsDelete != true && m.AttendanceTableID == AttendanceTableItemByAttID).ToList();
var AttendanceTableItem = TotalData.listAttendanceTableItem.Where(m => m.AttendanceTableID == listAttendanceTableProCut.ID).ToList();
for (int j = 0; j < AttendanceTableItem.Count; j++)
{
if (AttendanceTableItem[j].LeaveTypeID != null)
{
var LeaveDay = TotalData.listLeavedayType.Where(m => m.ID == AttendanceTableItem[j].LeaveTypeID).FirstOrDefault();
if (LeaveDay != null)
{
//code của là so sánh với IsWorkDay
if (LeaveDay.IsAnnualLeave || LeaveDay.PaidRate >= 1)
{
Total_LeaveDay += AttendanceTableItem[j].PaidLeaveHours / AttendanceTableItem[j].AvailableHours;
}
else if (!LeaveDay.IsAnnualLeave && LeaveDay.PaidRate <= 0)
{
//Total_LeaveDay_NotPay += AttendanceTableItem[j].PaidLeaveHours / AttendanceTableItem[j].AvailableHours;
Total_LeaveDay_NotPay++;
}
}
}
}
}
item = new ElementFormula(PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_DAY.ToString(), Total_LeaveDay, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_DAY_NOT_PAY.ToString(), Total_LeaveDay_NotPay, 0);
listElementFormula.Add(item);
}
}
//Tổng số ngày công trong năm
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_TOTAL_WORKDAY_IN_YEAR.ToString() }))
{
var Attantendence = TotalData.listAttendanceTable.Where(m => m.ProfileID == profileItem.ID).ToList();
item = new ElementFormula(PayrollElement.ATT_TOTAL_WORKDAY_IN_YEAR.ToString(), Attantendence.Sum(m => m.StdWorkDayCount), 0);
listElementFormula.Add(item);
}
//Tổng số ngày công thực tế trong năm
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_TOTAL_REALITYWORKDAY_IN_YEAR.ToString() }))
{
var Attantendence = TotalData.listAttendanceTable.Where(m => m.ProfileID == profileItem.ID).ToList();
item = new ElementFormula(PayrollElement.ATT_TOTAL_REALITYWORKDAY_IN_YEAR.ToString(), Attantendence.Sum(m => m.RealWorkDayCount), 0);
listElementFormula.Add(item);
}
//Tổng số ngày làm việc trong năm (365-dayoff)
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_TOTAL_DAY_NOT_DAYOFF_IN_YEAR.ToString() }))
{
DateTime form = new DateTime(CutOffDuration.MonthYear.Year - 1, 4, 1);
DateTime to = new DateTime(CutOffDuration.MonthYear.Year, 3, 31);
int days = new DateTime(CutOffDuration.MonthYear.Year, 12, 31).DayOfYear;
int dayOff = TotalData.listDayOff.Where(m => m.DateOff >= form && m.DateOff <= to && m.OrgStructureID == null).Count();
item = new ElementFormula(PayrollElement.ATT_TOTAL_DAY_NOT_DAYOFF_IN_YEAR.ToString(), days - dayOff, 0);
listElementFormula.Add(item);
}
#endregion
#region Enum phần tử bảo hiểm
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.INS_HEALTH_INSURANCE.ToString(), PayrollElement.INS_SALARY_INSURANCE.ToString(), PayrollElement.INS_SOCIAL_INSURANCE.ToString(), PayrollElement.INS_UNEMP_INSURANCE.ToString(), PayrollElement.INS_SOCIAL_INSURANCE_PROFILE.ToString(), PayrollElement.INS_SOCIAL_INSURANCE_COMPANY.ToString(), PayrollElement.INS_UNEMP_INSURANCE_PROFILE.ToString(), PayrollElement.INS_UNEMP_INSURANCE_COMPANY.ToString(), PayrollElement.INS_HEALTH_INSURANCE_PROFILE.ToString(), PayrollElement.INS_HEALTH_INSURANCE_COMPANY.ToString() }))
{
Ins_ProfileInsuranceMonthlyEntity InsItem = TotalData.listInsurance.Where(m => m.ProfileID == profileItem.ID && m.MonthYear != null && m.MonthYear.Value.Year == CutOffDuration.MonthYear.Year && m.MonthYear.Value.Month == CutOffDuration.MonthYear.Month).FirstOrDefault();
if (InsItem != null)
{
item = new ElementFormula(PayrollElement.INS_HEALTH_INSURANCE.ToString(), InsItem.MoneyHealthInsurance == null ? null : InsItem.MoneyHealthInsurance, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SALARY_INSURANCE.ToString(), InsItem.SalaryInsurance == null ? null : InsItem.SalaryInsurance, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SOCIAL_INSURANCE.ToString(), InsItem.MoneySocialInsurance == null ? null : InsItem.MoneySocialInsurance, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_UNEMP_INSURANCE.ToString(), InsItem.MoneyUnEmpInsurance == null ? null : InsItem.MoneyUnEmpInsurance, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SOCIAL_INSURANCE_PROFILE.ToString(), InsItem.SocialInsEmpAmount == null ? null : InsItem.SocialInsEmpAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SOCIAL_INSURANCE_COMPANY.ToString(), InsItem.SocialInsComAmount == null ? null : InsItem.SocialInsComAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_UNEMP_INSURANCE_PROFILE.ToString(), InsItem.UnemployEmpAmount == null ? null : InsItem.UnemployEmpAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_UNEMP_INSURANCE_COMPANY.ToString(), InsItem.UnemployComAmount == null ? null : InsItem.UnemployComAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_HEALTH_INSURANCE_PROFILE.ToString(), InsItem.HealthInsEmpAmount == null ? null : InsItem.HealthInsEmpAmount, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_HEALTH_INSURANCE_COMPANY.ToString(), InsItem.HealthInsComAmount == null ? null : InsItem.HealthInsComAmount, 0);
listElementFormula.Add(item);
}
else//nếu không có bảo hiểm thì cập nhất value = 0
{
item = new ElementFormula(PayrollElement.INS_HEALTH_INSURANCE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SALARY_INSURANCE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SOCIAL_INSURANCE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_UNEMP_INSURANCE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SOCIAL_INSURANCE_PROFILE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_SOCIAL_INSURANCE_COMPANY.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_UNEMP_INSURANCE_PROFILE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_UNEMP_INSURANCE_COMPANY.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_HEALTH_INSURANCE_PROFILE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.INS_HEALTH_INSURANCE_COMPANY.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
#endregion
#region Enum phần tử hoa hồng
//Lấy taget & actual của shop
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_COM_TAGET_SHOP.ToString(), PayrollElement.SAL_COM_ACTUAL_SHOP.ToString(), PayrollElement.SAL_COM_PRECENT_REVENUE.ToString() }))
{
Sal_RevenueForShopEntity RevenueForShopItem = TotalData.listRevenueForShop.Where(m => m.ShopID == profileItem.ShopID && m.KPIBonusID == TotalData.listKPIBonus.Where(t => t.IsTotalRevenue == true).FirstOrDefault().ID && m.DateFrom <= CutOffDuration.DateEnd && m.DateTo >= CutOffDuration.DateStart).FirstOrDefault();
if (RevenueForShopItem != null)
{
item = new ElementFormula(PayrollElement.SAL_COM_TAGET_SHOP.ToString(), RevenueForShopItem.Target, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_ACTUAL_SHOP.ToString(), RevenueForShopItem.Actual, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_PRECENT_REVENUE.ToString(), RevenueForShopItem.Actual / RevenueForShopItem.Target, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_COM_TAGET_SHOP.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_ACTUAL_SHOP.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_PRECENT_REVENUE.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
//Lấy tên cửa hàng
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_COM_SHOPNAME.ToString()))
{
item = new ElementFormula(PayrollElement.SAL_COM_SHOPNAME.ToString(), profileItem.ShopName == null ? "" : profileItem.ShopName, 0);
listElementFormula.Add(item);
}
//Lấy taget & actual của nhân viên
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_COM_TAGET_CUSTOMER.ToString(), PayrollElement.SAL_COM_ACTUAL_CUSTOMER.ToString() }))
{
Sal_RevenueForProfileEntity RevenueForProfileItem = new Sal_RevenueForProfileEntity();
RevenueForProfileItem = TotalData.listRevenueForProfile.Where(m => m.ProfileID == profileItem.ID && m.DateFrom <= CutOffDuration.DateEnd && m.DateTo >= CutOffDuration.DateStart).FirstOrDefault();
if (RevenueForProfileItem != null)
{
item = new ElementFormula(PayrollElement.SAL_COM_TAGET_CUSTOMER.ToString(), RevenueForProfileItem.Target, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_ACTUAL_CUSTOMER.ToString(), RevenueForProfileItem.Actual, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_COM_TAGET_CUSTOMER.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_ACTUAL_CUSTOMER.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
//Số tháng làm việc
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_COM_WORKINGMONTH.ToString()))
{
double CountMonth = ((CutOffDuration.MonthYear.Year - profileItem.DateHire.Value.Year) * 12) + CutOffDuration.MonthYear.Month - profileItem.DateHire.Value.Month + (profileItem.DateHire.Value.Day < CutOffDuration.DateEnd.Day ? 1 : 0);
item = new ElementFormula(PayrollElement.SAL_COM_WORKINGMONTH.ToString(), CountMonth, 0);
listElementFormula.Add(item);
}
//tổng số nhân viên của cửa hàng
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_COM_COUNT_SHOPMEMBER.ToString()))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoProfile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
int TotalProfileForShop = repoProfile.FindBy(m => m.ShopID == profileItem.ShopID).Count();
item = new ElementFormula(PayrollElement.SAL_COM_COUNT_SHOPMEMBER.ToString(), TotalProfileForShop, 0);
listElementFormula.Add(item);
}
}
//Chức danh
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_COM_JOBTITLE.ToString()))
{
item = new ElementFormula(PayrollElement.SAL_COM_JOBTITLE.ToString(), profileItem.PositionCode == null ? "" : profileItem.PositionCode, 0);
listElementFormula.Add(item);
}
//Số lượng ca trưởng trong cửa hàng
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_COM_COUNT_SL.ToString(), PayrollElement.SAL_COM_RANK.ToString() }))
{
if (profileItem.ShopID != null)
{
int Count_SL = (int)TotalData.listShop.Single(m => m.ID == profileItem.ShopID).NoShiftLeader;
item = new ElementFormula(PayrollElement.SAL_COM_COUNT_SL.ToString(), Count_SL, 0);
listElementFormula.Add(item);
//cấp bậc của cửa hàng
item = new ElementFormula(PayrollElement.SAL_COM_RANK.ToString(), TotalData.listShop.Single(m => m.ID == profileItem.ShopID).Rank, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_COM_COUNT_SL.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.SAL_COM_RANK.ToString(), 0, 0, "Null");
listElementFormula.Add(item);
}
}
//Tổng doanh thu của tất cả nhân viên trong shop
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_TOTAL_ACTUAL_PROFILE_SHOP.ToString()))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoProfile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
var TotalPRofileInShop = repoProfile.FindBy(m => m.ShopID == profileItem.ShopID).ToList();
var RevenueForProfileInShop = TotalData.listRevenueForProfile.Where(m => TotalPRofileInShop.Any(t => t.ID == m.ProfileID) && m.DateFrom <= CutOffDuration.DateEnd && m.DateTo >= CutOffDuration.DateStart).ToList();
item = new ElementFormula(PayrollElement.SAL_TOTAL_ACTUAL_PROFILE_SHOP.ToString(), RevenueForProfileInShop.Sum(m => m.Actual), 0);
listElementFormula.Add(item);
}
}
#endregion
#region Enum phần tử đánh giá
//Loại đánh giá
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.EVA_PERFORMANCE_TYPE_CODE.ToString(), PayrollElement.EVA_PERFORMANCE_LEVEL_NAME.ToString() }))
{
var PerformentceProfile = TotalData.listEva_Performance.Where(m => m.ProfileID == profileItem.ID && m.PeriodFromDate <= CutOffDuration.DateEnd && m.PeriodToDate >= CutOffDuration.DateStart).FirstOrDefault();
item = new ElementFormula(PayrollElement.EVA_PERFORMANCE_TYPE_CODE.ToString(), PerformentceProfile != null ? PerformentceProfile.PerformanceTypeCode : "", 0);
listElementFormula.Add(item);
//Cấp độ đánh giá
item = new ElementFormula(PayrollElement.EVA_PERFORMANCE_LEVEL_NAME.ToString(), PerformentceProfile != null ? PerformentceProfile.Level1Name : "", 0);
listElementFormula.Add(item);
}
if (CheckIsExistFormula(listElementFormula, formula, CatElementType.Evaluation.ToString().ToUpper() + "_PERFORMANCETYPE_", TotalData.listPerformanceType.Select(m => m.Code).ToArray()))
{
DateTime YearStart = new DateTime(CutOffDuration.MonthYear.Year, 1, 1);
DateTime YearEnd = new DateTime(CutOffDuration.MonthYear.Year, 12, 31);
var PerformentceByProfile = TotalData.listEva_Performance.Where(m => m.ProfileID == profileItem.ID && m.DateEffect <= YearEnd && m.DateEffect >= YearStart).OrderByDescending(m => m.DateEffect).ToList();
if (PerformentceByProfile != null)
{
foreach (var i in TotalData.listPerformanceType)
{
var PerformentceByProfileAndType = PerformentceByProfile.FirstOrDefault(m => m.PerformanceTypeID == i.ID);
if (PerformentceByProfileAndType != null)
{
item = new ElementFormula(CatElementType.Evaluation.ToString().ToUpper() + "_PERFORMANCETYPE_" + i.Code, PerformentceByProfileAndType.Level1Name != null ? PerformentceByProfileAndType.Level1Name : "", 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(CatElementType.Evaluation.ToString().ToUpper() + "_PERFORMANCETYPE_" + i.Code, "", 0, "null");
listElementFormula.Add(item);
}
}
}
else
{
foreach (var i in TotalData.listPerformanceType)
{
item = new ElementFormula(CatElementType.Evaluation.ToString().ToUpper() + "_PERFORMANCETYPE_" + i.Code, "", 0, "null");
listElementFormula.Add(item);
}
}
}
#endregion
#region Enum phần tử CanTeen
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.CAN_SUMAMOUNT_N_1.ToString(), PayrollElement.CAN_AMOUNTEATNOTSTANDAR_N_1.ToString(), PayrollElement.CAN_AMOUNTCARDMORE_N_1.ToString(), PayrollElement.CAN_AMOUNTNOTWORKHASEAT_N_1.ToString(), PayrollElement.CAN_AMOUNTHDTJOB_N_1.ToString(), PayrollElement.CAN_AMOUNTNOTWORKBUTHASHDT_N_1.ToString(), PayrollElement.CAN_AMOUNTSUBTRACTWRONGSTANDARHDT_N_1.ToString() }))
{
DateTime DateStart = CutOffDuration.DateStart.AddMonths(-1);
DateTime DateEnd = CutOffDuration.DateEnd.AddMonths(-1);
var SumryMealRecordByRrofile = TotalData.listSumryMealRecord.Where(m => m.ProfileID == profileItem.ID && (m.DateFrom != null && m.DateTo != null) && m.DateFrom <= DateEnd && m.DateTo >= DateStart).OrderByDescending(m => m.DateFrom).FirstOrDefault();
if (SumryMealRecordByRrofile != null)
{
item = new ElementFormula(PayrollElement.CAN_SUMAMOUNT_N_1.ToString(), SumryMealRecordByRrofile.SumAmount != null ? SumryMealRecordByRrofile.SumAmount : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTEATNOTSTANDAR_N_1.ToString(), SumryMealRecordByRrofile.AmountEatNotStandar != null ? SumryMealRecordByRrofile.AmountEatNotStandar : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTCARDMORE_N_1.ToString(), SumryMealRecordByRrofile.SumAmountCardMore != null ? SumryMealRecordByRrofile.SumAmountCardMore : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKHASEAT_N_1.ToString(), SumryMealRecordByRrofile.AmountNotWorkHasEat != null ? SumryMealRecordByRrofile.AmountNotWorkHasEat : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTHDTJOB_N_1.ToString(), SumryMealRecordByRrofile.AmountHDTJob != null ? SumryMealRecordByRrofile.AmountHDTJob : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKBUTHASHDT_N_1.ToString(), SumryMealRecordByRrofile.AmountNotWorkButHasHDT != null ? SumryMealRecordByRrofile.AmountNotWorkButHasHDT : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTSUBTRACTWRONGSTANDARHDT_N_1.ToString(), SumryMealRecordByRrofile.AmountSubtractWorngStandarHDT != null ? SumryMealRecordByRrofile.AmountSubtractWorngStandarHDT : 0, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.CAN_SUMAMOUNT_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTEATNOTSTANDAR_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTCARDMORE_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKHASEAT_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTHDTJOB_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKBUTHASHDT_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTSUBTRACTWRONGSTANDARHDT_N_1.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
}
}
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.CAN_SUMAMOUNT.ToString(), PayrollElement.CAN_AMOUNTEATNOTSTANDAR.ToString(), PayrollElement.CAN_AMOUNTCARDMORE.ToString(), PayrollElement.CAN_AMOUNTNOTWORKHASEAT.ToString(), PayrollElement.CAN_AMOUNTHDTJOB.ToString(), PayrollElement.CAN_AMOUNTNOTWORKBUTHASHDT.ToString(), PayrollElement.CAN_AMOUNTSUBTRACTWRONGSTANDARHDT.ToString() }))
{
var SumryMealRecordByRrofile = TotalData.listSumryMealRecord.Where(m => m.ProfileID == profileItem.ID && (m.DateFrom != null && m.DateTo != null) && m.DateFrom <= CutOffDuration.DateEnd && m.DateTo >= CutOffDuration.DateStart).OrderByDescending(m => m.DateFrom).FirstOrDefault();
if (SumryMealRecordByRrofile != null)
{
item = new ElementFormula(PayrollElement.CAN_SUMAMOUNT.ToString(), SumryMealRecordByRrofile.SumAmount != null ? SumryMealRecordByRrofile.SumAmount : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTEATNOTSTANDAR.ToString(), SumryMealRecordByRrofile.AmountEatNotStandar != null ? SumryMealRecordByRrofile.AmountEatNotStandar : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTCARDMORE.ToString(), SumryMealRecordByRrofile.SumAmountCardMore != null ? SumryMealRecordByRrofile.SumAmountCardMore : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKHASEAT.ToString(), SumryMealRecordByRrofile.AmountNotWorkHasEat != null ? SumryMealRecordByRrofile.AmountNotWorkHasEat : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTHDTJOB.ToString(), SumryMealRecordByRrofile.AmountHDTJob != null ? SumryMealRecordByRrofile.AmountHDTJob : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKBUTHASHDT.ToString(), SumryMealRecordByRrofile.AmountNotWorkButHasHDT != null ? SumryMealRecordByRrofile.AmountNotWorkButHasHDT : 0, 0);
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTSUBTRACTWRONGSTANDARHDT.ToString(), SumryMealRecordByRrofile.AmountSubtractWorngStandarHDT != null ? SumryMealRecordByRrofile.AmountSubtractWorngStandarHDT : 0, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.CAN_SUMAMOUNT.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTEATNOTSTANDAR.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTCARDMORE.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKHASEAT.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTHDTJOB.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTNOTWORKBUTHASHDT.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
item = new ElementFormula(PayrollElement.CAN_AMOUNTSUBTRACTWRONGSTANDARHDT.ToString(), 0, 0, "Không có dữ liệu trong kỳ tính lương !");
listElementFormula.Add(item);
}
}
#endregion
#endregion
#region Các phần tử động
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.DYN_COUNTDAYOVERTIMEBYTYPE_.ToString(), new string[] { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" }))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//var repoAttendanceTable = new CustomBaseRepository<Att_AttendanceTable>(unitOfWork);
//var repoAttOvertime = new CustomBaseRepository<Att_Overtime>(unitOfWork);
//tách phần tử ra để lấy tham số
string Parameter = string.Empty;
var ttt = ParseFormulaToList(formula.Formula);
List<string> ListFormula = ParseFormulaToList(formula.Formula).Where(m => m.IndexOf('[') != -1 && m.IndexOf(']') != -1 && m.StartsWith("[" + PayrollElement.DYN_COUNTDAYOVERTIMEBYTYPE_.ToString())).ToList();
//Att_AttendanceTable listAttTable = TotalData.listAttendanceTable.Where(m => m.CutOffDurationID == CutOffDuration.ID && m.ProfileID == profileItem.ID && m.IsDelete != true).FirstOrDefault();
List<Att_AttendanceTableItemEntity> listAttTableItem = TotalData.listAttendanceTableItem.Where(m => m.AttendanceTableID == listAttendanceTableProCut.ID).ToList();
//lấy danh sách đăng ký tăng ca
List<Att_OvertimeEntity> listOverTime = TotalData.listOverTime.Where(m => m.ProfileID == profileItem.ID).ToList();
//duyệt qua các phần tử động để lấy tham số
foreach (var i in ListFormula)
{
string[] listParam = i.Split('_');
if (listParam.Count() >= 3)//nếu là 3 phần tử là đúng công thức, ngược lại là sai
{
string OtTypeCode = i.Replace(PayrollElement.DYN_COUNTDAYOVERTIMEBYTYPE_.ToString(), "").Replace("_" + listParam.LastOrDefault(), "").Replace("]", "").Replace("[", "");
double number = 0;
double CountOtDay = 0;
Cat_OvertimeTypeEntity OTType = TotalData.listOvertimeType.Where(m => m.Code == OtTypeCode).FirstOrDefault();
List<Att_OvertimeEntity> listOverTimeByTableItem = new List<Att_OvertimeEntity>();
Att_OvertimeEntity OverTimeItem = new Att_OvertimeEntity();
Cat_Shift ShiftItem = new Cat_Shift();
if (double.TryParse(listParam.LastOrDefault().Replace("]", "").Replace("[", ""), out number) && OTType != null)
{
number = number / 10;
CountOtDay = 0;
//lọc ra các loại OT theo loại
foreach (var tableItem in listAttTableItem)
{
listOverTimeByTableItem = listOverTime.Where(m => m.WorkDate.Date == tableItem.WorkDate.Date).ToList();
if (tableItem.OvertimeTypeID != null && tableItem.OvertimeTypeID == OTType.ID)
{
OverTimeItem = listOverTimeByTableItem.Where(m => m.OvertimeTypeID == (Guid)tableItem.OvertimeTypeID).FirstOrDefault();
if (OverTimeItem != null && OverTimeItem.ShiftID != null)
{
ShiftItem = TotalData.listCat_Shift.Where(m => m.ID == (Guid)OverTimeItem.ShiftID).FirstOrDefault().Copy<Cat_Shift>();
CountOtDay += tableItem.OvertimeHours / ShiftItem.udAvailableHours >= number ? 1 : 0;
}
}
else if (tableItem.ExtraOvertimeTypeID != null && tableItem.ExtraOvertimeTypeID == OTType.ID)
{
OverTimeItem = listOverTimeByTableItem.Where(m => m.OvertimeTypeID == (Guid)tableItem.ExtraOvertimeTypeID).FirstOrDefault();
if (OverTimeItem != null && OverTimeItem.ShiftID != null)
{
ShiftItem = TotalData.listCat_Shift.Where(m => m.ID == (Guid)OverTimeItem.ShiftID).FirstOrDefault().Copy<Cat_Shift>();
CountOtDay += tableItem.ExtraOvertimeHours / ShiftItem.udAvailableHours >= number ? 1 : 0;
}
}
else if (tableItem.ExtraOvertimeType2ID != null && tableItem.ExtraOvertimeType2ID == OTType.ID)
{
OverTimeItem = listOverTimeByTableItem.Where(m => m.OvertimeTypeID == (Guid)tableItem.ExtraOvertimeType2ID).FirstOrDefault();
if (OverTimeItem != null && OverTimeItem.ShiftID != null)
{
ShiftItem = TotalData.listCat_Shift.Where(m => m.ID == (Guid)OverTimeItem.ShiftID).FirstOrDefault().Copy<Cat_Shift>();
CountOtDay += tableItem.ExtraOvertimeHours2 / ShiftItem.udAvailableHours >= number ? 1 : 0;
}
}
else if (tableItem.ExtraOvertimeType3ID != null && tableItem.ExtraOvertimeType3ID == OTType.ID)
{
OverTimeItem = listOverTimeByTableItem.Where(m => m.OvertimeTypeID == (Guid)tableItem.ExtraOvertimeType3ID).FirstOrDefault();
if (OverTimeItem != null && OverTimeItem.ShiftID != null)
{
ShiftItem = TotalData.listCat_Shift.Where(m => m.ID == (Guid)OverTimeItem.ShiftID).FirstOrDefault().Copy<Cat_Shift>();
CountOtDay += tableItem.ExtraOvertimeHours3 / ShiftItem.udAvailableHours >= number ? 1 : 0;
}
}
}
item = new ElementFormula(i.Replace("]", "").Replace("[", ""), CountOtDay, 0);
listElementFormula.Add(item);
}
else//sai công thức , không convert đc số giờ
{
item = new ElementFormula(i.Replace("]", "").Replace("[", ""), 0, 0, "Công thức động sai !");
listElementFormula.Add(item);
}
}
else
{
item = new ElementFormula(i.Replace("]", "").Replace("[", ""), 0, 0, "Công thức động sai !");
listElementFormula.Add(item);
}
}
}
}
#endregion
#region Lấy giá trị cho các phần tử là các loại OT và LeaveDay
#region Lấy OT theo từng loại và lấy tổng số giờ tăng ca đã quy đổi ra hệ số 1
#region OT tháng N
List<Cat_ElementEntity> listElement_OT = new List<Cat_ElementEntity>();
if (CheckIsExistFormula(listElementFormula, formula, "ATT_OVERTIME_", "_HOURS"))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//var repoAttendanceTable = new CustomBaseRepository<Att_AttendanceTable>(unitOfWork);
//double SumOvertime = 0;
//double SumOvertimeInsurance = 0;
//lấy lương cơ bản của nhân viên
List<Sal_BasicSalaryEntity> SalaryProfile = new List<Sal_BasicSalaryEntity>();
SalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
//có thay đổi lương trong tháng
if (SalaryProfile.Count > 0 && SalaryProfile.FirstOrDefault().DateOfEffect > CutOffDuration.DateStart)//có thay đổi lương trong tháng
{
double OtHour = 0;
//ngày bắt đầu mức lương 1 và ngày bắt đầu mức lương 2
DateTime dateStart1 = CutOffDuration.DateStart;
DateTime dateStart2 = SalaryProfile.FirstOrDefault().DateOfEffect;
//lấy dữ liệu công theo cutoff
List<Att_AttendanceTableItemEntity> listAttTableItem = TotalData.listAttendanceTableItem.Where(m => m.ProfileID == profileItem.ID).ToList();
if (listAttTableItem != null && listAttTableItem.Count > 0)
{
listAttTableItem = listAttTableItem.Where(m => m.WorkDate < dateStart2).ToList();
//duyệt wa các loại ot
foreach (var OTType in TotalData.listOvertimeType)
{
OtHour = 0;
//tính số giờ OT của từng loại
foreach (var tableItem in listAttTableItem)
{
if (tableItem.OvertimeTypeID != null && tableItem.OvertimeTypeID == OTType.ID)
{
OtHour += tableItem.OvertimeHours;
}
else if (tableItem.ExtraOvertimeTypeID != null && tableItem.ExtraOvertimeTypeID == OTType.ID)
{
OtHour += tableItem.ExtraOvertimeHours;
}
else if (tableItem.ExtraOvertimeType2ID != null && tableItem.ExtraOvertimeType2ID == OTType.ID)
{
OtHour += tableItem.ExtraOvertimeHours2;
}
else if (tableItem.ExtraOvertimeType3ID != null && tableItem.ExtraOvertimeType3ID == OTType.ID)
{
OtHour += tableItem.ExtraOvertimeHours3;
}
}
item = new ElementFormula("ATT_OVERTIME_" + OTType.Code + "_HOURS", OtHour, 0);
listElementFormula.Add(item);
}
}
else
{
foreach (var OTType in TotalData.listOvertimeType)
{
item = new ElementFormula("ATT_OVERTIME_" + OTType.Code + "_HOURS", 0, 0);
listElementFormula.Add(item);
}
}
}
else//không thay đổi lương trong tháng
{
listElement_OT = TotalData.listElement_All.Where(m => m.ElementCode.StartsWith("ATT_OVERTIME_") && m.ElementCode.EndsWith("_HOURS")).ToList();
foreach (var OT in listElement_OT)
{
var itemOverTime = TotalData.listOvertimeType.Where(m => m.Code == OT.ElementCode.Replace("ATT_OVERTIME_", "").Replace("_HOURS", "")).FirstOrDefault();
double value = 0;
if (itemOverTime != null && listAttendanceTableProCut != null)
{
if (listAttendanceTableProCut.Overtime1Type != null && listAttendanceTableProCut.Overtime1Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime1Hours;
}
if (listAttendanceTableProCut.Overtime2Type != null && listAttendanceTableProCut.Overtime2Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime2Hours;
}
if (listAttendanceTableProCut.Overtime3Type != null && listAttendanceTableProCut.Overtime3Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime3Hours;
}
if (listAttendanceTableProCut.Overtime4Type != null && listAttendanceTableProCut.Overtime4Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime4Hours;
}
if (listAttendanceTableProCut.Overtime5Type != null && listAttendanceTableProCut.Overtime5Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime5Hours;
}
if (listAttendanceTableProCut.Overtime6Type != null && listAttendanceTableProCut.Overtime6Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime6Hours;
}
}
item = new ElementFormula(OT.ElementCode, value, 0);
listElementFormula.Add(item);
//if (itemOverTime != null)
//{
// SumOvertimeInsurance += value * itemOverTime.TaxRate;//Tính số giờ tăng ca có chịu thuế
// SumOvertime += value * itemOverTime.Rate;//tính hệ số và lưu vào biến tổng số giờ tăng ca
//}
}
////Lưu giá trị cho Enum tổng số giớ tăng ca trong tháng
//item = new ElementFormula(PayrollElement.ATT_OVERTIME_HOURS.ToString(), SumOvertime, 0);
//listElementFormula.Add(item);
////Lưu giá trị cho Enum tổng số giớ tăng ca trong tháng có tính thuế
//item = new ElementFormula(PayrollElement.ATT_OVERTIME_PIT_HOURS.ToString(), SumOvertimeInsurance, 0);
//listElementFormula.Add(item);
}
}
}
#endregion
#region Tổng giờ tăng ca trong tháng và tổng giờ tăng ca trong tháng có tính thuế
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_OVERTIME_PIT_HOURS.ToString(), PayrollElement.ATT_OVERTIME_HOURS.ToString() }))
{
double SumOvertime = 0;
double SumOvertimeInsurance = 0;
foreach (var itemOverTime in TotalData.listOvertimeType)
{
double value = 0;
if (itemOverTime != null && listAttendanceTableProCut != null)
{
if (listAttendanceTableProCut.Overtime1Type != null && listAttendanceTableProCut.Overtime1Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime1Hours;
}
if (listAttendanceTableProCut.Overtime2Type != null && listAttendanceTableProCut.Overtime2Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime2Hours;
}
if (listAttendanceTableProCut.Overtime3Type != null && listAttendanceTableProCut.Overtime3Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime3Hours;
}
if (listAttendanceTableProCut.Overtime4Type != null && listAttendanceTableProCut.Overtime4Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime4Hours;
}
if (listAttendanceTableProCut.Overtime5Type != null && listAttendanceTableProCut.Overtime5Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime5Hours;
}
if (listAttendanceTableProCut.Overtime6Type != null && listAttendanceTableProCut.Overtime6Type == itemOverTime.ID)
{
value += listAttendanceTableProCut.Overtime6Hours;
}
}
if (itemOverTime != null)
{
SumOvertimeInsurance += value * itemOverTime.TaxRate;//Tính số giờ tăng ca có chịu thuế
SumOvertime += value * itemOverTime.Rate;//tính hệ số và lưu vào biến tổng số giờ tăng ca
}
}
//Lưu giá trị cho Enum tổng số giớ tăng ca trong tháng
item = new ElementFormula(PayrollElement.ATT_OVERTIME_HOURS.ToString(), SumOvertime, 0);
listElementFormula.Add(item);
//Lưu giá trị cho Enum tổng số giớ tăng ca trong tháng có tính thuế
item = new ElementFormula(PayrollElement.ATT_OVERTIME_PIT_HOURS.ToString(), SumOvertimeInsurance, 0);
listElementFormula.Add(item);
}
#endregion
#region Các loại OT nếu có thay đổi lương trong tháng
if (CheckIsExistFormula(listElementFormula, formula, "ATT_OVERTIME_", "_HOURS_AFTER"))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//var repoAttendanceTable = new CustomBaseRepository<Att_AttendanceTable>(unitOfWork);
//lấy lương cơ bản của nhân viên
List<Sal_BasicSalaryEntity> SalaryProfile = new List<Sal_BasicSalaryEntity>();
SalaryProfile = TotalData.listBasicSalary.Where(m => m.ProfileID == profileItem.ID).OrderByDescending(m => m.DateOfEffect).ToList();
if (SalaryProfile.Count > 0 && SalaryProfile.FirstOrDefault().DateOfEffect > CutOffDuration.DateStart)//có thay đổi lương trong tháng
{
double OtHour = 0;
//ngày bắt đầu mức lương 1 và ngày bắt đầu mức lương 2
DateTime dateStart1 = CutOffDuration.DateStart;
DateTime dateStart2 = SalaryProfile.FirstOrDefault().DateOfEffect;
//lấy dữ liệu công theo cutoff
List<Att_AttendanceTableItemEntity> listAttTableItem = TotalData.listAttendanceTableItem.Where(m => m.ProfileID == profileItem.ID).ToList();
if (listAttTableItem != null && listAttTableItem.Count > 0)
{
listAttTableItem = listAttTableItem.Where(m => m.WorkDate >= dateStart2).ToList();
//duyệt wa các loại ot
foreach (var OTType in TotalData.listOvertimeType)
{
OtHour = 0;
//tính số giờ OT của từng loại
foreach (var tableItem in listAttTableItem)
{
if (tableItem.OvertimeTypeID != null && tableItem.OvertimeTypeID == OTType.ID)
{
OtHour += tableItem.OvertimeHours;
}
else if (tableItem.ExtraOvertimeTypeID != null && tableItem.ExtraOvertimeTypeID == OTType.ID)
{
OtHour += tableItem.ExtraOvertimeHours;
}
else if (tableItem.ExtraOvertimeType2ID != null && tableItem.ExtraOvertimeType2ID == OTType.ID)
{
OtHour += tableItem.ExtraOvertimeHours2;
}
else if (tableItem.ExtraOvertimeType3ID != null && tableItem.ExtraOvertimeType3ID == OTType.ID)
{
OtHour += tableItem.ExtraOvertimeHours3;
}
}
item = new ElementFormula("ATT_OVERTIME_" + OTType.Code + "_HOURS_AFTER", OtHour, 0);
listElementFormula.Add(item);
}
}
else
{
foreach (var OTType in TotalData.listOvertimeType)
{
item = new ElementFormula("ATT_OVERTIME_" + OTType.Code + "_HOURS_AFTER", 0, 0);
listElementFormula.Add(item);
}
}
}
else//không có lương cơ bản hoặc không có thay đổi lương trong tháng
{
foreach (var OTType in TotalData.listOvertimeType)
{
item = new ElementFormula("ATT_OVERTIME_" + OTType.Code + "_HOURS_AFTER", 0, 0);
listElementFormula.Add(item);
}
}
}
}
#endregion
#region OT tháng N-1
if (CheckIsExistFormula(listElementFormula, formula, "ATT_OVERTIME_", "_HOURS_PREV"))
{
listElement_OT = TotalData.listElement_All.Where(m => m.ElementCode.StartsWith("ATT_OVERTIME_") && m.ElementCode.EndsWith("_HOURS_PREV")).ToList();
if (listElement_OT != null && listElement_OT.Count > 0)
{
foreach (var OT in listElement_OT)
{
var itemOverTime = TotalData.listOvertimeType.Where(m => m.Code == OT.ElementCode.Replace("ATT_OVERTIME_", "").Replace("_HOURS_PREV", "")).FirstOrDefault();
double value = 0;
var _tmpAttendanceTable = TotalData.Att_AttendanceTable_Prev.Where(m => m.ProfileID == profileItem.ID).FirstOrDefault();
if (itemOverTime != null && _tmpAttendanceTable != null)
{
if (_tmpAttendanceTable.Overtime1Type != null && _tmpAttendanceTable.Overtime1Type == itemOverTime.ID)
{
value += _tmpAttendanceTable.Overtime1Hours;
}
if (_tmpAttendanceTable.Overtime2Type != null && _tmpAttendanceTable.Overtime2Type == itemOverTime.ID)
{
value += _tmpAttendanceTable.Overtime2Hours;
}
if (_tmpAttendanceTable.Overtime3Type != null && _tmpAttendanceTable.Overtime3Type == itemOverTime.ID)
{
value += _tmpAttendanceTable.Overtime3Hours;
}
if (_tmpAttendanceTable.Overtime4Type != null && _tmpAttendanceTable.Overtime4Type == itemOverTime.ID)
{
value += _tmpAttendanceTable.Overtime4Hours;
}
if (_tmpAttendanceTable.Overtime5Type != null && _tmpAttendanceTable.Overtime5Type == itemOverTime.ID)
{
value += _tmpAttendanceTable.Overtime5Hours;
}
if (_tmpAttendanceTable.Overtime6Type != null && _tmpAttendanceTable.Overtime6Type == itemOverTime.ID)
{
value += _tmpAttendanceTable.Overtime6Hours;
}
}
item = new ElementFormula(OT.ElementCode, value, 0);
listElementFormula.Add(item);
}
}
}
#endregion
#endregion
#region Lấy LeaveDay theo từng loại và lấy tổng nghỉ
double SumLeaveday = 0;
double SumLeavedayIsSalary = 0;
//N-1
double SumLeaveday_Prev = 0;
double SumLeavedayIsSalary_Prev = 0;
List<Cat_ElementEntity> listElement_Leave = new List<Cat_ElementEntity>();
if (CheckIsExistFormula(listElementFormula, formula, "ATT_LEAVE_", "_HOURS") || CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_LEAVE_HOURS.ToString(), PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_HOURS.ToString() }))
{
listElement_Leave = TotalData.listElement_All.Where(m => m.ElementCode.StartsWith("ATT_LEAVE_") && m.ElementCode.EndsWith("_HOURS")).ToList();
foreach (var LD in listElement_Leave)
{
var itemLeaveday = TotalData.listLeavedayType.Where(m => m.Code == LD.ElementCode.Replace("ATT_LEAVE_", "").Replace("_HOURS", "")).FirstOrDefault();
double value = 0;
if (itemLeaveday != null && listAttendanceTableProCut != null)
{
if (listAttendanceTableProCut.LeaveDay1Type != null && listAttendanceTableProCut.LeaveDay1Type == itemLeaveday.ID)
{
value += listAttendanceTableProCut.LeaveDay1Hours;
}
if (listAttendanceTableProCut.LeaveDay2Type != null && listAttendanceTableProCut.LeaveDay2Type == itemLeaveday.ID)
{
value += listAttendanceTableProCut.LeaveDay2Hours;
}
if (listAttendanceTableProCut.LeaveDay3Type != null && listAttendanceTableProCut.LeaveDay3Type == itemLeaveday.ID)
{
value += listAttendanceTableProCut.LeaveDay3Hours;
}
if (listAttendanceTableProCut.LeaveDay4Type != null && listAttendanceTableProCut.LeaveDay4Type == itemLeaveday.ID)
{
value += listAttendanceTableProCut.LeaveDay4Hours;
}
}
item = new ElementFormula(LD.ElementCode, value, 0);
listElementFormula.Add(item);
SumLeaveday += value;//Tổng giờ nghỉ trong tháng
if (itemLeaveday != null)
{
SumLeavedayIsSalary += value * itemLeaveday.PaidRate;//tổng giờ nghỉ có trả lương
}
#region Lấy LeaveDay theo từng lại và lấy tổng ngày nghỉ tháng N - 1
value = 0;
var _tmpAttendanceTable = TotalData.Att_AttendanceTable_Prev.Where(m => m.ProfileID == profileItem.ID).FirstOrDefault();
if (itemLeaveday != null && _tmpAttendanceTable != null)
{
if (_tmpAttendanceTable.LeaveDay1Type != null && _tmpAttendanceTable.LeaveDay1Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay1Hours;
}
if (_tmpAttendanceTable.LeaveDay2Type != null && _tmpAttendanceTable.LeaveDay2Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay2Hours;
}
if (_tmpAttendanceTable.LeaveDay3Type != null && _tmpAttendanceTable.LeaveDay3Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay3Hours;
}
if (_tmpAttendanceTable.LeaveDay4Type != null && _tmpAttendanceTable.LeaveDay4Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay4Hours;
}
}
SumLeaveday_Prev += value;//Tổng giờ nghỉ trong tháng
if (itemLeaveday != null)
{
SumLeavedayIsSalary_Prev += value * itemLeaveday.PaidRate;//tổng giờ nghỉ có trả lương
}
#endregion
}
//tạo phần tử Enum tổng số giờ nghỉ trong tháng
item = new ElementFormula(PayrollElement.ATT_LEAVE_HOURS.ToString(), SumLeaveday, 0);
listElementFormula.Add(item);
//tạo phần tử Enum tổng số giờ nghỉ trong tháng có tính lương
item = new ElementFormula(PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_HOURS.ToString(), SumLeavedayIsSalary, 0);
listElementFormula.Add(item);
}
//Số ngày nghỉ tháng N-1
if (CheckIsExistFormula(listElementFormula, formula, "ATT_LEAVE_", "_DAY_PREV"))
{
listElement_Leave = TotalData.listElement_All.Where(m => m.ElementCode.StartsWith("ATT_LEAVE_") && m.ElementCode.EndsWith("_DAY_PREV")).ToList();
var _tmpAttendanceTable = TotalData.Att_AttendanceTable_Prev.Where(m => m.ProfileID == profileItem.ID).FirstOrDefault();
foreach (var LD in listElement_Leave)
{
var itemLeaveday = TotalData.listLeavedayType.Where(m => m.Code == LD.ElementCode.Replace("ATT_LEAVE_", "").Replace("_DAY_PREV", "")).FirstOrDefault();
double value = 0;
if (itemLeaveday != null && _tmpAttendanceTable != null)
{
if (_tmpAttendanceTable.LeaveDay1Type != null && _tmpAttendanceTable.LeaveDay1Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay1Days != null ? (double)_tmpAttendanceTable.LeaveDay1Days : 0;
}
if (_tmpAttendanceTable.LeaveDay2Type != null && _tmpAttendanceTable.LeaveDay2Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay2Days != null ? (double)_tmpAttendanceTable.LeaveDay2Days : 0;
}
if (_tmpAttendanceTable.LeaveDay3Type != null && _tmpAttendanceTable.LeaveDay3Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay3Days != null ? (double)_tmpAttendanceTable.LeaveDay3Days : 0;
}
if (_tmpAttendanceTable.LeaveDay4Type != null && _tmpAttendanceTable.LeaveDay4Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay4Days != null ? (double)_tmpAttendanceTable.LeaveDay4Days : 0;
}
}
item = new ElementFormula(LD.ElementCode, value, 0);
listElementFormula.Add(item);
}
}
//Tổng số Ngày Nghỉ từng loại trong năm
if (CheckIsExistFormula(listElementFormula, formula, "ATT_LEAVE_", "_DAY_INYEAR"))
{
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
var repoSys_AttendanceTable = new CustomBaseRepository<Att_AttendanceTable>(unitOfWork);
var repoSys_AttendanceTableItem = new CustomBaseRepository<Att_AttendanceTableItem>(unitOfWork);
DateTime from = new DateTime(CutOffDuration.MonthYear.Year - 1, 4, 1);
DateTime to = new DateTime(CutOffDuration.MonthYear.Year, 3, 31);
List<Att_AttendanceTable> listAttendanceTableByProfile = repoSys_AttendanceTable.FindBy(m => m.IsDelete != true && m.ProfileID == profileItem.ID && m.MonthYear != null && m.MonthYear.Value >= from && m.MonthYear.Value <= to).ToList();
listElement_Leave = TotalData.listElement_All.Where(m => m.ElementCode.StartsWith("ATT_LEAVE_") && m.ElementCode.EndsWith("_DAY_INYEAR")).ToList();
foreach (var LD in listElement_Leave)
{
var itemLeaveday = TotalData.listLeavedayType.Where(m => m.Code == LD.ElementCode.Replace("ATT_LEAVE_", "").Replace("_DAY_INYEAR", "")).FirstOrDefault();
double value = 0;
foreach (var _tmpAttendanceTable in listAttendanceTableByProfile)
{
if (itemLeaveday != null && _tmpAttendanceTable != null)
{
if (_tmpAttendanceTable.LeaveDay1Type != null && _tmpAttendanceTable.LeaveDay1Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay1Days != null ? (double)_tmpAttendanceTable.LeaveDay1Days : 0;
}
if (_tmpAttendanceTable.LeaveDay2Type != null && _tmpAttendanceTable.LeaveDay2Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay2Days != null ? (double)_tmpAttendanceTable.LeaveDay2Days : 0;
}
if (_tmpAttendanceTable.LeaveDay3Type != null && _tmpAttendanceTable.LeaveDay3Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay3Days != null ? (double)_tmpAttendanceTable.LeaveDay3Days : 0;
}
if (_tmpAttendanceTable.LeaveDay4Type != null && _tmpAttendanceTable.LeaveDay4Type == itemLeaveday.ID)
{
value += _tmpAttendanceTable.LeaveDay4Days != null ? (double)_tmpAttendanceTable.LeaveDay4Days : 0;
}
}
}
item = new ElementFormula(LD.ElementCode, value, 0);
listElementFormula.Add(item);
}
}
}
#region N-1
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.ATT_LEAVE_HOURS_PREV.ToString(), PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_HOURS_PREV.ToString() }))
{
//Tổng số giờ nghỉ trong tháng N-1
item = new ElementFormula(PayrollElement.ATT_LEAVE_HOURS_PREV.ToString(), SumLeaveday_Prev, 0);
listElementFormula.Add(item);
//Tổng số giờ nghỉ trong tháng có tính lương N-1
item = new ElementFormula(PayrollElement.ATT_TOTAL_PAID_LEAVEDAY_HOURS_PREV.ToString(), SumLeavedayIsSalary_Prev, 0);
listElementFormula.Add(item);
}
#endregion
#endregion
#endregion
#region Honda - tổng số ngày làm việc theo từng ca của nhân viên trong tháng
if (CheckIsExistFormula(listElementFormula, formula, "ATT_SHIFT_", "_HOURS"))
{
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//var repoAtt_AttendanceTableItem = new CustomBaseRepository<Att_AttendanceTableItem>(unitOfWork);
List<Att_AttendanceTableItemEntity> listAttTableItemByShift = new List<Att_AttendanceTableItemEntity>();
List<Att_AttendanceTableItemEntity> listAttendanceTableItemByAtt = TotalData.listAttendanceTableItem.Where(m => m.AttendanceTableID == listAttendanceTableProCut.ID).ToList();
for (int j = 0; j < TotalData.listCat_Shift.Count; j++)
{
listAttTableItemByShift = listAttendanceTableItemByAtt.Where(m => m.ShiftID != null && m.ShiftID == TotalData.listCat_Shift[j].ID).ToList();
item = new ElementFormula("ATT_SHIFT_" + TotalData.listCat_Shift[j].Code + "_HOURS", listAttTableItemByShift.Sum(m => m.AvailableHours), 0);
listElementFormula.Add(item);
}
}
}
if (CheckIsExistFormula(listElementFormula, formula, "ATT_SHIFT_", "_DAY"))
{
using (var context = new VnrHrmDataContext())
{
string status = string.Empty;
var unitOfWork = (IUnitOfWork)new UnitOfWork(context);
//var repoAtt_AttendanceTableItem = new CustomBaseRepository<Att_AttendanceTableItem>(unitOfWork);
List<Att_AttendanceTableItemEntity> listAttTableItemByShift = new List<Att_AttendanceTableItemEntity>();
List<Att_AttendanceTableItemEntity> listAttendanceTableItemByAtt = TotalData.listAttendanceTableItem.Where(m => m.AttendanceTableID == listAttendanceTableProCut.ID).ToList();
List<Att_AttendanceTableItemEntity> listAttendanceTableItemByAtt_Prev = new List<Att_AttendanceTableItemEntity>();
if (TotalData.Att_AttendanceTable_Prev.Count() >= 0)
{
Att_AttendanceTableEntity _tmp = TotalData.Att_AttendanceTable_Prev.Where(t => t.ProfileID == profileItem.ID).FirstOrDefault();
Guid _tmpID = Guid.Empty;
if (_tmp != null)
{
_tmpID = _tmp.ID;
}
listAttendanceTableItemByAtt_Prev = TotalData.listAttendanceTableItem.Where(m => m.AttendanceTableID == _tmpID).ToList();
}
for (int j = 0; j < TotalData.listCat_Shift.Count; j++)
{
listAttTableItemByShift = listAttendanceTableItemByAtt.Where(m => m.ShiftID != null && m.ShiftID == TotalData.listCat_Shift[j].ID).ToList();
if (listAttTableItemByShift != null && listAttTableItemByShift.Count > 0)
{
item = new ElementFormula("ATT_SHIFT" + "_" + TotalData.listCat_Shift[j].Code + "_" + "DAY", listAttTableItemByShift.Where(d => d.AvailableHours > 0).Sum(d => (d.WorkPaidHours + d.LateEarlyMinutes / 60.0) / d.AvailableHours), 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula("ATT_SHIFT" + "_" + TotalData.listCat_Shift[j].Code + "_" + "DAY", 0, 0);
listElementFormula.Add(item);
}
//tháng N-1
listAttTableItemByShift = listAttendanceTableItemByAtt_Prev.Where(m => m.ShiftID != null && m.ShiftID == TotalData.listCat_Shift[j].ID).ToList();
if (listAttTableItemByShift != null && listAttTableItemByShift.Count > 0)
{
item = new ElementFormula("ATT_SHIFT" + "_" + TotalData.listCat_Shift[j].Code + "_" + "DAY_PREV", listAttTableItemByShift.Where(d => d.AvailableHours > 0).Sum(d => (d.WorkPaidHours + d.LateEarlyMinutes / 60.0) / d.AvailableHours), 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula("ATT_SHIFT" + "_" + TotalData.listCat_Shift[j].Code + "_" + "DAY_PREV", 0, 0);
listElementFormula.Add(item);
}
}
}
}
#endregion
#region Lấy giá trị cho các loại phần tử là Hoa Hồng
if (CheckIsExistFormula(listElementFormula, formula, CatElementType.Comission.ToString().ToUpper(), ""))
{
//lấy doanh thu của shop trong tháng
List<Sal_RevenueRecordEntity> revenueShopInMonth = new List<Sal_RevenueRecordEntity>();
if (profileItem.ShopID != null)
{
revenueShopInMonth = TotalData.listRevenueRecord.Where(m => m.ShopID == profileItem.ShopID).ToList();
}
if (TotalData.listKPIBonus != null && TotalData.listKPIBonus.Count > 0)
{
foreach (var j in TotalData.listKPIBonus)
{
if (revenueShopInMonth.Any(m => m.KPIBonusID == j.ID))
{
listElementFormula.Add(new ElementFormula(CatElementType.Comission.ToString().ToUpper() + "_" + j.Code, revenueShopInMonth.Where(m => m.KPIBonusID == j.ID).FirstOrDefault().Amount, 0));
}
else
{
listElementFormula.Add(new ElementFormula(CatElementType.Comission.ToString().ToUpper() + "_" + j.Code, 0, 0));
}
}
}
}
#region Phần tử lương hoa hồng đã tính được, trong bảng Sal_PaycCommission
if (CheckIsExistFormula(listElementFormula, formula, "ELEMENT" + CatElementType.Comission.ToString().ToUpper() + "_", ""))
{
List<Cat_ElementEntity> listElementByCommission = TotalData.listElement_All.Where(m => m.GradePayrollID == null && m.MethodPayroll == MethodPayroll.E_COMMISSION_PAYMENT.ToString()).ToList();
if (TotalData.listPayCommissionItem != null)
{
//duyệt wa tất cả các phần tử
foreach (var element in listElementByCommission)
{
string elementCode = element.ElementCode.Replace("ELEMENT" + CatElementType.Comission.ToString().ToUpper() + "_", "");
Sal_PayCommissionItemEntity PayCommissionItem = TotalData.listPayCommissionItem.Where(m => m.ProfileID != null && m.Code.ReplaceSpace() == elementCode.ReplaceSpace()).FirstOrDefault();
if (PayCommissionItem != null)
{
item = new ElementFormula(element.ElementCode, PayCommissionItem.Value, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(element.ElementCode, 0, 0);
listElementFormula.Add(item);
}
}
}
else
{
foreach (var element in listElementByCommission)
{
item = new ElementFormula(element.ElementCode, 0, 0);
listElementFormula.Add(item);
}
}
}
#endregion
#region Lấy dữ liệu các phần tử là tổng số lượng chức vụ (Position) trong shop
if (CheckIsExistFormula(listElementFormula, formula, CatElementType.Comission.ToString().ToUpper() + "_COUNTPOSITION_", ""))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoProfile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
if (TotalData.listPosition != null && TotalData.listPosition.Count > 0)
{
var lstProfile = repoProfile.FindBy(m => m.ShopID == profileItem.ShopID).ToList();
foreach (var j in TotalData.listPosition)
{
listElementFormula.Add(new ElementFormula(CatElementType.Comission.ToString().ToUpper() + "_COUNTPOSITION_" + j.Code, lstProfile.Where(m => m.PositionID == j.ID).Count(), 0));
}
}
}
}
#endregion
#region Lấy giá trị cho 2 enum là dòng sản phẩm và sản phẩm
if (CheckIsExistFormula(listElementFormula, formula, new string[] { PayrollElement.SAL_COM_PERCENT_SHOP_LINEITEM.ToString(), PayrollElement.SAL_COM_PERCENT_SHOP_ITEM.ToString() }))
{
//lấy doanh thu của shop trong tháng
List<Sal_RevenueRecordEntity> revenueShopInMonth = new List<Sal_RevenueRecordEntity>();
if (profileItem.ShopID != null)
{
revenueShopInMonth = TotalData.listRevenueRecord.Where(m => m.ShopID == profileItem.ShopID).ToList();
}
//SAL_COM_PERCENT_SHOP_5
if (revenueShopInMonth.Any(m => m.Type == EnumDropDown.SalesType.E_LINEITEM_MAJOR.ToString()))
{
listElementFormula.Add(new ElementFormula(PayrollElement.SAL_COM_PERCENT_SHOP_LINEITEM.ToString(), revenueShopInMonth.Where(m => m.Type == EnumDropDown.SalesType.E_LINEITEM_MAJOR.ToString()).FirstOrDefault().Amount, 0));
}
else
{
listElementFormula.Add(new ElementFormula(PayrollElement.SAL_COM_PERCENT_SHOP_LINEITEM.ToString(), 0, 0));
}
//SAL_COM_PERCENT_SHOP_6
if (revenueShopInMonth.Any(m => m.Type == EnumDropDown.SalesType.E_ITEM_MAJOR.ToString()))
{
listElementFormula.Add(new ElementFormula(PayrollElement.SAL_COM_PERCENT_SHOP_ITEM.ToString(), revenueShopInMonth.Where(m => m.Type == EnumDropDown.SalesType.E_ITEM_MAJOR.ToString()).FirstOrDefault().Amount, 0));
}
else
{
listElementFormula.Add(new ElementFormula(PayrollElement.SAL_COM_PERCENT_SHOP_ITEM.ToString(), 0, 0));
}
}
#endregion
#region Tính giá trị cho phần tử khấu trừ khi có nhân viên ko đủ thâm niên trong shop
if (CheckIsExistFormula(listElementFormula, formula, PayrollElement.SAL_COM_BONUS_SCV.ToString()))
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoProfile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
if (profileItem.ShopID != null)
{
//tính tiền khấu trừ khi khong đủ thâm niên
double Money_Deduction = 0;
try
{
//Hiện tại đang lấy trong webconfig, sau này sẻ lấy trong bảng setting
Money_Deduction = (double)GetObjectValue(TotalData.listElement_All, listElementFormula, TotalData.listElement_All.Where(m => m.ElementCode == ConstantPathWeb.Hrm_Sal_ElementName_Comission).FirstOrDefault().Formula);
}
catch { }
if (Money_Deduction != 0)//nhân viên này không đủ thâm niên
{
if (listTmpDeduction.Any(m => m.Key == profileItem.ShopID))//đã có nhân viên ko đủ thâm niên trong shop trước đó
{
double _tmp = listTmpDeduction.Single(m => m.Key == profileItem.ShopID).Value.Value;
int countValue = listTmpDeduction.Single(m => m.Key == profileItem.ShopID).Value.Count;
listTmpDeduction.Remove((Guid)profileItem.ShopID);//xóa phần tử trước đó
listTmpDeduction.Add((Guid)profileItem.ShopID, new ValueCount(Money_Deduction + _tmp, countValue++));//thêm lại phần tử đó và cập nhật lại value
}
else//là nhân viên ko đủ thâm niên đầu tiên trong shop
{
listTmpDeduction.Add((Guid)profileItem.ShopID, new ValueCount(Money_Deduction, 1));//thêm lại phần tử đó và cập nhật lại value
}
item = new ElementFormula(PayrollElement.SAL_COM_BONUS_SCV.ToString(), 0, 0);
listElementFormula.Add(item);
}
else//nhân viên này đủ thâm niên, kiểm tra xem shop của nhân viên này có nhân viên nào ko đủ thâm niên hay không
{
if (listTmpDeduction.Any(m => m.Key == profileItem.ShopID))//đã có nhân viên ko đủ thâm niên trong shop trước đó
{
int CountProfile = repoProfile.FindBy(m => m.ShopID == profileItem.ShopID).Count() - listTmpDeduction.Single(m => m.Key == profileItem.ShopID).Value.Count;
item = new ElementFormula(PayrollElement.SAL_COM_BONUS_SCV.ToString(), listTmpDeduction.Single(m => m.Key == profileItem.ShopID).Value.Value / CountProfile, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(PayrollElement.SAL_COM_BONUS_SCV.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
}
else
{
item = new ElementFormula(PayrollElement.SAL_COM_BONUS_SCV.ToString(), 0, 0);
listElementFormula.Add(item);
}
}
}
#endregion
#endregion
#region lấy các phần tử Đánh Giá
if (CheckIsExistFormula(listElementFormula, formula, CatElementType.Evaluation.ToString().ToUpper(), ""))
{
IList<string> List_EvaBonusType = Enum.GetValues(typeof(EvaBonusType))
.Cast<EvaBonusType>()
.Select(x => x.ToString())
.ToList();
if (TotalData.listSalesType != null && TotalData.listSalesType.Count > 0)
{
foreach (var j in TotalData.listSalesType)
{
foreach (var t in List_EvaBonusType)
{
try
{
Eva_BonusSalaryEntity BonusSalaryITem = TotalData.listEva_BonusSalary.Where(m => m.ProfileID == profileItem.ID
&& m.SalesTypeID == j.ID
&& m.Type == t).FirstOrDefault();
if (BonusSalaryITem != null && BonusSalaryITem.Bonus != null)
{
item = new ElementFormula(CatElementType.Evaluation.ToString().ToUpper() + "_" + j.Code + "_" + t, BonusSalaryITem.Bonus, 0);
listElementFormula.Add(item);
}
else
{
item = new ElementFormula(CatElementType.Evaluation.ToString().ToUpper() + "_" + j.Code + "_" + t, 0, 0);
listElementFormula.Add(item);
}
}
catch
{
item = new ElementFormula(CatElementType.Evaluation.ToString().ToUpper() + "_" + j.Code + "_" + t, 0, 0);
listElementFormula.Add(item);
}
}
}
}
}
#endregion
#region Vietject
#region Lấy các phần tử đơn giá theo vai trò (Vietject)
if (CheckIsExistFormula(listElementFormula, formula, CatElementType.FLIGHT.ToString() + "_", "_HOURS") ||
CheckIsExistFormula(listElementFormula, formula, CatElementType.FLIGHT.ToString() + "_", "_ROUTES") ||
CheckIsExistFormula(listElementFormula, formula, CatElementType.FLIGHT.ToString() + "_", "_AMOUNT"))
{
List<Att_TimeSheetEntity> Att_TimeSheetItem = TotalData.listAtt_TimeSheet.Where(m => m.ProfileID == profileItem.ID && m.Date <= CutOffDuration.DateEnd && m.Date >= CutOffDuration.DateStart).OrderByDescending(m => m.Date).ToList();
List<Cat_UnitPriceEntity> Cat_UnitPrice = TotalData.listCat_UnitPrice.Where(m => m.Date <= CutOffDuration.DateEnd).OrderByDescending(m => m.Date).ToList();
if (TotalData.listCat_Role != null && TotalData.listCat_Role.Count > 0 && TotalData.listCat_JobType != null && TotalData.listCat_JobType.Count > 0)
{
foreach (var Role in TotalData.listCat_Role)
{
foreach (var JobType in TotalData.listCat_JobType)
{
var Att_TimeSheetItemByItem = Att_TimeSheetItem.Where(m => m.RoleID == Role.ID && m.JobTypeID == JobType.ID).OrderByDescending(m => m.Date).ToList();
var Cat_UnitPriceByItem = Cat_UnitPrice.Where(m => m.RoleID == Role.ID && m.JobTypeID == JobType.ID).OrderByDescending(m => m.Date).FirstOrDefault();
//số giờ bay
item = new ElementFormula(CatElementType.FLIGHT.ToString() + "_" + Role.Code.ReplaceSpace() + "_" + JobType.Code.ReplaceSpace() + "_HOURS", Att_TimeSheetItemByItem.Sum(m => m.NoHour), 0);
listElementFormula.Add(item);
//số chặn bay
item = new ElementFormula(CatElementType.FLIGHT.ToString() + "_" + Role.Code.ReplaceSpace() + "_" + JobType.Code.ReplaceSpace() + "_ROUTES", Att_TimeSheetItemByItem.Sum(m => m.Sector), 0);
listElementFormula.Add(item);
//số tiền
double Amount = Cat_UnitPriceByItem != null && Cat_UnitPriceByItem.Amount != null ? (double)Cat_UnitPriceByItem.Amount : 0;
item = new ElementFormula(CatElementType.FLIGHT.ToString() + "_" + Role.Code.ReplaceSpace() + "_" + JobType.Code.ReplaceSpace() + "_AMOUNT", Amount, 0);
listElementFormula.Add(item);
}
}
}
}
#endregion
#endregion
return listElementFormula.Distinct().ToList();
}
public ActionResult SaveContractAndSaslary(DateTime? dateStart, DateTime? dateEnd, string orgStructureID, string contractTypeID, string RankDetailForNextContract, List<Guid> selectedIds, string statusContract, bool IsEvaluation)
{
var hrService = new Hre_ProfileServices();
string message = string.Empty;
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var lstObjProfile = new List<object>();
lstObjProfile.AddRange(new object[16]);
lstObjProfile[14] = 1;
lstObjProfile[15] = int.MaxValue - 1;
var lstProfile = actionService.GetData<Hre_ProfileEntity>(lstObjProfile, ConstantSql.hrm_hr_sp_get_Profile, ref status).ToList();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjSalaryRank = new List<object>();
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(1);
lstObjSalaryRank.Add(int.MaxValue - 1);
var lstSalaryRank = actionService.GetData<Cat_SalaryRankEntity>(lstObjSalaryRank, ConstantSql.hrm_cat_sp_get_SalaryRank, ref status).ToList();
var contractServices = new Hre_ContractServices();
var lisobjContract = new List<object>();
string strIDs = string.Empty;
foreach (var item in selectedIds)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
strIDs = strIDs.Substring(0, strIDs.Length - 1);
lisobjContract.Add(strIDs);
var lstContractByProfileID = actionService.GetData<Hre_ContractEntity>(lisobjContract, ConstantSql.hrm_hr_sp_get_ContractsByListId, ref status).ToList();
var workhistoryService = new Hre_WorkHistoryServices();
var lstObjWorkhistory = new List<object>();
lstObjWorkhistory.AddRange(new object[17]);
lstObjWorkhistory[15] = 1;
lstObjWorkhistory[16] = int.MaxValue - 1;
var lstWorkhistory = actionService.GetData<Hre_WorkHistoryEntity>(lstObjWorkhistory, ConstantSql.hrm_hr_sp_get_WorkHistory, ref status).ToList();
var basicSalaryService = new Sal_BasicSalaryServices();
var attGradeService = new Att_GradeServices();
var lstObjAttGrade = new List<object>();
lstObjAttGrade.AddRange(new object[6]);
lstObjAttGrade[4] = 1;
lstObjAttGrade[5] = int.MaxValue - 1;
var lstAttGrade = actionService.GetData<Att_GradeEntity>(lstObjAttGrade, ConstantSql.hrm_att_sp_get_Att_Grade, ref status).ToList();
var gradeService = new Sal_GradeServices();
var lstObjSalGrade = new List<object>();
lstObjSalGrade.AddRange(new object[7]);
lstObjSalGrade[5] = 1;
lstObjSalGrade[6] = int.MaxValue - 1;
var lstSalGrade = actionService.GetData<Sal_GradeEntity>(lstObjSalGrade, ConstantSql.hrm_sal_sp_get_Sal_Grade, ref status).ToList();
var gradePayrollService = new Cat_GradePayrollServices();
var lstObjGradePayroll = new List<object>();
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(1);
lstObjGradePayroll.Add(int.MaxValue - 1);
var lstGradePayroll = actionService.GetData<Cat_GradePayrollEntity>(lstObjGradePayroll, ConstantSql.hrm_cat_sp_get_GradePayroll, ref status).ToList();
var gradeAttService = new Cat_GradeAttendanceServices();
var lstObjGradeAtt = new List<object>();
lstObjGradeAtt.AddRange(new object[10]);
lstObjGradeAtt[8] = 1;
lstObjGradeAtt[9] = int.MaxValue - 1;
var lstGradeAtt = actionService.GetData<Cat_GradeAttendanceEntity>(lstObjGradeAtt, ConstantSql.hrm_cat_sp_get_Cat_GradeAttendance, ref status).ToList();
var currencyServices = new Cat_CurrencyServices();
var lstObjCurrency = new List<object>();
lstObjCurrency.Add(null);
lstObjCurrency.Add(null);
lstObjCurrency.Add(1);
lstObjCurrency.Add(int.MaxValue - 1);
var lstCurrency = actionService.GetData<Cat_CurrencyEntity>(lstObjCurrency, ConstantSql.hrm_cat_sp_get_Currency, ref status).ToList();
var lstCurrencyNew = lstCurrency.Where(s => s.CurrencyName == "VND").FirstOrDefault();
var contractTypeService = new Cat_ContractTypeServices();
var lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(int.MaxValue - 1);
var lstContractType = actionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
var insuranceConfigServices = new Cat_InsuranceConfigServices();
var objInsuranceConfig = new List<object>();
objInsuranceConfig.Add(1);
objInsuranceConfig.Add(int.MaxValue - 1);
var lstInsuranceConfig = actionService.GetData<Cat_InsuranceConfigEntity>(objInsuranceConfig, ConstantSql.hrm_cat_sp_get_InsuranceConfig, ref status).ToList();
var insuranceServices = new Sal_InsuranceSalaryServices();
var objInsurance = new List<object>();
objInsurance.AddRange(new object[9]);
objInsurance[7] = 1;
objInsurance[8] = int.MaxValue - 1;
var lstInsurance = actionService.GetData<Sal_InsuranceSalaryEntity>(objInsurance, ConstantSql.hrm_sal_sp_get_InsuranceSalary, ref status).ToList();
foreach (var item in lstContractByProfileID)
{
var contractTypeEntity = new Cat_ContractTypeEntity();
var objContract = new List<object>();
objContract.Add(item.ProfileID);
var lstContractIdByProfileID = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var listIdContract = string.Empty;
if (lstContractIdByProfileID != null)
{
listIdContract = string.Join(",", lstContractIdByProfileID.Select(d => d.ContractTypeID));
}
var profile = lstProfile.Where(s => s.ID == item.ProfileID).FirstOrDefault();
if (item.NextContractTypeID != null)
{
contractTypeEntity = lstContractType.Where(s => item.NextContractTypeID.Value == s.ID).FirstOrDefault();
}
else
{
message = ConstantMessages.WarningContractHaveNotNextContract.ToString().TranslateString();
return Json(message, JsonRequestBehavior.AllowGet);
// contractTypeEntity = lstContractType.Where(s => Guid.Parse(Common.DotNetToOracle(item.ContractNextID.ToString())) == s.ID).FirstOrDefault();
}
var workingHistoryEntity = lstWorkhistory.Where(s => s.ProfileID == item.ProfileID).FirstOrDefault();
var objSalGrade = new List<object>();
objSalGrade.Add(item.ProfileID);
objSalGrade.Add(null);
objSalGrade.Add(1);
objSalGrade.Add(int.MaxValue - 1);
var salGradeByProfileIDEntity = actionService.GetData<Sal_GradeEntity>(objSalGrade, ConstantSql.hrm_sal_sp_get_GradeAndAllownaceByProId, ref status).FirstOrDefault();
var objAttGrade = new List<object>();
objAttGrade.Add(item.ProfileID);
objAttGrade.Add(null);
objAttGrade.Add(1);
objAttGrade.Add(int.MaxValue - 1);
var attGradeByProfileIDEntity = actionService.GetData<Att_GradeEntity>(objAttGrade, ConstantSql.hrm_att_sp_get_GradeAttendanceByProIdCutID, ref status).FirstOrDefault();
if (contractTypeEntity == null)
{
continue;
}
if (item.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
if (item.ContractEvaType == EnumDropDown.ContractEvaType.E_EXPIRED_APPRENTICE.ToString())
{
//chưa tìm dc cách xử lý nên hard code
var lstSalaryRankNew = new Cat_SalaryRankEntity();
// var lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
if (item.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankRateID != null && s.ID == item.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
if (item.TypeOfPass == EnumDropDown.TypeOfPass.E_SIGNED_NEXTCONTRACT.ToString())
{
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = item.DateEnd.Value.AddDays(1),
DateSigned = item.DateEnd.Value.AddDays(1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = item.DateEnd.Value.AddDays(1),
DateSigned = item.DateEnd.Value.AddDays(1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
// DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? item.RankRateID : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
}
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = item.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = item.DateEnd.Value.AddDays(1),
CurrencyID = lstCurrencyNew.ID,
Note = item.Remark
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = item.DateEnd.Value.AddDays(1)
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = item.DateEnd.Value.AddDays(1)
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstAttGradeByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = item.DateEnd.Value.AddDays(1)
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
// return Json(message, JsonRequestBehavior.AllowGet);
}
if (item.ContractEvaType == EnumDropDown.ContractEvaType.E_ANNUAL_EVALUATION.ToString() && item.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
var lstSalaryRankNew = new Cat_SalaryRankEntity();
// var lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
if (item.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankDetailForNextContract != null && s.ID == item.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => item.RankRateID != null && s.ID == item.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = item.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = item.ProfileID,
ProfileName = item.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = item.JobTitleID,
PositionID = item.PositionID,
// DateEnd = null,
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractEntity = SetNewDateEndContract(contractEntity);
}
if (item.DateEndNextContract != null)
{
contractEntity.DateEnd = item.DateEndNextContract.Value;
}
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return Json(contractEntity, JsonRequestBehavior.AllowGet);
}
message = contractServices.Add(contractEntity);
}
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = item.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = new DateTime(DateTime.Now.Year, 6, 1),
CurrencyID = lstCurrencyNew.ID,
Note = item.Remark
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
message = hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = new DateTime(DateTime.Now.Year, 6, 1)
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = item.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = new DateTime(DateTime.Now.Year, 6, 1)
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => item.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = item.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == item.ProfileID && s.DateEffect == item.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = item.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = item.DateEnd.Value.AddDays(1),
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
}
}
}
return Json(message, JsonRequestBehavior.AllowGet);
// return null;
}
public Hre_AppendixContractModel Post([Bind]Hre_AppendixContractModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_AppendixContractModel>(model, "Hre_AppendixContract", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
#endregion
if (model.AppendixCreateBasicSalary == true)
{
Sal_BasicSalaryServices salaryservices = new Sal_BasicSalaryServices();
Sal_BasicSalaryEntity basicSalaryBycontract = new Sal_BasicSalaryEntity();
basicSalaryBycontract.ProfileID = model.ProfileID.Value;
basicSalaryBycontract.GrossAmount = model.Salary != null ? model.Salary.ToString() : "0";
basicSalaryBycontract.CurrencyID = model.CurenncyID != null ? model.CurenncyID.Value : Guid.Empty;
basicSalaryBycontract.PersonalRate = model.PersonalRate;
if (model.DateofEffect != null)
{
basicSalaryBycontract.DateOfEffect = model.DateofEffect.Value;
}
basicSalaryBycontract.InsuranceAmount = model.InsuranceAmount != null ? model.InsuranceAmount.Value : 0;
basicSalaryBycontract.CurrencyID1 = model.CurenncyID1;
basicSalaryBycontract.ClassRateID = model.ClassRateID;
basicSalaryBycontract.RankRateID = model.RankRateID;
basicSalaryBycontract.AllowanceType1ID = model.AllowanceID1;
basicSalaryBycontract.AllowanceAmount1 = model.Allowance1;
basicSalaryBycontract.CurrencyID2 = model.CurenncyID2;
basicSalaryBycontract.AllowanceType2ID = model.AllowanceID2;
basicSalaryBycontract.AllowanceAmount2 = model.Allowance2;
basicSalaryBycontract.CurrencyID3 = model.CurenncyID3;
basicSalaryBycontract.AllowanceType3ID = model.AllowanceID3;
basicSalaryBycontract.AllowanceAmount3 = model.Allowance3;
basicSalaryBycontract.CurrencyID4 = model.CurenncyIDSalary;
salaryservices.Add(basicSalaryBycontract);
}
var status = string.Empty;
var contractServices = new Hre_ContractServices();
var contractEntity = contractServices.GetData<Hre_ContractEntity>(model.ProfileID, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, UserLogin, ref status).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (contractEntity != null)
{
model.ContractID = contractEntity.ID;
}
else {
model.ActionStatus = ConstantMessages.WarningProfileHaveNotContract.ToString().TranslateString();
return model;
}
ActionService service = new ActionService(UserLogin);
return service.UpdateOrCreate<Hre_AppendixContractEntity, Hre_AppendixContractModel>(model, model.UserID);
}
public ActionResult SaveProfileIDs([Bind]Hre_ContractModel model)
{
#region Validate
string message_Error = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "Hre_Contract", ref message_Error);
if (!checkValidate)
{
model.ActionStatus = message_Error;
return Json(message_Error, JsonRequestBehavior.AllowGet);
}
if (model.ContractEvaType == "E_ANNUAL_EVALUATION")
{
checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "EvaContractinfo", "Hre_Contract", ref message_Error);
if (!checkValidate)
{
model.ActionStatus = message_Error;
return Json(message_Error, JsonRequestBehavior.AllowGet);
}
}
#endregion
string status = string.Empty;
Guid convertProfileID = Guid.Empty;
string message = string.Empty;
List<Guid> lstProfileID = new List<Guid>();
var insuranceServices = new Sal_InsuranceSalaryServices();
var ContractServices = new Hre_ContractServices();
var hrService = new Hre_ProfileServices();
var actionService = new ActionService(UserLogin);
if (model.ID == Guid.Empty)
{
model.DateExtend = model.DateEnd;
}
if (model.ProfileIDs != null && model.ProfileIDs.IndexOf(',') > 1)
{
var lstID = model.ProfileIDs.Split(',');
for (int i = 0; i < lstID.Length; i++)
{
convertProfileID = Common.ConvertToGuid(lstID[i]);
lstProfileID.Add(convertProfileID);
}
}
else
{
convertProfileID = Common.ConvertToGuid(model.ProfileIDs);
lstProfileID.Add(convertProfileID);
}
var lstProfile = new List<Hre_ProfileEntity>();
if (model.ProfileIDs != null)
{
lstProfile = actionService.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(model.ProfileIDs), ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status).ToList();
}
if (!string.IsNullOrEmpty(model.OrgStructureIDs))
{
List<Guid> listGuid = new List<Guid>();
if (model.ProfileIDs != null)
{
var listStr = model.ProfileIDs.Split(',');
if (listStr[0] != "")
{
foreach (var item in listStr)
{
listGuid.Add(Guid.Parse(item));
}
}
}
string strIDs = string.Empty;
List<object> listObj = new List<object>();
listObj.Add(model.OrgStructureIDs);
listObj.Add(string.Empty);
listObj.Add(string.Empty);
var lstProfileids = actionService.GetData<Hre_ProfileIdEntity>(listObj, ConstantSql.hrm_hr_sp_get_ProfileIdsByOrgStructure, ref status).Select(s => s.ID).ToList();
if (listGuid != null)
{
lstProfileids = lstProfileids.Where(s => !listGuid.Contains(s)).ToList();
foreach (var item in lstProfileids)
{
strIDs += Common.DotNetToOracle(item.ToString()) + ",";
}
if (strIDs.IndexOf(",") > 0)
strIDs = strIDs.Substring(0, strIDs.Length - 1);
var lstProfileadd = actionService.GetData<Hre_ProfileEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status);
lstProfile.AddRange(lstProfileadd);
}
if (lstProfileids.Count == 0 && model.ProfileID == Guid.Empty)
{
model.ActionStatus = ConstantDisplay.HRM_Common_NotEmployee.TranslateString();
return Json(model.ActionStatus, JsonRequestBehavior.AllowGet);
lstProfile = lstProfile.Where(s => lstProfileids.Contains(s.ID)).ToList();
}
}
var contractTypeService = new Cat_ContractTypeServices();
var lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(int.MaxValue - 1);
var lstContractType = actionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
var insuranceConfigServices = new Cat_InsuranceConfigServices();
var objInsuranceConfig = new List<object>();
objInsuranceConfig.Add(1);
objInsuranceConfig.Add(int.MaxValue - 1);
var lstInsuranceConfig = actionService.GetData<Cat_InsuranceConfigEntity>(objInsuranceConfig, ConstantSql.hrm_cat_sp_get_InsuranceConfig, ref status).ToList();
foreach (var profile in lstProfile)
{
model.ProfileID = profile.ID;
var objContract = new List<object>();
objContract.Add(model.ProfileID);
var lstContractByProfileID = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var contractTypeEntity = lstContractType.Where(s => s.ID == model.ContractTypeID).FirstOrDefault();
#region Xử Lý Lương BHXH
if (contractTypeEntity != null && contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = model.ProfileID,
InsuranceAmount = model.InsuranceAmount,
DateEffect = model.DateStart,
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = model.CurenncyID1
};
message = insuranceServices.Add(insuranceEntity);
}
if (contractTypeEntity != null && contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID == model.ContractTypeID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = model.ProfileID,
InsuranceAmount = model.InsuranceAmount,
DateEffect = model.DateStart,
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = model.CurenncyID1
};
message = insuranceServices.Add(insuranceEntity);
}
}
#endregion
if (model.CreateBasicSalary == true)
{
Sal_BasicSalaryServices salaryservices = new Sal_BasicSalaryServices();
Sal_BasicSalaryEntity basicSalaryBycontract = new Sal_BasicSalaryEntity();
basicSalaryBycontract.ProfileID = profile.ID;
basicSalaryBycontract.GrossAmount = model.Salary != null ? model.Salary.ToString() : "0";
basicSalaryBycontract.CurrencyID = model.CurenncyID != null ? model.CurenncyID.Value : Guid.Empty;
basicSalaryBycontract.PersonalRate = model.PersonalRate;
basicSalaryBycontract.DateOfEffect = model.DateStart;
basicSalaryBycontract.InsuranceAmount = model.InsuranceAmount != null ? model.InsuranceAmount.Value : 0;
basicSalaryBycontract.CurrencyID1 = model.CurenncyID1;
basicSalaryBycontract.ClassRateID = model.ClassRateID;
basicSalaryBycontract.RankRateID = model.RankRateID;
basicSalaryBycontract.AllowanceType1ID = model.AllowanceID1;
basicSalaryBycontract.AllowanceAmount1 = model.Allowance1;
basicSalaryBycontract.CurrencyID2 = model.CurenncyID2;
basicSalaryBycontract.AllowanceType2ID = model.AllowanceID2;
basicSalaryBycontract.AllowanceAmount2 = model.Allowance2;
basicSalaryBycontract.CurrencyID3 = model.CurenncyID3;
basicSalaryBycontract.AllowanceType3ID = model.AllowanceID3;
basicSalaryBycontract.AllowanceAmount3 = model.Allowance3;
basicSalaryBycontract.CurrencyID4 = model.CurenncyIDSalary;
salaryservices.Add(basicSalaryBycontract);
}
if (model.BasicSalaryForPerson == true)
{
List<object> listObj = new List<object>();
listObj.Add(1);
listObj.Add(1000);
var BasicSalaryServices = new Sal_BasicSalaryServices();
var basicSalaryByProfile = actionService.GetData<Sal_BasicSalaryEntity>(Common.DotNetToOracle(profile.ID.ToString()), ConstantSql.hrm_sal_sp_get_BasicSalaryByProfileIds, ref status).FirstOrDefault();
Hre_ContractEntity contractgetNo = new Hre_ContractEntity();
model.CopyData(contractgetNo);
Hre_ContractEntity contract = new Hre_ContractEntity();
contract.Allowance = model.Allowance;
contract.Allowance1 = model.Allowance1;
contract.Allowance2 = model.Allowance2;
contract.Allowance3 = model.Allowance3;
contract.Allowance4 = model.Allowance4;
if (basicSalaryByProfile != null)
{
contract.AllowanceID1 = basicSalaryByProfile.AllowanceType1ID != null ? basicSalaryByProfile.AllowanceType1ID : null;
contract.AllowanceID2 = basicSalaryByProfile.AllowanceType2ID != null ? basicSalaryByProfile.AllowanceType2ID : null;
contract.AllowanceID3 = basicSalaryByProfile.AllowanceType3ID != null ? basicSalaryByProfile.AllowanceType3ID : null;
contract.AllowanceID4 = basicSalaryByProfile.AllowanceType4ID != null ? basicSalaryByProfile.AllowanceType4ID : null;
contract.ClassRateID = basicSalaryByProfile.ClassRateID != null ? basicSalaryByProfile.ClassRateID : null;
contract.CurenncyID = basicSalaryByProfile.CurrencyID;
contract.CurenncyID1 = basicSalaryByProfile.CurrencyID1 != null ? basicSalaryByProfile.CurrencyID1 : null;
contract.CurenncyID2 = basicSalaryByProfile.CurrencyID2 != null ? basicSalaryByProfile.CurrencyID2 : null;
contract.CurenncyID3 = basicSalaryByProfile.CurrencyID3 != null ? basicSalaryByProfile.CurrencyID3 : null;
contract.CurenncyID4 = basicSalaryByProfile.CurrencyID4 != null ? basicSalaryByProfile.CurrencyID4 : null;
contract.CurenncyID5 = basicSalaryByProfile.CurrencyID5 != null ? basicSalaryByProfile.CurrencyID5 : null;
}
contract.Code = model.Code;
contract.CodeEmp = model.CodeEmp;
contract.ContractTypeID = model.ContractTypeID;
contract.CurenncyIDSalary = model.CurenncyIDSalary;
contract.CurenncyInsName = model.CurenncyInsName;
contract.CurenncyOAllowanceName = model.CurenncyOAllowanceName;
contract.CurrencySalName = model.CurrencySalName;
contract.DateAuthorize = model.DateAuthorize;
contract.DateCreate = model.DateCreate;
contract.DateUpdate = DateTime.Now;
contract.DateEnd = model.DateEnd;
contract.DateSigned = model.DateSigned;
contract.DateStart = model.DateStart;
contract.FollowNo = model.FollowNo;
contract.FormPaySalary = model.FormPaySalary;
contract.HourWorkInMonth = model.HourWorkInMonth;
contract.InsuranceAmount = model.InsuranceAmount;
contract.IPCreate = model.IPCreate;
contract.IPUpdate = model.IPUpdate;
contract.JobTitleID = model.JobTitleID;
contract.PersonalRate = model.PersonalRate;
contract.PositionID = model.PositionID;
contract.ProfileID = model.ProfileID;
contract.ProfileSingID = model.ProfileSingID;
contract.ProfileName = model.ProfileName;
contract.ProfileSingName = model.ProfileSingName;
contract.QualificationID = model.QualificationID;
contract.RankRateID = basicSalaryByProfile.RankRateID;
contract.Salary = basicSalaryByProfile == null ? (double?)null : Convert.ToDouble(basicSalaryByProfile.GrossAmount);
contract.ClassRateID = basicSalaryByProfile.ClassRateID;
contract.SalaryClassTypeID = model.SalaryClassTypeID;
contract.ServerCreate = model.ServerCreate;
contract.ServerUpdate = model.ServerUpdate;
contract.WorkPlaceID = model.WorkPlaceID;
contract.NextContractTypeID = model.NextContractTypeID;
contract.Remark = model.Remark;
contract.RankDetailForNextContract = model.RankDetailForNextContract;
contract.ContractEvaType = model.ContractEvaType;
contract.DateOfContractEva = model.DateOfContractEva;
contract.EvaluationResult = model.EvaluationResult;
contract.ContractResult = model.ContractResult;
contract.TypeOfPass = model.TypeOfPass;
contract.DateEndNextContract = model.DateEndNextContract;
contract.DateExtend = model.DateEnd;
contract.Status = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contract = SetNewDateEndContract(contract);
}
//Tạo mã cho hợp đồng
// contract = SetNewCodeContract(contract, listIdContract);
if (contract.ID == Guid.Empty)
{
contract.ActionStatus = ContractServices.Add(contract);
}
else
{
contract.ActionStatus = ContractServices.Edit(contract);
}
return Json(contract, JsonRequestBehavior.AllowGet);
}
Hre_ContractEntity contractgetNoGetBasicSalary = new Hre_ContractEntity();
model.CopyData(contractgetNoGetBasicSalary);
Hre_ContractEntity contractNoGetBasicSalary = new Hre_ContractEntity();
contractNoGetBasicSalary.Allowance = model.Allowance;
contractNoGetBasicSalary.Allowance1 = model.Allowance1;
contractNoGetBasicSalary.Allowance3 = model.Allowance3;
contractNoGetBasicSalary.Allowance2 = model.Allowance2;
contractNoGetBasicSalary.Allowance4 = model.Allowance4;
contractNoGetBasicSalary.AllowanceID1 = model.AllowanceID1;
contractNoGetBasicSalary.AllowanceID2 = model.AllowanceID2;
contractNoGetBasicSalary.AllowanceID3 = model.AllowanceID3;
contractNoGetBasicSalary.AllowanceID4 = model.AllowanceID4;
contractNoGetBasicSalary.ClassRateID = model.ClassRateID;
contractNoGetBasicSalary.ClassRateName = model.ClassRateName;
contractNoGetBasicSalary.Code = model.Code;
contractNoGetBasicSalary.CodeEmp = model.CodeEmp;
contractNoGetBasicSalary.ContractTypeID = model.ContractTypeID;
contractNoGetBasicSalary.CurenncyID = model.CurenncyID;
contractNoGetBasicSalary.CurenncyID1 = model.CurenncyID1;
contractNoGetBasicSalary.CurenncyID2 = model.CurenncyID2;
contractNoGetBasicSalary.CurenncyID3 = model.CurenncyID3;
contractNoGetBasicSalary.CurenncyID4 = model.CurenncyID4;
contractNoGetBasicSalary.CurenncyID5 = model.CurenncyID5;
contractNoGetBasicSalary.CurenncyIDSalary = model.CurenncyIDSalary;
contractNoGetBasicSalary.CurenncyInsName = model.CurenncyInsName;
contractNoGetBasicSalary.CurenncyOAllowanceName = model.CurenncyOAllowanceName;
contractNoGetBasicSalary.CurrencySalName = model.CurrencySalName;
contractNoGetBasicSalary.DateAuthorize = model.DateAuthorize;
contractNoGetBasicSalary.DateCreate = model.DateCreate;
contractNoGetBasicSalary.DateEnd = model.DateEnd;
contractNoGetBasicSalary.DateSigned = model.DateSigned;
contractNoGetBasicSalary.DateStart = model.DateStart;
contractNoGetBasicSalary.DateUpdate = DateTime.Now;
contractNoGetBasicSalary.FollowNo = model.FollowNo;
contractNoGetBasicSalary.FormPaySalary = model.FormPaySalary;
contractNoGetBasicSalary.HourWorkInMonth = model.HourWorkInMonth;
contractNoGetBasicSalary.InsuranceAmount = model.InsuranceAmount;
contractNoGetBasicSalary.IPCreate = model.IPCreate;
contractNoGetBasicSalary.IPUpdate = model.IPUpdate;
contractNoGetBasicSalary.JobTitleID = model.JobTitleID;
contractNoGetBasicSalary.PersonalRate = model.PersonalRate;
contractNoGetBasicSalary.PositionID = model.PositionID;
contractNoGetBasicSalary.ProfileID = model.ProfileID;
contractNoGetBasicSalary.ProfileSingID = model.ProfileSingID;
contractNoGetBasicSalary.ProfileName = model.ProfileName;
contractNoGetBasicSalary.ProfileSingName = model.ProfileSingName;
contractNoGetBasicSalary.QualificationID = model.QualificationID;
contractNoGetBasicSalary.RankRateID = model.RankRateID;
contractNoGetBasicSalary.Salary = model.Salary;
contractNoGetBasicSalary.SalaryClassTypeID = model.SalaryClassTypeID;
contractNoGetBasicSalary.ServerCreate = model.ServerCreate;
contractNoGetBasicSalary.ServerUpdate = model.ServerUpdate;
contractNoGetBasicSalary.WorkPlaceID = model.WorkPlaceID;
contractNoGetBasicSalary.NextContractTypeID = model.NextContractTypeID;
contractNoGetBasicSalary.Remark = model.Remark;
contractNoGetBasicSalary.RankDetailForNextContract = model.RankDetailForNextContract;
contractNoGetBasicSalary.ContractEvaType = model.ContractEvaType;
contractNoGetBasicSalary.DateOfContractEva = model.DateOfContractEva;
contractNoGetBasicSalary.EvaluationResult = model.EvaluationResult;
contractNoGetBasicSalary.ContractResult = model.ContractResult;
contractNoGetBasicSalary.TypeOfPass = model.TypeOfPass;
contractNoGetBasicSalary.DateEndNextContract = model.DateEndNextContract;
contractNoGetBasicSalary.DateExtend = model.DateEnd;
contractNoGetBasicSalary.Status = HRM.Infrastructure.Utilities.EnumDropDown.Status.E_WAITING.ToString();
if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
{
contractNoGetBasicSalary = SetNewDateEndContract(contractNoGetBasicSalary);
}
//Tạo mã cho hợp đồng
// contractNoGetBasicSalary = SetNewCodeContract(contractNoGetBasicSalary, listIdContract);
if (contractNoGetBasicSalary.ID == Guid.Empty)
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Add(contractNoGetBasicSalary);
}
else
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Edit(contractNoGetBasicSalary);
}
message = contractNoGetBasicSalary.ActionStatus;
return Json(contractNoGetBasicSalary, JsonRequestBehavior.AllowGet);
}
return Json(null, JsonRequestBehavior.AllowGet);
}
public ActionResult SaveContractAndBasicSalary([Bind]Hre_ContractModel model)
{
#region Validate
string message_Error = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "Hre_Contract", ref message_Error);
if (!checkValidate)
{
model.ActionStatus = message_Error;
return Json(message_Error, JsonRequestBehavior.AllowGet);
}
#endregion
string status = string.Empty;
Guid convertProfileID = Guid.Empty;
var insuranceServices = new Sal_InsuranceSalaryServices();
string message = string.Empty;
List<Guid> lstProfileID = new List<Guid>();
var ContractServices = new Hre_ContractServices();
if (model.ProfileIDs != null && model.ProfileIDs.IndexOf(',') > 1)
{
var lstID = model.ProfileIDs.Split(',');
for (int i = 0; i < lstID.Length; i++)
{
convertProfileID = Common.ConvertToGuid(lstID[i]);
lstProfileID.Add(convertProfileID);
}
}
else
{
convertProfileID = Common.ConvertToGuid(model.ProfileIDs);
lstProfileID.Add(convertProfileID);
}
List<object> lstObjProfile = new List<object>();
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(null);
lstObjProfile.Add(1);
lstObjProfile.Add(int.MaxValue - 1);
var actionService = new ActionService(UserLogin);
var lstProfile = actionService.GetData<Hre_ProfileEntity>(lstObjProfile, ConstantSql.hrm_hr_sp_get_ProfileAll, ref status).ToList();
lstProfile = lstProfile.Where(s => lstProfileID.Contains(s.ID) && s.IsDelete == null).ToList();
var contractTypeService = new Cat_ContractTypeServices();
var lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(int.MaxValue - 1);
var lstContractType = actionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
foreach (var profile in lstProfile)
{
model.ProfileID = profile.ID;
var contractTypeEntity = lstContractType.Where(s => s.ID == model.ContractTypeID).FirstOrDefault();
#region Xử Lý Lương BHXH
if (contractTypeEntity != null && contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = model.ProfileID,
InsuranceAmount = model.InsuranceAmount,
DateEffect = model.DateStart,
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = model.CurenncyID1
};
message = insuranceServices.Add(insuranceEntity);
}
#endregion
if (model.CreateBasicSalary == true)
{
Sal_BasicSalaryServices salaryservices = new Sal_BasicSalaryServices();
Sal_BasicSalaryEntity basicSalaryBycontract = new Sal_BasicSalaryEntity();
basicSalaryBycontract.ProfileID = profile.ID;
basicSalaryBycontract.GrossAmount = model.Salary != null ? model.Salary.ToString() : "0";
basicSalaryBycontract.CurrencyID = model.CurenncyID != null ? model.CurenncyID.Value : Guid.Empty;
basicSalaryBycontract.PersonalRate = model.PersonalRate;
basicSalaryBycontract.DateOfEffect = model.DateStart;
basicSalaryBycontract.InsuranceAmount = model.InsuranceAmount != null ? model.InsuranceAmount.Value : 0;
basicSalaryBycontract.CurrencyID1 = model.CurenncyID1;
basicSalaryBycontract.ClassRateID = model.ClassRateID;
basicSalaryBycontract.RankRateID = model.RankRateID;
basicSalaryBycontract.AllowanceType1ID = model.AllowanceID1;
basicSalaryBycontract.AllowanceAmount1 = model.Allowance1;
basicSalaryBycontract.CurrencyID2 = model.CurenncyID2;
basicSalaryBycontract.AllowanceType2ID = model.AllowanceID2;
basicSalaryBycontract.AllowanceAmount2 = model.Allowance2;
basicSalaryBycontract.CurrencyID3 = model.CurenncyID3;
basicSalaryBycontract.AllowanceType3ID = model.AllowanceID3;
basicSalaryBycontract.AllowanceAmount3 = model.Allowance3;
basicSalaryBycontract.CurrencyID4 = model.CurenncyIDSalary;
salaryservices.Add(basicSalaryBycontract);
}
if (model.BasicSalaryForPerson == true)
{
List<object> listObj = new List<object>();
listObj.Add(1);
listObj.Add(1000);
var BasicSalaryServices = new Sal_BasicSalaryServices();
var lstBasicSalary = actionService.GetData<Sal_BasicSalaryEntity>(listObj, ConstantSql.hrm_sal_sp_get_BasicPayrollGetAll, ref status).Where(s => s.ProfileID == profile.ID && s.DateOfEffect != null).FirstOrDefault();
Hre_ContractEntity contractgetNo = new Hre_ContractEntity();
model.CopyData(contractgetNo);
Hre_ContractEntity contract = new Hre_ContractEntity
{
ID = model.ID,
Allowance = model.Allowance,
Allowance1 = model.Allowance1,
Allowance3 = model.Allowance3,
Allowance2 = model.Allowance2,
Allowance4 = model.Allowance4,
AllowanceID1 = lstBasicSalary.AllowanceType1ID,
AllowanceID2 = lstBasicSalary.AllowanceType2ID,
AllowanceID3 = lstBasicSalary.AllowanceType3ID,
AllowanceID4 = lstBasicSalary.AllowanceType4ID,
ClassRateID = lstBasicSalary.ClassRateID,
Code = model.Code,
CodeEmp = model.CodeEmp,
//ContractNo = getContractNo(contractgetNo, contractgetNo.DateSigned),
ContractTypeID = model.ContractTypeID,
CurenncyID = lstBasicSalary.CurrencyID,
CurenncyID1 = lstBasicSalary.CurrencyID1,
CurenncyID2 = lstBasicSalary.CurrencyID2,
CurenncyID3 = lstBasicSalary.CurrencyID3,
CurenncyID4 = lstBasicSalary.CurrencyID4,
CurenncyID5 = lstBasicSalary.CurrencyID5,
CurenncyIDSalary = model.CurenncyIDSalary,
CurenncyInsName = model.CurenncyInsName,
CurenncyOAllowanceName = model.CurenncyOAllowanceName,
CurrencySalName = model.CurrencySalName,
DateAuthorize = model.DateAuthorize,
DateCreate = model.DateCreate,
DateUpdate = DateTime.Now,
DateEnd = model.DateEnd,
DateSigned = model.DateSigned,
DateStart = model.DateStart,
FollowNo = model.FollowNo,
FormPaySalary = model.FormPaySalary,
HourWorkInMonth = model.HourWorkInMonth,
InsuranceAmount = model.InsuranceAmount,
IPCreate = model.IPCreate,
IPUpdate = model.IPUpdate,
JobTitleID = model.JobTitleID,
PersonalRate = model.PersonalRate,
PositionID = model.PositionID,
ProfileID = model.ProfileID,
ProfileSingID = model.ProfileSingID,
ProfileName = model.ProfileName,
ProfileSingName = model.ProfileSingName,
QualificationID = model.QualificationID,
RankRateID = lstBasicSalary.RankRateID,
Salary = lstBasicSalary == null ? (double?)null : Convert.ToDouble(lstBasicSalary.GrossAmount),
SalaryClassTypeID = lstBasicSalary.ClassRateID,
ServerCreate = model.ServerCreate,
ServerUpdate = model.ServerUpdate,
WorkPlaceID = model.WorkPlaceID,
};
if (contract.ID == Guid.Empty)
{
contract.ActionStatus = ContractServices.Add(contract);
}
else
{
contract.ActionStatus = ContractServices.Edit(contract);
}
return Json(contract, JsonRequestBehavior.AllowGet);
}
Hre_ContractEntity contractgetNoGetBasicSalary = new Hre_ContractEntity();
model.CopyData(contractgetNoGetBasicSalary);
Hre_ContractEntity contractNoGetBasicSalary = new Hre_ContractEntity
{
ID = model.ID,
Allowance = model.Allowance,
Allowance1 = model.Allowance1,
Allowance3 = model.Allowance3,
Allowance2 = model.Allowance2,
Allowance4 = model.Allowance4,
AllowanceID1 = model.AllowanceID1,
AllowanceID2 = model.AllowanceID2,
AllowanceID3 = model.AllowanceID3,
AllowanceID4 = model.AllowanceID4,
ClassRateID = model.ClassRateID,
ClassRateName = model.ClassRateName,
Code = model.Code,
CodeEmp = model.CodeEmp,
// ContractNo = getContractNo(contractgetNoGetBasicSalary, contractgetNoGetBasicSalary.DateSigned),
ContractTypeID = model.ContractTypeID,
CurenncyID = model.CurenncyID,
CurenncyID1 = model.CurenncyID1,
CurenncyID2 = model.CurenncyID2,
CurenncyID3 = model.CurenncyID3,
CurenncyID4 = model.CurenncyID4,
CurenncyID5 = model.CurenncyID5,
CurenncyIDSalary = model.CurenncyIDSalary,
CurenncyInsName = model.CurenncyInsName,
CurenncyOAllowanceName = model.CurenncyOAllowanceName,
CurrencySalName = model.CurrencySalName,
DateAuthorize = model.DateAuthorize,
DateCreate = model.DateCreate,
DateEnd = model.DateEnd,
DateSigned = model.DateSigned,
DateStart = model.DateStart,
DateUpdate = DateTime.Now,
FollowNo = model.FollowNo,
FormPaySalary = model.FormPaySalary,
HourWorkInMonth = model.HourWorkInMonth,
InsuranceAmount = model.InsuranceAmount,
IPCreate = model.IPCreate,
IPUpdate = model.IPUpdate,
JobTitleID = model.JobTitleID,
PersonalRate = model.PersonalRate,
PositionID = model.PositionID,
ProfileID = model.ProfileID,
ProfileSingID = model.ProfileSingID,
ProfileName = model.ProfileName,
ProfileSingName = model.ProfileSingName,
QualificationID = model.QualificationID,
RankRateID = model.RankRateID,
Salary = model.Salary,
SalaryClassTypeID = model.SalaryClassTypeID,
ServerCreate = model.ServerCreate,
ServerUpdate = model.ServerUpdate,
WorkPlaceID = model.WorkPlaceID,
};
if (contractNoGetBasicSalary.ID == Guid.Empty)
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Add(contractNoGetBasicSalary);
}
else
{
contractNoGetBasicSalary.ActionStatus = ContractServices.Edit(contractNoGetBasicSalary);
}
return Json(contractNoGetBasicSalary, JsonRequestBehavior.AllowGet);
}
return Json(message, JsonRequestBehavior.AllowGet);
}
public ActionResult CheckAddNewContract(string ContractTypeID, string ContractID)
{
string status = string.Empty;
var contractTypeID = Guid.Empty;
var message = string.Empty;
if (!string.IsNullOrEmpty(ContractTypeID))
{
contractTypeID = Common.ConvertToGuid(ContractTypeID);
}
var contractID = Common.ConvertToGuid(ContractID);
ActionService service = new ActionService(UserLogin);
var lstContract = service.GetData<Hre_ContractEntity>(contractID, ConstantSql.hrm_hr_sp_get_ContractById, ref status).FirstOrDefault();
List<object> listObj = new List<object>();
listObj.Add(1);
listObj.Add(1000);
var actionServices = new ActionService(UserLogin);
var lstBasicSalary = actionServices.GetData<Sal_BasicSalaryEntity>(listObj, ConstantSql.hrm_sal_sp_get_BasicPayrollGetAll, ref status);
Sal_BasicSalaryEntity basicSalary = new Sal_BasicSalaryEntity();
if (lstBasicSalary != null && lstBasicSalary.Count != 0)
{
basicSalary = lstBasicSalary.Where(s => s.ProfileID == lstContract.ProfileID && s.DateOfEffect <= lstContract.DateEnd && lstContract.ProfileID == s.ProfileID).OrderByDescending(s => s.DateOfEffect).FirstOrDefault();
}
if (basicSalary == null || lstBasicSalary.Count <= 0)
{
message = "Error";
return Json(message, JsonRequestBehavior.AllowGet);
}
var result = basicSalary.CopyData<Hre_ReportExpiryContractModel>();
result.ContractTypeID = contractTypeID;
return Json(result, JsonRequestBehavior.AllowGet);
}
public string SaveContractAndNextSalaryApprovedEvaluation(Hre_ContractEntity contract)
{
if (contract.DateEndNextContract == null)
{
return string.Empty;
}
// Lấy biến Dateend này gắn cho quá trình công tác khi cập nhật quá trinh công tác ở dưới
DateTime? dateEnd = contract.DateEnd;
string message = string.Empty;
var actionService = new ActionService(UserLogin);
string status = string.Empty;
var profile = actionService.GetData<Hre_ProfileEntity>(contract.ProfileID, ConstantSql.hrm_hr_sp_get_ProfileById, ref status).FirstOrDefault();
var hrService = new Hre_ProfileServices();
var salaryRankServices = new Cat_SalaryRankServices();
var lstObjSalaryRank = new List<object>();
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(null);
lstObjSalaryRank.Add(1);
lstObjSalaryRank.Add(int.MaxValue - 1);
var lstSalaryRank = actionService.GetData<Cat_SalaryRankEntity>(lstObjSalaryRank, ConstantSql.hrm_cat_sp_get_SalaryRank, ref status).ToList();
var contractServices = new Hre_ContractServices();
var workhistoryService = new Hre_WorkHistoryServices();
var lstObjWorkhistory = new List<object>();
lstObjWorkhistory.AddRange(new object[17]);
lstObjWorkhistory[15] = 1;
lstObjWorkhistory[16] = int.MaxValue - 1;
var lstWorkhistory = actionService.GetData<Hre_WorkHistoryEntity>(lstObjWorkhistory, ConstantSql.hrm_hr_sp_get_WorkHistory, ref status).ToList();
var basicSalaryService = new Sal_BasicSalaryServices();
var attGradeService = new Att_GradeServices();
var lstObjAttGrade = new List<object>();
lstObjAttGrade.AddRange(new object[6]);
lstObjAttGrade[4] = 1;
lstObjAttGrade[5] = int.MaxValue - 1;
var lstAttGrade = actionService.GetData<Att_GradeEntity>(lstObjAttGrade, ConstantSql.hrm_att_sp_get_Att_Grade, ref status).ToList();
var gradeService = new Sal_GradeServices();
var lstObjSalGrade = new List<object>();
lstObjSalGrade.AddRange(new object[7]);
lstObjSalGrade[5] = 1;
lstObjSalGrade[6] = int.MaxValue - 1;
var lstSalGrade = actionService.GetData<Sal_GradeEntity>(lstObjSalGrade, ConstantSql.hrm_sal_sp_get_Sal_Grade, ref status).ToList();
var gradePayrollService = new Cat_GradePayrollServices();
var lstObjGradePayroll = new List<object>();
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(null);
lstObjGradePayroll.Add(1);
lstObjGradePayroll.Add(int.MaxValue - 1);
var lstGradePayroll = actionService.GetData<Cat_GradePayrollEntity>(lstObjGradePayroll, ConstantSql.hrm_cat_sp_get_GradePayroll, ref status).ToList();
var gradeAttService = new Cat_GradeAttendanceServices();
var lstObjGradeAtt = new List<object>();
lstObjGradeAtt.AddRange(new object[10]);
lstObjGradeAtt[8] = 1;
lstObjGradeAtt[9] = int.MaxValue - 1;
var lstGradeAtt = actionService.GetData<Cat_GradeAttendanceEntity>(lstObjGradeAtt, ConstantSql.hrm_cat_sp_get_Cat_GradeAttendance, ref status).ToList();
var currencyServices = new Cat_CurrencyServices();
var lstObjCurrency = new List<object>();
lstObjCurrency.Add(null);
lstObjCurrency.Add(null);
lstObjCurrency.Add(1);
lstObjCurrency.Add(int.MaxValue - 1);
var lstCurrency = actionService.GetData<Cat_CurrencyEntity>(lstObjCurrency, ConstantSql.hrm_cat_sp_get_Currency, ref status).ToList();
var lstCurrencyNew = lstCurrency.Where(s => s.CurrencyName == "VND").FirstOrDefault();
var contractTypeService = new Cat_ContractTypeServices();
var lstObjContractType = new List<object>();
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(null);
lstObjContractType.Add(1);
lstObjContractType.Add(int.MaxValue - 1);
var lstContractType = actionService.GetData<Cat_ContractTypeEntity>(lstObjContractType, ConstantSql.hrm_cat_sp_get_ContractType, ref status).ToList();
var insuranceConfigServices = new Cat_InsuranceConfigServices();
var objInsuranceConfig = new List<object>();
objInsuranceConfig.Add(1);
objInsuranceConfig.Add(int.MaxValue - 1);
var lstInsuranceConfig = actionService.GetData<Cat_InsuranceConfigEntity>(objInsuranceConfig, ConstantSql.hrm_cat_sp_get_InsuranceConfig, ref status).ToList();
var insuranceServices = new Sal_InsuranceSalaryServices();
var objInsurance = new List<object>();
objInsurance.AddRange(new object[9]);
objInsurance[7] = 1;
objInsurance[8] = int.MaxValue - 1;
var lstInsurance = actionService.GetData<Sal_InsuranceSalaryEntity>(objInsurance, ConstantSql.hrm_sal_sp_get_InsuranceSalary, ref status).ToList();
var contractTypeEntity = new Cat_ContractTypeEntity();
var objContract = new List<object>();
objContract.Add(contract.ProfileID);
var lstContractIdByProfileID = actionService.GetData<Hre_ContractEntity>(objContract, ConstantSql.hrm_hr_sp_get_ContractsByProfileId, ref status);
var listIdContract = string.Empty;
if (lstContractIdByProfileID != null)
{
listIdContract = string.Join(",", lstContractIdByProfileID.Select(d => d.ContractTypeID));
}
if (contract.NextContractTypeID != null)
{
contractTypeEntity = lstContractType.Where(s => contract.NextContractTypeID.Value == s.ID).FirstOrDefault();
}
else
{
message = ConstantMessages.WarningContractHaveNotNextContract.ToString().TranslateString();
return message;
}
if (contractTypeEntity != null)
{
if (contractTypeEntity.Type == EnumDropDown.TypeContract.E_NODURATION.ToString())
{
return string.Empty;
}
}
var workingHistoryEntity = lstWorkhistory.Where(s => s.ProfileID == contract.ProfileID).FirstOrDefault();
var objSalGrade = new List<object>();
objSalGrade.Add(contract.ProfileID);
objSalGrade.Add(null);
objSalGrade.Add(1);
objSalGrade.Add(int.MaxValue - 1);
var salGradeByProfileIDEntity = actionService.GetData<Sal_GradeEntity>(objSalGrade, ConstantSql.hrm_sal_sp_get_GradeAndAllownaceByProId, ref status).FirstOrDefault();
var objAttGrade = new List<object>();
objAttGrade.Add(contract.ProfileID);
objAttGrade.Add(null);
objAttGrade.Add(1);
objAttGrade.Add(int.MaxValue - 1);
var attGradeByProfileIDEntity = actionService.GetData<Att_GradeEntity>(objAttGrade, ConstantSql.hrm_att_sp_get_GradeAttendanceByProIdCutID, ref status).FirstOrDefault();
if (contractTypeEntity == null)
{
return string.Empty;
}
var contracttypeByContract = lstContractType.Where(s => s.ID == contract.ContractTypeID).FirstOrDefault();
if (contract.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
if (contract.ContractEvaType == EnumDropDown.ContractEvaType.E_EXPIRED_APPRENTICE.ToString())
{
//chưa tìm dc cách xử lý nên hard code
var lstSalaryRankNew = new Cat_SalaryRankEntity();
if (contract.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankDetailForNextContract != null && s.ID == contract.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankRateID != null && s.ID == contract.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
if (contract.TypeOfPass == EnumDropDown.TypeOfPass.E_SIGNED_NEXTCONTRACT.ToString())
{
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = contract.DateEnd.Value.AddDays(1),
DateSigned = contract.DateEnd.Value.AddDays(1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID,
DateEndNextContract = contract.DateEndNextContract,
};
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity = SetNewCodeContract(contractEntity, listIdContract);
#region Nếu là loại hđ xác định thời hạn thì update lại cột TimesContract theo task 0049731
if (contracttypeByContract != null && contracttypeByContract.Type == HRM.Infrastructure.Utilities.EnumDropDown.TypeContract.E_DURATION.ToString())
{
try
{
string times = contractEntity.ContractNo.Substring(contractEntity.ContractNo.Length - 1, 1);
int Year = int.Parse(times);
contractEntity.TimesContract = Year;
}
catch
{
}
}
#endregion
contractEntity.Status = "E_APPROVED";
contractEntity.StatusEvaluation = "E_APPROVED";
contractEntity.DateExtend = contract.DateEnd;
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
// var nextContractTypeID = Common.ConvertToGuid(contractTypeEntity.ContractNextID).ToString();
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = contract.DateEnd.Value.AddDays(1),
DateSigned = contract.DateEnd.Value.AddDays(1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
// DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? contract.RankRateID : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
//if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
//{
// contractEntity = SetNewDateEndContract(contractEntity);
//}
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity.DateExtend = contract.DateEnd;
contractEntity.StatusEvaluation = "E_APPROVED";
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
}
//Edit lai StatusEvaluation
contract.StatusEvaluation = "E_APPROVED";
message = contractServices.Edit(contract);
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = contract.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = contract.DateSigned != null ? contract.DateSigned.Value : DateTime.Now,
CurrencyID = lstCurrencyNew.ID,
Note = contract.Remark,
Status = "E_APPROVED"
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
Guid? _AbilityTileID = null;
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
if (profileEntity.SalaryClassID != null)
{
var abilityTitleBySalaryClass = hrService.GetData<Cat_AbilityTileEntity>(Common.DotNetToOracle(profileEntity.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId, UserLogin, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
_AbilityTileID = abilityTitleBySalaryClass.ID;
profileEntity.AbilityTileID = _AbilityTileID;
}
}
hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
AbilityTileID = _AbilityTileID,
Status = "E_APPROVED"
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
Status = "E_APPROVED",
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstAttGradeByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
// ID = lstGradeAttByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = contract.DateSigned.Value,
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateSigned != null ? contract.DateSigned.Value : DateTime.Now,
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateSigned != null ? contract.DateSigned.Value : DateTime.Now,
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
}
if (contract.ContractEvaType == EnumDropDown.ContractEvaType.E_ANNUAL_EVALUATION.ToString() && contract.ContractResult == EnumDropDown.ResultContract.PASS.ToString())
{
var lstSalaryRankNew = new Cat_SalaryRankEntity();
if (contract.RankDetailForNextContract != null)
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankDetailForNextContract != null && s.ID == contract.RankDetailForNextContract.Value).FirstOrDefault();
}
else
{
lstSalaryRankNew = lstSalaryRank.Where(s => contract.RankRateID != null && s.ID == contract.RankRateID.Value).FirstOrDefault();
}
#region Xử lý Hre_Contract
int month = 0;
if (contractTypeEntity != null && contractTypeEntity.ValueTime != null)
{
month = (int)contractTypeEntity.ValueTime.Value;
if (contractTypeEntity.UnitTime == HRM.Infrastructure.Utilities.EnumDropDown.UnitType.E_YEAR.ToString())
{
month = month * 12;
}
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
DateEnd = contractTypeEntity.DateStart.Value.AddMonths(month),
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
//if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
//{
// contractEntity = SetNewDateEndContract(contractEntity);
//}
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity = SetNewCodeContract(contractEntity, listIdContract);
#region Nếu là loại hđ xác định thời hạn thì update lại cột TimesContract theo task 0049731
if (contracttypeByContract != null && contracttypeByContract.Type == HRM.Infrastructure.Utilities.EnumDropDown.TypeContract.E_DURATION.ToString())
{
try
{
string times = contractEntity.ContractNo.Substring(contractEntity.ContractNo.Length - 1, 1);
int Year = int.Parse(times);
contractEntity.TimesContract = Year;
}
catch
{
}
}
#endregion
contractEntity.Status = "E_APPROVED";
contractEntity.DateExtend = contract.DateEnd;
contractEntity.StatusEvaluation = "E_APPROVED";
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
else
{
contractTypeEntity.DateStart = contract.DateEnd.Value.AddDays(1);
//chưa tìm dc cách xử lý nên hard code
var contractEntity = new Hre_ContractEntity
{
// ContractNo = getContractNo(item, item.DateSigned),
ProfileID = contract.ProfileID,
ProfileName = contract.ProfileName,
DateStart = new DateTime(DateTime.Now.Year, 6, 1),
DateSigned = new DateTime(DateTime.Now.Year, 6, 1),
JobTitleID = contract.JobTitleID,
PositionID = contract.PositionID,
// DateEnd = null,
Salary = lstSalaryRankNew == null ? 0 : lstSalaryRankNew.SalaryStandard,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
ClassRateName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryClassName,
SalaryRankName = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryRankName,
ContractTypeID = contractTypeEntity.ID
};
//if (!string.IsNullOrEmpty(contractTypeEntity.Formula))
//{
// contractEntity = SetNewDateEndContract(contractEntity);
//}
if (contract.DateEndNextContract != null)
{
contractEntity.DateEnd = contract.DateEndNextContract.Value;
}
contractEntity.DateExtend = contract.DateEnd;
contractEntity.StatusEvaluation = "E_APPROVED";
if (!string.IsNullOrEmpty(contractEntity.ErrorMessage))
{
return string.Empty;
}
message = contractServices.Add(contractEntity);
}
//Edit lai StatusEvaluation
contract.StatusEvaluation = "E_APPROVED";
message = contractServices.Edit(contract);
#endregion
#region Xử Lý Sal_BasicSalary
var salaryEntity = new Sal_BasicSalaryEntity
{
ProfileID = contract.ProfileID,
ClassRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
RankRateID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.ID,
GrossAmount = lstSalaryRankNew == null ? string.Empty : lstSalaryRankNew.SalaryStandard.ToString(),
DateOfEffect = new DateTime(DateTime.Now.Year, 6, 1),
CurrencyID = lstCurrencyNew.ID,
Note = contract.Remark,
Status = "E_APPROVED"
};
message = basicSalaryService.Add(salaryEntity);
#endregion
#region Xử Lý Hre_Profile
var profileEntity = profile.CopyData<Hre_ProfileEntity>();
profileEntity.SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID;
Guid? _AbilityTileID = null;
if (profileEntity.SalaryClassID != null)
{
var abilityTitleBySalaryClass = actionService.GetData<Cat_AbilityTileEntity>(Common.DotNetToOracle(profileEntity.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
_AbilityTileID = abilityTitleBySalaryClass.ID;
profileEntity.AbilityTileID = _AbilityTileID;
}
}
message = hrService.Edit(profileEntity);
if (workingHistoryEntity != null)
{
if (workingHistoryEntity.SalaryClassID != lstSalaryRankNew.SalaryClassID)
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
AbilityTileID = _AbilityTileID,
Status = "E_APPROVED"
};
message = workhistoryService.Add(workhistoryEntity);
}
}
else
{
var workhistoryEntity = new Hre_WorkHistoryEntity
{
ProfileID = contract.ProfileID,
SalaryClassID = lstSalaryRankNew == null ? Guid.Empty : lstSalaryRankNew.SalaryClassID,
DateEffective = dateEnd != null ? dateEnd.Value.AddDays(1) : DateTime.Now,
Status = "E_APPROVED"
};
message = workhistoryService.Add(workhistoryEntity);
}
#endregion
#region Sal_Grade
var lstGradeByProfileID = lstSalGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradePayrollByProfileID = lstGradePayroll.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (salGradeByProfileIDEntity != null)
{
if (salGradeByProfileIDEntity.GradePayrollID != lstGradePayrollByProfileID.ID)
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1),
};
message = gradeService.Add(gradeEntity);
}
}
else
{
var gradeEntity = new Sal_GradeEntity
{
// ID = lstGradeByProfileID == null ? Guid.Empty : lstGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradePayrollID = lstGradePayrollByProfileID == null ? Guid.Empty : lstGradePayrollByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = gradeService.Add(gradeEntity);
}
#endregion
#region Att_Grade
var lstAttGradeByProfileID = lstAttGrade.Where(s => contract.ProfileID == s.ProfileID).ToList().OrderByDescending(s => s.MonthEnd <= DateTime.Now).FirstOrDefault();
var lstGradeAttByProfileID = lstGradeAtt.Where(s => s.Code == lstSalaryRankNew.Code).FirstOrDefault();
if (attGradeByProfileIDEntity != null)
{
if (attGradeByProfileIDEntity.GradeAttendanceID != lstGradeAttByProfileID.ID)
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
}
else
{
var gradeAttEntity = new Att_GradeEntity
{
//ID = lstAttGradeByProfileID == null ? Guid.Empty: lstAttGradeByProfileID.ID,
ProfileID = contract.ProfileID,
GradeAttendanceID = lstGradeAttByProfileID == null ? Guid.Empty : lstGradeAttByProfileID.ID,
MonthStart = new DateTime(DateTime.Now.Year, 6, 1)
};
message = attGradeService.Add(gradeAttEntity);
}
#endregion
#region Xử Lý Lương BHXH
if (contractTypeEntity.NoneTypeInsuarance == true)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateEnd.Value.AddDays(1),
IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance,
IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance,
IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance,
CurrencyID = lstCurrencyNew.ID,
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = contractTypeEntity.IsSocialInsurance == null ? null : contractTypeEntity.IsSocialInsurance;
insuranceEntityByProfileID.IsUnimploymentIns = contractTypeEntity.IsUnEmployInsurance == null ? null : contractTypeEntity.IsUnEmployInsurance;
insuranceEntityByProfileID.IsMedicalIns = contractTypeEntity.IsHealthInsurance == null ? null : contractTypeEntity.IsHealthInsurance;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
if (contractTypeEntity.NoneTypeInsuarance == false)
{
var insuranceConfigEntity = lstInsuranceConfig.Where(s => s.ContractTypeID != null && s.ContractTypeID.Value == contractTypeEntity.ID).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
if (insuranceConfigEntity != null)
{
var insuranceEntityByProfileID = lstInsurance.Where(s => s.ProfileID == contract.ProfileID && s.DateEffect == contract.DateEnd.Value.AddDays(1)).OrderByDescending(s => s.DateUpdate).FirstOrDefault();
var insuranceEntity = new Sal_InsuranceSalaryEntity
{
ProfileID = contract.ProfileID,
InsuranceAmount = lstSalaryRankNew.SalaryStandard,
DateEffect = contract.DateEnd.Value.AddDays(1),
IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial,
IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy,
IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth,
CurrencyID = lstCurrencyNew.ID
};
if (insuranceEntityByProfileID != null)
{
insuranceEntityByProfileID.InsuranceAmount = lstSalaryRankNew.SalaryStandard;
insuranceEntityByProfileID.IsSocialIns = insuranceConfigEntity.IsSocial == null ? null : insuranceConfigEntity.IsSocial;
insuranceEntityByProfileID.IsUnimploymentIns = insuranceConfigEntity.IsUnEmploy == null ? null : insuranceConfigEntity.IsUnEmploy;
insuranceEntityByProfileID.IsMedicalIns = insuranceConfigEntity.IsHealth == null ? null : insuranceConfigEntity.IsHealth;
message = insuranceServices.Edit(insuranceEntityByProfileID);
}
else
{
message = insuranceServices.Add(insuranceEntity);
}
}
}
#endregion
}
}
return message;
// return null;
}
public ActionResult 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 string ApplyPerformance(Guid? profileID, Guid? rankdetailID, DateTime? dateEffect,string userLogin)
{
using (var context = new VnrHrmDataContext())
{
string result = ConstantMessages.Succeed;
var profileservices = new Hre_ProfileServices();
BaseService service = new BaseService();
string message = string.Empty;
string status = string.Empty;
var contractservices = new Hre_ContractServices();
var basicSalaryServices = new Sal_BasicSalaryServices();
var InsuranceSalaryServices = new Sal_InsuranceSalaryServices();
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCandidate = new Rec_CandidateRepository(unitOfWork);
var repoHistory = new Rec_RecruitmentHistoryRepository(unitOfWork);
var profile = service.GetData<Hre_ProfileEntity>(Common.DotNetToOracle(profileID.ToString()), ConstantSql.hrm_hr_sp_get_ProfileById, userLogin, ref status).FirstOrDefault();
var salaryRank = service.GetData<Cat_SalaryRankEntity>(Common.DotNetToOracle(rankdetailID.ToString()), ConstantSql.hrm_cat_sp_get_SalaryRankById, userLogin, ref status).FirstOrDefault();
Guid? _AbilitiTitleID = null;
if (salaryRank != null && salaryRank.SalaryClassID != null)
{
var abilityTitleBySalaryClass = service.GetData<Cat_AbilityTileEntity>(Common.DotNetToOracle(salaryRank.SalaryClassID.ToString()), ConstantSql.hrm_cat_sp_get_AbilityTileBySalaryClassId, userLogin, ref status).FirstOrDefault();
if (abilityTitleBySalaryClass != null)
{
_AbilitiTitleID = abilityTitleBySalaryClass.ID;
}
}
// theo task 0049950 - không làm gì liên quan đến hđ hết.
//var contractybyProfile = service.GetData<Hre_ContractEntity>(Common.DotNetToOracle(profileID.ToString()), ConstantSql.hrm_hr_sp_get_ContractsByProfileId, userLogin, ref status)
// .OrderByDescending(s => s.DateUpdate).FirstOrDefault();
////if (contractybyProfile == null)
////{
//// result = ConstantDisplay.HRM_Common_ProfileNotHaveContract.ToString();
//// return result;
////}
////if (contractybyProfile != null && contractybyProfile.ContractNextID == null)
////{
//// result = ConstantDisplay.HRM_Common_ProfileNotHaveNextContract.ToString();
//// return result;
////}
//if (contractybyProfile != null && contractybyProfile.ContractNextID != null)
//{
//var contractype = service.GetData<Cat_ContractTypeEntity>(Guid.Parse(Common.DotNetToOracle(contractybyProfile.ContractNextID.ToString())), ConstantSql.hrm_cat_sp_get_ContractTypeById, userLogin, ref status).FirstOrDefault();
//if (contractype == null)
//{
// result = ConstantDisplay.HRM_Common_ProfileNotHaveNextContract.ToString();
// return result;
//}
//Hre_ContractEntity contract = new Hre_ContractEntity();
//contract.ProfileID = profile.ID;
//contract.DateStart = dateEffect.Value;
//contract.DateSigned = dateEffect;
//contract.RankRateID = rankdetailID;
//contract.ClassRateID = salaryRank != null ? salaryRank.SalaryClassID : null;
//contract.Salary = salaryRank != null ? salaryRank.SalaryStandard : null;
//contract.ContractTypeID = contractype.ID;
//if (!string.IsNullOrEmpty(contractype.Formula))
//{
// contract = SetNewDateEndContract(contract,userLogin);
//}
//if (contractybyProfile.DateEndNextContract != null)
//{
// contractybyProfile.DateEnd = contractybyProfile.DateEndNextContract.Value;
//}
//contractservices.Add(contract);
// Thêm mới lương cơ bản + lương BHXH
string defaultcur = null;
string ConfigHre = AppConfig.HRM_HRE_CONFIG.ToString();
List<object> lstOb = new List<object>();
lstOb.Add(ConfigHre);
lstOb.Add(null);
lstOb.Add(null);
var config = GetData<Sys_AllSettingEntity>(lstOb, ConstantSql.hrm_sys_sp_get_AllSetting, userLogin, ref status);
string valueConfig = AppConfig.HRM_HRE_CONFIG_DEFAULTCURRENCY.ToString();
if (config != null)
{
defaultcur = config.Where(s => s.Name == valueConfig).Select(s => s.Value1).FirstOrDefault().ToString();
List<object> listObjCurrency = new List<object>();
listObjCurrency.Add(null);
listObjCurrency.Add(defaultcur);
listObjCurrency.Add(1);
listObjCurrency.Add(Int32.MaxValue - 1);
var lstCurrency = service.GetData<Cat_CurrencyEntity>(listObjCurrency, ConstantSql.hrm_cat_sp_get_Currency, userLogin, ref status).FirstOrDefault();
var basicsalarybyprofile = service.GetData<Sal_BasicSalaryEntity>(Common.DotNetToOracle(profileID.ToString()), ConstantSql.hrm_sal_sp_get_BasicSalaryByProfileIds, userLogin, ref status)
.OrderByDescending(s => s.DateOfEffect).FirstOrDefault();
var insuransalarybyprofile = service.GetData<Sal_InsuranceSalaryEntity>(Common.DotNetToOracle(profileID.ToString()), ConstantSql.hrm_sal_sp_get_InsuranceSalaryByProfileIds, userLogin, ref status)
.OrderByDescending(s => s.DateEffect).FirstOrDefault();
if (basicsalarybyprofile != null && salaryRank != null && basicsalarybyprofile.RankRateID != rankdetailID && salaryRank.SalaryClassID == basicsalarybyprofile.ClassRateID)
{
Sal_BasicSalaryEntity basicSalary = new Sal_BasicSalaryEntity();
basicSalary.ProfileID = profile.ID;
basicSalary.GrossAmount = (salaryRank != null && salaryRank.SalaryStandard != null) ? salaryRank.SalaryStandard.Value.ToString() : null;
basicSalary.Amount = basicSalary.GrossAmount != null ? basicSalary.GrossAmount.Encrypt() : "";
basicSalary.InsuranceAmount = (salaryRank != null && salaryRank.SalaryStandard != null) ? salaryRank.SalaryStandard.Value : 0;
basicSalary.DateOfEffect = dateEffect.Value;
basicSalary.CurrencyID = lstCurrency.ID;
basicSalary.Status = EnumDropDown.Sal_BasicSalaryStatus.E_WATTING_APPROVED.ToString();
basicSalary.AmountTotal = salaryRank != null ? salaryRank.SalaryStandard : null;
basicSalary.ClassRateID = salaryRank.SalaryClassID;
basicSalary.RankRateID = salaryRank.ID;
basicSalaryServices.Add(basicSalary);
if(insuransalarybyprofile != null)
{
Sal_InsuranceSalaryEntity insuranceSalary = new Sal_InsuranceSalaryEntity();
insuranceSalary.ProfileID = profile.ID;
insuranceSalary.InsuranceAmount = salaryRank != null ? salaryRank.SalaryStandard : null;
insuranceSalary.DateEffect = dateEffect;
insuranceSalary.CurrencyID = lstCurrency.ID;
insuranceSalary.IsSocialIns = insuransalarybyprofile.IsSocialIns;
insuranceSalary.IsMedicalIns = insuransalarybyprofile.IsMedicalIns;
insuranceSalary.IsUnimploymentIns = insuransalarybyprofile.IsUnimploymentIns;
InsuranceSalaryServices.Add(insuranceSalary);
}
}
else
{
profile.SalaryClassID = salaryRank == null ? Guid.Empty : salaryRank.SalaryClassID;
profile.AbilityTileID = _AbilitiTitleID;
profile.DateOfEffect = dateEffect;
service.Edit(profile);
var workHistoryEntity = service.GetData<Hre_WorkHistoryEntity>(Common.DotNetToOracle(profileID.ToString()), ConstantSql.hrm_hr_sp_get_WorkHistoryByProfileId, userLogin, ref status)
.OrderByDescending(s => s.DateEffective).FirstOrDefault();
if (workHistoryEntity == null || workHistoryEntity.DateEffective != dateEffect)
{
var workHistory = new Hre_WorkHistoryEntity();
workHistory.ProfileID = profile.ID;
workHistory.SalaryClassID = salaryRank != null ? salaryRank.SalaryClassID : null;
workHistory.DateEffective = dateEffect != null ? dateEffect.Value : DateTime.Now;
workHistory.AbilityTileID = _AbilitiTitleID;
service.Add(workHistory);
}
else
{
workHistoryEntity.SalaryClassID = salaryRank != null ? salaryRank.SalaryClassID : null;
workHistoryEntity.DateEffective = dateEffect != null ? dateEffect.Value : DateTime.Now;
workHistoryEntity.AbilityTileID = _AbilitiTitleID;
service.Edit(workHistoryEntity);
}
Sal_BasicSalaryEntity basicSalary = new Sal_BasicSalaryEntity();
basicSalary.ProfileID = profile.ID;
basicSalary.GrossAmount = (salaryRank != null && salaryRank.SalaryStandard != null) ? salaryRank.SalaryStandard.Value.ToString() : null;
basicSalary.Amount = basicSalary.GrossAmount != null ? basicSalary.GrossAmount.Encrypt() : "";
basicSalary.InsuranceAmount = (salaryRank != null && salaryRank.SalaryStandard != null) ? salaryRank.SalaryStandard.Value : 0;
basicSalary.AmountTotal = salaryRank != null ? salaryRank.SalaryStandard : null;
basicSalary.DateOfEffect = dateEffect.Value;
basicSalary.CurrencyID = lstCurrency.ID;
basicSalary.Status = EnumDropDown.Sal_BasicSalaryStatus.E_WATTING_APPROVED.ToString();
basicSalaryServices.Add(basicSalary);
if (insuransalarybyprofile != null)
{
Sal_InsuranceSalaryEntity insuranceSalary = new Sal_InsuranceSalaryEntity();
insuranceSalary.ProfileID = profile.ID;
insuranceSalary.InsuranceAmount = salaryRank != null ? salaryRank.SalaryStandard : null;
insuranceSalary.DateEffect = dateEffect;
insuranceSalary.CurrencyID = lstCurrency.ID;
insuranceSalary.IsSocialIns = insuransalarybyprofile.IsSocialIns;
insuranceSalary.IsMedicalIns = insuransalarybyprofile.IsMedicalIns;
insuranceSalary.IsUnimploymentIns = insuransalarybyprofile.IsUnimploymentIns;
InsuranceSalaryServices.Add(insuranceSalary);
}
}
}
return result;
}
}
public Hre_ContractModel Post([Bind]Hre_ContractModel model)
{
#region Validate
string message = string.Empty;
var checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "Hre_Contract", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
if (model.ContractEvaType == "E_ANNUAL_EVALUATION")
{
checkValidate = HRM.Business.Main.Domain.ValidatorService.OnValidateData<Hre_ContractModel>(model, "EvaContractinfo", "Hre_Contract", ref message);
if (!checkValidate)
{
model.ActionStatus = message;
return model;
}
}
#endregion
if(model.ID == Guid.Empty)
{
model.DateExtend = model.DateEnd;
}
if (model.CreateBasicSalary == true)
{
Sal_BasicSalaryServices salaryservices = new Sal_BasicSalaryServices();
Sal_BasicSalaryEntity basicSalaryBycontract = new Sal_BasicSalaryEntity();
basicSalaryBycontract.ProfileID = model.ProfileID;
basicSalaryBycontract.GrossAmount = model.Salary != null ? model.Salary.ToString() : "0";
basicSalaryBycontract.CurrencyID = model.CurenncyID != null ? model.CurenncyID.Value : Guid.Empty;
basicSalaryBycontract.PersonalRate = model.PersonalRate;
basicSalaryBycontract.DateOfEffect = model.DateStart;
basicSalaryBycontract.InsuranceAmount = model.InsuranceAmount != null ? model.InsuranceAmount.Value : 0;
basicSalaryBycontract.CurrencyID1 = model.CurenncyID1;
basicSalaryBycontract.ClassRateID = model.ClassRateID;
basicSalaryBycontract.RankRateID = model.RankRateID;
basicSalaryBycontract.AllowanceType1ID = model.AllowanceID1;
basicSalaryBycontract.AllowanceAmount1 = model.Allowance1;
basicSalaryBycontract.CurrencyID2 = model.CurenncyID2;
basicSalaryBycontract.AllowanceType2ID = model.AllowanceID2;
basicSalaryBycontract.AllowanceAmount2 = model.Allowance2;
basicSalaryBycontract.CurrencyID3 = model.CurenncyID3;
basicSalaryBycontract.AllowanceType3ID = model.AllowanceID3;
basicSalaryBycontract.AllowanceAmount3 = model.Allowance3;
basicSalaryBycontract.CurrencyID4 = model.CurenncyIDSalary;
salaryservices.Add(basicSalaryBycontract);
}
ActionService service = new ActionService(UserLogin);
return service.UpdateOrCreate<Hre_ContractEntity, Hre_ContractModel>(model);
}
