protected static FR_Guids Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_GSTQFST_1516 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guids();
List <Guid> returnList = new List <Guid>();
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query shiftTemplateDetailQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
shiftTemplateDetailQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateDetailQuery.IsDeleted = false;
shiftTemplateDetailQuery.CMN_PPS_ShiftTemplate_RefID = Parameter.ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate_WorkDetail> shiftTemplateDetails = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, shiftTemplateDetailQuery);
foreach (var shiftTemplateDetail in shiftTemplateDetails)
{
ORM_CMN_STR_PPS_WorkDetail_Activity.Query activityQuery = new ORM_CMN_STR_PPS_WorkDetail_Activity.Query();
activityQuery.IsDeleted = false;
activityQuery.Tenant_RefID = securityTicket.TenantID;
activityQuery.CMN_PPS_ShiftTemplate_WorkDetail_RefID = shiftTemplateDetail.CMN_PPS_ShiftTemplate_WorkDetailID;
List <ORM_CMN_STR_PPS_WorkDetail_Activity> activities = ORM_CMN_STR_PPS_WorkDetail_Activity.Query.Search(Connection, Transaction, activityQuery);
if (activities.Count != 0)
{
activities = activities.Where(i => i.CMN_STR_PPS_Workplace_RefID == Guid.Empty).ToList();
foreach (var activity in activities)
{
ORM_CMN_STR_PPS_Activity activityItem = new ORM_CMN_STR_PPS_Activity();
activityItem.Load(Connection, Transaction, activity.CMN_STR_PPS_Activity_RefID);
if (!activityItem.IsAbsenceActivity)
{
ORM_CMN_STR_PPS_Activity_SkillAssignment.Query SkillactivityAssignment = new ORM_CMN_STR_PPS_Activity_SkillAssignment.Query();
SkillactivityAssignment.CMN_STR_PPS_Activity_RefID = activity.CMN_STR_PPS_Activity_RefID;
SkillactivityAssignment.Tenant_RefID = securityTicket.TenantID;
SkillactivityAssignment.IsDeleted = false;
List <ORM_CMN_STR_PPS_Activity_SkillAssignment> skillAssignments = ORM_CMN_STR_PPS_Activity_SkillAssignment.Query.Search(Connection, Transaction, SkillactivityAssignment);
if (skillAssignments.Count != 0)
{
if (!returnList.Contains(skillAssignments[0].CMN_STR_Skill_RefID))
{
returnList.Add(skillAssignments[0].CMN_STR_Skill_RefID);
}
}
}
}
}
}
returnValue.Result = returnList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5ST_GSTDFST_1402_Array Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_GSTDFST_1402 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5ST_GSTDFST_1402_Array();
List <L5ST_GSTDFST_1402> returnList = new List <L5ST_GSTDFST_1402>();
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query shiftTemplateDetailQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
shiftTemplateDetailQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateDetailQuery.IsDeleted = false;
shiftTemplateDetailQuery.CMN_PPS_ShiftTemplate_RefID = Parameter.ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate_WorkDetail> shiftTemplateDetails = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, shiftTemplateDetailQuery);
foreach (var shiftTemplateDetail in shiftTemplateDetails)
{
L5ST_GSTDFST_1402 shiftTemplateDetailItem = new L5ST_GSTDFST_1402();
shiftTemplateDetailItem.CMN_PPS_ShiftTemplate_WorkDetailID = shiftTemplateDetail.CMN_PPS_ShiftTemplate_WorkDetailID;
shiftTemplateDetailItem.Duration_in_sec = shiftTemplateDetail.Duration_in_sec;
shiftTemplateDetailItem.Required_StaffHeadCount = shiftTemplateDetail.Required_StaffHeadCount;
shiftTemplateDetailItem.ShiftStart_Offset_sec = shiftTemplateDetail.ShiftStart_Offset_sec;
shiftTemplateDetailItem.WorkDetail_Note_Content = shiftTemplateDetail.WorkDetail_Note_Content;
shiftTemplateDetailItem.WorkDetail_Note_Title = shiftTemplateDetail.WorkDetail_Note_Title;
ORM_CMN_STR_PPS_WorkDetail_Activity.Query activityDetailQuery = new ORM_CMN_STR_PPS_WorkDetail_Activity.Query();
activityDetailQuery.IsDeleted = false;
activityDetailQuery.Tenant_RefID = securityTicket.TenantID;
activityDetailQuery.CMN_PPS_ShiftTemplate_WorkDetail_RefID = shiftTemplateDetail.CMN_PPS_ShiftTemplate_WorkDetailID;
List <ORM_CMN_STR_PPS_WorkDetail_Activity> activityDetails = ORM_CMN_STR_PPS_WorkDetail_Activity.Query.Search(Connection, Transaction, activityDetailQuery);
if (activityDetails != null && activityDetails.Count != 0)
{
ORM_CMN_STR_PPS_WorkDetail_Activity activityDetail = activityDetails.FirstOrDefault();
shiftTemplateDetailItem.CMN_STR_PPS_Workplace_RefID = activityDetail.CMN_STR_PPS_Workplace_RefID;
if (activityDetail.CMN_STR_PPS_Activity_RefID != Guid.Empty)
{
ORM_CMN_STR_PPS_Activity activity = new ORM_CMN_STR_PPS_Activity();
activity.Load(Connection, Transaction, activityDetail.CMN_STR_PPS_Activity_RefID);
shiftTemplateDetailItem.AbsenceReason_RefID = activity.AbsenceReason_RefID;
}
}
returnList.Add(shiftTemplateDetailItem);
}
returnValue.Result = returnList.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_DST_0917 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Base();
var item = new ORM_CMN_PPS_ShiftTemplate();
item.Load(Connection, Transaction, Parameter.CMN_PPS_ShiftTemplateID);
item.Remove(Connection, Transaction);
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query workDetailQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
workDetailQuery.IsDeleted = false;
workDetailQuery.Tenant_RefID = securityTicket.TenantID;
workDetailQuery.CMN_PPS_ShiftTemplate_RefID = item.CMN_PPS_ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate_WorkDetail> workDetailsList = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, workDetailQuery);
if (workDetailsList != null && workDetailsList.Count != 0)
{
foreach (var workDetail in workDetailsList)
{
workDetail.Remove(Connection, Transaction);
ORM_CMN_STR_PPS_WorkDetail_Activity.Query activityDetailQuery = new ORM_CMN_STR_PPS_WorkDetail_Activity.Query();
activityDetailQuery.IsDeleted = false;
activityDetailQuery.Tenant_RefID = securityTicket.TenantID;
activityDetailQuery.CMN_PPS_ShiftTemplate_WorkDetail_RefID = workDetail.CMN_PPS_ShiftTemplate_WorkDetailID;
List <ORM_CMN_STR_PPS_WorkDetail_Activity> activityDetails = ORM_CMN_STR_PPS_WorkDetail_Activity.Query.Search(Connection, Transaction, activityDetailQuery);
if (activityDetails != null && activityDetails.Count != 0)
{
ORM_CMN_STR_PPS_WorkDetail_Activity activityDetail = activityDetails.FirstOrDefault();
activityDetail.Remove(Connection, Transaction);
if (activityDetail.CMN_STR_PPS_Activity_RefID != Guid.Empty)
{
ORM_CMN_STR_PPS_Activity activity = new ORM_CMN_STR_PPS_Activity();
activity.Load(Connection, Transaction, activityDetail.CMN_STR_PPS_Activity_RefID);
activity.Remove(Connection, Transaction);
}
}
}
}
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_SST_0854 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_CMN_PPS_ShiftTemplate();
if (Parameter.CMN_PPS_ShiftTemplateID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.CMN_PPS_ShiftTemplateID);
if (result.Status != FR_Status.Success || item.CMN_PPS_ShiftTemplateID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
item.ShiftTemplate_Name = Parameter.ShiftTemplate_Name;
item.ShiftTemplate_ShortName = Parameter.ShiftTemplate_ShortName;
item.CMN_STR_Office_RefID = Parameter.CMN_STR_Office_RefID;
item.CMN_STR_Workarea_RefID = Parameter.CMN_STR_Workarea_RefID;
item.CMN_STR_Workplace_RefID = Parameter.CMN_STR_Workplace_RefID;
item.Default_AllowedBreakTimeTemplate_RefID = Parameter.Default_AllowedBreakTimeTemplate_RefID;
item.DisplayColor = Parameter.DisplayColor;
item.Tenant_RefID = securityTicket.TenantID;
item.Save(Connection, Transaction);
returnValue.Result = item.CMN_PPS_ShiftTemplateID;
foreach (var skillID in Parameter.QualificationList)
{
ORM_CMN_STR_PPS_Activity_SkillAssignment.Query activityAssignment = new ORM_CMN_STR_PPS_Activity_SkillAssignment.Query();
activityAssignment.CMN_STR_Skill_RefID = skillID;
activityAssignment.Tenant_RefID = securityTicket.TenantID;
activityAssignment.IsDeleted = false;
List <ORM_CMN_STR_PPS_Activity_SkillAssignment> skillAssignments = ORM_CMN_STR_PPS_Activity_SkillAssignment.Query.Search(Connection, Transaction, activityAssignment);
if (skillAssignments.Count == 0)
{
ORM_CMN_STR_PPS_Activity activity = new ORM_CMN_STR_PPS_Activity();
activity.Activity_ShortName = "generated skill activity";
activity.IsSkill = true;
activity.Tenant_RefID = securityTicket.TenantID;
activity.Save(Connection, Transaction);
ORM_CMN_STR_PPS_Activity_SkillAssignment skillAssignemnt = new ORM_CMN_STR_PPS_Activity_SkillAssignment();
skillAssignemnt.CMN_STR_Skill_RefID = skillID;
skillAssignemnt.CMN_STR_PPS_Activity_RefID = activity.CMN_STR_PPS_ActivityID;
skillAssignemnt.Tenant_RefID = securityTicket.TenantID;
skillAssignemnt.Save(Connection, Transaction);
}
}
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query shiftTemplateDetailQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
shiftTemplateDetailQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateDetailQuery.IsDeleted = false;
shiftTemplateDetailQuery.CMN_PPS_ShiftTemplate_RefID = item.CMN_PPS_ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate_WorkDetail> shiftTemplateDetails = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, shiftTemplateDetailQuery);
foreach (var shiftTemplateDetail in shiftTemplateDetails)
{
ORM_CMN_STR_PPS_WorkDetail_Activity.Query activityQuery = new ORM_CMN_STR_PPS_WorkDetail_Activity.Query();
activityQuery.IsDeleted = false;
activityQuery.Tenant_RefID = securityTicket.TenantID;
activityQuery.CMN_PPS_ShiftTemplate_WorkDetail_RefID = shiftTemplateDetail.CMN_PPS_ShiftTemplate_WorkDetailID;
List <ORM_CMN_STR_PPS_WorkDetail_Activity> activities = ORM_CMN_STR_PPS_WorkDetail_Activity.Query.Search(Connection, Transaction, activityQuery);
if (activities.Count != 0)
{
activities = activities.Where(i => i.CMN_STR_PPS_Workplace_RefID == Guid.Empty).ToList();
foreach (var activity in activities)
{
ORM_CMN_STR_PPS_Activity activityItem = new ORM_CMN_STR_PPS_Activity();
activityItem.Load(Connection, Transaction, activity.CMN_STR_PPS_Activity_RefID);
if (!activityItem.IsAbsenceActivity)
{
activity.Remove(Connection, Transaction);
}
}
}
foreach (var skillID in Parameter.QualificationList)
{
ORM_CMN_STR_PPS_Activity_SkillAssignment.Query SkillactivityAssignment = new ORM_CMN_STR_PPS_Activity_SkillAssignment.Query();
SkillactivityAssignment.CMN_STR_Skill_RefID = skillID;
SkillactivityAssignment.Tenant_RefID = securityTicket.TenantID;
SkillactivityAssignment.IsDeleted = false;
List <ORM_CMN_STR_PPS_Activity_SkillAssignment> skillAssignments = ORM_CMN_STR_PPS_Activity_SkillAssignment.Query.Search(Connection, Transaction, SkillactivityAssignment);
if (skillAssignments.Count != 0)
{
ORM_CMN_STR_PPS_WorkDetail_Activity activityAssignment = new ORM_CMN_STR_PPS_WorkDetail_Activity();
activityAssignment.CMN_PPS_ShiftTemplate_WorkDetail_RefID = shiftTemplateDetail.CMN_PPS_ShiftTemplate_WorkDetailID;
activityAssignment.CMN_STR_PPS_Activity_RefID = skillAssignments[0].CMN_STR_PPS_Activity_RefID;
activityAssignment.Tenant_RefID = securityTicket.TenantID;
activityAssignment.Save(Connection, Transaction);
}
}
}
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_L5ST_GSTFSTI_1641 Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_GSTFSTI_1641 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5ST_GSTFSTI_1641();
returnValue.Result = new L5ST_GSTFSTI_1641();
ORM_CMN_PPS_ShiftTemplate.Query shiftTemplateQuery = new ORM_CMN_PPS_ShiftTemplate.Query();
shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateQuery.IsDeleted = false;
shiftTemplateQuery.CMN_PPS_ShiftTemplateID = Parameter.ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate> shiftTemplates = ORM_CMN_PPS_ShiftTemplate.Query.Search(Connection, Transaction, shiftTemplateQuery);
ORM_CMN_PPS_ShiftTemplate shiftTemplate = shiftTemplates[0];
L5ST_GSTFT_1610 templateItem = new L5ST_GSTFT_1610();
templateItem.CMN_PPS_ShiftTemplateID = shiftTemplate.CMN_PPS_ShiftTemplateID;
templateItem.CMN_STR_Office_RefID = shiftTemplate.CMN_STR_Office_RefID;
templateItem.CMN_STR_Workarea_RefID = shiftTemplate.CMN_STR_Workarea_RefID;
templateItem.CMN_STR_Workplace_RefID = shiftTemplate.CMN_STR_Workplace_RefID;
templateItem.ShiftTemplate_Name = shiftTemplate.ShiftTemplate_Name;
templateItem.ShiftTemplate_ShortName = shiftTemplate.ShiftTemplate_ShortName;
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query workdetailsQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
workdetailsQuery.IsDeleted = false;
workdetailsQuery.Tenant_RefID = securityTicket.TenantID;
workdetailsQuery.CMN_PPS_ShiftTemplate_RefID = shiftTemplate.CMN_PPS_ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate_WorkDetail> workDetails = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, workdetailsQuery);
if (workDetails != null && workDetails.Count != 0)
{
int startingTime = 0;
int endingTime = 0;
int brakeTime = 0;
double totalWorkTime = 0;
foreach (var workDetail in workDetails)
{
if (startingTime == 0 || startingTime > workDetail.ShiftStart_Offset_sec)
{
startingTime = (int)workDetail.ShiftStart_Offset_sec;
}
if (endingTime < workDetail.ShiftStart_Offset_sec + workDetail.Duration_in_sec)
{
endingTime = (int)workDetail.ShiftStart_Offset_sec + (int)workDetail.Duration_in_sec;
}
totalWorkTime += workDetail.Duration_in_sec;
}
templateItem.BrakeTime = CronExtender.secondsToTime(brakeTime);
templateItem.EndTime = CronExtender.secondsToTime(endingTime);
templateItem.StartTime = CronExtender.secondsToTime(startingTime);
templateItem.Worktime = CronExtender.secondsToTime(Int32.Parse(totalWorkTime.ToString()));
}
returnValue.Result.ShiftTemplate = templateItem;
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DWS_SDWSFST_1447 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
ORM_CMN_PPS_ShiftTemplate.Query shiftTemplateQuery = new ORM_CMN_PPS_ShiftTemplate.Query();
shiftTemplateQuery.CMN_PPS_ShiftTemplateID = Parameter.InstantiatedWithShiftTemplate_RefID;
shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateQuery.IsDeleted = false;
ORM_CMN_PPS_ShiftTemplate shiftTemplate = ORM_CMN_PPS_ShiftTemplate.Query.Search(Connection, Transaction, shiftTemplateQuery).FirstOrDefault();
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query shiftTemplateWorkDetailQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
shiftTemplateWorkDetailQuery.CMN_PPS_ShiftTemplate_RefID = Parameter.InstantiatedWithShiftTemplate_RefID;
shiftTemplateWorkDetailQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateWorkDetailQuery.IsDeleted = false;
var shiftTemplateDetailsResult = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, shiftTemplateWorkDetailQuery);
double totalTime = 0;
DateTime?startTime = null;
DateTime?endTime = null;
foreach (var shiftTemplateDetail in shiftTemplateDetailsResult)
{
DateTime detailStartTime = Parameter.WorkSheduleDate.Date.AddSeconds(shiftTemplateDetail.ShiftStart_Offset_sec);
DateTime detailEndTime = Parameter.WorkSheduleDate.Date.AddSeconds(shiftTemplateDetail.ShiftStart_Offset_sec + Math.Abs(shiftTemplateDetail.Duration_in_sec));
if (startTime == null)
{
startTime = detailStartTime;
}
if (endTime == null)
{
endTime = detailEndTime;
}
if (detailStartTime < startTime)
{
startTime = detailStartTime;
}
if (detailEndTime > endTime)
{
endTime = detailEndTime;
}
totalTime += shiftTemplateDetail.Duration_in_sec;
}
double startTimeInSec = 0;
double endTimeInSec = 0;
if (startTime.HasValue)
{
startTimeInSec = startTime.Value.TimeOfDay.TotalSeconds;
}
if (endTime.HasValue)
{
endTimeInSec = endTime.Value.TimeOfDay.TotalSeconds;
}
ORM_CMN_STR_PPS_DailyWorkSchedule dailyWorkSchedule = new ORM_CMN_STR_PPS_DailyWorkSchedule();
dailyWorkSchedule.IsBreakTimeManualySpecified = false;
dailyWorkSchedule.SheduleBreakTemplate_RefID = shiftTemplate.Default_AllowedBreakTimeTemplate_RefID;
dailyWorkSchedule.InstantiatedWithShiftTemplate_RefID = Parameter.InstantiatedWithShiftTemplate_RefID;
if (shiftTemplate.Default_AllowedBreakTimeTemplate_RefID != Guid.Empty && Parameter.IsBreakTimeCalculated_Planning)
{
ORM_CMN_PPS_BreakTime_Template_Assignment.Query breakTimeAssignmentQuery = new ORM_CMN_PPS_BreakTime_Template_Assignment.Query();
breakTimeAssignmentQuery.BreakTime_Template_RefID = shiftTemplate.Default_AllowedBreakTimeTemplate_RefID;
breakTimeAssignmentQuery.Tenant_RefID = securityTicket.TenantID;
breakTimeAssignmentQuery.IsDeleted = false;
var breakTimeAssignments = ORM_CMN_PPS_BreakTime_Template_Assignment.Query.Search(Connection, Transaction, breakTimeAssignmentQuery);
foreach (var breakTimeAssignment in breakTimeAssignments)
{
ORM_CMN_PPS_BreakTime.Query breakTimeQuery = new ORM_CMN_PPS_BreakTime.Query();
breakTimeQuery.CMN_PPS_BreakTimeID = breakTimeAssignment.BreakTime_RefID;
breakTimeQuery.Tenant_RefID = securityTicket.TenantID;
breakTimeQuery.IsDeleted = false;
breakTimeQuery.IsDinnerBreak = false;
breakTimeQuery.IsLunchBreak = false;
breakTimeQuery.IsBreakfastBreak = false;
var breakTime = ORM_CMN_PPS_BreakTime.Query.Search(Connection, Transaction, breakTimeQuery).FirstOrDefault();
if (breakTime != null)
{
dailyWorkSchedule.BreakDurationTime_in_sec += breakTime.Default_Duration_in_sec;
}
}
}
else
{
dailyWorkSchedule.BreakDurationTime_in_sec = 0;
}
dailyWorkSchedule.R_WorkDay_Start_in_sec = (int)startTimeInSec;
dailyWorkSchedule.R_WorkDay_Duration_in_sec = (int)totalTime;
dailyWorkSchedule.R_WorkDay_End_in_sec = (int)endTimeInSec;
dailyWorkSchedule.R_ContractSpecified_WorkingTime_in_sec = Parameter.R_ContractSpecified_WorkingTime_in_sec;
dailyWorkSchedule.ContractWorkerText = "";
dailyWorkSchedule.Employee_RefID = Parameter.Employee_RefID;
dailyWorkSchedule.WorkSheduleDate = Parameter.WorkSheduleDate.Date;
dailyWorkSchedule.Tenant_RefID = securityTicket.TenantID;
dailyWorkSchedule.Save(Connection, Transaction);
returnValue.Result = dailyWorkSchedule.CMN_STR_PPS_DailyWorkScheduleID;
foreach (var shiftTemplateDetail in shiftTemplateDetailsResult)
{
P_L5DWS_SDWSD_1130 detailParam = new P_L5DWS_SDWSD_1130();
detailParam.WorkTime_Start = dailyWorkSchedule.WorkSheduleDate.AddSeconds(shiftTemplateDetail.ShiftStart_Offset_sec);
detailParam.WorkTime_End = dailyWorkSchedule.WorkSheduleDate.AddSeconds(shiftTemplateDetail.ShiftStart_Offset_sec + shiftTemplateDetail.Duration_in_sec);
detailParam.DailyWorkSchedule_RefID = dailyWorkSchedule.CMN_STR_PPS_DailyWorkScheduleID;
detailParam.IsWorkBreak = false;
detailParam.SheduleForWorkplace_RefID = Guid.Empty;
detailParam.AbsenceReason_RefID = Guid.Empty;
detailParam.RequestedBy_Employee_RefID = Guid.Empty;
detailParam.RequestedFor_Employee_RefID = Parameter.Employee_RefID;
cls_Save_Employee_DailyWorkSchedule_Detail.Invoke(Connection, Transaction, detailParam, securityTicket);
}
return(returnValue);
#endregion UserCode
}
protected static FR_L5ST_GSTFT_1610_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5ST_GSTFT_1610_Array();
List <L5ST_GSTFT_1610> shiftTemplatesReturn = new List <L5ST_GSTFT_1610>();
ORM_CMN_PPS_ShiftTemplate.Query shiftTemplateQuery = new ORM_CMN_PPS_ShiftTemplate.Query();
shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateQuery.IsDeleted = false;
List <ORM_CMN_PPS_ShiftTemplate> shiftTemplates = ORM_CMN_PPS_ShiftTemplate.Query.Search(Connection, Transaction, shiftTemplateQuery);
foreach (var shiftTemplate in shiftTemplates)
{
L5ST_GSTFT_1610 templateItem = new L5ST_GSTFT_1610();
templateItem.CMN_PPS_ShiftTemplateID = shiftTemplate.CMN_PPS_ShiftTemplateID;
templateItem.CMN_STR_Office_RefID = shiftTemplate.CMN_STR_Office_RefID;
templateItem.CMN_STR_Workarea_RefID = shiftTemplate.CMN_STR_Workarea_RefID;
templateItem.CMN_STR_Workplace_RefID = shiftTemplate.CMN_STR_Workplace_RefID;
templateItem.ShiftTemplate_Name = shiftTemplate.ShiftTemplate_Name;
templateItem.ShiftTemplate_ShortName = shiftTemplate.ShiftTemplate_ShortName;
templateItem.Default_AllowedBreakTimeTemplate_RefID = shiftTemplate.Default_AllowedBreakTimeTemplate_RefID;
templateItem.DisplayColor = shiftTemplate.DisplayColor;
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query workdetailsQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
workdetailsQuery.IsDeleted = false;
workdetailsQuery.Tenant_RefID = securityTicket.TenantID;
workdetailsQuery.CMN_PPS_ShiftTemplate_RefID = shiftTemplate.CMN_PPS_ShiftTemplateID;
List <ORM_CMN_PPS_ShiftTemplate_WorkDetail> workDetails = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, workdetailsQuery);
if (workDetails != null && workDetails.Count != 0)
{
int startingTime = 0;
int endingTime = 0;
double totalWorkTime = 0;
foreach (var workDetail in workDetails)
{
if (startingTime == 0 || (startingTime > workDetail.ShiftStart_Offset_sec && workDetail.ShiftStart_Offset_sec != 0))
{
startingTime = (int)workDetail.ShiftStart_Offset_sec;
}
if (endingTime < workDetail.ShiftStart_Offset_sec + workDetail.Duration_in_sec)
{
endingTime = (int)workDetail.ShiftStart_Offset_sec + (int)workDetail.Duration_in_sec;
}
totalWorkTime += workDetail.Duration_in_sec;
}
templateItem.EndTime = CronExtender.secondsToTime(endingTime);
templateItem.StartTime = CronExtender.secondsToTime(startingTime);
templateItem.Worktime = CronExtender.secondsToTime(Int32.Parse(totalWorkTime.ToString()));
}
else
{
templateItem.EndTime = CronExtender.secondsToTime(0);
templateItem.StartTime = CronExtender.secondsToTime(0);
templateItem.Worktime = CronExtender.secondsToTime(0);
}
int brakeTime = 0;
if (shiftTemplate.Default_AllowedBreakTimeTemplate_RefID != Guid.Empty)
{
P_L5BR_GBMFTID_1537 par = new P_L5BR_GBMFTID_1537();
par.CMN_PPS_BreakTime_TemplateID = shiftTemplate.Default_AllowedBreakTimeTemplate_RefID;
L5BR_GBMFTID_1537 breakModel = cls_Get_BreakModels_For_TemplateID.Invoke(Connection, Transaction, par, securityTicket).Result;
brakeTime = breakModel.BreakModel.Duration;
templateItem.BrakeTime = CronExtender.secondsToTime(brakeTime);
templateItem.Worktime = CronExtender.secondsToTime(CronExtender.timeToSeconds(templateItem.Worktime) - brakeTime);
}
else
{
templateItem.BrakeTime = CronExtender.secondsToTime(0);
}
P_L5ST_GSTQFST_1516 param = new P_L5ST_GSTQFST_1516();
param.ShiftTemplateID = shiftTemplate.CMN_PPS_ShiftTemplateID;
templateItem.Qualifications = cls_Get_ShiftQualifications_For_ShiftTemplateID.Invoke(Connection, Transaction, param, securityTicket).Result;
shiftTemplatesReturn.Add(templateItem);
}
returnValue.Result = shiftTemplatesReturn.ToArray();
//Put your code here
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DWS_SEWTFST_1141 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_CMN_PPS_ShiftTemplate.Query shiftTemplateQuery = new ORM_CMN_PPS_ShiftTemplate.Query();
shiftTemplateQuery.CMN_PPS_ShiftTemplateID = Parameter.ShiftTemplate_RefID;
shiftTemplateQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateQuery.IsDeleted = false;
ORM_CMN_PPS_ShiftTemplate shiftTemplate = ORM_CMN_PPS_ShiftTemplate.Query.Search(Connection, Transaction, shiftTemplateQuery).FirstOrDefault();
ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query shiftTemplateWorkDetailQuery = new ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query();
shiftTemplateWorkDetailQuery.CMN_PPS_ShiftTemplate_RefID = Parameter.ShiftTemplate_RefID;
shiftTemplateWorkDetailQuery.Tenant_RefID = securityTicket.TenantID;
shiftTemplateWorkDetailQuery.IsDeleted = false;
var shiftTemplateDetailsResult = ORM_CMN_PPS_ShiftTemplate_WorkDetail.Query.Search(Connection, Transaction, shiftTemplateWorkDetailQuery);
ORM_CMN_BPT_EMP_EffectiveWorkTime_Header effectiveWorkTimeHeader = new ORM_CMN_BPT_EMP_EffectiveWorkTime_Header();
effectiveWorkTimeHeader.IsBreakTimeManualySpecified = false;
effectiveWorkTimeHeader.SheduleBreakTemplate_RefID = shiftTemplate.Default_AllowedBreakTimeTemplate_RefID;
if (shiftTemplate.Default_AllowedBreakTimeTemplate_RefID != Guid.Empty && Parameter.IsBreakTimeCalculated_Actual)
{
ORM_CMN_PPS_BreakTime_Template_Assignment.Query breakTimeAssignmentQuery = new ORM_CMN_PPS_BreakTime_Template_Assignment.Query();
breakTimeAssignmentQuery.BreakTime_Template_RefID = shiftTemplate.Default_AllowedBreakTimeTemplate_RefID;
breakTimeAssignmentQuery.Tenant_RefID = securityTicket.TenantID;
breakTimeAssignmentQuery.IsDeleted = false;
var breakTimeAssignment = ORM_CMN_PPS_BreakTime_Template_Assignment.Query.Search(Connection, Transaction, breakTimeAssignmentQuery).FirstOrDefault();
ORM_CMN_PPS_BreakTime.Query breakTimeQuery = new ORM_CMN_PPS_BreakTime.Query();
breakTimeQuery.CMN_PPS_BreakTimeID = breakTimeAssignment.BreakTime_RefID;
breakTimeQuery.Tenant_RefID = securityTicket.TenantID;
breakTimeQuery.IsDeleted = false;
var breakTime = ORM_CMN_PPS_BreakTime.Query.Search(Connection, Transaction, breakTimeQuery).FirstOrDefault();
effectiveWorkTimeHeader.BreakDurationTime_in_sec = breakTime.Default_Duration_in_sec;
}
else
{
effectiveWorkTimeHeader.BreakDurationTime_in_sec = 0;
}
effectiveWorkTimeHeader.EffectiveBusinessDay = Parameter.EffectiveBusinessDay;
effectiveWorkTimeHeader.ContractWorkerText = "";
effectiveWorkTimeHeader.Employee_RefID = Parameter.Employee_RefID;
effectiveWorkTimeHeader.Tenant_RefID = securityTicket.TenantID;
effectiveWorkTimeHeader.Save(Connection, Transaction);
foreach (var shiftTemplateDetail in shiftTemplateDetailsResult)
{
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(shiftTemplateDetail.ShiftStart_Offset_sec);
effectivePositionParam.WorkTime_End = effectiveWorkTimeHeader.EffectiveBusinessDay.AddSeconds(shiftTemplateDetail.ShiftStart_Offset_sec + shiftTemplateDetail.Duration_in_sec);
effectivePositionParam.Employee_RefID = Parameter.Employee_RefID;
effectivePositionParam.RequestedFor_Employee_RefID = Parameter.Employee_RefID;
cls_Save_EffectiveWorkTime_Position.Invoke(Connection, Transaction, effectivePositionParam, securityTicket);
}
return(returnValue);
#endregion UserCode
}
