protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_SCP_1308 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here var caseProperty = ORM_HEC_CAS_Case_UniversalProperty.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalProperty.Query() { GlobalPropertyMatchingID = Parameter.property_gpm_id, PropertyName = Parameter.property_name, Tenant_RefID = securityTicket.TenantID, IsValue_Boolean = Parameter.property_boolean_value.HasValue, IsValue_Number = Parameter.property_numeric_value.HasValue, IsValue_String = !String.IsNullOrEmpty(Parameter.property_string_value), IsDeleted = false }).SingleOrDefault(); if (caseProperty == null) { caseProperty = new ORM_HEC_CAS_Case_UniversalProperty() { IsValue_Boolean = Parameter.property_boolean_value.HasValue, IsValue_Number = Parameter.property_numeric_value.HasValue, IsValue_String = !String.IsNullOrEmpty(Parameter.property_string_value), GlobalPropertyMatchingID = Parameter.property_gpm_id, Modification_Timestamp = DateTime.Now, Tenant_RefID = securityTicket.TenantID, PropertyName = Parameter.property_name }; caseProperty.Save(Connection, Transaction); } var casePropertyValue = 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 = caseProperty.HEC_CAS_Case_UniversalPropertyID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (casePropertyValue == null) { casePropertyValue = new ORM_HEC_CAS_Case_UniversalPropertyValue(); casePropertyValue.HEC_CAS_Case_RefID = Parameter.case_id; casePropertyValue.HEC_CAS_Case_UniversalProperty_RefID = caseProperty.HEC_CAS_Case_UniversalPropertyID; casePropertyValue.Tenant_RefID = securityTicket.TenantID; } casePropertyValue.Modification_Timestamp = DateTime.Now; casePropertyValue.Value_Boolean = Parameter.property_boolean_value.HasValue ? Parameter.property_boolean_value.Value : false; casePropertyValue.Value_Number = Parameter.property_numeric_value.HasValue ? Parameter.property_numeric_value.Value : 0; casePropertyValue.Value_String = !String.IsNullOrEmpty(Parameter.property_string_value) ? Parameter.property_string_value : null; casePropertyValue.Save(Connection, Transaction); return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_ARCH_UCPD_0950 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { #region UserCode var returnValue = new FR_Guid(); //Put your code here if (Parameter.PlannedActionID == Guid.Empty) { return(returnValue); } var documentUpload = ORM_DOC_Document.Query.Search(Connection, Transaction, new ORM_DOC_Document.Query() { Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Alias = Parameter.PlannedActionID.ToString() }).SingleOrDefault(); var documentUploadRevision = new ORM_DOC_DocumentRevision(); documentUploadRevision.Revision = 0; if (documentUpload == null) { documentUpload = new ORM_DOC_Document(); documentUpload.Tenant_RefID = securityTicket.TenantID; documentUpload.Alias = Parameter.PlannedActionID.ToString(); documentUpload.GlobalPropertyMatchingID = "case pdf"; documentUpload.Save(Connection, Transaction); } else { var previousDocumentUploadRevision = ORM_DOC_DocumentRevision.Query.Search(Connection, Transaction, new ORM_DOC_DocumentRevision.Query() { IsLastRevision = true, Tenant_RefID = securityTicket.TenantID, IsDeleted = false, Document_RefID = documentUpload.DOC_DocumentID }).SingleOrDefault(); previousDocumentUploadRevision.IsLastRevision = false; previousDocumentUploadRevision.Modification_Timestamp = DateTime.Now; previousDocumentUploadRevision.Save(Connection, Transaction); documentUploadRevision.Revision = previousDocumentUploadRevision.Revision + 1; } documentUploadRevision.File_MIMEType = Parameter.Mime; documentUploadRevision.Tenant_RefID = securityTicket.TenantID; documentUploadRevision.Document_RefID = documentUpload.DOC_DocumentID; documentUploadRevision.UploadedByAccount = securityTicket.AccountID; documentUploadRevision.File_ServerLocation = Parameter.DocumentID.ToString(); documentUploadRevision.File_Name = Parameter.DocumentName; documentUploadRevision.File_Description = Parameter.CaseID.ToString(); documentUploadRevision.IsLastRevision = true; documentUploadRevision.Save(Connection, Transaction); var docStructure = ORM_DOC_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Structure.Query() { IsDeleted = false, Tenant_RefID = securityTicket.TenantID, Label = Parameter.CaseID.ToString() }).FirstOrDefault(); if (docStructure == null) { docStructure = new ORM_DOC_Structure(); docStructure.Tenant_RefID = securityTicket.TenantID; docStructure.Label = Parameter.CaseID.ToString(); docStructure.Save(Connection, Transaction); } var doc2docStructure = new ORM_DOC_Document_2_Structure(); doc2docStructure.Tenant_RefID = securityTicket.TenantID; doc2docStructure.Document_RefID = documentUpload.DOC_DocumentID; doc2docStructure.Structure_RefID = docStructure.DOC_StructureID; doc2docStructure.Save(Connection, Transaction); #region Case property var caseProperty = ORM_HEC_CAS_Case_UniversalProperty.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalProperty.Query() { GlobalPropertyMatchingID = ECaseProperty.ReportDownloaded.Value(), Tenant_RefID = securityTicket.TenantID, IsValue_String = true, IsDeleted = false, PropertyName = "Case Report Downloaded" }).SingleOrDefault(); if (caseProperty == null) { caseProperty = new ORM_HEC_CAS_Case_UniversalProperty(); caseProperty.GlobalPropertyMatchingID = ECaseProperty.ReportDownloaded.Value(); caseProperty.IsValue_String = true; caseProperty.Modification_Timestamp = DateTime.Now; caseProperty.PropertyName = "Case Report Downloaded"; caseProperty.Tenant_RefID = securityTicket.TenantID; caseProperty.Save(Connection, Transaction); } var casePropertyValue = ORM_HEC_CAS_Case_UniversalPropertyValue.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalPropertyValue.Query() { HEC_CAS_Case_RefID = Parameter.CaseID, HEC_CAS_Case_UniversalProperty_RefID = caseProperty.HEC_CAS_Case_UniversalPropertyID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (casePropertyValue == null) { casePropertyValue = new ORM_HEC_CAS_Case_UniversalPropertyValue(); casePropertyValue.HEC_CAS_Case_RefID = Parameter.CaseID; casePropertyValue.HEC_CAS_Case_UniversalProperty_RefID = caseProperty.HEC_CAS_Case_UniversalPropertyID; casePropertyValue.Tenant_RefID = securityTicket.TenantID; } casePropertyValue.Modification_Timestamp = DateTime.Now; if (casePropertyValue.Value_String == null) { casePropertyValue.Value_String = Parameter.PlannedActionID.ToString(); } else { if (!casePropertyValue.Value_String.Contains(Parameter.PlannedActionID.ToString())) { casePropertyValue.Value_String += ";" + Parameter.PlannedActionID.ToString(); } } casePropertyValue.Save(Connection, Transaction); #endregion if (!Parameter.IsBackgroundTask) { #region Update elastic try { var settlement = Get_Settlement.GetSettlementForID(Parameter.PlannedActionID.ToString(), securityTicket); settlement.is_report_downloaded = true; Add_new_Settlement.Import_Settlement_to_ElasticDB(new List <Settlement_Model>() { settlement }, securityTicket.TenantID.ToString()); var patientDetails = Retrieve_Patients.Get_PatientDetaiForID(Parameter.PlannedActionID.ToString(), securityTicket); patientDetails.if_settlement_is_report_downloaded = true; Add_New_Patient.ImportPatientDetailsToElastic(new List <PatientDetailViewModel>() { patientDetails }, securityTicket.TenantID.ToString()); } catch { } } #endregion 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 }
protected static FR_String Execute(DbConnection Connection, DbTransaction Transaction, P_CAS_SCONfOID_1442 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_String(); //Put your code here var caseOrderNumber = 00001; var lastCaseOrderNumber = cls_Get_Last_Case_Order_Number_for_PracticeBSNR.Invoke(Connection, Transaction, new P_CAS_GLCONfPBSNR_1534 { PracticeBSNR = String.Format("%{0}-%", Parameter.practice_bsnr) }, securityTicket).Result; if (lastCaseOrderNumber != null) { caseOrderNumber = lastCaseOrderNumber.CaseOrderNumber + 1; } var newCaseNumber = String.Format("{0}-{1}", Parameter.practice_bsnr, caseOrderNumber.ToString("D5")); var cases = cls_Get_CaseIDs_for_OrderIDs.Invoke(Connection, Transaction, new P_CAS_GCIDsfOIDs_1508 { OrderIDs = Parameter.order_ids }, securityTicket).Result; foreach (var cas in cases) { var case_universal_property = ORM_HEC_CAS_Case_UniversalProperty.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalProperty.Query() { GlobalPropertyMatchingID = ECaseProperty.CaseOrderNumber.Value(), Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (case_universal_property == null) { case_universal_property = new ORM_HEC_CAS_Case_UniversalProperty(); case_universal_property.Tenant_RefID = securityTicket.TenantID; case_universal_property.PropertyName = "Case order number"; case_universal_property.IsValue_Boolean = true; case_universal_property.GlobalPropertyMatchingID = ECaseProperty.CaseOrderNumber.Value(); case_universal_property.Modification_Timestamp = DateTime.Now; case_universal_property.Save(Connection, Transaction); } #region parameter value var case_universal_property_value = ORM_HEC_CAS_Case_UniversalPropertyValue.Query.Search(Connection, Transaction, new ORM_HEC_CAS_Case_UniversalPropertyValue.Query() { HEC_CAS_Case_RefID = cas.CaseID, HEC_CAS_Case_UniversalProperty_RefID = case_universal_property.HEC_CAS_Case_UniversalPropertyID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false }).SingleOrDefault(); if (case_universal_property_value == null) { case_universal_property_value = new ORM_HEC_CAS_Case_UniversalPropertyValue(); case_universal_property_value.Tenant_RefID = securityTicket.TenantID; case_universal_property_value.HEC_CAS_Case_RefID = cas.CaseID; case_universal_property_value.HEC_CAS_Case_UniversalProperty_RefID = case_universal_property.HEC_CAS_Case_UniversalPropertyID; } case_universal_property_value.Modification_Timestamp = DateTime.Now; case_universal_property_value.Value_String = newCaseNumber; case_universal_property_value.Save(Connection, Transaction); } #endregion returnValue.Result = newCaseNumber; return(returnValue); #endregion UserCode }