// -----------------------------------------------------
// Save Links
// -----------------------------------------------------
public static void LinkDocuments(int DocumentSetUID, int ParentID, int ChildID, string LinkType)
{
DocumentSetDocumentLink findOne = new DocumentSetDocumentLink();
if (findOne.Read(DocumentSetUID, ParentID, ChildID, LinkType))
{
// Already exists
}
else
{
findOne.LinkType = LinkType;
findOne.FKDocumentSetUID = DocumentSetUID;
findOne.FKParentDocumentUID = ParentID;
findOne.FKChildDocumentUID = ChildID;
findOne.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();
}
}
}
