protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PS_SNPFT_1319 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
var transaction = new ORM_HEC_Patient_Prescription_Transaction();
transaction.Load(Connection, Transaction, Parameter.HEC_Patient_Prescription_TransactionID);
transaction.PrescriptionTransaction_Patient_RefID = Parameter.PrescriptionTransaction_Patient_RefID;
transaction.Save(Connection, Transaction);
var query = new ORM_HEC_Patient_Prescription_2_PrescriptionTransaction.Query();
query.HEC_Patient_Prescription_Transaction_RefID = transaction.HEC_Patient_Prescription_TransactionID;
query.IsDeleted = false;
var assignments = ORM_HEC_Patient_Prescription_2_PrescriptionTransaction.Query.Search(Connection, Transaction, query);
foreach (var item in assignments)
{
var header = new ORM_HEC_Patient_Prescription_Header();
header.Load(Connection, Transaction, item.HEC_Patient_Prescription_Header_RefID);
header.Patient_RefID = Parameter.PrescriptionTransaction_Patient_RefID;
header.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6EV_CiiCEP_1506 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_HEC_Patient_Prescription_Transaction patientTranscription = new ORM_HEC_Patient_Prescription_Transaction();
patientTranscription.Load(Connection, Transaction, Parameter.HEC_Patient_Prescription_TransactionID);
patientTranscription.PrescriptionTransaction_IsComplete = false;
patientTranscription.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5PS_CT_1011 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
var transaction = new ORM_HEC_Patient_Prescription_Transaction();
transaction.Load(Connection, Transaction, Parameter.HEC_Patient_Prescription_TransactionID);
transaction.PrescriptionTransaction_IsComplete = true;
transaction.PrescriptionTransaction_Comment = Parameter.PrescriptionTransaction_Comment;
transaction.Save(Connection, Transaction);
return(returnValue);
#endregion UserCode
}
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
}
