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_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_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 }