protected static FR_L5BR_GBMFT_1503_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5BR_GBMFT_1503_Array();
List <L5BR_GBMFT_1503> breakModelList = new List <L5BR_GBMFT_1503>();
ORM_CMN_PPS_BreakTime_Template.Query breakteTimeTemplateQuery = new ORM_CMN_PPS_BreakTime_Template.Query();
breakteTimeTemplateQuery.IsDeleted = false;
breakteTimeTemplateQuery.Tenant_RefID = securityTicket.TenantID;
List <ORM_CMN_PPS_BreakTime_Template> breakTimeTemplates = ORM_CMN_PPS_BreakTime_Template.Query.Search(Connection, Transaction, breakteTimeTemplateQuery);
foreach (var breakTimeTemplate in breakTimeTemplates)
{
L5BR_GBMFT_1503 breakModel = new L5BR_GBMFT_1503();
breakModel.BreakTimeTemplate_Name_DictID = breakTimeTemplate.BreakTimeTemplate_Name;
breakModel.CMN_PPS_BreakTime_TemplateID = breakTimeTemplate.CMN_PPS_BreakTime_TemplateID;
int duration = 0;
ORM_CMN_PPS_BreakTime_Template_Assignment.Query breakeTimeAssigmentQuery = new ORM_CMN_PPS_BreakTime_Template_Assignment.Query();
breakeTimeAssigmentQuery.IsDeleted = false;
breakeTimeAssigmentQuery.Tenant_RefID = securityTicket.TenantID;
breakeTimeAssigmentQuery.BreakTime_Template_RefID = breakTimeTemplate.CMN_PPS_BreakTime_TemplateID;
List <ORM_CMN_PPS_BreakTime_Template_Assignment> breakTimeAssignemnts = ORM_CMN_PPS_BreakTime_Template_Assignment.Query.Search(Connection, Transaction, breakeTimeAssigmentQuery);
foreach (var assignment in breakTimeAssignemnts)
{
ORM_CMN_PPS_BreakTime breakeTime = new ORM_CMN_PPS_BreakTime();
breakeTime.Load(Connection, Transaction, assignment.BreakTime_RefID);
if (breakeTime.IsBreakfastBreak)
{
breakModel.BreakfestDuration = breakeTime.Default_Duration_in_sec;
}
else if (breakeTime.IsDinnerBreak)
{
breakModel.DinnerDuration = breakeTime.Default_Duration_in_sec;
}
else if (breakeTime.IsLunchBreak)
{
breakModel.LunchDuration = breakeTime.Default_Duration_in_sec;
}
else
{
duration += breakeTime.Default_Duration_in_sec;
}
}
breakModel.Duration = duration;
breakModel.Office_RefID = breakTimeTemplate.BoundTo_Office_RefID;
breakModel.Workarea_RefID = breakTimeTemplate.BoundTo_Workarea_RefID;
breakModel.Workplace_RefID = breakTimeTemplate.BoundTo_Workplace_RefID;
breakModelList.Add(breakModel);
}
returnValue.Result = breakModelList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5WA_IWAU_0954 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
//Put your code here
returnValue.Result = false;
ORM_CMN_BPT_EMP_Employee_PlanGroup.Query planGroupQuery = new ORM_CMN_BPT_EMP_Employee_PlanGroup.Query();
planGroupQuery.BoundTo_WorkArea_RefID = Parameter.WorkAreaID;
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_WorkArea_RefID = Parameter.WorkAreaID;
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_WorkArea_RefID = Parameter.WorkAreaID;
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_WorkArea_RefID = Parameter.WorkAreaID;
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_Workarea_RefID = Parameter.WorkAreaID;
shiftTemplateQuery.IsDeleted = false;
shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_PPS_ShiftTemplate.Query.Exists(Connection, Transaction, shiftTemplateQuery))
{
returnValue.Result = true;
}
ORM_CMN_PPS_ShiftTemplate_WorkareaAssignment.Query shiftWorkareaAssignemntQuery = new ORM_CMN_PPS_ShiftTemplate_WorkareaAssignment.Query();
shiftWorkareaAssignemntQuery.CMN_BPT_PPS_WorkArea_RefID = Parameter.WorkAreaID;
shiftWorkareaAssignemntQuery.IsDeleted = false;
shiftWorkareaAssignemntQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_PPS_ShiftTemplate_WorkareaAssignment.Query.Exists(Connection, Transaction, shiftWorkareaAssignemntQuery))
{
returnValue.Result = true;
}
ORM_CMN_PPS_BreakTime_Defaults_StructureBinding.Query defaultBreakQuery = new ORM_CMN_PPS_BreakTime_Defaults_StructureBinding.Query();
defaultBreakQuery.BoundTo_WorkArea_RefID = Parameter.WorkAreaID;
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_Workarea_RefID = Parameter.WorkAreaID;
breakTimeTemplateQuery.IsDeleted = false;
breakTimeTemplateQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_PPS_BreakTime_Template.Query.Exists(Connection, Transaction, breakTimeTemplateQuery))
{
returnValue.Result = true;
}
ORM_CMN_BPT_STR_Workarea_SettingsProfile.Query workareaSettingsProfileQuery = new ORM_CMN_BPT_STR_Workarea_SettingsProfile.Query();
workareaSettingsProfileQuery.Workarea_RefID = Parameter.WorkAreaID;
workareaSettingsProfileQuery.IsDeleted = false;
workareaSettingsProfileQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_BPT_STR_Workarea_SettingsProfile.Query.Exists(Connection, Transaction, workareaSettingsProfileQuery))
{
returnValue.Result = true;
}
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_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5OF_IOFU_1531 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Bool();
ORM_CMN_BPT_EMP_Employee_PlanGroup.Query planGroupQuery = new ORM_CMN_BPT_EMP_Employee_PlanGroup.Query();
planGroupQuery.BoundTo_Office_RefID = Parameter.OfficeID;
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_Office_RefID = Parameter.OfficeID;
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_Office_RefID = Parameter.OfficeID;
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_Office_RefID = Parameter.OfficeID;
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_Office_RefID = Parameter.OfficeID;
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_Office_RefID = Parameter.OfficeID;
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_Office_RefID = Parameter.OfficeID;
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_WorkArea.Query workplaceQuery = new ORM_CMN_STR_PPS_WorkArea.Query();
workplaceQuery.Office_RefID = Parameter.OfficeID;
workplaceQuery.IsDeleted = false;
workplaceQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_STR_PPS_WorkArea.Query.Exists(Connection, Transaction, workplaceQuery))
{
returnValue.Result = true;
}
ORM_CMN_BPT_STR_Office_SettingsProfile.Query OfficeSettingsProfileQuery = new ORM_CMN_BPT_STR_Office_SettingsProfile.Query();
OfficeSettingsProfileQuery.Office_RefID = Parameter.OfficeID;
OfficeSettingsProfileQuery.IsDeleted = false;
OfficeSettingsProfileQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_BPT_STR_Office_SettingsProfile.Query.Exists(Connection, Transaction, OfficeSettingsProfileQuery))
{
returnValue.Result = true;
}
ORM_CMN_STR_Office_2_CostCenter.Query OfficeCostcenterQuery = new ORM_CMN_STR_Office_2_CostCenter.Query();
OfficeCostcenterQuery.Office_RefID = Parameter.OfficeID;
OfficeCostcenterQuery.IsDeleted = false;
OfficeCostcenterQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_STR_Office_2_CostCenter.Query.Exists(Connection, Transaction, OfficeCostcenterQuery))
{
returnValue.Result = true;
}
ORM_CMN_STR_Office_Default_WorkRelationDefinition_Template.Query OfficeDefaultWorkRelationTemplateQuery = new ORM_CMN_STR_Office_Default_WorkRelationDefinition_Template.Query();
OfficeDefaultWorkRelationTemplateQuery.CMN_STR_Office_RefID = Parameter.OfficeID;
OfficeDefaultWorkRelationTemplateQuery.IsDeleted = false;
OfficeDefaultWorkRelationTemplateQuery.Tenant_RefID = securityTicket.TenantID;
if (ORM_CMN_STR_Office_Default_WorkRelationDefinition_Template.Query.Exists(Connection, Transaction, OfficeDefaultWorkRelationTemplateQuery))
{
returnValue.Result = true;
}
//Put your code here
return(returnValue);
#endregion UserCode
}
