public static double duration(this L6LR_GLR_ID_1339 leave, L5_EM_GEWI_1628 intervalsActiveContract, L5LR_EV_TSD_1047[] Events, DateTime start, DateTime end, bool inDays) { double leaveDuration = 0; for (DateTime iteratorDate = new DateTime(start.Year, start.Month, start.Day); iteratorDate < end; iteratorDate = iteratorDate.AddDays(1)) { double duration; if (intervalsActiveContract.isWorkingOn(iteratorDate.DayOfWeek)) { //take a duration from interval duration = (inDays ? intervalsActiveContract.dayDuration() : intervalsActiveContract.hoursDuration()); DateTimeRange currentRange = new DateTimeRange { Start = iteratorDate, End = new DateTime(iteratorDate.Year, iteratorDate.Month, iteratorDate.Day, end.Hour, end.Minute, end.Second) }; //get all events that fit given range (should be only one) var Event = (from e in Events from r in e.repetitions where r.Intersects(currentRange) select e).FirstOrDefault(); if (Event != null) { if (Event.EventType_IsHalfWorkingDay) { duration *= 0.5; } else if (Event.EventType_IsNonWorkingDay) { duration = 0; } } leaveDuration += duration; } } return(leaveDuration); }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6LR_CL_1224 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode FR_Guid returnValue = new FR_Guid(); #region get leave events and intervals var leaveToDeny = cls_Get_LeaveRequests_By_ID.Invoke(Connection, Transaction, new P_L6LR_GLR_ID_1339 { LeaveID = Parameter.LeaveRequestID }, securityTicket).Result; L5LR_EV_TSD_1047[] Events = cls_Get_Events_for_Timespan_Data.Invoke(Connection, Transaction, new P_L5LR_EV_TSD_1047() { EndDate = leaveToDeny.Leave.EndTime, StartDate = leaveToDeny.Leave.StartTime }, securityTicket).Result; L5_EM_GEWI_1628 intervalsActiveContract = cls_Get_Employee_WorktimeIntervals.Invoke(Connection, Transaction, securityTicket).Result.SingleOrDefault(); #endregion get leave events and intervals #region calculate duration and deny leave var durationInDays = leaveToDeny.duration(intervalsActiveContract, Events, true); var durationInHours = leaveToDeny.duration(intervalsActiveContract, Events, false); var rv = cle_Save_LeaveRequest_CancelAction.Invoke(Connection, Transaction, new P_L6LR_SLRCA_1055 { LeaveRequestID = Parameter.LeaveRequestID, durationInDays = durationInDays, durationInHours = durationInHours }, securityTicket); #endregion calculate duration and deny leave returnValue.ErrorMessage = rv.ErrorMessage; returnValue.Status = rv.Status; return(returnValue); #endregion UserCode }
public static double duration(this L6LR_GLR_ID_1339 leave, L5_EM_GEWI_1628 intervalsActiveContract, L5LR_EV_TSD_1047[] Events, bool inDays) { return(duration(leave, intervalsActiveContract, Events, leave.Leave.StartTime, leave.Leave.EndTime, inDays)); }
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 }