protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_COCT_1703 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var oct_planned_action = new ORM_HEC_ACT_PlannedAction();
oct_planned_action.Patient_RefID = Parameter.patient_id;
oct_planned_action.PlannedFor_Date = Parameter.treatment_date;
oct_planned_action.MedicalPractice_RefID = Parameter.practice_id;
oct_planned_action.Tenant_RefID = securityTicket.TenantID;
oct_planned_action.ToBePerformedBy_BusinessParticipant_RefID = Parameter.oct_bpt_id;
oct_planned_action.Modification_Timestamp = DateTime.Now;
oct_planned_action.Save(Connection, Transaction);
var oct_planned_action_2_type = new ORM_HEC_ACT_PlannedAction_2_ActionType();
oct_planned_action_2_type.HEC_ACT_ActionType_RefID = Parameter.oct_action_type_id;
oct_planned_action_2_type.HEC_ACT_PlannedAction_RefID = oct_planned_action.HEC_ACT_PlannedActionID;
oct_planned_action_2_type.Tenant_RefID = securityTicket.TenantID;
oct_planned_action_2_type.Modification_Timestamp = DateTime.Now;
oct_planned_action_2_type.Save(Connection, Transaction);
var oct_relevant_planned_action = new ORM_HEC_CAS_Case_RelevantPlannedAction();
oct_relevant_planned_action.Case_RefID = Parameter.case_id;
oct_relevant_planned_action.PlannedAction_RefID = oct_planned_action.HEC_ACT_PlannedActionID;
oct_relevant_planned_action.Tenant_RefID = securityTicket.TenantID;
oct_relevant_planned_action.Modification_Timestamp = DateTime.Now;
oct_relevant_planned_action.Save(Connection, Transaction);
returnValue.Result = oct_planned_action.HEC_ACT_PlannedActionID;
return(returnValue);
#endregion UserCode
}
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_L5TA_STI_1037 Execute(DbConnection Connection, DbTransaction Transaction, P_L5TA_STI_1037 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_L5TA_STI_1037()
{
Result = new L5TA_STI_1037()
};
//Put your code here
#region Save
var webAvailabilityType = ORM_CMN_CAL_AVA_Availability_Type.Query.Search(Connection, Transaction, new ORM_CMN_CAL_AVA_Availability_Type.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(AvailabilityType.WebBooking)
}).First();
var standardAvailabilityType = ORM_CMN_CAL_AVA_Availability_Type.Query.Search(Connection, Transaction, new ORM_CMN_CAL_AVA_Availability_Type.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(AvailabilityType.Standard)
}).First();
if (Parameter.PPS_TSK_TaskID == Guid.Empty)
{
//=====================New Task=====================
ORM_PPS_TSK_Task task = new ORM_PPS_TSK_Task();
task.PPS_TSK_TaskID = Guid.NewGuid();
var newTaskIdentifierNumber = ORM_PPS_TSK_Task.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task.Query
{
Tenant_RefID = securityTicket.TenantID
}).Count;
task.TaskIdentifier = (++newTaskIdentifierNumber).ToString();
task.DisplayName = "AT" + task.TaskIdentifier;
task.InstantiatedFrom_TaskTemplate_RefID = Parameter.TaskTemplate_RefID;
task.PlannedStartDate = Parameter.PlannedStartDate;
task.PlannedDuration_in_sec = Parameter.PlannedDuration_in_sec;
task.IsDeleted = false;
task.Tenant_RefID = securityTicket.TenantID;
//=====================Selected availability types=====================
ORM_PPRS_TSK_Task_SelectedAvailabilityType selectedTypes = new ORM_PPRS_TSK_Task_SelectedAvailabilityType();
selectedTypes.PPRS_TSK_Task_SelectedAvailabilityTypeID = Guid.NewGuid();
selectedTypes.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
selectedTypes.CMN_CAL_AVA_Availability_Type_RefID = Parameter.IsWebBooking ? webAvailabilityType.CMN_CAL_AVA_Availability_TypeID : standardAvailabilityType.CMN_CAL_AVA_Availability_TypeID;
selectedTypes.IsDeleted = false;
selectedTypes.Tenant_RefID = securityTicket.TenantID;
selectedTypes.Save(Connection, Transaction);
//=====================New Employee=====================
if (Parameter.Employee != null && Parameter.Employee.Count() > 0)
{
foreach (var employeeParam in Parameter.Employee)
{
ORM_PPS_TSK_Task_StaffBooking staff = new ORM_PPS_TSK_Task_StaffBooking();
staff.PPS_TSK_Task_StaffBookingsID = Guid.NewGuid();
staff.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
staff.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
staff.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
staff.IsDeleted = false;
staff.Tenant_RefID = securityTicket.TenantID;
staff.Save(Connection, Transaction);
}
}
//=====================New Device=====================
if (Parameter.Devices != null && Parameter.Devices.Count() > 0)
{
foreach (var deviceParam in Parameter.Devices)
{
ORM_PPS_TSK_Task_DeviceBooking device = new ORM_PPS_TSK_Task_DeviceBooking();
device.PPS_TSK_Task_DeviceBookingID = Guid.NewGuid();
device.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
device.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
device.IsDeleted = false;
device.Tenant_RefID = securityTicket.TenantID;
device.Save(Connection, Transaction);
}
}
//=====================New Office=====================
if (Parameter.Office != null)
{
ORM_PPS_TSK_Task_OfficeBooking office = new ORM_PPS_TSK_Task_OfficeBooking();
office.PPS_TSK_Task_OfficeBookingID = Guid.NewGuid();
office.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
office.CMN_STR_Office_RefID = Parameter.Office.CMN_STR_Office_RefID;
office.IsDeleted = false;
office.Tenant_RefID = securityTicket.TenantID;
office.Save(Connection, Transaction);
}
//=====================New Patient=====================
if (Parameter.Patient != null)
{
ORM_HEC_APP_Appointment appointmnet = new ORM_HEC_APP_Appointment();
appointmnet.HEC_APP_AppointmentID = Guid.NewGuid();
appointmnet.Ext_PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
appointmnet.IsDeleted = false;
appointmnet.Tenant_RefID = securityTicket.TenantID;
appointmnet.Save(Connection, Transaction);
ORM_HEC_ACT_PlannedAction plannedAppointment = new ORM_HEC_ACT_PlannedAction();
plannedAppointment.HEC_ACT_PlannedActionID = Guid.NewGuid();
plannedAppointment.Appointment_RefID = appointmnet.HEC_APP_AppointmentID;
plannedAppointment.Patient_RefID = Parameter.Patient.Patient_RefID;
plannedAppointment.IsDeleted = false;
plannedAppointment.Tenant_RefID = securityTicket.TenantID;
plannedAppointment.Save(Connection, Transaction);
}
task.Save(Connection, Transaction);
returnValue.Result.ID = task.PPS_TSK_TaskID;
}
#endregion
//=====================Edit or Delete=====================
else
{
var task = ORM_PPS_TSK_Task.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task.Query
{
PPS_TSK_TaskID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
#region Edit
if (Parameter.IsDeleted == false)
{
if (task.InstantiatedFrom_TaskTemplate_RefID != Parameter.TaskTemplate_RefID) //changed task template
{
//=====================First delete old employee and device=====================
var employeeForDelete = ORM_PPS_TSK_Task_StaffBooking.Query.SoftDelete(Connection, Transaction, new ORM_PPS_TSK_Task_StaffBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
var deviceForDelete = ORM_PPS_TSK_Task_DeviceBooking.Query.SoftDelete(Connection, Transaction, new ORM_PPS_TSK_Task_DeviceBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
task.InstantiatedFrom_TaskTemplate_RefID = Parameter.TaskTemplate_RefID;
task.PlannedDuration_in_sec = Parameter.PlannedDuration_in_sec;
//=====================New Employee=====================
if (Parameter.Employee != null && Parameter.Employee.Count() > 0)
{
foreach (var employeeParam in Parameter.Employee)
{
ORM_PPS_TSK_Task_StaffBooking staff = new ORM_PPS_TSK_Task_StaffBooking();
staff.PPS_TSK_Task_StaffBookingsID = Guid.NewGuid();
staff.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
staff.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
staff.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
staff.IsDeleted = false;
staff.Tenant_RefID = securityTicket.TenantID;
staff.Save(Connection, Transaction);
}
}
//=====================New Device=====================
if (Parameter.Devices != null && Parameter.Devices.Count() > 0)
{
foreach (var deviceParam in Parameter.Devices)
{
ORM_PPS_TSK_Task_DeviceBooking device = new ORM_PPS_TSK_Task_DeviceBooking();
device.PPS_TSK_Task_DeviceBookingID = Guid.NewGuid();
device.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
device.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
device.IsDeleted = false;
device.Tenant_RefID = securityTicket.TenantID;
device.Save(Connection, Transaction);
}
}
}
else //only change existing employee and device
{
//=====================Edit employee=====================
if (Parameter.Employee != null)
{
foreach (var employeeParam in Parameter.Employee)
{
var existingEmployee = ORM_PPS_TSK_Task_StaffBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_StaffBooking.Query
{
PPS_TSK_Task_StaffBookingsID = employeeParam.PPS_TSK_Task_StaffBookingsID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (existingEmployee == null) //if employee dont exist (if deleted from other page), create new
{
ORM_PPS_TSK_Task_StaffBooking staff = new ORM_PPS_TSK_Task_StaffBooking();
staff.PPS_TSK_Task_StaffBookingsID = Guid.NewGuid();
staff.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
staff.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
staff.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
staff.IsDeleted = false;
staff.Tenant_RefID = securityTicket.TenantID;
staff.Save(Connection, Transaction);
}
else
{
existingEmployee.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
existingEmployee.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
existingEmployee.Tenant_RefID = securityTicket.TenantID;
existingEmployee.Save(Connection, Transaction);
}
}
}
//=====================Edit device=====================
if (Parameter.Devices != null)
{
foreach (var deviceParam in Parameter.Devices)
{
var existingDevice = ORM_PPS_TSK_Task_DeviceBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_DeviceBooking.Query
{
PPS_TSK_Task_DeviceBookingID = deviceParam.PPS_TSK_Task_DeviceBookingID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (existingDevice == null)
{
ORM_PPS_TSK_Task_DeviceBooking device = new ORM_PPS_TSK_Task_DeviceBooking();
device.PPS_TSK_Task_DeviceBookingID = Guid.NewGuid();
device.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
device.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
device.IsDeleted = false;
device.Tenant_RefID = securityTicket.TenantID;
device.Save(Connection, Transaction);
}
else
{
existingDevice.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
existingDevice.Tenant_RefID = securityTicket.TenantID;
existingDevice.Save(Connection, Transaction);
}
}
}
}
//=====================Edit other data=====================
task.PlannedStartDate = Parameter.PlannedStartDate;
//=====================Edit selected availability types=====================
var existingAvailabilityType = ORM_PPRS_TSK_Task_SelectedAvailabilityType.Query.Search(Connection, Transaction, new ORM_PPRS_TSK_Task_SelectedAvailabilityType.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
PPS_TSK_Task_RefID = task.PPS_TSK_TaskID
}).Single();
existingAvailabilityType.CMN_CAL_AVA_Availability_Type_RefID = Parameter.IsWebBooking ? webAvailabilityType.CMN_CAL_AVA_Availability_TypeID : standardAvailabilityType.CMN_CAL_AVA_Availability_TypeID;
existingAvailabilityType.Save(Connection, Transaction);
//=====================Edit Office=====================
if (Parameter.Office != null)
{
var existingOffice = ORM_PPS_TSK_Task_OfficeBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_OfficeBooking.Query
{
PPS_TSK_Task_OfficeBookingID = Parameter.Office.PPS_TSK_Task_OfficeBookingID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
existingOffice.CMN_STR_Office_RefID = Parameter.Office.CMN_STR_Office_RefID;
existingOffice.Tenant_RefID = securityTicket.TenantID;
existingOffice.Save(Connection, Transaction);
}
//=====================Edit Patient=====================
//when inter tenant communication is implemented, this part should be changed.
if (Parameter.Patient != null && Parameter.Patient.Patient_RefID != Guid.Empty)
{
var appointmentForEdit = ORM_HEC_APP_Appointment.Query.Search(Connection, Transaction, new ORM_HEC_APP_Appointment.Query
{
Ext_PPS_TSK_Task_RefID = task.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
var patientPlannedAppointmentForEdit = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
Appointment_RefID = appointmentForEdit.HEC_APP_AppointmentID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
returnValue.Result.ReplacedPatient = new L5TA_STI_1037_ReplacedPatient()
{
ID = patientPlannedAppointmentForEdit.Patient_RefID
};
patientPlannedAppointmentForEdit.Patient_RefID = Parameter.Patient.Patient_RefID;
patientPlannedAppointmentForEdit.Save(Connection, Transaction);
}
}
#endregion
#region Delete
else
{
//=====================Delete employee=====================
var employeeForDelete = ORM_PPS_TSK_Task_StaffBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_StaffBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).ToArray();
foreach (var empForDel in employeeForDelete)
{
empForDel.IsDeleted = true;
empForDel.Save(Connection, Transaction);
}
//=====================Delete devices=====================
var deviceForDelete = ORM_PPS_TSK_Task_DeviceBooking.Query.SoftDelete(Connection, Transaction, new ORM_PPS_TSK_Task_DeviceBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
//=====================Delete office=====================
var officeForDelete = ORM_PPS_TSK_Task_OfficeBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_OfficeBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
//=====================Delete patient=====================
var appointmentForDelete = ORM_HEC_APP_Appointment.Query.Search(Connection, Transaction, new ORM_HEC_APP_Appointment.Query
{
Ext_PPS_TSK_Task_RefID = task.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
var plannedAction = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
Tenant_RefID = securityTicket.TenantID,
Appointment_RefID = appointmentForDelete.HEC_APP_AppointmentID,
}).Single();
var patientPlannedAppointmentToDelete = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
Appointment_RefID = appointmentForDelete.HEC_APP_AppointmentID,
Patient_RefID = plannedAction.Patient_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
patientPlannedAppointmentToDelete.IsDeleted = true;
patientPlannedAppointmentToDelete.Save(Connection, Transaction);
appointmentForDelete.IsDeleted = true;
appointmentForDelete.Save(Connection, Transaction);
task.IsDeleted = true;
var firstBookedEmp = employeeForDelete.First();
var reqStaff = ORM_PPS_TSK_Task_RequiredStaff.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_RequiredStaff.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
PPS_TSK_Task_RequiredStaffID = firstBookedEmp.CreatedFrom_TaskTemplate_RequiredStaff_RefID
}).Single();
var combsSraff = ORM_PPS_TSK_BOK_StaffResource.Query.Search(Connection, Transaction, new ORM_PPS_TSK_BOK_StaffResource.Query()
{
Tenant_RefID = securityTicket.TenantID,
CreatedFor_TaskTemplateRequiredStaff_RefID = reqStaff.PPS_TSK_Task_RequiredStaffID
}).ToArray();
var comb = ORM_PPS_TSK_BOK_AvailableResourceCombination.Query.Search(Connection, Transaction, new ORM_PPS_TSK_BOK_AvailableResourceCombination.Query()
{
Tenant_RefID = securityTicket.TenantID,
PPS_TSK_BOK_AvailableResourceCombinationID = combsSraff[0].AvailableResourceCombination_RefID,
}).Single();
if (!comb.IsDeleted)
{
comb.IsAvailable = true;
comb.Save(Connection, Transaction);
}
officeForDelete.IsDeleted = true;
officeForDelete.Save(Connection, Transaction);
}
#endregion
task.Save(Connection, Transaction);
returnValue.Result.ID = task.PPS_TSK_TaskID;
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CAPA_1237 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_HEC_ACT_PlannedAction aftercare_planned_action = new ORM_HEC_ACT_PlannedAction();
aftercare_planned_action.Creation_Timestamp = DateTime.Now;
aftercare_planned_action.HEC_ACT_PlannedActionID = Guid.NewGuid();
aftercare_planned_action.IsPerformed = false;
aftercare_planned_action.Modification_Timestamp = DateTime.Now;
aftercare_planned_action.Patient_RefID = Parameter.patient_id;
aftercare_planned_action.PlannedFor_Date = Parameter.treatment_date;
aftercare_planned_action.Tenant_RefID = securityTicket.TenantID;
Guid id = Guid.Empty;
var aftercare_doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
HEC_DoctorID = Parameter.aftercare_doctor_practice_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (aftercare_doctor != null)
{
id = aftercare_doctor.BusinessParticipant_RefID;
}
else
{
var aftercare_practice = ORM_CMN_BPT_CTM_OrganizationalUnit.Query.Search(Connection, Transaction, new ORM_CMN_BPT_CTM_OrganizationalUnit.Query()
{
IfMedicalPractise_HEC_MedicalPractice_RefID = Parameter.aftercare_doctor_practice_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (aftercare_practice != null)
{
var aftercare_customer = ORM_CMN_BPT_CTM_Customer.Query.Search(Connection, Transaction, new ORM_CMN_BPT_CTM_Customer.Query()
{
CMN_BPT_CTM_CustomerID = aftercare_practice.Customer_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (aftercare_customer != null)
{
id = aftercare_customer.Ext_BusinessParticipant_RefID;
}
}
}
aftercare_planned_action.ToBePerformedBy_BusinessParticipant_RefID = id;
aftercare_planned_action.Save(Connection, Transaction);
ORM_HEC_CAS_Case_RelevantPlannedAction aftercare_planned_action_to_case = new ORM_HEC_CAS_Case_RelevantPlannedAction();
aftercare_planned_action_to_case.Case_RefID = Parameter.case_id;
aftercare_planned_action_to_case.Creation_Timestamp = DateTime.Now;
aftercare_planned_action_to_case.HEC_CAS_Case_RelevantPlannedActionID = Guid.NewGuid();
aftercare_planned_action_to_case.Modification_Timestamp = DateTime.Now;
aftercare_planned_action_to_case.PlannedAction_RefID = aftercare_planned_action.HEC_ACT_PlannedActionID;
aftercare_planned_action_to_case.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_to_case.Save(Connection, Transaction);
ORM_HEC_ACT_ActionType.Query aftercare_planned_action_typeQ = new ORM_HEC_ACT_ActionType.Query();
aftercare_planned_action_typeQ.GlobalPropertyMatchingID = "mm.docconect.doc.app.planned.action.aftercare";
aftercare_planned_action_typeQ.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_typeQ.IsDeleted = false;
var aftercare_planned_action_type_id = Guid.Empty;
var aftercare_planned_action_type = ORM_HEC_ACT_ActionType.Query.Search(Connection, Transaction, aftercare_planned_action_typeQ).SingleOrDefault();
if (aftercare_planned_action_type == null)
{
aftercare_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") ? "nachsorge" : "aftercare";
action_type_name_dict.AddEntry(lang.CMN_LanguageID, content);
}
aftercare_planned_action_type.ActionType_Name = action_type_name_dict;
aftercare_planned_action_type.Creation_Timestamp = DateTime.Now;
aftercare_planned_action_type.GlobalPropertyMatchingID = "mm.docconect.doc.app.planned.action.aftercare";
aftercare_planned_action_type.Modification_Timestamp = DateTime.Now;
aftercare_planned_action_type.HEC_ACT_ActionTypeID = Guid.NewGuid();
aftercare_planned_action_type.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_type.Save(Connection, Transaction);
aftercare_planned_action_type_id = aftercare_planned_action_type.HEC_ACT_ActionTypeID;
}
else
{
aftercare_planned_action_type_id = aftercare_planned_action_type.HEC_ACT_ActionTypeID;
}
ORM_HEC_ACT_PlannedAction_2_ActionType aftercare_planned_action_2_type = new ORM_HEC_ACT_PlannedAction_2_ActionType();
aftercare_planned_action_2_type.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_2_type.Creation_Timestamp = DateTime.Now;
aftercare_planned_action_2_type.IsDeleted = false;
aftercare_planned_action_2_type.HEC_ACT_ActionType_RefID = aftercare_planned_action_type_id;
aftercare_planned_action_2_type.HEC_ACT_PlannedAction_RefID = aftercare_planned_action.HEC_ACT_PlannedActionID;
aftercare_planned_action_2_type.Modification_Timestamp = DateTime.Now;
aftercare_planned_action_2_type.HEC_ACT_PlannedAction_2_ActionTypeID = Guid.NewGuid();
aftercare_planned_action_2_type.Save(Connection, Transaction);
returnValue.Result = aftercare_planned_action.HEC_ACT_PlannedActionID;
return(returnValue);
#endregion UserCode
}
protected static FR_L5BTS_STI_1331 Execute(DbConnection Connection, DbTransaction Transaction, P_L5BTS_STI_1331 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_L5BTS_STI_1331()
{
Result = new L5BTS_STI_1331()
};
//Put your code here
#region Save
var webAvailabilityType = ORM_CMN_CAL_AVA_Availability_Type.Query.Search(Connection, Transaction, new ORM_CMN_CAL_AVA_Availability_Type.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(AvailabilityType.WebBooking)
}).First();
var standardAvailabilityType = ORM_CMN_CAL_AVA_Availability_Type.Query.Search(Connection, Transaction, new ORM_CMN_CAL_AVA_Availability_Type.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(AvailabilityType.Standard)
}).First();
if (Parameter.PPS_TSK_TaskID == Guid.Empty)
{
//=====================New Task=====================
ORM_PPS_TSK_Task task = new ORM_PPS_TSK_Task();
task.PPS_TSK_TaskID = Guid.NewGuid();
var newTaskIdentifierNumber = ORM_PPS_TSK_Task.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task.Query
{
Tenant_RefID = securityTicket.TenantID
}).Count;
task.TaskIdentifier = (++newTaskIdentifierNumber).ToString();
task.DisplayName = "AT" + task.TaskIdentifier;
task.InstantiatedFrom_TaskTemplate_RefID = Parameter.TaskTemplate_RefID;
task.PlannedStartDate = Parameter.PlannedStartDate;
task.PlannedDuration_in_sec = Parameter.PlannedDuration_in_sec;
task.IsDeleted = false;
task.Tenant_RefID = securityTicket.TenantID;
//=====================Selected availability types=====================
ORM_PPRS_TSK_Task_SelectedAvailabilityType selectedTypes = new ORM_PPRS_TSK_Task_SelectedAvailabilityType();
selectedTypes.PPRS_TSK_Task_SelectedAvailabilityTypeID = Guid.NewGuid();
selectedTypes.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
selectedTypes.CMN_CAL_AVA_Availability_Type_RefID = Parameter.IsWebBooking ? webAvailabilityType.CMN_CAL_AVA_Availability_TypeID : standardAvailabilityType.CMN_CAL_AVA_Availability_TypeID;
selectedTypes.IsDeleted = false;
selectedTypes.Tenant_RefID = securityTicket.TenantID;
selectedTypes.Save(Connection, Transaction);
//=====================New Employee=====================
if (Parameter.Employee != null && Parameter.Employee.Count() > 0)
{
foreach (var employeeParam in Parameter.Employee)
{
ORM_PPS_TSK_Task_StaffBooking staff = new ORM_PPS_TSK_Task_StaffBooking();
staff.PPS_TSK_Task_StaffBookingsID = Guid.NewGuid();
staff.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
staff.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
staff.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
staff.IsDeleted = false;
staff.Tenant_RefID = securityTicket.TenantID;
staff.Save(Connection, Transaction);
}
}
//=====================New Device=====================
if (Parameter.Devices != null && Parameter.Devices.Count() > 0)
{
foreach (var deviceParam in Parameter.Devices)
{
ORM_PPS_TSK_Task_DeviceBooking device = new ORM_PPS_TSK_Task_DeviceBooking();
device.PPS_TSK_Task_DeviceBookingID = Guid.NewGuid();
device.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
device.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
device.IsDeleted = false;
device.Tenant_RefID = securityTicket.TenantID;
device.Save(Connection, Transaction);
}
}
//=====================New Office=====================
if (Parameter.Office != null)
{
ORM_PPS_TSK_Task_OfficeBooking office = new ORM_PPS_TSK_Task_OfficeBooking();
office.PPS_TSK_Task_OfficeBookingID = Guid.NewGuid();
office.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
office.CMN_STR_Office_RefID = Parameter.Office.CMN_STR_Office_RefID;
office.IsDeleted = false;
office.Tenant_RefID = securityTicket.TenantID;
office.Save(Connection, Transaction);
}
//=====================New Patient=====================
if (Parameter.Patient != null)
{
ORM_HEC_APP_Appointment appointmnet = new ORM_HEC_APP_Appointment();
appointmnet.HEC_APP_AppointmentID = Guid.NewGuid();
appointmnet.Ext_PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
appointmnet.IsDeleted = false;
appointmnet.Tenant_RefID = securityTicket.TenantID;
appointmnet.Save(Connection, Transaction);
ORM_HEC_ACT_PlannedAction plannedAppointment = new ORM_HEC_ACT_PlannedAction();
plannedAppointment.HEC_ACT_PlannedActionID = Guid.NewGuid();
plannedAppointment.Appointment_RefID = appointmnet.HEC_APP_AppointmentID;
plannedAppointment.Patient_RefID = Parameter.Patient.Patient_RefID;
plannedAppointment.IsDeleted = false;
plannedAppointment.Tenant_RefID = securityTicket.TenantID;
plannedAppointment.Save(Connection, Transaction);
}
task.Save(Connection, Transaction);
returnValue.Result.ID = task.PPS_TSK_TaskID;
}
#endregion
//=====================Edit or Delete=====================
else
{
var task = ORM_PPS_TSK_Task.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task.Query
{
PPS_TSK_TaskID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
#region Edit
if (Parameter.IsDeleted == false)
{
if (task.InstantiatedFrom_TaskTemplate_RefID != Parameter.TaskTemplate_RefID) //changed task template
{
//=====================First delete old employee and device=====================
var employeeForDelete = ORM_PPS_TSK_Task_StaffBooking.Query.SoftDelete(Connection, Transaction, new ORM_PPS_TSK_Task_StaffBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
var deviceForDelete = ORM_PPS_TSK_Task_DeviceBooking.Query.SoftDelete(Connection, Transaction, new ORM_PPS_TSK_Task_DeviceBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
});
task.InstantiatedFrom_TaskTemplate_RefID = Parameter.TaskTemplate_RefID;
task.PlannedDuration_in_sec = Parameter.PlannedDuration_in_sec;
//=====================New Employee=====================
if (Parameter.Employee != null && Parameter.Employee.Count() > 0)
{
foreach (var employeeParam in Parameter.Employee)
{
ORM_PPS_TSK_Task_StaffBooking staff = new ORM_PPS_TSK_Task_StaffBooking();
staff.PPS_TSK_Task_StaffBookingsID = Guid.NewGuid();
staff.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
staff.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
staff.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
staff.IsDeleted = false;
staff.Tenant_RefID = securityTicket.TenantID;
staff.Save(Connection, Transaction);
}
}
//=====================New Device=====================
if (Parameter.Devices != null && Parameter.Devices.Count() > 0)
{
foreach (var deviceParam in Parameter.Devices)
{
ORM_PPS_TSK_Task_DeviceBooking device = new ORM_PPS_TSK_Task_DeviceBooking();
device.PPS_TSK_Task_DeviceBookingID = Guid.NewGuid();
device.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
device.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
device.IsDeleted = false;
device.Tenant_RefID = securityTicket.TenantID;
device.Save(Connection, Transaction);
}
}
}
else //only change existing employee and device
{
//=====================Edit employee=====================
if (Parameter.Employee != null)
{
foreach (var employeeParam in Parameter.Employee)
{
var existingEmployee = ORM_PPS_TSK_Task_StaffBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_StaffBooking.Query
{
PPS_TSK_Task_StaffBookingsID = employeeParam.PPS_TSK_Task_StaffBookingsID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (existingEmployee == null) //if employee dont exist (if deleted from other page), create new
{
ORM_PPS_TSK_Task_StaffBooking staff = new ORM_PPS_TSK_Task_StaffBooking();
staff.PPS_TSK_Task_StaffBookingsID = Guid.NewGuid();
staff.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
staff.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
staff.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
staff.IsDeleted = false;
staff.Tenant_RefID = securityTicket.TenantID;
staff.Save(Connection, Transaction);
}
else
{
existingEmployee.CMN_BPT_EMP_Employee_RefID = employeeParam.CMN_BPT_EMP_Employee_RefID;
existingEmployee.CreatedFrom_TaskTemplate_RequiredStaff_RefID = employeeParam.CreatedFrom_TaskTemplate_RequiredStaff_RefID;
existingEmployee.Tenant_RefID = securityTicket.TenantID;
existingEmployee.Save(Connection, Transaction);
}
}
}
//=====================Edit device=====================
if (Parameter.Devices != null)
{
foreach (var deviceParam in Parameter.Devices)
{
var existingDevice = ORM_PPS_TSK_Task_DeviceBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_DeviceBooking.Query
{
PPS_TSK_Task_DeviceBookingID = deviceParam.PPS_TSK_Task_DeviceBookingID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).SingleOrDefault();
if (existingDevice == null)
{
ORM_PPS_TSK_Task_DeviceBooking device = new ORM_PPS_TSK_Task_DeviceBooking();
device.PPS_TSK_Task_DeviceBookingID = Guid.NewGuid();
device.PPS_TSK_Task_RefID = task.PPS_TSK_TaskID;
device.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
device.IsDeleted = false;
device.Tenant_RefID = securityTicket.TenantID;
device.Save(Connection, Transaction);
}
else
{
existingDevice.PPS_DEV_Device_Instance_RefID = deviceParam.PPS_DEV_Device_Instance_RefID;
existingDevice.Tenant_RefID = securityTicket.TenantID;
existingDevice.Save(Connection, Transaction);
}
}
}
}
//=====================Edit other data=====================
task.PlannedStartDate = Parameter.PlannedStartDate;
//=====================Edit selected availability types=====================
var existingAvailabilityType = ORM_PPRS_TSK_Task_SelectedAvailabilityType.Query.Search(Connection, Transaction, new ORM_PPRS_TSK_Task_SelectedAvailabilityType.Query
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
PPS_TSK_Task_RefID = task.PPS_TSK_TaskID
}).Single();
existingAvailabilityType.CMN_CAL_AVA_Availability_Type_RefID = Parameter.IsWebBooking ? webAvailabilityType.CMN_CAL_AVA_Availability_TypeID : standardAvailabilityType.CMN_CAL_AVA_Availability_TypeID;
existingAvailabilityType.Save(Connection, Transaction);
//=====================Edit Office=====================
if (Parameter.Office != null)
{
var existingOffice = ORM_PPS_TSK_Task_OfficeBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_OfficeBooking.Query
{
PPS_TSK_Task_OfficeBookingID = Parameter.Office.PPS_TSK_Task_OfficeBookingID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
existingOffice.CMN_STR_Office_RefID = Parameter.Office.CMN_STR_Office_RefID;
existingOffice.Tenant_RefID = securityTicket.TenantID;
existingOffice.Save(Connection, Transaction);
}
//=====================Edit Patient=====================
//when inter tenant communication is implemented, this part should be changed.
if (Parameter.Patient != null && Parameter.Patient.Patient_RefID != Guid.Empty)
{
var appointmentForEdit = ORM_HEC_APP_Appointment.Query.Search(Connection, Transaction, new ORM_HEC_APP_Appointment.Query
{
Ext_PPS_TSK_Task_RefID = task.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
var patientPlannedAppointmentForEdit = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
Appointment_RefID = appointmentForEdit.HEC_APP_AppointmentID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
returnValue.Result.ReplacedPatient = new L5TA_STI_1037_ReplacedPatient()
{
ID = patientPlannedAppointmentForEdit.Patient_RefID
};
patientPlannedAppointmentForEdit.Patient_RefID = Parameter.Patient.Patient_RefID;
patientPlannedAppointmentForEdit.Save(Connection, Transaction);
}
}
#endregion
#region Delete
else
{
//=====================Delete employee=====================
var employeeForDelete = ORM_PPS_TSK_Task_StaffBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_StaffBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).ToArray();
foreach (var empForDel in employeeForDelete)
{
empForDel.IsDeleted = true;
empForDel.Save(Connection, Transaction);
}
//=====================Delete devices=====================
var deviceForDelete = ORM_PPS_TSK_Task_DeviceBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_DeviceBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).ToArray();
foreach (var devForDel in deviceForDelete)
{
devForDel.IsDeleted = true;
devForDel.Save(Connection, Transaction);
}
//=====================Delete office=====================
var officeForDelete = ORM_PPS_TSK_Task_OfficeBooking.Query.Search(Connection, Transaction, new ORM_PPS_TSK_Task_OfficeBooking.Query
{
PPS_TSK_Task_RefID = Parameter.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
//=====================Delete patient=====================
var appointmentForDelete = ORM_HEC_APP_Appointment.Query.Search(Connection, Transaction, new ORM_HEC_APP_Appointment.Query
{
Ext_PPS_TSK_Task_RefID = task.PPS_TSK_TaskID,
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID
}).Single();
var plannedAction = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
Tenant_RefID = securityTicket.TenantID,
Appointment_RefID = appointmentForDelete.HEC_APP_AppointmentID,
}).Single();
var patientPlannedAppointmentToDelete = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
Appointment_RefID = appointmentForDelete.HEC_APP_AppointmentID,
Patient_RefID = plannedAction.Patient_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
patientPlannedAppointmentToDelete.IsDeleted = true;
patientPlannedAppointmentToDelete.Save(Connection, Transaction);
appointmentForDelete.IsDeleted = true;
appointmentForDelete.Save(Connection, Transaction);
task.IsDeleted = true;
var firstBookedEmp = employeeForDelete;
var slot = ORM_PPS_TSK_BOK_BookableTimeSlot.Query.Search(Connection, Transaction, new ORM_PPS_TSK_BOK_BookableTimeSlot.Query()
{
Tenant_RefID = securityTicket.TenantID,
FreeInterval_Start = task.PlannedStartDate,
TaskTemplate_RefID = task.InstantiatedFrom_TaskTemplate_RefID,
Office_RefID = officeForDelete.CMN_STR_Office_RefID,
IsDeleted = false
}).Single();
var allCombs = cls_Get_Slot_NotAvaCombiantions_for_SlotID.Invoke(Connection, Transaction, new P_L5BTS_GSNACfSID_1456()
{
SlotID = slot.PPS_TSK_BOK_BookableTimeSlotID
}, securityTicket).Result;
L5BTS_GSNACfSID_1456 selecetedComb = null;
foreach (var comb in allCombs)
{
if (!comb.Devices.Select(s => s.PPS_DEV_Device_Instance_RefID).Except(deviceForDelete.Select(s => s.PPS_DEV_Device_Instance_RefID)).Any()
&&
!comb.Staff.Select(s => s.CMN_BPT_EMP_Employee_RefID).Except(employeeForDelete.Select(s => s.CMN_BPT_EMP_Employee_RefID)).Any())
{
selecetedComb = comb;
}
}
if (selecetedComb != null)
{
var comb = ORM_PPS_TSK_BOK_AvailableResourceCombination.Query.Search(Connection, Transaction, new ORM_PPS_TSK_BOK_AvailableResourceCombination.Query()
{
Tenant_RefID = securityTicket.TenantID,
PPS_TSK_BOK_AvailableResourceCombinationID = selecetedComb.PPS_TSK_BOK_AvailableResourceCombinationID,
}).Single();
if (!comb.IsDeleted)
{
comb.IsAvailable = true;
comb.Save(Connection, Transaction);
L5TE_GSAfT_1645[] allEmployeesDB = cls_Get_Staff_with_Availability_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result;
ORM_HEC_Doctor[] hecDoctorsDB = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
Tenant_RefID = securityTicket.TenantID, IsDeleted = false
}).ToArray();
ORM_HEC_Doctor_AssignableAppointmentType[] hecDoctor2ATDB = ORM_HEC_Doctor_AssignableAppointmentType.Query.Search(Connection, Transaction, new ORM_HEC_Doctor_AssignableAppointmentType.Query()
{
Tenant_RefID = securityTicket.TenantID, IsDeleted = false
}).ToArray();
L5TE_GTEFAS_1440[] allStaffExceptions = cls_Get_TimeExceptionsForAllStaff.Invoke(Connection, Transaction, securityTicket).Result;
L3P_GPfT_1537[] professionsForTenant = cls_Get_Professions_for_TenantID.Invoke(Connection, Transaction, securityTicket).Result;
L5TE_GSAfT_1645[] employeesFromPracticeDB = allEmployeesDB.Where(e => employeeForDelete.Select(s => s.CMN_BPT_EMP_Employee_RefID).Contains(e.CMN_BPT_EMP_EmployeeID)).ToArray();
var staff = ModelConvertor.ConvertStaffDBData(officeForDelete.CMN_STR_Office_RefID, employeesFromPracticeDB, hecDoctorsDB, hecDoctor2ATDB, allStaffExceptions, professionsForTenant);
TimeSlot ts = new TimeSlot()
{
PeriodStart = slot.FreeInterval_Start, PeriodEnd = slot.FreeInterval_End
};
bool isComboWebBookable = true;
foreach (var item in selecetedComb.Staff)
{
var employee = staff.Single(s => s.ID == item.CMN_BPT_EMP_Employee_RefID);
if (!StaffAvailabiltyCalculations.IsStaffWebBookableInThisTameRange(employee, ts))
{
isComboWebBookable = false;
break;
}
}
if (isComboWebBookable)
{
var slot2ATs = ORM_PPS_TSK_BOK_BookableTimeSlots_2_AvailabilityType.Query.Search(Connection, Transaction, new ORM_PPS_TSK_BOK_BookableTimeSlots_2_AvailabilityType.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false,
PPS_TSK_BOK_BookableTimeSlot_RefID = slot.PPS_TSK_BOK_BookableTimeSlotID
}).Single();
if (slot2ATs.CMN_CAL_AVA_Availability_TypeID != webAvailabilityType.CMN_CAL_AVA_Availability_TypeID)
{
slot2ATs.CMN_CAL_AVA_Availability_TypeID = webAvailabilityType.CMN_CAL_AVA_Availability_TypeID;
slot2ATs.Save(Connection, Transaction);
}
}
}
}
officeForDelete.IsDeleted = true;
officeForDelete.Save(Connection, Transaction);
}
#endregion
task.Save(Connection, Transaction);
returnValue.Result.ID = task.PPS_TSK_TaskID;
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_WOctoSE_0938 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var should_send_email = false;
var treatment_year_start_date = cls_Get_TreatmentYear.Invoke(Connection, Transaction, new P_CAS_GTY_1125()
{
Date = Parameter.treatment_date,
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id,
}, securityTicket).Result;
var treatment_year_length = cls_Get_TreatmentYearLength.Invoke(Connection, Transaction, new P_CAS_GTYL_1317()
{
Date = Parameter.treatment_date,
PatientID = Parameter.patient_id
}, securityTicket).Result;
var ops_in_treatment_year = cls_Get_OpDates_for_PatientID_and_LocalizationCode_in_TreatmentYear.Invoke(Connection, Transaction, new P_CAS_GOpDfPIDaLCiTY_1110()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id,
TreatmentYearStartDate = treatment_year_start_date,
TreatmentYearEndDate = treatment_year_start_date.AddDays(treatment_year_length - 1)
}, securityTicket).Result;
var existingBillPosition = cls_Get_Existing_OCT_BillPosition_for_PatientID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GEBPfPIDaLC_1803()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result;
if (existingBillPosition != null && existingBillPosition.CaseID == Parameter.case_id)
{
var op_to_reassign_oct_to = ops_in_treatment_year.FirstOrDefault(t => t.CaseID != Parameter.case_id && ((!t.IsPerformed && !t.IsDeleted) || (t.IsPerformed && t.FsStatus != 8 && t.FsStatus != 11 && t.FsStatus != 17)));
if (op_to_reassign_oct_to != null)
{
var caseBillCode = new ORM_HEC_CAS_Case_BillCode();
caseBillCode.Load(Connection, Transaction, existingBillPosition.CaseBillCodeID);
caseBillCode.HEC_CAS_Case_RefID = op_to_reassign_oct_to.CaseID;
caseBillCode.Save(Connection, Transaction);
}
else
{
var oct = Retrieve_Octs.GetOctsWhereFieldsHaveValues(new List <FieldValueParameter>()
{
new FieldValueParameter()
{
FieldName = "case_id", FieldValue = Parameter.case_id.ToString()
}
}, null, securityTicket.TenantID.ToString()).SingleOrDefault();
if (oct != null)
{
var oct_id = Guid.Parse(oct.id);
var oct_planned_action = new ORM_HEC_ACT_PlannedAction();
oct_planned_action.Load(Connection, Transaction, oct_id);
oct_planned_action.IsCancelled = true;
oct_planned_action.Save(Connection, Transaction);
}
}
should_send_email = cls_Get_Active_NonError_OctBillPositionID_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GANEOctBPIDfCID_0925()
{
CaseID = Parameter.case_id
}, securityTicket).Result.Any();
}
if (should_send_email)
{
var performedOcts = cls_Get_PerformedOctDoctorData_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GPOctDDfCID_0935()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
if (performedOcts.Any())
{
var mailToL = new List <String>();
var accountMails = cls_Get_All_Account_LoginEmails_Who_Receive_Notifications.Invoke(Connection, Transaction, securityTicket).Result.ToList();
foreach (var mail in accountMails)
{
mailToL.Add(mail.LoginEmail);
}
var mailToFromCompanySettings = cls_Get_Company_Settings.Invoke(Connection, Transaction, securityTicket).Result.Email;
mailToL.Add(mailToFromCompanySettings);
var patient_details = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPDfPID_1124()
{
PatientID = Parameter.patient_id
}, securityTicket).Result;
var treatment_doctor_details = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = Parameter.op_doctor_id
}, securityTicket).Result.First();
var appName = WebConfigurationManager.AppSettings["mmAppUrl"];
var prefix = HttpContext.Current.Request.Url.AbsoluteUri.Contains("https") ? "https://" : "http://";
var imageUrl = HttpContext.Current.Request.Url.AbsoluteUri.Substring(0, HttpContext.Current.Request.Url.AbsoluteUri.IndexOf("api")) + "Content/images/logo.png";
var email_template = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/TreatmentCancelledFromSettlementPageOctSubmittedEmailTemplate .html"));
var subjectsJson = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/EmailSubjects.json"));
dynamic subjects = JsonConvert.DeserializeObject(subjectsJson);
var subjectMail = subjects["TreatmentCancelledFromSettlementPageSubject"].ToString();
email_template = EmailTemplater.SetTemplateData(email_template, new
{
patient_first_name = patient_details.patient_first_name,
patient_last_name = patient_details.patient_last_name,
treatment_date = Parameter.treatment_date.ToString("dd.MM.yyyy"),
treatment_doctor_title = treatment_doctor_details.title,
treatment_doctor_first_name = treatment_doctor_details.first_name,
treatment_doctor_last_name = treatment_doctor_details.last_name,
octs = performedOcts,
mmapp_treatment_page_url = prefix + HttpContext.Current.Request.Url.Authority + "/" + appName + "/#/treatment",
medios_connect_logo_url = imageUrl
}, "{{", "}}");
try
{
string mailFrom = WebConfigurationManager.AppSettings["mailFrom"];
var mailsDistinct = mailToL.Distinct().ToList();
foreach (var mailTo in mailsDistinct)
{
EmailNotificationSenderUtil.SendEmail(mailFrom, mailTo, subjectMail, email_template);
}
}
catch (Exception ex)
{
LogUtils.Logger.LogDocAppInfo(new LogUtils.LogEntry(System.Reflection.MethodInfo.GetCurrentMethod(), ex, null, "Cancel case from settlement: Email sending failed."), "EmailExceptions");
}
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CAPA_1237 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_HEC_ACT_PlannedAction aftercare_planned_action = new ORM_HEC_ACT_PlannedAction();
aftercare_planned_action.Creation_Timestamp = DateTime.Now;
aftercare_planned_action.HEC_ACT_PlannedActionID = Guid.NewGuid();
aftercare_planned_action.IsPerformed = false;
aftercare_planned_action.MedicalPractice_RefID = Parameter.practice_id;
aftercare_planned_action.Modification_Timestamp = DateTime.Now;
aftercare_planned_action.Patient_RefID = Parameter.patient_id;
aftercare_planned_action.PlannedFor_Date = Parameter.treatment_date;
aftercare_planned_action.Tenant_RefID = securityTicket.TenantID;
Guid id = Guid.Empty;
var aftercare_doctor_account = cls_Get_Doctor_AccountID_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDAIDfDID_1549()
{
DoctorID = Parameter.aftercare_doctor_practice_id
}, securityTicket).Result;
if (aftercare_doctor_account != null)
{
id = aftercare_doctor_account.accountID;
}
else
{
var aftercare_practice_account = cls_Get_Practice_AccountID_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPAIDfPID_1522()
{
PracticeID = Parameter.aftercare_doctor_practice_id
}, securityTicket).Result;
if (aftercare_practice_account != null)
{
id = aftercare_practice_account.accountID;
}
}
ORM_USR_Account.Query aftercare_accountQ = new ORM_USR_Account.Query();
aftercare_accountQ.USR_AccountID = id;
aftercare_accountQ.Tenant_RefID = securityTicket.TenantID;
aftercare_accountQ.IsDeleted = false;
var aftercare_account = ORM_USR_Account.Query.Search(Connection, Transaction, aftercare_accountQ).SingleOrDefault();
if (aftercare_account != null)
{
aftercare_planned_action.ToBePerformedBy_BusinessParticipant_RefID = aftercare_account.BusinessParticipant_RefID;
}
aftercare_planned_action.Save(Connection, Transaction);
ORM_HEC_CAS_Case_RelevantPlannedAction aftercare_planned_action_to_case = new ORM_HEC_CAS_Case_RelevantPlannedAction();
aftercare_planned_action_to_case.Case_RefID = Parameter.case_id;
aftercare_planned_action_to_case.Creation_Timestamp = DateTime.Now;
aftercare_planned_action_to_case.HEC_CAS_Case_RelevantPlannedActionID = Guid.NewGuid();
aftercare_planned_action_to_case.Modification_Timestamp = DateTime.Now;
aftercare_planned_action_to_case.PlannedAction_RefID = aftercare_planned_action.HEC_ACT_PlannedActionID;
aftercare_planned_action_to_case.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_to_case.Save(Connection, Transaction);
ORM_HEC_ACT_ActionType.Query aftercare_planned_action_typeQ = new ORM_HEC_ACT_ActionType.Query();
aftercare_planned_action_typeQ.GlobalPropertyMatchingID = "mm.docconect.doc.app.planned.action.aftercare";
aftercare_planned_action_typeQ.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_typeQ.IsDeleted = false;
var aftercare_planned_action_type_id = Guid.Empty;
var aftercare_planned_action_type = ORM_HEC_ACT_ActionType.Query.Search(Connection, Transaction, aftercare_planned_action_typeQ).SingleOrDefault();
if (aftercare_planned_action_type == null)
{
aftercare_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") ? "nachsorge" : "aftercare";
action_type_name_dict.AddEntry(lang.CMN_LanguageID, content);
}
aftercare_planned_action_type.ActionType_Name = action_type_name_dict;
aftercare_planned_action_type.Creation_Timestamp = DateTime.Now;
aftercare_planned_action_type.GlobalPropertyMatchingID = "mm.docconect.doc.app.planned.action.aftercare";
aftercare_planned_action_type.Modification_Timestamp = DateTime.Now;
aftercare_planned_action_type.HEC_ACT_ActionTypeID = Guid.NewGuid();
aftercare_planned_action_type.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_type.Save(Connection, Transaction);
aftercare_planned_action_type_id = aftercare_planned_action_type.HEC_ACT_ActionTypeID;
}
else
{
aftercare_planned_action_type_id = aftercare_planned_action_type.HEC_ACT_ActionTypeID;
}
ORM_HEC_ACT_PlannedAction_2_ActionType aftercare_planned_action_2_type = new ORM_HEC_ACT_PlannedAction_2_ActionType();
aftercare_planned_action_2_type.Tenant_RefID = securityTicket.TenantID;
aftercare_planned_action_2_type.Creation_Timestamp = DateTime.Now;
aftercare_planned_action_2_type.IsDeleted = false;
aftercare_planned_action_2_type.HEC_ACT_ActionType_RefID = aftercare_planned_action_type_id;
aftercare_planned_action_2_type.HEC_ACT_PlannedAction_RefID = aftercare_planned_action.HEC_ACT_PlannedActionID;
aftercare_planned_action_2_type.Modification_Timestamp = DateTime.Now;
aftercare_planned_action_2_type.HEC_ACT_PlannedAction_2_ActionTypeID = Guid.NewGuid();
aftercare_planned_action_2_type.Save(Connection, Transaction);
returnValue.Result = aftercare_planned_action.HEC_ACT_PlannedActionID;
return(returnValue);
#endregion UserCode
}
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
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_HOCT_1013 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var oct_planned_action_type_id = cls_Get_ActionTypeID.Invoke(Connection, Transaction, new P_CAS_GATID_1514()
{
action_type_gpmid = EActionType.PlannedOct.Value()
}, securityTicket).Result;
var elastic_index = securityTicket.TenantID.ToString();
var oct_performed_action_type_id = cls_Get_ActionTypeID.Invoke(Connection, Transaction, new P_CAS_GATID_1514()
{
action_type_gpmid = EActionType.PerformedOct.Value()
}, securityTicket).Result;
var oct_doctor = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
HEC_DoctorID = Parameter.oct_doctor_id, Tenant_RefID = securityTicket.TenantID, IsDeleted = false
}).SingleOrDefault();
var patient_practice_name = cls_Get_Patient_PracticeName_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPPNfPID_1131()
{
PatientID = Parameter.patient_id
}, securityTicket).Result;
var current_treatment_year_start_date = DateTime.MaxValue;
if (oct_doctor != null)
{
current_treatment_year_start_date = cls_Get_TreatmentYear.Invoke(Connection, Transaction, new P_CAS_GTY_1125()
{
Date = Parameter.treatment_date,
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id,
}, securityTicket).Result;
}
else
{
current_treatment_year_start_date = cls_Get_TreatmentYear.Invoke(Connection, Transaction, new P_CAS_GTY_1125()
{
Date = Parameter.treatment_date,
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result;
}
var treatment_year_length = cls_Get_TreatmentYearLength.Invoke(Connection, Transaction, new P_CAS_GTYL_1317()
{
Date = Parameter.treatment_date,
PatientID = Parameter.patient_id
}, securityTicket).Result;
var current_treatment_year_end_date = current_treatment_year_start_date.AddDays(treatment_year_length - 1);
var oct_gpos_ids = cls_Get_GposIDs_for_GposType.Invoke(Connection, Transaction, new P_MD_GGpoIDsfGposT_1145()
{
GposType = EGposType.Oct.Value()
}, securityTicket).Result;
if (!oct_gpos_ids.Any())
{
return(returnValue);
}
var last_potential_consent = cls_Get_Patient_Consents_before_Date_and_GposIDs.Invoke(Connection, Transaction, new P_PA_GPCbDaGposIDs_1154()
{
Date = Parameter.treatment_date.Date,
GposIDs = oct_gpos_ids.Select(t => t.GposID).ToArray(),
PatientID = Parameter.patient_id
}, securityTicket).Result.FirstOrDefault(t => t.consent_valid_from.Date <= Parameter.treatment_date.Date);
var latest_oct_planned_actions = cls_Get_Latest_PlannedActionID_for_PatientID_ActionTypeID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GLPAIDfPIDATIDaLC_1545()
{
ActionTypeID = oct_planned_action_type_id,
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result;
if (last_potential_consent == null && Parameter.oct_doctor_id != Guid.Empty && latest_oct_planned_actions.Any(t => t.OpDate >= current_treatment_year_start_date.Date && t.OpDate < current_treatment_year_start_date.AddDays(treatment_year_length).Date))
{
var latest_oct_planned_action_id = latest_oct_planned_actions.FirstOrDefault(t => t.CaseID != Parameter.case_id && t.OpDate >= current_treatment_year_start_date.Date && t.OpDate < current_treatment_year_start_date.AddDays(treatment_year_length).Date);
if (latest_oct_planned_action_id == null)
{
latest_oct_planned_action_id = latest_oct_planned_actions.FirstOrDefault(t => t.CaseID == Parameter.case_id && t.OpDate >= current_treatment_year_start_date.Date && t.OpDate < current_treatment_year_start_date.AddDays(treatment_year_length).Date);
}
var latest_oct_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
HEC_ACT_PlannedActionID = latest_oct_planned_action_id.PlannedActionID
}).Single();
}
else
{
var case_properties = cls_Get_Case_Properties_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GCPfCID_1204()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
var oct_planned_action_id = cls_Get_Latest_PlannedActionID_for_CaseID_and_ActionTypeID.Invoke(Connection, Transaction, new P_CAS_GLPAIDfCIDaATID_1635()
{
ActionTypeID = oct_planned_action_type_id,
CaseID = Parameter.case_id
}, securityTicket).Result;
#region Case creation
if (!Parameter.is_submit)
{
var case_fs_statuses = cls_Get_Case_TransmitionCode_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GCTCfCID_1427()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
var op_submitted = case_fs_statuses.Any(t => t.gpos_type == EGposType.Operation.Value());
var latest_oct_planned_action_id = cls_Get_Latest_PlannedActionID_for_PatientID_ActionTypeID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GLPAIDfPIDATIDaLC_1545()
{
ActionTypeID = oct_planned_action_type_id,
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result.FirstOrDefault(t => t.CaseID != Parameter.case_id && t.OpDate >= current_treatment_year_start_date.Date && t.OpDate < current_treatment_year_start_date.AddDays(treatment_year_length).Date);
var properties_to_delete = case_properties.Where(t => t.property_gpmid == ECaseProperty.WithdrawOct.Value() || t.property_gpmid == ECaseProperty.SubmitOctUntilDate.Value());
if (Parameter.withdraw_oct && latest_oct_planned_action_id != null)
{
var latest_oct_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
HEC_ACT_PlannedActionID = latest_oct_planned_action_id.PlannedActionID
}).Single();
if (Parameter.submit_oct_until_date != DateTime.MinValue)
{
cls_Save_Case_Property.Invoke(Connection, Transaction, new P_CAS_SCP_1308()
{
case_id = Parameter.case_id,
property_gpm_id = ECaseProperty.SubmitOctUntilDate.Value(),
property_name = "Submit OCT until date",
property_string_value = String.Format("{0};{1};{2};{3}", Parameter.submit_oct_until_date.ToString("yyyy-MM-ddTHH:mm:ss"), latest_oct_planned_action.ToBePerformedBy_BusinessParticipant_RefID, Parameter.localization, latest_oct_planned_action.HEC_ACT_PlannedActionID)
}, securityTicket);
properties_to_delete = properties_to_delete.Where(t => t.property_gpmid == ECaseProperty.WithdrawOct.Value()).ToList();
}
else if (Parameter.withdraw_oct)
{
cls_Save_Case_Property.Invoke(Connection, Transaction, new P_CAS_SCP_1308()
{
case_id = Parameter.case_id,
property_name = "Withdraw OCT",
property_gpm_id = ECaseProperty.WithdrawOct.Value(),
property_string_value = String.Format("{0}", latest_oct_planned_action.ToBePerformedBy_BusinessParticipant_RefID.ToString())
}, securityTicket);
properties_to_delete = properties_to_delete.Where(t => t.property_gpmid == ECaseProperty.SubmitOctUntilDate.Value()).ToList();
}
}
foreach (var prop in properties_to_delete)
{
ORM_HEC_CAS_Case_UniversalPropertyValue.Query.SoftDelete(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalPropertyValue.Query()
{
HEC_CAS_Case_UniversalPropertyValueID = prop.id
});
}
if (!op_submitted || Parameter.is_documentation)
{
if (oct_planned_action_id != null)
{
var latest_oct_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
HEC_ACT_PlannedActionID = oct_planned_action_id.PlannedActionID
}).Single();
if (Parameter.oct_doctor_id == Guid.Empty)
{
latest_oct_planned_action.IsDeleted = true;
}
else
{
latest_oct_planned_action.ToBePerformedBy_BusinessParticipant_RefID = oct_doctor.BusinessParticipant_RefID;
}
latest_oct_planned_action.Modification_Timestamp = DateTime.Now;
latest_oct_planned_action.Save(Connection, Transaction);
returnValue.Result = latest_oct_planned_action.HEC_ACT_PlannedActionID;
#region localization changed
if (Parameter.localization_changed)
{
var old_localization = Parameter.localization == "L" ? "R" : "L";
var latest_new_localization_oct_bill_position = cls_Get_Existing_OCT_BillPosition_for_PatientID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GEBPfPIDaLC_1803()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result;
var latest_old_localization_op = cls_Get_OpDates_for_PatientID_and_LocalizationCode_in_TreatmentYear.Invoke(Connection, Transaction, new P_CAS_GOpDfPIDaLCiTY_1110()
{
LocalizationCode = old_localization,
PatientID = Parameter.patient_id,
TreatmentYearEndDate = DateTime.Now
}, securityTicket).Result.FirstOrDefault();
if (latest_new_localization_oct_bill_position != null && latest_new_localization_oct_bill_position.CaseID == Parameter.case_id)
{
if (latest_old_localization_op == null)
{
// check if case has pending oct
var case_has_pending_oct = cls_Get_CaseIDs_with_Pending_Octs_for_PatientID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GCIDswPOctsfPIDaLC_1103()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result.Any(t => t.case_id == Parameter.case_id);
if (case_has_pending_oct)
{
throw new Exception(String.Format("Case has a pending OCT attached and there isn't another IVOM to transfer OCT to. Localization cannot be changed. Case id: {0}", Parameter.case_id));
}
}
else
{
var case_details = cls_Get_Case_Details_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GCDfCID_1435()
{
CaseID = latest_old_localization_op.CaseID
}, securityTicket).Result;
cls_Calculate_Case_GPOS.Invoke(Connection, Transaction, new P_CAS_CCGPOS_1000()
{
case_id = latest_old_localization_op.CaseID,
diagnose_id = case_details.diagnose_id,
drug_id = case_details.drug_id,
patient_id = case_details.patient_id,
localization = case_details.localization,
treatment_date = case_details.treatment_date,
oct_doctor_id = Parameter.oct_doctor_id
}, securityTicket);
}
}
var new_localization_oct_bill_position = cls_Get_Existing_OCT_BillPosition_for_PatientID_and_LocalizationCode_where_not_CaseID.Invoke(Connection, Transaction, new P_CAS_GEBPfPIDaLCwnCID_1438()
{
CaseID = Parameter.case_id,
PatientID = Parameter.patient_id,
LocalizationCode = Parameter.localization
}, securityTicket).Result;
if (new_localization_oct_bill_position != null)
{
cls_Delete_BillingData_for_BillPositionID.Invoke(Connection, Transaction, new P_CAS_DBDfHBPID_1549()
{
bill_position_id = new_localization_oct_bill_position.BillPositionID
}, securityTicket);
}
}
#endregion
}
else if (Parameter.oct_doctor_id != Guid.Empty)
{
var existing_rejection_properties = cls_Get_Localizations_where_Oct_Rejected.Invoke(Connection, Transaction, new P_CAS_GLwOctR_1026()
{
PatientID = Parameter.patient_id,
RejectedOctPropertyID = ECaseProperty.HasRejectedOct.Value()
}, securityTicket).Result;
foreach (var existing_rejection_property in existing_rejection_properties.Where(t => t.localization == Parameter.localization))
{
ORM_HEC_CAS_Case_UniversalPropertyValue.Query.SoftDelete(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalPropertyValue.Query()
{
HEC_CAS_Case_UniversalPropertyValueID = existing_rejection_property.property_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
}
returnValue = cls_Create_OCT.Invoke(Connection, Transaction, new P_CAS_COCT_1703()
{
case_id = Parameter.case_id,
oct_action_type_id = oct_planned_action_type_id,
oct_bpt_id = oct_doctor.BusinessParticipant_RefID,
patient_id = Parameter.patient_id,
treatment_date = Parameter.treatment_date,
practice_id = Parameter.oct_doctor_practice_id
}, securityTicket);
var existingBillPosition = cls_Get_Existing_OCT_BillPosition_for_PatientID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GEBPfPIDaLC_1803()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result;
if (existingBillPosition == null)
{
cls_Calculate_Case_GPOS.Invoke(Connection, Transaction, new P_CAS_CCGPOS_1000()
{
case_id = Parameter.case_id,
diagnose_id = Parameter.diagnose_id,
drug_id = Parameter.drug_id,
patient_id = Parameter.patient_id,
localization = Parameter.localization,
treatment_date = Parameter.treatment_date,
oct_doctor_id = Parameter.oct_doctor_id
}, securityTicket);
}
else
{
cls_Delete_BillingData_for_BillPositionID.Invoke(Connection, Transaction, new P_CAS_DBDfHBPID_1549()
{
bill_position_id = existingBillPosition.BillPositionID
}, securityTicket);
var isAutoGenerated = cls_Get_CasePropertyValue_for_CaseIDs_and_CasePropertyGpmID.Invoke(Connection, Transaction, new P_CAS_GCPVfCIDsaCGpmID_0832()
{
CaseIDs = new Guid[] { existingBillPosition.CaseID },
IncludeDeleted = true,
PropertyGpmID = ECaseProperty.MissingIvom.Value()
}, securityTicket).Result.Any();
var octIds = new List <Guid>();
if (isAutoGenerated)
{
var caseBillCodeIds = cls_Get_CaseBillCodeIDs_for_GposType_and_CaseID.Invoke(Connection, Transaction, new P_CAS_GCBCIDsfGposTaCID_1622()
{
CaseID = existingBillPosition.CaseID,
OctGposType = EGposType.Oct.Value()
}, securityTicket).Result;
foreach (var caseBillCodeId in caseBillCodeIds)
{
var caseBillCode = new ORM_HEC_CAS_Case_BillCode();
caseBillCode.Load(Connection, Transaction, caseBillCodeId.HEC_CAS_Case_BillCodeID);
caseBillCode.HEC_CAS_Case_RefID = Parameter.case_id;
caseBillCode.Modification_Timestamp = DateTime.Now;
caseBillCode.Save(Connection, Transaction);
}
var relevantActions = ORM_HEC_CAS_Case_RelevantPlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_RelevantPlannedAction.Query()
{
Case_RefID = existingBillPosition.CaseID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
foreach (var relevantAction in relevantActions)
{
relevantAction.Case_RefID = Parameter.case_id;
relevantAction.Modification_Timestamp = DateTime.Now;
relevantAction.Save(Connection, Transaction);
octIds.Add(relevantAction.PlannedAction_RefID);
}
}
cls_Calculate_Case_GPOS.Invoke(Connection, Transaction, new P_CAS_CCGPOS_1000()
{
case_id = Parameter.case_id,
diagnose_id = Parameter.diagnose_id,
drug_id = Parameter.drug_id,
patient_id = Parameter.patient_id,
localization = Parameter.localization,
treatment_date = Parameter.treatment_date,
oct_doctor_id = Parameter.oct_doctor_id
}, securityTicket);
}
}
}
else if (Parameter.localization_changed)
{
var old_localization = Parameter.localization == "L" ? "R" : "L";
#region OCT e-mail
var patient_consent_valid_for_months_parameter = cls_Get_ConsentValidForMonths_for_LatestConsent_before_TreatmentDate_for_PatientID.Invoke(Connection, Transaction, new P_PA_GCVfMfLCbTDfPID_0930()
{
PatientID = Parameter.patient_id,
TreatmentDate = Parameter.treatment_date.Date
}, securityTicket).Result;
var performedOcts = cls_Get_NonCancelledOcts_in_OpRenewedConsentTimespan.Invoke(Connection, Transaction, new P_CAS_GNCOctsiOPRCT_1416()
{
PatientID = Parameter.patient_id,
PlannedOctActionTypeID = oct_planned_action_type_id,
ConsentStart = Parameter.treatment_date.Date,
ConsentEnd = Parameter.treatment_date.Date.AddMonths(patient_consent_valid_for_months_parameter != null && patient_consent_valid_for_months_parameter.consent_valid_for_months < 200000 ? Convert.ToInt32(patient_consent_valid_for_months_parameter.consent_valid_for_months) : 12)
}, securityTicket).Result.Where(t => t.localization == old_localization).ToList();
if (performedOcts.Any())
{
var mailToL = new List <String>();
var accountMails = cls_Get_All_Account_LoginEmails_Who_Receive_Notifications.Invoke(Connection, Transaction, securityTicket).Result.ToList();
foreach (var mail in accountMails)
{
mailToL.Add(mail.LoginEmail);
}
var mailToFromCompanySettings = cls_Get_Company_Settings.Invoke(Connection, Transaction, securityTicket).Result.Email;
mailToL.Add(mailToFromCompanySettings);
var appName = WebConfigurationManager.AppSettings["mmAppUrl"];
var prefix = HttpContext.Current.Request.Url.AbsoluteUri.Contains("https") ? "https://" : "http://";
var imageUrl = HttpContext.Current.Request.Url.AbsoluteUri.Substring(0, HttpContext.Current.Request.Url.AbsoluteUri.IndexOf("api")) + "Content/images/logo.png";
var email_template = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/TreatmentCancelledFromSettlementPageOctSubmittedEmailTemplate .html"));
var subjectsJson = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/EmailSubjects.json"));
dynamic subjects = JsonConvert.DeserializeObject(subjectsJson);
var subjectMail = subjects["TreatmentCancelledFromSettlementPageSubject"].ToString();
var patient_information = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPDfPID_1124()
{
PatientID = Parameter.patient_id
}, securityTicket).Result;
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.First();
email_template = EmailTemplater.SetTemplateData(email_template, new
{
patient_first_name = patient_information.patient_first_name,
patient_last_name = patient_information.patient_last_name,
treatment_date = Parameter.treatment_date.ToString("dd.MM.yyyy"),
treatment_doctor_title = treatment_doctor_details.title,
treatment_doctor_first_name = treatment_doctor_details.first_name,
treatment_doctor_last_name = treatment_doctor_details.last_name,
octs = performedOcts,
mmapp_treatment_page_url = prefix + HttpContext.Current.Request.Url.Authority + "/" + appName + "/#/treatment",
medios_connect_logo_url = imageUrl
}, "{{", "}}");
try
{
string mailFrom = WebConfigurationManager.AppSettings["mailFrom"];
var mailsDistinct = mailToL.Distinct().ToList();
foreach (var mailTo in mailsDistinct)
{
EmailNotificationSenderUtil.SendEmail(mailFrom, mailTo, subjectMail, email_template);
}
}
catch (Exception ex)
{
LogUtils.Logger.LogDocAppInfo(new LogUtils.LogEntry(System.Reflection.MethodInfo.GetCurrentMethod(), ex, null, "Cancel case from settlement: Email sending failed."), "EmailExceptions");
}
}
#endregion
#region OCT withdrawal
var existing_open_bill_position = cls_Get_Existing_OCT_BillPosition_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GEBPfCID_1522()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
if (existing_open_bill_position != null)
{
var non_performed_oct = cls_Get_NonPerformed_Oct_for_CaseID_and_PlannedActionTypeID.Invoke(Connection, Transaction, new P_CAS_GNPOctfCIDaPATID_1240()
{
CaseID = Parameter.case_id,
OctPlannedActionTypeID = oct_planned_action_type_id
}, securityTicket).Result;
var oct_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
HEC_ACT_PlannedActionID = non_performed_oct.action_id
}).Single();
oct_planned_action.IsCancelled = true;
oct_planned_action.Modification_Timestamp = DateTime.Now;
oct_planned_action.Save(Connection, Transaction);
var new_id = cls_Create_OCT.Invoke(Connection, Transaction, new P_CAS_COCT_1703()
{
case_id = Parameter.case_id,
oct_action_type_id = oct_planned_action_type_id,
oct_bpt_id = oct_doctor.BusinessParticipant_RefID,
patient_id = Parameter.patient_id,
practice_id = Parameter.oct_doctor_practice_id,
treatment_date = Parameter.treatment_date
}, securityTicket).Result;
}
#endregion
}
}
#endregion
#region Case submission
else
{
var existingBillPosition = cls_Get_Existing_OCT_BillPosition_for_PatientID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GEBPfPIDaLC_1803()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result;
if (existingBillPosition != null)
{
var oct_planned_actions = cls_Get_Latest_PlannedActionID_for_PatientID_ActionTypeID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GLPAIDfPIDATIDaLC_1545()
{
ActionTypeID = oct_planned_action_type_id,
PatientID = Parameter.patient_id,
LocalizationCode = Parameter.localization
}, securityTicket).Result;
var oct = new Oct_Model();
#region Magic
// don't ask
var i = 0;
do
{
var oct_planned_action = oct_planned_actions[i++];
oct = Retrieve_Octs.GetOctForID(oct_planned_action.PlannedActionID.ToString(), elastic_index);
returnValue.Result = oct_planned_action.PlannedActionID;
} while (i < oct_planned_actions.Length && oct == null);
#endregion
if (oct != null)
{
if (case_properties.Any(t => t.property_gpmid == ECaseProperty.WithdrawOct.Value() || t.property_gpmid == ECaseProperty.SubmitOctUntilDate.Value()))
{
var withdraw_oct_property = case_properties.SingleOrDefault(t => t.property_gpmid == ECaseProperty.WithdrawOct.Value());
if (withdraw_oct_property != null)
{
var doctor_whose_oct_is_withdrawn_bpt_id = Guid.Parse(withdraw_oct_property.string_value);
var planned_oct_to_withdraw = oct_planned_actions.First(t => t.CaseID != Parameter.case_id && t.DoctorBptID == doctor_whose_oct_is_withdrawn_bpt_id);
var planned_oct_action = new ORM_HEC_ACT_PlannedAction();
planned_oct_action.Load(Connection, Transaction, planned_oct_to_withdraw.PlannedActionID);
planned_oct_action.IsCancelled = true;
planned_oct_action.Modification_Timestamp = DateTime.Now;
planned_oct_action.Save(Connection, Transaction);
}
}
else
{
var oct_doctor_bpt_id = ORM_HEC_Doctor.Query.Search(Connection, Transaction, new ORM_HEC_Doctor.Query()
{
HEC_DoctorID = Parameter.oct_doctor_id
}).Single().BusinessParticipant_RefID;
var oct_planned = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction.Query()
{
HEC_ACT_PlannedActionID = returnValue.Result
}).Single();
oct_planned.ToBePerformedBy_BusinessParticipant_RefID = oct_doctor_bpt_id;
oct_planned.Modification_Timestamp = DateTime.Now;
oct_planned.Save(Connection, Transaction);
if (oct.status == "OCT6")
{
var case_with_pending_oct = cls_Get_CaseIDs_with_Pending_Octs_for_PatientID_and_LocalizationCode.Invoke(Connection, Transaction, new P_CAS_GCIDswPOctsfPIDaLC_1103()
{
LocalizationCode = Parameter.localization,
PatientID = Parameter.patient_id
}, securityTicket).Result.SingleOrDefault();
if (case_with_pending_oct != null)
{
var fs_status = ORM_BIL_BillPosition_TransmitionStatus.Query.Search(Connection, Transaction, new ORM_BIL_BillPosition_TransmitionStatus.Query()
{
BIL_BillPosition_TransmitionStatusID = case_with_pending_oct.fs_status_id
}).Single();
fs_status.IsActive = false;
fs_status.Modification_Timestamp = DateTime.Now;
fs_status.Save(Connection, Transaction);
var new_fs_status = new ORM_BIL_BillPosition_TransmitionStatus();
new_fs_status.IsActive = true;
new_fs_status.IsTransmitionStatusManuallySet = false;
new_fs_status.BillPosition_RefID = fs_status.BillPosition_RefID;
new_fs_status.Modification_Timestamp = DateTime.Now;
new_fs_status.Tenant_RefID = securityTicket.TenantID;
new_fs_status.TransmissionDataXML = fs_status.TransmissionDataXML;
new_fs_status.TransmitionCode = 1;
new_fs_status.TransmitionStatusKey = "oct";
new_fs_status.TransmittedOnDate = DateTime.Now;
new_fs_status.Save(Connection, Transaction);
}
}
}
}
}
}
#endregion
}
return(returnValue);
#endregion UserCode
}
