protected static FR_CAS_CDO_1250 Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CDO_1250 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_CAS_CDO_1250();
returnValue.Result = new CAS_CDO_1250();
//Put your code here
var treatment_planned_action_id = cls_Get_Treatment_Planned_Action_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GTPAfCID_0946()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
var drug_order_status_latestQ = new ORM_ORD_PRC_ProcurementOrder_Status.Query();
drug_order_status_latestQ.ORD_PRC_ProcurementOrder_StatusID = Parameter.ord_drug_order_header.Current_ProcurementOrderStatus_RefID;
drug_order_status_latestQ.Tenant_RefID = securityTicket.TenantID;
drug_order_status_latestQ.IsDeleted = false;
var drug_order_status_latest = ORM_ORD_PRC_ProcurementOrder_Status.Query.Search(Connection, Transaction, drug_order_status_latestQ).SingleOrDefault();
if (drug_order_status_latest.Status_Code == 6)
{
var previous_status = cls_Get_Previous_Order_Status_for_HeaderID.Invoke(Connection, Transaction, new P_OR_GPOSfHID_1347()
{
HeaderID = Parameter.ord_drug_order_header.ORD_PRC_ProcurementOrder_HeaderID
}, securityTicket).Result;
returnValue.Result.previous_status = previous_status != null ? "MO" + previous_status.OrderStatus : "";
}
else
{
returnValue.Result.previous_status = "MO" + drug_order_status_latest.Status_Code;
}
var cancellation_code = drug_order_status_latest.Status_Code == 0 ? 9 : 6;
var cancellation_status = String.Format("MO{0}", cancellation_code);
var new_status = new ORM_ORD_PRC_ProcurementOrder_Status();
new_status.Status_Code = cancellation_code;
new_status.GlobalPropertyMatchingID = String.Format("mm.doc.connect.drug.order.status.{0}", cancellation_status.ToLower());
new_status.Tenant_RefID = securityTicket.TenantID;
new_status.Modification_Timestamp = DateTime.Now;
Parameter.ord_drug_order_header.Current_ProcurementOrderStatus_RefID = new_status.ORD_PRC_ProcurementOrder_StatusID;
Parameter.ord_drug_order_header.Save(Connection, Transaction);
new_status.Status_Name = new Dict(ORM_ORD_PRC_ProcurementOrder_Status.TableName);
foreach (var lang in Parameter.all_languagesL)
{
new_status.Status_Name.AddEntry(lang.CMN_LanguageID, cancellation_status);
}
new_status.Save(Connection, Transaction);
var new_status_history_entry = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
new_status_history_entry.IsStatus_Canceled = true;
new_status_history_entry.Tenant_RefID = securityTicket.TenantID;
new_status_history_entry.Modification_Timestamp = DateTime.Now;
new_status_history_entry.ProcurementOrder_Header_RefID = Parameter.ord_drug_order_header.ORD_PRC_ProcurementOrder_HeaderID;
new_status_history_entry.ProcurementOrder_Status_RefID = new_status.ORD_PRC_ProcurementOrder_StatusID;
new_status_history_entry.TriggeredAt_Date = DateTime.Now;
new_status_history_entry.TriggeredBy_BusinessParticipant_RefID = Parameter.created_by_bpt;
new_status_history_entry.Save(Connection, Transaction);
var ord_drug_order_position_history_entry = new ORM_ORD_PRC_ProcurementOrder_Position_History();
ord_drug_order_position_history_entry.Tenant_RefID = securityTicket.TenantID;
ord_drug_order_position_history_entry.ProcurementOrder_Position_RefID = Parameter.procurement_order_position_id;
ord_drug_order_position_history_entry.IsRemoved = true;
ord_drug_order_position_history_entry.Modification_Timestamp = DateTime.Now;
ord_drug_order_position_history_entry.Save(Connection, Transaction);
var practice_invoice_universal_property = ORM_HEC_CAS_Case_UniversalProperty.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalProperty.Query()
{
GlobalPropertyMatchingID = "mm.doc.connect.case.practice.invoice",
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
var practice_invoice_universal_property_value = ORM_HEC_CAS_Case_UniversalPropertyValue.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalPropertyValue.Query()
{
HEC_CAS_Case_UniversalProperty_RefID = practice_invoice_universal_property.HEC_CAS_Case_UniversalPropertyID,
HEC_CAS_Case_RefID = Parameter.case_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (practice_invoice_universal_property_value != null)
{
practice_invoice_universal_property_value.IsDeleted = true;
practice_invoice_universal_property_value.Modification_Timestamp = DateTime.Now;
practice_invoice_universal_property_value.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_CAS_CDO_1202 Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CDO_1202 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_CAS_CDO_1202();
returnValue.Result = new CAS_CDO_1202();
//Put your code here
var statusCodePrefix = "MO";
var statusCode = 0;
var drugOrderStatus = String.Format("{0}{1}", statusCodePrefix, statusCode);
var hec_drugQ = new ORM_HEC_Product.Query();
hec_drugQ.Tenant_RefID = securityTicket.TenantID;
hec_drugQ.IsDeleted = false;
hec_drugQ.HEC_ProductID = Parameter.drug_id;
var hec_drug = ORM_HEC_Product.Query.Search(Connection, Transaction, hec_drugQ).SingleOrDefault();
if (hec_drug != null)
{
var ord_drug_order_header = new ORM_ORD_PRC_ProcurementOrder_Header();
ord_drug_order_header.CreatedBy_BusinessParticipant_RefID = Parameter.created_by_bpt;
ord_drug_order_header.ProcurementOrder_Date = DateTime.Now;
ord_drug_order_header.Tenant_RefID = securityTicket.TenantID;
ord_drug_order_header.ProcurementOrder_Number = cls_Get_Next_Order_Number.Invoke(Connection, Transaction, securityTicket).Result.order_number;
returnValue.Result.procurement_order_header_id = ord_drug_order_header.ORD_PRC_ProcurementOrder_HeaderID;
var drug_order_status = new ORM_ORD_PRC_ProcurementOrder_Status();
drug_order_status.GlobalPropertyMatchingID = String.Format("mm.doc.connect.drug.order.status.{0}", drugOrderStatus.ToLower());
drug_order_status.Status_Code = statusCode;
drug_order_status.Tenant_RefID = securityTicket.TenantID;
drug_order_status.Status_Name = new Dict(ORM_ORD_PRC_ProcurementOrder_Status.TableName);
foreach (var lang in Parameter.all_languagesL)
{
drug_order_status.Status_Name.AddEntry(lang.CMN_LanguageID, drugOrderStatus);
}
drug_order_status.Save(Connection, Transaction);
ord_drug_order_header.Current_ProcurementOrderStatus_RefID = drug_order_status.ORD_PRC_ProcurementOrder_StatusID;
ord_drug_order_header.Save(Connection, Transaction);
var drug_order_status_history = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
drug_order_status_history.ProcurementOrder_Header_RefID = ord_drug_order_header.ORD_PRC_ProcurementOrder_HeaderID;
drug_order_status_history.ProcurementOrder_Status_RefID = drug_order_status.ORD_PRC_ProcurementOrder_StatusID;
drug_order_status_history.Tenant_RefID = securityTicket.TenantID;
drug_order_status_history.IsStatus_Created = true;
drug_order_status_history.TriggeredAt_Date = DateTime.Now;
drug_order_status_history.TriggeredBy_BusinessParticipant_RefID = Parameter.created_by_bpt;
drug_order_status_history.Save(Connection, Transaction);
var ord_drug_order_position = new ORM_ORD_PRC_ProcurementOrder_Position();
ord_drug_order_position.CMN_PRO_Product_RefID = hec_drug.Ext_PRO_Product_RefID;
ord_drug_order_position.Position_RequestedDateOfDelivery = Parameter.delivery_date;
ord_drug_order_position.ProcurementOrder_Header_RefID = ord_drug_order_header.ORD_PRC_ProcurementOrder_HeaderID;
ord_drug_order_position.Tenant_RefID = securityTicket.TenantID;
ord_drug_order_position.RequestedDateOfDelivery_TimeFrame_From = Parameter.is_alternative_delivery_date ? Parameter.alternative_delivery_date_from : Parameter.treatment_date.AddHours(08).AddMinutes(00).AddSeconds(00);
ord_drug_order_position.RequestedDateOfDelivery_TimeFrame_To = Parameter.is_alternative_delivery_date ? Parameter.alternative_delivery_date_to : Parameter.treatment_date.AddHours(17).AddMinutes(59).AddSeconds(59);
ord_drug_order_position.IsProFormaOrderPosition = Parameter.is_label_only;
ord_drug_order_position.Position_Comment = Parameter.order_comment;
if (Parameter.is_send_invoice_to_practice)
{
var id = Guid.Empty;
var practice_account = cls_Get_Practice_AccountID_for_PracticeID.Invoke(Connection, Transaction, new P_DO_GPAIDfPID_1351()
{
PracticeID = Parameter.practice_id
}, securityTicket).Result;
if (practice_account != null)
{
id = practice_account.accountID;
}
var invoice_practice_accountQ = new ORM_USR_Account.Query();
invoice_practice_accountQ.USR_AccountID = id;
invoice_practice_accountQ.Tenant_RefID = securityTicket.TenantID;
invoice_practice_accountQ.IsDeleted = false;
var invoice_practice_account = ORM_USR_Account.Query.Search(Connection, Transaction, invoice_practice_accountQ).SingleOrDefault();
if (invoice_practice_account != null)
{
ord_drug_order_position.BillTo_BusinessParticipant_RefID = invoice_practice_account.BusinessParticipant_RefID;
}
}
ord_drug_order_position.Save(Connection, Transaction);
var ord_drug_order_history = new ORM_ORD_PRC_ProcurementOrder_Position_History();
ord_drug_order_history.Creation_Timestamp = DateTime.Now;
ord_drug_order_history.IsCreated = true;
ord_drug_order_history.Modification_Timestamp = DateTime.Now;
ord_drug_order_history.Tenant_RefID = securityTicket.TenantID;
ord_drug_order_history.TriggeredBy_BusinessParticipant_RefID = Parameter.created_by_bpt;
ord_drug_order_history.ProcurementOrder_Position_RefID = ord_drug_order_position.ORD_PRC_ProcurementOrder_PositionID;
ord_drug_order_history.Save(Connection, Transaction);
var hec_drug_order_position = new ORM_HEC_PRC_ProcurementOrder_Position();
hec_drug_order_position.Creation_Timestamp = DateTime.Now;
hec_drug_order_position.Ext_ORD_PRC_ProcurementOrder_Position_RefID = ord_drug_order_position.ORD_PRC_ProcurementOrder_PositionID;
hec_drug_order_position.Modification_Timestamp = DateTime.Now;
hec_drug_order_position.OrderedFor_Patient_RefID = Parameter.patient_id;
hec_drug_order_position.Tenant_RefID = securityTicket.TenantID;
hec_drug_order_position.IfProFormaOrderPosition_PrintLabelOnly = Parameter.is_label_only;
hec_drug_order_position.IsOrderForPatient_PatientFeeWaived = Parameter.is_patient_fee_waived;
if (Parameter.treatment_doctor_id != Guid.Empty)
{
hec_drug_order_position.OrderedFor_Doctor_RefID = Parameter.treatment_doctor_id;
hec_drug_order_position.OrderedForDoctor_DisplayName = GenericUtils.GetDoctorName(Parameter.treatment_doctor_details);
}
else
{
var doctor_id = cls_Get_DoctorID_for_AccountID.Invoke(Connection, Transaction, securityTicket).Result;
if (doctor_id != null)
{
var doctor = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = doctor_id.DoctorID
}, securityTicket).Result.SingleOrDefault();
if (doctor != null)
{
hec_drug_order_position.OrderedFor_Doctor_RefID = doctor.id;
hec_drug_order_position.OrderedForDoctor_DisplayName = GenericUtils.GetDoctorName(doctor);
}
}
}
hec_drug_order_position.OrderedForPatient_DisplayName = Parameter.patient_details.patient_last_name + " " + Parameter.patient_details.patient_first_name;
hec_drug_order_position.Save(Connection, Transaction);
returnValue.Result.procurement_order_position_id = hec_drug_order_position.HEC_PRC_ProcurementOrder_PositionID;
var practice_invoice_universal_property = ORM_HEC_CAS_Case_UniversalProperty.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalProperty.Query()
{
GlobalPropertyMatchingID = "mm.doc.connect.case.practice.invoice",
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (practice_invoice_universal_property == null)
{
practice_invoice_universal_property = new ORM_HEC_CAS_Case_UniversalProperty();
practice_invoice_universal_property.Tenant_RefID = securityTicket.TenantID;
practice_invoice_universal_property.PropertyName = "Send Invoice to Practice";
practice_invoice_universal_property.IsValue_Boolean = true;
practice_invoice_universal_property.GlobalPropertyMatchingID = "mm.doc.connect.case.practice.invoice";
practice_invoice_universal_property.Modification_Timestamp = DateTime.Now;
practice_invoice_universal_property.Save(Connection, Transaction);
}
var practice_invoice_universal_property_value = ORM_HEC_CAS_Case_UniversalPropertyValue.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalPropertyValue.Query()
{
HEC_CAS_Case_RefID = Parameter.case_id,
HEC_CAS_Case_UniversalProperty_RefID = practice_invoice_universal_property.HEC_CAS_Case_UniversalPropertyID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).SingleOrDefault();
if (practice_invoice_universal_property_value == null)
{
practice_invoice_universal_property_value = new ORM_HEC_CAS_Case_UniversalPropertyValue();
practice_invoice_universal_property_value.Tenant_RefID = securityTicket.TenantID;
practice_invoice_universal_property_value.HEC_CAS_Case_RefID = Parameter.case_id;
practice_invoice_universal_property_value.HEC_CAS_Case_UniversalProperty_RefID = practice_invoice_universal_property.HEC_CAS_Case_UniversalPropertyID;
}
practice_invoice_universal_property_value.Modification_Timestamp = DateTime.Now;
practice_invoice_universal_property_value.Value_Boolean = Parameter.is_send_invoice_to_practice;
practice_invoice_universal_property_value.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
