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_String Execute(DbConnection Connection, DbTransaction Transaction, P_OR_SOtMM_1311 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_String();
//Put your code here
var data = cls_Get_Account_Information_with_PracticeID.Invoke(Connection, Transaction, securityTicket).Result;
var isNewPharmacy = Parameter.Order.default_pharmacy == Guid.Empty;
var current_order_status = isNewPharmacy ? "MO10" : "MO1";
var current_order_status_code = isNewPharmacy ? 10 : 1;
var all_languages = ORM_CMN_Language.Query.Search(Connection, Transaction, new ORM_CMN_Language.Query()
{
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
});
var practice_info = cls_Get_Practice_Details_for_Report.Invoke(Connection, Transaction, new P_DO_GPDFR_0840()
{
PracticeID = data.PracticeID
}, securityTicket).Result;
var trigger_acc = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
USR_AccountID = securityTicket.AccountID
}).Single();
var culture = new CultureInfo("de", true);
var delivery_date = DateTime.ParseExact(Parameter.Order.delivery_date, "dd.MM.yyyy", culture);
var delivery_date_from = DateTime.ParseExact(Parameter.Order.delivery_date_from, "HH:mm", culture);
delivery_date_from = delivery_date.AddHours(delivery_date_from.Hour).AddMinutes(delivery_date_from.Minute);
var delivery_date_to = DateTime.ParseExact(Parameter.Order.delivery_date_to, "HH:mm", culture);
delivery_date_to = delivery_date.AddHours(delivery_date_to.Hour).AddMinutes(delivery_date_to.Minute);
var drug_names = new List <string>();
var cmn_products = ORM_CMN_PRO_Product.Query.Search(Connection, Transaction, new ORM_CMN_PRO_Product.Query()
{
Tenant_RefID = securityTicket.TenantID, IsDeleted = false
});
var hec_products = ORM_HEC_Product.Query.Search(Connection, Transaction, new ORM_HEC_Product.Query()
{
Tenant_RefID = securityTicket.TenantID, IsDeleted = false
});
var drugs = cls_Get_Drug_Details_on_Tenant.Invoke(Connection, Transaction, securityTicket).Result;
#region save and get pharmacy
if (isNewPharmacy)
{
Parameter.Order.default_pharmacy = cls_Save_Pharmacy.Invoke(Connection, Transaction, new P_PH_SP_1124
{
Pharmacy = new Pharmacy.Model.Pharmacy(Guid.Empty, Parameter.Order.pharmacy_name, String.Empty, String.Empty,
String.Empty, Parameter.Order.pharmacy_street, Parameter.Order.pharmacy_street_number, Parameter.Order.pharmacy_zip_code,
Parameter.Order.pharmacy_town, true, String.Empty)
}, securityTicket).Result;
}
var pharmacy = cls_Get_Pharmacy_for_PharmacyID.Invoke(Connection, Transaction, new P_PH_GPfPID_1535
{
PharmacyID = Parameter.Order.default_pharmacy
}, securityTicket).Result;
#endregion
var ordersForReport = new List <ReportOrderItem>();
foreach (var order_id in Parameter.Order.order_ids)
{
#region Status
var header = ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Header.Query()
{
ORD_PRC_ProcurementOrder_HeaderID = order_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
header.ProcurementOrder_Supplier_RefID = pharmacy != null ? pharmacy.CompanyBPID : Guid.Empty;
var header_comment = new ORM_ORD_PRC_ProcurementOrder_Note();
header_comment.Comment = Parameter.Order.comment;
header_comment.Title = "Order comment";
header_comment.Tenant_RefID = securityTicket.TenantID;
header_comment.ORD_PRC_ProcurementOrder_Header_RefID = order_id;
header_comment.Save(Connection, Transaction);
ORM_ORD_PRC_ProcurementOrder_Position.Query order_positionQ = new ORM_ORD_PRC_ProcurementOrder_Position.Query();
order_positionQ.Tenant_RefID = securityTicket.TenantID;
order_positionQ.IsDeleted = false;
order_positionQ.ProcurementOrder_Header_RefID = order_id;
var order_position = ORM_ORD_PRC_ProcurementOrder_Position.Query.Search(Connection, Transaction, order_positionQ).SingleOrDefault();
var position_comment = order_position != null ? order_position.Position_Comment ?? String.Empty : String.Empty;
var drug_order_status = new ORM_ORD_PRC_ProcurementOrder_Status();
drug_order_status.GlobalPropertyMatchingID = String.Format("mm.doc.connect.drug.order.status.{0}", current_order_status.ToLower());
drug_order_status.Status_Code = current_order_status_code;
drug_order_status.Tenant_RefID = securityTicket.TenantID;
drug_order_status.Status_Name = new Dict(ORM_ORD_PRC_ProcurementOrder_Status.TableName);
foreach (var lang in all_languages)
{
drug_order_status.Status_Name.AddEntry(lang.CMN_LanguageID, current_order_status);
}
drug_order_status.Save(Connection, Transaction);
var drug_order_status_history = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
drug_order_status_history.ProcurementOrder_Header_RefID = 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 = trigger_acc.BusinessParticipant_RefID;
drug_order_status_history.Save(Connection, Transaction);
header.Current_ProcurementOrderStatus_RefID = drug_order_status.ORD_PRC_ProcurementOrder_StatusID;
header.Save(Connection, Transaction);
#endregion Status
var ord_drug_order = ORM_ORD_PRC_ProcurementOrder_Position.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Position.Query()
{
ProcurementOrder_Header_RefID = order_id,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
ord_drug_order.Position_RequestedDateOfDelivery = delivery_date.Date;
ord_drug_order.RequestedDateOfDelivery_TimeFrame_From = delivery_date_from;
ord_drug_order.RequestedDateOfDelivery_TimeFrame_To = delivery_date_to;
ord_drug_order.Save(Connection, Transaction);
var hec_drug_order = ORM_HEC_PRC_ProcurementOrder_Position.Query.Search(Connection, Transaction, new ORM_HEC_PRC_ProcurementOrder_Position.Query()
{
Ext_ORD_PRC_ProcurementOrder_Position_RefID = ord_drug_order.ORD_PRC_ProcurementOrder_PositionID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single();
var drug_id = ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct.Query.Search(Connection, Transaction, new ORM_HEC_ACT_PlannedAction_PotentialProcedure_RequiredProduct.Query()
{
BoundTo_HealthcareProcurementOrderPosition_RefID = hec_drug_order.HEC_PRC_ProcurementOrder_PositionID,
Tenant_RefID = securityTicket.TenantID,
IsDeleted = false
}).Single().HealthcareProduct_RefID;
var drugName = drugs.First(t => t.DrugID == drug_id).DrugName;
drug_names.Add(drugName);
if (Parameter.Order.doctor_id != Guid.Empty)
{
var authorizing_doctor_details = cls_Get_Doctor_BasicInformation_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDBIfDID_1034()
{
DoctorID = Parameter.Order.doctor_id
}, securityTicket).Result;
hec_drug_order.Clearing_Doctor_RefID = Parameter.Order.doctor_id;
hec_drug_order.ClearingDoctor_DisplayName = GenericUtils.GetDoctorName(authorizing_doctor_details);
hec_drug_order.Save(Connection, Transaction);
}
var shipping_address = new ORM_CMN_UniversalContactDetail();
shipping_address.Modification_Timestamp = DateTime.Now;
shipping_address.Tenant_RefID = securityTicket.TenantID;
shipping_address.Street_Name = Parameter.Order.street;
shipping_address.Street_Number = Parameter.Order.number;
shipping_address.ZIP = Parameter.Order.zip;
shipping_address.Town = Parameter.Order.city;
shipping_address.CompanyName_Line1 = Parameter.Order.receiver;
shipping_address.Save(Connection, Transaction);
var ord_drug_order_header = new ORM_ORD_PRC_ProcurementOrder_Header();
ord_drug_order_header.Load(Connection, Transaction, ord_drug_order.ProcurementOrder_Header_RefID);
ord_drug_order_header.ShippingAddressUCD_RefID = shipping_address.CMN_UniversalContactDetailID;
ord_drug_order_header.Modification_Timestamp = DateTime.Now;
ord_drug_order_header.ProcurementOrder_Supplier_RefID = pharmacy != null ? pharmacy.CompanyBPID : Guid.Empty;
ord_drug_order_header.Save(Connection, Transaction);
ordersForReport.Add(new ReportOrderItem
{
Name = drugName,
PositionComment = position_comment,
Patient = new ReportOrderPatientInformation
{
PatientID = hec_drug_order.OrderedFor_Patient_RefID,
FeeWaived = hec_drug_order.IsOrderForPatient_PatientFeeWaived
}
});
}
#region Send e-mail if urgent order
var defaultshippingDateOffset = cls_Get_Practice_PropertyValue_for_PropertyName_and_PracticeID.Invoke(Connection, Transaction, new P_DO_GPPVfPNaPID_0916()
{
PracticeID = data.PracticeID,
PropertyName = "Default Shipping Date Offset"
}, securityTicket).Result.NumericValue;
var company_settings = cls_Get_Company_Settings.Invoke(Connection, Transaction, securityTicket).Result;
var ordernum = company_settings.ImmediateOrderInterval;
if (delivery_date > DateTime.Now.AddDays(-defaultshippingDateOffset).AddMinutes(ordernum))
{
try
{
Thread.CurrentThread.CurrentUICulture = CultureInfo.GetCultureInfo("de-DE");
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 = company_settings.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/UrgentOrderEmailTemplate.html"));
var subjectsJson = File.ReadAllText(HttpContext.Current.Server.MapPath("~/EmailTemplates/EmailSubjects.json"));
dynamic subjects = JsonConvert.DeserializeObject(subjectsJson);
var subjectMail = subjects["UrgentOrderSubject"].ToString();
email_template = EmailTemplater.SetTemplateData(email_template, new
{
orders = drug_names.Select(t => new
{
order_date_time_from = delivery_date_from.ToString("dd.MM.yyyy HH:mm"),
order_date_time_to = delivery_date_to.ToString("HH:mm"),
name = data.AccountInformation.name,
drug_name = t
}),
mmapp_dashboard_url = prefix + HttpContext.Current.Request.Url.Authority + "/" + appName,
medios_connect_logo_url = imageUrl
}, "{{", "}}");
var 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, "Urgent order: Email sending failed."), "EmailExceptions");
}
}
#endregion SEND MAIL URGENT ORDER
#region Update case order number
var case_order_number = cls_Save_Case_Order_Number_for_OrderIDs.Invoke(Connection, Transaction, new P_CAS_SCONfOID_1442
{
order_ids = Parameter.Order.order_ids.ToArray(),
practice_bsnr = practice_info.BSNR
}, securityTicket).Result;
#endregion
#region Create PDF report
if (isNewPharmacy)
{
#region patient information
var patients_info = cls_Get_Patient_Details_for_PatientIDs.Invoke(Connection, Transaction, new P_PA_GPDfPIDs_1354
{
PatientIDs = ordersForReport.Select(x => x.Patient).Select(x => x.PatientID).Distinct().ToArray()
}, securityTicket).Result;
foreach (var order in ordersForReport)
{
var patient_info = patients_info.Single(x => x.PatientID == order.Patient.PatientID);
order.Patient.FirstName = patient_info.FirstName;
order.Patient.LastName = patient_info.LastName;
order.Patient.BirthDate = patient_info.BirthDate;
order.Patient.Hip = patient_info.HipName;
order.Patient.InsuranceStatus = patient_info.InsuranceStatus;
}
#endregion
#region Repack data for report
var orderPdfReport = new OrderPdfReportGenerator();
var reportOrderInfo = new ReportOrderInformation
{
DeliveryDate = delivery_date,
DeliveryTimeFrom = delivery_date_from,
DeliveryTimeTo = delivery_date_to,
CreationDate = DateTime.Now,
OrderNumber = case_order_number,
HeaderComment = Parameter.Order.comment ?? String.Empty,
OrderedDrugs = ordersForReport,
};
var reportPractice = new OrderParticipantInformation
{
City = practice_info.City,
Email = practice_info.Contact_Email,
Name = practice_info.Name,
Number = practice_info.Street_Number,
Phone = practice_info.Contact_Telephone,
Street = practice_info.Street_Name,
Zip = practice_info.ZIP
};
var reportPharmacy = new OrderParticipantInformation
{
Name = pharmacy.PharmacyName,
Street = pharmacy.Street_Name,
Number = pharmacy.Street_Number,
Zip = pharmacy.ZIP,
City = pharmacy.Town,
Email = pharmacy.Contact_Email,
Phone = pharmacy.Contact_Telephone
};
#endregion
var bytes = orderPdfReport.Generate(
new Model.OrderReportParameters
{
Orders = reportOrderInfo,
Pharmacy = reportPharmacy,
Practice = reportPractice
},
HttpContext.Current.Server.MapPath("~/ReportContent/SubmitOrderPdfReportContent.xml")
);
var _providerFactory = ProviderFactory.Instance;
var documentProvider = _providerFactory.CreateDocumentServiceProvider();
var fileName = String.Format("{0}-{1}-{2}.pdf", "Submited Orders", pharmacy.PharmacyName, DateTime.Now.ToString("dd.MM.yyyy HH:mm"));
var documentID = documentProvider.UploadDocument(bytes, fileName, securityTicket.SessionTicket, HttpContext.Current.Request.UserHostAddress);
var reportURL = documentProvider.GenerateDownloadLink(documentID, securityTicket.SessionTicket, true, true);
var parameterDoc = new P_OR_UOPDFR_1049();
parameterDoc.DocumentID = documentID;
parameterDoc.Mime = UtilMethods.GetMimeType(fileName);
parameterDoc.DocumentName = fileName;
parameterDoc.CaseOrderNumber = case_order_number;
parameterDoc.OrderIDs = Parameter.Order.order_ids.ToArray();
cls_Upload_Order_PDF_Report.Invoke(Connection, Transaction, parameterDoc, securityTicket);
returnValue.Result = reportURL;
}
#endregion
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_OR_COS_0840 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
List <Case_Model> cases = new List <Case_Model>();
List <PatientDetailViewModel> patientDetailList = new List <PatientDetailViewModel>();
List <Order_Model> OrderModelL = new List <Order_Model>();
//Put your code here
foreach (var ParameterInstance in Parameter.ParameterArray)
{
var procurmentHeader = ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Header.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
ORD_PRC_ProcurementOrder_HeaderID = ParameterInstance.Order_ID
}).Single();
var newOrderStatus = new ORM_ORD_PRC_ProcurementOrder_Status();
newOrderStatus.Tenant_RefID = securityTicket.TenantID;
newOrderStatus.Status_Code = ParameterInstance.Status_To;
newOrderStatus.Modification_Timestamp = DateTime.Now;
newOrderStatus.Save(Connection, Transaction);
var newOrderStatusHistory = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
newOrderStatusHistory.Tenant_RefID = securityTicket.TenantID;
newOrderStatusHistory.ProcurementOrder_Status_RefID = newOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
newOrderStatusHistory.IsStatus_RejectedBySupplier = true;
newOrderStatusHistory.ProcurementOrder_Header_RefID = procurmentHeader.ORD_PRC_ProcurementOrder_HeaderID;
newOrderStatusHistory.Save(Connection, Transaction);
procurmentHeader.Current_ProcurementOrderStatus_RefID = newOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
procurmentHeader.Save(Connection, Transaction);
#region Update Case Elastic
var caseForUpdate = cls_Get_Case_Details_for_CaseID.Invoke(Connection, Transaction, new P_CAS_GCDfCID_1435()
{
CaseID = ParameterInstance.CaseID
}, securityTicket).Result;
var patient_details = cls_Get_Patient_Details_for_PatientID.Invoke(Connection, Transaction, new P_P_PA_GPDfPID_1124()
{
PatientID = caseForUpdate.patient_id
}, securityTicket).Result;
var diagnose_details = cls_Get_Diagnose_Details_for_DiagnoseID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1608()
{
DiagnoseID = caseForUpdate.diagnose_id
}, securityTicket).Result;
var drug_details = cls_Get_Drug_Details_for_DrugID.Invoke(Connection, Transaction, new P_CAS_GDDfDID_1614()
{
DrugID = caseForUpdate.drug_id
}, securityTicket).Result;
var treatment_doctor_details = cls_Get_Doctor_Details_for_DoctorID.Invoke(Connection, Transaction, new P_DO_GDDfDID_0823()
{
DoctorID = caseForUpdate.op_doctor_id
}, securityTicket).Result.SingleOrDefault();
var case_status = cls_Check_Case_Status.Invoke(Connection, Transaction, new P_CAS_CCS_1639()
{
CaseID = ParameterInstance.CaseID
}, securityTicket).Result;
if (case_status == null)
{
var case_model_elastic = Get_Cases.GetCaseforCaseID(caseForUpdate.case_id.ToString(), securityTicket);
if (case_model_elastic != null)
{
case_model_elastic.status_drug_order = ParameterInstance.Status_To_Str;
case_model_elastic.order_modification_timestamp = caseForUpdate.order_modification_timestamp;
case_model_elastic.order_modification_timestamp_string = caseForUpdate.order_modification_timestamp.ToString("dd.MM.yyyy");
cases.Add(case_model_elastic);
}
}
#endregion
var orderM = Get_Orders.GetOrderforOrderID(procurmentHeader.ORD_PRC_ProcurementOrder_HeaderID.ToString(), securityTicket);
if (orderM != null)
{
orderM.status_drug_order = ParameterInstance.Status_To_Str;
orderM.order_modification_timestamp = DateTime.Now;
orderM.order_modification_timestamp_string = DateTime.Now.ToString("dd.MM.yyyy");
OrderModelL.Add(orderM);
var patientDetalTreatmentWithOrder = Retrieve_Patients.Get_PatientDetaiForIDandOrderID(orderM.id, securityTicket).Where(i => i.detail_type == "op").SingleOrDefault();
if (patientDetalTreatmentWithOrder == null)
{
PatientDetailViewModel patient_detail = new PatientDetailViewModel();
patient_detail.case_id = orderM.case_id;
patient_detail.date = orderM.treatment_date;
patient_detail.date_string = patient_detail.date.ToString("dd.MM.");
patient_detail.detail_type = "order";
patient_detail.diagnose_or_medication = orderM.drug;
patient_detail.practice_id = orderM.practice_id;
patient_detail.id = orderM.id;
patient_detail.order_id = orderM.id;
patient_detail.case_id = orderM.case_id;
patient_detail.order_status = orderM.status_drug_order;
patient_detail.patient_id = patient_details.id.ToString();
patient_detail.drug_id = orderM.drug_id;
patientDetailList.Add(patient_detail);
}
else
{
patientDetalTreatmentWithOrder.date = orderM.treatment_date;
patientDetalTreatmentWithOrder.date_string = patientDetalTreatmentWithOrder.date.ToString("dd.MM.");
patientDetalTreatmentWithOrder.case_id = orderM.case_id;
patientDetalTreatmentWithOrder.order_id = orderM.id;
patientDetalTreatmentWithOrder.practice_id = orderM.practice_id;
patientDetalTreatmentWithOrder.drug = orderM.drug;
patientDetalTreatmentWithOrder.drug_id = orderM.drug_id;
patientDetalTreatmentWithOrder.order_status = orderM.status_drug_order;
patientDetalTreatmentWithOrder.patient_id = patient_details.id.ToString();
patientDetailList.Add(patientDetalTreatmentWithOrder);
}
}
}
if (patientDetailList.Count != 0)
{
Add_New_Patient.ImportPatientDetailsToElastic(patientDetailList, securityTicket.TenantID.ToString());
}
if (OrderModelL.Count != 0)
{
Add_New_Order.Import_Order_Data_to_ElasticDB(OrderModelL, securityTicket.TenantID.ToString());
}
if (cases.Count != 0)
{
Add_New_Case.Import_Case_Data_to_ElasticDB(cases, securityTicket.TenantID.ToString());
}
return(returnValue);
#endregion UserCode
}
protected static FR_OR_CAOS_1424 Execute(DbConnection Connection, DbTransaction Transaction, P_OR_CAOS_1424 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_OR_CAOS_1424();
returnValue.Result = new OR_CAOS_1424();
//Put your code here
var statuses = new List <string>();
statuses.Add(Parameter.Status_From.ToString());
var ordersForChange = cls_Get_all_Orders_with_Status.Invoke(Connection, Transaction, new P_OR_GOwS_1428()
{
Status = statuses.ToArray()
}, securityTicket).Result;
#region Create Orders Report
if (Parameter.Status_To_Str == "MO2")
{
returnValue.Result.ReportURL = cls_Create_Orders_Report.Invoke(Connection, Transaction, new P_OR_COR_1437 {
GroupByPharmacy = true, Statuses = new int[] { 1, 6 }
}, securityTicket).Result;
//Check with Nemanja what this code shoud to do, it is same as code in cls_Change_Order_Status and it was in cls_Create_Orders_Report
#region change status
var statusDeleted = 6;
var ordersForChangeDeleted = cls_Get_all_Orders_with_Status.Invoke(Connection, Transaction, new P_OR_GOwS_1428()
{
Status = new string[] { statusDeleted.ToString() }
}, securityTicket).Result;
foreach (var order in ordersForChangeDeleted)
{
var procurmentHeader = ORM_ORD_PRC_ProcurementOrder_Header.Query.Search(Connection, Transaction, new ORM_ORD_PRC_ProcurementOrder_Header.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
ORD_PRC_ProcurementOrder_HeaderID = order.OrderID
}).Single();
var newOrderStatus = new ORM_ORD_PRC_ProcurementOrder_Status();
newOrderStatus.Tenant_RefID = securityTicket.TenantID;
newOrderStatus.Status_Code = 7;
newOrderStatus.Save(Connection, Transaction);
var newOrderStatusHistory = new ORM_ORD_PRC_ProcurementOrder_StatusHistory();
newOrderStatusHistory.Tenant_RefID = securityTicket.TenantID;
newOrderStatusHistory.ProcurementOrder_Status_RefID = newOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
newOrderStatusHistory.IsStatus_RejectedBySupplier = true;
newOrderStatusHistory.ProcurementOrder_Header_RefID = procurmentHeader.ORD_PRC_ProcurementOrder_HeaderID;
newOrderStatusHistory.Save(Connection, Transaction);
procurmentHeader.Current_ProcurementOrderStatus_RefID = newOrderStatus.ORD_PRC_ProcurementOrder_StatusID;
procurmentHeader.Save(Connection, Transaction);
}
#endregion
}
#endregion
if (ordersForChange.Any())
{
P_OR_COS_0840 param = new P_OR_COS_0840()
{
ParameterArray = ordersForChange.Select(order =>
{
P_OR_COS_0840a parameter = new P_OR_COS_0840a();
parameter.CaseID = order.CaseID;
parameter.Order_ID = order.OrderID;
parameter.Status_To = Parameter.Status_To;
parameter.Status_To_Str = Parameter.Status_To_Str;
return(parameter);
}).ToArray()
};
var data = cls_Change_Order_Status.Invoke(Connection, Transaction, param, securityTicket);
}
returnValue.Result.Orders = ordersForChange;
return(returnValue);
#endregion UserCode
}
protected static FR_Bool Execute(DbConnection Connection, DbTransaction Transaction, P_L5ZW_SDfNC_1707 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Bool();
returnValue.Result = false;
//Put your code here
#region get securityTicket and businessParticipantID by Paramter.AccountID and set defaultLanguageID
Guid tenantID;
Guid businessParticipantID;
if (Parameter.AccountID == Guid.Empty)
{
return(returnValue);
}
ORM_USR_Account orm_account = new ORM_USR_Account();
var result = orm_account.Load(Connection, Transaction, Parameter.AccountID);
if (result.Status != FR_Status.Success || orm_account.USR_AccountID == Guid.Empty)
{
return(returnValue);
}
tenantID = orm_account.Tenant_RefID;
securityTicket = new CSV2Core.SessionSecurity.SessionSecurityTicket()
{
TenantID = tenantID
};
ORM_CMN_BPT_BusinessParticipant.Query businessParticipantQuery = new ORM_CMN_BPT_BusinessParticipant.Query();
businessParticipantQuery.IfTenant_Tenant_RefID = tenantID;
businessParticipantQuery.IsDeleted = false;
ORM_CMN_BPT_BusinessParticipant businessParticipant = ORM_CMN_BPT_BusinessParticipant.Query.Search(Connection, Transaction, businessParticipantQuery).FirstOrDefault();
if (businessParticipant == null)
{
return(returnValue);
}
businessParticipantID = businessParticipant.CMN_BPT_BusinessParticipantID;
#endregion
#region get languages for tenant and set parameter dict values
P_L2LN_GALFTID_1530 languageParam = new P_L2LN_GALFTID_1530()
{
Tenant_RefID = tenantID
};
L2LN_GALFTID_1530[] languages = cls_Get_All_Languages_ForTenantID.Invoke(Connection, Transaction, languageParam, securityTicket).Result;
SetParameterDictValues(Parameter, languages);
List <ISOLanguage> languagesISOs = new List <ISOLanguage>();
languagesISOs.AddRange(languages.Select(l => new ISOLanguage()
{
ISO = l.ISO_639_1,
LanguageID = l.CMN_LanguageID
}).ToList());
#endregion
#region save defaultLanguage
// We are setting language for bp and acc
var defaultLanguage = languages.FirstOrDefault(i => i.ISO_639_1.ToLower().Contains(Parameter.DefaultLanguageCode.ToLower()));
if (defaultLanguage != null)
{
businessParticipant.DefaultLanguage_RefID = defaultLanguage.CMN_LanguageID;
businessParticipant.Save(Connection, Transaction);
orm_account.DefaultLanguage_RefID = defaultLanguage.CMN_LanguageID;
orm_account.Save(Connection, Transaction);
}
#endregion
#region save default country
if (Parameter.DefaultCountry != null)
{
ORM_CMN_Country country = new ORM_CMN_Country();
country.CMN_CountryID = Guid.NewGuid();
country.Country_ISOCode_Alpha3 = Parameter.DefaultCountry.Code;
country.Country_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
country.Creation_Timestamp = DateTime.Now;
country.Default_Currency_RefID = Guid.Empty;
country.Default_Language_RefID = Guid.Empty;
country.Tenant_RefID = tenantID;
country.IsDeleted = false;
country.IsDefault = true;
foreach (var languageItem in languages)
{
country.Country_Name.UpdateEntry(languageItem.CMN_LanguageID, Parameter.DefaultCountry.Name);
}
country.Save(Connection, Transaction);
}
#endregion
#region save default currency
//asign currency
if (Parameter.DefaultCurrency != null)
{
ORM_CMN_Currency currency = new ORM_CMN_Currency();
currency.CMN_CurrencyID = Guid.NewGuid();
currency.Creation_Timestamp = DateTime.Now;
currency.IsDeleted = false;
currency.ISO4127 = Parameter.DefaultCurrency.Code;
currency.Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
currency.Tenant_RefID = tenantID;
foreach (var language in languages)
{
currency.Name.UpdateEntry(language.CMN_LanguageID, Parameter.DefaultCurrency.Name);
}
currency.Save(Connection, Transaction);
//set default currency
ORM_CMN_BPT_BusinessParticipant businessPart = new ORM_CMN_BPT_BusinessParticipant();
businessPart.Load(Connection, Transaction, businessParticipantID);
businessPart.DefaultCurrency_RefID = currency.CMN_CurrencyID;
businessPart.Save(Connection, Transaction);
}
#endregion
#region save organisational units
if (Parameter.OrganisationalUnitParameters.Length > 0)
{
foreach (var item in Parameter.OrganisationalUnitParameters)
{
cls_Save_Office.Invoke(Connection, Transaction, item, securityTicket);
}
}
#endregion
#region save cost centers
if (Parameter.CostCenterParameters.Length > 0)
{
foreach (var item in Parameter.CostCenterParameters)
{
cls_Save_CostCenter.Invoke(Connection, Transaction, item, securityTicket);
}
}
#endregion
#region save warehouses
if (Parameter.WarehousesParameters.Length > 0)
{
#region save warehouse group
P_L2WH_SWHG_1327 warehouseGroupParam = new P_L2WH_SWHG_1327();
warehouseGroupParam.Parent_RefID = Guid.Empty;
warehouseGroupParam.WarehouseGroup_Name = "Waregouse group";
warehouseGroupParam.WarehouseGroup_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
foreach (var language in languages)
{
warehouseGroupParam.WarehouseGroup_Description.UpdateEntry(language.CMN_LanguageID, String.Empty);
}
var warehouseGroupID = cls_Save_Warehouse_Group.Invoke(Connection, Transaction, warehouseGroupParam, securityTicket).Result;
#endregion
foreach (var item in Parameter.WarehousesParameters)
{
item.LOG_WRH_WarehouseGroupID = warehouseGroupID;
cls_Save_Warehouse.Invoke(Connection, Transaction, item, securityTicket);
}
}
#endregion
#region create dimension templates
string jsonTemplates = ReadFromFile.LoadContentFromFile(@"Dimensions.json");
List <Dimension> dimensionTemplates = JsonConvert.DeserializeObject <List <Dimension> >(jsonTemplates);
int orderSequence = 1;
ORM_CMN_PRO_Dimension orm_dimension;
ORM_CMN_PRO_Dimension_Value orm_dimensionValue;
foreach (var template in dimensionTemplates)
{
orderSequence = 1;
#region save dimension
orm_dimension = new ORM_CMN_PRO_Dimension();
orm_dimension.Product_RefID = Guid.Empty;
orm_dimension.DimensionName = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_dimension.IsDimensionTemplate = true;
orm_dimension.Tenant_RefID = tenantID;
foreach (var language in languages)
{
orm_dimension.DimensionName.UpdateEntry(language.CMN_LanguageID, template.Name);
}
orm_dimension.Save(Connection, Transaction);
#endregion
#region save dimension values
foreach (var templateValue in template.DimansionValues)
{
orm_dimensionValue = new ORM_CMN_PRO_Dimension_Value();
orm_dimensionValue.Dimensions_RefID = orm_dimension.CMN_PRO_DimensionID;
orm_dimensionValue.DimensionValue_Text = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_dimensionValue.Tenant_RefID = tenantID;
orm_dimensionValue.OrderSequence = orderSequence;
foreach (var language in languages)
{
orm_dimensionValue.DimensionValue_Text.UpdateEntry(language.CMN_LanguageID, templateValue);
}
orm_dimensionValue.Save(Connection, Transaction);
orderSequence++;
}
#endregion
}
#endregion
#region create shipment types
string shipmentTypesJson = ReadFromFile.LoadContentFromFile(@"ShipmentTypes.json");
List <ShipmentTypes> shipmentTypes = JsonConvert.DeserializeObject <List <ShipmentTypes> >(shipmentTypesJson);
ORM_LOG_SHP_Shipment_Type orm_shipmentType;
foreach (var type in shipmentTypes)
{
#region save LOG_SHP_Shipment_Type
orm_shipmentType = new ORM_LOG_SHP_Shipment_Type();
orm_shipmentType.ShipmentType_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_shipmentType.ShipmentType_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_shipmentType.Tenant_RefID = tenantID;
foreach (var language in languages)
{
orm_shipmentType.ShipmentType_Name.UpdateEntry(language.CMN_LanguageID, type.Name);
orm_shipmentType.ShipmentType_Description.UpdateEntry(language.CMN_LanguageID, string.Empty);
}
orm_shipmentType.Save(Connection, Transaction);
#endregion
}
#endregion
#region create number ranges
string numberRangesJson = ReadFromFile.LoadContentFromFile(@"NumberRanges.json");
NumberRange numberRanges = JsonConvert.DeserializeObject <NumberRange>(numberRangesJson);
ORM_CMN_NumberRange_UsageArea numberRangeUsageArea;
ORM_CMN_NumberRange orm_numberRanges;
foreach (var item in numberRanges.NumberRanges)
{
if (Parameter.IsCustomerRegistration && item.Name == "Customer orders")
{
continue;
}
if (!Parameter.IsCustomerRegistration && item.Name == "Distribution orders")
{
continue;
}
if (!Parameter.IsCustomerRegistration && item.Name == "Procurement orders")
{
continue;
}
numberRangeUsageArea = new ORM_CMN_NumberRange_UsageArea();
numberRangeUsageArea.UsageArea_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
numberRangeUsageArea.UsageArea_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
foreach (var language in languages)
{
numberRangeUsageArea.UsageArea_Name.UpdateEntry(language.CMN_LanguageID, item.Name);
numberRangeUsageArea.UsageArea_Description.UpdateEntry(language.CMN_LanguageID, string.Empty);
}
numberRangeUsageArea.Tenant_RefID = tenantID;
numberRangeUsageArea.GlobalStaticMatchingID = item.GlobalStaticMatchingID;
numberRangeUsageArea.Save(Connection, Transaction);
orm_numberRanges = new ORM_CMN_NumberRange();
orm_numberRanges.NumberRange_Name = item.Name;
orm_numberRanges.Tenant_RefID = tenantID;
orm_numberRanges.NumberRange_UsageArea_RefID = numberRangeUsageArea.CMN_NumberRange_UsageAreaID;
orm_numberRanges.FixedPrefix = item.FixedPrefix;
orm_numberRanges.Formatting_LeadingFillCharacter = item.FillCharacter;
orm_numberRanges.Formatting_NumberLength = item.Length;
orm_numberRanges.Value_Current = item.CurrentValue;
orm_numberRanges.Value_Start = item.StartValue;
orm_numberRanges.Value_End = item.EndValue;
orm_numberRanges.Save(Connection, Transaction);
}
#endregion
#region create inventory change reasons
string inventoryChangeReasonsJson = ReadFromFile.LoadContentFromFile(@"InventoryChangeReasons.json");
List <InventoryChangeReasons> inventoryChangeReasons = JsonConvert.DeserializeObject <List <InventoryChangeReasons> >(inventoryChangeReasonsJson);
ORM_LOG_WRH_InventoryChangeReason orm_inventoryChangeReason;
foreach (var reason in inventoryChangeReasons)
{
#region save inventory change reason
orm_inventoryChangeReason = new ORM_LOG_WRH_InventoryChangeReason();
orm_inventoryChangeReason.GlobalPropertyMatchingID = InventoryChangeReasons.InventoryChangeReasonGlobalPropertyMatchingID + "-" + reason.Name;
orm_inventoryChangeReason.InventoryChange_Name = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_inventoryChangeReason.InventoryChange_Description = new Dict()
{
DictionaryID = Guid.NewGuid()
};
orm_inventoryChangeReason.Tenant_RefID = tenantID;
foreach (var language in languages)
{
orm_inventoryChangeReason.InventoryChange_Name.UpdateEntry(language.CMN_LanguageID, reason.Name);
orm_inventoryChangeReason.InventoryChange_Description.UpdateEntry(language.CMN_LanguageID, string.Empty);
}
orm_inventoryChangeReason.Save(Connection, Transaction);
#endregion
}
#endregion
#region create shipment statuses
var shipmentStatuses = Enum.GetValues(typeof(EShipmentStatus));
var shipmentStatusDicts = EnumUtils.GetDictObjectsForStaticListData <EShipmentStatus>(
ResourceFilePath.ShipmentStatus, ORM_LOG_SHP_Shipment_Status.TableName, languagesISOs);
var statusCodeCount = 1;
ORM_LOG_SHP_Shipment_Status shipmentStatus;
foreach (EShipmentStatus status in shipmentStatuses)
{
shipmentStatus = new ORM_LOG_SHP_Shipment_Status();
shipmentStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription((EShipmentStatus)status);
shipmentStatus.Status_Code = statusCodeCount++;
shipmentStatus.Status_Name = shipmentStatusDicts[EnumUtils.GetEnumDescription((EShipmentStatus)status)];
shipmentStatus.Tenant_RefID = tenantID;
shipmentStatus.Save(Connection, Transaction);
}
#endregion
if (Parameter.IsCustomerRegistration)
{
#region create procurement order statuses
var procurementStatuses = Enum.GetValues(typeof(EProcurementStatus));
ORM_ORD_PRC_ProcurementOrder_Status procurementOrderStatus;
foreach (EProcurementStatus status in procurementStatuses)
{
procurementOrderStatus = new ORM_ORD_PRC_ProcurementOrder_Status();
procurementOrderStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription(status);
procurementOrderStatus.Tenant_RefID = tenantID;
procurementOrderStatus.Save(Connection, Transaction);
}
#endregion
}
else
{
#region create customer order statuses
var customerOrderStatuses = Enum.GetValues(typeof(ECustomerOrderStatus));
var customerOrderStatusesDicts = EnumUtils.GetDictObjectsForStaticListData <ECustomerOrderStatus>(
ResourceFilePath.CustomerOrderStatus, ORM_ORD_CUO_CustomerOrder_Status.TableName, languagesISOs);
var count = 1;
ORM_ORD_CUO_CustomerOrder_Status customerOrderStatus;
foreach (var status in customerOrderStatuses)
{
customerOrderStatus = new ORM_ORD_CUO_CustomerOrder_Status();
customerOrderStatus.GlobalPropertyMatchingID = EnumUtils.GetEnumDescription((ECustomerOrderStatus)status);
customerOrderStatus.Status_Code = count++;
customerOrderStatus.Status_Name = customerOrderStatusesDicts[EnumUtils.GetEnumDescription((ECustomerOrderStatus)status)];
customerOrderStatus.Tenant_RefID = tenantID;
customerOrderStatus.Save(Connection, Transaction);
}
#endregion
}
returnValue.Result = true;
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
}
