///<summary> /// Method Invocation of wrapper classes ///<summary> protected static FR_L5EX_GAPDDOI_1644 Invoke(DbConnection Connection, DbTransaction Transaction, string ConnectionString, P_L5EX_GAPDDOI_1644 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { bool cleanupConnection = Connection == null; bool cleanupTransaction = Transaction == null; FR_L5EX_GAPDDOI_1644 functionReturn = new FR_L5EX_GAPDDOI_1644(); try { if (cleanupConnection == true) { Connection = CSV2Core_MySQL.Support.DBSQLSupport.CreateConnection(ConnectionString); Connection.Open(); } if (cleanupTransaction == true) { Transaction = Connection.BeginTransaction(); } functionReturn = Execute(Connection, Transaction, Parameter, securityTicket); #region Cleanup Connection/Transaction //Commit the transaction if (cleanupTransaction == true) { Transaction.Commit(); } //Close the connection if (cleanupConnection == true) { Connection.Close(); } #endregion } catch (Exception ex) { try { if (cleanupTransaction == true && Transaction != null) { Transaction.Rollback(); } } catch { } try { if (cleanupConnection == true && Connection != null) { Connection.Close(); } } catch { } throw ex; } return(functionReturn); }
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 }