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
}