protected static FR_L6LR_LR_EV_D_1503 Execute(DbConnection Connection, DbTransaction Transaction, P_L6LR_LR_EV_D_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6LR_LR_EV_D_1503(); int TotalUnapprovedLeaveCount = 0; L5LR_GLRFSP_1532[] LeaveRequests = null; L5LR_EV_TSD_1047[] Events = null; #region retrive employee list for leave request //get employee details var loggedInEmployeeDetails = cls_Get_Employee_For_LoggedAccount.Invoke(Connection, Transaction, securityTicket).Result; P_L5EM_GEFTAE_1517 p_employeesForTennantAndManager = new P_L5EM_GEFTAE_1517() { EmployeeID = loggedInEmployeeDetails.CMN_BPT_EMP_EmployeeID }; //use employee details to retrive a list of employees whose leave requests you need var employeesForTenantAndManager = cls_Get_Employees_For_Tenant_And_ManagerEmployeeID.Invoke(Connection, Transaction, p_employeesForTennantAndManager, securityTicket).Result; //employed and non resigned people //employeesForTenantAndManager.Employees = employeesForTenantAndManager.Employees.Where(e => e.Work_StartDate.Ticks <= Parameter.EndDate.Ticks && !(e.Work_EndDate.Ticks <= Parameter.StartDate.Ticks)).ToArray(); #endregion #region get leave requests P_L5LR_GLRFSP_1532 p_leaves_for_selected_person = new P_L5LR_GLRFSP_1532() { EmployeeIDList = employeesForTenantAndManager.Employees.Select(e => e.CMN_BPT_EMP_EmployeeID).ToArray() }; L5LR_GLRFSP_1532[] AllLeaveRequests = cls_Get_LeaveRequests_For_SelectedPersons.Invoke(Connection, Transaction, p_leaves_for_selected_person, securityTicket).Result; TotalUnapprovedLeaveCount = AllLeaveRequests.Count(lr => lr.IsApproved == false); //add to rv only those that fit the timespan LeaveRequests = AllLeaveRequests.Where(a => ((a.StartTime >= Parameter.StartDate && a.EndTime <= Parameter.EndDate) || (a.StartTime <= Parameter.StartDate && a.EndTime >= Parameter.StartDate) || (a.StartTime <= Parameter.EndDate && a.EndTime >= Parameter.EndDate) || (a.StartTime <= Parameter.StartDate && a.EndTime >= Parameter.EndDate)) && !a.IsDeactivated).ToArray(); #endregion #region get events P_L5LR_EV_TSD_1047 param = new P_L5LR_EV_TSD_1047 { EndDate = Parameter.EndDate, StartDate = Parameter.StartDate }; Events = cls_Get_Events_for_Timespan_Data.Invoke(Connection, Transaction, param, securityTicket).Result; #endregion returnValue.Result = new L6LR_LR_EV_D_1503(); returnValue.Result.Events = Events; returnValue.Result.LeaveRequests = LeaveRequests; returnValue.Result.TotalUnapprovedLeaveCount = TotalUnapprovedLeaveCount; 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 }
protected static FR_L6LR_VNL_M_1429 Execute(DbConnection Connection, DbTransaction Transaction, P_L6LR_VNL_M_1429 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_L6LR_VNL_M_1429(); var calculationTimeframe = cls_Get_CalculationTimeFramesForTenant.Invoke(Connection, Transaction, securityTicket).Result.FirstOrDefault(); #region get events P_L5LR_EV_TSD_1047 param = new P_L5LR_EV_TSD_1047 { EndDate = Parameter.EndDate, StartDate = Parameter.StartDate }; var forbiddingEvents = cls_Get_Events_for_Timespan_Data.Invoke(Connection, Transaction, param, securityTicket).Result.Where(e => e.forbiddenLeaveTypes != null && e.forbiddenLeaveTypes.FirstOrDefault(f => f.CMN_BPT_STA_AbsenceReasonID == Parameter.AbsenceTypeID) != null); #endregion #region basic validation if (Parameter.ForPerson == Guid.Empty || Parameter.ForPerson == null) { returnValue.Result = new L6LR_VNL_M_1429 { isInvalidPerson = true }; return(returnValue); } else if (Parameter.AbsenceTypeID == Guid.Empty || Parameter.AbsenceTypeID == null) { returnValue.Result = new L6LR_VNL_M_1429 { isInvalidAbsenceReason = true }; return(returnValue); } if (Parameter.StartDate == Parameter.EndDate) { returnValue.Result = new L6LR_VNL_M_1429 { isSamedate = true }; return(returnValue); } if (Parameter.StartDate == DateTime.MinValue || Parameter.EndDate == DateTime.MinValue) { returnValue.Result = new L6LR_VNL_M_1429 { isInvalidDatePairGiven = true }; return(returnValue); } if (Parameter.EndDate < Parameter.EndDate) { returnValue.Result = new L6LR_VNL_M_1429 { isEndTimeLover = true }; return(returnValue); } #endregion basic validation 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(); var contract = employeeAndLrData.WorkingContract2LeaveRequest.FirstOrDefault(c => c.CMN_BPT_STA_AbsenceReasonID == Parameter.AbsenceTypeID); if (contract == null) { var reason = cls_get_Active_AbsenceReason_For_TenantID.Invoke(Connection, Transaction, securityTicket).Result.FirstOrDefault(r => r.CMN_BPT_STA_AbsenceReasonID == Parameter.AbsenceTypeID); if (reason.IsAllowedAbsence)//WTF? { returnValue.Result = new L6LR_VNL_M_1429 { isInvalidAbsenceReason = true }; return(returnValue); } else { if (forbiddingEvents.Count() > 0) { returnValue.Result = new L6LR_VNL_M_1429 { isIntersectingWithForbiddenEvent = true }; returnValue.Result.errorDaysInfo = new List <DateTime>(); returnValue.Result.errorDaysInfo.Add(forbiddingEvents.ToArray()[0].repetitions[0].Start); return(returnValue); } else { returnValue.Result = new L6LR_VNL_M_1429 { isValidationPassed = true }; return(returnValue); } } } var statistisParam = new P_L6LR_GLRS_M_1706 { AbsenceResonID = Parameter.AbsenceTypeID, EndDate = Parameter.EndDate, ForPerson = Parameter.ForPerson, SavedLeaveDuration = 0, StartDate = Parameter.StartDate }; var statistics = cls_Get_Leave_Statistics_Mobile.Invoke(Connection, Transaction, statistisParam, securityTicket).Result; if (statistics.PlannedAndTaken + statistics.ThisRequest > contract.ContractAllowedAbsence_per_Month + statistics.FromLastyear + statistics.adjustment && contract.IsAllowedAbsence) { returnValue.Result = new L6LR_VNL_M_1429 { isMoreDaysThanAllowed = true }; return(returnValue); } else if (forbiddingEvents.Count() > 0) { returnValue.Result = new L6LR_VNL_M_1429 { isIntersectingWithForbiddenEvent = true }; return(returnValue); } else { var p = new P_L5LR_GLRTFEAT_1634(); p.EndTime = Parameter.EndDate; p.StartTime = Parameter.StartDate; p.EmployeeID = Parameter.ForPerson; var res = cls_Get_LeaveRequestsTimes_For_EmployeeAndTime.Invoke(Connection, Transaction, p, securityTicket).Result; if (res != null) { returnValue.Result = new L6LR_VNL_M_1429 { isIntersectingWithLeaveRequest = true }; returnValue.Result.errorDaysInfo = new List <DateTime>(); returnValue.Result.errorDaysInfo.Add(res.StartTime); returnValue.Result.errorDaysInfo.Add(res.EndTime); return(returnValue); } } returnValue.Result = new L6LR_VNL_M_1429 { isValidationPassed = true }; return(returnValue); #endregion UserCode }