protected static FR_CAS_SPE_1805 Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_SPE_1805 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_CAS_SPE_1805();
returnValue.Result = new CAS_SPE_1805();
//Put your code here
var case_id = Parameter.case_id;
#region DATA
var patient_details = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPDfPID_1124()
{
PatientID = Parameter.patient_id
}, securityTicket).Result;
if (patient_details == null)
{
throw new Exception("Patient details not found for ID: " + Parameter.patient_id);
}
var doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
Tenant_RefID = securityTicket.TenantID, HEC_DoctorID = Parameter.doctor_id, IsDeleted = false
}).SingleOrDefault();
if (doctor == null)
{
throw new Exception("Doctor not found for ID: " + Parameter.doctor_id);
}
var doctor_details = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = Parameter.doctor_id
}, securityTicket).Result.FirstOrDefault();
if (doctor_details == null)
{
throw new Exception("Doctor details not found for ID: " + Parameter.doctor_id);
}
var practice_details = cls_Get_Practice_Details_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPDfPID_1432()
{
PracticeID = doctor_details.practice_id
}, securityTicket).Result.FirstOrDefault();
if (practice_details == null)
{
throw new Exception("Practice details not found for ID: " + doctor_details.practice_id);
}
var shouldDownloadReportProperty = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916()
{
PracticeID = doctor_details.practice_id, PropertyName = "Download Report Upon Submission"
}, securityTicket).Result;
var shouldDownloadReport = shouldDownloadReportProperty == null ? false : shouldDownloadReportProperty.BooleanValue;
ORM_USR_Account.Query trigger_accQ = new ORM_USR_Account.Query();
trigger_accQ.Tenant_RefID = securityTicket.TenantID;
trigger_accQ.USR_AccountID = securityTicket.AccountID;
trigger_accQ.IsDeleted = false;
ORM_USR_Account trigger_acc = ORM_USR_Account.Query.Search(Connection, Transaction, trigger_accQ).Single();
ORM_CMN_Language.Query all_languagesQ = new ORM_CMN_Language.Query();
all_languagesQ.Tenant_RefID = securityTicket.TenantID;
all_languagesQ.IsDeleted = false;
var all_languagesL = ORM_CMN_Language.Query.Search(Connection, Transaction, all_languagesQ).ToArray();
var intraocular_procedure_id = Guid.Empty;
#endregion
if (!Parameter.isResubmit)
{
#region NEW CASE
ORM_HEC_CAS_Case new_case = new ORM_HEC_CAS_Case();
new_case.HEC_CAS_CaseID = Guid.NewGuid();
new_case.Creation_Timestamp = DateTime.Now;
new_case.CreatedBy_BusinessParticipant_RefID = trigger_acc.BusinessParticipant_RefID;
new_case.Patient_RefID = Parameter.patient_id;
new_case.Patient_FirstName = patient_details.patient_first_name;
new_case.Patient_LastName = patient_details.patient_last_name;
new_case.Patient_Gender = patient_details.gender;
new_case.Patient_BirthDate = patient_details.birthday;
new_case.CaseNumber = cls_Get_Next_Case_Number.Invoke(Connection, Transaction, securityTicket).Result.case_number;
new_case.Modification_Timestamp = DateTime.Now;
DateTime today = DateTime.Today;
int age = today.Year - patient_details.birthday.Year;
if (patient_details.birthday > today.AddYears(-age))
{
age--;
}
new_case.Patient_Age = age;
new_case.Tenant_RefID = securityTicket.TenantID;
new_case.Save(Connection, Transaction);
case_id = new_case.HEC_CAS_CaseID;
#endregion NEW CASE
#region INITIAL PERFORMED ACTION
var initial_performed_action_id = cls_Create_Initial_Performed_Action.Invoke(Connection, Transaction, new P_CAS_CIPA_1140()
{
all_languagesL = all_languagesL,
case_id = new_case.HEC_CAS_CaseID,
created_by_bpt = trigger_acc.BusinessParticipant_RefID,
patient_id = Parameter.patient_id,
practice_id = doctor_details.practice_id,
action_type_gpmid = "mm.docconect.doc.app.performed.action.preexamination"
}, securityTicket).Result;
#endregion INITIAL PERFORMED ACTION
#region LOCALIZATION
ORM_HEC_DIA_Diagnosis_Localization diagnosis_localization = new ORM_HEC_DIA_Diagnosis_Localization();
diagnosis_localization.Modification_Timestamp = DateTime.Now;
diagnosis_localization.Tenant_RefID = securityTicket.TenantID;
diagnosis_localization.LocalizationCode = Parameter.localization;
diagnosis_localization.Save(Connection, Transaction);
ORM_HEC_ACT_PerformedAction_DiagnosisUpdate initial_performed_action_diagnose = new ORM_HEC_ACT_PerformedAction_DiagnosisUpdate();
initial_performed_action_diagnose.HEC_ACT_PerformedAction_RefID = initial_performed_action_id;
initial_performed_action_diagnose.Modification_Timestamp = DateTime.Now;
initial_performed_action_diagnose.Tenant_RefID = securityTicket.TenantID;
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.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.localization;
initial_performed_action_diagnose_localization.Save(Connection, Transaction);
#endregion
#region PLANNED ACTION
var action_gpmid = "mm.docconect.doc.app.planned.action.preexamination";
var planned_action_type = ORM_HEC_ACT_ActionType.Query.Search(Connection, Transaction, new ORM_HEC_ACT_ActionType.Query()
{
GlobalPropertyMatchingID = action_gpmid,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (planned_action_type == null)
{
planned_action_type = new ORM_HEC_ACT_ActionType();
planned_action_type.GlobalPropertyMatchingID = action_gpmid;
planned_action_type.Modification_Timestamp = DateTime.Now;
planned_action_type.Tenant_RefID = securityTicket.TenantID;
planned_action_type.Save(Connection, Transaction);
}
// circular reference to same performed action in order to be compatible with treatment planned actions,
// so that it can be accessed in the same way
var preexamination_planned_action = new ORM_HEC_ACT_PlannedAction();
preexamination_planned_action.IfPlannedFollowup_PreviousAction_RefID = initial_performed_action_id;
preexamination_planned_action.IsPerformed = true;
preexamination_planned_action.IfPerformed_PerformedAction_RefID = initial_performed_action_id;
preexamination_planned_action.MedicalPractice_RefID = doctor_details.practice_id;
preexamination_planned_action.Modification_Timestamp = DateTime.Now;
preexamination_planned_action.Patient_RefID = Parameter.patient_id;
preexamination_planned_action.PlannedFor_Date = Parameter.date;
preexamination_planned_action.ToBePerformedBy_BusinessParticipant_RefID = doctor.BusinessParticipant_RefID;
preexamination_planned_action.Tenant_RefID = securityTicket.TenantID;
preexamination_planned_action.Save(Connection, Transaction);
var action_to_type = new ORM_HEC_ACT_PlannedAction_2_ActionType();
action_to_type.HEC_ACT_ActionType_RefID = planned_action_type.HEC_ACT_ActionTypeID;
action_to_type.HEC_ACT_PlannedAction_RefID = preexamination_planned_action.HEC_ACT_PlannedActionID;
action_to_type.Modification_Timestamp = DateTime.Now;
action_to_type.Tenant_RefID = securityTicket.TenantID;
action_to_type.Save(Connection, Transaction);
#endregion
#region GPOS
var patient_consent = ORM_HEC_CRT_InsuranceToBrokerContract_ParticipatingPatient.Query.Search(Connection, Transaction, new ORM_HEC_CRT_InsuranceToBrokerContract_ParticipatingPatient.Query()
{
Patient_RefID = Parameter.patient_id,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Where(t =>
{
var ctrParameter = cls_Get_Contract_Parameter_Value_for_InsuranceToBrokerContractID.Invoke(Connection, Transaction, new P_MD_GCPVfITBCID_1647()
{
ParameterName = "Duration of participation consent – Month",
InsuranceToBrokerContractID = t.InsuranceToBrokerContract_RefID
}, securityTicket).Result;
var validThrough = ctrParameter == null || ctrParameter.ConsentValidForMonths == double.MaxValue ? DateTime.MaxValue : t.ValidFrom.AddMonths(Convert.ToInt32(ctrParameter.ConsentValidForMonths));
return(t.ValidFrom <= Parameter.date && validThrough >= Parameter.date);
}).OrderBy(t => t.ValidFrom).FirstOrDefault();
if (patient_consent == null)
{
throw new Exception("No patients consents found for selected date: " + Parameter.date.ToString("dd.MM.yyyy") + " and patient id: " + Parameter.patient_id);
}
var gpos_gpmid = "mm.docconnect.gpos.catalog.voruntersuchung";
var preexamination_gpos_catalog = ORM_HEC_BIL_PotentialCode_Catalog.Query.Search(Connection, Transaction, new ORM_HEC_BIL_PotentialCode_Catalog.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
GlobalPropertyMatchingID = gpos_gpmid
}).SingleOrDefault();
if (preexamination_gpos_catalog == null)
{
throw new Exception("Preexamination catalog not found.");
}
var gpos_connections_to_drugs = ORM_HEC_BIL_PotentialCode_2_HealthcareProduct.Query.Search(Connection, Transaction, new ORM_HEC_BIL_PotentialCode_2_HealthcareProduct.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).GroupBy(t => t.HEC_BIL_PotentialCode_RefID);
var gpos_connections_to_diagnoses = ORM_HEC_BIL_PotentialCode_2_PotentialDiagnosis.Query.Search(Connection, Transaction, new ORM_HEC_BIL_PotentialCode_2_PotentialDiagnosis.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).GroupBy(t => t.HEC_BIL_PotentialCode_RefID);
var preexamination_gposes = ORM_HEC_BIL_PotentialCode.Query.Search(Connection, Transaction, new ORM_HEC_BIL_PotentialCode.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
PotentialCode_Catalog_RefID = preexamination_gpos_catalog.HEC_BIL_PotentialCode_CatalogID
});
var covered_gposes = ORM_HEC_CTR_InsuranceToBrokerContracts_CoveredPotentialBillCode.Query.Search(Connection, Transaction, new ORM_HEC_CTR_InsuranceToBrokerContracts_CoveredPotentialBillCode.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
InsuranceToBrokerContract_RefID = patient_consent.InsuranceToBrokerContract_RefID
});
preexamination_gposes = preexamination_gposes.Where(t => covered_gposes.Any(c => c.PotentialBillCode_RefID == t.HEC_BIL_PotentialCodeID)).ToList();
var bill_header = new ORM_BIL_BillHeader();
bill_header.Modification_Timestamp = DateTime.Now;
bill_header.Tenant_RefID = securityTicket.TenantID;
foreach (var gpos in preexamination_gposes)
{
if (!gpos_connections_to_diagnoses.Any(t => t.Key == gpos.HEC_BIL_PotentialCodeID) && !gpos_connections_to_drugs.Any(t => t.Key == gpos.HEC_BIL_PotentialCodeID))
{
var price_value = ORM_CMN_Price_Value.Query.Search(Connection, Transaction, new ORM_CMN_Price_Value.Query()
{
Price_RefID = gpos.Price_RefID, IsDeleted = false, Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (price_value == null)
{
throw new Exception("Price value not found for GPOS: " + gpos.BillingCode);
}
ORM_BIL_BillPosition gpos_position = new ORM_BIL_BillPosition();
gpos_position.BIL_BilHeader_RefID = bill_header.BIL_BillHeaderID;
gpos_position.Modification_Timestamp = DateTime.Now;
gpos_position.Tenant_RefID = securityTicket.TenantID;
gpos_position.PositionValue_IncludingTax = Convert.ToDecimal(price_value.PriceValue_Amount);
gpos_position.PositionNumber = cls_Get_Next_Bill_Position_Number.Invoke(Connection, Transaction, securityTicket).Result.bill_position_number;
gpos_position.Save(Connection, Transaction);
ORM_BIL_BillPosition_TransmitionStatus fs_status = new ORM_BIL_BillPosition_TransmitionStatus();
fs_status.BillPosition_RefID = gpos_position.BIL_BillPositionID;
fs_status.IsActive = true;
fs_status.Modification_Timestamp = DateTime.Now;
fs_status.Tenant_RefID = securityTicket.TenantID;
fs_status.TransmitionCode = 1;
fs_status.TransmitionStatusKey = "preexamination";
fs_status.TransmittedOnDate = DateTime.Now;
fs_status.Save(Connection, Transaction);
ORM_HEC_BIL_BillPosition hec_gpos_position = new ORM_HEC_BIL_BillPosition();
hec_gpos_position.Ext_BIL_BillPosition_RefID = gpos_position.BIL_BillPositionID;
hec_gpos_position.Modification_Timestamp = DateTime.Now;
hec_gpos_position.Tenant_RefID = securityTicket.TenantID;
hec_gpos_position.PositionFor_Patient_RefID = Parameter.patient_id;
hec_gpos_position.Save(Connection, Transaction);
ORM_HEC_BIL_BillPosition_BillCode hec_gpos_position_code = new ORM_HEC_BIL_BillPosition_BillCode();
hec_gpos_position_code.BillPosition_RefID = hec_gpos_position.HEC_BIL_BillPositionID;
hec_gpos_position_code.IM_BillingCode = gpos.BillingCode;
hec_gpos_position_code.Modification_Timestamp = DateTime.Now;
hec_gpos_position_code.PotentialCode_RefID = gpos.HEC_BIL_PotentialCodeID;
hec_gpos_position_code.Tenant_RefID = securityTicket.TenantID;
hec_gpos_position_code.Save(Connection, Transaction);
ORM_HEC_CAS_Case_BillCode hec_gpos_case_code = new ORM_HEC_CAS_Case_BillCode();
hec_gpos_case_code.HEC_BIL_BillPosition_BillCode_RefID = hec_gpos_position_code.HEC_BIL_BillPosition_BillCodeID;
hec_gpos_case_code.HEC_CAS_Case_RefID = new_case.HEC_CAS_CaseID;
hec_gpos_case_code.Modification_Timestamp = DateTime.Now;
hec_gpos_case_code.Tenant_RefID = securityTicket.TenantID;
hec_gpos_case_code.Save(Connection, Transaction);
ORM_BIL_BillPosition_PropertyValue gpos_management_fee_property_value = new ORM_BIL_BillPosition_PropertyValue();
gpos_management_fee_property_value.BIL_BillPosition_RefID = gpos_position.BIL_BillPositionID;
gpos_management_fee_property_value.BIL_BillPosition_PropertyValueID = Guid.NewGuid();
gpos_management_fee_property_value.Creation_Timestamp = DateTime.Now;
gpos_management_fee_property_value.Modification_Timestamp = DateTime.Now;
gpos_management_fee_property_value.PropertyKey = "mm.doc.connect.management.fee";
gpos_management_fee_property_value.PropertyValue = "waived";
gpos_management_fee_property_value.Tenant_RefID = securityTicket.TenantID;
gpos_management_fee_property_value.Save(Connection, Transaction);
bill_header.TotalValue_IncludingTax += Convert.ToDecimal(price_value.PriceValue_Amount);
}
}
bill_header.Save(Connection, Transaction);
#endregion
}
return(returnValue);
#endregion UserCode
}
public string GetResponseFromHIP(Guid case_id, Guid planned_action_id, string connectionString, string sessionTicket, out TransactionalInformation transaction)
{
var method = MethodInfo.GetCurrentMethod();
var ipInfo = Util.GetIPInfo(HttpContext.Current.Request);
transaction = new TransactionalInformation();
string response = "";
var securityTicket = VerifySessionToken(sessionTicket);
try
{
using (var dbConnection = DBSQLSupport.CreateConnection(connectionString))
{
dbConnection.Open();
var dbTransaction = dbConnection.BeginTransaction();
var action_gpmid = cls_Get_PlannedActionType_GlobalPropertyMatchingID_for_PlannedActionID.Invoke(dbConnection, dbTransaction, new P_CAS_GPAGPMIDfPAID_1652()
{
PlannedActionID = planned_action_id
}, securityTicket).Result.GlobalPropertyMatchingID;
if (action_gpmid == EActionType.PlannedOct.Value())
{
var relevant_action = ORM_HEC_CAS_Case_RelevantPlannedAction.Query.Search(dbConnection, dbTransaction, new ORM_HEC_CAS_Case_RelevantPlannedAction.Query()
{
PlannedAction_RefID = planned_action_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
if (relevant_action.Case_RefID != case_id)
{
case_id = relevant_action.Case_RefID;
}
var relevant_case = new ORM_HEC_CAS_Case();
relevant_case.Load(dbConnection, dbTransaction, case_id);
var oct_planned_action_type_id = cls_Get_ActionTypeID.Invoke(dbConnection, dbTransaction, new P_CAS_GATID_1514()
{
action_type_gpmid = EActionType.PlannedOct.Value()
}, securityTicket).Result;
var case_relevant_actions = cls_Get_PlannedActionIDs_for_PatientID_and_ActionTypeID.Invoke(dbConnection, dbTransaction, new P_CAS_GPAIDsfPIDaATID_1705()
{
ActionTypeID = oct_planned_action_type_id,
PatientID = relevant_case.Patient_RefID
}, securityTicket).Result.Where(t => t.performed).ToList();
var case_bill_positions = cls_Get_BillPositionIDs_for_PatientID_and_GposType.Invoke(dbConnection, dbTransaction, new P_CAS_GBPIDsfPIDaGposT_1709()
{
PatientID = relevant_case.Patient_RefID,
GposType = EGposType.Oct.Value()
}, securityTicket).Result.Where(t => t.status_id != Guid.Empty).ToList();
var bill_position_id = Guid.Empty;
for (var i = 0; i < case_relevant_actions.Count; i++)
{
if (case_relevant_actions[i].action_id == planned_action_id)
{
bill_position_id = case_bill_positions[i].bill_position_id;
break;
}
}
if (bill_position_id == Guid.Empty)
{
throw new ArgumentException(String.Format("No bill position found for case: {0} and planned action id: {1}", case_id, planned_action_id));
}
var transmition_status = ORM_BIL_BillPosition_TransmitionStatus.Query.Search(dbConnection, dbTransaction, new ORM_BIL_BillPosition_TransmitionStatus.Query()
{
BillPosition_RefID = bill_position_id,
IsActive = true,
TransmitionCode = 5,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
response = transmition_status.PrimaryComment;
}
else
{
var response_from_hip = cls_Get_Response_from_HIP_and_Comment_for_Doctor_for_CaseID.Invoke(connectionString, new P_CAS_GRfHIPaCfDfCID_1537()
{
CaseID = case_id,
StatusKey = action_gpmid.Replace("mm.docconect.doc.app.planned.action.", ""),
StatusCode = 5
}, securityTicket).Result;
response = response_from_hip != null ? response_from_hip.response_from_hip : "";
}
}
}
catch (Exception ex)
{
Logger.LogInfo(new LogEntry(ipInfo.address, ipInfo.agent, connectionString, method, securityTicket, ex));
transaction.ReturnMessage = new List <string>();
string errorMessage = ex.Message;
transaction.ReturnStatus = false;
transaction.ReturnMessage.Add(errorMessage);
transaction.IsAuthenicated = true;
transaction.IsException = true;
}
return(response);
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_SC_1711 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_CMN_Language.Query all_languagesQ = new ORM_CMN_Language.Query();
all_languagesQ.Tenant_RefID = securityTicket.TenantID;
all_languagesQ.IsDeleted = false;
var all_languagesL = ORM_CMN_Language.Query.Search(Connection, Transaction, all_languagesQ).ToArray();
var intraocular_procedure_id = Guid.Empty;
var treatment_doctor_details = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = Parameter.treatment_doctor_id
}, securityTicket).Result.SingleOrDefault();
var patient_details = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_PA_GPDfPID_1729()
{
PatientID = Parameter.patient_id
}, securityTicket).Result;
var diagnose_details = cls_Get_Diagnose_Details_for_DiagnoseID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1357()
{
DiagnoseID = Parameter.diagnose_id
}, securityTicket).Result;
var drug_details = cls_Get_Drug_Details_for_DrugID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1614()
{
DrugID = Parameter.drug_id
}, securityTicket).Result;
#region NEW CASE
ORM_HEC_CAS_Case new_case = new ORM_HEC_CAS_Case();
new_case.HEC_CAS_CaseID = Guid.NewGuid();
new_case.Creation_Timestamp = DateTime.Now;
new_case.Patient_RefID = Parameter.patient_id;
new_case.Patient_FirstName = patient_details.patient_first_name;
new_case.Patient_LastName = patient_details.patient_last_name;
new_case.Patient_Gender = patient_details.gender;
new_case.Patient_BirthDate = patient_details.birthday;
new_case.CaseNumber = cls_Get_Next_Case_Number.Invoke(Connection, Transaction, securityTicket).Result.case_number;
new_case.Modification_Timestamp = DateTime.Now;
DateTime today = DateTime.Today;
int age = today.Year - patient_details.birthday.Year;
if (patient_details.birthday > today.AddYears(-age))
{
age--;
}
new_case.Patient_Age = age;
new_case.Tenant_RefID = securityTicket.TenantID;
new_case.Save(Connection, Transaction);
returnValue.Result = new_case.HEC_CAS_CaseID;
#endregion NEW CASE
#region INITIAL PERFORMED ACTION
var initial_performed_action_id = cls_Create_Initial_Performed_Action.Invoke(Connection, Transaction, new P_CAS_CIPA_1140()
{
all_languagesL = all_languagesL,
case_id = new_case.HEC_CAS_CaseID,
patient_id = Parameter.patient_id,
practice_id = Parameter.practice_id
}, securityTicket).Result;
#endregion INITIAL PERFORMED ACTION
#region POTENTIAL PROCEDURE
ORM_HEC_TRE_PotentialProcedure_Package.Query intraocular_packageQ = new ORM_HEC_TRE_PotentialProcedure_Package.Query();
intraocular_packageQ.Tenant_RefID = securityTicket.TenantID;
intraocular_packageQ.IsDeleted = false;
intraocular_packageQ.GlobalPropertyMatchingID = "mm.docconect.doc.app.intraocular.package";
var intraocular_package = ORM_HEC_TRE_PotentialProcedure_Package.Query.Search(Connection, Transaction, intraocular_packageQ).FirstOrDefault();
if (intraocular_package != null)
{
ORM_HEC_TRE_PotentialProcedure_2_ProcedurePackage.Query procedure_2_packageQ = new ORM_HEC_TRE_PotentialProcedure_2_ProcedurePackage.Query();
procedure_2_packageQ.Tenant_RefID = securityTicket.TenantID;
procedure_2_packageQ.IsDeleted = false;
procedure_2_packageQ.HEC_TRE_PotentialProcedure_Package_RefID = intraocular_package.HEC_TRE_PotentialProcedure_PackageID;
var procedure_2_package = ORM_HEC_TRE_PotentialProcedure_2_ProcedurePackage.Query.Search(Connection, Transaction, procedure_2_packageQ).FirstOrDefault();
if (procedure_2_package != null)
{
intraocular_procedure_id = procedure_2_package.HEC_TRE_PotentialProcedure_RefID;
}
else
{
intraocular_procedure_id = cls_Create_Potential_Procedure.Invoke(Connection, Transaction, securityTicket).Result;
}
}
else
{
intraocular_procedure_id = cls_Create_Potential_Procedure.Invoke(Connection, Transaction, securityTicket).Result;
}
#endregion POTENTIAL PROCEDURE
#region TREATMENT PLANNED ACTION
cls_Create_Treatment_Planned_Action.Invoke(Connection, Transaction, new P_CAS_CTPA_1225()
{
all_languagesL = all_languagesL,
case_id = new_case.HEC_CAS_CaseID,
diagnose_id = Parameter.diagnose_id,
initial_performed_action_id = initial_performed_action_id,
drug_id = Parameter.drug_id,
intraocular_procedure_id = intraocular_procedure_id,
is_confirmed = Parameter.is_confirmed,
is_left_eye = Parameter.is_left_eye,
patient_id = Parameter.patient_id,
practice_id = Parameter.practice_id,
treatment_date = Parameter.treatment_date,
treatment_doctor_id = Parameter.treatment_doctor_id
}, securityTicket);
#endregion TREATMENT PLANNED ACTION
#region AFTERCARE PLANNED ACTION
if (Parameter.aftercare_doctor_practice_id != Guid.Empty)
{
cls_Create_Aftercare_Planned_Action.Invoke(Connection, Transaction, new P_CAS_CAPA_1237()
{
aftercare_doctor_practice_id = Parameter.aftercare_doctor_practice_id,
all_languagesL = all_languagesL,
case_id = new_case.HEC_CAS_CaseID,
patient_id = Parameter.patient_id,
practice_id = Parameter.practice_id,
treatment_date = Parameter.treatment_date
}, securityTicket);
}
#endregion AFTERCARE PLANNED ACTION
#region ADD GPOS TO THE CASE
cls_Add_GPOS_to_Case.Invoke(Connection, Transaction, new P_CAS_AGPOStC_0906()
{
ac_doctor_id = Parameter.aftercare_doctor_practice_id,
all_languagesL = all_languagesL,
case_id = new_case.HEC_CAS_CaseID,
diagnose_id = Parameter.diagnose_id,
drug_id = Parameter.drug_id,
patient_id = Parameter.patient_id,
treatment_doctor_id = Parameter.treatment_doctor_id,
localization = Parameter.is_left_eye ? "L" : "R",
treatment_gpos = Parameter.treatment_gpos,
aftercare_gpos = Parameter.aftercare_gpos,
bevacizumab_gpos = Parameter.bevacizumab_gpos,
management_fee_gpos = Parameter.management_fee_gpos
}, securityTicket);
#endregion
#region IMPORT TO ELASTIC
Case_Model case_model_elastic = new Case_Model();
case_model_elastic.diagnose = diagnose_details != null ? diagnose_details.diagnose_name + " (" + diagnose_details.catalog_display_name + ": " + diagnose_details.diagnose_icd_10 + ")" : "";
case_model_elastic.drug = drug_details != null ? drug_details.drug_name : "";
case_model_elastic.id = new_case.HEC_CAS_CaseID.ToString();
case_model_elastic.localization = Parameter.diagnose_id == Guid.Empty ? "-" : Parameter.is_left_eye ? "L" : "R";
case_model_elastic.previous_status_drug_order = "";
case_model_elastic.status_treatment = "OP1";
case_model_elastic.diagnose_id = Parameter.diagnose_id.ToString();
case_model_elastic.drug_id = Parameter.drug_id.ToString();
case_model_elastic.patient_id = Parameter.patient_id.ToString();
case_model_elastic.treatment_doctor_id = Parameter.treatment_doctor_id.ToString();
case_model_elastic.aftercare_doctor_practice_id = Parameter.aftercare_doctor_practice_id.ToString();
case_model_elastic.patient_name = patient_details != null ? patient_details.patient_last_name + ", " + patient_details.patient_first_name : "";
case_model_elastic.patient_birthdate_string = patient_details.birthday.ToString("dd.MM.yyyy");
case_model_elastic.patient_birthdate = patient_details.birthday;
var is_aftercare_doctor = true;
string aftercare_name = "";
var aftercare_doctor_details = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = Parameter.aftercare_doctor_practice_id
}, securityTicket).Result.SingleOrDefault();
if (aftercare_doctor_details != null)
{
case_model_elastic.aftercare_name = aftercare_doctor_details.title + " " + aftercare_doctor_details.last_name + " " + aftercare_doctor_details.first_name;
case_model_elastic.aftercare_doctors_practice_name = aftercare_doctor_details.practice;
case_model_elastic.aftercare_practice_bsnr = aftercare_doctor_details.BSNR;
aftercare_name = aftercare_doctor_details.title + " " + aftercare_doctor_details.first_name + " " + aftercare_doctor_details.last_name;
}
else
{
is_aftercare_doctor = false;
var aftercare_practice_details = cls_Get_Practice_Details_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPDfPID_1432()
{
PracticeID = Parameter.aftercare_doctor_practice_id
}, securityTicket).Result.FirstOrDefault();
if (aftercare_practice_details != null)
{
case_model_elastic.aftercare_name = aftercare_practice_details.practice_name;
case_model_elastic.aftercare_practice_bsnr = aftercare_doctor_details.BSNR;
aftercare_name = aftercare_practice_details.practice_name;
}
else
{
case_model_elastic.aftercare_name = "-";
}
}
case_model_elastic.is_aftercare_doctor = is_aftercare_doctor;
DateTime treatment_date = DateTime.SpecifyKind(Parameter.treatment_date, DateTimeKind.Local);
case_model_elastic.treatment_date = Parameter.treatment_date;
case_model_elastic.treatment_date_day_month = Parameter.treatment_date.ToString("dd.MM.");
case_model_elastic.treatment_date_month_year = Parameter.treatment_date.ToString("MMMM yyyy", new System.Globalization.CultureInfo("de", true));
case_model_elastic.treatment_doctor_name = treatment_doctor_details != null ? treatment_doctor_details.title + " " + treatment_doctor_details.first_name + " " + treatment_doctor_details.last_name : "-";
case_model_elastic.practice_id = Parameter.practice_id.ToString();
case_model_elastic.delivery_time_string = case_model_elastic.delivery_time_from.ToString("HH:mm") + " - " + case_model_elastic.delivery_time_to.ToString("HH:mm");
List <Case_Model> cases = new List <Case_Model>();
cases.Add(case_model_elastic);
Add_New_Case.Import_Case_Data_to_ElasticDB(cases, securityTicket.TenantID.ToString());
#endregion IMPORT TO ELASTIC
return(returnValue);
#endregion UserCode
}
