protected static FR_L5EX_GAPDDOI_1644 Execute(DbConnection Connection, DbTransaction Transaction, P_L5EX_GAPDDOI_1644 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
        {
            #region UserCode
            var returnValue = new FR_L5EX_GAPDDOI_1644();
            returnValue.Result = new L5EX_GAPDDOI_1644();
            List <L5EX_GAPDDOI_1644_patient_diagnoses> patient_diagnoses = new List <L5EX_GAPDDOI_1644_patient_diagnoses>();
            returnValue.Result.patient_diagnoses = patient_diagnoses.ToArray();

            returnValue.Result.diagnoses = cls_Get_Diagnoses_Elasticc.Invoke(Connection, Transaction, new P_L5MPC_GDE_1412
            {
                number_of_elements = Parameter.number_of_elements,
                search_params      = Parameter.search_params,
                sort_by            = Parameter.sort_by,
                sort_order         = Parameter.sort_order,
                start_row_index    = Parameter.start_row_index
            }, securityTicket).Result;

            var patient_diagnoses_list = cls_Get_Examination_Diagnoses.Invoke(Connection, Transaction, new P_L5EX_GED_1640 {
                ExaminationID = Parameter.ExaminationID,
                PatientID     = Parameter.PatientID
            }, securityTicket).Result.ToList();

            foreach (var item in patient_diagnoses_list)
            {
                int days_active = 0;
                if (item.R_ScheduledExpiryDate > DateTime.Now)
                {
                    TimeSpan span = item.R_ScheduledExpiryDate.Subtract(DateTime.Now);
                    days_active = span.Days;
                }

                L5EX_GAPDDOI_1644_patient_diagnoses diagnose = new L5EX_GAPDDOI_1644_patient_diagnoses();
                diagnose.date        = item.R_ScheduledExpiryDate.ToShortDateString();
                diagnose.days_active = days_active.ToString();
                diagnose.icd_10      = item.ICD10_Code;
                diagnose.id          = item.HEC_Patient_DiagnosisID.ToString();
                diagnose.itl         = item.PotentialDiagnosisITL.ToString();
                diagnose.name        = item.PotentialDiagnosis_Name.Contents[0].Content;
                patient_diagnoses.Add(diagnose);
            }

            returnValue.Result.patient_diagnoses = patient_diagnoses.ToArray();
            return(returnValue);

            #endregion UserCode
        }