/// <summary>
/// [Son.Vo] - 20140724 - BC Thanh Toán Trợ Cấp Ăn Ca Cho Nhân Viên
/// </summary>
/// <param name="CarteringIDs"></param>
/// <param name="CanteenIDS"></param>
/// <param name="LineIDS"></param>
/// <param name="DateFrom"></param>
/// <param name="DateTo"></param>
/// <returns></returns>
public List<Can_ReportAdjustmentMealAllowancePaymentEntity> ReportAdjustmentMealAllowancePayment(DateTime DateFrom, DateTime DateTo, List<int> lstProfileIDs)
{
#region GetData
var lstMealRecord = new List<Can_MealRecord>().Select(s => new { s.CardCode, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.Amount, s.MealAllowanceType, s.NoWorkDay }).ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_MealRecordRepository(unitOfWork);
lstMealRecord = repo.FindBy(m => m.TimeLog >= DateFrom || m.TimeLog <= DateTo && m.CardCode != null).Select(
s => new { s.CardCode, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.Amount, s.MealAllowanceType, s.NoWorkDay }).ToList();
}
var cardcode = lstMealRecord.Select(s => s.CardCode).Distinct().ToList();
var profiles = new List<Hre_Profile>().Select(s => new { s.Id, s.DateQuit, s.OrgStructureID, s.ProfileName, s.CodeAttendance, s.CodeEmp, s.PositionID, s.JobTitleID }).ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Hre_ProfileRepository(unitOfWork);
profiles = repo.FindBy(s => cardcode.Contains(s.CodeAttendance)).Select(s => new { s.Id, s.DateQuit, s.OrgStructureID, s.ProfileName, s.CodeAttendance, s.CodeEmp, s.PositionID, s.JobTitleID }).ToList();
}
var mealAllowanceTypeSantandIDs = new List<Can_MealAllowanceTypeSetting>().Select(m=> m.Id).ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_MealAllowanceTypeSettingRepository(unitOfWork);
mealAllowanceTypeSantandIDs = repo.FindBy(s => s.Standard == true).Select(m=> m.Id).ToList();
}
var lineHDTJobIDs = new List<Can_Line>().Select(m => m.Id).ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_LineRepository(unitOfWork);
lineHDTJobIDs = repo.FindBy(s => s.LineHDTJOB != null).Select(m => m.Id).ToList();
}
var lines = new List<Can_Line>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_LineRepository(unitOfWork);
lines = repo.GetAll().ToList();
}
var lstOrgAll = new List<Cat_OrgStructure>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Cat_OrgStructureRepository(unitOfWork);
lstOrgAll = repo.GetAll().ToList();
}
#endregion
List<Can_ReportAdjustmentMealAllowancePaymentEntity> lstReportAdjustmentMealAllowancePayment = new List<Can_ReportAdjustmentMealAllowancePaymentEntity>();
foreach (var profile in profiles)
{
Can_ReportAdjustmentMealAllowancePaymentEntity ReportAdjustmentMealAllowancePayment = new Can_ReportAdjustmentMealAllowancePaymentEntity();
var orgbyprofile = lstOrgAll.Where(m => m.Id == profile.OrgStructureID).Select(m => m.OrgStructureName).FirstOrDefault();
ReportAdjustmentMealAllowancePayment.CodeEmp = profile.CodeEmp;
ReportAdjustmentMealAllowancePayment.ProfileName = profile.ProfileName;
ReportAdjustmentMealAllowancePayment.OrgStructureName = orgbyprofile;
var mealProfiles = lstMealRecord.Where(s => s.CardCode == profile.CodeAttendance).ToList();
if (mealProfiles.Count > 0)
{
var line = lines.FirstOrDefault(s => s.Id == mealProfiles[0].LineID);
if (line != null)
{
ReportAdjustmentMealAllowancePayment.TotalAdditionalAmount = mealProfiles.Count * line.Amount;
}
ReportAdjustmentMealAllowancePayment.TotalMealTime = mealProfiles.Where(m => m.MealAllowanceType != null
&& mealAllowanceTypeSantandIDs.Contains(m.MealAllowanceType)).Count();
ReportAdjustmentMealAllowancePayment.TotalDeductionAmount = mealProfiles.Where(m => m.MealAllowanceType != null
&& mealAllowanceTypeSantandIDs.Contains(m.MealAllowanceType)).Sum(m => m.Amount.Value);
var countCardMore1 = 0;
double? AmountSubtractCardMore1 = 0;
for (DateTime date = DateFrom; date <= DateTo; date = date.AddDays(1))
{
if (mealProfiles.Count(s => s.TimeLog == date) > 1)
{
countCardMore1++;
var meal = mealProfiles.FirstOrDefault(s => s.TimeLog == date);
if (meal != null)
{
AmountSubtractCardMore1 += meal.Amount;
}
}
}
ReportAdjustmentMealAllowancePayment.TotalScanManyTime = countCardMore1;
ReportAdjustmentMealAllowancePayment.TotalDeductionScanManyTime = AmountSubtractCardMore1.Value;
ReportAdjustmentMealAllowancePayment.TotalNotWorkButEatTime = mealProfiles.Count(s => s.NoWorkDay == true);
ReportAdjustmentMealAllowancePayment.TotalNotWorkButEatAmount = mealProfiles.Sum(s => s.Amount.Value);
ReportAdjustmentMealAllowancePayment.TotalNotWorkButEatAmount = mealProfiles.Sum(s => s.Amount.Value);
}
lstReportAdjustmentMealAllowancePayment.Add(ReportAdjustmentMealAllowancePayment);
}
return lstReportAdjustmentMealAllowancePayment;
}
public bool SaveSumryMealRecord(Guid CutOffDurationID, List<Guid> lstProfileIDs)
{
using (var context = new VnrHrmDataContext())
{
try
{
#region GetData
List<Can_ReportAdjustmentMealAllowancePaymentEntity> lstReportAdjustmentMealAllowancePayment = new List<Can_ReportAdjustmentMealAllowancePaymentEntity>();
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoMealRecord = new Can_MealRecordRepository(unitOfWork);
var cutoffdurationRepository = new Att_CutOffDurationRepository(unitOfWork);
var Cutoffduration = cutoffdurationRepository.FindBy(m => m.ID == CutOffDurationID && m.IsDelete != true).FirstOrDefault();
DateTime DateFrom = new DateTime();
DateTime DateTo = new DateTime();
if (Cutoffduration != null)
{
DateFrom = Cutoffduration.DateStart;
DateTo = Cutoffduration.DateEnd.AddDays(1).AddMilliseconds(-1);
}
var sumryMealRecordRepository = new Can_SumryMealRecordRepository(unitOfWork);
var lstMealRecord = repoMealRecord.FindBy(m => m.WorkDay != null && m.WorkDay >= DateFrom && m.WorkDay <= DateTo && m.ProfileID != null)
.Select(s => new { s.ProfileID, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.Amount, s.MealAllowanceTypeID, s.NoWorkDay }).ToList();
if (lstMealRecord.Count < 0)
{
return true;
}
var status = StatusMealAllowanceToMoney.E_APPROVED.ToString();
#region Dư ko dùng
//var repoAllowanceToMoney = new Can_MealAllowanceToMoneyRepository(unitOfWork);
//var mealAllowncaToMoneyProfileIDs = repoAllowanceToMoney.FindBy(s => s.Status == status && s.ProfileID != null && DateFrom <= s.DateTo && s.DateFrom <= DateTo).ToList();
#endregion
var lstProfileIdsByMeal = lstMealRecord.Select(s => s.ProfileID).Distinct().ToList();
var repoprofiles = new Hre_ProfileRepository(unitOfWork);
var profiles = repoprofiles.FindBy(s => lstProfileIdsByMeal.Contains(s.ID)).Select(s => new { s.ID, s.DateQuit, s.OrgStructureID, s.ProfileName, s.CodeAttendance, s.CodeEmp, s.PositionID, s.JobTitleID }).ToList();
if (lstProfileIDs != null && lstProfileIDs.Count > 0)
{
profiles = profiles.Where(m => lstProfileIDs.Contains(m.ID)).ToList();
}
var repomealAllowanceType = new Can_MealAllowanceTypeSettingRepository(unitOfWork);
var mealAllowanceTypeSantandIDs = repomealAllowanceType.FindBy(s => s.Standard == true).Select(m => m.ID).ToList();
var mealAllowanceTypes = repomealAllowanceType.FindBy(s => s.IsDelete == null).ToList();
var amountStardand = repomealAllowanceType.FindBy(s => s.Standard == true && s.Amount != null).Select(s => s.Amount.Value).FirstOrDefault();
var repoLineHDTJob = new Can_LineRepository(unitOfWork);
var lineHDTJobIDs = repoLineHDTJob.FindBy(s => s.HDTJ != null).Select(m => m.ID).ToList();
var repoHDTJob = new Hre_HDTJobRepository(unitOfWork);
var profileHDTJs = repoHDTJob.FindBy(s => DateFrom <= s.DateTo && s.DateFrom <= DateTo)
.Select(s => new { s.ProfileID, s.Type, s.DateFrom, s.DateTo }).ToList();
var profileHDTJIDs = profileHDTJs.Select(s => s.ProfileID).Distinct().ToList();
string approveKey = MealRecord_Status.E_APPROVED.ToString();
var repo_MealRecordMissing = new Can_MealRecordMissingRepository(unitOfWork);
var mealRecordMissings = repo_MealRecordMissing.FindBy(s => s.Status == approveKey && DateFrom <= s.WorkDate && s.WorkDate <= DateTo)
.Select(s => new { s.ProfileID, s.WorkDate, s.MealAllowanceTypeSettingID, s.TamScanReasonMissID, s.Amount }).ToList();
var repoWorkDay = new Att_WorkDayRepository(unitOfWork);
var dateStart1 = DateFrom.AddDays(-1);
var workDays = repoWorkDay.FindBy(s => dateStart1 <= s.WorkDate && s.WorkDate <= DateTo).Select(s => new { s.ProfileID, s.FirstInTime, s.LastOutTime, s.ShiftID, s.WorkDate }).ToList();
var workDayProfies = workDays.Where(s => s.FirstInTime != null || s.LastOutTime != null).ToList();
var repotamScan = new Cat_TAMScanReasonMissRepository(unitOfWork);
var tamSans = repotamScan.GetAll().ToList();
var tamScanNotFullPayIDs = tamSans.Where(s => s.IsFullPay == null || s.IsFullPay == false).Select(s => s.ID).ToList();
var reposhift = new Cat_ShiftRepository(unitOfWork);
var shifts = reposhift.GetAll().ToList();
var lines = new List<Can_Line>().ToList();
var repolines = new Can_LineRepository(unitOfWork);
lines = repolines.GetAll().ToList();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrg.GetAll().ToList();
var orgTypes = new List<Cat_OrgStructureType>();
var repoorgType = new Cat_OrgStructureTypeRepository(unitOfWork);
orgTypes = repoorgType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
#endregion
foreach (var profile in profiles)
{
var mealProfiles = lstMealRecord.Where(s => s.ProfileID == profile.ID).ToList();
#region Dư ko dùng
//var mealAllownProfiles = mealAllowncaToMoneyProfileIDs.Where(s => s.ProfileID == profile.ID).ToList();
//var mealNotStardands = lstMealRecord.Where(s => s.ProfileID == profile.ID && s.Amount > amountStardand).ToList();
#endregion
Can_ReportAdjustmentMealAllowancePaymentEntity ReportAdjustmentMealAllowancePayment = new Can_ReportAdjustmentMealAllowancePaymentEntity();
Guid? orgId = profile.OrgStructureID;
var org = orgs.FirstOrDefault(s => s.ID == profile.OrgStructureID);
var orgBranch = LibraryService.GetNearestParent(orgId, OrgUnit.E_DIVISION, orgs, orgTypes);
var orgOrg = LibraryService.GetNearestParent(orgId, OrgUnit.E_DEPARTMENT, orgs, orgTypes);
var orgTeam = LibraryService.GetNearestParent(orgId, OrgUnit.E_SECTION, orgs, orgTypes);
var orgSection = LibraryService.GetNearestParent(orgId, OrgUnit.E_GROUP, orgs, orgTypes);
ReportAdjustmentMealAllowancePayment.BranchName = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
ReportAdjustmentMealAllowancePayment.DepartmentName = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
ReportAdjustmentMealAllowancePayment.TeamName = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
ReportAdjustmentMealAllowancePayment.SectionName = orgSection != null ? orgSection.OrgStructureName : string.Empty;
ReportAdjustmentMealAllowancePayment.CodeEmp = profile.CodeEmp;
ReportAdjustmentMealAllowancePayment.ProfileName = profile.ProfileName;
ReportAdjustmentMealAllowancePayment.DateFrom = DateFrom;
ReportAdjustmentMealAllowancePayment.DateTo = DateTo;
ReportAdjustmentMealAllowancePayment.DatePrint = DateTime.Now;
var countCard = 0;
var sumCard = 0.0;
int countCardMore1 = 0;
var countNotWorkButHasEat = 0;
var sumNotWorkButHasEat = 0.0;
var countmealNotStardand = 0;
var amountmealNotStardand = 0.0;
var countHDTJ = 0;
var amountHDTJ = 0.0;
var countNotStandHDTJ = 0;
var amountNotStandHDTJ = 0.0;
int amount3OnMonth = 0;
var workdayProfileDates = workDayProfies.Where(s => s.ProfileID == profile.ID).Select(s => s.WorkDate.Date).ToList();
for (DateTime date = DateFrom; date <= DateTo; date = date.AddDays(1))
{
var workDay = workDays.FirstOrDefault(s => s.ProfileID == profile.ID && s.WorkDate.Date == date.Date);
var shift = shifts.FirstOrDefault(s => workDay != null && s.ID == workDay.ShiftID);
var missing = mealRecordMissings.FirstOrDefault(s => s.ProfileID == profile.ID && s.WorkDate.Value.Date == date.Date);
if (missing != null)
{
if (missing.MealAllowanceTypeSettingID != null && missing.TamScanReasonMissID == null)
{
countCard++;
sumCard += (double)(missing.Amount != null ? missing.Amount.Value : 0);
}
else if (missing.TamScanReasonMissID != null)
{
var tamscan = tamSans.FirstOrDefault(s => s.ID == missing.TamScanReasonMissID);
if (tamscan != null)
{
if (tamscan.IsFullPay == true)
{
countCard++;
sumCard += (double)amountStardand;
}
else
{
amount3OnMonth++;
}
}
}
}
if (mealProfiles.Count(s => s.TimeLog != null && s.TimeLog.Value.Date == date.Date) > 1)
{
countCardMore1++;
}
var record = lstMealRecord.FirstOrDefault(s => s.TimeLog != null && s.LineID != null && !lineHDTJobIDs.Contains(s.LineID.Value)
&& s.ProfileID == profile.ID && date.Date == s.TimeLog.Value.Date && !workdayProfileDates.Contains(date.Date));
if (record != null)
{
countNotWorkButHasEat++;
sumNotWorkButHasEat += (double)(record.Amount != null ? record.Amount.Value : 0);
}
var meal = lstMealRecord.FirstOrDefault(s => s.TimeLog != null && s.Amount > amountStardand && s.LineID != null && !lineHDTJobIDs.Contains(s.LineID.Value)
&& s.ProfileID == profile.ID && s.TimeLog.Value.Date == date.Date && workdayProfileDates.Contains(date.Date));
if (meal != null)
{
countmealNotStardand++;
amountmealNotStardand += (double)(meal.Amount != null ? meal.Amount.Value : 0);
}
var mealHDT = lstMealRecord.FirstOrDefault(s => s.ProfileID == profile.ID && s.LineID != null && lineHDTJobIDs.Contains(s.LineID.Value) && s.TimeLog != null &&
s.TimeLog.Value.Date == date.Date && (!profileHDTJIDs.Contains(s.ProfileID.Value) || (profileHDTJIDs.Contains(s.ProfileID.Value) && !workdayProfileDates.Contains(date.Date))));
if (mealHDT != null)
{
countHDTJ++;
amountHDTJ += (double)(mealHDT.Amount != null ? mealHDT.Amount.Value : 0);
}
var mealNotStandandHDT = lstMealRecord.FirstOrDefault(s => s.ProfileID != null && s.ProfileID == profile.ID && s.LineID != null && lineHDTJobIDs.Contains(s.LineID.Value) &&
s.TimeLog != null && s.TimeLog.Value.Date == date.Date && profileHDTJIDs.Contains(s.ProfileID.Value) && workdayProfileDates.Contains(date.Date));
if (mealNotStandandHDT != null && mealNotStandandHDT.LineID != null)
{
var line = lines.FirstOrDefault(s => s.ID == mealNotStandandHDT.LineID);
var hdtjob = profileHDTJs.FirstOrDefault(s => s.Type != null && s.ProfileID == profile.ID && s.DateFrom.Value.Date <= date.Date && date.Date <= s.DateTo.Value.Date);
if (line != null && line.HDTJ != null && hdtjob.Type != line.HDTJ)
{
var lineHDT = lines.FirstOrDefault(s => s.HDTJ == hdtjob.Type);
if (lineHDT != null && lineHDT.Amount != null && lineHDT.Amount < line.Amount)
{
countNotStandHDTJ++;
var lineAmount = line.Amount != null ? line.Amount.Value : 0;
var lineAmountHDT = lineHDT.Amount != null ? lineHDT.Amount.Value : 0;
amountNotStandHDTJ += (double)(lineAmount - lineAmountHDT);
}
}
}
double countMiss = mealRecordMissings.Count(s => s.ProfileID == profile.ID && s.TamScanReasonMissID != null && tamScanNotFullPayIDs.Contains(s.TamScanReasonMissID.Value));
countMiss = GetCountAmount((int)countMiss);
if (countCard > 0)
{
ReportAdjustmentMealAllowancePayment.TotalMealAllowance = countCard + countMiss;
}
if (sumCard > 0)
{
ReportAdjustmentMealAllowancePayment.SumAmount = (double)(sumCard + countMiss * (double)amountStardand);
}
if (countmealNotStardand > 0)
{
ReportAdjustmentMealAllowancePayment.CountEatNotStandar = countmealNotStardand;
ReportAdjustmentMealAllowancePayment.AmountEatNotStandar = amountmealNotStardand - (double)(amountStardand * countmealNotStardand);
}
if (countCardMore1 > 0)
{
ReportAdjustmentMealAllowancePayment.CountCardMore = countCardMore1;
ReportAdjustmentMealAllowancePayment.SumCardMore = (double)Math.Round(countCardMore1 * amountStardand, 2);
}
if (countNotWorkButHasEat > 0)
{
ReportAdjustmentMealAllowancePayment.CountNotWorkHasEat = countNotWorkButHasEat;
ReportAdjustmentMealAllowancePayment.AmountNotWorkHasEat = sumNotWorkButHasEat;
}
amount3OnMonth = amount3OnMonth - (int)GetCountAmount(amount3OnMonth);
if (amount3OnMonth > 0)
{
ReportAdjustmentMealAllowancePayment.Amount3OnMonth = amount3OnMonth;
}
if (countHDTJ > 0)
{
ReportAdjustmentMealAllowancePayment.CountHDTJob = countHDTJ;
ReportAdjustmentMealAllowancePayment.AmounSubtractHDTJob = amountHDTJ;
}
if (countNotStandHDTJ > 0)
{
ReportAdjustmentMealAllowancePayment.CountCardWorngStandar = countNotStandHDTJ;
ReportAdjustmentMealAllowancePayment.AmountSubtractWorngStandar = amountNotStandHDTJ;
}
}
Can_SumryMealRecord sumryMealRecordNew = new Can_SumryMealRecord();
sumryMealRecordNew.ProfileID = profile.ID;
sumryMealRecordNew.DateFrom = Cutoffduration.DateStart;
sumryMealRecordNew.DateTo = Cutoffduration.DateEnd;
sumryMealRecordNew.TotalMealAllowance = ReportAdjustmentMealAllowancePayment.TotalMealAllowance;
sumryMealRecordNew.SumAmount = ReportAdjustmentMealAllowancePayment.SumAmount;
sumryMealRecordNew.CountEatNotStandar = ReportAdjustmentMealAllowancePayment.CountEatNotStandar;
sumryMealRecordNew.AmountEatNotStandar = ReportAdjustmentMealAllowancePayment.AmountEatNotStandar;
sumryMealRecordNew.CountCardMore = ReportAdjustmentMealAllowancePayment.CountCardMore;
sumryMealRecordNew.SumAmountCardMore = ReportAdjustmentMealAllowancePayment.SumCardMore;
sumryMealRecordNew.CountNotWorkHasEat = ReportAdjustmentMealAllowancePayment.CountNotWorkHasEat;
sumryMealRecordNew.AmountNotWorkHasEat = ReportAdjustmentMealAllowancePayment.AmountNotWorkHasEat;
sumryMealRecordNew.Amount3OnMonth = ReportAdjustmentMealAllowancePayment.Amount3OnMonth;
sumryMealRecordNew.CountHDTJob = ReportAdjustmentMealAllowancePayment.CountHDTJob;
sumryMealRecordNew.AmountHDTJob = ReportAdjustmentMealAllowancePayment.AmounSubtractHDTJob;
sumryMealRecordNew.AmountNotWorkButHasHDT = ReportAdjustmentMealAllowancePayment.AmountNotWorkButHasHDT;
sumryMealRecordNew.CountSubtractWorngStandarHDT = ReportAdjustmentMealAllowancePayment.CountSubtractWorngStandarHDT;
sumryMealRecordNew.AmountSubtractWorngStandarHDT = ReportAdjustmentMealAllowancePayment.AmountSubtractWorngStandarHDT;
sumryMealRecordRepository.Add(sumryMealRecordNew);
lstReportAdjustmentMealAllowancePayment.Add(ReportAdjustmentMealAllowancePayment);
if (profiles.IndexOf(profile) % 1000 == 0)
{
sumryMealRecordRepository.SaveChanges();
}
}
sumryMealRecordRepository.SaveChanges();
}
catch (Exception)
{
return false;
}
}
return true;
}
