protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_CC_1641 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
var case_to_cancel = cls_Get_Case_Details_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GCDfCID_1435()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
returnValue.Result = case_to_cancel.patient_id;
var drug_order_details = cls_Get_DrugOrderIDs_for_PlannedActionID.Invoke(Connection, Transaction, new P_CAS_GDOIDsfPAID_1243()
{
PlannedActionID = case_to_cancel.treatment_planned_action_id
}, securityTicket).Result;
var 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 trigger_accQ = new ORM_USR_Account.Query();
trigger_accQ.Tenant_RefID = securityTicket.TenantID;
trigger_accQ.USR_AccountID = securityTicket.AccountID;
trigger_accQ.IsDeleted = false;
var delete_drug_order = false;
var cancel_order = false;
var drug_order_header_id = Guid.Empty;
var trigger_acc = ORM_USR_Account.Query.Search(Connection, Transaction, trigger_accQ).SingleOrDefault();
var op_planned_action_id = Guid.Empty;
string previous_status = "";
var planned_action = cls_Get_Treatment_Planned_Action_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GTPAfCID_0946()
{
CaseID = Parameter.case_id
}, securityTicket).Result;
if (planned_action != null)
{
op_planned_action_id = planned_action.planned_action_id;
var drug_order_ids = cls_Get_DrugOrderIDs_for_PlannedActionID.Invoke(Connection, Transaction, new P_CAS_GDOIDsfPAID_1243()
{
PlannedActionID = planned_action.planned_action_id
}, securityTicket).Result;
if (drug_order_ids != null)
{
var ord_drug_order_headerQ = new ORM_ORD_PRC_ProcurementOrder_Header.Query();
ord_drug_order_headerQ.Tenant_RefID = securityTicket.TenantID;
ord_drug_order_headerQ.IsDeleted = false;
ord_drug_order_headerQ.ORD_PRC_ProcurementOrder_HeaderID = drug_order_ids.ORD_PRC_ProcurementOrder_HeaderID;
var ord_drug_order_header = ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction, ord_drug_order_headerQ).SingleOrDefault();
var existing_treatment_planned_action_required_product = ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct.Query()
{
HEC_ACT_PlannedAction_PotentialProcedure_RequiredProductID = drug_order_ids.HEC_ACT_PlannedAction_PotentialProcedure_RequiredProductID
}).Single();
if (Parameter.cancel_drug_order)
{
if (ord_drug_order_header != null)
{
drug_order_header_id = ord_drug_order_header.ORD_PRC_ProcurementOrder_HeaderID;
var drug_order_status_latest = ORM_ORD_PRC_ProcurementOrder_Status.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Status.Query()
{
ORD_PRC_ProcurementOrder_StatusID = ord_drug_order_header.Current_ProcurementOrderStatus_RefID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
previous_status = cls_Cancel_Drug_Order.Invoke(Connection, Transaction, new P_CAS_CDO_1250()
{
all_languagesL = all_languagesL,
created_by_bpt = trigger_acc.BusinessParticipant_RefID,
ord_drug_order_header = ord_drug_order_header,
procurement_order_position_id = drug_order_ids.HEC_PRC_ProcurementOrder_PositionID,
case_id = Parameter.case_id
}, securityTicket).Result.previous_status;
delete_drug_order = previous_status == "MO0";
cancel_order = !delete_drug_order && previous_status != "MO9";
}
}
}
}
if (Parameter.cancel_treatment)
{
var treatment_planned_actionQ = new ORM_HEC_ACT_PlannedAction.Query();
treatment_planned_actionQ.HEC_ACT_PlannedActionID = case_to_cancel.treatment_planned_action_id;
treatment_planned_actionQ.IsDeleted = false;
treatment_planned_actionQ.IsCancelled = false;
treatment_planned_actionQ.IsPerformed = false;
treatment_planned_actionQ.Tenant_RefID = securityTicket.TenantID;
var treatment_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, treatment_planned_actionQ).SingleOrDefault();
if (treatment_planned_action != null)
{
treatment_planned_action.IsCancelled = true;
treatment_planned_action.Save(Connection, Transaction);
}
var aftercare_planned_actionQ = new ORM_HEC_ACT_PlannedAction.Query();
aftercare_planned_actionQ.HEC_ACT_PlannedActionID = case_to_cancel.aftercare_planned_action_id;
aftercare_planned_actionQ.IsDeleted = false;
aftercare_planned_actionQ.IsCancelled = false;
aftercare_planned_actionQ.IsPerformed = false;
aftercare_planned_actionQ.Tenant_RefID = securityTicket.TenantID;
var aftercare_planned_action = ORM_HEC_ACT_PlannedAction.Query.Search(Connection, Transaction, treatment_planned_actionQ).SingleOrDefault();
if (aftercare_planned_action != null)
{
aftercare_planned_action.IsCancelled = true;
aftercare_planned_action.Save(Connection, Transaction);
}
var cancelled_caseQ = new ORM_HEC_CAS_Case.Query();
cancelled_caseQ.HEC_CAS_CaseID = Parameter.case_id;
cancelled_caseQ.Tenant_RefID = securityTicket.TenantID;
cancelled_caseQ.IsDeleted = false;
var cancelled_case = ORM_HEC_CAS_Case.Query.Search(Connection, Transaction, cancelled_caseQ).SingleOrDefault();
if (cancelled_case != null)
{
cls_Withdraw_OCT_or_Send_Email.Invoke(Connection, Transaction, new P_CAS_WOctoSE_0938()
{
case_id = Parameter.case_id,
op_doctor_id = case_to_cancel.op_doctor_id,
patient_id = case_to_cancel.patient_id,
localization = case_to_cancel.localization,
diagnose_id = case_to_cancel.diagnose_id,
drug_id = case_to_cancel.drug_id,
oct_doctor_id = case_to_cancel.oct_doctor_id,
treatment_date = case_to_cancel.treatment_date
}, securityTicket);
cancelled_case.IsDeleted = true;
cancelled_case.Save(Connection, Transaction);
}
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6TR_SaOQTwPO_1620 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
P_L6TR_SQT_1308 param = new P_L6TR_SQT_1308();
param = Parameter.QuickTreatment;
Guid TreatmentID = cls_Save_Quick_Treatment.Invoke(Connection, Transaction, param, securityTicket).Result;
#region Save Order
var status_query = new ORM_ORD_PRC_ProcurementOrder_Status.Query();
status_query.IsDeleted = false;
status_query.Tenant_RefID = securityTicket.TenantID;
status_query.GlobalPropertyMatchingID = STLD_ORD_CUO_CustomerOrder_Status.Ordered.ToString();
var notOrderedstatus = ORM_ORD_PRC_ProcurementOrder_Status.Query.Search(Connection, Transaction, status_query).First();
var prod_param = new P_L6PD_GPaPOSfT_1702();
prod_param.TreatmentID = TreatmentID;
var products = cls_Get_Product_and_ProcurementOrderStatuses_for_TreatmentID.Invoke(Connection, Transaction, prod_param, securityTicket).Result;
var notOrdered_Products = products.Where(i => i.BoundTo_ProcurementOrderPosition_RefID == Guid.Empty);
if (notOrdered_Products.Count() == 0)
{
return(returnValue);
}
#region Save Header and Status
var header_query = new ORM_ORD_PRC_ProcurementOrder_Header.Query();
header_query.IsDeleted = false;
header_query.Tenant_RefID = securityTicket.TenantID;
var headers = ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction, header_query);
var count = 0;
if (headers != null)
{
count = headers.Count();
}
String ordernumber = "000000000000" + (count + 1).ToString();
ordernumber = ordernumber.Substring(ordernumber.Length - 12);
var header = new ORM_ORD_PRC_ProcurementOrder_Header();
header.ORD_PRC_ProcurementOrder_HeaderID = Guid.NewGuid();
header.Current_ProcurementOrderStatus_RefID = notOrderedstatus.ORD_PRC_ProcurementOrder_StatusID;
header.ProcurementOrder_Number = ordernumber;
header.ProcurementOrder_Date = DateTime.Now;
header.Creation_Timestamp = DateTime.Now;
header.Tenant_RefID = securityTicket.TenantID;
header.Save(Connection, Transaction);
var history = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
history.ORD_PRC_ProcurementOrder_StatusHistoryID = Guid.NewGuid();
history.ProcurementOrder_Header_RefID = header.ORD_PRC_ProcurementOrder_HeaderID;
history.ProcurementOrder_Status_RefID = notOrderedstatus.ORD_PRC_ProcurementOrder_StatusID;
history.StatusHistoryComment = "";
history.Creation_Timestamp = DateTime.Now;
history.Tenant_RefID = securityTicket.TenantID;
history.Save(Connection, Transaction);
#endregion
int cnt = 0;
foreach (var product in notOrdered_Products)
{
cnt++;
var position = new ORM_ORD_PRC_ProcurementOrder_Position();
position.ORD_PRC_ProcurementOrder_PositionID = Guid.NewGuid();
position.ProcurementOrder_Header_RefID = header.ORD_PRC_ProcurementOrder_HeaderID;
position.Position_OrdinalNumber = cnt;
position.Position_Quantity = product.Quantity;
position.Position_ValuePerUnit = 1;
position.Position_ValueTotal = decimal.Parse(product.Quantity.ToString());
position.CMN_PRO_Product_Variant_RefID = Guid.Empty;
position.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
position.CMN_PRO_Product_Release_RefID = Guid.Empty;
position.Position_RequestedDateOfDelivery = product.ExpectedDateOfDelivery;
position.Creation_Timestamp = DateTime.Now;
position.Tenant_RefID = securityTicket.TenantID;
position.Save(Connection, Transaction);
var item = new ORM_HEC_Patient_Treatment_RequiredProduct();
item.Load(Connection, Transaction, product.HEC_Patient_Treatment_RequiredProductID);
item.BoundTo_CustomerOrderPosition_RefID = position.ORD_PRC_ProcurementOrder_PositionID;
item.Save(Connection, Transaction);
}
#endregion
return(returnValue);
#endregion UserCode
}
