// ------------------------------------------------------------
// Cop\y document links from Document Set Document Link
// ------------------------------------------------------------
public void ReplicateDocSetDocLinkToClient(int ClientUID, int ClientSetUID, int DocumentSetUID)
{
// 1... GetClientDocument
// List documents for a Client Set Document
//
var clientDocumentList = new ClientDocument();
clientDocumentList.List(ClientUID, ClientSetUID);
// 2... foreach( clientDocument )
// For each client document, retrieve the linked documents
//
foreach (var clientDocument in clientDocumentList.clientDocSetDocLink)
{
// 3...... GetDocumentChildren( currentClientDocument)
// This part retrieves Document Links and not ClientDocument Links
var children = DocumentSetDocumentLinkList.ListRelatedDocuments(DocumentSetUID, clientDocument.document.UID, type: "ALL");
// 4...... foreach (GetDocumentChildren)
foreach (var child in children.documentSetDocumentLinkList)
{
// 5..... CreateClientDocumentLink(Client,ClientSet,DocumentParent,DocumentChild, Type)
ClientDocumentLink newLink = new ClientDocumentLink();
newLink.FKClientDocumentSetUID = ClientSetUID;
newLink.FKClientUID = ClientUID;
newLink.FKParentDocumentUID = clientDocument.document.UID;
newLink.FKChildDocumentUID = child.FKChildDocumentUID;
newLink.LinkType = child.LinkType;
newLink.Add();
}
}
}
// -----------------------------------------------------
// Save Links
// -----------------------------------------------------
public static void LinkDocuments(
int clientUID,
int clientDocumentSetUID,
int parentDocumentUID, int childDocumentUID,
string LinkType)
{
ClientDocumentLink findOne = new ClientDocumentLink();
if (findOne.Read(
ParentID: parentDocumentUID,
ChildID: childDocumentUID,
LinkType: LinkType,
clientUID: clientUID,
clientDocumentSetUID: clientDocumentSetUID))
{
// Already exists
}
else
{
findOne.FKClientUID = clientUID;
findOne.FKClientDocumentSetUID = clientDocumentSetUID;
findOne.LinkType = LinkType;
findOne.FKParentDocumentUID = parentDocumentUID;
findOne.FKChildDocumentUID = childDocumentUID;
findOne.Add();
}
}
// -----------------------------------
// List children documents
// -----------------------------------
public void ListChildrenDocuments(
int clientUID,
int clientDocumentSetUID,
int documentUID,
string type)
{
string linktype = "";
if (type == "ALL" || string.IsNullOrEmpty(type))
{
// do nothing
}
else
{
linktype = " AND CDL.LinkType = '" + type + "'";
}
// The client document UID is unique
// The link table does not have document set uid
//
clientDocumentLinkList = new List <ClientDocumentLink>();
using (var connection = new SqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
" CDL.[UID] " +
" ,CDL.[FKChildDocumentUID] " +
" ,CDL.[FKParentDocumentUID] " +
" ,CDL.[LinkType] " +
" ,CDL.[IsVoid] " +
" ,CD.[UID] childUID" +
" ,CD.[FKClientUID] childFKClientUID" +
" ,CD.[FKClientDocumentSetUID] childFKClientDocumentSetUID" +
" ,CD.[FKDocumentUID] childFKDocumentUID" +
" ,CD.[SequenceNumber] childSequenceNumber" +
" ,CD.[StartDate] childStartDate" +
" ,CD.[EndDate] childEndDate" +
" ,CD.[SourceLocation] childSourceLocation" +
" ,CD.[SourceFileName] childSourceFileName" +
" ,CD.[Location] childLocation" +
" ,CD.[FileName] childFileName" +
" ,CD.[SourceIssueNumber] childIssueNumber" +
" ,CD.[Generated] childGenerated" +
" ,CD.[RecordType] childRecordType" +
" ,CD.[ParentUID] childParentUID" +
" ,CD.[IsVoid] childIsVoid" +
" ,PARENT.[UID] parentUID" +
" ,PARENT.[FKClientUID] parentFKClientUID" +
" ,PARENT.[FKClientDocumentSetUID] parentFKClientDocumentSetUID" +
" ,PARENT.[FKDocumentUID] parentFKDocumentUID" +
" ,PARENT.[SequenceNumber] parentSequenceNumber" +
" ,PARENT.[StartDate] parentStartDate" +
" ,PARENT.[EndDate] parentEndDate" +
" ,PARENT.[SourceLocation] parentSourceLocation" +
" ,PARENT.[SourceFileName] parentSourceFileName" +
" ,PARENT.[Location] parentLocation" +
" ,PARENT.[FileName] parentFileName" +
" ,PARENT.[SourceIssueNumber] parentIssueNumber" +
" ,PARENT.[Generated] parentGenerated" +
" ,PARENT.[RecordType] parentRecordType" +
" ,PARENT.[ParentUID] parentParentUID" +
" ,PARENT.[IsVoid] parentIsVoid" +
" FROM [ClientDocument] CD, " +
" [ClientDocumentLink] CDL," +
" [ClientDocument] PARENT" +
" WHERE " +
" CDL.IsVoid = 'N' " +
" AND PARENT.IsVoid = 'N' " +
" AND CD.IsVoid = 'N' " +
" AND CDL.FKParentDocumentUID = {0} " +
" AND CDL.FKClientDocumentSetUID = {1} " +
" AND CDL.FKClientUID = {2} " +
" AND CDL.FKChildDocumentUID = CD.FKDocumentUID " +
" AND CDL.FKParentDocumentUID = PARENT.FKDocumentUID " +
linktype +
" ORDER BY CD.ParentUID ASC, CD.SequenceNumber ASC "
, documentUID
, clientDocumentSetUID
, clientUID
);
using (var command = new SqlCommand(
commandString, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// Ignore voids
if (Convert.ToChar(reader["IsVoid"]) == 'Y')
{
continue;
}
var docItem = new ClientDocumentLink();
// Set Client Document Link Details
//
docItem.UID = Convert.ToInt32(reader["UID"].ToString());
docItem.FKParentDocumentUID = Convert.ToInt32(reader["FKParentDocumentUID"].ToString());
docItem.FKChildDocumentUID = Convert.ToInt32(reader["FKChildDocumentUID"].ToString());
docItem.isVoid = Convert.ToChar(reader["IsVoid"].ToString());
docItem.LinkType = reader["LinkType"].ToString();
// Set Client Document Child
//
docItem.childClientDocument = new ClientDocument();
docItem.childClientDocument.UID = Convert.ToInt32(reader["childUID"].ToString());
docItem.childClientDocument.FKDocumentUID = Convert.ToInt32(reader["childFKDocumentUID"].ToString());
docItem.childClientDocument.SequenceNumber = Convert.ToInt32(reader["childSequenceNumber"].ToString());
docItem.childClientDocument.FKClientDocumentSetUID = Convert.ToInt32(reader["childFKClientDocumentSetUID"].ToString());
docItem.childClientDocument.IsVoid = Convert.ToChar(reader["childIsVoid"].ToString());
docItem.childClientDocument.StartDate = Convert.ToDateTime(reader["childStartDate"].ToString());
docItem.childClientDocument.SourceLocation = reader["childSourceLocation"].ToString();
docItem.childClientDocument.SourceFileName = reader["childSourceFileName"].ToString();
docItem.childClientDocument.Location = reader["childLocation"].ToString();
docItem.childClientDocument.FileName = reader["childFileName"].ToString();
docItem.childClientDocument.SourceIssueNumber = Convert.ToInt32(reader["childIssueNumber"].ToString());
docItem.childClientDocument.Generated = Convert.ToChar(reader["childGenerated"]);
docItem.childClientDocument.RecordType = reader["childRecordType"].ToString();
docItem.childClientDocument.ParentUID = Convert.ToInt32(reader["childParentUID"].ToString());
//docItem.childClientDocument.EndDate = Convert.ToDateTime(reader["childEndDate"].ToString());
docItem.childClientDocument.EndDate = System.DateTime.MaxValue;
// Set Client Document Parent
//
docItem.parentClientDocument = new ClientDocument();
docItem.parentClientDocument.UID = Convert.ToInt32(reader["parentUID"].ToString());
docItem.parentClientDocument.FKDocumentUID = Convert.ToInt32(reader["parentFKDocumentUID"].ToString());
docItem.parentClientDocument.SequenceNumber = Convert.ToInt32(reader["parentSequenceNumber"].ToString());
docItem.parentClientDocument.FKClientDocumentSetUID = Convert.ToInt32(reader["parentFKClientDocumentSetUID"].ToString());
docItem.parentClientDocument.IsVoid = Convert.ToChar(reader["parentIsVoid"].ToString());
docItem.parentClientDocument.StartDate = Convert.ToDateTime(reader["parentStartDate"].ToString());
docItem.parentClientDocument.SourceLocation = reader["parentSourceLocation"].ToString();
docItem.parentClientDocument.SourceFileName = reader["parentSourceFileName"].ToString();
docItem.parentClientDocument.Location = reader["parentLocation"].ToString();
docItem.parentClientDocument.FileName = reader["parentFileName"].ToString();
docItem.parentClientDocument.SourceIssueNumber = Convert.ToInt32(reader["parentIssueNumber"].ToString());
docItem.parentClientDocument.Generated = Convert.ToChar(reader["parentGenerated"]);
docItem.parentClientDocument.RecordType = reader["parentRecordType"].ToString();
docItem.parentClientDocument.ParentUID = Convert.ToInt32(reader["parentParentUID"].ToString());
//docItem.parentClientDocument .EndDate = Convert.ToDateTime(reader["parentEndDate"].ToString());
docItem.parentClientDocument.EndDate = System.DateTime.MaxValue;
this.clientDocumentLinkList.Add(docItem);
}
}
}
}
}
public static ClientDocumentLinkList ListRelatedDocuments(
int clientUID,
int clientDocumentSetUID,
int documentUID,
string type)
{
ClientDocumentLinkList ret = new ClientDocumentLinkList();
ret.clientDocumentLinkList = new List <ClientDocumentLink>();
string linktype = "";
if (type == "ALL" || string.IsNullOrEmpty(type))
{
// do nothing
}
else
{
linktype = " AND CDL.LinkType = '" + type + "'";
}
using (var connection = new SqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format
(
"SELECT " +
" CDL.[UID] CDLUID " +
" ,CDL.[FKParentDocumentUID] CDLFKParentDocumentUID " +
" ,CDL.[FKChildDocumentUID] CDLFKChildDocumentUID " +
" ,CDL.[LinkType] CDLLinkType " +
" ,CDL.[IsVoid] CDLIsVoid " +
" ,CDL.[FKClientDocumentSetUID] CDLFKClientDocumentSetUID " +
" ,CDL.[FKClientUID] CDLFKClientUID " +
" " +
" FROM [management].[dbo].[ClientDocumentLink] CDL " +
" WHERE " +
" CDL.IsVoid = 'N' " +
" AND CDL.FKParentDocumentUID = {0} " +
" AND CDL.FKClientDocumentSetUID = {1} " +
" AND CDL.FKClientUID = {2} " +
linktype
, documentUID
, clientDocumentSetUID
, clientUID
);
using (var command = new SqlCommand(
commandString, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
ClientDocumentLink clientDocumentLink = new ClientDocumentLink();
clientDocumentLink.UID = Convert.ToInt32(reader["CDLUID"].ToString());
clientDocumentLink.FKParentDocumentUID = Convert.ToInt32(reader["CDLFKParentDocumentUID"].ToString());
clientDocumentLink.FKChildDocumentUID = Convert.ToInt32(reader["CDLFKChildDocumentUID"].ToString());
clientDocumentLink.LinkType = reader["CDLLinkType"].ToString();
clientDocumentLink.FKClientDocumentSetUID =
Convert.ToChar(reader["CDLFKClientDocumentSetUID"].ToString());
clientDocumentLink.FKClientUID = Convert.ToInt32(reader["CDLFKClientUID"].ToString());
// Get the client document child
clientDocumentLink.childClientDocument = new ClientDocument();
clientDocumentLink.childClientDocument.UID = clientDocumentLink.FKChildDocumentUID;
clientDocumentLink.childClientDocument.Read();
// Get the document child
clientDocumentLink.childDocument = new Document.Document();
clientDocumentLink.childDocument.UID = clientDocumentLink.FKChildDocumentUID;
clientDocumentLink.childDocument.Read();
// Get the client document parent
clientDocumentLink.parentClientDocument = new ClientDocument();
clientDocumentLink.parentClientDocument.UID = clientDocumentLink.FKParentDocumentUID;
clientDocumentLink.parentClientDocument.Read();
// Get the document parent
clientDocumentLink.parentDocument = new Document.Document();
clientDocumentLink.parentDocument.UID = clientDocumentLink.FKParentDocumentUID;
clientDocumentLink.parentDocument.Read();
// Get the client document set
clientDocumentLink.clientDocumentSet = new ClientDocumentSet();
clientDocumentLink.clientDocumentSet.UID = clientDocumentLink.FKClientDocumentSetUID;
clientDocumentLink.clientDocumentSet.Read();
ret.clientDocumentLinkList.Add(clientDocumentLink);
}
}
}
}
return(ret);
}
// ---------------------------------------------------------
// Copy document links to client document links
// ---------------------------------------------------------
public void ReplicateDocLinkToClientDeprecated(int ClientUID, int ClientSetUID)
{
// 1... GetClientDocument
// List documents for a Client Set Document
//
var clientDocumentList = new ClientDocument();
clientDocumentList.List(ClientUID, ClientSetUID);
// 2... foreach( clientDocument )
// For each client document, retrieve the linked documents
//
foreach (var clientDocument in clientDocumentList.clientDocSetDocLink)
{
// 3...... GetDocumentChildren( currentClientDocument)
// This part retrieves Document Links and not ClientDocument Links
// that's why we need to get the equivalent ClientDocumentUID...
var children = DocumentLinkList.ListRelatedDocuments(clientDocument.document.UID);
// 4...... foreach (GetDocumentChildren)
foreach (var child in children.documentLinkList)
{
// 5..... CreateClientDocumentLink(Client,ClientSet,DocumentParent,DocumentChild, Type)
ClientDocumentLink newLink = new ClientDocumentLink();
// This is the client document UID
newLink.FKParentDocumentUID = clientDocument.clientDocument.UID;
// Get clientUID for child document
ClientDocument childDocument = new ClientDocument();
//childDocument.FKDocumentUID = child.UID;
childDocument.FKDocumentUID = child.documentTo.UID;
childDocument.Find(child.documentTo.UID, clientDocument.clientDocumentSet.UID, 'N', ClientUID);
if (childDocument.UID > 0)
{
newLink.FKChildDocumentUID = childDocument.UID;
newLink.LinkType = child.LinkType; // Replace by link type
newLink.Add();
}
}
}
//using (var connection = new SqlConnection(ConnString.ConnectionString))
//{
// var commandString = string.Format(
// " SELECT " +
// " [UID] " +
// " FROM [ClientDocument] " +
// " WHERE " +
// " [FKClientUID] = {0} " +
// " AND [FKClientDocumentSetUID] = {1} ",
// ClientUID,
// ClientSetUID
// );
// using (var command = new SqlCommand(
// commandString, connection))
// {
// connection.Open();
// using (SqlDataReader reader = command.ExecuteReader())
// {
// while (reader.Read())
// {
// int ClientDocumentUID;
// ClientDocumentUID = Convert.ToInt32(reader["UID"].ToString());
// }
// }
// }
//}
}