/// <summary>
/// [Hieu.Van]
/// Xử lý Gửi yêu cầu phê duyệt
/// </summary>
/// <param name="LoginID"></param>
/// <param name="userApprovedID"></param>
/// <param name="recordID"></param>
/// <param name="type"></param>
/// <returns></returns>
public string ProcessSendRequest(string host, Guid LoginID, Guid userApprovedID, Guid recordID, string type)
{
DataErrorCode status = DataErrorCode.Success;
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoFIN_PurchaseRequest = new CustomBaseRepository <FIN_PurchaseRequest>(unitOfWork);
var repoSys_UserApprove = new CustomBaseRepository <Sys_UserApprove>(unitOfWork);
var record = repoFIN_PurchaseRequest.FindBy(s => s.ID == recordID).FirstOrDefault();
if (record.UserCreateID != LoginID)
{
return(DataErrorCode.NoPermission.ToString());
}
if (record.Status == EnumDropDown.Status.E_REJECTED.ToString())
{
return(DataErrorCode.Error_Reject.ToString());
}
if (record.Status != null)
{
return(DataErrorCode.Error_SendRequest.ToString());
}
var userApproved = repoSys_UserApprove.FindBy(s => s.ID == userApprovedID).FirstOrDefault();
// Lấy status hiện tại của bản ghi
string currentStatus = record.Status;
// truyền từ Dropdownlist chọn người duyệt, lấy ra giá trị Status tiếp theo
string nextStatus = userApproved.CurrentStatus;
record.Status = nextStatus;
record.UserApproveID = userApprovedID;
repoFIN_PurchaseRequest.Edit(record);
status = repoFIN_PurchaseRequest.SaveChanges();
if (status == DataErrorCode.Success)
{
if (nextStatus != "Approved")
{
status = SendMail_ToNextApproved(host, recordID, userApprovedID, nextStatus, type);
}
var repoSys_ConfigProcessApprove = new CustomBaseRepository <Sys_ConfigProcessApprove>(unitOfWork);
var configProcess = repoSys_ConfigProcessApprove.FindBy(s => s.IsDelete == null && s.Function == type && s.CurrentStatus == record.Status).FirstOrDefault();
if (configProcess == null)
{
return(DataErrorCode.Success.ToString());
}
else
{
return(DataErrorCode.Success_Forward.ToString());
}
}
return(status.ToString());
}
}
public bool AddList(List<Att_AnnualLeaveDetailEntity> models)
{
bool isSuccess = false;
var leaveType = string.Empty;
var status = string.Empty;
var year = 2013;
if (models != null && models.FirstOrDefault() != null && models.FirstOrDefault().Year != null)
{
year = Convert.ToInt32(models.FirstOrDefault().Year);
leaveType = models.FirstOrDefault().Type;
}
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new CustomBaseRepository<Att_AnnualLeaveDetail>(unitOfWork);
try
{
var annualLeaveDetails = GetAllUseEntity<Att_AnnualLeaveDetail>(ref status).Where(p => p.Type == leaveType && p.Year == year).ToList().AsQueryable();
foreach (var attAnnualLeaveDetail in models)
{
var addSuccess = false;
var existAnnualDetail = annualLeaveDetails.Where(p => p.ProfileID == attAnnualLeaveDetail.ProfileID ).FirstOrDefault();
if (existAnnualDetail != null)
{
existAnnualDetail.Month1 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month2 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month3 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month4 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month5 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month6 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month7 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month8 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month9 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month10 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month11 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month12 = attAnnualLeaveDetail.Month1;
repo.Edit(existAnnualDetail);
}
else
{
Att_AnnualLeaveDetail temp = new Att_AnnualLeaveDetail();
temp = attAnnualLeaveDetail.CopyData<Att_AnnualLeaveDetail>();
repo.Add(temp);
}
}
repo.SaveChanges();
return true;
}
catch
{
return false;
}
}
}
public bool AddList(List <Att_AnnualLeaveDetailEntity> models)
{
bool isSuccess = false;
var leaveType = string.Empty;
var status = string.Empty;
var year = 2013;
if (models != null && models.FirstOrDefault() != null && models.FirstOrDefault().Year != null)
{
year = Convert.ToInt32(models.FirstOrDefault().Year);
leaveType = models.FirstOrDefault().Type;
}
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new CustomBaseRepository <Att_AnnualLeaveDetail>(unitOfWork);
try
{
var annualLeaveDetails = GetAllUseEntity <Att_AnnualLeaveDetail>(ref status).Where(p => p.Type == leaveType && p.Year == year).ToList().AsQueryable();
foreach (var attAnnualLeaveDetail in models)
{
var addSuccess = false;
var existAnnualDetail = annualLeaveDetails.Where(p => p.ProfileID == attAnnualLeaveDetail.ProfileID).FirstOrDefault();
if (existAnnualDetail != null)
{
existAnnualDetail.Month1 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month2 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month3 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month4 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month5 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month6 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month7 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month8 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month9 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month10 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month11 = attAnnualLeaveDetail.Month1;
existAnnualDetail.Month12 = attAnnualLeaveDetail.Month1;
repo.Edit(existAnnualDetail);
}
else
{
Att_AnnualLeaveDetail temp = new Att_AnnualLeaveDetail();
temp = attAnnualLeaveDetail.CopyData <Att_AnnualLeaveDetail>();
repo.Add(temp);
}
}
repo.SaveChanges();
return(true);
}
catch
{
return(false);
}
}
}
public void SetCompensationLeaveBeginYear(List <Guid> lstProfileIDs, double?limitMaximum, int Year, int?MonthResetANL, Guid?AllowanceTypeID, Guid?CuttOffDurationID)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_CompensationConfig = new CustomBaseRepository <Att_CompensationConfig>(unitOfWork);
DateTime EndLastYear = new DateTime(Year - 1, 12, 1);
List <Att_CompensationDetail> lstCompensationDetail = unitOfWork.CreateQueryable <Att_CompensationDetail>(m => m.MonthYear == EndLastYear &&
m.ProfileID != null &&
lstProfileIDs.Contains(m.ProfileID.Value)).ToList();
var lstCompensationLeaveInDB = unitOfWork.CreateQueryable <Att_CompensationConfig>(m => m.Year == Year && m.ProfileID != null && lstProfileIDs.Contains(m.ProfileID.Value)).ToList();
List <Att_CompensationConfig> lstNewData = new List <Att_CompensationConfig>();
List <Att_CompensationConfig> lstEditData = new List <Att_CompensationConfig>();
foreach (var ProfileID in lstProfileIDs)
{
Att_CompensationConfig CompensationLeaveConfigByProfile = lstCompensationLeaveInDB.Where(m => m.ProfileID == ProfileID).FirstOrDefault();
bool IsNew = false;
if (CompensationLeaveConfigByProfile == null)
{
IsNew = true;
CompensationLeaveConfigByProfile = new Att_CompensationConfig();
CompensationLeaveConfigByProfile.ID = Guid.NewGuid();
CompensationLeaveConfigByProfile.ProfileID = ProfileID;
CompensationLeaveConfigByProfile.Year = Year;
}
CompensationLeaveConfigByProfile.MonthResetInitAvailable = MonthResetANL;
double RemainLastYear = lstCompensationDetail.Where(m => m.ProfileID == ProfileID).Select(m => m.Remain ?? 0).FirstOrDefault();
if (limitMaximum != null)
{
CompensationLeaveConfigByProfile.InitAvailable = RemainLastYear > limitMaximum.Value ? limitMaximum.Value : RemainLastYear;
}
else
{
CompensationLeaveConfigByProfile.InitAvailable = RemainLastYear;
}
if (IsNew)
{
lstNewData.Add(CompensationLeaveConfigByProfile);
}
else
{
lstEditData.Add(CompensationLeaveConfigByProfile);
}
//Sửa lại theo phần tử mới mà Sơn build
}
repoAtt_CompensationConfig.Add(lstNewData);
repoAtt_CompensationConfig.Edit(lstEditData);
unitOfWork.SaveChanges();
}
}
public void SetCompensationLeaveBeginYear(List<Guid> lstProfileIDs, double? limitMaximum, int Year, int? MonthResetANL, Guid? AllowanceTypeID, Guid? CuttOffDurationID)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_CompensationConfig = new CustomBaseRepository<Att_CompensationConfig>(unitOfWork);
DateTime EndLastYear = new DateTime(Year - 1, 12, 1);
List<Att_CompensationDetail> lstCompensationDetail = unitOfWork.CreateQueryable<Att_CompensationDetail>(m => m.MonthYear == EndLastYear
&& m.ProfileID != null
&& lstProfileIDs.Contains(m.ProfileID.Value)).ToList();
var lstCompensationLeaveInDB = unitOfWork.CreateQueryable<Att_CompensationConfig>(m => m.Year == Year && m.ProfileID != null && lstProfileIDs.Contains(m.ProfileID.Value)).ToList();
List<Att_CompensationConfig> lstNewData = new List<Att_CompensationConfig>();
List<Att_CompensationConfig> lstEditData = new List<Att_CompensationConfig>();
foreach (var ProfileID in lstProfileIDs)
{
Att_CompensationConfig CompensationLeaveConfigByProfile = lstCompensationLeaveInDB.Where(m => m.ProfileID == ProfileID).FirstOrDefault();
bool IsNew = false;
if (CompensationLeaveConfigByProfile == null)
{
IsNew = true;
CompensationLeaveConfigByProfile = new Att_CompensationConfig();
CompensationLeaveConfigByProfile.ID = Guid.NewGuid();
CompensationLeaveConfigByProfile.ProfileID = ProfileID;
CompensationLeaveConfigByProfile.Year = Year;
}
CompensationLeaveConfigByProfile.MonthResetInitAvailable = MonthResetANL;
double RemainLastYear = lstCompensationDetail.Where(m => m.ProfileID == ProfileID).Select(m => m.Remain ?? 0).FirstOrDefault();
if (limitMaximum != null)
{
CompensationLeaveConfigByProfile.InitAvailable = RemainLastYear > limitMaximum.Value ? limitMaximum.Value : RemainLastYear;
}
else
{
CompensationLeaveConfigByProfile.InitAvailable = RemainLastYear;
}
if (IsNew)
{
lstNewData.Add(CompensationLeaveConfigByProfile);
}
else
{
lstEditData.Add(CompensationLeaveConfigByProfile);
}
//Sửa lại theo phần tử mới mà Sơn build
}
repoAtt_CompensationConfig.Add(lstNewData);
repoAtt_CompensationConfig.Edit(lstEditData);
unitOfWork.SaveChanges();
}
}
/// <summary>
/// [Chuc.Nguyen] - Chỉnh sửa một danh sách đối tượng
/// </summary>
/// <typeparam name="TEntity"></typeparam>
/// <param name="listEntity"></param>
/// <returns></returns>
public string Edit <TEntity>(List <TEntity> listEntity) where TEntity : class
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new CustomBaseRepository <TEntity>(unitOfWork);
try
{
repo.Edit(listEntity);
var status = repo.SaveChanges();
if (status == DataErrorCode.Locked)
{
return(NotificationType.Locked.ToString());
}
else
{
return(NotificationType.Success.ToString());
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
return(NotificationType.Error + "," + exceptionMessage);
}
catch (Exception ex)
{
return(NotificationType.Error + "," + ex.Message);
}
}
}
/// <summary>
/// [Hieu.Van]
/// Xử lý Từ Chối
/// </summary>
/// <param name="LoginID"></param>
/// <param name="userApprovedID"></param>
/// <param name="recordID"></param>
/// <param name="type"></param>
/// <returns></returns>
public string ProcessReject(string host, Guid LoginID, Guid recordID, string type)
{
DataErrorCode status = DataErrorCode.Success;
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoFIN_PurchaseRequest = new CustomBaseRepository <FIN_PurchaseRequest>(unitOfWork);
var repoSys_UserApprove = new CustomBaseRepository <Sys_UserApprove>(unitOfWork);
var repoSys_UserInfo = new CustomBaseRepository <Sys_UserInfo>(unitOfWork);
var record = repoFIN_PurchaseRequest.FindBy(s => s.ID == recordID).FirstOrDefault();
if (record.Status == EnumDropDown.Status.E_REJECTED.ToString())
{
return(DataErrorCode.Error_Reject.ToString());
}
var userApproved = repoSys_UserApprove.FindBy(s => s.ID == record.UserApproveID).FirstOrDefault();
// Kiểm tra tài khoản login có được phép Duyệt hay ko?
if (LoginID == Guid.Empty || userApproved.UserApproveID != LoginID)
{
// kiểm tra nếu bản ghi có tk duyệt trống (tức bản ghi mới tạo) và tk login = tk tạo thì cho duyệt tiếp tục
if (record.UserApproveID == null && record.UserCreateID == LoginID)
{
}
else
{
return(DataErrorCode.NoPermission.ToString());
}
}
record.Status = EnumDropDown.Status.E_REJECTED.ToString();
repoFIN_PurchaseRequest.Edit(record);
status = repoFIN_PurchaseRequest.SaveChanges();
return(status.ToString());
}
}
public string SaveOvertimePermitConfig(OvertimePermitEntity entity, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoSys_AllSetting = new CustomBaseRepository<Sys_AllSetting>(unitOfWork);
Sys_AllSetting sys = new Sys_AllSetting();
string HRM_ATT_OT_OTPERMIT_ = AppConfig.HRM_ATT_OT_OTPERMIT_.ToString();
string status = string.Empty;
List<object> lstO = new List<object>();
lstO.Add(HRM_ATT_OT_OTPERMIT_);
lstO.Add(null);
lstO.Add(null);
var config = GetData<Sys_AllSetting>(lstO, ConstantSql.hrm_sys_sp_get_AllSetting, userLogin, ref status);
if (config != null)
{
if (entity.limitHour_ByDay.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByDay.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByDay.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY.ToString();
objConfig.Value1 = entity.limitHour_ByDay.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByDay_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByDay_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByDay_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByDay_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByDay_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByDay_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByDay_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByDay_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByWeek.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByWeek.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByWeek.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK.ToString();
objConfig.Value1 = entity.limitHour_ByWeek.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByWeek_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByWeek_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByWeek_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByWeek_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByWeek_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByWeek_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByWeek_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByWeek_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByMonth.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByMonth.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByMonth.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH.ToString();
objConfig.Value1 = entity.limitHour_ByMonth.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByMonth_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByMonth_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByMonth_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByMonth_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByMonth_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByMonth_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByMonth_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByMonth_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByYear.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByYear.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByYear.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR.ToString();
objConfig.Value1 = entity.limitHour_ByYear.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByYear_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByYear_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByYear_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByYear_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByYear_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByYear_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByYear_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByYear_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (!string.IsNullOrEmpty(entity.limitColor))
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitColor)
{
objConfig.Value1 = entity.limitColor;
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR.ToString();
objConfig.Value1 = entity.limitColor;
repoSys_AllSetting.Add(objConfig);
}
}
if (!string.IsNullOrEmpty(entity.limitColor_Lev1))
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitColor_Lev1)
{
objConfig.Value1 = entity.limitColor_Lev1;
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV1.ToString();
objConfig.Value1 = entity.limitColor_Lev1;
repoSys_AllSetting.Add(objConfig);
}
}
if (!string.IsNullOrEmpty(entity.limitColor_Lev2))
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitColor_Lev2)
{
objConfig.Value1 = entity.limitColor_Lev2;
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV2.ToString();
objConfig.Value1 = entity.limitColor_Lev2;
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_Normal.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_Normal.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_Normal.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_Normal.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_Normal_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_Normal_Lev1.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV1.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_Normal_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_Normal_Lev2.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV2.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_AllowOver.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_AllowOver.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_AllowOver_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_AllowOver_Lev1.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV1.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_AllowOver_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_AllowOver_Lev2.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV2.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowSplit.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWSPLIT.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowSplit.Value.ToString())
{
objConfig.Value1 = entity.IsAllowSplit.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWSPLIT.ToString();
objConfig.Value1 = entity.IsAllowSplit.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
}
repoSys_AllSetting.SaveChanges();
return "0";
}
}
/// <summary>
/// [Hieu.Van]
/// Xử lý duyệt động đa cấp
/// ProcessApproved (Tài khoản Login - LoginID, Value Dropdownlist - userApprovedID, Id Bản ghi - recordID, Enum màn hình - type)
/// </summary>
/// <param name="LoginID"></param>
/// <param name="userApprovedID"></param>
/// <param name="recordID"></param>
/// <param name="type"></param>
/// <returns></returns>
public string ProcessApproved(string host, Guid LoginID, Guid userApprovedID, Guid recordID, string type)
{
DataErrorCode status = DataErrorCode.Success;
string stt = string.Empty;
var Services = new BaseService();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoFIN_PurchaseRequest = new CustomBaseRepository <FIN_PurchaseRequest>(unitOfWork);
var repoSys_UserApprove = new CustomBaseRepository <Sys_UserApprove>(unitOfWork);
var repoSys_ConfigProcessApprove = new CustomBaseRepository <Sys_ConfigProcessApprove>(unitOfWork);
var UserLogin = string.Empty;
var record = GetData <FIN_PurchaseRequestEntity>(recordID, ConstantSql.hrm_hr_sp_get_PurchaseRequestById, UserLogin, ref stt).FirstOrDefault();
var configProcess = repoSys_ConfigProcessApprove.FindBy(s => s.IsDelete == null && s.Function == type && s.CurrentStatus == record.Status).FirstOrDefault();
double total = record.Total != null ? record.Total.Value : 0.0;
List <ElementFormula> listFomula = new List <ElementFormula>();
ElementFormula FomulaItem = new ElementFormula("Total", total, 0);
ElementFormula statusItem = new ElementFormula(configProcess.NextStatusFormular, configProcess.NextStatusFormular, 1);
listFomula.Add(FomulaItem);
listFomula.Add(statusItem);
string nextStatus = Services.GetObjectValue(new List <Cat_ElementEntity>(), listFomula, configProcess.NextStatusFormular).ToString();
if (configProcess != null && userApprovedID == Guid.Empty && nextStatus != "Approved")
{
return(DataErrorCode.Error_NoUserApproved.ToString());
}
if (record.Status == EnumDropDown.Status.E_REJECTED.ToString())
{
return(DataErrorCode.Error_Reject.ToString());
}
var recordEdit = repoFIN_PurchaseRequest.FindBy(s => s.ID == recordID).FirstOrDefault();
// lấy UserInfoID hiện tại của bản ghi
var userApprovedCurrent = repoSys_UserApprove.FindBy(s => s.ID == recordEdit.UserApproveID).FirstOrDefault();
// Kiểm tra tài khoản login có được phép Duyệt hay ko?
if (LoginID == Guid.Empty || userApprovedCurrent.UserApproveID != LoginID)
{
// kiểm tra nếu bản ghi có tk duyệt trống (tức bản ghi mới tạo) và tk login = tk tạo thì cho duyệt tiếp tục
if (recordEdit.UserApproveID == null && record.UserCreateID == LoginID)
{
}
else
{
return(DataErrorCode.NoPermission.ToString());
}
}
recordEdit.Status = nextStatus;
if (userApprovedID == Guid.Empty)
{
recordEdit.UserApproveID = null;
}
else
{
recordEdit.UserApproveID = userApprovedID;
}
repoFIN_PurchaseRequest.Edit(recordEdit);
status = repoFIN_PurchaseRequest.SaveChanges();
if (nextStatus != "Approved")
{
status = SendMail_ToNextApproved(host, recordID, userApprovedID, nextStatus, type);
}
if (status == DataErrorCode.Success)
{
//var configProcess = repoSys_ConfigProcessApprove.FindBy(s => s.IsDelete == null && s.Function == type && s.CurrentStatus == nextStatus).FirstOrDefault();
if (nextStatus == "Approved")
{
return(DataErrorCode.Success.ToString());
}
else
{
return(DataErrorCode.Success_Forward.ToString());
}
}
return(status.ToString());
}
}
/// <summary>
/// [Hieu.van] Tổng Hợp giặt là
/// </summary>
/// <param name="dateStart"></param>
/// <param name="dateEnd"></param>
/// <param name="lstProfileIDs"></param>
/// <returns></returns>
public List<LMS_LaundryRecordEntity> GetLaundryRecordSummary(string _line, string _locker, string _marker, DateTime dateStart, DateTime dateEnd, List<Hre_ProfileEntity> lstProfileIDs,string UserLogin)
{
dateStart = dateStart.Date;
dateEnd = dateEnd.Date.AddDays(1).AddMilliseconds(-1);
string status = string.Empty;
//string strIDs = string.Join(",", lstProfileIDs.ToArray());
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoLau_TamScanLog = new CustomBaseRepository<LMS_TamScanLogLMS>(unitOfWork);
var repoLau_Line = new CustomBaseRepository<LMS_LineLMS>(unitOfWork);
var repoLau_Locker = new CustomBaseRepository<LMS_LockerLMS>(unitOfWork);
var repoLau_Marker = new CustomBaseRepository<LMS_Marker>(unitOfWork);
var repoLau_LaundryRecord = new CustomBaseRepository<LMS_LaundryRecord>(unitOfWork);
var repoSys_AllSetting = new CustomBaseRepository<Sys_AllSetting>(unitOfWork);
#region cấu hình số phút xử lý trùng
int rsScanMulti = 0;
var rsScanMultiConfig = GetData<Sys_AllSetting>(AppConfig.HRM_LAU_LAUNDRYRECORD_SCANMULTI_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey,UserLogin, ref status).FirstOrDefault();
if (rsScanMultiConfig != null)
{
rsScanMulti = rsScanMultiConfig.Value1 != null ? int.Parse(rsScanMultiConfig.Value1.ToString()) : 0;
dateStart = dateStart.Date.AddHours(rsScanMulti);
dateEnd = dateEnd.Date.AddDays(1).AddHours(rsScanMulti).AddMilliseconds(-1);
}
#endregion
var tamScanLogs = repoLau_TamScanLog
.FindBy(s => dateStart <= s.TimeLog && s.TimeLog <= dateEnd)
.Select(s => new { s.Code, s.TimeLog, s.ID, s.MachineCode })
//.Select(s => new { s.MachineCode, s.CardCode, s.TimeLog, s.Id })
.ToList();
var cardCodes = tamScanLogs.Select(s => s.Code).ToList();
//strIDs = Common.DotNetToOracle(strIDs);
//var profiles = GetData<Hre_ProfileEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status)
// .Where(s => cardCodes.Contains(s.CodeAttendance) && lstProfileIDs.Contains(s.ID))
var profiles = lstProfileIDs
.Where(s => cardCodes.Contains(s.CodeAttendance))
.Select(s => new { s.ID, s.CodeAttendance, s.CodeEmp, s.ProfileName, s.OrgStructureName }).ToList();
tamScanLogs = tamScanLogs
.Where(s => profiles.Select(p => p.CodeAttendance).Contains(s.Code))
.OrderBy(s => s.Code)
.ThenBy(s => s.TimeLog)
.ToList();
#region lấy line-locker-marker và xử lý khi tìm kiếm
var lines = repoLau_Line.FindBy(s => s.IsDelete == null).ToList();
var Lockers = repoLau_Locker.FindBy(s => s.IsDelete == null).ToList();
var Markers = repoLau_Marker.FindBy(s => s.IsDelete == null).ToList();
if (_line != null)
{
List<Guid> lstLine = _line.Split(',').Select(Guid.Parse).ToList();
lines = lines.Where(s => lstLine.Contains(s.ID)).ToList();
}
if (_locker != null)
{
List<Guid> lstLocker = _locker.Split(',').Select(Guid.Parse).ToList();
Lockers = Lockers.Where(s => lstLocker.Contains(s.ID)).ToList();
}
if (_marker != null)
{
List<Guid> lstMarker = _marker.Split(',').Select(Guid.Parse).ToList();
Markers = Markers.Where(s => lstMarker.Contains(s.ID)).ToList();
}
#endregion
List<object> lstObj = new List<object>();
lstObj.Add(dateStart);
lstObj.Add(dateEnd);
List<Lau_LaundryRecordCheckEntity> laundryCheckList = GetData<Lau_LaundryRecordCheckEntity>(lstObj, ConstantSql.hrm_lau_sp_get_LaundryRecord_ByDateFromDateTo, UserLogin, ref status);
LMS_LaundryRecordEntity laundry = new LMS_LaundryRecordEntity();
List<LMS_LaundryRecordEntity> lstRecord = new List<LMS_LaundryRecordEntity>();
List<LMS_LaundryRecord> lstAdd = new List<LMS_LaundryRecord>();
List<LMS_LaundryRecord> lstEdit = new List<LMS_LaundryRecord>();
List<Guid> lstDuplicateTamScan = new List<Guid>();
foreach (var tamScanLog in tamScanLogs)
{
if (lstDuplicateTamScan.Contains(tamScanLog.ID))
continue;
laundry = new LMS_LaundryRecordEntity();
var profile = profiles.FirstOrDefault(s => s.CodeAttendance == tamScanLog.Code);
var line = lines.FirstOrDefault(s => tamScanLog.MachineCode == s.MachineCode);
if (profile != null && line != null)
{
#region xử lý bản ghi trùng
var tamScanLogProfiles = tamScanLogs
.Where(s => s.Code == tamScanLog.Code && s.TimeLog.Value.Date == tamScanLog.TimeLog.Value.Date && s.MachineCode == tamScanLog.MachineCode)
.OrderBy(s => s.TimeLog)
.ToList();
if (tamScanLogProfiles.Count > 1 && rsScanMulti > 0)
{
for (int i = 0; i < tamScanLogProfiles.Count; i++)
{
var tamsanFirst = tamScanLogProfiles[i];
int j = i + 1;
if (j > tamScanLogProfiles.Count - 1)
{
j = i;
}
var tamsanNear = tamScanLogProfiles[j];
if (tamsanNear.TimeLog.Value.Subtract(tamsanFirst.TimeLog.Value).TotalMinutes < rsScanMulti && tamsanFirst.ID != tamsanNear.ID)
{
if (tamsanFirst.MachineCode == tamsanNear.MachineCode)
{
lstDuplicateTamScan.Add(tamsanNear.ID);
break;
}
}
}
}
#endregion
#region xử lý add record
laundry.ProfileID = profile.ID;
laundry.ProfileName = profile.ProfileName;
laundry.CodeAttendance = profile.CodeAttendance;
laundry.TimeLog = tamScanLog.TimeLog;
laundry.Status = HRM.Infrastructure.Utilities.LaundryRecordStatus.E_SUBMIT.ToString();
laundry.Type = LaundryRecordType.E_AUTO.ToString();
if (tamScanLog.MachineCode != null)
{
laundry.MachineCode = tamScanLog.MachineCode;
if (line != null)
{
laundry.LineLMSName = line.LineLMSName;
laundry.LineID = line.ID;
laundry.Amount = (decimal)line.Amount;
if (line.LockerID != null)
{
var locker = Lockers.Where(c => c.ID == line.LockerID).FirstOrDefault();
laundry.LockerLMSName = locker.LockerLMSName;
laundry.LockerID = locker.ID;
}
if (line.MarkerID != null)
{
var marker = Markers.Where(c => c.ID == line.MarkerID).FirstOrDefault();
laundry.MarkerName = marker.MarkerName;
laundry.MarkerID = marker.ID;
}
}
}
laundry.DateCreate = DateTime.Now;
var recordAdd = laundry.CopyData<LMS_LaundryRecord>();
var CheckList = laundryCheckList.Where(s => s.ProfileID == laundry.ProfileID.Value && s.TimeLog == laundry.TimeLog).ToList();
if (CheckList != null)
{
if (CheckList.Count() > 0)
{
var idUpdate = CheckList.FirstOrDefault();
recordAdd.ID = idUpdate.ID;
repoLau_LaundryRecord.Edit(recordAdd);
//lstEdit.Add(recordAdd);
}
else
{
recordAdd.ID = Guid.NewGuid();
repoLau_LaundryRecord.Add(recordAdd);
//lstAdd.Add(recordAdd);
}
}
laundry.ID = tamScanLog.ID;
lstRecord.Add(laundry);
#endregion
}
}
repoLau_LaundryRecord.SaveChanges();
//if (lstAdd.Any())
//{
// repoLau_LaundryRecord.Add(lstAdd);
// repoLau_LaundryRecord.SaveChanges();
//}
//if (lstEdit.Any())
//{
// repoLau_LaundryRecord.Edit(lstEdit);
// repoLau_LaundryRecord.SaveChanges();
//}
if (lstRecord.Count > 0)
{
Sys_AllSetting sys = new Sys_AllSetting();
Sys_AllSetting rs = GetData<Sys_AllSetting>(AppConfig.HRM_LAU_LAUNDRYRECORD_SUMMARY.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey,UserLogin, ref status).FirstOrDefault();
sys.Value1 = dateStart.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Value2 = dateEnd.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Name = AppConfig.HRM_LAU_LAUNDRYRECORD_SUMMARY.ToString();
if (rs != null)
{
sys.ID = rs.ID;
repoSys_AllSetting.Edit(sys);
}
else
{
sys.ID = Guid.NewGuid();
repoSys_AllSetting.Add(sys);
}
repoSys_AllSetting.SaveChanges();
}
return lstRecord;
}
}
private List <Att_AnnualDetail> AnalyzeAnnualDetail(List <Hre_ProfileMultiField> lstProfile, int Year, bool?isFullEmp, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_AnnualDetail = new CustomBaseRepository <Att_AnnualDetail>(unitOfWork);
List <Att_AnnualDetail> lstResult = new List <Att_AnnualDetail>();
List <Guid> lstProfileID = lstProfile.Select(m => m.ID).ToList();
int BeginMonth = MonthStartAnl;
DateTime BeginYear = new DateTime(Year, BeginMonth, 1);
DateTime EndYear = BeginYear.AddYears(1).AddMinutes(-1);
DateTime BeginYearToGetData = BeginYear.AddMonths(-1); //trừ một tháng để lấy data (bao những data thuộc những ngày trước tháng dành cho chế độ lương ko phải từ ngày 1)
var lstGradeCgf = unitOfWork.CreateQueryable <Cat_GradeAttendance>().ToList();
var lstLeaveDayTypeAnnual = unitOfWork.CreateQueryable <Cat_LeaveDayType>(s => s.IsAnnualLeave == true).ToList();
List <Guid> lstAnnualTypeID = lstLeaveDayTypeAnnual.Select(s => s.ID).ToList();
string E_APPROVED = LeaveDayStatus.E_APPROVED.ToString();
var lstAnnualDetailInDB_Query = unitOfWork.CreateQueryable <Att_AnnualDetail>(m => m.ProfileID != null && m.Year == Year);
var lstLeaveDayAnl_Query = unitOfWork.CreateQueryable <Att_LeaveDay>(m =>
m.Status == E_APPROVED &&
m.DateStart <= EndYear &&
m.DateEnd >= BeginYearToGetData &&
m.LeaveDayTypeID != null &&
lstAnnualTypeID.Contains(m.LeaveDayTypeID));
var lstAttGrade_Query = unitOfWork.CreateQueryable <Att_Grade>();
var lstAnualLeaveCfg_Query = unitOfWork.CreateQueryable <Att_AnnualLeave>(m => m.Year == Year);
var lstlstRoster_Query = unitOfWork.CreateQueryable <Att_Roster>(m =>
m.Status == E_APPROVED &&
m.DateStart <= EndYear &&
m.DateEnd >= BeginYearToGetData);
if (isFullEmp != null && isFullEmp.Value == false)
{
lstAnnualDetailInDB_Query = lstAnnualDetailInDB_Query.Where(m => m.ProfileID != null && lstProfileID.Contains(m.ProfileID.Value));
lstLeaveDayAnl_Query = lstLeaveDayAnl_Query.Where(m => lstProfileID.Contains(m.ProfileID));
lstAttGrade_Query = lstAttGrade_Query.Where(m => m.ProfileID != null && lstProfileID.Contains(m.ProfileID.Value));
lstAnualLeaveCfg_Query = lstAnualLeaveCfg_Query.Where(m => lstProfileID.Contains(m.ProfileID));
lstlstRoster_Query = lstlstRoster_Query.Where(m => lstProfileID.Contains(m.ProfileID));
}
var lstAnnualDetailInDB = lstAnnualDetailInDB_Query.ToList();
var lstLeaveDayAnl = lstLeaveDayAnl_Query.Select(m => new Att_LeaveDayInfo()
{
ID = m.ID
,
ProfileID = m.ProfileID
,
DateStart = m.DateStart
,
DateEnd = m.DateEnd
,
LeaveDayTypeID = m.LeaveDayTypeID
,
TotalDuration = m.TotalDuration
,
Duration = m.Duration
,
DurationType = m.DurationType
,
LeaveDays = m.LeaveDays
,
LeaveHours = m.LeaveHours
}).ToList();
var lstAttGrade = lstAttGrade_Query.ToList();
var lstAnualLeaveCfg = lstAnualLeaveCfg_Query.ToList();
var lstRoster = lstlstRoster_Query.Select(m => new Att_RosterInfo()
{
ID = m.ID, ProfileID = m.ProfileID, Type = m.Type, MonShiftID = m.MonShiftID, TueShiftID = m.TueShiftID, WedShiftID = m.WedShiftID, ThuShiftID = m.ThuShiftID, FriShiftID = m.FriShiftID, SatShiftID = m.SatShiftID, SunShiftID = m.SunShiftID
}).ToList();
var lstRosterGroup = unitOfWork.CreateQueryable <Att_RosterGroup>(m => m.DateStart <= EndYear && m.DateEnd >= BeginYearToGetData).ToList();
var lstDayOff = unitOfWork.CreateQueryable <Cat_DayOff>(m => m.DateOff >= BeginYearToGetData && m.DateOff <= EndYear).ToList();
// Phép Năm chốt Từ Ngày 1 -> 31 Hàng Tháng
bool IsFrom1To31 = false;
string type2 = AppConfig.HRM_ATT_ANNUALLEAVE_ANNUALBEGINMONTHTOENDMONTH.ToString();
Sys_AllSetting sys_ANNUAL_BEGINMONTHTO_ENDMONTH = unitOfWork.CreateQueryable <Sys_AllSetting>(sy => sy.Name == type2).FirstOrDefault();
if (sys_ANNUAL_BEGINMONTHTO_ENDMONTH != null && sys_ANNUAL_BEGINMONTHTO_ENDMONTH.Value1 == bool.TrueString)
{
IsFrom1To31 = true;
}
List <Guid> lstPositionIDs = lstProfile.Where(m => m.PositionID != null).Select(m => m.PositionID.Value).Distinct().ToList();
List <Cat_Position> lstPosition = unitOfWork.CreateQueryable <Cat_Position>(m => lstPositionIDs.Contains(m.ID)).ToList <Cat_Position>();
var lstAllSetting = unitOfWork.CreateQueryable <Sys_AllSetting>().ToList();
var lstHDTJob = new List <Hre_HDTJob>();
foreach (var templstProfileId in lstProfileID.Chunk(1000))
{
lstHDTJob.AddRange(unitOfWork.CreateQueryable <Hre_HDTJob>(Guid.Empty, m => m.ProfileID != null && templstProfileId.Contains(m.ProfileID.Value)).ToList());
}
foreach (var profile in lstProfile)
{
var lstGradeByProfile = lstAttGrade.Where(m => m.ProfileID == profile.ID).OrderByDescending(m => m.MonthStart).ToList();
var lstLeaveDayByprofile = lstLeaveDayAnl.Where(m => m.ProfileID == profile.ID).ToList();
var AnualLeaveCfg = lstAnualLeaveCfg.Where(m => m.ProfileID == profile.ID).FirstOrDefault();
var lstRosterByProfile = lstRoster.Where(m => m.ProfileID == profile.ID).ToList();
var position = lstPosition.Where(m => m.ID == profile.PositionID).FirstOrDefault();
List <Att_AnnualDetail> lstAnnualDetailByProfile_Update = new List <Att_AnnualDetail>();
List <Att_AnnualDetail> lstAnnualDetailByProfile = AnalyzeAnnualDetailPerProfile(profile,
lstGradeCgf, lstGradeByProfile, BeginYear, EndYear, lstLeaveDayByprofile, lstAnnualDetailInDB,
AnualLeaveCfg, lstRosterByProfile, lstRosterGroup, lstDayOff, IsFrom1To31,
position, lstAllSetting, lstHDTJob, out lstAnnualDetailByProfile_Update, userLogin);
lstResult.AddRange(lstAnnualDetailByProfile);
lstResult.AddRange(lstAnnualDetailByProfile_Update);
repoAtt_AnnualDetail.Add(lstAnnualDetailByProfile);
repoAtt_AnnualDetail.Edit(lstAnnualDetailByProfile_Update);
}
repoAtt_AnnualDetail.SaveChanges();
return(lstResult);
}
}
/// <summary>
/// Lấy tất cả các bản ghi
/// Get by key
/// </summary>
/// <returns></returns>
public void SaveConfig(List<Dictionary<string,string>> lstModel)
{
using (var context = new VnrHrmDataContext())
{
IUnitOfWork unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new CustomBaseRepository<Sys_AllSetting>(unitOfWork);
string status = string.Empty;
List<Dictionary<Guid, string>> lstUpdate = new List<Dictionary<Guid, string>>();
var valueTemp = new Sys_AllSetting();
var modelTemp = new Sys_AllSetting();
List<Guid> lstConfigIds = new List<Guid>();
List<Sys_AllSetting> lstAdd = new List<Sys_AllSetting>();
List<Sys_AllSetting> lstEdit = new List<Sys_AllSetting>();
List<Sys_AllSetting> lstDel = new List<Sys_AllSetting>();
var getdata = repo.FindBy(s => s.IsDelete == null).ToList();
if (lstModel[0].FirstOrDefault().Value.Length > 0)
{
var lstStr = lstModel.FirstOrDefault()["lstConfigIds"].Split(',');
lstConfigIds = lstStr.Select(Guid.Parse).ToList();
}
foreach (var item in lstConfigIds)
{
modelTemp = GetById<Sys_AllSetting>(item, ref status);
lstUpdate.Add(new Dictionary<Guid, string>() { { modelTemp.ID, modelTemp.Name } });
}
for (int i = 1; i < lstModel.Count; i++)
{
var lstEntity = getdata.Where(s => s.Name == lstModel[i].FirstOrDefault().Key).ToList();
if (lstEntity.Count == 0)
{
valueTemp = new Sys_AllSetting();
valueTemp.ID = Guid.NewGuid();
valueTemp.Name = lstModel[i].FirstOrDefault().Key;
valueTemp.Value1 = lstModel[i].FirstOrDefault().Value;
lstAdd.Add(valueTemp);
continue;
}
if (lstEntity.Count > 0)
{
valueTemp = new Sys_AllSetting();
foreach (var item in lstEntity)
{
item.IsDelete = true;
lstDel.Add(item);
//repo.Edit(item);
}
var isUpdate = lstUpdate.Where(s => s.FirstOrDefault().Value == lstModel[i].FirstOrDefault().Key).FirstOrDefault();
if (isUpdate != null)
{
valueTemp.ID = lstEntity.FirstOrDefault().ID;
valueTemp.Name = lstModel[i].FirstOrDefault().Key;
valueTemp.Value1 = lstModel[i].FirstOrDefault().Value;
valueTemp.IsDelete = null;
lstEdit.Add(valueTemp);
}
else
{
valueTemp.ID = Guid.NewGuid();
valueTemp.Name = lstModel[i].FirstOrDefault().Key;
valueTemp.Value1 = lstModel[i].FirstOrDefault().Value;
lstAdd.Add(valueTemp);
}
}
}
repo.Edit(lstDel);
repo.Add(lstAdd);
repo.Edit(lstEdit);
repo.SaveChanges();
}
}
/// <summary>
/// [Hieu.Van]
/// Xử lý Từ Chối
/// </summary>
/// <param name="LoginID"></param>
/// <param name="userApprovedID"></param>
/// <param name="recordID"></param>
/// <param name="type"></param>
/// <returns></returns>
public string ProcessReject(string host, Guid LoginID, Guid recordID, string type)
{
DataErrorCode status = DataErrorCode.Success;
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoFIN_PurchaseRequest = new CustomBaseRepository<FIN_PurchaseRequest>(unitOfWork);
var repoSys_UserApprove = new CustomBaseRepository<Sys_UserApprove>(unitOfWork);
var repoSys_UserInfo = new CustomBaseRepository<Sys_UserInfo>(unitOfWork);
var record = repoFIN_PurchaseRequest.FindBy(s => s.ID == recordID).FirstOrDefault();
if (record.Status == EnumDropDown.Status.E_REJECTED.ToString())
{
return DataErrorCode.Error_Reject.ToString();
}
var userApproved = repoSys_UserApprove.FindBy(s => s.ID == record.UserApproveID).FirstOrDefault();
// Kiểm tra tài khoản login có được phép Duyệt hay ko?
if (LoginID == Guid.Empty || userApproved.UserApproveID != LoginID)
{
// kiểm tra nếu bản ghi có tk duyệt trống (tức bản ghi mới tạo) và tk login = tk tạo thì cho duyệt tiếp tục
if (record.UserApproveID == null && record.UserCreateID == LoginID)
{
}
else
{
return DataErrorCode.NoPermission.ToString();
}
}
record.Status = EnumDropDown.Status.E_REJECTED.ToString();
repoFIN_PurchaseRequest.Edit(record);
status = repoFIN_PurchaseRequest.SaveChanges();
return status.ToString();
}
}
public void SetSickLeaveBeginYear(List<Guid> lstProfileIDs, double? limitMaximum, int Year)
{
//Đối với phép ốm thì tạm thời tính từ đầu năm đến cuối năm
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_AnnualLeave = new CustomBaseRepository<Att_AnnualLeave>(unitOfWork);
var repoCat_LeaveDayType = new CustomBaseRepository<Cat_LeaveDayType>(unitOfWork);
var repoAtt_LeaveDay = new CustomBaseRepository<Att_LeaveDay>(unitOfWork);
int LastYear = Year - 1;
DateTime beginLastYear = new DateTime(LastYear, 1, 1);
DateTime endLastYear = beginLastYear.AddYears(1).AddMinutes(-1);
List<Guid> SickLeaveType = repoCat_LeaveDayType.FindBy(m => m.IsDelete == null && m.Code == "SICK").Select(m => m.ID).ToList();
string Approve = LeaveDayStatus.E_APPROVED.ToString();
var lstLeaveDay = repoAtt_LeaveDay.FindBy(m =>
m.IsDelete == null
&& m.Status == Approve
&& m.DateStart < endLastYear
&& m.DateEnd >= beginLastYear
&& SickLeaveType.Contains(m.LeaveDayTypeID)
&& lstProfileIDs.Contains(m.ProfileID)).Select(m => new { m.ProfileID, m.TotalDuration }).ToList();
List<Att_AnnualLeave> lstAnnualLeaveInDB = repoAtt_AnnualLeave.FindBy(m => m.IsDelete == null && (m.Year == Year || m.Year == LastYear) && lstProfileIDs.Contains(m.ProfileID)).ToList();
foreach (var ProfileID in lstProfileIDs)
{
Att_AnnualLeave AnnualLeaveByProfile = lstAnnualLeaveInDB.Where(m => m.ProfileID == ProfileID && m.Year == Year).FirstOrDefault();
Att_AnnualLeave AnnualLeaveByProfile_Last = lstAnnualLeaveInDB.Where(m => m.ProfileID == ProfileID && m.Year == LastYear).FirstOrDefault();
bool IsNew = false;
if (AnnualLeaveByProfile == null)
{
IsNew = true;
AnnualLeaveByProfile = new Att_AnnualLeave();
AnnualLeaveByProfile.ID = Guid.NewGuid();
AnnualLeaveByProfile.ProfileID = ProfileID;
AnnualLeaveByProfile.Year = Year;
AnnualLeaveByProfile.MonthStart = 1;
}
double InitLastYear = 0;
if (AnnualLeaveByProfile_Last != null)
InitLastYear = AnnualLeaveByProfile_Last.InitSickValue;
double remainLastYear = InitLastYear - lstLeaveDay.Where(m => m.ProfileID == ProfileID).Sum(m => m.TotalDuration ?? 0);
if (limitMaximum != null)
{
AnnualLeaveByProfile.InitSickValue = remainLastYear > limitMaximum.Value ? limitMaximum.Value : remainLastYear;
AnnualLeaveByProfile.SurplusSicklastYear = remainLastYear > limitMaximum ? remainLastYear - limitMaximum : 0;
}
else
{
AnnualLeaveByProfile.InitSickValue = remainLastYear;
AnnualLeaveByProfile.SurplusSicklastYear = 0;
}
if (IsNew)
{
repoAtt_AnnualLeave.Add(AnnualLeaveByProfile);
}
else
{
repoAtt_AnnualLeave.Edit(AnnualLeaveByProfile);
}
}
repoAtt_AnnualLeave.SaveChanges();
}
}
public string SaveOvertimePermitConfig(OvertimePermitEntity entity, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoSys_AllSetting = new CustomBaseRepository <Sys_AllSetting>(unitOfWork);
Sys_AllSetting sys = new Sys_AllSetting();
string HRM_ATT_OT_OTPERMIT_ = AppConfig.HRM_ATT_OT_OTPERMIT_.ToString();
string status = string.Empty;
List <object> lstO = new List <object>();
lstO.Add(HRM_ATT_OT_OTPERMIT_);
lstO.Add(null);
lstO.Add(null);
var config = GetData <Sys_AllSetting>(lstO, ConstantSql.hrm_sys_sp_get_AllSetting, userLogin, ref status);
if (config != null)
{
if (entity.limitHour_ByDay.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByDay.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByDay.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY.ToString();
objConfig.Value1 = entity.limitHour_ByDay.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByDay_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByDay_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByDay_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByDay_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByDay_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByDay_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByDay_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYDAY_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByDay_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByWeek.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByWeek.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByWeek.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK.ToString();
objConfig.Value1 = entity.limitHour_ByWeek.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByWeek_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByWeek_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByWeek_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByWeek_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByWeek_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByWeek_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByWeek_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYWEEK_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByWeek_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByMonth.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByMonth.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByMonth.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH.ToString();
objConfig.Value1 = entity.limitHour_ByMonth.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByMonth_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByMonth_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByMonth_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByMonth_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByMonth_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByMonth_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByMonth_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYMONTH_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByMonth_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByYear.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByYear.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByYear.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR.ToString();
objConfig.Value1 = entity.limitHour_ByYear.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByYear_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByYear_Lev1.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByYear_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV1.ToString();
objConfig.Value1 = entity.limitHour_ByYear_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.limitHour_ByYear_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitHour_ByYear_Lev2.Value.ToString())
{
objConfig.Value1 = entity.limitHour_ByYear_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITHOUR_BYYEAR_LEV2.ToString();
objConfig.Value1 = entity.limitHour_ByYear_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (!string.IsNullOrEmpty(entity.limitColor))
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitColor)
{
objConfig.Value1 = entity.limitColor;
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR.ToString();
objConfig.Value1 = entity.limitColor;
repoSys_AllSetting.Add(objConfig);
}
}
if (!string.IsNullOrEmpty(entity.limitColor_Lev1))
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitColor_Lev1)
{
objConfig.Value1 = entity.limitColor_Lev1;
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV1.ToString();
objConfig.Value1 = entity.limitColor_Lev1;
repoSys_AllSetting.Add(objConfig);
}
}
if (!string.IsNullOrEmpty(entity.limitColor_Lev2))
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.limitColor_Lev2)
{
objConfig.Value1 = entity.limitColor_Lev2;
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_LIMITCOLOR_LEV2.ToString();
objConfig.Value1 = entity.limitColor_Lev2;
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_Normal.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_Normal.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_Normal.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_Normal.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_Normal_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_Normal_Lev1.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV1.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_Normal_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_Normal_Lev2.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_NORMAL_LEV2.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_Normal_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_AllowOver.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_AllowOver.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_AllowOver_Lev1.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV1.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_AllowOver_Lev1.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev1.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV1.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev1.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowOverLimit_AllowOver_Lev2.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV2.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowOverLimit_AllowOver_Lev2.Value.ToString())
{
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev2.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWOVERLIMIT_ALLOWOVER_LEV2.ToString();
objConfig.Value1 = entity.IsAllowOverLimit_AllowOver_Lev2.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
if (entity.IsAllowSplit.HasValue)
{
var objConfig = config.Where(s => s.Name == AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWSPLIT.ToString()).FirstOrDefault();
if (objConfig != null)
{
if (objConfig.Value1 != entity.IsAllowSplit.Value.ToString())
{
objConfig.Value1 = entity.IsAllowSplit.Value.ToString();
repoSys_AllSetting.Edit(objConfig);
}
}
else
{
objConfig.ID = Guid.NewGuid();
objConfig.Name = AppConfig.HRM_ATT_OT_OTPERMIT_ISALLOWSPLIT.ToString();
objConfig.Value1 = entity.IsAllowSplit.Value.ToString();
repoSys_AllSetting.Add(objConfig);
}
}
}
repoSys_AllSetting.SaveChanges();
return("0");
}
}
public List<Can_MealRecordEntity> GetMealRecordSummary(string _line, string _catering, string _canteen, DateTime dateStart, DateTime dateEnd, List<Hre_ProfileEntity> lstProfileIDs, string UserLogin)
{
dateStart = dateStart.Date;
dateEnd = dateEnd.Date.AddDays(1).AddMilliseconds(-1);
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_MealRecord = new CustomBaseRepository<Can_MealRecord>(unitOfWork);
var repoCan_TamScanLog = new CustomBaseRepository<Can_TamScanLogCMS>(unitOfWork);
var repoCan_Line = new CustomBaseRepository<Can_Line>(unitOfWork);
var repoCan_Canteen = new CustomBaseRepository<Can_Canteen>(unitOfWork);
var repoCan_Catering = new CustomBaseRepository<Can_Catering>(unitOfWork);
var repoSys_AllSetting = new CustomBaseRepository<Sys_AllSetting>(unitOfWork);
string status = string.Empty;
//string strIDs = string.Join(",", lstProfileIDs.ToArray());
#region xử lý cấu hình giờ kết thúc ăn - DateStart & DateEnd
DateTime dateConfig = DateTime.MinValue;
var rsTimeConfig = GetData<Sys_AllSettingEntity>(AppConfig.HRM_CAN_MEALRECORD_EATEND_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
if (rsTimeConfig != null && rsTimeConfig.Value1 != null)
{
dateConfig = DateTimeHelper.ConvertStringToDateTime(rsTimeConfig.Value1, ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond_ffffff.ToString());
}
double hourConfig = dateConfig.Hour + (((double)dateConfig.Minute) / 60);
dateStart = dateStart.Date.AddHours(hourConfig);
dateEnd = dateEnd.Date.AddDays(1).AddHours(hourConfig).AddMilliseconds(-1);
#endregion
#region cấu hình số phút xử lý trùng
int rsScanMulti = 0;
var rsScanMultiConfig = GetData<Sys_AllSettingEntity>(AppConfig.HRM_CAN_MEALRECORD_SCANMULTI_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
if (rsScanMultiConfig != null)
{
rsScanMulti = rsScanMultiConfig.Value1 != null ? int.Parse(rsScanMultiConfig.Value1.ToString()) : 0;
}
#endregion
var tamScanLogs = repoCan_TamScanLog
.FindBy(s => dateStart <= s.TimeLog && s.TimeLog <= dateEnd)
.Select(s => new { s.MachineCode, s.CardCode, s.TimeLog, s.ID })
.ToList();
var cardCodes = tamScanLogs.Select(s => s.CardCode).ToList();
//strIDs = Common.DotNetToOracle(strIDs);
//var profiles = GetData<Hre_ProfileEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status)
// .Where(s => cardCodes.Contains(s.CodeAttendance) && lstProfileIDs.Contains(s.ID))
var profiles = lstProfileIDs
.Where(s => cardCodes.Contains(s.CodeAttendance))
.Select(s => new { s.ID, s.CodeAttendance, s.CodeEmp, s.ProfileName, s.OrgStructureName }).ToList();
tamScanLogs = tamScanLogs.Where(s => profiles.Select(p => p.CodeAttendance).Contains(s.CardCode)).OrderBy(s => s.CardCode).ThenBy(s=>s.TimeLog).ToList();
var lines = repoCan_Line.FindBy(s => s.IsDelete == null).ToList();
var canteens = repoCan_Canteen.FindBy(s => s.IsDelete == null).ToList();
var caterings = repoCan_Catering.FindBy(s => s.IsDelete == null).ToList();
if (_line != null)
{
List<Guid> lstLine = _line.Split(',').Select(Guid.Parse).ToList();
lines = lines.Where(s => lstLine.Contains(s.ID)).ToList();
}
if (_canteen != null)
{
List<Guid> lstcanteen = _canteen.Split(',').Select(Guid.Parse).ToList();
canteens = canteens.Where(s => lstcanteen.Contains(s.ID)).ToList();
}
if (_catering != null)
{
List<Guid> lstcatering = _catering.Split(',').Select(Guid.Parse).ToList();
caterings = caterings.Where(s => lstcatering.Contains(s.ID)).ToList();
}
List<object> lstObj = new List<object>();
lstObj.Add(dateStart);
lstObj.Add(dateEnd);
List<Can_MealRecordCheckEntity> mealRecordCheckList = GetData<Can_MealRecordCheckEntity>(lstObj, ConstantSql.hrm_can_sp_get_MealRecord_ByDateFromDateTo, UserLogin, ref status);
Can_MealRecordEntity record = new Can_MealRecordEntity();
List<Can_MealRecordEntity> lstRecord = new List<Can_MealRecordEntity>();
List<Can_MealRecord> lstEdit = new List<Can_MealRecord>();
List<Can_MealRecord> lstAdd = new List<Can_MealRecord>();
List<Guid> lstDuplicateTamScan = new List<Guid>();
foreach (var tamScanLog in tamScanLogs)
{
if (lstDuplicateTamScan.Contains(tamScanLog.ID))
continue;
record = new Can_MealRecordEntity();
var profile = profiles.FirstOrDefault(s => s.CodeAttendance == tamScanLog.CardCode);
var line = lines.FirstOrDefault(s => tamScanLog.MachineCode == s.MachineCode);
if (profile != null && line != null)
{
#region xử lý quẹt thẻ trùng theo HRM_CAN_MEALRECORD_SCANMULTI_CONFIG
var tamScanLogProfiles = tamScanLogs
.Where(s => s.CardCode == tamScanLog.CardCode && s.TimeLog.Value.Date == tamScanLog.TimeLog.Value.Date && s.MachineCode == tamScanLog.MachineCode)
.OrderBy(s => s.TimeLog)
.ToList();
if (tamScanLogProfiles.Count > 1 && rsScanMulti > 0)
{
for (int i = 0; i < tamScanLogProfiles.Count; i++)
{
var tamsanFirst = tamScanLogProfiles[i];
int j = i + 1;
if (j > tamScanLogProfiles.Count - 1)
{
j = i;
}
var tamsanNear = tamScanLogProfiles[j];
if (tamsanNear.TimeLog.Value.Subtract(tamsanFirst.TimeLog.Value).TotalMinutes < rsScanMulti
&& tamsanFirst.ID != tamsanNear.ID )
{
if (tamsanFirst.MachineCode == tamsanNear.MachineCode)
{
lstDuplicateTamScan.Add(tamsanNear.ID);
break;
}
}
}
}
#endregion
#region xử lý add record
record.TimeLog = tamScanLog.TimeLog.HasValue ? tamScanLog.TimeLog.Value : DateTime.MinValue;
if (record.TimeLog < record.TimeLog.Value.Date.AddHours(hourConfig))
{
record.WorkDay = record.TimeLog.Value.AddDays(-1);
}
else
{
record.WorkDay = record.TimeLog;
}
if (tamScanLog.MachineCode != null)
{
record.MachineCode = tamScanLog.MachineCode;
if (line != null)
{
record.LineName = line.LineName;
record.LineID = line.ID;
record.Amount = (decimal)line.Amount;
if (line.CanteenID != null)
{
var cant = canteens.Where(c => c.ID == line.CanteenID).FirstOrDefault();
record.CanteenName = cant.CanteenName;
record.CanteenID = line.CanteenID;
}
if (line.CateringID != null)
{
var cater = caterings.Where(c => c.ID == line.CateringID).FirstOrDefault();
record.CateringName = cater.CateringName;
record.CateringID = line.CateringID;
}
}
}
record.ProfileName = profile.ProfileName;
record.CodeEmp = profile.CodeEmp;
record.OrgStructureName = profile.OrgStructureName;
record.CodeAttendance = profile.CodeAttendance;
record.DateCreate = DateTime.Now;
var recordAdd = record.CopyData<Can_MealRecord>();
recordAdd.ProfileID = profile.ID;
var CheckList = mealRecordCheckList.Where(s => s.ProfileID == profile.ID && s.TimeLog == tamScanLog.TimeLog).ToList();
if (CheckList != null)
{
if (CheckList.Count() > 0)
{
var idUpdate = CheckList.FirstOrDefault();
recordAdd.ID = idUpdate.ID;
//lstEdit.Add(recordAdd);
repoCan_MealRecord.Edit(recordAdd);
}
else
{
recordAdd.ID = Guid.NewGuid();
repoCan_MealRecord.Add(recordAdd);
//lstAdd.Add(recordAdd);
}
}
record.ID = tamScanLog.ID;
lstRecord.Add(record);
#endregion
}
}
repoCan_MealRecord.SaveChanges();
if (lstRecord.Count > 0)
{
Sys_AllSetting sys = new Sys_AllSetting();
Sys_AllSetting rs = GetData<Sys_AllSetting>(AppConfig.HRM_CAN_MEALRECORD_SUMMARY.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
sys.Value1 = dateStart.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Value2 = dateEnd.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Name = AppConfig.HRM_CAN_MEALRECORD_SUMMARY.ToString();
if (rs != null)
{
sys.ID = rs.ID;
repoSys_AllSetting.Edit(sys);
}
else
{
sys.ID = Guid.NewGuid();
repoSys_AllSetting.Add(sys);
}
repoSys_AllSetting.SaveChanges();
}
//lstRecord.Where().(s => s.MealAllowanceTypeName = ConstantDisplay.HRM_Enum_Submit.TranslateString()).ToList();
return lstRecord;
}
}
///// <summary>
///// Lấy toàn bộ data
///// </summary>
///// <returns></returns>
//public IQueryable<Att_AnnualLeave> Get()
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// return repo.Get().Where(i => i.IsDelete == null);
// }
//}
///// <summary>
///// Lấy dữ liệu theo Id
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public Att_AnnualLeaveEntity Get(int id)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetAnnualLeaveById(id);
// if (data.IsDelete == true) data = null;
// return data;
// }
//}
//public List<Att_AnnualLeaveEntity> GetAnnualLeaveByIds(string selectedIds)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// return repo.GetAnnualLeaveByIds(selectedIds);
// }
//}
///// <summary>
///// Thêm mới một record
///// </summary>
///// <param name="cat"></param>
///// <returns></returns>
//public bool Add(Att_AnnualLeave model)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// try
// {
// repo.Add(model);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
///// <summary>
///// Edit một record
///// </summary>
///// <param name="cat"></param>
///// <returns></returns>
//public bool Edit(Att_AnnualLeave model)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// try
// {
// repo.Edit(model);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
///// <summary>
///// Remove 1 record là chuyển trạng thái IsDelete=true
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public bool Remove(int id)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetById(id);
// try
// {
// repo.Remove(data);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
///// <summary>
///// Delete 1 record là xóa luôn record khỏi database
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public bool Delete(int id)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetById(id);
// try
// {
// repo.Delete(data);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
//#region Store Procedure
//#region Danh sách
///// <summary>
///// Lấy danh sách dữ liệu AnnualLeaves [Tung.Ly - 2014/05/09]
///// </summary>
///// <returns></returns>
//public IQueryable<Att_AnnualLeaveEntity> GetAnnualLeaves(ListQueryModel model)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// IAtt_AnnualLeaveRepository repo = new Att_AnnualLeaveRepository(unitOfWork);
// var rs = repo.GetAnnualLeaves(model);
// return rs;
// }
//}
//#endregion
//#region Chi tiet
///// <summary>
///// Lấy dữ liệu AnnualLeave theo Id [Tung.Ly - 2014/05/09]
///// </summary>
///// <param name="annualLeaveId"></param>
///// <returns></returns>
//public Att_AnnualLeaveEntity GetAnnualLeaveById(int annualLeaveId)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// IAtt_AnnualLeaveRepository repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetAnnualLeaveById(annualLeaveId);
// return data;
// }
//}
//#endregion
//#endregion
#endregion
#region thanh toán phép năm đầu kỳ
public void SetAnnualLeaveBeginYear(List<Guid> lstProfileIDs, double? limitMaximum, int Year, int? MonthResetANL, Guid? AllowanceTypeID, Guid? CuttOffDurationID)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_AnnualLeave = new CustomBaseRepository<Att_AnnualLeave>(unitOfWork);
var repoAtt_AnnualDetail = new CustomBaseRepository<Att_AnnualDetail>(unitOfWork);
var repoSal_UnusualAllowance = new CustomBaseRepository<Sal_UnusualAllowance>(unitOfWork);
var repoAtt_CutOffDuration = new CustomBaseRepository<Att_CutOffDuration>(unitOfWork);
//nếu có rồi thì chỉ cần Update
//Nếu chưa có thì tạo mới
Att_CutOffDuration CutOffDuration = new Att_CutOffDuration();
if (CuttOffDurationID != null)
{
CutOffDuration = repoAtt_CutOffDuration.FindBy(m => m.ID == CuttOffDurationID).FirstOrDefault();
}
int LastYear = Year - 1;
DateTime? MaxTime = repoAtt_AnnualDetail.FindBy(m => m.IsDelete != null && m.Year == LastYear).OrderByDescending(m => m.MonthYear).Select(m => m.MonthYear).FirstOrDefault();
List<Att_AnnualDetail> lstAnnualDetail = new List<Att_AnnualDetail>();
if (MaxTime != null)
{
lstAnnualDetail = repoAtt_AnnualDetail.FindBy(m => m.MonthYear == MaxTime
&& m.ProfileID != null
&& lstProfileIDs.Contains(m.ProfileID.Value)).ToList();
}
var lstAnnualLeaveInDB = repoAtt_AnnualLeave.FindBy(m => m.IsDelete == null && m.Year == Year && lstProfileIDs.Contains(m.ProfileID)).ToList();
foreach (var ProfileID in lstProfileIDs)
{
Att_AnnualLeave AnnualLeaveByProfile = lstAnnualLeaveInDB.Where(m => m.ProfileID == ProfileID).FirstOrDefault();
bool IsNew = false;
if (AnnualLeaveByProfile == null)
{
IsNew = true;
AnnualLeaveByProfile = new Att_AnnualLeave();
AnnualLeaveByProfile.ID = Guid.NewGuid();
AnnualLeaveByProfile.ProfileID = ProfileID;
AnnualLeaveByProfile.Year = Year;
AnnualLeaveByProfile.MonthStart = 1;
}
AnnualLeaveByProfile.MonthResetAnlOfBeforeYear = MonthResetANL;
double RemainLastYear = lstAnnualDetail.Where(m => m.ProfileID == ProfileID).Select(m => m.Remain ?? 0).FirstOrDefault();
if (limitMaximum != null)
{
AnnualLeaveByProfile.InitAnlValue = RemainLastYear > limitMaximum.Value ? limitMaximum.Value : RemainLastYear;
AnnualLeaveByProfile.SurplusAnllastYear = RemainLastYear > limitMaximum ? RemainLastYear - limitMaximum : 0;
if (CutOffDuration.ID != null && CutOffDuration.ID != Guid.Empty && AllowanceTypeID != null)
{
Sal_UnusualAllowance UnusualAllowance = new Sal_UnusualAllowance();
UnusualAllowance.ProfileID = ProfileID;
UnusualAllowance.MonthStart = CutOffDuration.DateStart;
UnusualAllowance.MonthEnd = CutOffDuration.DateEnd;
UnusualAllowance.UnusualEDTypeID = AllowanceTypeID;
UnusualAllowance.Amount = AnnualLeaveByProfile.SurplusAnllastYear;
repoSal_UnusualAllowance.Add(UnusualAllowance);
}
}
else
{
AnnualLeaveByProfile.InitAnlValue = RemainLastYear;
AnnualLeaveByProfile.SurplusAnllastYear = 0;
}
//Sửa lại theo phần tử mới mà Sơn build
if (IsNew)
{
repoAtt_AnnualLeave.Add(AnnualLeaveByProfile);
}
else
{
repoAtt_AnnualLeave.Edit(AnnualLeaveByProfile);
}
}
repoAtt_AnnualLeave.SaveChanges();
repoSal_UnusualAllowance.SaveChanges();
}
}
private List<Att_AnnualDetail> AnalyzeAnnualDetail(List<Hre_ProfileMultiField> lstProfile, int Year, bool? isFullEmp, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_AnnualDetail = new CustomBaseRepository<Att_AnnualDetail>(unitOfWork);
List<Att_AnnualDetail> lstResult = new List<Att_AnnualDetail>();
List<Guid> lstProfileID = lstProfile.Select(m => m.ID).ToList();
int BeginMonth = MonthStartAnl;
DateTime BeginYear = new DateTime(Year, BeginMonth, 1);
DateTime EndYear = BeginYear.AddYears(1).AddMinutes(-1);
DateTime BeginYearToGetData = BeginYear.AddMonths(-1); //trừ một tháng để lấy data (bao những data thuộc những ngày trước tháng dành cho chế độ lương ko phải từ ngày 1)
var lstGradeCgf = unitOfWork.CreateQueryable<Cat_GradeAttendance>().ToList();
var lstLeaveDayTypeAnnual = unitOfWork.CreateQueryable<Cat_LeaveDayType>(s => s.IsAnnualLeave == true).ToList();
List<Guid> lstAnnualTypeID = lstLeaveDayTypeAnnual.Select(s => s.ID).ToList();
string E_APPROVED = LeaveDayStatus.E_APPROVED.ToString();
var lstAnnualDetailInDB_Query = unitOfWork.CreateQueryable<Att_AnnualDetail>(m => m.ProfileID != null && m.Year == Year);
var lstLeaveDayAnl_Query = unitOfWork.CreateQueryable<Att_LeaveDay>(m =>
m.Status == E_APPROVED
&& m.DateStart <= EndYear
&& m.DateEnd >= BeginYearToGetData
&& m.LeaveDayTypeID != null
&& lstAnnualTypeID.Contains(m.LeaveDayTypeID));
var lstAttGrade_Query = unitOfWork.CreateQueryable<Att_Grade>();
var lstAnualLeaveCfg_Query = unitOfWork.CreateQueryable<Att_AnnualLeave>(m => m.Year == Year);
var lstlstRoster_Query = unitOfWork.CreateQueryable<Att_Roster>(m =>
m.Status == E_APPROVED
&& m.DateStart <= EndYear
&& m.DateEnd >= BeginYearToGetData);
if (isFullEmp != null && isFullEmp.Value == false)
{
lstAnnualDetailInDB_Query = lstAnnualDetailInDB_Query.Where(m => m.ProfileID != null && lstProfileID.Contains(m.ProfileID.Value));
lstLeaveDayAnl_Query = lstLeaveDayAnl_Query.Where(m => lstProfileID.Contains(m.ProfileID));
lstAttGrade_Query = lstAttGrade_Query.Where(m => m.ProfileID != null && lstProfileID.Contains(m.ProfileID.Value));
lstAnualLeaveCfg_Query = lstAnualLeaveCfg_Query.Where(m => lstProfileID.Contains(m.ProfileID));
lstlstRoster_Query = lstlstRoster_Query.Where(m => lstProfileID.Contains(m.ProfileID));
}
var lstAnnualDetailInDB = lstAnnualDetailInDB_Query.ToList();
var lstLeaveDayAnl = lstLeaveDayAnl_Query.Select(m => new Att_LeaveDayInfo()
{
ID = m.ID
,
ProfileID = m.ProfileID
,
DateStart = m.DateStart
,
DateEnd = m.DateEnd
,
LeaveDayTypeID = m.LeaveDayTypeID
,
TotalDuration = m.TotalDuration
,
Duration = m.Duration
,
DurationType = m.DurationType
,
LeaveDays = m.LeaveDays
,
LeaveHours = m.LeaveHours
}).ToList();
var lstAttGrade = lstAttGrade_Query.ToList();
var lstAnualLeaveCfg = lstAnualLeaveCfg_Query.ToList();
var lstRoster = lstlstRoster_Query.Select(m => new Att_RosterInfo() { ID = m.ID, ProfileID = m.ProfileID, Type = m.Type, MonShiftID = m.MonShiftID, TueShiftID = m.TueShiftID, WedShiftID = m.WedShiftID, ThuShiftID = m.ThuShiftID, FriShiftID = m.FriShiftID, SatShiftID = m.SatShiftID, SunShiftID = m.SunShiftID }).ToList();
var lstRosterGroup = unitOfWork.CreateQueryable<Att_RosterGroup>(m => m.DateStart <= EndYear && m.DateEnd >= BeginYearToGetData).ToList();
var lstDayOff = unitOfWork.CreateQueryable<Cat_DayOff>(m => m.DateOff >= BeginYearToGetData && m.DateOff <= EndYear).ToList();
// Phép Năm chốt Từ Ngày 1 -> 31 Hàng Tháng
bool IsFrom1To31 = false;
string type2 = AppConfig.HRM_ATT_ANNUALLEAVE_ANNUALBEGINMONTHTOENDMONTH.ToString();
Sys_AllSetting sys_ANNUAL_BEGINMONTHTO_ENDMONTH = unitOfWork.CreateQueryable<Sys_AllSetting>(sy => sy.Name == type2).FirstOrDefault();
if (sys_ANNUAL_BEGINMONTHTO_ENDMONTH != null && sys_ANNUAL_BEGINMONTHTO_ENDMONTH.Value1 == bool.TrueString)
{
IsFrom1To31 = true;
}
List<Guid> lstPositionIDs = lstProfile.Where(m => m.PositionID != null).Select(m => m.PositionID.Value).Distinct().ToList();
List<Cat_Position> lstPosition = unitOfWork.CreateQueryable<Cat_Position>(m => lstPositionIDs.Contains(m.ID)).ToList<Cat_Position>();
var lstAllSetting = unitOfWork.CreateQueryable<Sys_AllSetting>().ToList();
var lstHDTJob=new List<Hre_HDTJob>();
foreach (var templstProfileId in lstProfileID.Chunk(1000))
{
lstHDTJob.AddRange(unitOfWork.CreateQueryable<Hre_HDTJob>(Guid.Empty, m => m.ProfileID != null && templstProfileId.Contains(m.ProfileID.Value)).ToList());
}
foreach (var profile in lstProfile)
{
var lstGradeByProfile = lstAttGrade.Where(m => m.ProfileID == profile.ID).OrderByDescending(m => m.MonthStart).ToList();
var lstLeaveDayByprofile = lstLeaveDayAnl.Where(m => m.ProfileID == profile.ID).ToList();
var AnualLeaveCfg = lstAnualLeaveCfg.Where(m => m.ProfileID == profile.ID).FirstOrDefault();
var lstRosterByProfile = lstRoster.Where(m => m.ProfileID == profile.ID).ToList();
var position = lstPosition.Where(m => m.ID == profile.PositionID).FirstOrDefault();
List<Att_AnnualDetail> lstAnnualDetailByProfile_Update = new List<Att_AnnualDetail>();
List<Att_AnnualDetail> lstAnnualDetailByProfile = AnalyzeAnnualDetailPerProfile(profile,
lstGradeCgf, lstGradeByProfile, BeginYear, EndYear, lstLeaveDayByprofile, lstAnnualDetailInDB,
AnualLeaveCfg, lstRosterByProfile, lstRosterGroup, lstDayOff, IsFrom1To31,
position, lstAllSetting, lstHDTJob, out lstAnnualDetailByProfile_Update, userLogin);
lstResult.AddRange(lstAnnualDetailByProfile);
lstResult.AddRange(lstAnnualDetailByProfile_Update);
repoAtt_AnnualDetail.Add(lstAnnualDetailByProfile);
repoAtt_AnnualDetail.Edit(lstAnnualDetailByProfile_Update);
}
repoAtt_AnnualDetail.SaveChanges();
return lstResult;
}
}
public string ValidateSaveWorkday(Att_WorkdayEntity WorkdaySave, Att_WorkdayEntity WorkdayOld, string UserLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoHre_CardHistory = new CustomBaseRepository<Hre_CardHistory>(unitOfWork);
var repoHre_Profile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
var repoAtt_TAMScanLog = new CustomBaseRepository<Att_TAMScanLog>(unitOfWork);
var repoCat_Shift = new CustomBaseRepository<Cat_Shift>(unitOfWork);
var repoCat_TAMScanReasonMiss = new CustomBaseRepository<Cat_TAMScanReasonMiss>(unitOfWork);
var repoAtt_Workday = new CustomBaseRepository<Att_Workday>(unitOfWork);
string message = "";
List<Att_TAMScanLog> lstTamScanLog = new List<Att_TAMScanLog>();
string Notes = string.Empty;
#region cập nhật giờ intime va outtime
//1. xử lí việc insert vào TamScanlog
//2. xử lí việc chuyển in và out theo logic in phải nhỏ hơn out
//3. xử lý việc Validate inout không thẻ lơn hơn workday 1 ngày
DateTime? Intime1 = null;
if (WorkdaySave.InTime1 != null)
{
Intime1 = WorkdaySave.InTime1.Value.Date;
}
if (!string.IsNullOrEmpty(WorkdaySave.TempTimeIn) && Intime1.HasValue)
{
DateTime TimeScan = DateTime.ParseExact(WorkdaySave.TempTimeIn, "HH:mm:ss", null);
Intime1 = Intime1.Value.AddHours(TimeScan.Hour).AddMinutes(TimeScan.Minute).AddSeconds(TimeScan.Second);
}
DateTime? OutTime1 = null;
if (WorkdaySave.OutTime1 != null)
{
OutTime1 = WorkdaySave.InTime1.Value.Date;
}
if (!string.IsNullOrEmpty(WorkdaySave.TempTimeOut) && OutTime1.HasValue)
{
DateTime TimeScan = DateTime.ParseExact(WorkdaySave.TempTimeOut, "HH:mm:ss", null);
OutTime1 = OutTime1.Value.AddHours(TimeScan.Hour).AddMinutes(TimeScan.Minute).AddSeconds(TimeScan.Second);
}
Guid? MissInOutReason = WorkdaySave.MissInOutReason;
//Check validate ko cho phép Intime hoặc out time
if (((WorkdayOld.InTime1 == null && Intime1 != null) || (WorkdayOld.OutTime1 == null && OutTime1 != null)) && (MissInOutReason == null || MissInOutReason == Guid.Empty))
{
message = ConstantMessages.plsInputTAMScanReasonMissBeforeChangeInOut.TranslateString();
return message;
}
//Chuyển dổi vị trí in và out
if (Intime1 != null && OutTime1 != null && (Intime1 > OutTime1))
{
DateTime DateChange = Intime1.Value;
Intime1 = OutTime1;
OutTime1 = DateChange;
// DataBeChangedBecauseInTimeIsAfterOutTime
}
bool isChangeTamScan = false;
if (Intime1 != null)
{
if (WorkdayOld.InTime1 != Intime1)
{
Notes += "Intime1:" + string.Format("{0:dd/MM/yyyy hh:mm:ss}", Intime1);
}
if (WorkdayOld.InTime1 == null) //Thiếu Intime. Thì cập nhật vào lstTamscanLog
{
Att_TAMScanLog Tams = new Att_TAMScanLog();
Tams.ID = Guid.NewGuid();
Tams.TimeLog = Intime1;
Tams.Status = TAMScanStatus.E_MANUAL.ToString();
lstTamScanLog.Add(Tams);
isChangeTamScan = true;
}
else
{
string E_MANUAL = TAMScanStatus.E_MANUAL.ToString();
Att_TAMScanLog tamScan = repoAtt_TAMScanLog.FindBy(m => m.TimeLog == WorkdayOld.InTime1.Value && m.ProfileID == WorkdayOld.ProfileID && m.Status == E_MANUAL).FirstOrDefault();
if (tamScan != null)
{
tamScan.TimeLog = Intime1;
isChangeTamScan = true;
}
}
WorkdaySave.InTime1 = Intime1; //Cập nhật vào workday
}
else if (WorkdayOld.InTime1 != null && Intime1 == null)
{
Notes += "Intime1:" + "Null";
WorkdaySave.InTime1 = Intime1; //Cập nhật vào workday
string E_MANUAL = TAMScanStatus.E_MANUAL.ToString();
//Att_TAMScanLog tamScan = EntityService.CreateQueryable<Att_TAMScanLog>(false, GuidContext, Guid.Empty, m => m.TimeLog == WorkDay.InTime1.Value && m.ProfileID == WorkDay.ProfileID && m.Status == E_MANUAL).FirstOrDefault();
Att_TAMScanLog tamScan = repoAtt_TAMScanLog.FindBy(m => m.TimeLog == WorkdayOld.InTime1.Value && m.ProfileID == WorkdayOld.ProfileID && m.Status == E_MANUAL).FirstOrDefault();
if (tamScan != null)
{
tamScan.IsDelete = true;
}
}
if (OutTime1 != null)
{
if (WorkdayOld.OutTime1 != OutTime1)
{
Notes += "OutTime1:" + string.Format("{0:dd/MM/yyyy hh:mm:ss}", OutTime1);
}
if (WorkdayOld.OutTime1 == null) //Thiếu OutTime. Thì cập nhật vào lstTamscanLog
{
Att_TAMScanLog Tams = new Att_TAMScanLog();
Tams.ID = Guid.NewGuid();
Tams.TimeLog = OutTime1;
Tams.Status = TAMScanStatus.E_MANUAL.ToString();
lstTamScanLog.Add(Tams);
isChangeTamScan = true;
}
WorkdaySave.OutTime1 = OutTime1;
}
else if (WorkdayOld.OutTime1 != null && OutTime1 == null)
{
Notes += "OutTime1:" + "Null";
WorkdaySave.OutTime1 = OutTime1; //Cập nhật vào workday
//Att_TAMScanLog tamScan = EntityService.CreateQueryable<Att_TAMScanLog>(false, GuidContext, Guid.Empty, m => m.TimeLog == WorkDay.OutTime1.Value && m.ProfileID == WorkDay.ProfileID && m.Status == E_MANUAL).FirstOrDefault();
Att_TAMScanLog tamScan = repoAtt_TAMScanLog.FindBy(m => m.TimeLog == WorkdayOld.InTime1.Value && m.ProfileID == WorkdayOld.ProfileID && m.Status == TAMScanStatus.E_MANUAL.ToString()).FirstOrDefault();
if (tamScan != null)
{
tamScan.TimeLog = OutTime1;
isChangeTamScan = true;
}
}
#endregion
#region xử lý tamsCanLog
DateTime workdate = WorkdayOld.WorkDate;
string cardCode = string.Empty;
var Card = repoHre_CardHistory.FindBy(m => (!m.IsDelete.HasValue || m.IsDelete != true) && m.ProfileID == WorkdayOld.ProfileID && m.CardCode != null && m.DateEffect <= workdate).OrderByDescending(m => m.DateEffect).FirstOrDefault();
//Hre_CardHistoryEntity Card = EntityService.CreateQueryable<Hre_CardHistory>(false, GuidContext, Guid.Empty, m => m.ProfileID == WorkDay.ProfileID && m.CardCode != null && m.DateEffect <= workdate).OrderByDescending(m => m.DateEffect).FirstOrDefault();
if (Card != null)
{
cardCode = Card.CardCode;
}
else
{
string CodeAttendance = repoHre_Profile.FindBy(m => m.IsDelete == null && m.ID == WorkdayOld.ProfileID).Select(m => m.CodeAttendance).FirstOrDefault();
//string CodeAttendance = EntityService.CreateQueryable<Hre_Profile>(false, GuidContext, Guid.Empty, m => m.ID == WorkDay.ProfileID).Select(m => m.CodeAttendance).FirstOrDefault();
cardCode = CodeAttendance;
}
if (cardCode == string.Empty)
{
//return new { valid = true };
message = ConstantMessages.Error.TranslateString();
return message;
}
if (lstTamScanLog.Count > 0)
{
foreach (var Tam in lstTamScanLog)
{
Tam.CardCode = cardCode;
Tam.ProfileID = WorkdayOld.ProfileID;
}
//EntityService.AddEntity<Att_TAMScanLog>(GuidContext, lstTamScanLog.ToArray());
repoAtt_TAMScanLog.Add(lstTamScanLog);
}
#endregion
#region Xử lý Xóa Trong tamsCanLog
if (WorkdayOld.InTime1 != null && Intime1 == null)
{
string E_MANUAL = TAMScanStatus.E_MANUAL.ToString();
List<Att_TAMScanLog> tamScan = repoAtt_TAMScanLog.FindBy(m => m.IsDelete == null && m.TimeLog == WorkdayOld.InTime1 && m.CardCode == cardCode).ToList();
//List<Att_TAMScanLog> tamScan = EntityService.CreateQueryable<Att_TAMScanLog>(false, GuidContext, Guid.Empty, m => m.TimeLog == InTimeBeforeChanges.Value && m.CardCode == cardCode
// && m.Status == E_MANUAL).ToList<Att_TAMScanLog>();
if (tamScan != null && tamScan.Count > 0)
{
foreach (var item in tamScan)
{
item.IsDelete = true;
}
}
}
if (WorkdayOld.OutTime1 != null && OutTime1 == null)
{
string E_MANUAL = TAMScanStatus.E_MANUAL.ToString();
List<Att_TAMScanLog> tamScan = repoAtt_TAMScanLog.FindBy(m => m.IsDelete == null && m.TimeLog == WorkdayOld.OutTime1 && m.CardCode == cardCode).ToList();
//List<Att_TAMScanLog> tamScan = EntityService.CreateQueryable<Att_TAMScanLog>(false, GuidContext, Guid.Empty, m => m.TimeLog == OutTimeBeforeChanges.Value && m.CardCode == cardCode
// && m.Status == E_MANUAL).ToList<Att_TAMScanLog>();
if (tamScan.Count > 0)
{
foreach (var item in tamScan)
{
item.IsDelete = true;
}
}
}
#endregion
#region Thay đổi Shift
var ShiftAll = repoCat_Shift.FindBy(m => m.IsDelete == null).ToList();
Guid ShiftIDActual = Guid.Empty;
Guid ShiftIDApprove = Guid.Empty;
string ShiftCodeActual = string.Empty;
string ShiftCodeApprove = string.Empty;
var ShiftActual = ShiftAll.Where(m => m.ID == WorkdaySave.ShiftActual).FirstOrDefault();
var ShiftApprove = ShiftAll.Where(m => m.ID == WorkdaySave.ShiftApprove).FirstOrDefault();
if (ShiftActual != null)
{
ShiftIDActual = ShiftActual.ID;
ShiftCodeActual = ShiftActual.Code;
}
if (ShiftApprove != null)
{
ShiftIDApprove = ShiftApprove.ID;
ShiftCodeApprove = ShiftApprove.Code;
}
if (WorkdayOld.ShiftActual != ShiftIDActual)
{
Notes += "ShiftCodeActual:" + ShiftActual.Code;
Notes += "ShiftCodeApprove:" + ShiftActual.Code;
if (ShiftActual != null) // nếu như ShiftActual thay đổi thì thay đổi
{
ShiftIDActual = ShiftActual.ID;
ShiftCodeActual = ShiftActual.Code;
ShiftIDApprove = ShiftActual.ID;
ShiftCodeApprove = ShiftActual.Code;
}
}
else if (WorkdayOld.ShiftApprove != ShiftIDApprove)
{
Notes += "ShiftCodeApprove:" + ShiftCodeApprove;
}
WorkdaySave.ShiftActual = ShiftIDActual;
WorkdaySave.ShiftApprove = ShiftIDApprove;
#endregion
#region thay dổi lateEarly
string LateEarLyModify = string.Empty;
double MinuteLateEarly = 0;
if (WorkdaySave.LateEarlyDuration != null)
{
MinuteLateEarly = WorkdaySave.LateEarlyDuration.Value;
}
string LateEarlyReason = string.Empty;
if (!string.IsNullOrEmpty(WorkdaySave.LateEarlyReason))
{
LateEarlyReason = WorkdaySave.LateEarlyReason;
}
bool IsChangeLateEarly = false;
if (WorkdayOld.LateEarlyDuration != null && (WorkdayOld.LateEarlyDuration != MinuteLateEarly))
{
IsChangeLateEarly = true;
Notes += "LateEarlyDuration:" + MinuteLateEarly;
WorkdaySave.LateEarlyDuration = MinuteLateEarly;
}
if ((WorkdayOld.LateEarlyReason == null && !string.IsNullOrEmpty(LateEarlyReason)) || WorkdayOld.LateEarlyReason != LateEarlyReason)
{
Notes += "LateEarlyReason:" + LateEarlyReason;
WorkdaySave.LateEarlyReason = LateEarlyReason;
}
//Cat_TAMScanReasonMiss TAMScanReasonMiss = EntityService.CreateQueryable<Cat_TAMScanReasonMiss>(false, GuidContext, Guid.Empty, m => m.TAMScanReasonMissName == MissInOutReason).FirstOrDefault();
Cat_TAMScanReasonMiss TAMScanReasonMiss = repoCat_TAMScanReasonMiss.FindBy(m => m.IsDelete == null && m.ID == MissInOutReason).FirstOrDefault();
if (TAMScanReasonMiss != null)
{
if (WorkdayOld.MissInOutReason == Guid.Empty || WorkdayOld.MissInOutReason != TAMScanReasonMiss.ID)
{
Notes += "MissInOutReason:" + TAMScanReasonMiss.TAMScanReasonMissName;
}
WorkdaySave.TAMScanReasonMissName = TAMScanReasonMiss.TAMScanReasonMissName;
}
else
{
Notes += "MissInOutReason:" + "NULL";
WorkdaySave.MissInOutReason = null;
}
#endregion
#region Đăng Ký Nghỉ LeaveDay
string LeavedayCode = string.Empty;
if (WorkdaySave.udLeavedayCode1 != null && WorkdayOld.udLeavedayCode1 != WorkdaySave.udLeavedayCode1)
{
LeavedayCode = WorkdaySave.udLeavedayCode1;
if (LeavedayCode == "CO")
{
message = ConstantMessages.CantRegisterCO.TranslateString();
return message;
//Common.MessageBoxs(Messages.Msg, LanguageManager.GetString(Messages.CantRegisterCO), MessageBox.Icon.WARNING, string.Empty);
//return new { valid = true };
}
}
if (WorkdayOld != null && (!string.IsNullOrEmpty(WorkdayOld.udLeavedayCode1) || !string.IsNullOrEmpty(WorkdayOld.udLeavedayCode2)))
{
if (!string.IsNullOrEmpty(WorkdayOld.udLeavedayStatus1) && WorkdayOld.udLeavedayStatus1 == LeaveDayStatus.E_APPROVED.ToString())
{
message = ConstantMessages.StatusApproveCannotEdit.TranslateString();
return message;
//Common.MessageBoxs(Messages.Msg, LanguageManager.GetString(Messages.DataCantBeModify), MessageBox.Icon.WARNING, string.Empty);
//return new { valid = true };
}
}
#endregion
string TypeOld = WorkdaySave.Type;
//if (isChangeTamScan)
//{
// WorkdaySave.udIsManualFromTamScan = true;
//}
List<Att_WorkdayEntity> lstWorkdaySave = new List<Att_WorkdayEntity>() { WorkdaySave };
List<Att_Workday> lstWorkdayNew = ComputeWorkday(lstWorkdaySave.Translate<Att_Workday>(), ShiftAll, isChangeTamScan, UserLogin);
WorkdaySave.Type = TypeOld;
if (lstWorkdayNew.Count > 0)
{
Att_Workday workdayNew = lstWorkdayNew.FirstOrDefault();
if (workdayNew != null)
{
if (LeavedayCode != "")
{
string ErrLeave = SaveLeaveDay(workdayNew, LeavedayCode, UserLogin);
if (ErrLeave != string.Empty)
{
return ErrLeave;
//Common.MessageBoxs(Messages.Msg, ErrLeave, MessageBox.Icon.WARNING, string.Empty);
//return new { valid = true };
}
}
workdayNew.Type = TypeOld;
if (IsChangeLateEarly)
workdayNew.LateEarlyDuration = MinuteLateEarly;
//if (Notes != string.Empty)
//{
// Notes = "(" + UserLogin + "-" + string.Format("{0:dd/MM/yyyy hh:mm:ss}", DateTime.Now) + "-[" + Notes + "])";
//}
string NoteValidated = workdayNew.Note + Notes;
if (NoteValidated.Length > 2000)
{
NoteValidated = NoteValidated.Substring(NoteValidated.Length - 2000, 2000);
}
if (Notes != string.Empty)
{
workdayNew.SrcType = WorkdaySrcType.E_MANUAL.ToString();
}
workdayNew.Note = NoteValidated;
if (workdayNew.Type == string.Empty)
{
workdayNew.Type = WorkdayType.E_NORMAL.ToString();
}
DateTime DateNew = workdayNew.WorkDate;
Guid ProfileID = workdayNew.ProfileID;
}
}
repoAtt_Workday.Edit(lstWorkdayNew);
//EntityService.AddEntity<Att_Workday>(GuidContext, lstWorkdayNew.ToArray());
//EntityService.SubmitChanges(GuidContext, LoginUserID);
repoAtt_Workday.SaveChanges();
//unitOfWork.SaveChanges();
return message;
}
}
public string SaveLeaveDay(Att_Workday Workday, string LeaveTypeCode, string UserLogin)
{
if (Workday == null)
return string.Empty;
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCat_Shift = new CustomBaseRepository<Cat_Shift>(unitOfWork);
var repoCat_LeaveDayType = new CustomBaseRepository<Cat_LeaveDayType>(unitOfWork);
var repoAtt_LeaveDay = new CustomBaseRepository<Att_LeaveDay>(unitOfWork);
var repoHre_Profile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
var repoAtt_Grade = new CustomBaseRepository<Att_Grade>(unitOfWork);
var repoCat_GradeAttendance = new CustomBaseRepository<Cat_GradeAttendance>(unitOfWork);
var repoHre_WorkHistory = new CustomBaseRepository<Hre_WorkHistory>(unitOfWork);
var repoAtt_Roster = new CustomBaseRepository<Att_Roster>(unitOfWork);
var repoAtt_RosterGroup = new CustomBaseRepository<Att_RosterGroup>(unitOfWork);
var repoCat_DayOff = new CustomBaseRepository<Cat_DayOff>(unitOfWork);
var shifts = repoCat_Shift.FindBy(s => s.IsDelete == null).ToList();
Att_LeavedayServices leavedayServices = new Att_LeavedayServices();
LeaveTypeCode = LeaveTypeCode.Replace("...", string.Empty);
Guid? ShiftID = Workday.ShiftApprove ?? Workday.ShiftID;
double DurationHour = 8;
var shift = repoCat_Shift.FindBy(m => m.ID == ShiftID).FirstOrDefault();
//Cat_Shift shift = EntityService.CreateQueryable<Cat_Shift>(false, GuidContext, Guid.Empty, m => m.ID == ShiftID).FirstOrDefault();
if (shift != null)
DurationHour = shift.WorkHours ?? 8;
var leaveType = new List<Cat_LeaveDayType>().Select(m => new { m.ID, m.Code, m.CodeStatistic }).FirstOrDefault();
if (!string.IsNullOrEmpty(LeaveTypeCode))
{
leaveType = repoCat_LeaveDayType.FindBy(m => m.Code == LeaveTypeCode).Select(m => new { m.ID, m.Code, m.CodeStatistic }).FirstOrDefault();
//leaveType = EntityService.CreateQueryable<Cat_LeaveDayType>(false, GuidContext, Guid.Empty, m => m.CodeStatistic == LeaveTypeCode).Select(m => new { m.ID, m.Code, m.CodeStatistic }).FirstOrDefault();
}
DateTime workday = Workday.WorkDate;
DateTime beginDate = workday.Date;
DateTime endDate = beginDate.AddDays(1).AddMinutes(-1);
DateTime beginShift = workday.AddHours(shift.InTime.Hour).AddMinutes(shift.InTime.Minute);
DateTime endShift = beginShift.AddHours(shift.CoOut);
string E_APPROVED = LeaveDayStatus.E_APPROVED.ToString();
string E_REJECTED = LeaveDayStatus.E_REJECTED.ToString();
List<Att_LeaveDay> lstLeaveDayInDbUpdate = repoAtt_LeaveDay.FindBy(m => m.DateStart <= endDate && m.DateEnd >= beginDate && m.ProfileID == Workday.ProfileID && m.Status != E_REJECTED).ToList<Att_LeaveDay>();
List<Att_LeaveDay> lstLeaveDayInsert = new List<Att_LeaveDay>();
if (lstLeaveDayInDbUpdate.Count > 0)
{
if (!lstLeaveDayInDbUpdate.Any(m => m.Status == LeaveDayStatus.E_APPROVED.ToString()))
{
if (leaveType != null)
{
lstLeaveDayInDbUpdate.ForEach(m => m.LeaveDayTypeID = leaveType.ID);
}
else
{
lstLeaveDayInDbUpdate.ForEach(m => m.IsDelete = true);
}
}
else
lstLeaveDayInDbUpdate = new List<Att_LeaveDay>();
}
else
{
if (leaveType != null)
{
Att_LeaveDay LeavedayInsert = new Att_LeaveDay();
LeavedayInsert.ID = Guid.Empty;
LeavedayInsert.ProfileID = Workday.ProfileID;
LeavedayInsert.TotalDuration = 1;
LeavedayInsert.LeaveDays = 1;
LeavedayInsert.Duration = shift.WorkHours ?? 8;
LeavedayInsert.LeaveHours = shift.WorkHours ?? 8;
LeavedayInsert.DurationType = LeaveDayDurationType.E_FULLSHIFT.ToString();
LeavedayInsert.DateStart = workday;
LeavedayInsert.DateEnd = workday;
LeavedayInsert.LeaveDayTypeID = leaveType.ID;
LeavedayInsert.Status = LeaveDayStatus.E_SUBMIT.ToString();
lstLeaveDayInsert.Add(LeavedayInsert);
}
}
//Cap nhat leavedayID cho workday o day
if (lstLeaveDayInsert.Count > 0)
{
if (lstLeaveDayInsert.Count > 1)
{
Workday.LeaveDayID1 = lstLeaveDayInsert[0].ID;
Workday.LeaveDayID2 = lstLeaveDayInsert[1].ID;
//Workday.udLeavedayCode1 = LeaveTypeCode;
//Workday.udLeavedayCode2 = LeaveTypeCode;
//Workday.udLeavedayStatus1 = lstLeaveDayInsert.FirstOrDefault().Status.TranslateString();
//Workday.udLeavedayStatus2 = lstLeaveDayInsert.FirstOrDefault().Status.TranslateString();
}
else
{
Workday.LeaveDayID1 = lstLeaveDayInsert[0].ID;
//Workday.udLeavedayCode1 = LeaveTypeCode;
//Workday.udLeavedayStatus1 = lstLeaveDayInsert.FirstOrDefault().Status.TranslateString();
}
}
//else if (lstLeaveDayInDbUpdate.Count > 0)
//{
// if (lstLeaveDayInDbUpdate.Count >= 2)
// {
// Workday.udLeavedayCode1 = LeaveTypeCode;
// Workday.udLeavedayCode2 = LeaveTypeCode;
// Workday.udLeavedayStatus1 = lstLeaveDayInDbUpdate.FirstOrDefault().Status.TranslateString();
// Workday.udLeavedayStatus2 = lstLeaveDayInDbUpdate.FirstOrDefault().Status.TranslateString();
// }
// else
// {
// Workday.udLeavedayCode1 = LeaveTypeCode;
// Workday.udLeavedayStatus1 = lstLeaveDayInDbUpdate.FirstOrDefault().Status.TranslateString();
// Workday.udLeavedayStatus2 = lstLeaveDayInDbUpdate.FirstOrDefault().Status.TranslateString();
// }
//}
#region Triet.Mai Validate Nghỉ Bù
if (lstLeaveDayInsert.Count > 0)
{
List<Guid> LeaveTypeDayOffID = repoCat_LeaveDayType.FindBy(m => m.IsTimeOffInLieu == true).Select(m => m.ID).ToList<Guid>();
//List<Guid> LeaveTypeDayOffID = EntityService.CreateQueryable<Cat_LeaveDayType>(false, GuidContext, Guid.Empty, m => m.IsTimeOffInLieu == true).Select(m => m.ID).ToList<Guid>();
if (lstLeaveDayInsert.FirstOrDefault().Status != OverTimeStatus.E_CANCEL.ToString() && LeaveTypeDayOffID.Any(m => m == lstLeaveDayInsert.FirstOrDefault().LeaveDayTypeID))
{
string Error = leavedayServices.ValidateLeaveDayTimeOff(lstLeaveDayInsert.Select(m => m.ProfileID).Distinct().ToList(), lstLeaveDayInsert);
if (Error != string.Empty)
{
return Error;
}
}
}
#endregion
#region triet.mai validate vấn đề ngày nghỉ dành cho nhân viên thực tập
string E_STANDARD_WORKDAY = AppConfig.E_STANDARD_WORKDAY.ToString();
string status = string.Empty;
List<object> lstO = new List<object>();
lstO.Add(E_STANDARD_WORKDAY);
lstO.Add(null);
lstO.Add(null);
Sys_AllSetting config = GetData<Sys_AllSetting>(lstO, ConstantSql.hrm_sys_sp_get_AllSetting, UserLogin, ref status).FirstOrDefault();
//Sys_AppConfig config = EntityService.GetEntity<Sys_AppConfig>(false, GuidContext, Guid.Empty, m => m.Info == E_STANDARD_WORKDAY);
string validateEmpProbation = leavedayServices.ValidateLeaveTypeByNewEmployee(config, lstLeaveDayInsert);
if (validateEmpProbation != string.Empty)
{
return validateEmpProbation;
}
#endregion
#region triet.mai cap nhat leaveDays va leaveHours
lstLeaveDayInsert.AddRange(lstLeaveDayInDbUpdate);
if (lstLeaveDayInsert.Count > 0)
{
List<Cat_LeaveDayType> lstLeaveDayType = repoCat_LeaveDayType.FindBy(m => m.IsDelete == null).ToList<Cat_LeaveDayType>();
//List<Cat_LeaveDayType> lstLeaveDayType = EntityService.CreateQueryable<Cat_LeaveDayType>(false, GuidContext, Guid.Empty).ToList<Cat_LeaveDayType>();
List<Guid> lstProfileID1 = lstLeaveDayInsert.Select(m => m.ProfileID).Distinct().ToList<Guid>();
List<Hre_Profile> lstProfile = repoHre_Profile.FindBy(m => lstProfileID1.Contains(m.ID)).ToList<Hre_Profile>();
//List<Hre_Profile> lstProfile = EntityService.CreateQueryable<Hre_Profile>(false, GuidContext, Guid.Empty, m => lstProfileID1.Contains(m.ID)).ToList<Hre_Profile>();
DateTime dateMin1 = lstLeaveDayInsert.Min(m => m.DateStart).Date;
DateTime dateMax1 = lstLeaveDayInsert.Max(m => m.DateEnd);
List<Att_Roster> lstRosterTypeGroup = new List<Att_Roster>();
List<Att_RosterGroup> lstRosterGroup = new List<Att_RosterGroup>();
var lstGrade = repoAtt_Grade.FindBy(m => lstProfileID1.Contains(m.ProfileID.Value))
.Select(m => new { m.ID, m.ProfileID, m.MonthStart, m.GradeAttendanceID })
.OrderByDescending(m => m.MonthStart).ToList();
//var lstGrade = EntityService.CreateQueryable<Sal_Grade>(false, GuidContext, Guid.Empty, m => lstProfileID1.Contains(m.ProfileID))
// .Select(m => new { m.ID, m.ProfileID, m.MonthStart, m.GradeID })
// .OrderByDescending(m => m.MonthStart)
// .Execute();
List<Cat_GradeAttendance> lstGradeAttendance = repoCat_GradeAttendance.FindBy(m => m.IsDelete == null).ToList();
//List<Cat_GradeCfg> lstGradeCfg = EntityService.CreateQueryable<Cat_GradeCfg>(false, GuidContext, Guid.Empty).ToList<Cat_GradeCfg>();
List<Hre_WorkHistory> listWorkHistory = repoHre_WorkHistory.FindBy(m => m.DateEffective <= dateMax1 && lstProfileID1.Contains(m.ProfileID)).OrderByDescending(m => m.DateEffective).ToList<Hre_WorkHistory>();
//List<Hre_WorkHistory> listWorkHistory = EntityService.CreateQueryable<Hre_WorkHistory>(false, GuidContext, Guid.Empty, m => m.DateEffective <= dateMax1 && lstProfileID1.Contains(m.ProfileID)).OrderByDescending(m => m.DateEffective).ToList<Hre_WorkHistory>();
E_APPROVED = RosterStatus.E_APPROVED.ToString();
string E_ROSTERGROUP = RosterType.E_ROSTERGROUP.ToString();
if (dateMin1 == null || dateMax1 == null)
{
lstRosterTypeGroup = repoAtt_Roster.FindBy(m => lstProfileID1.Contains(m.ProfileID) && m.Status == E_APPROVED && m.Type == E_ROSTERGROUP).ToList<Att_Roster>();
//lstRosterTypeGroup = EntityService.Instance.CreateQueryable<Att_Roster>(false, guidContext, Guid.Empty, m => lstProfileID.Contains(m.ProfileID) && m.Status == E_APPROVED && m.Type == E_ROSTERGROUP).ToList<Att_Roster>();
lstRosterGroup = repoAtt_RosterGroup.FindBy(m => m.DateStart != null && m.DateEnd != null).ToList<Att_RosterGroup>();
//lstRosterGroup = EntityService.Instance.CreateQueryable<Att_RosterGroup>(false, guidContext, Guid.Empty, m => m.DateStart != null && m.DateEnd != null).ToList<Att_RosterGroup>();
}
else
{
lstRosterTypeGroup = repoAtt_Roster.FindBy(m => lstProfileID1.Contains(m.ProfileID) && m.Status == E_APPROVED && m.Type == E_ROSTERGROUP && m.DateStart <= dateMax1).ToList<Att_Roster>();
//lstRosterTypeGroup = EntityService.Instance.CreateQueryable<Att_Roster>(false, guidContext, Guid.Empty, m => lstProfileID.Contains(m.ProfileID) && m.Status == E_APPROVED && m.Type == E_ROSTERGROUP && m.DateStart <= DateTo).ToList<Att_Roster>();
lstRosterGroup = repoAtt_RosterGroup.FindBy(m => m.DateStart != null && m.DateEnd != null && m.DateStart <= dateMax1 && m.DateEnd >= dateMin1).ToList<Att_RosterGroup>();
//lstRosterGroup = EntityService.Instance.CreateQueryable<Att_RosterGroup>(false, guidContext, Guid.Empty, m => m.DateStart != null && m.DateEnd != null && m.DateStart <= DateTo && m.DateEnd >= DateFrom).ToList<Att_RosterGroup>();
}
//RosterDAO.GetRosterGroup(GuidContext, lstProfileID1, dateMin1, dateMax1, out lstRosterTypeGroup, out lstRosterGroup);
List<Cat_DayOff> lstHoliday = repoCat_DayOff.FindBy(m => m.IsDelete == null).ToList<Cat_DayOff>();
//List<Cat_DayOff> lstHoliday = EntityService.CreateQueryable<Cat_DayOff>(false, GuidContext, Guid.Empty).ToList<Cat_DayOff>();
string E_APPROVED1 = RosterStatus.E_APPROVED.ToString();
E_ROSTERGROUP = RosterType.E_ROSTERGROUP.ToString();
List<Att_Roster> lstRoster = repoAtt_Roster.FindBy(m => m.Status == E_APPROVED1 && m.DateStart <= dateMax1 && m.DateEnd >= dateMin1 && lstProfileID1.Contains(m.ProfileID)).ToList<Att_Roster>();
//List<Att_Roster> lstRoster = EntityService.CreateQueryable<Att_Roster>(false, GuidContext, Guid.Empty, m => m.Status == E_APPROVED1 && m.DateStart <= dateMax1 && m.DateEnd >= dateMin1 && lstProfileID1.Contains(m.ProfileID)).ToList<Att_Roster>();
List<DateTime> lstHolidayType = lstHoliday.Select(m => m.DateOff).ToList<DateTime>();
//LeaveDayDAO ldDao = new LeaveDayDAO();
foreach (var item in lstLeaveDayInsert)
{
if (item.DurationType != null && item.DurationType != LeaveDayDurationType.E_FULLSHIFT.ToString())
continue;
Cat_LeaveDayType leaveDayType = lstLeaveDayType.Where(m => m.ID == item.LeaveDayTypeID).FirstOrDefault();
if (leaveDayType == null)
continue;
Hre_Profile profileInLeave = lstProfile.Where(m => m.ID == item.ProfileID).FirstOrDefault();
if (profileInLeave == null)
continue;
DateTime dateFrom = item.DateStart;
DateTime dateTo = item.DateEnd;
dateTo = dateTo.AddDays(1).AddMinutes(-1);
Guid GradeAttendanceID = lstGrade.Where(m => m.ProfileID == profileInLeave.ID && m.MonthStart <= dateMax1 && m.GradeAttendanceID.HasValue).Select(m => m.GradeAttendanceID.Value).FirstOrDefault();
Cat_GradeAttendance gradeAttendance = lstGradeAttendance.Where(m => m.ID == GradeAttendanceID).FirstOrDefault();
List<Att_Roster> lstRosterByProfile = lstRoster.Where(m => m.ProfileID == profileInLeave.ID).ToList();
List<Hre_WorkHistory> listWorkHistoryByProfile = listWorkHistory.Where(m => m.ProfileID == profileInLeave.ID && m.DateEffective < dateTo).ToList();
List<Att_Roster> lstRosterByProfileTypeGroup = lstRosterByProfile.Where(m => m.Type == E_ROSTERGROUP).ToList();
leavedayServices.AnalyseTotalLeaveDaysAndHours(item, leaveDayType, profileInLeave, gradeAttendance, lstRosterByProfile, lstRosterGroup, listWorkHistoryByProfile, lstHoliday, shifts);
if (item.ID == Guid.Empty)
{
item.ID = Guid.NewGuid();
repoAtt_LeaveDay.Add(item);
}
else
repoAtt_LeaveDay.Edit(item);
}
}
#endregion
//repoAtt_LeaveDay.Add(lstLeaveDayInsert);
repoAtt_LeaveDay.SaveChanges();
//EntityService.AddEntity<Att_LeaveDay>(GuidContext, lstLeaveDayInsert.ToArray());
return string.Empty;
}
}
///// <summary>
///// Lấy toàn bộ data
///// </summary>
///// <returns></returns>
//public IQueryable<Att_AnnualLeave> Get()
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// return repo.Get().Where(i => i.IsDelete == null);
// }
//}
///// <summary>
///// Lấy dữ liệu theo Id
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public Att_AnnualLeaveEntity Get(int id)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetAnnualLeaveById(id);
// if (data.IsDelete == true) data = null;
// return data;
// }
//}
//public List<Att_AnnualLeaveEntity> GetAnnualLeaveByIds(string selectedIds)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// return repo.GetAnnualLeaveByIds(selectedIds);
// }
//}
///// <summary>
///// Thêm mới một record
///// </summary>
///// <param name="cat"></param>
///// <returns></returns>
//public bool Add(Att_AnnualLeave model)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// try
// {
// repo.Add(model);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
///// <summary>
///// Edit một record
///// </summary>
///// <param name="cat"></param>
///// <returns></returns>
//public bool Edit(Att_AnnualLeave model)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// try
// {
// repo.Edit(model);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
///// <summary>
///// Remove 1 record là chuyển trạng thái IsDelete=true
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public bool Remove(int id)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetById(id);
// try
// {
// repo.Remove(data);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
///// <summary>
///// Delete 1 record là xóa luôn record khỏi database
///// </summary>
///// <param name="id"></param>
///// <returns></returns>
//public bool Delete(int id)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// var repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetById(id);
// try
// {
// repo.Delete(data);
// repo.SaveChanges();
// return true;
// }
// catch
// {
// return false;
// }
// }
//}
//#region Store Procedure
//#region Danh sách
///// <summary>
///// Lấy danh sách dữ liệu AnnualLeaves [Tung.Ly - 2014/05/09]
///// </summary>
///// <returns></returns>
//public IQueryable<Att_AnnualLeaveEntity> GetAnnualLeaves(ListQueryModel model)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// IAtt_AnnualLeaveRepository repo = new Att_AnnualLeaveRepository(unitOfWork);
// var rs = repo.GetAnnualLeaves(model);
// return rs;
// }
//}
//#endregion
//#region Chi tiet
///// <summary>
///// Lấy dữ liệu AnnualLeave theo Id [Tung.Ly - 2014/05/09]
///// </summary>
///// <param name="annualLeaveId"></param>
///// <returns></returns>
//public Att_AnnualLeaveEntity GetAnnualLeaveById(int annualLeaveId)
//{
// using (var context = new VnrHrmDataContext())
// {
// var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
// IAtt_AnnualLeaveRepository repo = new Att_AnnualLeaveRepository(unitOfWork);
// var data = repo.GetAnnualLeaveById(annualLeaveId);
// return data;
// }
//}
//#endregion
//#endregion
#endregion
#region thanh toán phép năm đầu kỳ
public void SetAnnualLeaveBeginYear(List <Guid> lstProfileIDs, double?limitMaximum, int Year, int?MonthResetANL, Guid?AllowanceTypeID, Guid?CuttOffDurationID)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_AnnualLeave = new CustomBaseRepository <Att_AnnualLeave>(unitOfWork);
var repoAtt_AnnualDetail = new CustomBaseRepository <Att_AnnualDetail>(unitOfWork);
var repoSal_UnusualAllowance = new CustomBaseRepository <Sal_UnusualAllowance>(unitOfWork);
var repoAtt_CutOffDuration = new CustomBaseRepository <Att_CutOffDuration>(unitOfWork);
//nếu có rồi thì chỉ cần Update
//Nếu chưa có thì tạo mới
Att_CutOffDuration CutOffDuration = new Att_CutOffDuration();
if (CuttOffDurationID != null)
{
CutOffDuration = repoAtt_CutOffDuration.FindBy(m => m.ID == CuttOffDurationID).FirstOrDefault();
}
int LastYear = Year - 1;
DateTime?MaxTime = repoAtt_AnnualDetail.FindBy(m => m.IsDelete != null && m.Year == LastYear).OrderByDescending(m => m.MonthYear).Select(m => m.MonthYear).FirstOrDefault();
List <Att_AnnualDetail> lstAnnualDetail = new List <Att_AnnualDetail>();
if (MaxTime != null)
{
lstAnnualDetail = repoAtt_AnnualDetail.FindBy(m => m.MonthYear == MaxTime &&
m.ProfileID != null &&
lstProfileIDs.Contains(m.ProfileID.Value)).ToList();
}
var lstAnnualLeaveInDB = repoAtt_AnnualLeave.FindBy(m => m.IsDelete == null && m.Year == Year && lstProfileIDs.Contains(m.ProfileID)).ToList();
foreach (var ProfileID in lstProfileIDs)
{
Att_AnnualLeave AnnualLeaveByProfile = lstAnnualLeaveInDB.Where(m => m.ProfileID == ProfileID).FirstOrDefault();
bool IsNew = false;
if (AnnualLeaveByProfile == null)
{
IsNew = true;
AnnualLeaveByProfile = new Att_AnnualLeave();
AnnualLeaveByProfile.ID = Guid.NewGuid();
AnnualLeaveByProfile.ProfileID = ProfileID;
AnnualLeaveByProfile.Year = Year;
AnnualLeaveByProfile.MonthStart = 1;
}
AnnualLeaveByProfile.MonthResetAnlOfBeforeYear = MonthResetANL;
double RemainLastYear = lstAnnualDetail.Where(m => m.ProfileID == ProfileID).Select(m => m.Remain ?? 0).FirstOrDefault();
if (limitMaximum != null)
{
AnnualLeaveByProfile.InitAnlValue = RemainLastYear > limitMaximum.Value ? limitMaximum.Value : RemainLastYear;
AnnualLeaveByProfile.SurplusAnllastYear = RemainLastYear > limitMaximum ? RemainLastYear - limitMaximum : 0;
if (CutOffDuration.ID != null && CutOffDuration.ID != Guid.Empty && AllowanceTypeID != null)
{
Sal_UnusualAllowance UnusualAllowance = new Sal_UnusualAllowance();
UnusualAllowance.ProfileID = ProfileID;
UnusualAllowance.MonthStart = CutOffDuration.DateStart;
UnusualAllowance.MonthEnd = CutOffDuration.DateEnd;
UnusualAllowance.UnusualEDTypeID = AllowanceTypeID;
UnusualAllowance.Amount = AnnualLeaveByProfile.SurplusAnllastYear;
repoSal_UnusualAllowance.Add(UnusualAllowance);
}
}
else
{
AnnualLeaveByProfile.InitAnlValue = RemainLastYear;
AnnualLeaveByProfile.SurplusAnllastYear = 0;
}
//Sửa lại theo phần tử mới mà Sơn build
if (IsNew)
{
repoAtt_AnnualLeave.Add(AnnualLeaveByProfile);
}
else
{
repoAtt_AnnualLeave.Edit(AnnualLeaveByProfile);
}
}
repoAtt_AnnualLeave.SaveChanges();
repoSal_UnusualAllowance.SaveChanges();
}
}
/// <summary>
/// [Hieu.van] Tổng Hợp giặt là
/// </summary>
/// <param name="dateStart"></param>
/// <param name="dateEnd"></param>
/// <param name="lstProfileIDs"></param>
/// <returns></returns>
public List <LMS_LaundryRecordEntity> GetLaundryRecordSummary(string _line, string _locker, string _marker, DateTime dateStart, DateTime dateEnd, List <Hre_ProfileEntity> lstProfileIDs, string UserLogin)
{
dateStart = dateStart.Date;
dateEnd = dateEnd.Date.AddDays(1).AddMilliseconds(-1);
string status = string.Empty;
//string strIDs = string.Join(",", lstProfileIDs.ToArray());
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoLau_TamScanLog = new CustomBaseRepository <LMS_TamScanLogLMS>(unitOfWork);
var repoLau_Line = new CustomBaseRepository <LMS_LineLMS>(unitOfWork);
var repoLau_Locker = new CustomBaseRepository <LMS_LockerLMS>(unitOfWork);
var repoLau_Marker = new CustomBaseRepository <LMS_Marker>(unitOfWork);
var repoLau_LaundryRecord = new CustomBaseRepository <LMS_LaundryRecord>(unitOfWork);
var repoSys_AllSetting = new CustomBaseRepository <Sys_AllSetting>(unitOfWork);
#region cấu hình số phút xử lý trùng
int rsScanMulti = 0;
var rsScanMultiConfig = GetData <Sys_AllSetting>(AppConfig.HRM_LAU_LAUNDRYRECORD_SCANMULTI_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
if (rsScanMultiConfig != null)
{
rsScanMulti = rsScanMultiConfig.Value1 != null?int.Parse(rsScanMultiConfig.Value1.ToString()) : 0;
dateStart = dateStart.Date.AddHours(rsScanMulti);
dateEnd = dateEnd.Date.AddDays(1).AddHours(rsScanMulti).AddMilliseconds(-1);
}
#endregion
var tamScanLogs = repoLau_TamScanLog
.FindBy(s => dateStart <= s.TimeLog && s.TimeLog <= dateEnd)
.Select(s => new { s.Code, s.TimeLog, s.ID, s.MachineCode })
//.Select(s => new { s.MachineCode, s.CardCode, s.TimeLog, s.Id })
.ToList();
var cardCodes = tamScanLogs.Select(s => s.Code).ToList();
//strIDs = Common.DotNetToOracle(strIDs);
//var profiles = GetData<Hre_ProfileEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status)
// .Where(s => cardCodes.Contains(s.CodeAttendance) && lstProfileIDs.Contains(s.ID))
var profiles = lstProfileIDs
.Where(s => cardCodes.Contains(s.CodeAttendance))
.Select(s => new { s.ID, s.CodeAttendance, s.CodeEmp, s.ProfileName, s.OrgStructureName }).ToList();
tamScanLogs = tamScanLogs
.Where(s => profiles.Select(p => p.CodeAttendance).Contains(s.Code))
.OrderBy(s => s.Code)
.ThenBy(s => s.TimeLog)
.ToList();
#region lấy line-locker-marker và xử lý khi tìm kiếm
var lines = repoLau_Line.FindBy(s => s.IsDelete == null).ToList();
var Lockers = repoLau_Locker.FindBy(s => s.IsDelete == null).ToList();
var Markers = repoLau_Marker.FindBy(s => s.IsDelete == null).ToList();
if (_line != null)
{
List <Guid> lstLine = _line.Split(',').Select(Guid.Parse).ToList();
lines = lines.Where(s => lstLine.Contains(s.ID)).ToList();
}
if (_locker != null)
{
List <Guid> lstLocker = _locker.Split(',').Select(Guid.Parse).ToList();
Lockers = Lockers.Where(s => lstLocker.Contains(s.ID)).ToList();
}
if (_marker != null)
{
List <Guid> lstMarker = _marker.Split(',').Select(Guid.Parse).ToList();
Markers = Markers.Where(s => lstMarker.Contains(s.ID)).ToList();
}
#endregion
List <object> lstObj = new List <object>();
lstObj.Add(dateStart);
lstObj.Add(dateEnd);
List <Lau_LaundryRecordCheckEntity> laundryCheckList = GetData <Lau_LaundryRecordCheckEntity>(lstObj, ConstantSql.hrm_lau_sp_get_LaundryRecord_ByDateFromDateTo, UserLogin, ref status);
LMS_LaundryRecordEntity laundry = new LMS_LaundryRecordEntity();
List <LMS_LaundryRecordEntity> lstRecord = new List <LMS_LaundryRecordEntity>();
List <LMS_LaundryRecord> lstAdd = new List <LMS_LaundryRecord>();
List <LMS_LaundryRecord> lstEdit = new List <LMS_LaundryRecord>();
List <Guid> lstDuplicateTamScan = new List <Guid>();
foreach (var tamScanLog in tamScanLogs)
{
if (lstDuplicateTamScan.Contains(tamScanLog.ID))
{
continue;
}
laundry = new LMS_LaundryRecordEntity();
var profile = profiles.FirstOrDefault(s => s.CodeAttendance == tamScanLog.Code);
var line = lines.FirstOrDefault(s => tamScanLog.MachineCode == s.MachineCode);
if (profile != null && line != null)
{
#region xử lý bản ghi trùng
var tamScanLogProfiles = tamScanLogs
.Where(s => s.Code == tamScanLog.Code && s.TimeLog.Value.Date == tamScanLog.TimeLog.Value.Date && s.MachineCode == tamScanLog.MachineCode)
.OrderBy(s => s.TimeLog)
.ToList();
if (tamScanLogProfiles.Count > 1 && rsScanMulti > 0)
{
for (int i = 0; i < tamScanLogProfiles.Count; i++)
{
var tamsanFirst = tamScanLogProfiles[i];
int j = i + 1;
if (j > tamScanLogProfiles.Count - 1)
{
j = i;
}
var tamsanNear = tamScanLogProfiles[j];
if (tamsanNear.TimeLog.Value.Subtract(tamsanFirst.TimeLog.Value).TotalMinutes < rsScanMulti && tamsanFirst.ID != tamsanNear.ID)
{
if (tamsanFirst.MachineCode == tamsanNear.MachineCode)
{
lstDuplicateTamScan.Add(tamsanNear.ID);
break;
}
}
}
}
#endregion
#region xử lý add record
laundry.ProfileID = profile.ID;
laundry.ProfileName = profile.ProfileName;
laundry.CodeAttendance = profile.CodeAttendance;
laundry.TimeLog = tamScanLog.TimeLog;
laundry.Status = HRM.Infrastructure.Utilities.LaundryRecordStatus.E_SUBMIT.ToString();
laundry.Type = LaundryRecordType.E_AUTO.ToString();
if (tamScanLog.MachineCode != null)
{
laundry.MachineCode = tamScanLog.MachineCode;
if (line != null)
{
laundry.LineLMSName = line.LineLMSName;
laundry.LineID = line.ID;
laundry.Amount = (decimal)line.Amount;
if (line.LockerID != null)
{
var locker = Lockers.Where(c => c.ID == line.LockerID).FirstOrDefault();
laundry.LockerLMSName = locker.LockerLMSName;
laundry.LockerID = locker.ID;
}
if (line.MarkerID != null)
{
var marker = Markers.Where(c => c.ID == line.MarkerID).FirstOrDefault();
laundry.MarkerName = marker.MarkerName;
laundry.MarkerID = marker.ID;
}
}
}
laundry.DateCreate = DateTime.Now;
var recordAdd = laundry.CopyData <LMS_LaundryRecord>();
var CheckList = laundryCheckList.Where(s => s.ProfileID == laundry.ProfileID.Value && s.TimeLog == laundry.TimeLog).ToList();
if (CheckList != null)
{
if (CheckList.Count() > 0)
{
var idUpdate = CheckList.FirstOrDefault();
recordAdd.ID = idUpdate.ID;
repoLau_LaundryRecord.Edit(recordAdd);
//lstEdit.Add(recordAdd);
}
else
{
recordAdd.ID = Guid.NewGuid();
repoLau_LaundryRecord.Add(recordAdd);
//lstAdd.Add(recordAdd);
}
}
laundry.ID = tamScanLog.ID;
lstRecord.Add(laundry);
#endregion
}
}
repoLau_LaundryRecord.SaveChanges();
//if (lstAdd.Any())
//{
// repoLau_LaundryRecord.Add(lstAdd);
// repoLau_LaundryRecord.SaveChanges();
//}
//if (lstEdit.Any())
//{
// repoLau_LaundryRecord.Edit(lstEdit);
// repoLau_LaundryRecord.SaveChanges();
//}
if (lstRecord.Count > 0)
{
Sys_AllSetting sys = new Sys_AllSetting();
Sys_AllSetting rs = GetData <Sys_AllSetting>(AppConfig.HRM_LAU_LAUNDRYRECORD_SUMMARY.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
sys.Value1 = dateStart.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Value2 = dateEnd.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Name = AppConfig.HRM_LAU_LAUNDRYRECORD_SUMMARY.ToString();
if (rs != null)
{
sys.ID = rs.ID;
repoSys_AllSetting.Edit(sys);
}
else
{
sys.ID = Guid.NewGuid();
repoSys_AllSetting.Add(sys);
}
repoSys_AllSetting.SaveChanges();
}
return(lstRecord);
}
}
/// <summary>
/// Lấy tất cả các bản ghi
/// Get by key
/// </summary>
/// <returns></returns>
public void SaveConfig(List <Dictionary <string, string> > lstModel)
{
using (var context = new VnrHrmDataContext())
{
IUnitOfWork unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repo = new CustomBaseRepository <Sys_AllSetting>(unitOfWork);
string status = string.Empty;
List <Dictionary <Guid, string> > lstUpdate = new List <Dictionary <Guid, string> >();
var valueTemp = new Sys_AllSetting();
var modelTemp = new Sys_AllSetting();
List <Guid> lstConfigIds = new List <Guid>();
List <Sys_AllSetting> lstAdd = new List <Sys_AllSetting>();
List <Sys_AllSetting> lstEdit = new List <Sys_AllSetting>();
List <Sys_AllSetting> lstDel = new List <Sys_AllSetting>();
var getdata = repo.FindBy(s => s.IsDelete == null).ToList();
if (lstModel[0].FirstOrDefault().Value.Length > 0)
{
var lstStr = lstModel.FirstOrDefault()["lstConfigIds"].Split(',');
lstConfigIds = lstStr.Select(Guid.Parse).ToList();
}
foreach (var item in lstConfigIds)
{
modelTemp = GetById <Sys_AllSetting>(item, ref status);
lstUpdate.Add(new Dictionary <Guid, string>()
{
{ modelTemp.ID, modelTemp.Name }
});
}
for (int i = 1; i < lstModel.Count; i++)
{
var lstEntity = getdata.Where(s => s.Name == lstModel[i].FirstOrDefault().Key).ToList();
if (lstEntity.Count == 0)
{
valueTemp = new Sys_AllSetting();
valueTemp.ID = Guid.NewGuid();
valueTemp.Name = lstModel[i].FirstOrDefault().Key;
valueTemp.Value1 = lstModel[i].FirstOrDefault().Value;
lstAdd.Add(valueTemp);
continue;
}
if (lstEntity.Count > 0)
{
valueTemp = new Sys_AllSetting();
foreach (var item in lstEntity)
{
item.IsDelete = true;
lstDel.Add(item);
//repo.Edit(item);
}
var isUpdate = lstUpdate.Where(s => s.FirstOrDefault().Value == lstModel[i].FirstOrDefault().Key).FirstOrDefault();
if (isUpdate != null)
{
valueTemp.ID = lstEntity.FirstOrDefault().ID;
valueTemp.Name = lstModel[i].FirstOrDefault().Key;
valueTemp.Value1 = lstModel[i].FirstOrDefault().Value;
valueTemp.IsDelete = null;
lstEdit.Add(valueTemp);
}
else
{
valueTemp.ID = Guid.NewGuid();
valueTemp.Name = lstModel[i].FirstOrDefault().Key;
valueTemp.Value1 = lstModel[i].FirstOrDefault().Value;
lstAdd.Add(valueTemp);
}
}
}
repo.Edit(lstDel);
repo.Add(lstAdd);
repo.Edit(lstEdit);
repo.SaveChanges();
}
}
public void ChangeMethodOverTime_Manual(Att_OvertimeEntity model)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_Overtime = new CustomBaseRepository<Att_Overtime>(unitOfWork);
var repoAtt_TimeofInLieu = new CustomBaseRepository<Att_TimeOffInLieu>(unitOfWork);
double TimeOffRealValidate = 0;
double TimeOffValidate = 0;
double CashOutValidate = 0;
if (model.TimeOffReal != null)
{
TimeOffRealValidate = (double)model.TimeOffReal;
//double.TryParse(model.TimeOffReal.ToString(), out TimeOffRealValidate);
}
if (model.HourToTimeOff != null)
{
TimeOffValidate = (double)model.HourToTimeOff;
//double.TryParse(txt_TimeOff.Text, out TimeOffValidate);
}
if (model.TimeRegister != null)
{
CashOutValidate = (double)model.TimeRegister;
//double.TryParse(txt_CashOut.Text, out CashOutValidate);
}
if (TimeOffRealValidate < 0 || TimeOffValidate < 0 || CashOutValidate < 0)
{
return;
}
double Cashout = CashOutValidate;
double Timeoff = TimeOffValidate;
//if (Ot.Status == OverTimeStatus.E_APPROVED.ToString())
//{
// Common.MessageBoxs(Messages.Msg, Messages.DataCantBeModify.TranslateString(), Ext.Net.MessageBox.Icon.WARNING, string.Empty);
// return;
//}
Att_Overtime OT_New = new Att_Overtime();
if (Cashout > 0 && Timeoff <= 0)
{
//Chuyển hết cho trả tiền
model.MethodPayment = MethodOption.E_CASHOUT.ToString();
}
else if (Cashout <= 0 && Timeoff > 0)
{
//Chuyển hết cho nghỉ bù
model.MethodPayment = MethodOption.E_TIMEOFF.ToString();
}
else if (Cashout > 0 && Timeoff > 0)
{
//Vửa chuyển tiền vừa nghỉ bù
model.MethodPayment = MethodOption.E_CASHOUT.ToString();
model.RegisterHours = Cashout;
if (model.Status == OverTimeStatus.E_APPROVED.ToString())
{
model.ApproveHours = Cashout;
}
if (model.Status == OverTimeStatus.E_CONFIRM.ToString())
{
model.ApproveHours = Cashout;
model.ConfirmHours = Cashout;
}
OT_New = model.CopyData<Att_Overtime>();
OT_New.ID = Guid.NewGuid();
OT_New.WorkDate = model.WorkDate.AddHours(model.RegisterHours);
OT_New.MethodPayment = MethodOption.E_TIMEOFF.ToString();
OT_New.RegisterHours = Timeoff;
if (OT_New.Status == OverTimeStatus.E_APPROVED.ToString())
{
OT_New.ApproveHours = Timeoff;
}
if (OT_New.Status == OverTimeStatus.E_CONFIRM.ToString())
{
OT_New.ApproveHours = Timeoff;
OT_New.ConfirmHours = Timeoff;
}
if (model.IsNonOvertime == true)
{
//model.IsNonOvertime = true;
OT_New.IsNonOvertime = true;
}
//repoAtt_Overtime.FindBy<Att_Overtime>();
repoAtt_Overtime.Add(OT_New);
var att_overtimeEntity = model.CopyData<Att_Overtime>();
repoAtt_Overtime.Edit(att_overtimeEntity);
//EntityService.AddEntity<Att_Overtime>(GuidContext, (new List<Att_Overtime>() { OT_New }).ToArray());
}
if (model.LeaveDay1 != null || model.LeaveDay2 != null)
{
DateTime? date1 = null;
DateTime? date2 = null;
if (model.LeaveDay1 != null)
{
date1 = model.LeaveDay1;
}
if (model.LeaveDay2 != null)
{
date2 = model.LeaveDay2;
}
//string Error = AddTimeOffInLieu(new List<Att_Overtime>() { Ot, OT_New }, date1, date2);
//if (Error != string.Empty)
//{
// return;
//}
}
if (model.Status == OverTimeStatus.E_APPROVED.ToString() || model.Status == OverTimeStatus.E_CONFIRM.ToString())
{
List<Att_TimeOffInLieu> lstTimeOffInsert = new List<Att_TimeOffInLieu>();
//TimeOffInLieeu
//1 Xóa Đi những cái OT liên Quan trong TimeOff
//2 Insert lại nhưng cái liên quan đên TimeOff
List<Att_TimeOffInLieu> lstTimeOff = repoAtt_TimeofInLieu.FindBy(m => m.OvertimeID == model.ID).ToList<Att_TimeOffInLieu>();
foreach (var item in lstTimeOff)
{
item.IsDelete = null;
}
if (model.MethodPayment == MethodOption.E_TIMEOFF.ToString())
{
Att_TimeOffInLieu TimeOffInsert = AddTimeOffInLieu(model.CopyData<Att_Overtime>());
TimeOffInsert.ID = Guid.NewGuid();
TimeOffInsert.ProfileID = model.ProfileID;
lstTimeOffInsert.Add(TimeOffInsert);
}
if (OT_New.MethodPayment == MethodOption.E_TIMEOFF.ToString())
{
Att_TimeOffInLieu TimeOffInsert = AddTimeOffInLieu(OT_New);
TimeOffInsert.ID = Guid.NewGuid();
TimeOffInsert.ProfileID = model.ProfileID;
lstTimeOffInsert.Add(TimeOffInsert);
}
if (lstTimeOffInsert.Count > 0)
{
for (int i = 0; i < lstTimeOffInsert.Count; i++)
{
lstTimeOffInsert[i].Hre_Profile = null;
repoAtt_TimeofInLieu.Add(lstTimeOffInsert[i]);
}
// repoAtt_TimeofInLieu.Add(lstTimeOffInsert);
//EntityService.AddEntity<Att_TimeOffInLieu>(GuidContext, lstTimeOffInsert.ToArray());
}
}
unitOfWork.SaveChanges();
// EntityService.SubmitChanges(GuidContext, LoginUserID.Value);
//IsSave = false;
//IsSave = false;
}
//return Json(new { });
}
/// <summary>
/// [Hieu.Van]
/// Xử lý duyệt động đa cấp
/// ProcessApproved (Tài khoản Login - LoginID, Value Dropdownlist - userApprovedID, Id Bản ghi - recordID, Enum màn hình - type)
/// </summary>
/// <param name="LoginID"></param>
/// <param name="userApprovedID"></param>
/// <param name="recordID"></param>
/// <param name="type"></param>
/// <returns></returns>
public string ProcessApproved(string host, Guid LoginID, Guid userApprovedID, Guid recordID, string type)
{
DataErrorCode status = DataErrorCode.Success;
string stt = string.Empty;
var Services = new BaseService();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoFIN_PurchaseRequest = new CustomBaseRepository<FIN_PurchaseRequest>(unitOfWork);
var repoSys_UserApprove = new CustomBaseRepository<Sys_UserApprove>(unitOfWork);
var repoSys_ConfigProcessApprove = new CustomBaseRepository<Sys_ConfigProcessApprove>(unitOfWork);
var UserLogin = string.Empty;
var record = GetData<FIN_PurchaseRequestEntity>(recordID, ConstantSql.hrm_hr_sp_get_PurchaseRequestById, UserLogin, ref stt).FirstOrDefault();
var configProcess = repoSys_ConfigProcessApprove.FindBy(s => s.IsDelete == null && s.Function == type && s.CurrentStatus == record.Status).FirstOrDefault();
double total = record.Total != null ? record.Total.Value : 0.0;
List<ElementFormula> listFomula = new List<ElementFormula>();
ElementFormula FomulaItem = new ElementFormula("Total", total, 0);
ElementFormula statusItem = new ElementFormula(configProcess.NextStatusFormular, configProcess.NextStatusFormular, 1);
listFomula.Add(FomulaItem);
listFomula.Add(statusItem);
string nextStatus = Services.GetObjectValue(new List<Cat_ElementEntity>(), listFomula, configProcess.NextStatusFormular).ToString();
if (configProcess != null && userApprovedID == Guid.Empty && nextStatus != "Approved")
{
return DataErrorCode.Error_NoUserApproved.ToString();
}
if (record.Status == EnumDropDown.Status.E_REJECTED.ToString())
{
return DataErrorCode.Error_Reject.ToString();
}
var recordEdit = repoFIN_PurchaseRequest.FindBy(s => s.ID == recordID).FirstOrDefault();
// lấy UserInfoID hiện tại của bản ghi
var userApprovedCurrent = repoSys_UserApprove.FindBy(s => s.ID == recordEdit.UserApproveID).FirstOrDefault();
// Kiểm tra tài khoản login có được phép Duyệt hay ko?
if (LoginID == Guid.Empty || userApprovedCurrent.UserApproveID != LoginID)
{
// kiểm tra nếu bản ghi có tk duyệt trống (tức bản ghi mới tạo) và tk login = tk tạo thì cho duyệt tiếp tục
if (recordEdit.UserApproveID == null && record.UserCreateID == LoginID)
{
}
else
{
return DataErrorCode.NoPermission.ToString();
}
}
recordEdit.Status = nextStatus;
if (userApprovedID == Guid.Empty)
{
recordEdit.UserApproveID = null;
}
else
{
recordEdit.UserApproveID = userApprovedID;
}
repoFIN_PurchaseRequest.Edit(recordEdit);
status = repoFIN_PurchaseRequest.SaveChanges();
if (nextStatus != "Approved")
{
status = SendMail_ToNextApproved(host, recordID, userApprovedID, nextStatus, type);
}
if (status == DataErrorCode.Success)
{
//var configProcess = repoSys_ConfigProcessApprove.FindBy(s => s.IsDelete == null && s.Function == type && s.CurrentStatus == nextStatus).FirstOrDefault();
if (nextStatus == "Approved")
{
return DataErrorCode.Success.ToString();
}
else
{
return DataErrorCode.Success_Forward.ToString();
}
}
return status.ToString();
}
}
/// <summary>
/// [Hien.NGuyen] - Xử lý form lưu của màn hình phân tích tăng ca
/// </summary>
/// <param name="updatedAtt_OvertimeModel"></param>
/// <returns></returns>
public bool CreateComputeOvertime(List<Att_OvertimeEntity> lstOvertimeInsert, string PaymentMethod, string strOvertimeStatus, Guid UserAppvoveID, double HourToTimeOff, double TimeRegister, string strReasonOT, Guid UserId, string userLogin)
{
string status = string.Empty;
List<Att_Overtime> lstOvertimeInsertOutput = new List<Att_Overtime>();
List<Guid> lstProID = lstOvertimeInsert.Select(s => s.ProfileID).Distinct().ToList();
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoSys_UserInfo = new CustomBaseRepository<Sys_UserInfo>(unitOfWork);
//var repoHre_Profile = new CustomBaseRepository<Hre_Profile>(unitOfWork);
var repoAtt_AllowLimitOvertime = new CustomBaseRepository<Att_AllowLimitOvertime>(unitOfWork);
var repoCat_EntityLabel = new CustomBaseRepository<Cat_EntityLabel>(unitOfWork);
var repoSys_GroupLabel = new CustomBaseRepository<Sys_GroupLabel>(unitOfWork);
var repoAtt_TimeOffInLieu = new CustomBaseRepository<Att_TimeOffInLieu>(unitOfWork);
var repoAtt_OverTime = new CustomBaseRepository<Att_Overtime>(unitOfWork);
var lstHre = GetData<Hre_ProfileEntity>(Common.DotNetToOracle(String.Join(",", lstProID)), ConstantSql.hrm_hr_sp_get_ProfileByIds, userLogin, ref status);
Sys_UserInfo UserAppvove = repoSys_UserInfo.FindBy(pro => pro.ID == UserAppvoveID).FirstOrDefault();
if (UserAppvove == null)
{
//errorMessage = Messages.plsChooseApproveUser.TranslateString();
return false;
}
if (strReasonOT == string.Empty)
strReasonOT = " ";
foreach (var item in lstOvertimeInsert)
{
item.ReasonOT = strReasonOT;
if (item.MethodPayment == null)
{
item.MethodPayment = EnumDropDown.PaymentType.E_CASHOUT.ToString();
}
}
#region Validate Đã Đăng Ký Rồi
List<Guid> profileHaveOT = new List<Guid>();
profileHaveOT = lstOvertimeInsert.Where(m => m.udOvertimeStatus != null).Select(m => m.ProfileID).Distinct().ToList();
if (profileHaveOT.Count > 0)
{
var lstProfile = lstHre.Where(m => profileHaveOT.Contains(m.ID)).Select(m => new { m.ID, m.ProfileName, m.CodeEmp });
string ProfileNameErr = string.Empty;
foreach (var item in lstProfile)
{
ProfileNameErr += item.ProfileName + " [" + item.CodeEmp + "]; ";
}
if (ProfileNameErr.Length > 0)
{
ProfileNameErr = ProfileNameErr.Substring(0, ProfileNameErr.Length - 2);
}
//errorMessage = string.Format("Nhân viên {0} Tăng Ca Trùng ", ProfileNameErr);
return false;
}
#endregion
#region Validate Không được phép Tăng Ca
string Err = ValidateOT_DoNotAllow(lstOvertimeInsert, lstHre);
if (Err != string.Empty)
{
//errorMessage = Err;
return false;
}
#endregion
#region phân tích lại và validate thông báo vượt trần mức 300
List<Att_AllowLimitOvertime> lisProfileAllowLimitOvertime = repoAtt_AllowLimitOvertime.GetAll().ToList();
double HourInLieu = 0;
if (PaymentMethod == EnumDropDown.PaymentType.E_CASHOUT.ToString() || PaymentMethod == EnumDropDown.PaymentType.E_CASHOUT_TIMEOFF.ToString())
{
HourInLieu = HourToTimeOff;
}
else if (PaymentMethod == MethodOption.E_TIMEOFF.ToString())
{
HourInLieu = double.MaxValue;
}
if (HourInLieu > 0)
{
lstOvertimeInsert = SplitOvertimeByInlieuHour(lstOvertimeInsert, HourInLieu);
}
OvertimePermitEntity overtimePermit = getOvertimePermit(userLogin);
List<Att_OvertimeEntity> LimitOTByYear = ValidateLimitOTByYear(lstOvertimeInsert, lisProfileAllowLimitOvertime, overtimePermit);
if (LimitOTByYear.Count > 0)
{
List<Guid> lstProfileID = LimitOTByYear.Select(m => m.ProfileID).Distinct().ToList();
var lstProfile = lstHre.Where(m => lstProfileID.Contains(m.ID)).Select(m => new { m.ID, m.ProfileName, m.CodeEmp });
string lstCodeEmpErr = string.Empty;
foreach (var item in lstProfile)
{
lstCodeEmpErr += item.CodeEmp + "; ";
}
if (lstCodeEmpErr.Length > 0)
{
lstCodeEmpErr = lstCodeEmpErr.Substring(0, lstCodeEmpErr.Length - 2);
}
// errorMessage = string.Format("Nhân viên {0} đã vượt trần", lstCodeEmpErr);
return false;
}
#endregion
List<Att_TimeOffInLieu> lstTimeOffInLieu = new List<Att_TimeOffInLieu>();
string Att_Overtime = "Att_Overtime";
string E_OVERTIME = "E_OVERTIME";
Cat_EntityLabel EntityLabel = repoCat_EntityLabel.FindBy(m => m.UserID == UserId && m.EntityName == Att_Overtime && m.EntityLabelName == E_OVERTIME).FirstOrDefault();
if (EntityLabel == null)
{
EntityLabel = new Cat_EntityLabel();
EntityLabel.ID = Guid.NewGuid();
EntityLabel.UserID = UserId;
EntityLabel.EntityName = Att_Overtime;
EntityLabel.EntityLabelName = E_OVERTIME;
repoCat_EntityLabel.Add(EntityLabel);
repoCat_EntityLabel.SaveChanges();
}
Sys_GroupLabel GroupLable = repoSys_GroupLabel.FindBy(m => m.EntityLabelID == EntityLabel.ID).FirstOrDefault();
if (GroupLable == null)
{
GroupLable = new Sys_GroupLabel();
GroupLable.ID = Guid.NewGuid();
GroupLable.EntityLabelID = EntityLabel.ID;
GroupLable.EntityItems = string.Empty;
repoSys_GroupLabel.Add(GroupLable);
repoSys_GroupLabel.SaveChanges();
}
string EntityItems = GroupLable.EntityItems;
List<Att_Overtime> save = new List<Att_Overtime>();
List<Att_Overtime> saveAdd = new List<Att_Overtime>();
List<Att_Overtime> saveEdit = new List<Att_Overtime>();
Att_Overtime saveModel = null;
foreach (Att_OvertimeEntity Ot in lstOvertimeInsert)
{
bool InsertToTimeOffInlieu = false;
Ot.Status = strOvertimeStatus;//OverTimeStatus.E_APPROVED.ToString();
Ot.udOvertimeStatus = strOvertimeStatus.TranslateString();
if (strOvertimeStatus == OverTimeStatus.E_APPROVED.ToString())
{
Ot.ApproveHours = Ot.RegisterHours;
if (Ot.MethodPayment == EnumDropDown.PaymentType.E_TIMEOFF.ToString() || Ot.MethodPayment == EnumDropDown.PaymentType.E_CASHOUT_TIMEOFF.ToString())
InsertToTimeOffInlieu = true;
}
else if (strOvertimeStatus == OverTimeStatus.E_CONFIRM.ToString())
{
Ot.ConfirmHours = Ot.RegisterHours;
if (Ot.MethodPayment == EnumDropDown.PaymentType.E_TIMEOFF.ToString() || Ot.MethodPayment == EnumDropDown.PaymentType.E_CASHOUT_TIMEOFF.ToString())
InsertToTimeOffInlieu = true;
}
Ot.ReasonOT = strReasonOT;
Ot.UserApproveID = UserAppvove.ID;
Guid ProfileID = Ot.ProfileID;
DateTime beginOt = Ot.WorkDate;
DateTime endOt = beginOt.AddHours(Ot.RegisterHours);
Att_OvertimeEntity OvertimeRemove = lstOvertimeCache.Where(m => m.ID == Ot.ID).FirstOrDefault();
if (OvertimeRemove != null)
{
int index = lstOvertimeCache.IndexOf(OvertimeRemove);
lstOvertimeCache.Remove(OvertimeRemove);
lstOvertimeCache.Insert(index, Ot);
}
if (InsertToTimeOffInlieu)
{
Att_TimeOffInLieu timeOffLieu = AddTimeOffInLieu(Ot.CopyData<Att_Overtime>());
lstTimeOffInLieu.Add(timeOffLieu);
//repoAtt_TimeOffInLieu.Add(timeOffLieu);
}
EntityItems += Ot.ID.ToString().ToLower() + "|";
//Insert vào Đính Nhãn
saveModel = Ot.CopyData<Att_Overtime>();
save.Add(saveModel);
}
if (EntityItems.Length > 0)
{
EntityItems = EntityItems.Substring(0, EntityItems.Length - 1);
}
GroupLable.EntityItems = EntityItems;
saveEdit = save.Where(s => s.ID != Guid.Empty).ToList();
saveAdd = save.Where(s => s.ID == Guid.Empty).ToList();
foreach (var item in saveAdd)
{
item.ID = Guid.NewGuid();
}
if (saveAdd != null && saveAdd.Count > 0)
repoAtt_OverTime.Add(saveAdd);
if (saveEdit != null && saveEdit.Count > 0)
repoAtt_OverTime.Edit(saveEdit);
if (lstTimeOffInLieu != null && lstTimeOffInLieu.Count > 0)
repoAtt_TimeOffInLieu.Add(lstTimeOffInLieu);
//if (EntityLabel != null)
// repoCat_EntityLabel.Add(EntityLabel);
//if (GroupLable != null)
// repoSys_GroupLabel.Add(GroupLable);
try
{
repoAtt_OverTime.SaveChanges();
repoAtt_TimeOffInLieu.SaveChanges();
//repoCat_EntityLabel.SaveChanges();
//repoSys_GroupLabel.SaveChanges();
//unitOfWork.SaveChanges();
return true;
}
catch (Exception)
{
return false;
}
}
}
/// <summary>
/// [Hieu.Van]
/// Xử lý Gửi yêu cầu phê duyệt
/// </summary>
/// <param name="LoginID"></param>
/// <param name="userApprovedID"></param>
/// <param name="recordID"></param>
/// <param name="type"></param>
/// <returns></returns>
public string ProcessSendRequest(string host, Guid LoginID, Guid userApprovedID, Guid recordID, string type)
{
DataErrorCode status = DataErrorCode.Success;
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoFIN_PurchaseRequest = new CustomBaseRepository<FIN_PurchaseRequest>(unitOfWork);
var repoSys_UserApprove = new CustomBaseRepository<Sys_UserApprove>(unitOfWork);
var record = repoFIN_PurchaseRequest.FindBy(s => s.ID == recordID).FirstOrDefault();
if (record.UserCreateID != LoginID)
{
return DataErrorCode.NoPermission.ToString();
}
if (record.Status == EnumDropDown.Status.E_REJECTED.ToString())
{
return DataErrorCode.Error_Reject.ToString();
}
if (record.Status != null)
{
return DataErrorCode.Error_SendRequest.ToString();
}
var userApproved = repoSys_UserApprove.FindBy(s => s.ID == userApprovedID).FirstOrDefault();
// Lấy status hiện tại của bản ghi
string currentStatus = record.Status;
// truyền từ Dropdownlist chọn người duyệt, lấy ra giá trị Status tiếp theo
string nextStatus = userApproved.CurrentStatus;
record.Status = nextStatus;
record.UserApproveID = userApprovedID;
repoFIN_PurchaseRequest.Edit(record);
status = repoFIN_PurchaseRequest.SaveChanges();
if (status == DataErrorCode.Success)
{
if (nextStatus != "Approved")
{
status = SendMail_ToNextApproved(host, recordID, userApprovedID, nextStatus, type);
}
var repoSys_ConfigProcessApprove = new CustomBaseRepository<Sys_ConfigProcessApprove>(unitOfWork);
var configProcess = repoSys_ConfigProcessApprove.FindBy(s => s.IsDelete == null && s.Function == type && s.CurrentStatus == record.Status).FirstOrDefault();
if (configProcess == null)
{
return DataErrorCode.Success.ToString();
}
else
{
return DataErrorCode.Success_Forward.ToString();
}
}
return status.ToString();
}
}
/// <summary>
/// [Hien.Nguyen] - Chức năng tính tăng ca - màng hình Phân Tích Tăng Ca
/// </summary>
/// <param name="lstOvertimeEntity"></param>
public void CalAllowOvertime(List<Att_OvertimeEntity> lstOvertime, string userLogin)
{
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_workday = new CustomBaseRepository<Att_Workday>(unitOfWork);
var repoAtt_NoneOvertime = new CustomBaseRepository<Att_NonOverTime>(unitOfWork);
if (lstOvertime.Count == 0 || lstOvertime.Where(m => m.WorkDateRoot != null).Count() == 0)
{
return;
}
DateTime minDate = lstOvertime.Min(m => m.WorkDateRoot.Value);
DateTime maxDate = lstOvertime.Max(m => m.WorkDateRoot.Value);
List<Guid> lstProfileID = lstOvertime.Select(m => m.ProfileID).Distinct().ToList();
List<ProfileDateTime> lstWorkdayCanBeOT = new List<ProfileDateTime>();
foreach (var item in lstOvertime)
{
if (item.WorkDateRoot == null)
continue;
if (item.IsNonOvertime == null)
continue;
ProfileDateTime workdayNotOt = new ProfileDateTime();
workdayNotOt.ProfileID = item.ProfileID;
workdayNotOt.WorkDate = item.WorkDateRoot.Value;
lstWorkdayCanBeOT.Add(workdayNotOt);
}
List<Att_OvertimeEntity> lstOvertimeInCache = lstOvertimeCache;
List<Att_OvertimeEntity> lstOvertimeInCache_Profile = lstOvertimeInCache.Where(m => lstProfileID.Contains(m.ProfileID)).ToList();
var _tmp = lstOvertimeInCache_Profile;
for (int i = 0; i < _tmp.Count(); i++)
lstOvertimeInCache.Remove(lstOvertimeInCache_Profile[i]);
List<Att_OvertimeEntity> lstOvertimeNonBe_Delete = new List<Att_OvertimeEntity>();
foreach (var item in lstOvertimeInCache_Profile)
{
if (lstWorkdayCanBeOT.Any(m => m.ProfileID == item.ProfileID && m.WorkDate == item.WorkDateRoot))
{
item.IsNonOvertime = null;
lstOvertimeNonBe_Delete.Add(item);
}
}
//Để tính lại lũy kế sau khi xong
OvertimePermitEntity overtimePermit = getOvertimePermit(userLogin);
//List<Att_WorkdayEntity> lstWorkday = repoAtt_workday.FindBy(m => m.WorkDate >= minDate && m.WorkDate <= maxDate && lstProfileID.Contains(m.ProfileID)).ToList().Translate<Att_WorkdayEntity>();
List<WorkdayCustom> lstWorkday = new List<WorkdayCustom>();
if (lstProfileID.Count < 2000)
{
lstWorkday = repoAtt_workday
.FindBy(m => m.IsDelete == null && m.WorkDate >= minDate && m.WorkDate <= maxDate && lstProfileID.Contains(m.ProfileID))
.Select(m => new WorkdayCustom() { ID = m.ID, ProfileID = m.ProfileID, ShiftID = m.ShiftID, ShiftApprove = m.ShiftApprove, WorkDate = m.WorkDate, Status = m.Status, InTime1 = m.InTime1, InTime2 = m.InTime2, OutTime1 = m.OutTime1, OutTime2 = m.OutTime2 })
.ToList<WorkdayCustom>();
}
else
{
lstWorkday = repoAtt_workday
.FindBy(m => m.IsDelete == null && m.WorkDate >= minDate && m.WorkDate <= maxDate)
.Select(m => new WorkdayCustom() { ID = m.ID, ProfileID = m.ProfileID, ShiftID = m.ShiftID, ShiftApprove = m.ShiftApprove, WorkDate = m.WorkDate, Status = m.Status, InTime1 = m.InTime1, InTime2 = m.InTime2, OutTime1 = m.OutTime1, OutTime2 = m.OutTime2 })
.ToList<WorkdayCustom>();
}
FillterAllowOvertime(context, lstOvertimeInCache_Profile, overtimePermit, lstWorkday);
lstOvertimeInCache.AddRange(lstOvertimeInCache_Profile);
lstOvertimeInCache = lstOvertimeInCache.OrderBy(m => m.WorkDate.Date).ThenBy(m => m.ProfileID).ToList();
lstOvertimeCache = lstOvertimeInCache;
//List<Att_NonOverTime> LstNonOTSelect = repoAtt_NoneOvertime.FindBy(m => m.WorkDay >= minDate && m.WorkDay <= maxDate && lstProfileID.Contains(m.ProfileID.Value)).ToList<Att_NonOverTime>();
List<Att_NonOverTime> LstNonOTSelect = new List<Att_NonOverTime>();
if (lstProfileID.Count < 2000)
{
LstNonOTSelect = repoAtt_workday
.FindBy(m => m.IsDelete == null && m.WorkDate >= minDate && m.WorkDate <= maxDate && lstProfileID.Contains(m.ProfileID)).ToList().Translate<Att_NonOverTime>();
}
else
{
LstNonOTSelect = repoAtt_workday
.FindBy(m => m.IsDelete == null && m.WorkDate >= minDate && m.WorkDate <= maxDate).ToList().Translate<Att_NonOverTime>();
}
foreach (var item in lstOvertimeNonBe_Delete)
{
Att_NonOverTime NonOT = LstNonOTSelect.Where(m => m.ProfileID == item.ProfileID && m.OvertimeTypeID == item.OvertimeTypeID && m.WorkDay == item.WorkDateRoot && m.Type == item.udTypeBeginOTWithShift).FirstOrDefault();
if (NonOT != null)
{
NonOT.IsDelete = true;
}
}
if (LstNonOTSelect.Count > 0)
{
repoAtt_NoneOvertime.Edit(LstNonOTSelect);
unitOfWork.SaveChanges();
}
//BindToGrid(lstOvertimeCache);
}
}
public List <Can_MealRecordEntity> GetMealRecordSummary(string _line, string _catering, string _canteen, DateTime dateStart, DateTime dateEnd, List <Hre_ProfileEntity> lstProfileIDs, string UserLogin)
{
dateStart = dateStart.Date;
dateEnd = dateEnd.Date.AddDays(1).AddMilliseconds(-1);
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoCan_MealRecord = new CustomBaseRepository <Can_MealRecord>(unitOfWork);
var repoCan_TamScanLog = new CustomBaseRepository <Can_TamScanLogCMS>(unitOfWork);
var repoCan_Line = new CustomBaseRepository <Can_Line>(unitOfWork);
var repoCan_Canteen = new CustomBaseRepository <Can_Canteen>(unitOfWork);
var repoCan_Catering = new CustomBaseRepository <Can_Catering>(unitOfWork);
var repoSys_AllSetting = new CustomBaseRepository <Sys_AllSetting>(unitOfWork);
string status = string.Empty;
//string strIDs = string.Join(",", lstProfileIDs.ToArray());
#region xử lý cấu hình giờ kết thúc ăn - DateStart & DateEnd
DateTime dateConfig = DateTime.MinValue;
var rsTimeConfig = GetData <Sys_AllSettingEntity>(AppConfig.HRM_CAN_MEALRECORD_EATEND_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
if (rsTimeConfig != null && rsTimeConfig.Value1 != null)
{
dateConfig = DateTimeHelper.ConvertStringToDateTime(rsTimeConfig.Value1, ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond_ffffff.ToString());
}
double hourConfig = dateConfig.Hour + (((double)dateConfig.Minute) / 60);
dateStart = dateStart.Date.AddHours(hourConfig);
dateEnd = dateEnd.Date.AddDays(1).AddHours(hourConfig).AddMilliseconds(-1);
#endregion
#region cấu hình số phút xử lý trùng
int rsScanMulti = 0;
var rsScanMultiConfig = GetData <Sys_AllSettingEntity>(AppConfig.HRM_CAN_MEALRECORD_SCANMULTI_CONFIG.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
if (rsScanMultiConfig != null)
{
rsScanMulti = rsScanMultiConfig.Value1 != null?int.Parse(rsScanMultiConfig.Value1.ToString()) : 0;
}
#endregion
var tamScanLogs = repoCan_TamScanLog
.FindBy(s => dateStart <= s.TimeLog && s.TimeLog <= dateEnd)
.Select(s => new { s.MachineCode, s.CardCode, s.TimeLog, s.ID })
.ToList();
var cardCodes = tamScanLogs.Select(s => s.CardCode).ToList();
//strIDs = Common.DotNetToOracle(strIDs);
//var profiles = GetData<Hre_ProfileEntity>(strIDs, ConstantSql.hrm_hr_sp_get_ProfileByIds, ref status)
// .Where(s => cardCodes.Contains(s.CodeAttendance) && lstProfileIDs.Contains(s.ID))
var profiles = lstProfileIDs
.Where(s => cardCodes.Contains(s.CodeAttendance))
.Select(s => new { s.ID, s.CodeAttendance, s.CodeEmp, s.ProfileName, s.OrgStructureName }).ToList();
tamScanLogs = tamScanLogs.Where(s => profiles.Select(p => p.CodeAttendance).Contains(s.CardCode)).OrderBy(s => s.CardCode).ThenBy(s => s.TimeLog).ToList();
var lines = repoCan_Line.FindBy(s => s.IsDelete == null).ToList();
var canteens = repoCan_Canteen.FindBy(s => s.IsDelete == null).ToList();
var caterings = repoCan_Catering.FindBy(s => s.IsDelete == null).ToList();
if (_line != null)
{
List <Guid> lstLine = _line.Split(',').Select(Guid.Parse).ToList();
lines = lines.Where(s => lstLine.Contains(s.ID)).ToList();
}
if (_canteen != null)
{
List <Guid> lstcanteen = _canteen.Split(',').Select(Guid.Parse).ToList();
canteens = canteens.Where(s => lstcanteen.Contains(s.ID)).ToList();
}
if (_catering != null)
{
List <Guid> lstcatering = _catering.Split(',').Select(Guid.Parse).ToList();
caterings = caterings.Where(s => lstcatering.Contains(s.ID)).ToList();
}
List <object> lstObj = new List <object>();
lstObj.Add(dateStart);
lstObj.Add(dateEnd);
List <Can_MealRecordCheckEntity> mealRecordCheckList = GetData <Can_MealRecordCheckEntity>(lstObj, ConstantSql.hrm_can_sp_get_MealRecord_ByDateFromDateTo, UserLogin, ref status);
Can_MealRecordEntity record = new Can_MealRecordEntity();
List <Can_MealRecordEntity> lstRecord = new List <Can_MealRecordEntity>();
List <Can_MealRecord> lstEdit = new List <Can_MealRecord>();
List <Can_MealRecord> lstAdd = new List <Can_MealRecord>();
List <Guid> lstDuplicateTamScan = new List <Guid>();
foreach (var tamScanLog in tamScanLogs)
{
if (lstDuplicateTamScan.Contains(tamScanLog.ID))
{
continue;
}
record = new Can_MealRecordEntity();
var profile = profiles.FirstOrDefault(s => s.CodeAttendance == tamScanLog.CardCode);
var line = lines.FirstOrDefault(s => tamScanLog.MachineCode == s.MachineCode);
if (profile != null && line != null)
{
#region xử lý quẹt thẻ trùng theo HRM_CAN_MEALRECORD_SCANMULTI_CONFIG
var tamScanLogProfiles = tamScanLogs
.Where(s => s.CardCode == tamScanLog.CardCode && s.TimeLog.Value.Date == tamScanLog.TimeLog.Value.Date && s.MachineCode == tamScanLog.MachineCode)
.OrderBy(s => s.TimeLog)
.ToList();
if (tamScanLogProfiles.Count > 1 && rsScanMulti > 0)
{
for (int i = 0; i < tamScanLogProfiles.Count; i++)
{
var tamsanFirst = tamScanLogProfiles[i];
int j = i + 1;
if (j > tamScanLogProfiles.Count - 1)
{
j = i;
}
var tamsanNear = tamScanLogProfiles[j];
if (tamsanNear.TimeLog.Value.Subtract(tamsanFirst.TimeLog.Value).TotalMinutes < rsScanMulti &&
tamsanFirst.ID != tamsanNear.ID)
{
if (tamsanFirst.MachineCode == tamsanNear.MachineCode)
{
lstDuplicateTamScan.Add(tamsanNear.ID);
break;
}
}
}
}
#endregion
#region xử lý add record
record.TimeLog = tamScanLog.TimeLog.HasValue ? tamScanLog.TimeLog.Value : DateTime.MinValue;
if (record.TimeLog < record.TimeLog.Value.Date.AddHours(hourConfig))
{
record.WorkDay = record.TimeLog.Value.AddDays(-1);
}
else
{
record.WorkDay = record.TimeLog;
}
if (tamScanLog.MachineCode != null)
{
record.MachineCode = tamScanLog.MachineCode;
if (line != null)
{
record.LineName = line.LineName;
record.LineID = line.ID;
record.Amount = (decimal)line.Amount;
if (line.CanteenID != null)
{
var cant = canteens.Where(c => c.ID == line.CanteenID).FirstOrDefault();
record.CanteenName = cant.CanteenName;
record.CanteenID = line.CanteenID;
}
if (line.CateringID != null)
{
var cater = caterings.Where(c => c.ID == line.CateringID).FirstOrDefault();
record.CateringName = cater.CateringName;
record.CateringID = line.CateringID;
}
}
}
record.ProfileName = profile.ProfileName;
record.CodeEmp = profile.CodeEmp;
record.OrgStructureName = profile.OrgStructureName;
record.CodeAttendance = profile.CodeAttendance;
record.DateCreate = DateTime.Now;
var recordAdd = record.CopyData <Can_MealRecord>();
recordAdd.ProfileID = profile.ID;
var CheckList = mealRecordCheckList.Where(s => s.ProfileID == profile.ID && s.TimeLog == tamScanLog.TimeLog).ToList();
if (CheckList != null)
{
if (CheckList.Count() > 0)
{
var idUpdate = CheckList.FirstOrDefault();
recordAdd.ID = idUpdate.ID;
//lstEdit.Add(recordAdd);
repoCan_MealRecord.Edit(recordAdd);
}
else
{
recordAdd.ID = Guid.NewGuid();
repoCan_MealRecord.Add(recordAdd);
//lstAdd.Add(recordAdd);
}
}
record.ID = tamScanLog.ID;
lstRecord.Add(record);
#endregion
}
}
repoCan_MealRecord.SaveChanges();
if (lstRecord.Count > 0)
{
Sys_AllSetting sys = new Sys_AllSetting();
Sys_AllSetting rs = GetData <Sys_AllSetting>(AppConfig.HRM_CAN_MEALRECORD_SUMMARY.ToString(), ConstantSql.hrm_sys_sp_get_AllSettingByKey, UserLogin, ref status).FirstOrDefault();
sys.Value1 = dateStart.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Value2 = dateEnd.ToString(ConstantFormat.HRM_Format_YearMonthDay_HoursMinSecond.ToString());
sys.Name = AppConfig.HRM_CAN_MEALRECORD_SUMMARY.ToString();
if (rs != null)
{
sys.ID = rs.ID;
repoSys_AllSetting.Edit(sys);
}
else
{
sys.ID = Guid.NewGuid();
repoSys_AllSetting.Add(sys);
}
repoSys_AllSetting.SaveChanges();
}
//lstRecord.Where().(s => s.MealAllowanceTypeName = ConstantDisplay.HRM_Enum_Submit.TranslateString()).ToList();
return(lstRecord);
}
}
public void SetSickLeaveBeginYear(List <Guid> lstProfileIDs, double?limitMaximum, int Year)
{
//Đối với phép ốm thì tạm thời tính từ đầu năm đến cuối năm
using (var context = new VnrHrmDataContext())
{
var unitOfWork = (IUnitOfWork)(new UnitOfWork(context));
var repoAtt_AnnualLeave = new CustomBaseRepository <Att_AnnualLeave>(unitOfWork);
var repoCat_LeaveDayType = new CustomBaseRepository <Cat_LeaveDayType>(unitOfWork);
var repoAtt_LeaveDay = new CustomBaseRepository <Att_LeaveDay>(unitOfWork);
int LastYear = Year - 1;
DateTime beginLastYear = new DateTime(LastYear, 1, 1);
DateTime endLastYear = beginLastYear.AddYears(1).AddMinutes(-1);
List <Guid> SickLeaveType = repoCat_LeaveDayType.FindBy(m => m.IsDelete == null && m.Code == "SICK").Select(m => m.ID).ToList();
string Approve = LeaveDayStatus.E_APPROVED.ToString();
var lstLeaveDay = repoAtt_LeaveDay.FindBy(m =>
m.IsDelete == null &&
m.Status == Approve &&
m.DateStart < endLastYear &&
m.DateEnd >= beginLastYear &&
SickLeaveType.Contains(m.LeaveDayTypeID) &&
lstProfileIDs.Contains(m.ProfileID)).Select(m => new { m.ProfileID, m.TotalDuration }).ToList();
List <Att_AnnualLeave> lstAnnualLeaveInDB = repoAtt_AnnualLeave.FindBy(m => m.IsDelete == null && (m.Year == Year || m.Year == LastYear) && lstProfileIDs.Contains(m.ProfileID)).ToList();
foreach (var ProfileID in lstProfileIDs)
{
Att_AnnualLeave AnnualLeaveByProfile = lstAnnualLeaveInDB.Where(m => m.ProfileID == ProfileID && m.Year == Year).FirstOrDefault();
Att_AnnualLeave AnnualLeaveByProfile_Last = lstAnnualLeaveInDB.Where(m => m.ProfileID == ProfileID && m.Year == LastYear).FirstOrDefault();
bool IsNew = false;
if (AnnualLeaveByProfile == null)
{
IsNew = true;
AnnualLeaveByProfile = new Att_AnnualLeave();
AnnualLeaveByProfile.ID = Guid.NewGuid();
AnnualLeaveByProfile.ProfileID = ProfileID;
AnnualLeaveByProfile.Year = Year;
AnnualLeaveByProfile.MonthStart = 1;
}
double InitLastYear = 0;
if (AnnualLeaveByProfile_Last != null)
{
InitLastYear = AnnualLeaveByProfile_Last.InitSickValue;
}
double remainLastYear = InitLastYear - lstLeaveDay.Where(m => m.ProfileID == ProfileID).Sum(m => m.TotalDuration ?? 0);
if (limitMaximum != null)
{
AnnualLeaveByProfile.InitSickValue = remainLastYear > limitMaximum.Value ? limitMaximum.Value : remainLastYear;
AnnualLeaveByProfile.SurplusSicklastYear = remainLastYear > limitMaximum ? remainLastYear - limitMaximum : 0;
}
else
{
AnnualLeaveByProfile.InitSickValue = remainLastYear;
AnnualLeaveByProfile.SurplusSicklastYear = 0;
}
if (IsNew)
{
repoAtt_AnnualLeave.Add(AnnualLeaveByProfile);
}
else
{
repoAtt_AnnualLeave.Edit(AnnualLeaveByProfile);
}
}
repoAtt_AnnualLeave.SaveChanges();
}
}