/// <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); } } } } }