protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5BD_SBIfII_1360 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision();
documentRevision.Load(Connection, Transaction, Parameter.DOC_DocumentRevisionID);
if (documentRevision.DOC_DocumentRevisionID == Guid.Empty)
{
//Put your code here
ORM_DOC_Structure structure = ORM_DOC_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Structure.Query {
Structure_Header_RefID = Parameter.DOC_StructureHeaderRefID, Tenant_RefID = securityTicket.TenantID, IsDeleted = false
}).FirstOrDefault();
if (structure == null)
{
structure = new ORM_DOC_Structure();
}
structure.Structure_Header_RefID = Parameter.DOC_StructureHeaderRefID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
ORM_DOC_Document document = new ORM_DOC_Document();
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = structure.DOC_StructureID;
documentStructure.StructureHeader_RefID = Parameter.DOC_StructureHeaderRefID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
documentRevision.DOC_DocumentRevisionID = Parameter.DOC_DocumentRevisionID;
documentRevision.Document_RefID = document.DOC_DocumentID;
documentRevision.File_Name = Parameter.File_Name;
documentRevision.File_Description = Parameter.File_Description;
documentRevision.File_SourceLocation = Parameter.File_SourceLocation;
documentRevision.File_ServerLocation = Parameter.File_ServerLocation;
documentRevision.File_MIMEType = Parameter.File_MIMEType;
documentRevision.File_Extension = Parameter.File_Extension;
documentRevision.File_Size_Bytes = Parameter.File_Size_Bytes;
documentRevision.UploadedByAccount = securityTicket.AccountID;
documentRevision.Tenant_RefID = securityTicket.TenantID;
documentRevision.Save(Connection, Transaction);
returnValue.Result = documentRevision.DOC_DocumentRevisionID;
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L2DO_SDDR_1644 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
var returnValue = new FR_Guid();
var item = new ORM_DOC_DocumentRevision();
if (Parameter.DOC_DocumentRevisionID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.DOC_DocumentRevisionID);
if (result.Status != FR_Status.Success || item.DOC_DocumentRevisionID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.DOC_DocumentRevisionID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.DOC_DocumentRevisionID == Guid.Empty)
{
item.Tenant_RefID = securityTicket.TenantID;
}
item.Document_RefID = Parameter.Document_RefID;
item.Revision = Parameter.Revision;
item.IsLocked = Parameter.IsLocked;
item.IsLastRevision = Parameter.IsLastRevision;
item.UploadedByAccount = Parameter.UploadedByAccount;
item.File_Name = Parameter.File_Name;
item.File_Description = Parameter.File_Description;
item.File_SourceLocation = Parameter.File_SourceLocation;
item.File_ServerLocation = Parameter.File_ServerLocation;
item.File_MIMEType = Parameter.File_MIMEType;
item.File_Extension = Parameter.File_Extension;
item.File_Size_Bytes = Parameter.File_Size_Bytes;
return(new FR_Guid(item.Save(Connection, Transaction), item.DOC_DocumentRevisionID));
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5BD_SBI_1360 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_DOC_Structure structure = new ORM_DOC_Structure();
structure.Structure_Header_RefID = Parameter.DOC_StructureHeaderRefID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
ORM_DOC_Document document = new ORM_DOC_Document();
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = structure.DOC_StructureID;
documentStructure.StructureHeader_RefID = Parameter.DOC_StructureHeaderRefID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision();
documentRevision.DOC_DocumentRevisionID = Parameter.DocumentID;
documentRevision.Document_RefID = document.DOC_DocumentID;
documentRevision.File_Name = Parameter.File_Name;
documentRevision.File_Description = Parameter.File_Description;
documentRevision.File_SourceLocation = Parameter.File_SourceLocation;
documentRevision.File_ServerLocation = Parameter.File_ServerLocation;
documentRevision.File_MIMEType = Parameter.File_MIMEType;
documentRevision.File_Extension = Parameter.File_Extension;
documentRevision.File_Size_Bytes = Parameter.File_Size_Bytes;
documentRevision.UploadedByAccount = securityTicket.AccountID;
documentRevision.Tenant_RefID = securityTicket.TenantID;
documentRevision.Save(Connection, Transaction);
returnValue.Result = documentRevision.DOC_DocumentRevisionID;
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
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_ARCH_UD_1326 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var documentUpload = new ORM_DOC_Document();
documentUpload.DOC_DocumentID = Guid.NewGuid();
documentUpload.IsDeleted = false;
documentUpload.Creation_Timestamp = DateTime.Now;
documentUpload.Tenant_RefID = securityTicket.TenantID;
documentUpload.Alias = Parameter.Receiver;
if (Parameter.Mime.Contains("pdf"))
{
documentUpload.PrimaryType = "Abrechnungen";
documentUpload.GlobalPropertyMatchingID = "pdf mm";
}
else
{
switch (Parameter.Mime)
{
case "Application/Edifact":
documentUpload.PrimaryType = "EDIFACT";
documentUpload.GlobalPropertyMatchingID = Parameter.ContractID.ToString();
break;
case "Application/Edifact_Error":
documentUpload.PrimaryType = "HIP error import";
break;
default:
documentUpload.PrimaryType = "Excel report";
break;
}
}
documentUpload.Save(Connection, Transaction);
var documentUploadRevision = new ORM_DOC_DocumentRevision();
documentUploadRevision.DOC_DocumentRevisionID = Guid.NewGuid();
documentUploadRevision.Creation_Timestamp = DateTime.Now;
documentUploadRevision.File_MIMEType = Parameter.Mime;
documentUploadRevision.IsDeleted = false;
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.Description;
documentUploadRevision.Save(Connection, Transaction);
var usrAccount = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = securityTicket.AccountID
}).Single();
Guid DocStructureGuid = Guid.NewGuid();
var docStructureQ = ORM_DOC_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Structure.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Label = usrAccount.BusinessParticipant_RefID.ToString()
}).SingleOrDefault();
if (docStructureQ == null)
{
var docStructure = new ORM_DOC_Structure();
docStructure.DOC_StructureID = DocStructureGuid;
docStructure.IsDeleted = false;
docStructure.Tenant_RefID = securityTicket.TenantID;
docStructure.Label = usrAccount.BusinessParticipant_RefID.ToString();
docStructure.Creation_Timestamp = DateTime.Now;
docStructure.Save(Connection, Transaction);
}
else
{
DocStructureGuid = docStructureQ.DOC_StructureID;
}
var doc2docStructure = new ORM_DOC_Document_2_Structure();
doc2docStructure.IsDeleted = false;
doc2docStructure.Tenant_RefID = securityTicket.TenantID;
doc2docStructure.Creation_Timestamp = DateTime.Now;
doc2docStructure.AssignmentID = Guid.NewGuid();
doc2docStructure.Document_RefID = documentUpload.DOC_DocumentID;
doc2docStructure.Structure_RefID = DocStructureGuid;
doc2docStructure.Save(Connection, Transaction);
Archive_Model archiveModel = new Archive_Model();
archiveModel.id = documentUpload.DOC_DocumentID.ToString();
archiveModel.documentId = Parameter.DocumentID.ToString();
archiveModel.filedate = Parameter.DocumentDate.Date;
archiveModel.datestring = DateTime.Now.ToString("dd.MM.yyyy");
archiveModel.filetype = documentUpload.PrimaryType;
archiveModel.description = documentUploadRevision.File_Description;
archiveModel.recipient = documentUpload.Alias;
archiveModel.creationtimestamp = new DateTime(Parameter.DocumentDate.Year, Parameter.DocumentDate.Month, Parameter.DocumentDate.Day, Parameter.DocumentDate.Hour, Parameter.DocumentDate.Minute, 0);
Add_Item_to_Archive.Import_Archive_Item_to_ElasticDB(archiveModel, securityTicket.TenantID.ToString());
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L3DO_SDR_1401 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
//Leave UserCode region to enable user code saving
#region UserCode
var returnValue = new FR_Guid();
var item = new ORM_DOC_DocumentRevision();
if (Parameter.DOC_DocumentRevisionID != Guid.Empty)
{
var result = item.Load(Connection, Transaction, Parameter.DOC_DocumentRevisionID);
if (result.Status != FR_Status.Success || item.DOC_DocumentRevisionID == Guid.Empty)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
}
if (Parameter.IsDeleted == true)
{
item.IsDeleted = true;
return(new FR_Guid(item.Save(Connection, Transaction), item.DOC_DocumentRevisionID));
}
//Creation specific parameters (Tenant, Account ... )
if (Parameter.DOC_DocumentRevisionID == Guid.Empty)
{
#region Set IsLastRevision
ORM_DOC_DocumentRevision instance = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_DOC_DocumentRevision>();
instance.IsLastRevision = false;
InstanceFilterWrapper instanceWrap = InstanceFilterWrapper.Wrap(instance, new string[] { "IsLastRevision" });
ORM_DOC_DocumentRevision comparator = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_DOC_DocumentRevision>();
comparator.Document_RefID = Parameter.Document_RefID;
InstanceFilterWrapper comparatorWrap = InstanceFilterWrapper.Wrap(comparator, new string[] { "Document_RefID" });
CSV2Core_MySQL.Support.SQLClassFilter.UpdateValue(Connection, Transaction, instanceWrap, comparatorWrap);
#endregion setLastRevision
ORM_DOC_DocumentRevision instance2 = CSV2Core_MySQL.Support.SQLClassFilter.GetDefaultInstance <ORM_DOC_DocumentRevision>();
instance2.Document_RefID = Parameter.Document_RefID;
InstanceFilterWrapper wrapper = InstanceFilterWrapper.Wrap(instance2);
int count = CSV2Core_MySQL.Support.SQLClassFilter.Count(Connection, Transaction, wrapper);
item.IsLastRevision = true;
item.Revision = count + 1;
item.Tenant_RefID = securityTicket.TenantID;
}
item.Document_RefID = Parameter.Document_RefID;
//item.Revision = Parameter.Revision;
item.IsLocked = Parameter.IsLocked;
//item.IsLastRevision = Parameter.IsLastRevision;
item.UploadedByAccount = securityTicket.AccountID;
item.File_Name = Parameter.File_Name;
item.File_Description = Parameter.File_Description;
item.File_SourceLocation = Parameter.File_SourceLocation;
item.File_ServerLocation = Parameter.File_ServerLocation;
item.File_MIMEType = Parameter.File_MIMEType;
item.File_Extension = Parameter.File_Extension;
item.File_Size_Bytes = Parameter.File_Size_Bytes;
return(new FR_Guid(item.Save(Connection, Transaction), item.DOC_DocumentRevisionID));
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5AR_SA_1614 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
var languageQuery = new ORM_CMN_Language.Query();
languageQuery.Tenant_RefID = securityTicket.TenantID;
languageQuery.IsDeleted = false;
var languages = ORM_CMN_Language.Query.Search(Connection, Transaction, languageQuery);
var product = new ORM_CMN_PRO_Product();
if (Parameter.ArticleID == Guid.Empty)
{
#region ORM_CMN_PRO_Product
product = new ORM_CMN_PRO_Product();
product.CMN_PRO_ProductID = Guid.NewGuid();
product.ProductITL = Guid.NewGuid().ToString();
product.IsProduct_Article = true;
product.IsProductAvailableForOrdering = true;
product.IsImportedFromExternalCatalog = false;
product.Product_Name = new Dict(ORM_CMN_PRO_Product.TableName);
product.Product_Description = new Dict(ORM_CMN_PRO_Product.TableName);
product.PackageInfo_RefID = Guid.NewGuid();
product.Creation_Timestamp = DateTime.Now;
product.Tenant_RefID = securityTicket.TenantID;
product.IsDeleted = Parameter.IsDeleted;
#region Product picture
if (Parameter.Image != null && Parameter.Image.Document_ID != Guid.Empty)
{
ORM_DOC_Structure_Header structureHeader = new ORM_DOC_Structure_Header();
structureHeader.Label = "Product picture";
structureHeader.Tenant_RefID = securityTicket.TenantID;
structureHeader.Save(Connection, Transaction);
ORM_DOC_Structure structure = new ORM_DOC_Structure();
structure.Label = "Product picture";
structure.Structure_Header_RefID = structureHeader.DOC_Structure_HeaderID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
ORM_DOC_Document document = new ORM_DOC_Document();
document.DOC_DocumentID = Parameter.Image.Document_ID;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = structure.DOC_StructureID;
documentStructure.StructureHeader_RefID = structureHeader.DOC_Structure_HeaderID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision();
documentRevision.Document_RefID = document.DOC_DocumentID;
documentRevision.Revision = 1;
documentRevision.IsLocked = false;
documentRevision.IsLastRevision = true;
documentRevision.UploadedByAccount = securityTicket.AccountID;
documentRevision.File_Name = Parameter.Image.File_Name;
documentRevision.File_Description = Parameter.Image.File_Description;
documentRevision.File_SourceLocation = Parameter.Image.File_Source_Location;
documentRevision.File_ServerLocation = Parameter.Image.File_Server_Location;
documentRevision.File_MIMEType = Parameter.Image.File_MimeType;
documentRevision.File_Extension = Parameter.Image.File_Extension;
documentRevision.File_Size_Bytes = Parameter.Image.File_Size_Bytes;
documentRevision.Tenant_RefID = securityTicket.TenantID;
documentRevision.Save(Connection, Transaction);
//add relation for product picture with product
product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID;
}
#endregion
product.Save(Connection, Transaction);
#endregion
}
else
{
product.Load(Connection, Transaction, Parameter.ArticleID);
#region Product picture
if (Parameter.Image != null && Parameter.Image.Document_ID != Guid.Empty)
{
ORM_DOC_Structure_Header structureHeader = new ORM_DOC_Structure_Header();
structureHeader.Label = "Product picture";
structureHeader.Tenant_RefID = securityTicket.TenantID;
structureHeader.Save(Connection, Transaction);
ORM_DOC_Structure structure = new ORM_DOC_Structure();
structure.Label = "Product picture";
structure.Structure_Header_RefID = structureHeader.DOC_Structure_HeaderID;
structure.CreatedBy_Account_RefID = securityTicket.AccountID;
structure.Tenant_RefID = securityTicket.TenantID;
structure.Save(Connection, Transaction);
ORM_DOC_Document document = new ORM_DOC_Document();
document.DOC_DocumentID = Parameter.Image.Document_ID;
document.Tenant_RefID = securityTicket.TenantID;
document.Save(Connection, Transaction);
ORM_DOC_Document_2_Structure documentStructure = new ORM_DOC_Document_2_Structure();
documentStructure.Document_RefID = document.DOC_DocumentID;
documentStructure.Structure_RefID = structure.DOC_StructureID;
documentStructure.StructureHeader_RefID = structureHeader.DOC_Structure_HeaderID;
documentStructure.Tenant_RefID = securityTicket.TenantID;
documentStructure.Save(Connection, Transaction);
ORM_DOC_DocumentRevision documentRevision = new ORM_DOC_DocumentRevision();
documentRevision.Document_RefID = document.DOC_DocumentID;
documentRevision.Revision = 1;
documentRevision.IsLocked = false;
documentRevision.IsLastRevision = true;
documentRevision.UploadedByAccount = securityTicket.AccountID;
documentRevision.File_Name = Parameter.Image.File_Name;
documentRevision.File_Description = Parameter.Image.File_Description;
documentRevision.File_SourceLocation = Parameter.Image.File_Source_Location;
documentRevision.File_ServerLocation = Parameter.Image.File_Server_Location;
documentRevision.File_MIMEType = Parameter.Image.File_MimeType;
documentRevision.File_Extension = Parameter.Image.File_Extension;
documentRevision.File_Size_Bytes = Parameter.Image.File_Size_Bytes;
documentRevision.Tenant_RefID = securityTicket.TenantID;
documentRevision.Save(Connection, Transaction);
//add relation for product picture with product
product.Product_DocumentationStructure_RefID = structureHeader.DOC_Structure_HeaderID;
}
else
{
// if (Parameter.Image.IsForDeleting) if product image has to be deleted
}
#endregion
}
#region ORM_CMN_PRO_Product
product.Product_Number = Parameter.ProductNumber;
foreach (var language in languages)
{
product.Product_Name.UpdateEntry(language.CMN_LanguageID, Parameter.ArticleName);
product.Product_Description.UpdateEntry(language.CMN_LanguageID, Parameter.Description);
}
product.ProductType_RefID = Guid.Empty;
product.IsPlaceholderArticle = Parameter.IsDummy;
product.ProductSuccessor_RefID = Guid.Empty;
product.IsDeleted = Parameter.IsDeleted;
product.Save(Connection, Transaction);
#endregion
//#region ORM_CMN_PRO_Product_2_ProductCode
//var product2CodeQuery = new ORM_CMN_PRO_Product_2_ProductCode.Query();
//product2CodeQuery.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
//product2CodeQuery.Tenant_RefID = securityTicket.TenantID;
//product2CodeQuery.IsDeleted = false;
//var productCodeAssignment = ORM_CMN_PRO_Product_2_ProductCode.Query.Search(Connection, Transaction, product2CodeQuery).SingleOrDefault();
//if (productCodeAssignment == null)
//{
// #region ORM_CMN_PRO_ProductCode
#region Variant
//Create default varient
var defaultVarient = new ORM_CMN_PRO_Product_Variant();
defaultVarient.CMN_PRO_Product_VariantID = Guid.NewGuid();
defaultVarient.CMN_PRO_Product_RefID = product.CMN_PRO_ProductID;
defaultVarient.IsStandardProductVariant = true;
defaultVarient.Tenant_RefID = securityTicket.TenantID;
defaultVarient.VariantName = new Dict(ORM_CMN_PRO_Product_Variant.TableName);
foreach (var language in languages)
{
defaultVarient.VariantName.UpdateEntry(language.CMN_LanguageID, String.Empty);
}
defaultVarient.Save(Connection, Transaction);
#endregion
returnValue.Result = product.CMN_PRO_ProductID;
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_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_ARCH_UPD_1434 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
var documentUpload = new ORM_DOC_Document();
documentUpload.DOC_DocumentID = Guid.NewGuid();
documentUpload.IsDeleted = false;
documentUpload.Creation_Timestamp = DateTime.Now;
documentUpload.Tenant_RefID = securityTicket.TenantID;
documentUpload.Alias = Parameter.RecepiantID.ToString();
documentUpload.PrimaryType = Parameter.AmountNo.ToString();
documentUpload.GlobalPropertyMatchingID = "pdf doc";
documentUpload.Save(Connection, Transaction);
var documentUploadRevision = new ORM_DOC_DocumentRevision();
documentUploadRevision.DOC_DocumentRevisionID = Guid.NewGuid();
documentUploadRevision.Creation_Timestamp = DateTime.Now;
documentUploadRevision.File_MIMEType = Parameter.Mime;
documentUploadRevision.IsDeleted = false;
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.Description;
documentUploadRevision.Save(Connection, Transaction);
var usrAccount = ORM_USR_Account.Query.Search(Connection, Transaction, new ORM_USR_Account.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
USR_AccountID = securityTicket.AccountID
}).Single();
Guid DocStructureGuid = Guid.NewGuid();
var docStructureQ = ORM_DOC_Structure.Query.Search(Connection, Transaction, new ORM_DOC_Structure.Query()
{
IsDeleted = false,
Tenant_RefID = securityTicket.TenantID,
Label = usrAccount.BusinessParticipant_RefID.ToString()
}).SingleOrDefault();
if (docStructureQ == null)
{
var docStructure = new ORM_DOC_Structure();
docStructure.DOC_StructureID = DocStructureGuid;
docStructure.IsDeleted = false;
docStructure.Tenant_RefID = securityTicket.TenantID;
docStructure.Label = usrAccount.BusinessParticipant_RefID.ToString();
docStructure.Creation_Timestamp = DateTime.Now;
docStructure.Save(Connection, Transaction);
}
else
{
DocStructureGuid = docStructureQ.DOC_StructureID;
}
var doc2docStructure = new ORM_DOC_Document_2_Structure();
doc2docStructure.IsDeleted = false;
doc2docStructure.Tenant_RefID = securityTicket.TenantID;
doc2docStructure.Creation_Timestamp = DateTime.Now;
doc2docStructure.AssignmentID = Guid.NewGuid();
doc2docStructure.Document_RefID = documentUpload.DOC_DocumentID;
doc2docStructure.Structure_RefID = DocStructureGuid;
doc2docStructure.Save(Connection, Transaction);
Receipt_Model receipt = new Receipt_Model();
receipt.id = documentUpload.DOC_DocumentID.ToString();
receipt.documentID = Parameter.DocumentID.ToString();
receipt.filedate = Parameter.DocumentDate;
receipt.filedateString = Parameter.DocumentDate.ToString("dd.MM.yyyy");
receipt.period = Parameter.Description;
receipt.periodDate = Parameter.DocumentDate;
receipt.amount = Parameter.Amount;
receipt.doctorID = Parameter.RecepiantID.ToString();
receipt.amountNo = Parameter.AmountNo;
receipt.isViewed = false;
Add_Item_to_Receipts.Import_Receipt_Item_to_ElasticDB(new List <Receipt_Model>()
{
receipt
}, securityTicket.TenantID.ToString());
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L5EM_SUED_1648 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
//Put your code here
ORM_CMN_BPT_EMP_Employee_PayroleDocument.Query payroleDocumentQuery = new ORM_CMN_BPT_EMP_Employee_PayroleDocument.Query();
payroleDocumentQuery.Employee_RefID = Parameter.Employee_RefID;
payroleDocumentQuery.Tenant_RefID = securityTicket.TenantID;
payroleDocumentQuery.IsDeleted = false;
List <ORM_CMN_BPT_EMP_Employee_PayroleDocument> payroleDocumentList = ORM_CMN_BPT_EMP_Employee_PayroleDocument.Query.Search(Connection, Transaction, payroleDocumentQuery);
List <ORM_CMN_BPT_EMP_Employee_PayroleDocument> deletedDocumentList = new List <ORM_CMN_BPT_EMP_Employee_PayroleDocument>();
ORM_DOC_DocumentRevision docReviosion = new ORM_DOC_DocumentRevision();
ORM_DOC_Document docDocument;
FR_Base docRevisionResult = new FR_Base();
FR_Base docDocumentResult = new FR_Base();
foreach (var item in payroleDocumentList)
{
if (Parameter.Documents.Any(p => p.CMN_BPT_EMP_Employee_PayroleDocumentsID == item.CMN_BPT_EMP_Employee_PayroleDocumentsID))
{
continue;
}
if (item.Document_RefID != Guid.Empty)
{
docRevisionResult = docReviosion.Load(Connection, Transaction, item.Document_RefID);
}
if (docRevisionResult.Status == FR_Status.Success && docReviosion.DOC_DocumentRevisionID != Guid.Empty)
{
docReviosion.Remove(Connection, Transaction);
}
item.Remove(Connection, Transaction);
deletedDocumentList.Add(item);
}
payroleDocumentList = payroleDocumentList.Except(deletedDocumentList).ToList();
foreach (var payroleDocument in Parameter.Documents)
{
ORM_CMN_BPT_EMP_Employee_PayroleDocument payroleDocuments = new ORM_CMN_BPT_EMP_Employee_PayroleDocument();
if (payroleDocumentList.Any(item => item.CMN_BPT_EMP_Employee_PayroleDocumentsID == payroleDocument.CMN_BPT_EMP_Employee_PayroleDocumentsID))
{
payroleDocuments.Load(Connection, Transaction, payroleDocument.CMN_BPT_EMP_Employee_PayroleDocumentsID);
}
docDocument = new ORM_DOC_Document();
docReviosion = new ORM_DOC_DocumentRevision();
if (payroleDocuments.Document_RefID != Guid.Empty)
{
docRevisionResult = docReviosion.Load(Connection, Transaction, payroleDocument.DocumentID);
docDocumentResult = docDocument.Load(Connection, Transaction, docReviosion.Document_RefID);
}
docDocument.Alias = payroleDocument.File_Name;
docDocument.Tenant_RefID = securityTicket.TenantID;
docDocument.Save(Connection, Transaction);
docReviosion.DOC_DocumentRevisionID = payroleDocument.DocumentID;
docReviosion.Document_RefID = docDocument.DOC_DocumentID;
docReviosion.File_Name = payroleDocument.File_Name;
docReviosion.File_Description = payroleDocument.File_Description;
docReviosion.File_Extension = payroleDocument.File_Extension;
docReviosion.File_MIMEType = payroleDocument.File_MIMEType;
docReviosion.Tenant_RefID = securityTicket.TenantID;
docReviosion.Save(Connection, Transaction);
payroleDocuments.Tenant_RefID = securityTicket.TenantID;
payroleDocuments.Document_RefID = payroleDocument.DocumentID;
payroleDocuments.DocumentDate = payroleDocument.DocumentDate;
payroleDocuments.Employee_RefID = Parameter.Employee_RefID;
payroleDocuments.Save(Connection, Transaction);
}
return(returnValue);
#endregion UserCode
}
protected static FR_Guid Execute(DbConnection Connection, DbTransaction Transaction, P_L6PA_SBBVPP_1434 Parameter, CSV2Core.SessionSecurity.SessionSecurityTicket securityTicket = null)
{
#region UserCode
var returnValue = new FR_Guid();
P_L6PA_GBBVPfID_1714 getPatientParam = new P_L6PA_GBBVPfID_1714();
getPatientParam.HEC_PatientID = Parameter.HEC_PatientID;
L6PA_GBBVPfID_1714 patient = cls_Get_BBV_Patients_For_ID.Invoke(Connection, Transaction, getPatientParam, securityTicket).Result;
if (patient == null)
{
var error = new FR_Guid();
error.ErrorMessage = "No Such ID";
error.Status = FR_Status.Error_Internal;
return(error);
}
ORM_HEC_STU_Study currentStudy;
ORM_HEC_STU_Study.Query StudyQuer = new ORM_HEC_STU_Study.Query();
StudyQuer.Tenant_RefID = securityTicket.TenantID;
StudyQuer.IsDeleted = false;
StudyQuer.GlobalPropertyMatchingID = STLD_Sudies.Sudies_GlobalProperty;
var studyRes = ORM_HEC_STU_Study.Query.Search(Connection, Transaction, StudyQuer);
if (studyRes.Count == 0)
{
ORM_HEC_STU_Study study = new ORM_HEC_STU_Study();
study.GlobalPropertyMatchingID = STLD_Sudies.Sudies_GlobalProperty;
study.Tenant_RefID = securityTicket.TenantID;
study.Save(Connection, Transaction);
currentStudy = study;
}
else
{
currentStudy = studyRes[0];
}
ORM_HEC_STU_Study_ParticipatingPatient.Query ppQuery = new ORM_HEC_STU_Study_ParticipatingPatient.Query();
ppQuery.IsDeleted = false;
ppQuery.Tenant_RefID = securityTicket.TenantID;
ppQuery.HEC_STU_Study_ParticipatingPatientID = patient.HEC_STU_Study_ParticipatingPatientID;
var ppRes = ORM_HEC_STU_Study_ParticipatingPatient.Query.Search(Connection, Transaction, ppQuery);
ORM_HEC_STU_Study_ParticipatingPatient ParticipatingPatient = ppRes[0];
ParticipatingPatient.Study_RefID = currentStudy.HEC_STU_StudyID;
ParticipatingPatient.Participation_DateOfSigning = DateTime.Now;
ParticipatingPatient.Save(Connection, Transaction);
if (Parameter.Documents != null)
{
foreach (var doc in Parameter.Documents)
{
ORM_DOC_SLT_DocumentSlot currentSlot;
ORM_DOC_SLT_DocumentSlot.Query QueryORM_DOC_SLT_DocumentSlotQuery = new ORM_DOC_SLT_DocumentSlot.Query();
QueryORM_DOC_SLT_DocumentSlotQuery.Tenant_RefID = securityTicket.TenantID;
QueryORM_DOC_SLT_DocumentSlotQuery.IsDeleted = false;
QueryORM_DOC_SLT_DocumentSlotQuery.GlobalPropertyMatchingID = doc.DocSlot_GlobalPropertyMatching;
var QueryORM_DOC_SLT_DocumentSlotQueryRes = ORM_DOC_SLT_DocumentSlot.Query.Search(Connection, Transaction, QueryORM_DOC_SLT_DocumentSlotQuery);
if (QueryORM_DOC_SLT_DocumentSlotQueryRes.Count == 0)
{
ORM_DOC_SLT_DocumentSlot DocumentSlot = new ORM_DOC_SLT_DocumentSlot();
DocumentSlot.GlobalPropertyMatchingID = doc.DocSlot_GlobalPropertyMatching;
DocumentSlot.Tenant_RefID = securityTicket.TenantID;
DocumentSlot.Save(Connection, Transaction);
currentSlot = DocumentSlot;
}
else
{
currentSlot = QueryORM_DOC_SLT_DocumentSlotQueryRes[0];
}
ORM_HEC_STU_Study_ParticipationRequiredDocument ParticipationRequiredDocument = new ORM_HEC_STU_Study_ParticipationRequiredDocument();
ParticipationRequiredDocument.Tenant_RefID = securityTicket.TenantID;
ParticipationRequiredDocument.Study_RefID = currentStudy.HEC_STU_StudyID;
ParticipationRequiredDocument.DOC_SLT_DocumentSlot_RefID = currentSlot.DOC_SLT_DocumentSlotID;
ParticipationRequiredDocument.IsRequiredFor_PatientParticipation = true;
ParticipationRequiredDocument.Save(Connection, Transaction);
ORM_HEC_STU_Study_PatientDocument PatientDocument = new ORM_HEC_STU_Study_PatientDocument();
PatientDocument.Tenant_RefID = securityTicket.TenantID;
PatientDocument.ParticipatingPatient_RefID = ParticipatingPatient.HEC_STU_Study_ParticipatingPatientID;
PatientDocument.ParticipationRequiredDocument_RefID = ParticipationRequiredDocument.HEC_STU_Study_ParticipatingPatient_RequiredDocumentID;
PatientDocument.Document_RefID = Guid.NewGuid();
PatientDocument.Save(Connection, Transaction);
var document = new ORM_DOC_Document();
document.DOC_DocumentID = PatientDocument.Document_RefID;
document.Alias = doc.File_Name;
document.PrimaryType = doc.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 = PatientDocument.Document_RefID;
revision.Revision = 1;
revision.IsLastRevision = true;
revision.UploadedByAccount = securityTicket.AccountID;
revision.File_Name = doc.File_Name;
revision.File_ServerLocation = doc.File_ServerLocation;
revision.File_Extension = doc.File_Extension;
revision.File_Size_Bytes = doc.File_Size_Bytes;
revision.Creation_Timestamp = DateTime.Now;
revision.Tenant_RefID = securityTicket.TenantID;
revision.Save(Connection, Transaction);
}
}
return(returnValue);
#endregion UserCode
}
