/// <summary>
/// Retrieve document details
/// </summary>
/// <param name="documentReadRequest"></param>
/// <returns></returns>
public static DocumentReadResponse DocumentRead(DocumentReadRequest documentReadRequest)
{
var documentRead = RepDocument.Read(
documentReadRequest.retrieveVoidedDocuments,
documentReadRequest.UID,
documentReadRequest.CUID);
var documentReadResponse = new DocumentReadResponse();
documentReadResponse.document = documentRead;
documentReadResponse.response = new ResponseStatus(MessageType.Informational);
return(documentReadResponse);
}
public static void ListInTree(
TreeView fileList,
DocumentSetDocumentLinkList documentList,
Model.ModelDocument.Document root)
{
// Find root folder
//
Model.ModelDocument.Document rootDocument = new Model.ModelDocument.Document();
rootDocument.CUID = root.CUID;
rootDocument.RecordType = root.RecordType;
rootDocument.UID = root.UID;
// rootDocument.Read();
rootDocument = RepDocument.Read(false, root.UID);
// Create root
//
var rootNode = new TreeNode(rootDocument.Name, MakConstant.Image.Folder, MakConstant.Image.Folder);
// Add root node to tree
//
fileList.Nodes.Add(rootNode);
rootNode.Tag = rootDocument;
rootNode.Name = rootDocument.Name;
foreach (var document in documentList.documentSetDocumentLinkList)
{
int image = 0;
image = Utils.ImageSelect(document.documentChild.RecordType.Trim());
var treeNode = new TreeNode(document.documentChild.Name, image, image);
treeNode.Tag = document;
treeNode.Name = document.LinkType;
rootNode.Nodes.Add(treeNode);
}
}
// -----------------------------------------------------
// Load documents in a tree
// -----------------------------------------------------
public static void ListInTree(
TreeView fileList,
DocumentLinkList documentList,
Model.ModelDocument.Document root)
{
// Find root folder
//
Model.ModelDocument.Document rootDocument = new Model.ModelDocument.Document();
rootDocument.CUID = root.CUID;
rootDocument.RecordType = root.RecordType;
rootDocument.UID = root.UID;
// rootDocument.Read();
rootDocument = RepDocument.Read(true, root.UID);
// Create root
//
var rootNode = new TreeNode(rootDocument.Name, MakConstant.Image.Folder, MakConstant.Image.Folder);
// Add root node to tree
//
fileList.Nodes.Add(rootNode);
rootNode.Tag = rootDocument;
rootNode.Name = rootDocument.Name;
foreach (var document in documentList.documentLinkList)
{
// Ignore root folder
if (document.documentTo.CUID == "ROOT")
{
continue;
}
// Check if folder has a parent
string cdocumentUID = document.UID.ToString();
string cparentIUID = document.documentTo.ParentUID.ToString();
int image = 0;
document.documentTo.RecordType = document.documentTo.RecordType.Trim();
image = Utils.ImageSelect(document.documentTo.RecordType);
if (document.documentTo.ParentUID == 0)
{
var treeNode = new TreeNode(document.documentTo.Name, image, image);
treeNode.Tag = document;
treeNode.Name = cdocumentUID;
rootNode.Nodes.Add(treeNode);
}
else
{
// Find the parent node
//
var node = fileList.Nodes.Find(cparentIUID, true);
if (node.Count() > 0)
{
var treeNode = new TreeNode(document.documentTo.Name, image, image);
treeNode.Tag = document;
treeNode.Name = cdocumentUID;
node[0].Nodes.Add(treeNode);
}
else
{
// Add Element to the root
//
var treeNode = new TreeNode(document.documentTo.Name, image, image);
treeNode.Tag = document;
treeNode.Name = cdocumentUID;
rootNode.Nodes.Add(treeNode);
}
}
}
}
// -----------------------------------------------------
// Load documents in a tree
// -----------------------------------------------------
public static void ListInTree(
TreeView fileList,
DocumentList documentList,
Model.ModelDocument.Document root)
{
// Find root folder
//
Model.ModelDocument.Document rootDocument = new Model.ModelDocument.Document();
rootDocument.CUID = root.CUID;
rootDocument.RecordType = root.RecordType;
rootDocument.UID = root.UID;
// rootDocument.Read();
rootDocument = RepDocument.Read(false, root.UID);
// Create root
//
var rootNode = new TreeNode(rootDocument.FileName, MakConstant.Image.Folder, MakConstant.Image.Folder);
// Add root node to tree
//
fileList.Nodes.Add(rootNode);
rootNode.Tag = rootDocument;
rootNode.Name = rootDocument.Name;
foreach (var document in documentList.documentList)
{
// Ignore root folder
if (document.CUID == "ROOT")
{
continue;
}
// Check if folder has a parent
string cdocumentUID = document.UID.ToString();
string cparentIUID = document.ParentUID.ToString();
int image = 0;
int imageSelected = 0;
document.RecordType = document.RecordType.Trim();
#region Image
switch (document.DocumentType)
{
case Utils.DocumentType.WORD:
image = MakConstant.Image.Word32;
imageSelected = MakConstant.Image.Word32;
// I have to think about this...
//
if (document.RecordType == Utils.RecordType.APPENDIX)
{
image = MakConstant.Image.Appendix;
imageSelected = MakConstant.Image.Appendix;
}
break;
case Utils.DocumentType.EXCEL:
image = MakConstant.Image.Excel;
imageSelected = MakConstant.Image.Excel;
break;
case Utils.DocumentType.FOLDER:
image = MakConstant.Image.Folder;
imageSelected = MakConstant.Image.Folder;
break;
case Utils.DocumentType.PDF:
image = MakConstant.Image.PDF;
imageSelected = MakConstant.Image.PDF;
break;
default:
image = MakConstant.Image.Word32;
imageSelected = MakConstant.Image.Word32;
break;
}
#endregion Image
if (document.ParentUID == 0)
{
var treeNode = new TreeNode(document.FileName, image, image);
treeNode.Tag = document;
treeNode.Name = cdocumentUID;
rootNode.Nodes.Add(treeNode);
}
else
{
// Find the parent node
//
var node = fileList.Nodes.Find(cparentIUID, true);
if (node.Count() > 0)
{
var treeNode = new TreeNode(document.FileName, image, imageSelected);
treeNode.Tag = document;
treeNode.Name = cdocumentUID;
node[0].Nodes.Add(treeNode);
}
else
{
// Add Element to the root
//
var treeNode = new TreeNode(document.FileName, image, imageSelected);
treeNode.Tag = document;
treeNode.Name = cdocumentUID;
rootNode.Nodes.Add(treeNode);
}
}
}
}
//
// It returns a list of links for a given document set UID
//
public void List(DocumentSet documentSet)
{
documentSetDocumentList = new List <scDocoSetDocumentLink>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
" UID " +
" ,FKDocumentUID " +
" ,FKDocumentSetUID " +
" ,StartDate " +
" ,EndDate " +
" ,IsVoid " +
" FROM DocumentSetDocument " +
" WHERE FKDocumentSetUID = {0} ",
documentSet.UID
);
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// Ignore voids
if (Convert.ToChar(reader["IsVoid"]) == 'Y')
{
continue;
}
var docItem = new scDocoSetDocumentLink();
// Get document
//
docItem.document = new Model.ModelDocument.Document();
docItem.document.UID = Convert.ToInt32(reader["FKDocumentUID"]);
// 11.01.2013
//
// docItem.document.Read();
docItem.document = RepDocument.Read(true, docItem.document.UID);
// Get DocumentSet
//
docItem.documentSet = new DocumentSet();
docItem.documentSet.UID = Convert.ToInt32(reader["FKDocumentSetUID"].ToString());
// Set DocumentSetDocument
docItem.DocumentSetDocument = new DocumentSetDocument();
docItem.DocumentSetDocument.UID = Convert.ToInt32(reader["UID"].ToString());
docItem.DocumentSetDocument.FKDocumentUID = Convert.ToInt32(reader["FKDocumentUID"].ToString());
docItem.DocumentSetDocument.FKDocumentSetUID = Convert.ToInt32(reader["FKDocumentSetUID"].ToString());
docItem.DocumentSetDocument.IsVoid = Convert.ToChar(reader["IsVoid"].ToString());
docItem.DocumentSetDocument.StartDate = Convert.ToDateTime(reader["StartDate"].ToString());
if (reader["EndDate"] == null)
{
docItem.DocumentSetDocument.EndDate = System.DateTime.MaxValue;
}
else
{
docItem.DocumentSetDocument.EndDate = Convert.ToDateTime(reader["EndDate"].ToString());
}
documentSetDocumentList.Add(docItem);
}
}
}
return;
}
}
/// <summary>
/// Retrieve document details
/// </summary>
/// <returns></returns>
public static Document GetRootDocument()
{
var documentRead = RepDocument.Read(false, 0, "ROOT");
return(documentRead);
}
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 MySqlConnection(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 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 MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader 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;
// 04.02.2013
// clientDocumentLink.childClientDocument.Read();
clientDocumentLink.childClientDocument = RepClientDocument.Read(clientDocumentLink.FKChildDocumentUID);
// Get the document child
clientDocumentLink.childDocument = new Model.ModelDocument.Document();
clientDocumentLink.childDocument.UID = clientDocumentLink.FKChildDocumentUID;
// clientDocumentLink.childDocument.Read();
clientDocumentLink.childDocument = RepDocument.Read(false, clientDocumentLink.FKChildDocumentUID);
// Get the client document parent
clientDocumentLink.parentClientDocument = new ClientDocument();
clientDocumentLink.parentClientDocument.UID = clientDocumentLink.FKParentDocumentUID;
//clientDocumentLink.parentClientDocument.Read();
clientDocumentLink.parentClientDocument = RepClientDocument.Read(clientDocumentLink.FKParentDocumentUID);
// Get the document parent
clientDocumentLink.parentDocument = new Model.ModelDocument.Document();
clientDocumentLink.parentDocument.UID = clientDocumentLink.FKParentDocumentUID;
// clientDocumentLink.parentDocument.Read();
clientDocumentLink.parentDocument =
RepDocument.Read(false, clientDocumentLink.FKParentDocumentUID);
// Get the client document set
clientDocumentLink.clientDocumentSet = new ClientDocumentSet();
clientDocumentLink.clientDocumentSet.UID = clientDocumentLink.FKClientDocumentSetUID;
clientDocumentLink.clientDocumentSet.Read();
ret.clientDocumentLinkList.Add(clientDocumentLink);
}
}
}
}
return(ret);
}
//
// List documents for a client
//
public void List(int clientID, int clientDocumentSetUID)
{
clientDocSetDocLink = new List <scClientDocSetDocLink>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
" UID " +
" ,FKClientUID " +
" ,FKClientDocumentSetUID " +
" ,FKDocumentUID " +
" ,SequenceNumber " +
" ,StartDate " +
" ,EndDate " +
" ,IsVoid " +
" ,SourceLocation " +
" ,SourceFileName " +
" ,Location " +
" ,FileName " +
" ,SourceIssueNumber " +
" ,Generated " +
" ,RecordType " +
" ,ParentUID " +
" FROM ClientDocument " +
" WHERE FKClientUID = {0} " +
" AND FKClientDocumentSetUID = {1} " +
" ORDER BY ParentUID ASC, SequenceNumber ASC ",
clientID,
clientDocumentSetUID
);
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
// Ignore voids
if (Convert.ToChar(reader["IsVoid"]) == 'Y')
{
continue;
}
var docItem = new scClientDocSetDocLink();
// Get document
//
docItem.document = new Model.ModelDocument.Document();
docItem.document.UID = Convert.ToInt32(reader["FKDocumentUID"]);
// docItem.document.Read();
docItem.document = RepDocument.Read(false, docItem.document.UID);
// Get Client Document Set
//
docItem.clientDocumentSet = new ClientDocumentSet();
docItem.clientDocumentSet.UID = Convert.ToInt32(reader["FKClientDocumentSetUID"].ToString());
docItem.clientDocumentSet.FKClientUID = Convert.ToInt32(reader["FKClientUID"].ToString());
// Set Client Document
//
docItem.clientDocument = new ClientDocument();
docItem.clientDocument.UID = Convert.ToInt32(reader["UID"].ToString());
docItem.clientDocument.FKDocumentUID = Convert.ToInt32(reader["FKDocumentUID"].ToString());
docItem.clientDocument.SequenceNumber = Convert.ToInt32(reader["SequenceNumber"].ToString());
docItem.clientDocument.FKClientDocumentSetUID = Convert.ToInt32(reader["FKClientDocumentSetUID"].ToString());
docItem.clientDocument.IsVoid = Convert.ToChar(reader["IsVoid"].ToString());
docItem.clientDocument.StartDate = Convert.ToDateTime(reader["StartDate"].ToString());
docItem.clientDocument.SourceLocation = reader["SourceLocation"].ToString();
docItem.clientDocument.SourceFileName = reader["SourceFileName"].ToString();
docItem.clientDocument.Location = reader["Location"].ToString();
docItem.clientDocument.FileName = reader["FileName"].ToString();
docItem.clientDocument.SourceIssueNumber = Convert.ToInt32(reader["SourceIssueNumber"].ToString());
docItem.clientDocument.Generated = Convert.ToChar(reader["Generated"]);
docItem.clientDocument.RecordType = reader["RecordType"].ToString();
docItem.clientDocument.ParentUID = Convert.ToInt32(reader["ParentUID"].ToString());
try
{
docItem.clientDocument.EndDate = Convert.ToDateTime(reader["EndDate"].ToString());
}
catch
{
docItem.clientDocument.EndDate = System.DateTime.MaxValue;
}
this.clientDocSetDocLink.Add(docItem);
}
}
}
}
}
