protected static FR_Base Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_DSTD_1425 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_Guid();

            var item = new ORM_CMN_PPS_ShiftTemplate_WorkDetail();
            item.Load(Connection, Transaction, Parameter.CMN_PPS_ShiftTemplate_WorkDetailID);
            item.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 = item.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_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
        }
Ejemplo n.º 3
0
        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_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5ST_SSTD_1423 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_Guid();


            var item = new ORM_CMN_PPS_ShiftTemplate_WorkDetail();
            if (Parameter.CMN_PPS_ShiftTemplate_WorkDetailID != Guid.Empty)
            {
                var result = item.Load(Connection, Transaction, Parameter.CMN_PPS_ShiftTemplate_WorkDetailID);
                if (result.Status != FR_Status.Success || item.CMN_PPS_ShiftTemplate_WorkDetailID == Guid.Empty)
                {
                    var error = new FR_Guid();
                    error.ErrorMessage = "No Such ID";
                    error.Status       = FR_Status.Error_Internal;
                    return(error);
                }
            }
            item.CMN_PPS_ShiftTemplate_RefID = Parameter.CMN_PPS_ShiftTemplate_RefID;
            item.Duration_in_sec             = Parameter.Duration_in_sec;
            item.ShiftStart_Offset_sec       = Parameter.ShiftStart_Offset_sec;
            item.Tenant_RefID            = securityTicket.TenantID;
            item.WorkDetail_Note_Content = Parameter.WorkDetail_Note_Content;
            item.WorkDetail_Note_Title   = Parameter.WorkDetail_Note_Title;
            item.Save(Connection, Transaction);

            ORM_CMN_PPS_ShiftTemplate shiftTemplate = new ORM_CMN_PPS_ShiftTemplate();
            shiftTemplate.Load(Connection, Transaction, item.CMN_PPS_ShiftTemplate_RefID);
            shiftTemplate.Default_AllowedBreakTimeTemplate_RefID = Parameter.AllowedBreakTime_RefID;
            shiftTemplate.Save(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 = item.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.CMN_STR_PPS_Workplace_RefID = Parameter.CMN_STR_PPS_Workplace_RefID;

                ORM_CMN_STR_PPS_Activity activity = new ORM_CMN_STR_PPS_Activity();
                if (Parameter.AbsenceReason_RefID != Guid.Empty)
                {
                    activity.Load(Connection, Transaction, activityDetail.CMN_STR_PPS_Activity_RefID);
                    if (activity.CMN_STR_PPS_ActivityID == Guid.Empty)
                    {
                        activity.CMN_STR_PPS_ActivityID = Guid.NewGuid();
                    }
                    activity.AbsenceReason_RefID = Parameter.AbsenceReason_RefID;
                    activity.IsAbsenceActivity   = true;
                    activity.Tenant_RefID        = securityTicket.TenantID;
                    activity.Save(Connection, Transaction);
                    activityDetail.CMN_STR_PPS_Activity_RefID = activity.CMN_STR_PPS_ActivityID;
                }
                else if (activityDetail.CMN_STR_PPS_Activity_RefID != Guid.Empty)
                {
                    activity.Load(Connection, Transaction, activityDetail.CMN_STR_PPS_Activity_RefID);
                    activity.Remove(Connection, Transaction);
                }
                activityDetail.Save(Connection, Transaction);
            }
            else
            {
                ORM_CMN_STR_PPS_WorkDetail_Activity activityDetail = new ORM_CMN_STR_PPS_WorkDetail_Activity();
                activityDetail.CMN_PPS_ShiftTemplate_WorkDetail_RefID = item.CMN_PPS_ShiftTemplate_WorkDetailID;
                activityDetail.CMN_STR_PPS_Workplace_RefID            = Parameter.CMN_STR_PPS_Workplace_RefID;
                activityDetail.Tenant_RefID = securityTicket.TenantID;

                ORM_CMN_STR_PPS_Activity activity = new ORM_CMN_STR_PPS_Activity();
                if (Parameter.AbsenceReason_RefID != Guid.Empty)
                {
                    activity.AbsenceReason_RefID = Parameter.AbsenceReason_RefID;
                    activity.IsAbsenceActivity   = true;
                    activity.Tenant_RefID        = securityTicket.TenantID;
                    activity.Save(Connection, Transaction);
                    activityDetail.CMN_STR_PPS_WorkDetail_ActivityID = activity.CMN_STR_PPS_ActivityID;
                }
                activityDetail.Save(Connection, Transaction);
            }

            returnValue.Result = item.CMN_PPS_ShiftTemplate_WorkDetailID;
            //Put your code here
            return(returnValue);

            #endregion UserCode
        }
        protected static FR_L5ST_GSTWDFT_1520_Array Execute(DbConnection Connection, DbTransaction Transaction, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_L5ST_GSTWDFT_1520_Array();

            List <L5ST_GSTWDFT_1520> shiftTemplatesReturn = new List <L5ST_GSTWDFT_1520>();

            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_GSTWDFT_1520 templateItem = new L5ST_GSTWDFT_1520();
                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;

                List <L5ST_GSTWDFT_1520_Detail> returnList = new List <L5ST_GSTWDFT_1520_Detail>();

                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 = shiftTemplate.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)
                {
                    L5ST_GSTWDFT_1520_Detail shiftTemplateDetailItem = new L5ST_GSTWDFT_1520_Detail();
                    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);
                }
                templateItem.Details = returnList.ToArray();

                shiftTemplatesReturn.Add(templateItem);
            }

            returnValue.Result = shiftTemplatesReturn.ToArray();

            //Put your code here
            return(returnValue);

            #endregion UserCode
        }