/// <summary>
/// [Son.Vo] - 20140724 - Lấy dữ liệu BC Tổng Hợp Suất Ăn Của 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_ReportMealTimeSummaryEntity> ReportMealTimeSummary(List <int?> CarteringIDs, List <int?> CanteenIDS, List <int?> LineIDS, DateTime DateFrom, DateTime DateTo)
{
#region GetData
var lstMealRecord = new List <Can_MealRecord>().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).ToList();
}
var lstCanteens = new List <Can_Canteen>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_CanteenRepository(unitOfWork);
if (CanteenIDS != null)
{
lstCanteens = repo.FindBy(s => CanteenIDS.Contains(s.Id)).ToList();
}
else
{
lstCanteens = repo.GetAll().ToList();
}
}
var lstCaterings = new List <Can_Catering>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_CateringRepository(unitOfWork);
if (CarteringIDs != null)
{
lstCaterings = repo.FindBy(s => CarteringIDs.Contains(s.Id)).ToList();
}
else
{
lstCaterings = repo.GetAll().ToList();
}
}
var lstLines = new List <Can_Line>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_LineRepository(unitOfWork);
if (LineIDS != null)
{
lstLines = repo.FindBy(s => LineIDS.Contains(s.Id)).ToList();
}
else
{
lstLines = repo.GetAll().ToList();
}
}
#endregion
List <Can_ReportMealTimeSummaryEntity> lstReportMealTimeSummary = new List <Can_ReportMealTimeSummaryEntity>();
foreach (var cate in lstCaterings)
{
Can_ReportMealTimeSummaryEntity ReportAdjustmentMealAllowancePayment = new Can_ReportMealTimeSummaryEntity();
ReportAdjustmentMealAllowancePayment.Catering = cate.CateringName;
foreach (var item in lstCanteens)
{
ReportAdjustmentMealAllowancePayment.Canteen = item.CanteenName;
foreach (var line in lstLines)
{
ReportAdjustmentMealAllowancePayment.Line = line.LineName;
ReportAdjustmentMealAllowancePayment.Price = line.Amount.Value;
var sum = lstMealRecord.Where(s => s.CateringID == cate.Id && s.CanteenID == cate.Id && s.LineID == line.Id).Sum(s => s.Amount);
var rate = lstMealRecord.Where(s => s.CateringID == cate.Id && s.LineID == line.Id).Sum(s => s.Amount) / sum;
ReportAdjustmentMealAllowancePayment.TotalAmount = sum != null ? sum.Value : 0;
ReportAdjustmentMealAllowancePayment.Rate = rate != null ? rate.Value : 0;
}
}
lstReportMealTimeSummary.Add(ReportAdjustmentMealAllowancePayment);
}
return(lstReportMealTimeSummary);
}
public DataTable ReportMultiSlideCard(List<int?> CarteringIDs, List<int?> CanteenIDS, List<int?> LineIDS, DateTime dateStart, DateTime dateEnd, List<int> lstProfileIds)
{
List<Can_ReportMultiSlideCardEntity> lstReportMultiSlideCard = new List<Can_ReportMultiSlideCardEntity>();
DataTable datatable = CreateReportMultiSlideCardSchema(dateStart, dateEnd);
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var mealRecords = new List<Can_MealRecord>().Select(s => new { s.CardCode, s.TimeLog, s.CanteenID, s.CateringID, s.LineID }).ToList();
var repo = new Can_MealRecordRepository(unitOfWork);
mealRecords = repo.FindBy(s => s.CardCode != null && dateStart <= s.TimeLog && s.TimeLog <= dateEnd && s.NoWorkDay == true)
.Select(s => new { s.CardCode, s.TimeLog, s.CanteenID, s.CateringID, s.LineID }).ToList();
var lstcateringids = mealRecords.Select(m =>m.CateringID).ToList();
var lstcanteenids = mealRecords.Select(m =>m.CanteenID).ToList();
var lstlineids = mealRecords.Select(m => m.LineID).ToList();
var workDays = new List<Att_WorkDay>().Select(s => new { s.ProfileID, s.WorkDate }).ToList();
var repoWorkDay = new Att_WorkDayRepository(unitOfWork);
workDays = repoWorkDay.FindBy(s => s.ProfileID != null && dateStart <= s.WorkDate && s.WorkDate <= dateEnd)
.Select(s => new { s.ProfileID, s.WorkDate }).ToList();
var Cardcode = mealRecords.Select(s => s.CardCode).Distinct().ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(m => Cardcode.Contains(m.CodeAttendance) && lstProfileIds.Contains(m.Id)).Select(s => new { s.Id, s.DateQuit, s.OrgStructureID, s.ProfileName, s.CodeEmp, s.CodeAttendance }).ToList();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrg.FindBy(m => m.Code != null).ToList();
var catering = new List<Can_Catering>().ToList();
var repocatering = new Can_CateringRepository(unitOfWork);
if(CarteringIDs != null && CarteringIDs.Count >0)
{
catering = repocatering.FindBy(m => CarteringIDs.Contains(m.Id)).ToList();
}
else
catering = repocatering.GetAll().ToList();
var canteen = new List<Can_Canteen>().ToList();
var repocanteen = new Can_CanteenRepository(unitOfWork);
if (CanteenIDS != null && CanteenIDS.Count > 0)
{
canteen = repocanteen.FindBy(m => CanteenIDS.Contains(m.Id)).ToList();
}
else
canteen = repocanteen.GetAll().ToList();
var line = new List<Can_Line>().ToList();
var repoline = new Can_LineRepository(unitOfWork);
if (LineIDS != null && LineIDS.Count > 0)
{
line = repoline.FindBy(m => LineIDS.Contains(m.Id)).ToList();
}
else
line = repoline.GetAll().ToList();
Can_ReportMultiSlideCardEntity ReportMultiSlideCardEntity = new Can_ReportMultiSlideCardEntity();
foreach (var profile in profiles)
{
DataRow row = datatable.NewRow();
var orgbyprofile = orgs.Where(m => m.Id == profile.OrgStructureID).FirstOrDefault();
var cateringbyprofile = catering.Where(m => lstcateringids.Contains(m.Id)).FirstOrDefault();
var lineprofile = line.Where(m => lstlineids.Contains(m.Id)).FirstOrDefault();
var canteenbyprofile = canteen.Where(m => lstcanteenids.Contains(m.Id)).FirstOrDefault();
row[Can_ReportMultiSlideCardEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportMultiSlideCardEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportMultiSlideCardEntity.FieldNames.OrgStructureName] = orgbyprofile.OrgStructureName;
row[Can_ReportMultiSlideCardEntity.FieldNames.Cartering] = cateringbyprofile.CateringName;
row[Can_ReportMultiSlideCardEntity.FieldNames.Canteen] = canteenbyprofile.CanteenName;
row[Can_ReportMultiSlideCardEntity.FieldNames.Line] = lineprofile.LineName;
var mealRecordProfiles = mealRecords.Where(s => s.CardCode == profile.CodeAttendance).ToList();
var workDayProfiles = workDays.Where(s => s.ProfileID == profile.Id).ToList();
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var meal = mealRecords.FirstOrDefault(s => s.CardCode == profile.CodeAttendance && s.TimeLog == date);
if (meal != null)
{
row["Date" + date.Day] = (object)meal.TimeLog ?? DBNull.Value;
//row["SumCardMore" + date.Day] = mealRecordProfiles.Count(s => s.TimeLog == date) - workDayProfiles.Count(s => s.WorkDate == date);
}
}
datatable.Rows.Add(row);
}
}
return datatable;
}
public DataTable ReportMultiSlideCard(List <int?> CarteringIDs, List <int?> CanteenIDS, List <int?> LineIDS, DateTime dateStart, DateTime dateEnd, List <int> lstProfileIds)
{
List <Can_ReportMultiSlideCardEntity> lstReportMultiSlideCard = new List <Can_ReportMultiSlideCardEntity>();
DataTable datatable = CreateReportMultiSlideCardSchema(dateStart, dateEnd);
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var mealRecords = new List <Can_MealRecord>().Select(s => new { s.CardCode, s.TimeLog, s.CanteenID, s.CateringID, s.LineID }).ToList();
var repo = new Can_MealRecordRepository(unitOfWork);
mealRecords = repo.FindBy(s => s.CardCode != null && dateStart <= s.TimeLog && s.TimeLog <= dateEnd && s.NoWorkDay == true)
.Select(s => new { s.CardCode, s.TimeLog, s.CanteenID, s.CateringID, s.LineID }).ToList();
var lstcateringids = mealRecords.Select(m => m.CateringID).ToList();
var lstcanteenids = mealRecords.Select(m => m.CanteenID).ToList();
var lstlineids = mealRecords.Select(m => m.LineID).ToList();
var workDays = new List <Att_WorkDay>().Select(s => new { s.ProfileID, s.WorkDate }).ToList();
var repoWorkDay = new Att_WorkDayRepository(unitOfWork);
workDays = repoWorkDay.FindBy(s => s.ProfileID != null && dateStart <= s.WorkDate && s.WorkDate <= dateEnd)
.Select(s => new { s.ProfileID, s.WorkDate }).ToList();
var Cardcode = mealRecords.Select(s => s.CardCode).Distinct().ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(m => Cardcode.Contains(m.CodeAttendance) && lstProfileIds.Contains(m.Id)).Select(s => new { s.Id, s.DateQuit, s.OrgStructureID, s.ProfileName, s.CodeEmp, s.CodeAttendance }).ToList();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrg.FindBy(m => m.Code != null).ToList();
var catering = new List <Can_Catering>().ToList();
var repocatering = new Can_CateringRepository(unitOfWork);
if (CarteringIDs != null && CarteringIDs.Count > 0)
{
catering = repocatering.FindBy(m => CarteringIDs.Contains(m.Id)).ToList();
}
else
{
catering = repocatering.GetAll().ToList();
}
var canteen = new List <Can_Canteen>().ToList();
var repocanteen = new Can_CanteenRepository(unitOfWork);
if (CanteenIDS != null && CanteenIDS.Count > 0)
{
canteen = repocanteen.FindBy(m => CanteenIDS.Contains(m.Id)).ToList();
}
else
{
canteen = repocanteen.GetAll().ToList();
}
var line = new List <Can_Line>().ToList();
var repoline = new Can_LineRepository(unitOfWork);
if (LineIDS != null && LineIDS.Count > 0)
{
line = repoline.FindBy(m => LineIDS.Contains(m.Id)).ToList();
}
else
{
line = repoline.GetAll().ToList();
}
Can_ReportMultiSlideCardEntity ReportMultiSlideCardEntity = new Can_ReportMultiSlideCardEntity();
foreach (var profile in profiles)
{
DataRow row = datatable.NewRow();
var orgbyprofile = orgs.Where(m => m.Id == profile.OrgStructureID).FirstOrDefault();
var cateringbyprofile = catering.Where(m => lstcateringids.Contains(m.Id)).FirstOrDefault();
var lineprofile = line.Where(m => lstlineids.Contains(m.Id)).FirstOrDefault();
var canteenbyprofile = canteen.Where(m => lstcanteenids.Contains(m.Id)).FirstOrDefault();
row[Can_ReportMultiSlideCardEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportMultiSlideCardEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportMultiSlideCardEntity.FieldNames.OrgStructureName] = orgbyprofile.OrgStructureName;
row[Can_ReportMultiSlideCardEntity.FieldNames.Cartering] = cateringbyprofile.CateringName;
row[Can_ReportMultiSlideCardEntity.FieldNames.Canteen] = canteenbyprofile.CanteenName;
row[Can_ReportMultiSlideCardEntity.FieldNames.Line] = lineprofile.LineName;
var mealRecordProfiles = mealRecords.Where(s => s.CardCode == profile.CodeAttendance).ToList();
var workDayProfiles = workDays.Where(s => s.ProfileID == profile.Id).ToList();
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var meal = mealRecords.FirstOrDefault(s => s.CardCode == profile.CodeAttendance && s.TimeLog == date);
if (meal != null)
{
row["Date" + date.Day] = (object)meal.TimeLog ?? DBNull.Value;
//row["SumCardMore" + date.Day] = mealRecordProfiles.Count(s => s.TimeLog == date) - workDayProfiles.Count(s => s.WorkDate == date);
}
}
datatable.Rows.Add(row);
}
}
return(datatable);
}
public DataTable ReportDetailCard(List<Guid?> cateringIDs, List<Guid?> canteenIDs, List<Guid?> lineIDs, DateTime dateStart, DateTime dateEndSearch, List<Guid?> orgIDs)
{
DataTable datatable = CreateReportDetailCardSchema(dateStart, dateEndSearch);
using (var context = new VnrHrmDataContext())
{
#region get data
DateTime dateEnd = dateEndSearch.AddDays(1).AddMilliseconds(-1);
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_MealRecord = new Can_MealRecordRepository(unitOfWork);
var mealRecords = repoCan_MealRecord.FindBy(s => s.ProfileID != null && s.WorkDay != null &&
dateStart <= s.WorkDay && s.WorkDay <= dateEnd).Select(s =>
new { s.ProfileID, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.Amount, s.MealAllowanceTypeID, s.WorkDay }).ToList();
if (mealRecords != null && mealRecords.Count < 1)
{
return datatable;
}
var profileIdsByMealRecord = mealRecords.Select(s => s.ProfileID).Distinct().ToList();
var repoHre_Profile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoHre_Profile.FindBy(s => profileIdsByMealRecord.Contains(s.ID)).ToList();
var repoCan_Line = new Can_LineRepository(unitOfWork);
var repoCan_Canteen = new Can_CanteenRepository(unitOfWork);
var repoCan_Catering = new Can_CateringRepository(unitOfWork);
var repoCat_OrgStructure = new Cat_OrgStructureRepository(unitOfWork);
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
var orgs = repoCat_OrgStructure.FindBy(s => s.Code != null).ToList();
var lstallLine = repoCan_Line.GetAll().ToList();
var lstallCatering = repoCan_Catering.GetAll().ToList();
var lstallCanteen = repoCan_Canteen.GetAll().ToList();
var orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
if (orgIDs != null && orgIDs[0] != null)
{
profiles = profiles.Where(s => s.OrgStructureID != null && orgIDs.Contains(s.OrgStructureID.Value)).ToList();
}
if (canteenIDs != null && canteenIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CanteenID != null && canteenIDs.Contains(s.CanteenID.Value)).ToList();
}
if (cateringIDs != null && cateringIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CateringID != null && cateringIDs.Contains(s.CateringID.Value)).ToList();
}
if (lineIDs != null && lineIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.LineID != null && lineIDs.Contains(s.LineID.Value)).ToList();
}
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
#endregion
foreach (var profile in profiles)
{
var mealRecordByProfile = mealRecords.Where(m => m.ProfileID != null && m.ProfileID.Value == profile.ID).ToList();
if (mealRecordByProfile == null && mealRecordByProfile.Count() == 0)
continue;
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var lstMealByPro = mealRecords.Where(m => m.ProfileID == profile.ID && m.TimeLog != null && m.TimeLog.Value.Date == date.Date).ToList();
foreach (var MealByPro in lstMealByPro)
{
if (MealByPro != null)
{
DataRow row = datatable.NewRow();
var profilebymeal = repoHre_Profile.FindBy(m => m.ID == MealByPro.ProfileID).FirstOrDefault();
Guid? orgId = profilebymeal.OrgStructureID;
var org = orgs.FirstOrDefault(s => s.ID == profilebymeal.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);
row[Can_ReportDetailCardEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
row[Can_ReportDetailCardEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
row[Can_ReportDetailCardEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
row[Can_ReportDetailCardEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
row[Can_ReportDetailCardEntity.FieldNames.CodeEmp] = profilebymeal.CodeEmp;
row[Can_ReportDetailCardEntity.FieldNames.ProfileName] = profilebymeal.ProfileName;
if (MealByPro.WorkDay != null)
{
row["Data" + date.Day] = MealByPro.WorkDay.Value.ToString(ConstantFormat.HRM_Format_Grid_ShortTime);
}
var line = lstallLine.Where(m => MealByPro.LineID == m.ID).FirstOrDefault();
row[Can_ReportDetailCardEntity.FieldNames.LineName] = line != null ? line.LineName : string.Empty;
var catering = lstallCatering.Where(m => MealByPro.CateringID == m.ID).FirstOrDefault();
row[Can_ReportDetailCardEntity.FieldNames.CateringName] = catering != null ? catering.CateringName : string.Empty;
var canteen = lstallCanteen.Where(m => MealByPro.CanteenID == m.ID).FirstOrDefault();
row[Can_ReportDetailCardEntity.FieldNames.CanteenName] = canteen != null ? canteen.CanteenName : string.Empty;
row[Can_ReportDetailCardEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportDetailCardEntity.FieldNames.DateTo] = dateEnd;
row[Can_ReportDetailCardEntity.FieldNames.DatePrint] = DateTime.Now;
datatable.Rows.Add(row);
}
}
}
}
return datatable;
}
}
/// <summary>
/// [Son.Vo] - 20140724 - Lấy dữ liệu BC Tổng Hợp Suất Ăn Của 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_ReportMealTimeSummaryEntity> ReportMealTimeSummary(List<int?> CarteringIDs, List<int?> CanteenIDS, List<int?> LineIDS, DateTime DateFrom, DateTime DateTo)
{
#region GetData
var lstMealRecord = new List<Can_MealRecord>().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).ToList();
}
var lstCanteens = new List<Can_Canteen>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_CanteenRepository(unitOfWork);
if (CanteenIDS != null)
{
lstCanteens = repo.FindBy(s => CanteenIDS.Contains(s.Id)).ToList();
}
else lstCanteens = repo.GetAll().ToList();
}
var lstCaterings = new List<Can_Catering>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_CateringRepository(unitOfWork);
if (CarteringIDs != null)
{
lstCaterings = repo.FindBy(s => CarteringIDs.Contains(s.Id)).ToList();
}
else lstCaterings = repo.GetAll().ToList();
}
var lstLines = new List<Can_Line>().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_LineRepository(unitOfWork);
if (LineIDS != null)
{
lstLines = repo.FindBy(s => LineIDS.Contains(s.Id)).ToList();
}
else lstLines = repo.GetAll().ToList();
}
#endregion
List<Can_ReportMealTimeSummaryEntity> lstReportMealTimeSummary = new List<Can_ReportMealTimeSummaryEntity>();
foreach (var cate in lstCaterings)
{
Can_ReportMealTimeSummaryEntity ReportAdjustmentMealAllowancePayment = new Can_ReportMealTimeSummaryEntity();
ReportAdjustmentMealAllowancePayment.Catering = cate.CateringName;
foreach (var item in lstCanteens)
{
ReportAdjustmentMealAllowancePayment.Canteen = item.CanteenName;
foreach (var line in lstLines)
{
ReportAdjustmentMealAllowancePayment.Line = line.LineName;
ReportAdjustmentMealAllowancePayment.Price = line.Amount.Value;
var sum = lstMealRecord.Where(s => s.CateringID == cate.Id && s.CanteenID == cate.Id && s.LineID == line.Id).Sum(s => s.Amount);
var rate = lstMealRecord.Where(s => s.CateringID == cate.Id && s.LineID == line.Id).Sum(s => s.Amount) / sum;
ReportAdjustmentMealAllowancePayment.TotalAmount = sum != null ? sum.Value : 0;
ReportAdjustmentMealAllowancePayment.Rate = rate != null ? rate.Value : 0;
lstReportMealTimeSummary.Add(ReportAdjustmentMealAllowancePayment);
}
}
}
return lstReportMealTimeSummary;
}
public DataTable ReportCardNotStand(List<Guid?> cateringIDs, List<Guid?> canteenIDs, List<Guid?> lineIDs, DateTime dateStart, DateTime dateEndSearch, List<Guid?> orgIDs)
{
DataTable datatable = CreateReportCardNotStandSchema(dateStart, dateEndSearch);
using (var context = new VnrHrmDataContext())
{
DateTime dateEnd = dateEndSearch.AddDays(1).AddMilliseconds(-1);
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_MealRecord = new Can_MealRecordRepository(unitOfWork);
var mealRecords = repoCan_MealRecord.FindBy(s => s.ProfileID != null && s.WorkDay != null && dateStart <= s.WorkDay && s.WorkDay <= dateEnd)
.Select(s => new { s.ProfileID, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.Amount, s.MealAllowanceTypeID, s.WorkDay }).ToList();
if (mealRecords.Count < 1)
{
return datatable;
}
var Profileids = mealRecords.Select(s => s.ProfileID).ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(s => Profileids.Contains(s.ID)).ToList();
var profileIdsByMealrecords = mealRecords.Where(m => m.ProfileID != null).Select(s => s.ProfileID.Value).ToList();
var amountByMealrecords = mealRecords.Select(m => m.Amount).Distinct().ToList();
var repoWorkDay = new Att_WorkDayRepository(unitOfWork);
var workDayProfies = repoWorkDay.FindBy(s => s.ProfileID != null && s.WorkDate != null && dateStart <= s.WorkDate && s.WorkDate <= dateEnd &&
profileIdsByMealrecords.Contains(s.ProfileID)).ToList();
var repoAllowanceType = new Can_MealAllowanceTypeSettingRepository(unitOfWork);
var mealAllowanceTypeStandard = repoAllowanceType.FindBy(s => s.Standard == true).FirstOrDefault();
var amountStandar = mealAllowanceTypeStandard != null ? mealAllowanceTypeStandard.Amount : null;
var repoline = new Can_LineRepository(unitOfWork);
var lineHDTJobIDs = repoline.FindBy(s => s.HDTJ != null).Select(s => s.ID).ToList();
var linIdNotAmoutStardands = repoline.FindBy(s => s.Amount != amountStandar).Select(s => s.ID).ToList();
var repoOrgs = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrgs.FindBy(s => s.Code != null).ToList();
if (orgIDs != null && orgIDs[0] != null)
{
profiles = profiles.Where(s => s.OrgStructureID != null && orgIDs.Contains(s.OrgStructureID.Value)).ToList();
}
if (canteenIDs != null && canteenIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CanteenID != null && canteenIDs.Contains(s.CanteenID.Value)).ToList();
}
if (cateringIDs != null && cateringIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CateringID != null && cateringIDs.Contains(s.CateringID.Value)).ToList();
}
if (lineIDs != null && lineIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.LineID != null && lineIDs.Contains(s.LineID.Value)).ToList();
}
if (linIdNotAmoutStardands.Count > 0)
{
mealRecords = mealRecords.Where(s => s.LineID != null && linIdNotAmoutStardands.Contains(s.LineID.Value)).ToList();
}
if (lineHDTJobIDs.Count > 0)
{
mealRecords = mealRecords.Where(s => s.LineID != null && !lineHDTJobIDs.Contains(s.LineID.Value)).ToList();
}
if (mealRecords.Count < 1)
{
return datatable;
}
var repocanteen = new Can_CanteenRepository(unitOfWork);
var canteens = repocanteen.GetAll().ToList();
var repocatering = new Can_CateringRepository(unitOfWork);
var caterings = repocatering.GetAll().ToList();
var lines = repoline.GetAll().ToList();
var orgTypes = new List<Cat_OrgStructureType>();
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
var approve = LeaveDayStatus.E_APPROVED.ToString();
var repoleavedays = new Att_LeavedayRepository(unitOfWork);
var leavedays = repoleavedays.FindBy(s => s.Status == approve && dateStart <= s.DateEnd
&& s.DateStart <= dateEnd && profileIdsByMealrecords.Contains(s.ProfileID)).Select(s => new { s.ProfileID, s.DateStart, s.DateEnd }).ToList();
foreach (var profile in profiles)
{
var workdayProfileDates = workDayProfies.Where(s => s.ProfileID == profile.ID).Select(s => s.WorkDate.Date).ToList();
var dateLeveDays = new List<DateTime>();
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var leaveDay = leavedays.FirstOrDefault(s => s.ProfileID == profile.ID && s.DateStart <= date && date <= s.DateEnd);
if (leaveDay != null)
{
dateLeveDays.Add(date.Date);
}
}
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var leaveDay = leavedays.FirstOrDefault(s => s.ProfileID == profile.ID && s.DateStart <= date && date <= s.DateEnd);
var meal = mealRecords.FirstOrDefault(s => s.ProfileID == profile.ID && s.TimeLog != null && s.WorkDay != null
&& s.TimeLog.Value.Date == date.Date && workdayProfileDates.Contains(s.WorkDay.Value.Date) && leaveDay == null);
if (meal != null)
{
DataRow row = datatable.NewRow();
Guid? orgId = profile != null ? profile.OrgStructureID : null;
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);
row[Can_ReportCardNotStandEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
row[Can_ReportCardNotStandEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
row[Can_ReportCardNotStandEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
row[Can_ReportCardNotStandEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
row[Can_ReportCardNotStandEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportCardNotStandEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportCardNotStandEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportCardNotStandEntity.FieldNames.DateTo] = dateEnd;
row[Can_ReportCardNotStandEntity.FieldNames.DatePrint] = DateTime.Now;
var cate = caterings.FirstOrDefault(s => s.ID == meal.CateringID);
var cateen = canteens.FirstOrDefault(s => s.ID == meal.CanteenID);
var line = lines.FirstOrDefault(s => s.ID == meal.LineID);
if (meal.WorkDay != null)
{
row["Data" + date.Day] = meal.WorkDay.Value.ToString(ConstantFormat.HRM_Format_Grid_ShortTime);
}
row[Can_ReportCardNotStandEntity.FieldNames.CateringName] = cate != null ? cate.CateringName : string.Empty; ;
row[Can_ReportCardNotStandEntity.FieldNames.CanteenName] = cateen != null ? cateen.CanteenName : string.Empty; ;
row[Can_ReportCardNotStandEntity.FieldNames.LineName] = line != null ? line.LineName : string.Empty;
var countcard = mealRecords.Count(s => s.WorkDay != null && s.ProfileID == profile.ID && workdayProfileDates.Contains(s.WorkDay.Value.Date)
&& !dateLeveDays.Contains(s.WorkDay.Value.Date));
if (countcard != null)
{
row[Can_ReportCardNotStandEntity.FieldNames.CountCard] = countcard;
var SumAmount = mealRecords.Where(s => s.WorkDay != null && s.ProfileID == profile.ID && workdayProfileDates.Contains(s.WorkDay.Value.Date) &&
!dateLeveDays.Contains(s.WorkDay.Value.Date)).Sum(s => s.Amount) - countcard * amountStandar;
row[Can_ReportCardNotStandEntity.FieldNames.SumAmount] = SumAmount;
}
datatable.Rows.Add(row);
}
}
}
return datatable;
}
}
public DataTable ReportMealTimeDetail(List<Guid?> CarteringIDs, List<Guid?> CanteenIDS, List<Guid?> LineIDS, DateTime dateStart, DateTime dateEndSearch, List<Guid?> orgIDs)
{
using (var context = new VnrHrmDataContext())
{
DateTime dateEnd = dateEndSearch.AddDays(1).AddMilliseconds(-1);
DataTable datatable = CreateReportMealTimeDetailSchema(dateStart, dateEnd);
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoMealRecord = new Can_MealRecordRepository(unitOfWork);
var repoLine = new Can_LineRepository(unitOfWork);
var lineHDTJobIDs = repoLine.FindBy(s => s.HDTJ != null).Select(s => s.ID).ToList();
var mealRecords = repoMealRecord.FindBy(s => s.LineID != null && !lineHDTJobIDs.Contains(s.LineID.Value)
&& s.ProfileID != null && dateStart <= s.WorkDay && s.WorkDay <= dateEnd).ToList();
if (mealRecords.Count < 1)
{
return datatable;
}
var profileIds = mealRecords.Select(s => s.ProfileID.Value).Distinct().ToList();
var repoWorkDay = new Att_WorkDayRepository(unitOfWork);
var workDayProfies = repoWorkDay.FindBy(s => s.ProfileID != null && dateStart <= s.WorkDate
&& s.WorkDate <= dateEnd && profileIds.Contains(s.ProfileID)).ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(s => profileIds.Contains(s.ID)).ToList();
var repoLeaveday = new Att_LeavedayRepository(unitOfWork);
var leavedays = repoLeaveday.FindBy(s => dateStart <= s.DateEnd
&& s.DateStart <= dateEnd && profileIds.Contains(s.ProfileID)).
Select(s => new { s.ProfileID, s.DateStart, s.DateEnd, s.LeaveDayTypeID }).ToList();
var repoleaveDayType = new Cat_LeaveDayTypeRepository(unitOfWork);
var leaveDayTypes = repoleaveDayType.GetAll().Select(s => new { s.ID, s.LeaveDayTypeName }).ToList();
List<Cat_OrgStructure> orgs = new List<Cat_OrgStructure>();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
orgs = repoOrg.FindBy(s => s.Code != null).ToList();
if (orgIDs != null && orgIDs.Count > 0)
{
profiles = profiles.Where(s => s.OrgStructureID != null && orgIDs.Contains(s.OrgStructureID.Value)).ToList();
}
if (CanteenIDS != null && CanteenIDS[0] != null)
{
mealRecords = mealRecords.Where(s => s.CanteenID != null && CanteenIDS.Contains(s.CanteenID.Value)).ToList();
}
if (CarteringIDs != null && CarteringIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CateringID != null && CarteringIDs.Contains(s.CateringID.Value)).ToList();
}
if (LineIDS != null && LineIDS[0] != null)
{
mealRecords = mealRecords.Where(s => s.LineID != null && LineIDS.Contains(s.LineID.Value)).ToList();
}
if (mealRecords.Count < 1)
{
return datatable;
}
profileIds = mealRecords.Select(s => s.ProfileID.Value).ToList();
profiles = profiles.Where(s => profileIds.Contains(s.ID)).ToList();
var orgTypes = new List<Cat_OrgStructureType>();
var repoorgType = new Cat_OrgStructureTypeRepository(unitOfWork);
orgTypes = repoorgType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
var repoCanteen = new Can_CanteenRepository(unitOfWork);
var repoCatering = new Can_CateringRepository(unitOfWork);
var canteens = repoCanteen.GetAll().ToList();
var caterings = repoCatering.GetAll().ToList();
var lines = repoLine.GetAll().ToList();
#region Code Cũ
//foreach (var profile in profiles)
//{
// var workdayProfileDates = workDayProfies.Where(s => s.ProfileID == profile.Id).Select(s => s.WorkDate.Date).ToList();
// for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
// {
// var record = mealRecords.FirstOrDefault(s => s.ProfileID == profile.Id && date == s.TimeLog.Date && !workdayProfileDates.Contains(date.Date));
// if (record != null)
// {
// DataRow row = datatable.NewRow();
// int? orgId = profile.OrgStructureID;
// var org = orgs.FirstOrDefault(s => s.Id == profile.OrgStructureID);
// var orgBranch = LibraryService.GetNearestParent(orgId, OrgUnit.E_BRANCH, orgs, orgTypes);
// var orgOrg = LibraryService.GetNearestParent(orgId, OrgUnit.E_DEPARTMENT, orgs, orgTypes);
// var orgTeam = LibraryService.GetNearestParent(orgId, OrgUnit.E_TEAM, orgs, orgTypes);
// var orgSection = LibraryService.GetNearestParent(orgId, OrgUnit.E_SECTION, orgs, orgTypes);
// row[Can_ReportMealTimeDetailEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
// row[Can_ReportMealTimeDetailEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
// row[Can_ReportMealTimeDetailEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
// row[Can_ReportMealTimeDetailEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
// row[Can_ReportMealTimeDetailEntity.FieldNames.CodeEmp] = profile.CodeEmp;
// row[Can_ReportMealTimeDetailEntity.FieldNames.ProfileName] = profile.ProfileName;
// var line = repoLine.FindBy(m => record.LineID == m.Id).FirstOrDefault();
// var canteen = repoCanteen.FindBy(m => record.CanteenID == m.Id).FirstOrDefault();
// var catering = repoCatering.FindBy(m => record.CateringID == m.Id).FirstOrDefault();
// row[Can_ReportMealTimeDetailEntity.FieldNames.CateringName] = catering != null ? catering.CateringName : null;
// row[Can_ReportMealTimeDetailEntity.FieldNames.CanteenName] = canteen != null ? canteen.CanteenName : null;
// row[Can_ReportMealTimeDetailEntity.FieldNames.LineName] = line != null ? line.LineName : null;
// row[Can_ReportMealTimeDetailEntity.FieldNames.DateFrom] = dateStart;
// row[Can_ReportMealTimeDetailEntity.FieldNames.DateTo] = dateEnd;
// row[Can_ReportMealTimeDetailEntity.FieldNames.DatePrint] = DateTime.Now;
// if (record.TimeLog != null)
// {
// row["Data" + date.Day] = record.TimeLog.ToString(ConstantFormat.HRM_Format_Grid_ShortTime);
// }
// datatable.Rows.Add(row);
// }
// }
//}
#endregion
foreach (var profile in profiles)
{
var workdayProfileDates = workDayProfies.Where(s => s.ProfileID == profile.ID && (s.FirstInTime != null || s.LastOutTime != null)).Select(s => s.WorkDate.Date).ToList();
var mealRecordProfiles = mealRecords.Where(s => s.ProfileID == profile.ID).ToList();
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var leaday = leavedays.FirstOrDefault(s => s.DateStart != null && s.DateEnd != null && s.ProfileID == profile.ID && s.DateStart.Date <= date.Date && date.Date <= s.DateEnd.Date);
var record = mealRecordProfiles.FirstOrDefault(s => date.Date == s.WorkDay.Value.Date && (!workdayProfileDates.Contains(s.WorkDay.Value.Date) || leaday != null));
if (record != null)
{
DataRow row = datatable.NewRow();
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);
row[Can_ReportMealTimeDetailEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
row[Can_ReportMealTimeDetailEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
row[Can_ReportMealTimeDetailEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
row[Can_ReportMealTimeDetailEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
row[Can_ReportMealTimeDetailEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportMealTimeDetailEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportMealTimeDetailEntity.FieldNames.Date] = record.WorkDay;
row[Can_ReportMealTimeDetailEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportMealTimeDetailEntity.FieldNames.DateTo] = dateEnd;
var cate = caterings.FirstOrDefault(s => s.ID == record.CateringID);
var cateen = canteens.FirstOrDefault(s => s.ID == record.CanteenID);
var line = lines.FirstOrDefault(s => s.ID == record.LineID);
row[Can_ReportMealTimeDetailEntity.FieldNames.CateringName] = cate != null ? cate.CateringName : string.Empty; ;
row[Can_ReportMealTimeDetailEntity.FieldNames.CanteenName] = cateen != null ? cateen.CanteenName : string.Empty; ;
row[Can_ReportMealTimeDetailEntity.FieldNames.LineName] = line != null ? line.LineName : string.Empty;
if (record.TimeLog != null)
{
row["Data" + record.WorkDay.Value.Day] = record.TimeLog == null ? null : (object)record.TimeLog.Value.ToString(ConstantFormat.HRM_Format_Grid_ShortTime) ?? DBNull.Value;
}
row[Can_ReportMealTimeDetailEntity.FieldNames.DatePrint] = DateTime.Now;
if (leaday != null)
{
var leadayType = leaveDayTypes.FirstOrDefault(s => s.ID == leaday.LeaveDayTypeID);
row[Can_ReportMealTimeDetailEntity.FieldNames.LeaveDayTypeName] = leadayType != null ? leadayType.LeaveDayTypeName : string.Empty;
}
datatable.Rows.Add(row);
}
}
}
return datatable;
}
}
public DataTable ReportHDTJobCardMore(List<Guid?> CarteringIDs, List<Guid?> CanteenIDS, List<Guid?> LineIDS, DateTime dateStart, DateTime dateEnd, List<Guid> lstProfileIds, Boolean isCludeEmpQuit)
{
DataTable datatable = CreateReportHDTJobCardMoreSchema();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_Line = new Can_LineRepository(unitOfWork);
var repo = new Can_MealRecordRepository(unitOfWork);
var mealRecords = repo.FindBy(s => s.ProfileID != null && s.WorkDay != null && s.TimeLog != null && dateStart <= s.WorkDay && s.WorkDay <= dateEnd).ToList();
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var profileIds = mealRecords.Select(s => s.ProfileID.Value).Distinct().ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(m => profileIds.Contains(m.ID)).ToList();
var repoCan_Location = new Can_LocationRepository(unitOfWork);
var lstLocation = repoCan_Location.FindBy(s => s.IsDelete == null).ToList();
if (lstProfileIds != null && lstProfileIds.Count >= 1)
{
profiles = profiles.Where(s => lstProfileIds.Contains(s.ID)).ToList();
}
if (isCludeEmpQuit != true)
{
profiles = profiles.Where(s => s.DateQuit == null || s.DateQuit > dateEnd).ToList();
}
profileIds = profiles.Select(s => s.ID).ToList();
mealRecords = mealRecords.Where(s => profileIds.Contains(s.ProfileID.Value)).ToList();
var lstcateringids = mealRecords.Select(m => m.CateringID).ToList();
var lstcanteenids = mealRecords.Select(m => m.CanteenID).ToList();
var Cardcode = mealRecords.Select(s => s.ProfileID).Distinct().ToList();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrg.FindBy(m => m.Code != null).ToList();
if (CarteringIDs != null && CarteringIDs[0] != null)
{
mealRecords = mealRecords.Where(m => m.CateringID != null && CarteringIDs.Contains(m.CateringID)).ToList();
}
if (CanteenIDS != null && CanteenIDS[0] != null)
{
mealRecords = mealRecords.Where(m => m.CanteenID != null && CanteenIDS.Contains(m.CanteenID)).ToList();
}
if (LineIDS != null && LineIDS[0] != null)
{
mealRecords = mealRecords.Where(m => m.LineID != null && LineIDS.Contains(m.LineID)).ToList();
}
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var repoWorkLocation = new Cat_WorkPlaceRepository(unitOfWork);
var lstWorkPlace = repoWorkLocation.GetAll().ToList();
var repocatering = new Can_CateringRepository(unitOfWork);
var caterings = repocatering.GetAll().ToList();
var repocanteen = new Can_CanteenRepository(unitOfWork);
var canteens = repocanteen.GetAll().ToList();
var repoline = new Can_LineRepository(unitOfWork);
var lines = repoline.GetAll().ToList();
var orgTypes = new List<Cat_OrgStructureType>();
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
var repoAttWorkday = new Att_WorkDayRepository(unitOfWork);
var wordDayProfiles = repoAttWorkday.FindBy(wd => dateStart <= wd.WorkDate && wd.WorkDate <= dateEnd)
.Select(wd => new { wd.ProfileID, wd.ShiftID, wd.WorkDate, wd.InTime1, wd.OutTime1 }).ToList();
var approve = LeaveDayStatus.E_APPROVED.ToString();
var repoAttLeaveday = new Att_LeavedayRepository(unitOfWork);
var leavedays = repoAttLeaveday.FindBy(ld => ld.Status == approve && dateStart <= ld.DateEnd
&& ld.DateStart <= dateEnd && profileIds.Contains(ld.ProfileID)).Select(ld => new { ld.ProfileID, ld.DateStart, ld.DateEnd }).ToList();
var repoHDTjob = new Hre_HDTJobRepository(unitOfWork);
var hdtJobs = repoHDTjob.FindBy(s => s.ProfileID != null && profileIds.Contains(s.ProfileID.Value)
&& dateStart <= s.DateTo && s.DateFrom <= dateEnd).Select(s => new { s.DateFrom, s.ProfileID, s.DateTo, s.Type }).ToList();
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
if (!datatable.Columns.Contains("Data" + date.Day))
{
datatable.Columns.Add("Data" + date.Day, typeof(double));
}
}
foreach (var profile in profiles)
{
List<DateTime> leaveDayDates = new List<DateTime>();
var leaveDayProfiles = leavedays.Where(s => s.ProfileID == profile.ID).ToList();
foreach (var leaveDayProfile in leaveDayProfiles)
{
for (DateTime date = leaveDayProfile.DateStart; date <= leaveDayProfile.DateEnd; date = date.AddDays(1))
{
leaveDayDates.Add(date.Date);
}
}
var workDayDates = wordDayProfiles.Where(s => s.ProfileID == profile.ID).Select(s => s.WorkDate.Date).ToList();
workDayDates = workDayDates.Where(s => !leaveDayDates.Contains(s.Date)).ToList();
var mealRecordProfiles = mealRecords.Where(s => s.ProfileID == profile.ID && workDayDates.Contains(s.WorkDay.Value.Date)).ToList();
if (mealRecordProfiles.Count > 0)
{
var dateend = mealRecordProfiles[mealRecordProfiles.Count - 1].WorkDay;
for (DateTime date = mealRecordProfiles[0].WorkDay.Value; date <= dateend; date = date.AddDays(1))
{
if (mealRecordProfiles.Count(s => s.WorkDay.Value.Date == date.Date) > 1)
{
var mealDoubles = mealRecordProfiles.Where(s => s.WorkDay.Value.Date == date.Date).ToList();
if (mealDoubles.Count > 1)
{
var hdtType = hdtJobs.FirstOrDefault(s => s.DateFrom <= date && date <= s.DateTo && s.ProfileID == profile.ID);
foreach (var meal in mealDoubles)
{
DataRow row = datatable.NewRow();
var orgId = orgs.Where(og => og.ID == mealRecordProfiles[0].OrgStructureID).Select(og => og.ID).FirstOrDefault();
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);
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CodeBranch] = orgBranch != null ? orgBranch.Code : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CodeDepartment] = orgOrg != null ? orgOrg.Code : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CodeTeam] = orgTeam != null ? orgTeam.Code : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CodeSection] = orgSection != null ? orgSection.Code : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.DateTo] = dateEnd;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.DateExport] = DateTime.Now;
if (meal.TimeLog != null)
{
row[Can_ReportHDTJobCardMoreEntity.FieldNames.DateCard] = meal.WorkDay;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.Hour] = meal.TimeLog.Value.ToString("HH:mm:ss");
}
var count1 = 0;
for (DateTime date1 = dateStart; date1 <= dateEnd; date1 = date1.AddDays(1))
{
int countDay = mealRecordProfiles.Count(s => s.WorkDay.Value.Date == date1.Date && !leaveDayDates.Contains(date1.Date));
if (countDay > 1)
{
count1 += countDay - 1;
}
}
row[Can_ReportHDTJobCardMoreEntity.FieldNames.Total] = count1;
row["Data" + date.Day] = mealDoubles.Sum(s => s.Amount);
var cate = caterings.FirstOrDefault(s => s.ID == meal.CateringID);
var cateen = canteens.FirstOrDefault(s => s.ID == meal.CanteenID);
var line = lines.FirstOrDefault(s => s.ID == meal.LineID);
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CateringName] = cate != null ? cate.CateringName : string.Empty; ;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.CanteenName] = cateen != null ? cateen.CanteenName : string.Empty; ;
row[Can_ReportHDTJobCardMoreEntity.FieldNames.LineName] = line != null ? line.LineName : string.Empty;
if (hdtType != null)
{
var hdttype = lines.FirstOrDefault(s => s.HDTJ == hdtType.Type);
if (hdttype != null)
{
row[Can_ReportHDTJobCardMoreEntity.FieldNames.PriceStardand] = (object)hdttype.Amount ?? DBNull.Value;
}
}
datatable.Rows.Add(row);
}
}
}
}
}
}
}
return datatable;
}
public List<Can_ReportMealTimeSummaryEntity> ReportMealTimeSummary(List<Guid> CarteringIDs, List<Guid> CanteenIDS, List<Guid> LineIDS, DateTime DateFrom, DateTime dateEndSearch, List<Guid> OrgIds)
{
#region GetData
using (var context = new VnrHrmDataContext())
{
DateTime DateTo = dateEndSearch.AddDays(1).AddMilliseconds(-1);
List<Can_ReportMealTimeSummaryEntity> lstReportMealTimeSummary = new List<Can_ReportMealTimeSummaryEntity>();
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new Can_MealRecordRepository(unitOfWork);
var lstMealRecord = repo.FindBy(m => m.CateringID != null && m.WorkDay >= DateFrom && m.WorkDay <= DateTo && m.ProfileID != null).ToList();
if (lstMealRecord.Count < 0)
{
return lstReportMealTimeSummary;
}
var lstProfileIdsByMealRecord = lstMealRecord.Select(m => m.ProfileID).ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(m => lstProfileIdsByMealRecord.Contains(m.ID)).ToList();
if (OrgIds != null && OrgIds[0] != Guid.Empty)
{
profiles = profiles.Where(m => m.OrgStructureID != null && OrgIds.Contains(m.OrgStructureID.Value)).ToList();
}
if (CanteenIDS != null && CanteenIDS[0] != Guid.Empty)
{
lstMealRecord = lstMealRecord.Where(m => m.CanteenID != null && CanteenIDS.Contains(m.CanteenID.Value)).ToList();
}
if (CarteringIDs != null && CarteringIDs[0] != Guid.Empty)
{
lstMealRecord = lstMealRecord.Where(m => m.CateringID != null && CarteringIDs.Contains(m.CateringID.Value)).ToList();
}
if (lstMealRecord.Count < 1)
{
return lstReportMealTimeSummary;
}
if (LineIDS != null && LineIDS[0] != Guid.Empty)
{
lstMealRecord = lstMealRecord.Where(m => m.LineID != null && LineIDS.Contains(m.LineID.Value)).ToList();
}
if (lstMealRecord.Count < 0)
{
return lstReportMealTimeSummary;
}
var repoCatering = new Can_CateringRepository(unitOfWork);
var caterings = repoCatering.GetAll().ToList();
var repoLine = new Can_LineRepository(unitOfWork);
var lines = repoLine.GetAll().ToList();
var repoCanteen = new Can_CanteenRepository(unitOfWork);
var canteens = repoCanteen.GetAll().ToList();
#endregion
foreach (var canLine in lines)
{
var cateIDs = lstMealRecord.Where(s => s.LineID == canLine.ID).Select(s => s.CateringID).Distinct().ToList();
foreach (var catering in caterings.Where(s => cateIDs.Contains(s.ID)).ToList())
{
var cantenIDs = lstMealRecord.Where(s => s.LineID == canLine.ID).Select(s => s.CanteenID).Distinct().ToList();
foreach (var canteen in canteens.Where(s => cantenIDs.Contains(s.ID)).ToList())
{
Can_ReportMealTimeSummaryEntity ReportMealTimeSummaryEntity = new Can_ReportMealTimeSummaryEntity();
ReportMealTimeSummaryEntity.CateringName = catering != null ? catering.CateringName : string.Empty;
ReportMealTimeSummaryEntity.CanteenName = canteen != null ? canteen.CanteenName : string.Empty;
ReportMealTimeSummaryEntity.DateFrom = DateFrom;
ReportMealTimeSummaryEntity.DateTo = DateTo;
ReportMealTimeSummaryEntity.LineName = canLine != null ? canLine.LineName : string.Empty;
ReportMealTimeSummaryEntity.Price = (double)(canLine.Amount != null ? canLine.Amount.Value : 0);
var count = lstMealRecord.Count(s => canLine != null && (canteen != null && (catering != null && (s.CateringID == catering.ID && s.CanteenID == canteen.ID && s.LineID == canLine.ID))));
var sumAll = lstMealRecord.Where(s => catering != null && catering.ID == s.CateringID).Sum(s => s.Amount);
if (count > 0)
{
ReportMealTimeSummaryEntity.Total = count;
}
if (canLine.Amount != null)
{
var amount = count * canLine.Amount;
if (amount > 0)
ReportMealTimeSummaryEntity.TotalAmount = (double)amount;
if (amount > 0)
{
var rate = (double)(amount / sumAll);
ReportMealTimeSummaryEntity.Rate = Math.Round(rate, 6);
}
}
ReportMealTimeSummaryEntity.DatePrint = DateTime.Now;
if (ReportMealTimeSummaryEntity.Rate > 0)
lstReportMealTimeSummary.Add(ReportMealTimeSummaryEntity);
}
}
}
return lstReportMealTimeSummary;
}
}
public DataTable GetReportPayMoneyEat(List<Guid?> cateringIDs, List<Guid?> canteenIDs, List<Guid?> lineIDs,
DateTime dateStart, DateTime dateEndSearch, List<Guid?> orgIDs, List<Guid?> countryIDs, String codeEmp, Boolean IsIncludeQuitEmp)
{
DataTable datatable = CreatePayMoneyEatSchema();
using (var context = new VnrHrmDataContext())
{
DateTime dateEnd = dateEndSearch.AddDays(1).AddMilliseconds(-1);
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_MealRecord = new Can_MealRecordRepository(unitOfWork);
var mealRecords = repoCan_MealRecord.FindBy(s => s.ProfileID != null && s.WorkDay != null
&& dateStart <= s.WorkDay && s.WorkDay <= dateEnd).Select(
s => new { s.ProfileID, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.Amount, s.MealAllowanceTypeID, s.NoWorkDay }).ToList();
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var profileIds = mealRecords.Select(s => s.ProfileID.Value).Distinct().ToList();
var repoHre_Profile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoHre_Profile.FindBy(m => profileIds.Contains(m.ID)).ToList();
var repoCat_OrgStructure = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoCat_OrgStructure.FindBy(s => s.Code != null).ToList();
if (orgIDs != null && orgIDs[0] != null)
{
profiles = profiles.Where(s => s.OrgStructureID != null && orgIDs.Contains(s.OrgStructureID.Value)).ToList();
}
//if (empTypes != null && empTypes[0] != null)
//{
// profiles = profiles.Where(s => s.EmpTypeID != null && empTypes.Contains(s.EmpTypeID.Value)).ToList();
//}
if (countryIDs[0] != Guid.Empty)
{
profiles = profiles.Where(s => s.NationalityID != null && countryIDs.Contains(s.NationalityID.Value)).ToList();
//profileIds = profiles.Select(s => s.ID).ToList();
//mealRecords = mealRecords.Where(s => profileIds.Contains(s.ProfileID.Value)).ToList();
}
if (IsIncludeQuitEmp != true)
{
profiles = profiles.Where(s => s.DateQuit == null || s.DateQuit > dateEnd).ToList();
//profileIds = profiles.Select(s => s.ID).ToList();
//mealRecords = mealRecords.Where(s => profileIds.Contains(s.ProfileID.Value)).ToList();
}
if (!string.IsNullOrEmpty(codeEmp))
{
char[] ext = new char[] { ';', ',' };
List<string> codeEmpSeachs = codeEmp.Split(ext, StringSplitOptions.RemoveEmptyEntries).ToList<string>();
if (codeEmpSeachs.Count == 1)
{
string codeEmpSearch = codeEmpSeachs[0];
profiles = profiles.Where(hr => hr.CodeEmp == codeEmpSearch).ToList();
}
else
{
profiles = profiles.Where(hr => codeEmpSeachs.Contains(hr.CodeEmp)).ToList();
}
}
profileIds = profiles.Select(s => s.ID).ToList();
mealRecords = mealRecords.Where(s => profileIds.Contains(s.ProfileID.Value)).ToList();
if (canteenIDs != null && canteenIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CanteenID != null && canteenIDs.Contains(s.CanteenID.Value)).ToList();
}
if (cateringIDs != null && cateringIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.CateringID != null && cateringIDs.Contains(s.CateringID.Value)).ToList();
}
if (lineIDs != null && lineIDs[0] != null)
{
mealRecords = mealRecords.Where(s => s.LineID != null && lineIDs.Contains(s.LineID.Value)).ToList();
}
var codeAttendaceByProfile = profiles.Select(m => m.ID).ToList();
if (codeAttendaceByProfile != null && codeAttendaceByProfile.Count > 0)
{
mealRecords = mealRecords.Where(m => m.ProfileID != null && codeAttendaceByProfile.Contains(m.ProfileID.Value)).ToList();
}
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
profileIds = mealRecords.Select(s => s.ProfileID.Value).ToList();
profiles = profiles.Where(s => profileIds.Contains(s.ID)).ToList();
var repoCan_Line = new Can_LineRepository(unitOfWork);
var repoCaterings = new Can_CateringRepository(unitOfWork);
var caterings = repoCaterings.GetAll().ToList();
var repoCanteen = new Can_CanteenRepository(unitOfWork);
var canteens = repoCanteen.GetAll().ToList();
var amounts = repoCan_Line.FindBy(s => s.Amount != null).Select(s => new { s.Amount, s.ID }).Distinct().ToList();
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
var orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
foreach (var profile in profiles)
{
var careringIDs = mealRecords.Where(s => s.ProfileID == profile.ID).Select(s => s.CateringID).ToList();
var carerings = caterings.Where(s => careringIDs.Contains(s.ID)).ToList();
foreach (var catering in carerings)
{
DataRow row = datatable.NewRow();
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);
row[Can_ReportPayMoneyEatEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
row[Can_ReportPayMoneyEatEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
row[Can_ReportPayMoneyEatEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
row[Can_ReportPayMoneyEatEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
row[Can_ReportPayMoneyEatEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportPayMoneyEatEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportPayMoneyEatEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportPayMoneyEatEntity.FieldNames.DateTo] = dateEnd;
row[Can_ReportPayMoneyEatEntity.FieldNames.DatePrint] = DateTime.Now;
row[Can_ReportPayMoneyEatEntity.FieldNames.CateringName] = catering.CateringName;
var lstAmount = amounts.Select(am => am.Amount).Distinct().ToList();
foreach (var amount in lstAmount)
{
var lsLineID = amounts.Where(am => am.Amount == amount).Select(am => am.ID).ToList();
var countCareing = mealRecords.Where(meal => meal.ProfileID == profile.ID && meal.LineID != null && lsLineID.Contains(meal.LineID.Value)).Count();
if (countCareing > 0)
row[amount.ToString()] = countCareing;
}
foreach (var amount in amounts)
{
var countCareing = mealRecords.Count(s => s.ProfileID == profile.ID && s.CateringID == catering.ID && s.LineID == amount.ID);
if (countCareing > 0)
row[amount.Amount.ToString()] = countCareing;
}
var countEat = mealRecords.Count(s => s.ProfileID == profile.ID && s.CateringID == catering.ID);
if (countEat > 0)
row[Can_ReportPayMoneyEatEntity.FieldNames.CountEat] = countEat;
var subtractSalary = mealRecords.Where(s => s.ProfileID == profile.ID && s.CateringID == catering.ID).Sum(s => s.Amount);
if (subtractSalary > 0)
row[Can_ReportPayMoneyEatEntity.FieldNames.SubtractSalary] = subtractSalary;
datatable.Rows.Add(row);
}
}
return datatable;
}
}
public DataTable ReportMultiSlideCard(List<Guid?> CarteringIDs, List<Guid?> CanteenIDS, List<Guid?> LineIDS, List<Guid?> lstWorkPlaceID,
DateTime dateStart, DateTime dateEndSearch, List<Guid> lstProfileIds, Boolean IsIncludeQuitEmp)
{
DataTable datatable = CreateReportMultiSlideCardSchema(dateStart, dateEndSearch);
using (var context = new VnrHrmDataContext())
{
DateTime dateEnd = dateEndSearch.AddDays(1).AddMilliseconds(-1);
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_Line = new Can_LineRepository(unitOfWork);
var lineHDTJobIDs = repoCan_Line.FindBy(s => s.HDTJ != null)
.Select(s => s.ID).ToList();
var repoWorkDay = new Att_WorkDayRepository(unitOfWork);
var wordDayProfiles = repoWorkDay.FindBy(s => s.ProfileID != null && dateStart <= s.WorkDate && s.WorkDate <= dateEnd)
.Select(s => new { s.ProfileID, s.WorkDate, s.FirstInTime, s.LastOutTime }).ToList();
var repo = new Can_MealRecordRepository(unitOfWork);
var mealRecords = repo.FindBy(s => s.LineID != null && s.WorkDay != null && !lineHDTJobIDs.Contains(s.LineID.Value) && s.ProfileID != null
&& dateStart <= s.WorkDay && s.WorkDay <= dateEnd).Select(s => new { s.ProfileID, s.TimeLog, s.CanteenID, s.CateringID, s.LineID, s.WorkDay }).ToList();
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var profileIds = mealRecords.Select(s => s.ProfileID.Value).Distinct().ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(m => profileIds.Contains(m.ID)).ToList();
if (lstProfileIds != null && lstProfileIds.Count >= 1)
{
profiles = profiles.Where(s => lstProfileIds.Contains(s.ID)).ToList();
}
if (lstWorkPlaceID[0] != Guid.Empty)
{
profiles = profiles.Where(hr => hr.WorkPlaceID != null && lstWorkPlaceID.Contains(hr.WorkPlaceID.Value)).ToList();
}
//Kiểm tra ko nghỉ việc
if (IsIncludeQuitEmp != true)
{
profiles = profiles.Where(s => s.DateQuit == null || s.DateQuit > dateEnd).ToList();
}
profileIds = profiles.Select(s => s.ID).ToList();
mealRecords = mealRecords.Where(s => profileIds.Contains(s.ProfileID.Value)).ToList();
var Cardcode = mealRecords.Select(s => s.ProfileID).Distinct().ToList();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrg.FindBy(m => m.Code != null).ToList();
var catering = new List<Can_Catering>().ToList();
var repocatering = new Can_CateringRepository(unitOfWork);
if (CarteringIDs != null && CarteringIDs[0] != null)
{
mealRecords = mealRecords.Where(m => m.CateringID != null && CarteringIDs.Contains(m.CateringID)).ToList();
}
var repocanteen = new Can_CanteenRepository(unitOfWork);
if (CanteenIDS != null && CanteenIDS[0] != null)
{
mealRecords = mealRecords.Where(m => m.CanteenID != null && CanteenIDS.Contains(m.CanteenID)).ToList();
}
if (LineIDS != null && LineIDS[0] != null)
{
mealRecords = mealRecords.Where(m => m.LineID != null && LineIDS.Contains(m.LineID)).ToList();
}
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var orgTypes = new List<Cat_OrgStructureType>();
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
var repoCan_Catering = new Can_CateringRepository(unitOfWork);
var repoCan_Canteen = new Can_CanteenRepository(unitOfWork);
var repoline = new Can_LineRepository(unitOfWork);
var canteens = repoCan_Canteen.GetAll().ToList();
var caterings = repoCan_Catering.GetAll().ToList();
var lines = repoCan_Line.GetAll().ToList();
var approve = LeaveDayStatus.E_APPROVED.ToString();
var repoLeaveDay = new Att_LeavedayRepository(unitOfWork);
var leavedays = repoLeaveDay.FindBy(s => s.Status == approve && dateStart <= s.DateEnd
&& s.DateStart <= dateEnd && profileIds.Contains(s.ProfileID)).Select(s => new { s.ProfileID, s.DateStart, s.DateEnd }).ToList();
foreach (var profile in profiles)
{
var mealRecordProfiles = mealRecords.Where(s => s.ProfileID == profile.ID).ToList();
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var leaveDay = leavedays.FirstOrDefault(s => s.ProfileID == profile.ID && s.DateStart <= date && date <= s.DateEnd);
var workDayDates = wordDayProfiles.Where(s => s.ProfileID == profile.ID && (s.FirstInTime != null || s.LastOutTime != null)).Select(s => s.WorkDate.Date).ToList();
var mealDoubles = mealRecordProfiles.Where(s => s.TimeLog != null && s.TimeLog.Value.Date == date.Date).ToList();
if (mealDoubles.Count > 1)
{
foreach (var meal in mealDoubles)
{
DataRow row = datatable.NewRow();
Guid? orgId = profile != null ? profile.OrgStructureID : Guid.Empty;
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);
row[Can_ReportMultiSlIDeCardEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.OrgStructureName : string.Empty;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.OrgStructureName : string.Empty;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.OrgStructureName : string.Empty;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.SectionName] = orgSection != null ? orgSection.OrgStructureName : string.Empty;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.DateTo] = dateEnd;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.DatePrint] = DateTime.Now;
if (meal.TimeLog != null)
{
row["Data" + date.Day] = meal.TimeLog.Value.ToString(ConstantFormat.HRM_Format_Grid_ShortTime);
}
var count1 = 0;
for (DateTime date1 = dateStart; date1 <= dateEnd; date1 = date1.AddDays(1))
{
int countDay = mealRecordProfiles.Count(s => s.TimeLog != null && s.TimeLog.Value.Date == date1.Date && leaveDay == null);
if (countDay > 1)
{
count1 += countDay - 1;
}
}
row[Can_ReportMultiSlIDeCardEntity.FieldNames.SumCardMore] = count1;
var cate = caterings.FirstOrDefault(s => s.ID == meal.CateringID);
var cateen = canteens.FirstOrDefault(s => s.ID == meal.CanteenID);
var line = lines.FirstOrDefault(s => s.ID == meal.LineID);
row[Can_ReportMultiSlIDeCardEntity.FieldNames.CateringName] = cate != null ? cate.CateringName : string.Empty; ;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.CanteenName] = cateen != null ? cateen.CanteenName : string.Empty; ;
row[Can_ReportMultiSlIDeCardEntity.FieldNames.LineName] = line != null ? line.LineName : string.Empty;
datatable.Rows.Add(row);
}
}
}
}
return datatable;
}
}
public DataTable ReportCardByLocation(List<Guid?> CarteringIDs, List<Guid?> CanteenIDS, List<Guid?> LineIDS, DateTime dateStart, DateTime dateEndSearch,
List<Guid> lstProfileIds, List<Guid?> workPlaceIds, List<Guid?> eatLocationIds, Boolean isCludeEmpQuit)
{
DataTable datatable = CreateReportCardByLocationSchema(dateStart, dateEndSearch);
using (var context = new VnrHrmDataContext())
{
DateTime dateEnd = dateEndSearch.AddDays(1).AddMilliseconds(-1);
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_Line = new Can_LineRepository(unitOfWork);
var repo = new Can_MealRecordRepository(unitOfWork);
var mealRecords = repo.FindBy(s => s.ProfileID != null && s.WorkDay != null && s.TimeLog != null
&& dateStart <= s.WorkDay && s.WorkDay <= dateEnd).ToList();
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var profileIds = mealRecords.Select(s => s.ProfileID.Value).Distinct().ToList();
var repoProfile = new Hre_ProfileRepository(unitOfWork);
var profiles = repoProfile.FindBy(m => profileIds.Contains(m.ID)).ToList();
var repoCan_Location = new Can_LocationRepository(unitOfWork);
var lstLocation = repoCan_Location.FindBy(s => s.IsDelete == null).ToList();
if (lstProfileIds != null && lstProfileIds.Count >= 1)
{
profiles = profiles.Where(s => lstProfileIds.Contains(s.ID)).ToList();
}
if (workPlaceIds != null && workPlaceIds[0] != null)
{
profiles = profiles.Where(s => workPlaceIds.Contains(s.WorkPlaceID)).ToList();
}
if(isCludeEmpQuit != true)
{
profiles = profiles.Where(s => s.DateQuit == null || s.DateQuit > dateEnd).ToList();
}
profileIds = profiles.Select(s => s.ID).ToList();
mealRecords = mealRecords.Where(s => profileIds.Contains(s.ProfileID.Value)).ToList();
var lstcateringids = mealRecords.Select(m => m.CateringID).ToList();
var lstcanteenids = mealRecords.Select(m => m.CanteenID).ToList();
var Cardcode = mealRecords.Select(s => s.ProfileID).Distinct().ToList();
var repoOrg = new Cat_OrgStructureRepository(unitOfWork);
var orgs = repoOrg.FindBy(m => m.Code != null).ToList();
if (CarteringIDs != null && CarteringIDs[0] != null)
{
mealRecords = mealRecords.Where(m => m.CateringID != null && CarteringIDs.Contains(m.CateringID)).ToList();
}
if (CanteenIDS != null && CanteenIDS[0] != null)
{
mealRecords = mealRecords.Where(m => m.CanteenID != null && CanteenIDS.Contains(m.CanteenID)).ToList();
}
if (LineIDS != null && LineIDS[0] != null)
{
mealRecords = mealRecords.Where(m => m.LineID != null && LineIDS.Contains(m.LineID)).ToList();
}
var repocanteen = new Can_CanteenRepository(unitOfWork);
if (eatLocationIds != null && eatLocationIds[0] != null)
{
var lstcanteenbylocation = repocanteen.FindBy(c => c.IsDelete == null && c.LocationID != null && eatLocationIds.Contains(c.LocationID.Value));
var lstcanteenbylocationID = lstcanteenbylocation.Select(s => s.ID).ToList();
mealRecords = mealRecords.Where(s => s.CanteenID != null && lstcanteenbylocationID.Contains(s.CanteenID.Value)).ToList();
}
if (mealRecords == null && mealRecords.Count < 1)
{
return datatable;
}
var repoWorkLocation = new Cat_WorkPlaceRepository(unitOfWork);
var lstWorkPlace = repoWorkLocation.GetAll().ToList();
var repocatering = new Can_CateringRepository(unitOfWork);
var caterings = repocatering.GetAll().ToList();
var canteens = repocanteen.GetAll().ToList();
var repoline = new Can_LineRepository(unitOfWork);
var lines = repoline.GetAll().ToList();
var orgTypes = new List<Cat_OrgStructureType>();
var repoCat_OrgStructureType = new Cat_OrgStructureTypeRepository(unitOfWork);
orgTypes = repoCat_OrgStructureType.FindBy(s => s.IsDelete == null).ToList<Cat_OrgStructureType>();
foreach (var profile in profiles)
{
for (DateTime date = dateStart; date <= dateEnd; date = date.AddDays(1))
{
var meal = mealRecords.FirstOrDefault(s => s.TimeLog != null && s.ProfileID == profile.ID && s.TimeLog.Value.Date == date.Date);
if (meal != null)
{
DataRow row = datatable.NewRow();
var cateen = canteens.FirstOrDefault(s => s.ID == meal.CanteenID);
var cate = caterings.FirstOrDefault(s => s.ID == meal.CateringID);
var line = lines.FirstOrDefault(s => s.ID == meal.LineID);
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);
row[Can_ReportCardByLocationEntity.FieldNames.BranchName] = orgBranch != null ? orgBranch.Code : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.DepartmentName] = orgOrg != null ? orgOrg.Code : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.TeamName] = orgTeam != null ? orgTeam.Code : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.SectionName] = orgSection != null ? orgSection.Code : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.CodeEmp] = profile.CodeEmp;
row[Can_ReportCardByLocationEntity.FieldNames.ProfileName] = profile.ProfileName;
row[Can_ReportCardByLocationEntity.FieldNames.DateFrom] = dateStart;
row[Can_ReportCardByLocationEntity.FieldNames.DateTo] = dateEnd;
row[Can_ReportCardByLocationEntity.FieldNames.DatePrint] = DateTime.Now;
var location = cateen != null ? cateen.LocationID : null;
row[Can_ReportCardByLocationEntity.FieldNames.CateringName] = cate != null ? cate.CateringName : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.CanteenName] = cateen != null ? cateen.CanteenName : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.LineName] = line != null ? line.LineName : string.Empty;
if (lstWorkPlace != null && lstWorkPlace.Count > 0)
{
var workPlaceByPro = lstWorkPlace.Where(m => m.ID == profile.WorkPlaceID).FirstOrDefault();
row[Can_ReportCardByLocationEntity.FieldNames.WorkLocationCode] = workPlaceByPro != null ? workPlaceByPro.Code : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.WorkLocationHD] = workPlaceByPro != null ? workPlaceByPro.WorkPlaceName : string.Empty;
}
if (location != null && location != Guid.Empty)
{
var locationname = lstLocation.Where(s => s.ID == location).FirstOrDefault();
row[Can_ReportCardByLocationEntity.FieldNames.EatLoCationCode] = location != null ? locationname.LocationCode : string.Empty;
row[Can_ReportCardByLocationEntity.FieldNames.EatLoCationHD] = location != null ? locationname.LocationName : string.Empty;
}
if (meal.WorkDay != null)
{
row["Data" + date.Day] = meal.WorkDay.Value.ToString(ConstantFormat.HRM_Format_Grid_ShortTime);
row[Can_ReportCardByLocationEntity.FieldNames.Quantity] = 1;
}
row[Can_ReportCardByLocationEntity.FieldNames.Amount] = (object)meal.Amount ?? DBNull.Value;
row[Can_ReportCardByLocationEntity.FieldNames.Date] = meal.WorkDay;
if (meal.TimeLog != null)
{
row[Can_ReportCardByLocationEntity.FieldNames.Hour] = meal.TimeLog.Value;
}
datatable.Rows.Add(row);
}
}
}
}
return datatable;
}