protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CTPA_1225 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var diagnose_details = cls_Get_Diagnose_Details_for_DiagnoseID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1608() { DiagnoseID = Parameter.diagnose_id }, securityTicket).Result; ORM_HEC_ACT_PlannedAction treatment_planned_action = null; if (Parameter.treatment_planned_action_id != Guid.Empty) { treatment_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, HEC_ACT_PlannedActionID = Parameter.treatment_planned_action_id }).SingleOrDefault(); } if (treatment_planned_action == null) { treatment_planned_action = new ORM_HEC_ACT_PlannedAction(); treatment_planned_action.Creation_Timestamp = DateTime.Now; treatment_planned_action.HEC_ACT_PlannedActionID = Guid.NewGuid(); treatment_planned_action.IsPlannedFollowup = true; treatment_planned_action.IfPlannedFollowup_PreviousAction_RefID = Parameter.initial_performed_action_id; treatment_planned_action.IsPerformed = false; treatment_planned_action.MedicalPractice_RefID = Parameter.practice_id; treatment_planned_action.Modification_Timestamp = DateTime.Now; treatment_planned_action.Patient_RefID = Parameter.patient_id; treatment_planned_action.PlannedFor_Date = Parameter.treatment_date; treatment_planned_action.Tenant_RefID = securityTicket.TenantID; } if (Parameter.treatment_doctor_id != Guid.Empty) { var doctor_account_id = cls_Get_Doctor_AccountID_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDAIDfDID_1549() { DoctorID = Parameter.treatment_doctor_id }, securityTicket).Result.accountID; var doctor_accountQ = new ORM_USR_Account.Query(); doctor_accountQ.USR_AccountID = doctor_account_id; doctor_accountQ.Tenant_RefID = securityTicket.TenantID; doctor_accountQ.IsDeleted = false; var doctor_account = ORM_USR_Account.Query.Search(Connection, Transaction, doctor_accountQ).SingleOrDefault(); if (doctor_account != null) { treatment_planned_action.ToBePerformedBy_BusinessParticipant_RefID = doctor_account.BusinessParticipant_RefID; } } treatment_planned_action.Save(Connection, Transaction); returnValue.Result = treatment_planned_action.HEC_ACT_PlannedActionID; var treatment_planned_action_potential_procedure = ORM_HEC_ACT_PlannedAction_PotentialProcedure.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction_PotentialProcedure.Query() { PlannedAction_RefID = treatment_planned_action.HEC_ACT_PlannedActionID, PotentialProcedure_RefID = Parameter.intraocular_procedure_id, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (treatment_planned_action_potential_procedure == null) { treatment_planned_action_potential_procedure = new ORM_HEC_ACT_PlannedAction_PotentialProcedure(); treatment_planned_action_potential_procedure.Tenant_RefID = securityTicket.TenantID; treatment_planned_action_potential_procedure.PlannedAction_RefID = treatment_planned_action.HEC_ACT_PlannedActionID; treatment_planned_action_potential_procedure.PotentialProcedure_RefID = Parameter.intraocular_procedure_id; } treatment_planned_action_potential_procedure.Modification_Timestamp = DateTime.Now; treatment_planned_action_potential_procedure.Save(Connection, Transaction); var treatment_planned_action_typeQ = new ORM_HEC_ACT_ActionType.Query(); treatment_planned_action_typeQ.GlobalPropertyMatchingID = "mm.docconect.doc.app.planned.action.treatment"; treatment_planned_action_typeQ.Tenant_RefID = securityTicket.TenantID; treatment_planned_action_typeQ.IsDeleted = false; var treatment_planned_action_type = ORM_HEC_ACT_ActionType.Query.Search(Connection, Transaction, treatment_planned_action_typeQ).SingleOrDefault(); var treatment_planned_action_type_id = Guid.Empty; if (treatment_planned_action_type == null) { treatment_planned_action_type = new ORM_HEC_ACT_ActionType(); Dict action_type_name_dict = new Dict(ORM_HEC_ACT_ActionType.TableName); foreach (var lang in Parameter.all_languagesL) { var content = lang.ISO_639_1.Equals("DE") ? "behandlung" : "treatment"; action_type_name_dict.AddEntry(lang.CMN_LanguageID, content); } treatment_planned_action_type.ActionType_Name = action_type_name_dict; treatment_planned_action_type.Creation_Timestamp = DateTime.Now; treatment_planned_action_type.GlobalPropertyMatchingID = "mm.docconect.doc.app.planned.action.treatment"; treatment_planned_action_type.Modification_Timestamp = DateTime.Now; treatment_planned_action_type.HEC_ACT_ActionTypeID = Guid.NewGuid(); treatment_planned_action_type.Tenant_RefID = securityTicket.TenantID; treatment_planned_action_type.Save(Connection, Transaction); treatment_planned_action_type_id = treatment_planned_action_type.HEC_ACT_ActionTypeID; } else { treatment_planned_action_type_id = treatment_planned_action_type.HEC_ACT_ActionTypeID; } ORM_HEC_ACT_PlannedAction_2_ActionType treatment_planned_action_2_type = new ORM_HEC_ACT_PlannedAction_2_ActionType(); treatment_planned_action_2_type.Tenant_RefID = securityTicket.TenantID; treatment_planned_action_2_type.Creation_Timestamp = DateTime.Now; treatment_planned_action_2_type.IsDeleted = false; treatment_planned_action_2_type.HEC_ACT_ActionType_RefID = treatment_planned_action_type_id; treatment_planned_action_2_type.HEC_ACT_PlannedAction_RefID = treatment_planned_action.HEC_ACT_PlannedActionID; treatment_planned_action_2_type.Modification_Timestamp = DateTime.Now; treatment_planned_action_2_type.HEC_ACT_PlannedAction_2_ActionTypeID = Guid.NewGuid(); treatment_planned_action_2_type.Save(Connection, Transaction); var treatment_planned_action_required_product = ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct.Query() { BoundTo_HealthcareProcurementOrderPosition_RefID = Parameter.procurement_order_id, PlannedAction_PotentialProcedure_RefID = treatment_planned_action_potential_procedure.HEC_ACT_PlannedAction_PotentialProcedureID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (treatment_planned_action_required_product == null) { treatment_planned_action_required_product = new ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct(); treatment_planned_action_required_product.BoundTo_HealthcareProcurementOrderPosition_RefID = Parameter.procurement_order_id; treatment_planned_action_required_product.PlannedAction_PotentialProcedure_RefID = treatment_planned_action_potential_procedure.HEC_ACT_PlannedAction_PotentialProcedureID; treatment_planned_action_required_product.Tenant_RefID = securityTicket.TenantID; } treatment_planned_action_required_product.Modification_Timestamp = DateTime.Now; treatment_planned_action_required_product.HealthcareProduct_RefID = Parameter.drug_id; treatment_planned_action_required_product.Save(Connection, Transaction); #region DIAGNOSE if (Parameter.diagnose_id != Guid.Empty) { var patient_diagnosis = new ORM_HEC_Patient_Diagnosis(); patient_diagnosis.Creation_Timestamp = DateTime.Now; patient_diagnosis.HEC_Patient_DiagnosisID = Guid.NewGuid(); patient_diagnosis.Modification_Timestamp = DateTime.Now; patient_diagnosis.Patient_RefID = Parameter.patient_id; patient_diagnosis.R_IsConfirmed = Parameter.is_confirmed; patient_diagnosis.R_PotentialDiagnosis_RefID = Parameter.diagnose_id; patient_diagnosis.Tenant_RefID = securityTicket.TenantID; patient_diagnosis.Save(Connection, Transaction); ORM_HEC_DIA_Diagnosis_Localization diagnosis_localization = new ORM_HEC_DIA_Diagnosis_Localization(); diagnosis_localization.Creation_Timestamp = DateTime.Now; diagnosis_localization.Diagnosis_RefID = Parameter.diagnose_id; diagnosis_localization.HEC_DIA_Diagnosis_LocalizationID = Guid.NewGuid(); diagnosis_localization.Modification_Timestamp = DateTime.Now; diagnosis_localization.Tenant_RefID = securityTicket.TenantID; diagnosis_localization.LocalizationCode = Parameter.diagnose_id == Guid.Empty ? "-" : Parameter.is_left_eye ? "L" : "R"; diagnosis_localization.Save(Connection, Transaction); ORM_HEC_ACT_PerformedAction_DiagnosisUpdate initial_performed_action_diagnose = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate(); initial_performed_action_diagnose.Creation_Timestamp = DateTime.Now; initial_performed_action_diagnose.HEC_ACT_PerformedAction_DiagnosisUpdateID = Guid.NewGuid(); initial_performed_action_diagnose.HEC_ACT_PerformedAction_RefID = Parameter.initial_performed_action_id; initial_performed_action_diagnose.IsDiagnosisConfirmed = Parameter.is_confirmed; initial_performed_action_diagnose.Modification_Timestamp = DateTime.Now; initial_performed_action_diagnose.PotentialDiagnosis_RefID = Parameter.diagnose_id; initial_performed_action_diagnose.Tenant_RefID = securityTicket.TenantID; initial_performed_action_diagnose.HEC_Patient_Diagnosis_RefID = patient_diagnosis.HEC_Patient_DiagnosisID; initial_performed_action_diagnose.IM_PotentialDiagnosis_Code = diagnose_details.diagnose_icd_10; initial_performed_action_diagnose.IM_PotentialDiagnosis_Name = diagnose_details.diagnose_name; initial_performed_action_diagnose.IM_PotentialDiagnosisCatalog_Name = diagnose_details.catalog_display_name; initial_performed_action_diagnose.Save(Connection, Transaction); ORM_HEC_ACT_PerformedAction_DiagnosisUpdate_Localization initial_performed_action_diagnose_localization = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate_Localization(); initial_performed_action_diagnose_localization.Creation_Timestamp = DateTime.Now; initial_performed_action_diagnose_localization.HEC_ACT_PerformedAction_DiagnosisUpdate_LocalizationID = Guid.NewGuid(); initial_performed_action_diagnose_localization.HEX_EXC_Action_DiagnosisUpdate_RefID = initial_performed_action_diagnose.HEC_ACT_PerformedAction_DiagnosisUpdateID; initial_performed_action_diagnose_localization.HEC_DIA_Diagnosis_Localization_RefID = diagnosis_localization.HEC_DIA_Diagnosis_LocalizationID; initial_performed_action_diagnose_localization.Modification_Timestamp = DateTime.Now; initial_performed_action_diagnose_localization.Tenant_RefID = securityTicket.TenantID; initial_performed_action_diagnose_localization.IM_PotentialDiagnosisLocalization_Code = Parameter.diagnose_id == Guid.Empty ? "-" : Parameter.is_left_eye ? "L" : "R"; initial_performed_action_diagnose_localization.Save(Connection, Transaction); ORM_HEC_Patient_Diagnosis_Localization patient_diagnosis_localization = new ORM_HEC_Patient_Diagnosis_Localization(); patient_diagnosis_localization.Creation_Timestamp = DateTime.Now; patient_diagnosis_localization.DIA_Diagnosis_Localization_RefID = diagnosis_localization.HEC_DIA_Diagnosis_LocalizationID; patient_diagnosis_localization.HEC_Patient_Diagnosis_LocalizationID = Guid.NewGuid(); patient_diagnosis_localization.Patient_Diagnosis_RefID = patient_diagnosis.HEC_Patient_DiagnosisID; patient_diagnosis_localization.Tenant_RefID = securityTicket.TenantID; patient_diagnosis_localization.Save(Connection, Transaction); } #endregion return(returnValue); #endregion UserCode }
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5PA_SPED_1313 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Bool(); returnValue.Result = false; P_L2LN_GALFTID_1530 langParam = new P_L2LN_GALFTID_1530(); langParam.Tenant_RefID = securityTicket.TenantID; var DBLanguages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, langParam, securityTicket).Result; var medPro_Credentials = cls_Get_TenantMemershipData.Invoke(Connection, Transaction, securityTicket).Result; var examination = ORM_HEC_ACT_PerformedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PerformedAction.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, HEC_ACT_PerformedActionID = Parameter.ExaminationID }).Single(); #region save foreach (var item in Parameter.newDiagnoses) { if (medPro_Credentials.Credantial != null) { var potentialDiagnosisQuery = new ORM_HEC_DIA_PotentialDiagnosis.Query(); potentialDiagnosisQuery.IsDeleted = false; potentialDiagnosisQuery.Tenant_RefID = securityTicket.TenantID; potentialDiagnosisQuery.PotentialDiagnosisITL = item.DiagnoseITL; var potentialDiagnosis = ORM_HEC_DIA_PotentialDiagnosis.Query.Search(Connection, Transaction, potentialDiagnosisQuery).SingleOrDefault(); if (potentialDiagnosis == null) { potentialDiagnosis = new ORM_HEC_DIA_PotentialDiagnosis(); potentialDiagnosis.HEC_DIA_PotentialDiagnosisID = Guid.NewGuid(); potentialDiagnosis.ICD10_Code = item.DiagnoseICD10; Dict name = new Dict("hec_dia_potentialdiagnoses"); for (int i = 0; i < DBLanguages.Length; i++) { name.AddEntry(DBLanguages[i].CMN_LanguageID, item.DiagnoseName); } potentialDiagnosis.PotentialDiagnosis_Name = name; potentialDiagnosis.PotentialDiagnosisITL = item.DiagnoseITL; potentialDiagnosis.Tenant_RefID = securityTicket.TenantID; potentialDiagnosis.Creation_Timestamp = DateTime.Now; potentialDiagnosis.Modification_Timestamp = DateTime.Now; potentialDiagnosis.Save(Connection, Transaction); } //check if exists active patient diagnoses (same one) var patientDiagQuery = new ORM_HEC_Patient_Diagnosis.Query(); patientDiagQuery.IsDeleted = false; patientDiagQuery.Tenant_RefID = securityTicket.TenantID; patientDiagQuery.R_IsActive = true; patientDiagQuery.R_PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; patientDiagQuery.Patient_RefID = Parameter.PatientID; var patientDiagExists = ORM_HEC_Patient_Diagnosis.Query.Search(Connection, Transaction, patientDiagQuery).SingleOrDefault(); if (patientDiagExists == null) { ORM_HEC_Patient_Diagnosis patientDiagnoses = new ORM_HEC_Patient_Diagnosis(); patientDiagnoses.HEC_Patient_DiagnosisID = Guid.NewGuid(); patientDiagnoses.Creation_Timestamp = DateTime.Now; patientDiagnoses.Modification_Timestamp = DateTime.Now; patientDiagnoses.R_IsActive = true; patientDiagnoses.Patient_RefID = Parameter.PatientID; patientDiagnoses.Tenant_RefID = securityTicket.TenantID; patientDiagnoses.R_DiagnosedOnDate = examination.IfPerfomed_DateOfAction; patientDiagnoses.R_ScheduledExpiryDate = patientDiagnoses.R_DiagnosedOnDate.AddDays(item.days_valid); patientDiagnoses.R_PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; patientDiagnoses.Save(Connection, Transaction); ORM_HEC_ACT_PerformedAction_DiagnosisUpdate diagnosisUpdate = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate(); diagnosisUpdate.HEC_ACT_PerformedAction_DiagnosisUpdateID = Guid.NewGuid(); diagnosisUpdate.Creation_Timestamp = DateTime.Now; diagnosisUpdate.Modification_Timestamp = DateTime.Now; diagnosisUpdate.Tenant_RefID = securityTicket.TenantID; diagnosisUpdate.ScheduledExpiryDate = DateTime.Now.AddDays(item.days_valid); diagnosisUpdate.PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; diagnosisUpdate.HEC_Patient_Diagnosis_RefID = patientDiagnoses.HEC_Patient_DiagnosisID; diagnosisUpdate.HEC_ACT_PerformedAction_RefID = Parameter.ExaminationID; diagnosisUpdate.Save(Connection, Transaction); } } else { var potentialDiagnosisQuery = new ORM_HEC_DIA_PotentialDiagnosis.Query(); potentialDiagnosisQuery.IsDeleted = false; potentialDiagnosisQuery.Tenant_RefID = securityTicket.TenantID; potentialDiagnosisQuery.HEC_DIA_PotentialDiagnosisID = new Guid(item.DiagnoseITL); var potentialDiagnosis = ORM_HEC_DIA_PotentialDiagnosis.Query.Search(Connection, Transaction, potentialDiagnosisQuery).SingleOrDefault(); //check if exists active patient diagnoses (same one) var patientDiagQuery = new ORM_HEC_Patient_Diagnosis.Query(); patientDiagQuery.IsDeleted = false; patientDiagQuery.Tenant_RefID = securityTicket.TenantID; patientDiagQuery.R_IsActive = true; patientDiagQuery.R_PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; var patientDiagExists = ORM_HEC_Patient_Diagnosis.Query.Search(Connection, Transaction, patientDiagQuery).SingleOrDefault(); if (patientDiagExists == null) { ORM_HEC_Patient_Diagnosis patientDiagnoses = new ORM_HEC_Patient_Diagnosis(); patientDiagnoses.HEC_Patient_DiagnosisID = Guid.NewGuid(); patientDiagnoses.Creation_Timestamp = DateTime.Now; patientDiagnoses.Modification_Timestamp = DateTime.Now; patientDiagnoses.R_IsActive = true; patientDiagnoses.Patient_RefID = Parameter.PatientID; patientDiagnoses.Tenant_RefID = securityTicket.TenantID; patientDiagnoses.R_DiagnosedOnDate = DateTime.Now; patientDiagnoses.R_ScheduledExpiryDate = DateTime.Now.AddDays(item.days_valid); patientDiagnoses.R_PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; patientDiagnoses.Save(Connection, Transaction); ORM_HEC_ACT_PerformedAction_DiagnosisUpdate diagnosisUpdate = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate(); diagnosisUpdate.HEC_ACT_PerformedAction_DiagnosisUpdateID = Guid.NewGuid(); diagnosisUpdate.Creation_Timestamp = DateTime.Now; diagnosisUpdate.Modification_Timestamp = DateTime.Now; diagnosisUpdate.Tenant_RefID = securityTicket.TenantID; diagnosisUpdate.ScheduledExpiryDate = DateTime.Now.AddDays(item.days_valid); diagnosisUpdate.PotentialDiagnosis_RefID = potentialDiagnosis.HEC_DIA_PotentialDiagnosisID; diagnosisUpdate.HEC_Patient_Diagnosis_RefID = patientDiagnoses.HEC_Patient_DiagnosisID; diagnosisUpdate.HEC_ACT_PerformedAction_RefID = Parameter.ExaminationID; diagnosisUpdate.Save(Connection, Transaction); } } } #endregion #region negated foreach (var item in Parameter.deletedDiagnoses) { var patientDiagnosesQuery = new ORM_HEC_Patient_Diagnosis.Query(); patientDiagnosesQuery.IsDeleted = false; patientDiagnosesQuery.R_IsNegated = false; patientDiagnosesQuery.R_IsActive = true; patientDiagnosesQuery.Tenant_RefID = securityTicket.TenantID; patientDiagnosesQuery.HEC_Patient_DiagnosisID = item.PatientDiagnoseID; var patientDiagnoses = ORM_HEC_Patient_Diagnosis.Query.Search(Connection, Transaction, patientDiagnosesQuery).Single(); patientDiagnoses.R_IsNegated = true; patientDiagnoses.R_IsActive = false; patientDiagnoses.Save(Connection, Transaction); var diagnoseUpdateQuery = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate.Query(); diagnoseUpdateQuery.HEC_Patient_Diagnosis_RefID = item.PatientDiagnoseID; diagnoseUpdateQuery.IsDeleted = false; diagnoseUpdateQuery.IsDiagnosisNegated = false; diagnoseUpdateQuery.Tenant_RefID = securityTicket.TenantID; var patientUpdate = ORM_HEC_ACT_PerformedAction_DiagnosisUpdate.Query.Search(Connection, Transaction, diagnoseUpdateQuery).Single(); patientUpdate.IsDiagnosisNegated = true; patientUpdate.Save(Connection, Transaction); } returnValue.Result = true; #endregion return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5DG_SDfP_17_02 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); #region New for (int i = 0; i < Parameter.PatientDiagnosis.Length; i++) { ORM_HEC_Patient_Diagnosis item = new ORM_HEC_Patient_Diagnosis(); ORM_HEC_Patient_Diagnosis_Localization localization = new ORM_HEC_Patient_Diagnosis_Localization(); if (Parameter.PatientDiagnosis[i].HEC_Patient_DiagnosesID != Guid.Empty) { var result = item.Load(Connection, Transaction, Parameter.PatientDiagnosis[i].HEC_Patient_DiagnosesID); if (result.Status != FR_Status.Success || item.HEC_Patient_DiagnosisID == Guid.Empty) { if (item.IsDeleted) { continue; } Guid PatientID = Guid.NewGuid(); item.HEC_Patient_DiagnosisID = PatientID; item.Patient_RefID = Parameter.PatientDiagnosis[i].PatientID; //item.Doctor_RefID = Parameter.PatientDiagnosis[i].Doctor_RefID; //item.DIA_PotentialDiagnosis_RefID = Parameter.PatientDiagnosis[i].DIA_PotentialDiagnosis_RefID; //item.DIA_State_RefID = Parameter.PatientDiagnosis[i].DIA_State_RefID; //item.PatientDiagnosis_Comment = Parameter.PatientDiagnosis[i].RelevantDiagnosis_Comment; item.Creation_Timestamp = DateTime.Now; // item.DiagnosedOnDate = Parameter.PatientDiagnosis[i].CreationTime; item.IsDeleted = false; item.Tenant_RefID = securityTicket.TenantID; localization.HEC_Patient_Diagnosis_LocalizationID = Guid.NewGuid(); localization.HEC_Patient_Diagnosis_RefID = PatientID; localization.HEC_DIA_Diagnosis_Localization_RefID = Parameter.PatientDiagnosis[i].DIA_Localization_RefID; localization.Tenant_RefID = securityTicket.TenantID; localization.Creation_Timestamp = DateTime.Now; item.Save(Connection, Transaction); localization.Save(Connection, Transaction); } #endregion else { if (Parameter.PatientDiagnosis[i].IsDeleted == true) { item.IsDeleted = true; item.Save(Connection, Transaction); } else { item.Patient_RefID = Parameter.PatientDiagnosis[i].PatientID; // item.Doctor_RefID = Parameter.PatientDiagnosis[i].Doctor_RefID; // item.DIA_PotentialDiagnosis_RefID = Parameter.PatientDiagnosis[i].DIA_PotentialDiagnosis_RefID; // item.DIA_State_RefID = Parameter.PatientDiagnosis[i].DIA_State_RefID; // item.PatientDiagnosis_Comment = Parameter.PatientDiagnosis[i].RelevantDiagnosis_Comment; item.Creation_Timestamp = DateTime.Now; //item.DiagnosedOnDate = Parameter.PatientDiagnosis[i].CreationTime; item.IsDeleted = false; item.Tenant_RefID = securityTicket.TenantID; var query = new ORM_HEC_Patient_Diagnosis_Localization.Query(); query.HEC_Patient_Diagnosis_RefID = Parameter.PatientDiagnosis[i].HEC_Patient_DiagnosesID; var local = ORM_HEC_Patient_Diagnosis_Localization.Query.Search(Connection, Transaction, query); if (local.Count > 0) { local[0].HEC_Patient_Diagnosis_LocalizationID = Parameter.PatientDiagnosis[i].DIA_Localization_RefID; local[0].Save(Connection, Transaction); } item.Save(Connection, Transaction); } } } } return(returnValue); #endregion UserCode }