protected static FR_L5EM_GEALRDFIDL_1138_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_GEALRDFIDL_1138 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L5EM_GEALRDFIDL_1138_Array(); List <L5EM_GEALRDFIDL_1138> resultList = new List <L5EM_GEALRDFIDL_1138>(); //Put your code here L5EM_GEAAWCFT_1210[] allEmployees = cls_Get_Employees_And_ActiveWorkingContracts_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result; L5AR_GART_1118[] allReasons = cls_Get_AbsenceReasons_For_Tenant.Invoke(Connection, Transaction, securityTicket).Result; foreach (var employeeID in Parameter.EmployeeIDList) { L5EM_GEALRDFIDL_1138 result = new L5EM_GEALRDFIDL_1138(); L5EM_GEAAWCFT_1210 employee = allEmployees.Where(x => x.CMN_BPT_EMP_EmployeeID == employeeID).FirstOrDefault(); if (employee == null) { continue; } result.FirstName = employee.FirstName; result.LastName = employee.LastName; result.CMN_BPT_BusinessParticipantID = employee.CMN_BPT_BusinessParticipantID; result.CMN_BPT_EMP_EmployeeID = employee.CMN_BPT_EMP_EmployeeID; result.CMN_BPT_EMP_EmploymentRelationshipID = employee.CMN_BPT_EMP_EmploymentRelationshipID; result.Work_StartDate = employee.Work_StartDate; result.Work_EndDate = employee.Work_EndDate; result.CMN_BPT_EMP_WorkingContractID = employee.ActiveWorkingContract.CMN_BPT_EMP_WorkingContractID; result.IsContractEndDateDefined = employee.ActiveWorkingContract.IsContractEndDateDefined; result.IsWorkTimeCalculated_InDays = employee.ActiveWorkingContract.IsWorkTimeCalculated_InDays; result.IsWorkTimeCalculated_InHours = employee.ActiveWorkingContract.IsWorkTimeCalculated_InHours; result.Contract_StartDate = employee.ActiveWorkingContract.Contract_StartDate; result.Contract_EndDate = employee.ActiveWorkingContract.Contract_EndDate; result.R_WorkTime_DaysPerWeek = employee.ActiveWorkingContract.R_WorkTime_DaysPerWeek; result.R_WorkTime_HoursPerWeek = employee.ActiveWorkingContract.R_WorkTime_HoursPerWeek; List <L5EM_GEALRDFIDL_1138_WeeklyOfficeHour> weeklyOfficeHoursResult = new List <L5EM_GEALRDFIDL_1138_WeeklyOfficeHour>(); foreach (var weeklyOfficeHours in employee.ActiveWorkingContract.WeeklyOfficeHours) { L5EM_GEALRDFIDL_1138_WeeklyOfficeHour weeklyOfficeHourInterval = new L5EM_GEALRDFIDL_1138_WeeklyOfficeHour(); weeklyOfficeHourInterval.CMN_CAL_WeeklyOfficeHours_IntervalID = weeklyOfficeHours.CMN_CAL_WeeklyOfficeHours_IntervalID; weeklyOfficeHourInterval.IsWholeDay = weeklyOfficeHours.IsWholeDay; weeklyOfficeHourInterval.TimeFrom_InMinutes = weeklyOfficeHours.TimeFrom_InMinutes; weeklyOfficeHourInterval.TimeTo_InMinutes = weeklyOfficeHours.TimeTo_InMinutes; weeklyOfficeHourInterval.IsMonday = weeklyOfficeHours.IsMonday; weeklyOfficeHourInterval.IsTuesday = weeklyOfficeHours.IsTuesday; weeklyOfficeHourInterval.IsWednesday = weeklyOfficeHours.IsWednesday; weeklyOfficeHourInterval.IsThursday = weeklyOfficeHours.IsThursday; weeklyOfficeHourInterval.IsFriday = weeklyOfficeHours.IsFriday; weeklyOfficeHourInterval.IsSaturday = weeklyOfficeHours.IsSaturday; weeklyOfficeHourInterval.IsSunday = weeklyOfficeHours.IsSunday; weeklyOfficeHoursResult.Add(weeklyOfficeHourInterval); } result.WeeklyOfficeHours = weeklyOfficeHoursResult.ToArray(); P_L5EM_GAFE_1216 adjustmentsParam = new P_L5EM_GAFE_1216(); adjustmentsParam.EmployeeID = employeeID; L5EM_GAFE_1216[] adjustmentsForEmployee = cls_get_Adjustments_For_Employee.Invoke(Connection, Transaction, adjustmentsParam, securityTicket).Result; List <L5EM_GEALRDFIDL_1138_WorkingContract2LeaveRequest> workingContract2LeaveRequestResult = new List <L5EM_GEALRDFIDL_1138_WorkingContract2LeaveRequest>(); List <L5EM_GEALRDFIDL_1138_EmployeeWorkplaceHistory> employeeWorkplaceAssignments = new List <L5EM_GEALRDFIDL_1138_EmployeeWorkplaceHistory>(); foreach (var workplaceAssignemns in employee.EmployeeWorkplaceHistory) { L5EM_GEALRDFIDL_1138_EmployeeWorkplaceHistory item = new L5EM_GEALRDFIDL_1138_EmployeeWorkplaceHistory(); item.BoundTo_Workplace_RefID = workplaceAssignemns.BoundTo_Workplace_RefID; item.CMN_BPT_EMP_Employee_PlanGroup_RefID = workplaceAssignemns.CMN_BPT_EMP_Employee_PlanGroup_RefID; item.CMN_BPT_EMP_Employee_WorkplaceAssignmentID = workplaceAssignemns.CMN_BPT_EMP_Employee_WorkplaceAssignmentID; item.Default_BreakTime_Template_RefID = workplaceAssignemns.Default_BreakTime_Template_RefID; item.IsBreakTimeCalculated_Actual = workplaceAssignemns.IsBreakTimeCalculated_Actual; item.IsBreakTimeCalculated_Planning = workplaceAssignemns.IsBreakTimeCalculated_Planning; item.SequenceNumber = workplaceAssignemns.SequenceNumber; item.WorkplaceAssignment_StartDate = workplaceAssignemns.WorkplaceAssignment_StartDate; employeeWorkplaceAssignments.Add(item); } result.EmployeeWorkplaceHistory = employeeWorkplaceAssignments.ToArray(); foreach (var absence in employee.ActiveWorkingContract.WorkingContract2LeaveRequest) { L5EM_GEALRDFIDL_1138_WorkingContract2LeaveRequest workingContract2LeaveRequest = new L5EM_GEALRDFIDL_1138_WorkingContract2LeaveRequest(); L5AR_GART_1118 reason = allReasons.Where(x => x.CMN_BPT_STA_AbsenceReasonID == absence.STA_AbsenceReason_RefID).FirstOrDefault(); if (reason == null) { continue; } workingContract2LeaveRequest.CMN_BPT_EMP_Employee_WorkingContract_AllowedAbsenceReasonID = absence.CMN_BPT_EMP_Employee_WorkingContract_AllowedAbsenceReasonID; workingContract2LeaveRequest.IsAbsenceCalculated_InDays = absence.IsAbsenceCalculated_InDays; workingContract2LeaveRequest.IsAbsenceCalculated_InHours = absence.IsAbsenceCalculated_InHours; workingContract2LeaveRequest.ContractAllowedAbsence_per_Month = absence.ContractAllowedAbsence_per_Month; workingContract2LeaveRequest.AbsenceReasonName = reason.ReasonName; workingContract2LeaveRequest.CMN_BPT_STA_AbsenceReasonID = reason.CMN_BPT_STA_AbsenceReasonID; workingContract2LeaveRequest.AbsenceReason_ParentID = reason.Parent_RefID; workingContract2LeaveRequest.IsAuthorizationRequired = reason.IsAuthorizationRequired; workingContract2LeaveRequest.IsIncludedInCapacityCalculation = reason.IsIncludedInCapacityCalculation; workingContract2LeaveRequest.IsAllowedAbsence = reason.IsAllowedAbsence; workingContract2LeaveRequest.IsDeactivated = reason.IsDeactivated; workingContract2LeaveRequest.IsCarryOverEnabled = reason.IsCarryOverEnabled; L5EM_GAFE_1216[] adjustmentsForAbsenceReason = adjustmentsForEmployee.Where(x => x.CMN_BPT_STA_AbsenceReasonID == workingContract2LeaveRequest.CMN_BPT_STA_AbsenceReasonID).ToArray(); List <L5EM_GEALRDFIDL_1138_adjustments> adjustmentsResult = new List <L5EM_GEALRDFIDL_1138_adjustments>(); foreach (var adjustment in adjustmentsForAbsenceReason) { L5EM_GEALRDFIDL_1138_adjustments adjustmentResult = new L5EM_GEALRDFIDL_1138_adjustments(); adjustmentResult.CMN_BPT_EMP_ContractAbsenceAdjustmentID = adjustment.CMN_BPT_EMP_ContractAbsenceAdjustmentID; adjustmentResult.AbsenceTime_InMinutes = adjustment.AbsenceTime_InMinutes; adjustmentResult.ContractAbsenceAdjustment_Group_RefID = adjustment.CMN_BPT_EMP_ContractAbsenceAdjustment_GroupID; adjustmentResult.IsManual = adjustment.IsManual; adjustmentResult.TriggeringAccount_RefID = adjustment.TriggeringAccount_RefID; adjustmentResult.AdjustmentComment = adjustment.AdjustmentComment; adjustmentResult.AdjustmentDate = adjustment.AdjustmentDate; adjustmentsResult.Add(adjustmentResult); } workingContract2LeaveRequest.Adjustments = adjustmentsResult.ToArray(); workingContract2LeaveRequestResult.Add(workingContract2LeaveRequest); } result.WorkingContract2LeaveRequest = workingContract2LeaveRequestResult.ToArray(); resultList.Add(result); } returnValue.Result = resultList.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_L6LR_GLRS_M_1706 Execute(DbConnection Connection, DbTransaction Transaction, P_L6LR_GLRS_M_1706 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6LR_GLRS_M_1706(); DateTime start = Parameter.StartDate; DateTime end = Parameter.EndDate; #region get events P_L5LR_EV_TSD_1047 param = new P_L5LR_EV_TSD_1047() { EndDate = end, StartDate = start }; L5LR_EV_TSD_1047[] Events = cls_Get_Events_for_Timespan_Data.Invoke(Connection, Transaction, param, securityTicket).Result; #endregion get events #region leave request duration var employeeAndLrData = cls_Get_Employees_And_LeaveRequestData_For_IDList.Invoke(Connection, Transaction, new P_L5EM_GEALRDFIDL_1138 { EmployeeIDList = new Guid[] { Parameter.ForPerson } }, securityTicket).Result.FirstOrDefault(); L5_EM_GEWI_1628 intervalsActiveContract = cls_Get_Employee_WorktimeIntervals.Invoke(Connection, Transaction, securityTicket).Result.SingleOrDefault(); double leaveDuration = new L6LR_GLR_ID_1339().duration(intervalsActiveContract, Events, Parameter.StartDate, Parameter.EndDate, employeeAndLrData.IsWorkTimeCalculated_InDays); #endregion leave request duration var contractToReason = employeeAndLrData.WorkingContract2LeaveRequest.Where(cr => cr.CMN_BPT_STA_AbsenceReasonID == Parameter.AbsenceResonID).FirstOrDefault(); //var reasonsAndAdjustment = cls_Get_AbsenceReason_And_Adjustments_For_Employee.Invoke(Connection, Transaction, new P_L5EM_GARaAFE_1612 {AbsenceReason_ID = Parameter.AbsenceResonID }, securityTicket).Result; var calculationTimeframe = cls_Get_CalculationTimeFramesForTenant.Invoke(Connection, Transaction, securityTicket).Result.Where(x => x.CalculationTimeframe_StartDate.Year == Parameter.StartDate.Year).FirstOrDefault(); P_L5EM_GEATFSbRTFE_1423 statisticsParameter = new P_L5EM_GEATFSbRTFE_1423 { absenceReasonID = Parameter.AbsenceResonID, employeeID = Parameter.ForPerson, timeFrameID = calculationTimeframe.CMN_CAL_CalculationTimeframeID }; L5EM_GEATFSbRTFE_1423 EmployeeStatistics = cls_Get_Employee_AbsenceReason_TimeframeStatistic_byReasonTimeFrameEmployee.Invoke(Connection, Transaction, statisticsParameter, securityTicket).Result; if (EmployeeStatistics == null) { EmployeeStatistics = new L5EM_GEATFSbRTFE_1423(); } double adjustment = 0; if (contractToReason != null && contractToReason.Adjustments != null) { foreach (var adj in contractToReason.Adjustments) { if (employeeAndLrData.IsWorkTimeCalculated_InDays) { adjustment += (double)adj.AbsenceTime_InMinutes / 60; double hours = Math.Abs((double)adj.AbsenceTime_InMinutes / 60); double days = 0; while (hours > 0) { foreach (var officehours in employeeAndLrData.WeeklyOfficeHours) { double dayDuration = (double)(officehours.TimeTo_InMinutes - officehours.TimeFrom_InMinutes) / 60; hours -= dayDuration; if (officehours.IsWholeDay) { days += 1; } else { days += 0.5; } if (hours <= 0) { break; } } } adjustment = days; } else { adjustment += (double)adj.AbsenceTime_InMinutes / 60; } } } if (contractToReason == null) { contractToReason = new L5EM_GEALRDFIDL_1138_WorkingContract2LeaveRequest();//fuj } #region assign result L6LR_GLRS_M_1706 Result = null; if (employeeAndLrData.IsWorkTimeCalculated_InDays) { Result = new L6LR_GLRS_M_1706 { FromLastyear = EmployeeStatistics.R_AbsenceCarryOver_InDays, PlannedAndTaken = EmployeeStatistics.R_RequestReservedAbsence_InDays + EmployeeStatistics.R_AbsenceTimeUsed_InDays - Parameter.SavedLeaveDuration, FromThisYear = contractToReason.ContractAllowedAbsence_per_Month, ThisRequest = leaveDuration, isAllowedAbsence = contractToReason.IsAllowedAbsence, adjustment = adjustment, }; Result.Remaining = (Result.FromLastyear + Result.FromThisYear) - (Result.PlannedAndTaken + Result.ThisRequest + Math.Abs(Result.adjustment)); } else { Result = new L6LR_GLRS_M_1706 { FromLastyear = EmployeeStatistics.R_AbsenceCarryOver_InHours, PlannedAndTaken = EmployeeStatistics.R_RequestReservedAbsence_InHours + EmployeeStatistics.R_AbsenceTimeUsed_InHours - Parameter.SavedLeaveDuration, FromThisYear = contractToReason.ContractAllowedAbsence_per_Month, ThisRequest = leaveDuration, isAllowedAbsence = contractToReason.IsAllowedAbsence, adjustment = adjustment, }; Result.Remaining = (Result.FromLastyear + Result.FromThisYear) - (Result.PlannedAndTaken + Result.ThisRequest + Math.Abs(Result.adjustment)); } returnValue.Result = Result; #endregion assign result return(returnValue); #endregion UserCode }