protected static FR_L5DWS_GEWTPFH_1725 Execute(DbConnection Connection, DbTransaction Transaction, P_L5DWS_GEWTPFH_1725 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5DWS_GEWTPFH_1725(); //Put your code here ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionQuery.EffectiveWorkTime_Header_RefID = Parameter.EffectiveWorkTime_Header_RefID; positionQuery.IsDeleted = false; positionQuery.Tenant_RefID = securityTicket.TenantID; var positions = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionQuery); List <L5DWS_GEWTFD_1648_Position> listOfPositions = new List <L5DWS_GEWTFD_1648_Position>(); foreach (var position in positions) { L5DWS_GEWTFD_1648_Position newPosition = new L5DWS_GEWTFD_1648_Position(); newPosition.Activity_RefID = position.Activity_RefID; newPosition.CMN_BPT_EMP_EffectiveWorkTime_PositionID = position.CMN_BPT_EMP_EffectiveWorkTime_PositionID; newPosition.CMN_BPT_EMP_Employe_RefID = position.CMN_BPT_EMP_Employe_RefID; newPosition.CMN_BPT_EMP_Employee_LeaveRequest_RefID = position.CMN_BPT_EMP_Employee_LeaveRequest_RefID; newPosition.EffectiveWorkTime_Header_RefID = position.EffectiveWorkTime_Header_RefID; newPosition.SourceOfEntry = position.SourceOfEntry; newPosition.Workplace_RefID = position.Workplace_RefID; newPosition.WorkTime_Duration_in_sec = position.WorkTime_Duration_in_sec; newPosition.WorkTime_StartTime = position.WorkTime_StartTime; if (position.CMN_BPT_EMP_Employee_LeaveRequest_RefID != Guid.Empty) { ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query lrQuery = new ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query(); lrQuery.CMN_BPT_EMP_Employee_LeaveRequestID = position.CMN_BPT_EMP_Employee_LeaveRequest_RefID; lrQuery.IsDeleted = false; lrQuery.Tenant_RefID = securityTicket.TenantID; var leaveRequest = ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query.Search(Connection, Transaction, lrQuery).FirstOrDefault(); newPosition.AbsenceReason_RefID = leaveRequest.CMN_BPT_STA_AbsenceReason_RefID; } else { newPosition.AbsenceReason_RefID = Guid.Empty; } listOfPositions.Add(newPosition); } returnValue.Result = new L5DWS_GEWTPFH_1725(); returnValue.Result.EffectiveWorkTimePositions = listOfPositions.ToArray(); return(returnValue); #endregion UserCode }
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5DWS_DEWTP_1130 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Base(); //Put your code here ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionQuery.CMN_BPT_EMP_EffectiveWorkTime_PositionID = Parameter.CMN_BPT_EMP_EffectiveWorkTime_PositionID; positionQuery.IsDeleted = false; positionQuery.Tenant_RefID = securityTicket.TenantID; var position = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionQuery).FirstOrDefault(); if (position == null) { return(null); } ORM_CMN_BPT_EMP_Employee_LeaveRequest leaveRequest = new ORM_CMN_BPT_EMP_Employee_LeaveRequest(); Guid leaveRequestID = Guid.Empty; if (position.CMN_BPT_EMP_Employee_LeaveRequest_RefID != Guid.Empty) { leaveRequestID = position.CMN_BPT_EMP_Employee_LeaveRequest_RefID; } if (leaveRequestID != Guid.Empty) { leaveRequest.Load(Connection, Transaction, leaveRequestID); leaveRequest.Remove(Connection, Transaction); ORM_CMN_CAL_Event leaveRequestEvent = new ORM_CMN_CAL_Event(); leaveRequestEvent.Load(Connection, Transaction, leaveRequest.CMN_CAL_Event_RefID); leaveRequestEvent.Remove(Connection, Transaction); var calQuery = new ORM_CMN_CAL_Event.Query(); calQuery.CMN_CAL_EventID = leaveRequest.CMN_CAL_Event_RefID; var calendarRes = ORM_CMN_CAL_Event.Query.Search(Connection, Transaction, calQuery); ORM_CMN_CAL_Event calendarEvent = calendarRes[0]; var timeFrame = cls_Get_CalculationTimeFramesForTenant.Invoke(Connection, Transaction, securityTicket).Result.Where(x => x.CalculationTimeframe_StartDate.Year == calendarEvent.StartTime.Year).FirstOrDefault(); P_L5EM_GEATFSbRTFE_1423 statParam = new P_L5EM_GEATFSbRTFE_1423(); statParam.absenceReasonID = leaveRequest.CMN_BPT_STA_AbsenceReason_RefID; statParam.employeeID = leaveRequest.RequestedFor_Employee_RefID; statParam.timeFrameID = timeFrame.CMN_CAL_CalculationTimeframeID; var statistics = cls_Get_Employee_AbsenceReason_TimeframeStatistic_byReasonTimeFrameEmployee.Invoke(Connection, Transaction, statParam, securityTicket).Result; if (statistics != null) { P_L5EM_SEARTFS_1356 updateStatisticsParam = new P_L5EM_SEARTFS_1356(); updateStatisticsParam.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID = statistics.CMN_BPT_EMP_Employee_AbsenceReason_TimeframeStatisticsID; updateStatisticsParam.Employee_RefID = statistics.Employee_RefID; updateStatisticsParam.CalculationTimeframe_RefID = statistics.CalculationTimeframe_RefID; updateStatisticsParam.AbsenceReason_RefID = statistics.AbsenceReason_RefID; updateStatisticsParam.R_AbsenceCarryOver_InDays = statistics.R_AbsenceCarryOver_InDays; updateStatisticsParam.R_AbsenceCarryOver_InHours = statistics.R_AbsenceCarryOver_InHours; updateStatisticsParam.R_TotalAllowedAbsenceTime_InDays = statistics.R_TotalAllowedAbsenceTime_InDays + Parameter.durationInDays; updateStatisticsParam.R_TotalAllowedAbsenceTime_InHours = statistics.R_TotalAllowedAbsenceTime_InHours + Parameter.durationInHours; updateStatisticsParam.R_RequestReservedAbsence_InDays = statistics.R_RequestReservedAbsence_InDays; updateStatisticsParam.R_RequestReservedAbsence_InHours = statistics.R_RequestReservedAbsence_InHours; updateStatisticsParam.R_AbsenceTimeUsed_InDays = statistics.R_AbsenceTimeUsed_InDays - Parameter.durationInDays; updateStatisticsParam.R_AbsenceTimeUsed_InHours = statistics.R_AbsenceTimeUsed_InHours - Parameter.durationInHours; var res = cls_Save_Employee_AbsenceReason_TimeframeStatistic.Invoke(Connection, Transaction, updateStatisticsParam, securityTicket); } } position.IsDeleted = true; position.Save(Connection, Transaction); return(returnValue); #endregion UserCode }
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5DWS_LAD_1001 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode FR_Base returnValue = new FR_Base(); var dayCount = 1; if (Parameter.LoadFor_Week) { dayCount = 7; } LeaveRequestUtils leaveRequestUtil = new LeaveRequestUtils(); for (int i = 0; i < dayCount; i++) { var date = Parameter.WorkSheduleDate.Date.AddDays(i); if (Parameter.LoadFrom_LastWeek || Parameter.LoadFrom_Specific_Date_Or_Week) { DateTime loadForDate; if (Parameter.LoadFrom_Specific_Date_Or_Week) { loadForDate = Parameter.IfLoadFrom_Specific_Date_Or_Week_DateTime.AddDays(i); } else { loadForDate = Parameter.WorkSheduleDate.AddDays(-7).AddDays(i); } ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query actualsQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query(); actualsQuery.EffectiveBusinessDay = loadForDate; actualsQuery.Tenant_RefID = securityTicket.TenantID; actualsQuery.IsDeleted = false; var allEffectiveWorkTimeHeadersToLoadFrom = ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query.Search(Connection, Transaction, actualsQuery); foreach (var effectiveWorkTimeHeader in allEffectiveWorkTimeHeadersToLoadFrom) { ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query effectiveWorkTimeToDeleteQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query(); effectiveWorkTimeToDeleteQuery.EffectiveBusinessDay = date; effectiveWorkTimeToDeleteQuery.Employee_RefID = effectiveWorkTimeHeader.Employee_RefID; effectiveWorkTimeToDeleteQuery.Tenant_RefID = securityTicket.TenantID; effectiveWorkTimeToDeleteQuery.IsDeleted = false; var effectiveWorkTimeHeaderToDeleteQueryResult = ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query.Search(Connection, Transaction, effectiveWorkTimeToDeleteQuery); if (effectiveWorkTimeHeaderToDeleteQueryResult.Count != 0) { var effectiveWorkTimeHeaderToDelete = effectiveWorkTimeHeaderToDeleteQueryResult.FirstOrDefault(); P_L5DWS_DEWTH_1126 deleteParam = new P_L5DWS_DEWTH_1126(); deleteParam.CMN_STR_PPS_EffectiveWorkTime_HeaderID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionsQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionsQuery.EffectiveWorkTime_Header_RefID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionsQuery.Tenant_RefID = securityTicket.TenantID; positionsQuery.IsDeleted = false; var positions = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionsQuery); List <P_L5DWS_DEWTH_1126_Positions> listOfPositions = new List <P_L5DWS_DEWTH_1126_Positions>(); foreach (var position in positions) { P_L5DWS_DEWTH_1126_Positions positionItem = new P_L5DWS_DEWTH_1126_Positions(); positionItem.CMN_BPT_EMP_EffectiveWorkTime_PositionID = position.CMN_BPT_EMP_EffectiveWorkTime_PositionID; positionItem.durationInDays = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), true); positionItem.durationInHours = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), false); listOfPositions.Add(positionItem); } deleteParam.Positions = listOfPositions.ToArray(); cls_Delete_EffectiveWorkTime_Header.Invoke(Connection, Transaction, deleteParam, securityTicket); } ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionsToLoadQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionsToLoadQuery.EffectiveWorkTime_Header_RefID = effectiveWorkTimeHeader.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionsToLoadQuery.Tenant_RefID = securityTicket.TenantID; positionsToLoadQuery.IsDeleted = false; var positionsToLoad = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionsToLoadQuery); ORM_CMN_BPT_EMP_EffectiveWorkTime_Header newHeader = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header(); newHeader.ContractWorkerText = effectiveWorkTimeHeader.ContractWorkerText; newHeader.BreakDurationTime_in_sec = effectiveWorkTimeHeader.BreakDurationTime_in_sec; newHeader.EffectiveBusinessDay = date; newHeader.Employee_RefID = effectiveWorkTimeHeader.Employee_RefID; newHeader.IsBreakTimeManualySpecified = effectiveWorkTimeHeader.IsBreakTimeManualySpecified; newHeader.SheduleBreakTemplate_RefID = effectiveWorkTimeHeader.SheduleBreakTemplate_RefID; newHeader.Tenant_RefID = securityTicket.TenantID; newHeader.Save(Connection, Transaction); foreach (var positionToLoad in positionsToLoad) { P_L5DWS_SEWTP_1337 positionSavePar = new P_L5DWS_SEWTP_1337(); if (positionToLoad.CMN_BPT_EMP_Employee_LeaveRequest_RefID != Guid.Empty) { ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query lrQuery = new ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query(); lrQuery.CMN_BPT_EMP_Employee_LeaveRequestID = positionToLoad.CMN_BPT_EMP_Employee_LeaveRequest_RefID; lrQuery.IsDeleted = false; lrQuery.Tenant_RefID = securityTicket.TenantID; var leaveRequest = ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query.Search(Connection, Transaction, lrQuery).FirstOrDefault(); positionSavePar.AbsenceReason_RefID = leaveRequest.CMN_BPT_STA_AbsenceReason_RefID; positionSavePar.durationInDays = leaveRequestUtil.LeaveRequestDuration(positionToLoad.WorkTime_StartTime, positionToLoad.WorkTime_StartTime.AddSeconds(positionToLoad.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == positionToLoad.CMN_BPT_EMP_Employe_RefID), true); positionSavePar.durationInHours = leaveRequestUtil.LeaveRequestDuration(positionToLoad.WorkTime_StartTime, positionToLoad.WorkTime_StartTime.AddSeconds(positionToLoad.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == positionToLoad.CMN_BPT_EMP_Employe_RefID), false); positionSavePar.RequestedBy_Employee_RefID = leaveRequest.RequestedBy_Employee_RefID; positionSavePar.RequestedFor_Employee_RefID = leaveRequest.RequestedFor_Employee_RefID; } else { positionSavePar.AbsenceReason_RefID = Guid.Empty; positionSavePar.durationInDays = 0; positionSavePar.durationInHours = 0; positionSavePar.RequestedBy_Employee_RefID = Guid.Empty; positionSavePar.RequestedFor_Employee_RefID = Guid.Empty; } positionSavePar.CMN_BPT_EMP_Employee_LeaveRequest_RefID = Guid.Empty; positionSavePar.EffectiveWorkTime_Header_RefID = newHeader.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionSavePar.Employee_RefID = newHeader.Employee_RefID; positionSavePar.OldDurationInDays = 0; positionSavePar.OldDurationInHours = 0; positionSavePar.Workplace_RefID = positionToLoad.Workplace_RefID; positionSavePar.WorkTime_End = positionToLoad.WorkTime_StartTime.AddSeconds(positionToLoad.WorkTime_Duration_in_sec); positionSavePar.WorkTime_Start = positionToLoad.WorkTime_StartTime; cls_Save_EffectiveWorkTime_Position.Invoke(Connection, Transaction, positionSavePar, securityTicket); } } } else if (Parameter.LoadFrom_StandardTimes) { bool isEven = false; if (CronExtender.weekNumber(date) % 2 == 0) { isEven = true; } ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query workplaceAssignementQuery = new ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query(); foreach (var empInfo in Parameter.EmployeeInformation) { var empID = empInfo.EmployeeID; workplaceAssignementQuery.CMN_BPT_EMP_Employee_RefID = empID; workplaceAssignementQuery.Tenant_RefID = securityTicket.TenantID; workplaceAssignementQuery.IsDeleted = false; var workplaceAssignements = ORM_CMN_BPT_EMP_Employee_WorkplaceAssignment.Query.Search(Connection, Transaction, workplaceAssignementQuery); if (workplaceAssignements != null) { var workplaceAssignement = workplaceAssignements.FirstOrDefault(x => x.WorkplaceAssignment_StartDate <= date && (x.WorkplaceAssignment_EndDate >= date || x.WorkplaceAssignment_EndDate == new DateTime())); if (workplaceAssignement != null) { ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern.Query patternQuery = new ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern.Query(); patternQuery.BoundTo_WorkplaceAssignment_RefID = workplaceAssignement.CMN_BPT_EMP_Employee_WorkplaceAssignment; patternQuery.Tenant_RefID = securityTicket.TenantID; patternQuery.IsDeleted = false; var patterns = ORM_CMN_BPT_EMP_WorkplaceAssignments_WorkPattern.Query.Search(Connection, Transaction, patternQuery); if (patterns != null) { foreach (var pattern in patterns) { if (pattern.IsWeek_Even == isEven || !pattern.IsWeek_Even && pattern.IsWeek_Odd) { switch (date.DayOfWeek) { case DayOfWeek.Monday: if (!pattern.IsMonday) { continue; } break; case DayOfWeek.Tuesday: if (!pattern.IsTuesday) { continue; } break; case DayOfWeek.Wednesday: if (!pattern.IsWednesday) { continue; } break; case DayOfWeek.Thursday: if (!pattern.IsThursday) { continue; } break; case DayOfWeek.Friday: if (!pattern.IsFriday) { continue; } break; case DayOfWeek.Saturday: if (!pattern.IsSaturday) { continue; } break; case DayOfWeek.Sunday: if (!pattern.IsSunday) { continue; } break; } if (pattern.CMN_PPS_ShiftTemplate_RefID == Guid.Empty && pattern.CMN_BPT_STA_AbsenceReason_RefID != Guid.Empty) { double totalTime = 0; DateTime startTime = date; DateTime endTime = new DateTime(date.Year, date.Month, date.Day, 23, 59, 59); double startTimeInSec = startTime.TimeOfDay.TotalSeconds; double endTimeInSec = endTime.TimeOfDay.TotalSeconds; ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query effectiveWorkTimeToDeleteQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query(); effectiveWorkTimeToDeleteQuery.EffectiveBusinessDay = date; effectiveWorkTimeToDeleteQuery.Employee_RefID = empID; effectiveWorkTimeToDeleteQuery.Tenant_RefID = securityTicket.TenantID; effectiveWorkTimeToDeleteQuery.IsDeleted = false; var allEffectiveWorkTimeHeadersToDelete = ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query.Search(Connection, Transaction, effectiveWorkTimeToDeleteQuery); foreach (var effectiveWorkTimeHeaderToDelete in allEffectiveWorkTimeHeadersToDelete) { P_L5DWS_DEWTH_1126 deleteParam = new P_L5DWS_DEWTH_1126(); deleteParam.CMN_STR_PPS_EffectiveWorkTime_HeaderID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionsQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionsQuery.EffectiveWorkTime_Header_RefID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionsQuery.Tenant_RefID = securityTicket.TenantID; positionsQuery.IsDeleted = false; var positions = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionsQuery); List <P_L5DWS_DEWTH_1126_Positions> listOfPositions = new List <P_L5DWS_DEWTH_1126_Positions>(); foreach (var position in positions) { P_L5DWS_DEWTH_1126_Positions positionItem = new P_L5DWS_DEWTH_1126_Positions(); positionItem.CMN_BPT_EMP_EffectiveWorkTime_PositionID = position.CMN_BPT_EMP_EffectiveWorkTime_PositionID; positionItem.durationInDays = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), true); positionItem.durationInHours = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), false); listOfPositions.Add(positionItem); } deleteParam.Positions = listOfPositions.ToArray(); cls_Delete_EffectiveWorkTime_Header.Invoke(Connection, Transaction, deleteParam, securityTicket); } ORM_CMN_BPT_EMP_EffectiveWorkTime_Header effectiveWorkTimeHeader = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header(); effectiveWorkTimeHeader.IsBreakTimeManualySpecified = false; effectiveWorkTimeHeader.ContractWorkerText = ""; effectiveWorkTimeHeader.Employee_RefID = empID; effectiveWorkTimeHeader.Tenant_RefID = securityTicket.TenantID; effectiveWorkTimeHeader.EffectiveBusinessDay = date; effectiveWorkTimeHeader.Save(Connection, Transaction); P_L5DWS_SEWTP_1337 effectivePositionParam = new P_L5DWS_SEWTP_1337(); effectivePositionParam.EffectiveWorkTime_Header_RefID = effectiveWorkTimeHeader.CMN_STR_PPS_EffectiveWorkTime_HeaderID; effectivePositionParam.WorkTime_Start = effectiveWorkTimeHeader.EffectiveBusinessDay.AddSeconds(0); effectivePositionParam.WorkTime_End = effectiveWorkTimeHeader.EffectiveBusinessDay.AddSeconds(86340); effectivePositionParam.Employee_RefID = empID; effectivePositionParam.AbsenceReason_RefID = pattern.CMN_BPT_STA_AbsenceReason_RefID; effectivePositionParam.RequestedFor_Employee_RefID = empID; cls_Save_EffectiveWorkTime_Position.Invoke(Connection, Transaction, effectivePositionParam, securityTicket); } else if (pattern.CMN_PPS_ShiftTemplate_RefID != Guid.Empty) { ORM_CMN_PPS_ShiftTemplate.Query shiftTemplateQuery = new ORM_CMN_PPS_ShiftTemplate.Query(); shiftTemplateQuery.CMN_PPS_ShiftTemplateID = pattern.CMN_PPS_ShiftTemplate_RefID; shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID; shiftTemplateQuery.IsDeleted = false; var shiftTemplate = ORM_CMN_PPS_ShiftTemplate.Query.Search(Connection, Transaction, shiftTemplateQuery).FirstOrDefault(); if (shiftTemplate != null) { ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query effectiveWorkTimeToDeleteQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query(); effectiveWorkTimeToDeleteQuery.EffectiveBusinessDay = date; effectiveWorkTimeToDeleteQuery.Employee_RefID = empID; effectiveWorkTimeToDeleteQuery.Tenant_RefID = securityTicket.TenantID; effectiveWorkTimeToDeleteQuery.IsDeleted = false; var allEffectiveWorkTimeHeadersToDelete = ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query.Search(Connection, Transaction, effectiveWorkTimeToDeleteQuery); foreach (var effectiveWorkTimeHeaderToDelete in allEffectiveWorkTimeHeadersToDelete) { P_L5DWS_DEWTH_1126 deleteParam = new P_L5DWS_DEWTH_1126(); deleteParam.CMN_STR_PPS_EffectiveWorkTime_HeaderID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionsQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionsQuery.EffectiveWorkTime_Header_RefID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionsQuery.Tenant_RefID = securityTicket.TenantID; positionsQuery.IsDeleted = false; var positions = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionsQuery); List <P_L5DWS_DEWTH_1126_Positions> listOfPositions = new List <P_L5DWS_DEWTH_1126_Positions>(); foreach (var position in positions) { P_L5DWS_DEWTH_1126_Positions positionItem = new P_L5DWS_DEWTH_1126_Positions(); positionItem.CMN_BPT_EMP_EffectiveWorkTime_PositionID = position.CMN_BPT_EMP_EffectiveWorkTime_PositionID; positionItem.durationInDays = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), true); positionItem.durationInHours = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), false); listOfPositions.Add(positionItem); } deleteParam.Positions = listOfPositions.ToArray(); cls_Delete_EffectiveWorkTime_Header.Invoke(Connection, Transaction, deleteParam, securityTicket); } P_L5DWS_SEWTFST_1141 saveParam = new P_L5DWS_SEWTFST_1141(); saveParam.EffectiveBusinessDay = date; saveParam.Employee_RefID = empID; saveParam.ShiftTemplate_RefID = shiftTemplate.CMN_PPS_ShiftTemplateID; cls_Save_EffectiveWorkTime_For_ShiftTemplate.Invoke(Connection, Transaction, saveParam, securityTicket); } } } } } } } } } else if (Parameter.LoadFrom_PlanData) { P_L5DWS_GDWSWDFT_0946 param = new P_L5DWS_GDWSWDFT_0946(); param.WorkSheduleDate = date; var dailyWorkSchedules = cls_Get_DailyWorkSchedules_WithDetails_For_Date.Invoke(Connection, Transaction, param, securityTicket).Result; foreach (var dailyWorkSchedule in dailyWorkSchedules) { ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query effectiveWorkTimeToDeleteQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query(); effectiveWorkTimeToDeleteQuery.EffectiveBusinessDay = date; effectiveWorkTimeToDeleteQuery.Employee_RefID = dailyWorkSchedule.Employee_RefID; effectiveWorkTimeToDeleteQuery.Tenant_RefID = securityTicket.TenantID; effectiveWorkTimeToDeleteQuery.IsDeleted = false; var effectiveWorkTimeHeaderToDeleteQueryResult = ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query.Search(Connection, Transaction, effectiveWorkTimeToDeleteQuery); if (effectiveWorkTimeHeaderToDeleteQueryResult.Count != 0) { var effectiveWorkTimeHeaderToDelete = effectiveWorkTimeHeaderToDeleteQueryResult.FirstOrDefault(); P_L5DWS_DEWTH_1126 deleteParam = new P_L5DWS_DEWTH_1126(); deleteParam.CMN_STR_PPS_EffectiveWorkTime_HeaderID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionsQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionsQuery.EffectiveWorkTime_Header_RefID = effectiveWorkTimeHeaderToDelete.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionsQuery.Tenant_RefID = securityTicket.TenantID; positionsQuery.IsDeleted = false; var positions = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionsQuery); List <P_L5DWS_DEWTH_1126_Positions> listOfPositions = new List <P_L5DWS_DEWTH_1126_Positions>(); foreach (var position in positions) { P_L5DWS_DEWTH_1126_Positions positionItem = new P_L5DWS_DEWTH_1126_Positions(); positionItem.CMN_BPT_EMP_EffectiveWorkTime_PositionID = position.CMN_BPT_EMP_EffectiveWorkTime_PositionID; positionItem.durationInDays = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), true); positionItem.durationInHours = leaveRequestUtil.LeaveRequestDuration(position.WorkTime_StartTime, position.WorkTime_StartTime.AddSeconds(position.WorkTime_Duration_in_sec), Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == position.CMN_BPT_EMP_Employe_RefID), false); listOfPositions.Add(positionItem); } deleteParam.Positions = listOfPositions.ToArray(); cls_Delete_EffectiveWorkTime_Header.Invoke(Connection, Transaction, deleteParam, securityTicket); } ORM_CMN_BPT_EMP_EffectiveWorkTime_Header newHeader = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header(); newHeader.ContractWorkerText = dailyWorkSchedule.ContractWorkerText; newHeader.BreakDurationTime_in_sec = dailyWorkSchedule.BreakDurationTime_in_sec; newHeader.EffectiveBusinessDay = date; newHeader.Employee_RefID = dailyWorkSchedule.Employee_RefID; newHeader.IsBreakTimeManualySpecified = dailyWorkSchedule.IsBreakTimeManualySpecified; newHeader.SheduleBreakTemplate_RefID = dailyWorkSchedule.SheduleBreakTemplate_RefID; newHeader.Tenant_RefID = securityTicket.TenantID; newHeader.Save(Connection, Transaction); foreach (var dailyWorkDetail in dailyWorkSchedule.Details) { P_L5DWS_SEWTP_1337 positionSavePar = new P_L5DWS_SEWTP_1337(); if (dailyWorkDetail.LeaveRequest_RefID != Guid.Empty) { positionSavePar.AbsenceReason_RefID = dailyWorkDetail.AbsenceReason_RefID; positionSavePar.durationInDays = leaveRequestUtil.LeaveRequestDuration(dailyWorkDetail.FromTime_as_DateTime, dailyWorkDetail.ToTime_as_DateTime, Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == dailyWorkSchedule.Employee_RefID), true); positionSavePar.durationInHours = leaveRequestUtil.LeaveRequestDuration(dailyWorkDetail.FromTime_as_DateTime, dailyWorkDetail.ToTime_as_DateTime, Parameter.Events, Parameter.Employees.FirstOrDefault(x => x.CMN_BPT_EMP_EmployeeID == dailyWorkSchedule.Employee_RefID), false); positionSavePar.RequestedBy_Employee_RefID = Guid.Empty; positionSavePar.RequestedFor_Employee_RefID = dailyWorkSchedule.Employee_RefID; } else { positionSavePar.AbsenceReason_RefID = Guid.Empty; positionSavePar.durationInDays = 0; positionSavePar.durationInHours = 0; positionSavePar.RequestedBy_Employee_RefID = Guid.Empty; positionSavePar.RequestedFor_Employee_RefID = Guid.Empty; } positionSavePar.CMN_BPT_EMP_Employee_LeaveRequest_RefID = Guid.Empty; positionSavePar.EffectiveWorkTime_Header_RefID = newHeader.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionSavePar.Employee_RefID = newHeader.Employee_RefID; positionSavePar.OldDurationInDays = 0; positionSavePar.OldDurationInHours = 0; positionSavePar.Workplace_RefID = dailyWorkDetail.SheduleForWorkplace_RefID; positionSavePar.WorkTime_End = dailyWorkDetail.ToTime_as_DateTime; positionSavePar.WorkTime_Start = dailyWorkDetail.FromTime_as_DateTime; cls_Save_EffectiveWorkTime_Position.Invoke(Connection, Transaction, positionSavePar, securityTicket); } } } } //Put your code here return(returnValue); #endregion UserCode }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5WP_IWPU_1503 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); //Put your code here ORM_CMN_BPT_EMP_Employee_PlanGroup.Query planGroupQuery = new ORM_CMN_BPT_EMP_Employee_PlanGroup.Query(); planGroupQuery.BoundTo_WorkPlace_RefID = Parameter.WorkplaceID; planGroupQuery.IsDeleted = false; planGroupQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_BPT_EMP_Employee_PlanGroup.Query.Exists(Connection, Transaction, planGroupQuery)) { returnValue.Result = true; } ORM_CMN_BPT_EMP_ExtraWorkCalculation_StructureBinding.Query extraWorkCalculationQuery = new ORM_CMN_BPT_EMP_ExtraWorkCalculation_StructureBinding.Query(); extraWorkCalculationQuery.BoundTo_Workplace_RefID = Parameter.WorkplaceID; extraWorkCalculationQuery.IsDeleted = false; extraWorkCalculationQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_BPT_EMP_ExtraWorkCalculation_StructureBinding.Query.Exists(Connection, Transaction, extraWorkCalculationQuery)) { returnValue.Result = true; } ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge_StructureBinding.Query surchargeQuery = new ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge_StructureBinding.Query(); surchargeQuery.BoundTo_Workplace_RefID = Parameter.WorkplaceID; surchargeQuery.IsDeleted = false; surchargeQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_BPT_EMP_ExtraWorkCalculation_Surcharge_StructureBinding.Query.Exists(Connection, Transaction, surchargeQuery)) { returnValue.Result = true; } ORM_CMN_BPT_EMP_Employee.Query employeeQuery = new ORM_CMN_BPT_EMP_Employee.Query(); employeeQuery.Primary_Workplace_RefID = Parameter.WorkplaceID; employeeQuery.IsDeleted = false; employeeQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_BPT_EMP_Employee.Query.Exists(Connection, Transaction, employeeQuery)) { returnValue.Result = true; } ORM_CMN_PPS_ShiftTemplate.Query shiftTemplateQuery = new ORM_CMN_PPS_ShiftTemplate.Query(); shiftTemplateQuery.CMN_STR_Workplace_RefID = Parameter.WorkplaceID; shiftTemplateQuery.IsDeleted = false; shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_PPS_ShiftTemplate.Query.Exists(Connection, Transaction, shiftTemplateQuery)) { returnValue.Result = true; } ORM_CMN_PPS_BreakTime_Defaults_StructureBinding.Query defaultBreakQuery = new ORM_CMN_PPS_BreakTime_Defaults_StructureBinding.Query(); defaultBreakQuery.BoundTo_Workplace_RefID = Parameter.WorkplaceID; defaultBreakQuery.IsDeleted = false; defaultBreakQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_PPS_BreakTime_Defaults_StructureBinding.Query.Exists(Connection, Transaction, defaultBreakQuery)) { returnValue.Result = true; } ORM_CMN_PPS_BreakTime_Template.Query breakTimeTemplateQuery = new ORM_CMN_PPS_BreakTime_Template.Query(); breakTimeTemplateQuery.BoundTo_Workplace_RefID = Parameter.WorkplaceID; breakTimeTemplateQuery.IsDeleted = false; breakTimeTemplateQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_PPS_BreakTime_Template.Query.Exists(Connection, Transaction, breakTimeTemplateQuery)) { returnValue.Result = true; } ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query WorkplaceResponsiblePersonQuery = new ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query(); WorkplaceResponsiblePersonQuery.Workplace_RefID = Parameter.WorkplaceID; WorkplaceResponsiblePersonQuery.IsDeleted = false; WorkplaceResponsiblePersonQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_STR_PPS_Workplace_ResponsiblePerson.Query.Exists(Connection, Transaction, WorkplaceResponsiblePersonQuery)) { returnValue.Result = true; } ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query WorkplaceEffectiveWorkTimePositionQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); WorkplaceEffectiveWorkTimePositionQuery.Workplace_RefID = Parameter.WorkplaceID; WorkplaceEffectiveWorkTimePositionQuery.IsDeleted = false; WorkplaceEffectiveWorkTimePositionQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Exists(Connection, Transaction, WorkplaceEffectiveWorkTimePositionQuery)) { returnValue.Result = true; } ORM_CMN_STR_PPS_DailyWorkSchedule_Detail.Query WorkplaceDailyScheduleQuery = new ORM_CMN_STR_PPS_DailyWorkSchedule_Detail.Query(); WorkplaceDailyScheduleQuery.SheduleForWorkplace_RefID = Parameter.WorkplaceID; WorkplaceDailyScheduleQuery.IsDeleted = false; WorkplaceDailyScheduleQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_STR_PPS_DailyWorkSchedule_Detail.Query.Exists(Connection, Transaction, WorkplaceDailyScheduleQuery)) { returnValue.Result = true; } ORM_CMN_STR_PPS_WorkDetail_Activity.Query WorkplaceWorkDetailActivityQuery = new ORM_CMN_STR_PPS_WorkDetail_Activity.Query(); WorkplaceWorkDetailActivityQuery.CMN_STR_PPS_Workplace_RefID = Parameter.WorkplaceID; WorkplaceWorkDetailActivityQuery.IsDeleted = false; WorkplaceWorkDetailActivityQuery.Tenant_RefID = securityTicket.TenantID; if (ORM_CMN_STR_PPS_WorkDetail_Activity.Query.Exists(Connection, Transaction, WorkplaceWorkDetailActivityQuery)) { returnValue.Result = true; } return(returnValue); #endregion UserCode }
protected static FR_L5DWS_GEWTFDAE_0953 Execute(DbConnection Connection, DbTransaction Transaction, P_L5DWS_GEWTFDAE_0953 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_L5DWS_GEWTFDAE_0953(); //Put your code here ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query effectiveWorkTimeHeaderQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query(); effectiveWorkTimeHeaderQuery.EffectiveBusinessDay = Parameter.currentDate.Date; effectiveWorkTimeHeaderQuery.Employee_RefID = Parameter.EmployeeID; effectiveWorkTimeHeaderQuery.IsDeleted = false; effectiveWorkTimeHeaderQuery.Tenant_RefID = securityTicket.TenantID; var header = ORM_CMN_BPT_EMP_EffectiveWorkTime_Header.Query.Search(Connection, Transaction, effectiveWorkTimeHeaderQuery).FirstOrDefault(); if (header == null) { returnValue.Result = new L5DWS_GEWTFDAE_0953(); returnValue.Result.EffectiveWorkTime = null; return(returnValue); } L5DWS_GEWTFD_1648 resultItem = new L5DWS_GEWTFD_1648(); resultItem.CMN_STR_PPS_EffectiveWorkTime_HeaderID = header.CMN_STR_PPS_EffectiveWorkTime_HeaderID; resultItem.BreakDurationTime_in_sec = header.BreakDurationTime_in_sec; resultItem.ContractWorkerText = header.ContractWorkerText; resultItem.EffectiveBusinessDay = header.EffectiveBusinessDay; resultItem.Employee_RefID = header.Employee_RefID; resultItem.IsBreakTimeManualySpecified = header.IsBreakTimeManualySpecified; resultItem.SheduleBreakTemplate_RefID = header.SheduleBreakTemplate_RefID; resultItem.WorktimeComment = header.WorktimeComment; ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query positionQuery = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query(); positionQuery.EffectiveWorkTime_Header_RefID = header.CMN_STR_PPS_EffectiveWorkTime_HeaderID; positionQuery.IsDeleted = false; positionQuery.Tenant_RefID = securityTicket.TenantID; var positions = ORM_CMN_BPT_EMP_EffectiveWorkTime_Position.Query.Search(Connection, Transaction, positionQuery); List <L5DWS_GEWTFD_1648_Position> listOfPositions = new List <L5DWS_GEWTFD_1648_Position>(); foreach (var position in positions) { L5DWS_GEWTFD_1648_Position newPosition = new L5DWS_GEWTFD_1648_Position(); newPosition.Activity_RefID = position.Activity_RefID; newPosition.CMN_BPT_EMP_EffectiveWorkTime_PositionID = position.CMN_BPT_EMP_EffectiveWorkTime_PositionID; newPosition.CMN_BPT_EMP_Employe_RefID = position.CMN_BPT_EMP_Employe_RefID; newPosition.CMN_BPT_EMP_Employee_LeaveRequest_RefID = position.CMN_BPT_EMP_Employee_LeaveRequest_RefID; newPosition.EffectiveWorkTime_Header_RefID = position.EffectiveWorkTime_Header_RefID; newPosition.SourceOfEntry = position.SourceOfEntry; newPosition.Workplace_RefID = position.Workplace_RefID; newPosition.WorkTime_Duration_in_sec = position.WorkTime_Duration_in_sec; newPosition.WorkTime_StartTime = position.WorkTime_StartTime; if (position.CMN_BPT_EMP_Employee_LeaveRequest_RefID != Guid.Empty) { ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query lrQuery = new ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query(); lrQuery.CMN_BPT_EMP_Employee_LeaveRequestID = position.CMN_BPT_EMP_Employee_LeaveRequest_RefID; lrQuery.IsDeleted = false; lrQuery.Tenant_RefID = securityTicket.TenantID; var leaveRequest = ORM_CMN_BPT_EMP_Employee_LeaveRequest.Query.Search(Connection, Transaction, lrQuery).FirstOrDefault(); newPosition.AbsenceReason_RefID = leaveRequest.CMN_BPT_STA_AbsenceReason_RefID; } else { newPosition.AbsenceReason_RefID = Guid.Empty; } listOfPositions.Add(newPosition); } resultItem.Positions = listOfPositions.ToArray(); returnValue.Result = new L5DWS_GEWTFDAE_0953(); returnValue.Result.EffectiveWorkTime = resultItem; return(returnValue); #endregion UserCode }