public void LinkDocumentListToSet(ListOfscDocoSetDocumentLink docListToLink) { // for each document in the list // check if it is already linked with document set // if it is not linked, add a new link record // otherwise, ignore link. foreach (var doco in docListToLink.list) { DocumentSetDocument dslLocate = new DocumentSetDocument(); dslLocate.StartDate = DateTime.Today; dslLocate.IsVoid = 'N'; dslLocate.FKDocumentUID = doco.document.UID; dslLocate.FKDocumentSetUID = doco.documentSet.UID; if (dslLocate.Find(doco.document.UID, doco.documentSet.UID, 'N')) { // Fact: There is an existing non-voided row // Intention (1): Make it void // Intention (2): Do nothing // // Check for Intention (1) // if (doco.DocumentSetDocument.IsVoid == 'Y') { // Update row to make it voided... // Update(doco.DocumentSetDocument.UID); } // else, do nothing } else { // if the pair does not exist, check if it is void. // If void = Y, just ignore. if (doco.DocumentSetDocument.IsVoid == 'Y') { // just ignore. The pair was not saved initially. } else { // add document to set DocumentSetDocument dslAdd = new DocumentSetDocument(); dslAdd.StartDate = DateTime.Today; dslAdd.IsVoid = 'N'; dslAdd.FKDocumentUID = doco.document.UID; dslAdd.FKDocumentSetUID = doco.documentSet.UID; dslAdd.Add(); } } } }
// ----------------------------------------------------- // Load document into document set // ----------------------------------------------------- public void LoadAllDocuments() { // Retrieve all documents // For each document (order by parent uid) // check if it is already connected to current Document Set // If it is not, connect document // Link with parent document in the set // Replicate Document Links DocumentList dl = new DocumentList(); dl.List(); foreach (Document document in dl.documentList) { var found = DocumentSet.FindDocumentInSet(this.UID, document.UID); if (found.document.UID > 0) { continue; } else { DocumentSetDocument dsl = new DocumentSetDocument(); // Generate new UID dsl.UID = this.GetLastUID() + 1; // Add document to set // dsl.FKDocumentSetUID = this.UID; dsl.FKDocumentUID = document.UID; dsl.Location = document.Location; dsl.IsVoid = 'N'; dsl.StartDate = System.DateTime.Today; dsl.EndDate = System.DateTime.MaxValue; dsl.FKParentDocumentUID = document.ParentUID; // Uses the Document UID as the source (Has to be combined with Doc Set) dsl.FKParentDocumentSetUID = dsl.FKDocumentSetUID; dsl.SequenceNumber = document.SequenceNumber; dsl.Add(); } } // Replicate document links // foreach (Document document in dl.documentList) { var children = DocumentLinkList.ListRelatedDocuments(document.UID); foreach (var child in children.documentLinkList) { // DocumentSetDocumentLink dsdl = new DocumentSetDocumentLink(); dsdl.FKParentDocumentUID = 0; dsdl.FKChildDocumentUID = 0; dsdl.IsVoid = 'N'; dsdl.LinkType = child.LinkType; dsdl.UID = GetLastUID() + 1; // Find parent var parent1 = DocumentSet.FindDocumentInSet(this.UID, child.FKParentDocumentUID); // Find child var child1 = DocumentSet.FindDocumentInSet(this.UID, child.FKChildDocumentUID); dsdl.FKParentDocumentUID = parent1.DocumentSetDocument.UID; dsdl.FKChildDocumentUID = child1.DocumentSetDocument.UID; dsdl.Add(); } } }