protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PS_ST_1157 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); #region Get Account By AccountID var account = new ORM_USR_Account(); account.Load(Connection, Transaction, securityTicket.AccountID); #endregion #region PrescriptionTransaction_InternalNubmer var qtransaction = new ORM_HEC_Patient_Prescription_Transaction.Query(); qtransaction.Tenant_RefID = securityTicket.TenantID; var count = ORM_HEC_Patient_Prescription_Transaction.Query.Search(Connection, Transaction, qtransaction).Count(); var internalnumber = "0000000" + count; internalnumber = internalnumber.Substring(internalnumber.Length - 7, 7); #endregion var transaction = new ORM_HEC_Patient_Prescription_Transaction(); transaction.HEC_Patient_Prescription_TransactionID = Guid.NewGuid(); transaction.PrescriptionTransaction_InternalNubmer = internalnumber; transaction.PrescriptionTransaction_IsComplete = false; transaction.PrescriptionTransaction_RequestedDateOfDeliveryFrom = Parameter.PrescriptionTransaction_RequestedDateOfDeliveryFrom; transaction.PrescriptionTransaction_RequestedDateOfDeliveryTo = Parameter.PrescriptionTransaction_RequestedDateOfDeliveryTo; transaction.PrescriptionTransaction_CreatedByBusinessParticpant_RefID = account.BusinessParticipant_RefID; transaction.PrescriptionTransaction_Comment = Parameter.PrescriptionTransaction_Comment; transaction.PrescriptionTransaction_Patient_RefID = Parameter.PrescriptionTransaction_Patient_RefID; transaction.PerscriptionTransaction_DeliveryAddress_RefID = Parameter.PrescriptionTransaction_Address_RefID; transaction.PrescriptionTransaction_UseParticipationPolicyAddress = false; transaction.PrescriptionTransaction_UsePatientAddress = true; transaction.PrescriptionTransaction_UseReceiptAddress = false; transaction.Creation_Timestamp = DateTime.Now; transaction.Tenant_RefID = securityTicket.TenantID; transaction.Save(Connection, Transaction); if (Parameter.Prescriptions != null) { var header = new ORM_HEC_Patient_Prescription_Header(); header.HEC_Patient_Prescription_HeaderID = Guid.NewGuid(); header.Patient_RefID = Parameter.PrescriptionTransaction_Patient_RefID; header.PrescribedBy_Doctor_RefID = Guid.Empty; header.Prescription_Date = new DateTime(); header.Prescription_Comment = ""; header.Prescription_InternalNumber = transaction.PrescriptionTransaction_InternalNubmer + "/" + 1; header.Perscription_UploadedByBusinessParticipant_RefID = account.BusinessParticipant_RefID; header.Creation_Timestamp = DateTime.Now; header.Tenant_RefID = securityTicket.TenantID; header.Save(Connection, Transaction); var transaction2header = new ORM_HEC_Patient_Prescription_2_PrescriptionTransaction(); transaction2header.AssignmentID = Guid.NewGuid(); transaction2header.HEC_Patient_Prescription_Header_RefID = header.HEC_Patient_Prescription_HeaderID; transaction2header.HEC_Patient_Prescription_Transaction_RefID = transaction.HEC_Patient_Prescription_TransactionID; transaction2header.Creation_Timestamp = DateTime.Now; transaction2header.Tenant_RefID = securityTicket.TenantID; transaction2header.Save(Connection, Transaction); var prescriptionDocument = new ORM_HEC_Patient_Prescription_Document(); prescriptionDocument.HEC_Patient_Prescription_DocumentID = Guid.NewGuid(); prescriptionDocument.PrescriptionHeader_RefID = header.HEC_Patient_Prescription_HeaderID; prescriptionDocument.Comment = ""; prescriptionDocument.Document_RefID = Guid.NewGuid(); prescriptionDocument.Creation_Timestamp = DateTime.Now; prescriptionDocument.Tenant_RefID = securityTicket.TenantID; prescriptionDocument.Save(Connection, Transaction); var document = new ORM_DOC_Document(); document.DOC_DocumentID = prescriptionDocument.Document_RefID; document.Alias = Parameter.Prescriptions.File_Name; document.PrimaryType = Parameter.Prescriptions.File_Extension; document.Creation_Timestamp = DateTime.Now; document.Tenant_RefID = securityTicket.TenantID; document.Save(Connection, Transaction); var revision = new ORM_DOC_DocumentRevision(); revision.DOC_DocumentRevisionID = Guid.NewGuid(); revision.Document_RefID = prescriptionDocument.Document_RefID; revision.Revision = 1; revision.IsLastRevision = true; revision.UploadedByAccount = securityTicket.AccountID; revision.File_Name = Parameter.Prescriptions.File_Name; revision.File_ServerLocation = Parameter.Prescriptions.File_ServerLocation; revision.File_Extension = Parameter.Prescriptions.File_Extension; revision.File_Size_Bytes = Parameter.Prescriptions.File_Size_Bytes; revision.Creation_Timestamp = DateTime.Now; revision.Tenant_RefID = securityTicket.TenantID; revision.Save(Connection, Transaction); } return(returnValue); #endregion UserCode }
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_DBBVP_1711 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null) { //Leave UserCode region to enable user code saving #region UserCode var returnValue = new FR_Guid(); P_L6PA_GBBVPfID_1714 getParam = new P_L6PA_GBBVPfID_1714(); getParam.HEC_PatientID = Parameter.HEC_PatientID; var patient = cls_Get_BBV_Patients_For_ID.Invoke(Connection, Transaction, getParam, securityTicket).Result; if (patient != null) { if (patient.Addresses != null) { foreach (var address in patient.Addresses) { P_L6PA_DBBVAFP_1703 delAddressPar = new P_L6PA_DBBVAFP_1703(); delAddressPar.CMN_AddressID = address.CMN_AddressID; cls_Delete_BBV_AddressForPatient.Invoke(Connection, Transaction, delAddressPar, securityTicket); } } if (patient.Contacts != null) { foreach (var contact in patient.Contacts) { ORM_CMN_PER_CommunicationContact.Query cQuery = new ORM_CMN_PER_CommunicationContact.Query(); cQuery.CMN_PER_CommunicationContactID = contact.CMN_PER_CommunicationContactID; cQuery.IsDeleted = false; cQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_PER_CommunicationContact.Query.SoftDelete(Connection, Transaction, cQuery); } } ORM_CMN_PER_PersonInfo.Query ORM_CMN_PER_PersonInfoQuery = new ORM_CMN_PER_PersonInfo.Query(); ORM_CMN_PER_PersonInfoQuery.CMN_PER_PersonInfoID = patient.CMN_PER_PersonInfoID; ORM_CMN_PER_PersonInfoQuery.IsDeleted = false; ORM_CMN_PER_PersonInfoQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_PER_PersonInfo.Query.SoftDelete(Connection, Transaction, ORM_CMN_PER_PersonInfoQuery); ORM_CMN_BPT_BusinessParticipant.Query ORM_CMN_BPT_BusinessParticipantoQuery = new ORM_CMN_BPT_BusinessParticipant.Query(); ORM_CMN_BPT_BusinessParticipantoQuery.CMN_BPT_BusinessParticipantID = patient.CMN_BPT_BusinessParticipantID; ORM_CMN_BPT_BusinessParticipantoQuery.IsDeleted = false; ORM_CMN_BPT_BusinessParticipantoQuery.Tenant_RefID = securityTicket.TenantID; ORM_CMN_BPT_BusinessParticipant.Query.SoftDelete(Connection, Transaction, ORM_CMN_BPT_BusinessParticipantoQuery); ORM_HEC_Patient.Query ORM_HEC_PatientQuery = new ORM_HEC_Patient.Query(); ORM_HEC_PatientQuery.HEC_PatientID = patient.HEC_PatientID; ORM_HEC_PatientQuery.IsDeleted = false; ORM_HEC_PatientQuery.Tenant_RefID = securityTicket.TenantID; ORM_HEC_Patient.Query.SoftDelete(Connection, Transaction, ORM_HEC_PatientQuery); ORM_HEC_Patient_HealthInsurance.Query ORM_HEC_Patient_HealthInsuranceoQuery = new ORM_HEC_Patient_HealthInsurance.Query(); ORM_HEC_Patient_HealthInsuranceoQuery.HEC_Patient_HealthInsurancesID = patient.HEC_Patient_HealthInsurancesID; ORM_HEC_Patient_HealthInsuranceoQuery.IsDeleted = false; ORM_HEC_Patient_HealthInsuranceoQuery.Tenant_RefID = securityTicket.TenantID; ORM_HEC_Patient_HealthInsurance.Query.SoftDelete(Connection, Transaction, ORM_HEC_Patient_HealthInsuranceoQuery); ORM_HEC_STU_Study_ParticipatingPatient.Query ORM_HEC_STU_Study_ParticipatingPatientQuery = new ORM_HEC_STU_Study_ParticipatingPatient.Query(); ORM_HEC_STU_Study_ParticipatingPatientQuery.HEC_STU_Study_ParticipatingPatientID = patient.HEC_STU_Study_ParticipatingPatientID; ORM_HEC_STU_Study_ParticipatingPatientQuery.IsDeleted = false; ORM_HEC_STU_Study_ParticipatingPatientQuery.Tenant_RefID = securityTicket.TenantID; ORM_HEC_STU_Study_ParticipatingPatient.Query.SoftDelete(Connection, Transaction, ORM_HEC_STU_Study_ParticipatingPatientQuery); var transactionsQuery = new ORM_HEC_Patient_Prescription_Transaction.Query(); transactionsQuery.PrescriptionTransaction_Patient_RefID = patient.HEC_PatientID; transactionsQuery.IsDeleted = false; ORM_HEC_Patient_Prescription_Transaction.Query.SoftDelete(Connection, Transaction, transactionsQuery); } return(returnValue); #endregion UserCode }