// ----------------------------------------------------- // List Documents // ----------------------------------------------------- private void List(string Condition) { this.documentList = new List <Document>(); using (var connection = new SqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + Document.SQLDocumentConcat("DOC") + " FROM [Document] DOC " + " WHERE DOC.[SourceCode] = 'FCM' " + " AND DOC.[IsVoid] = 'N' " + Condition + " ORDER BY PARENTUID ASC, SequenceNumber ASC " ); using (var command = new SqlCommand( commandString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Document _Document = new Document(); Document.LoadDocumentFromReader(_Document, "DOC", reader); this.documentList.Add(_Document); } } } } }
// ----------------------------------------------------- // List Documents for a client // ----------------------------------------------------- public void ListClient(int clientUID) { this.documentList = new List <Document>(); using (var connection = new SqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + Document.SQLDocumentConcat("DOC") + " FROM [Document] DOC " + " WHERE [SourceCode] = 'CLIENT' " + " AND [FKClientUID] = {0} " + " AND [IsVoid] <> 'Y' " + " ORDER BY PARENTUID ASC, SequenceNumber ASC ", clientUID); using (var command = new SqlCommand( commandString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Document _Document = new Document(); Document.LoadDocumentFromReader(_Document, "DOC", reader); this.documentList.Add(_Document); } } } } }
// ----------------------------------------------------- // List Documents for a Document Set // ----------------------------------------------------- public void ListDocSet(int documentSetUID) { this.documentList = new List <Document>(); using (var connection = new SqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + Document.SQLDocumentConcat("DOC") + " ,[LNK].[FKParentDocumentUID] " + " ,[LNK].[FKParentDocumentSetUID] " + " ,[LNK].[SequenceNumber] " + " FROM [Document] DOC " + " ,[DocumentSetDocument] LNK" + " WHERE " + " [LNK].[FKDocumentUID] = [DOC].[UID] " + " AND [DOC].[SourceCode] = 'FCM' " + " AND [LNK].[IsVoid] = 'N' " + " AND [DOC].[IsVoid] = 'N' " + " AND [LNK].[FKDocumentSetUID] = {0} " + " ORDER BY [LNK].FKParentDocumentUID ASC, [LNK].SequenceNumber ", documentSetUID ); using (var command = new SqlCommand( commandString, connection)) { connection.Open(); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Document _Document = new Document(); Document.LoadDocumentFromReader(_Document, "DOC", reader); // This is necessary because when the list comes from DocumentSet, the parent may change // _Document.ParentUID = Convert.ToInt32(reader["FKParentDocumentUID"].ToString()); this.documentList.Add(_Document); } } } } }
// ----------------------------------------------------- // Get Document Details // ----------------------------------------------------- public static scDocoSetDocumentLink FindDocumentInSet(int documentSetUID, int documentUID) { // // EA SQL database // scDocoSetDocumentLink ret = new scDocoSetDocumentLink(); ret.document = new Document(); ret.documentSet = new DocumentSet(); ret.DocumentSetDocument = new DocumentSetDocument(); string commandString = ""; commandString = string.Format( " SELECT " + " [Document].[UID] DocumentUID" + " ,[Document].[CUID] DocumentCUID " + " ,[Document].[Name] DocumentName " + " ,[Document].[SequenceNumber] DocumentSequenceNumber " + " ,[Document].[IssueNumber] DocumentIssueNumber " + " ,[Document].[Location] DocumentLocation " + " ,[Document].[Comments] DocumentComments" + " ,[Document].[UID] DocumentUID" + " ,[Document].[FileName] DocumentFileName" + " ,[Document].[SourceCode] DocumentSourceCode" + " ,[Document].[FKClientUID] DocumentFKClientUID" + " ,[Document].[ParentUID] DocumentParentUID" + " ,[Document].[RecordType] DocumentRecordType" + " ,[Document].[IsProjectPlan] DocumentIsProjectPlan" + " ,[Document].[DocumentType] DocumentDocumentType" + " ,[DocSetDoc].[UID] DocSetDocUID" + " ,[DocSetDoc].[FKDocumentUID] DocSetDocFKDocumentUID" + " ,[DocSetDoc].[FKDocumentSetUID] DocSetDocFKDocumentSetUID" + " ,[DocSetDoc].[Location] DocSetDocLocation" + " ,[DocSetDoc].[IsVoid] DocSetDocIsVoid" + " ,[DocSetDoc].[StartDate] DocSetDocStartDate" + " ,[DocSetDoc].[EndDate] DocSetDocEndDate" + " ,[DocSetDoc].[FKParentDocumentUID] DocSetDocFKParentDocumentUID" + " ,[DocSetDoc].[FKParentDocumentSetUID] DocSetDocFKParentDocumentSetUID" + " ,[DocSet].[UID] SetUID" + " ,[DocSet].[TemplateType] SetTemplateType" + " ,[DocSet].[TemplateFolder] SetTemplateFolder" + " FROM [Document] Document" + " ,[DocumentSetDocument] DocSetDoc " + " ,[DocumentSet] DocSet " + " WHERE " + " [Document].[UID] = [DocSetDoc].[FKDocumentUID] " + " AND [DocSetDoc].[FKDocumentSetUID] = [DocSet].[UID] " + " AND [Document].[UID] = {0} " + " AND [DocSetDoc].[FKDocumentSetUID] = {1}", documentUID, documentSetUID); using (var connection = new SqlConnection(ConnString.ConnectionString)) { using (var command = new SqlCommand( commandString, connection)) { connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { try { // Document // Document.LoadDocumentFromReader(ret.document, "", reader); //ret.document.UID = Convert.ToInt32(reader["DocumentUID"].ToString()); //ret.document.CUID = reader["DocumentCUID"].ToString(); //ret.document.Name = reader["DocumentName"].ToString(); //ret.document.SequenceNumber = Convert.ToInt32(reader["DocumentSequenceNumber"].ToString()); //ret.document.IssueNumber = Convert.ToInt32(reader["DocumentIssueNumber"].ToString()); //ret.document.Location = reader["DocumentLocation"].ToString(); //ret.document.Comments = reader["DocumentComments"].ToString(); //ret.document.FileName = reader["DocumentFileName"].ToString(); //ret.document.SourceCode = reader["DocumentSourceCode"].ToString(); //ret.document.FKClientUID = Convert.ToInt32(reader["DocumentFKClientUID"].ToString()); //ret.document.ParentUID = Convert.ToInt32(reader["DocumentParentUID"].ToString()); //ret.document.RecordType = reader["DocumentRecordType"].ToString(); //ret.document.IsProjectPlan = Convert.ToChar(reader["DocumentIsProjectPlan"]); //ret.document.DocumentType = reader["DocumentDocumentType"].ToString(); // Document Set // ret.documentSet.UID = Convert.ToInt32(reader["SetUID"].ToString()); ret.documentSet.TemplateType = reader["SetTemplateType"].ToString(); ret.documentSet.TemplateFolder = reader["SetTemplateFolder"].ToString(); ret.documentSet.UIDNameDisplay = ret.documentSet.UID.ToString() + "; " + ret.documentSet.TemplateType; // DocumentSetDocument // ret.DocumentSetDocument.UID = Convert.ToInt32(reader["DocSetDocUID"].ToString()); ret.DocumentSetDocument.FKDocumentUID = Convert.ToInt32(reader["DocSetDocFKDocumentUID"].ToString()); ret.DocumentSetDocument.FKDocumentSetUID = Convert.ToInt32(reader["DocSetDocFKDocumentSetUID"].ToString()); ret.DocumentSetDocument.Location = reader["DocSetDocLocation"].ToString(); ret.DocumentSetDocument.IsVoid = Convert.ToChar(reader["DocSetDocIsVoid"].ToString()); ret.DocumentSetDocument.StartDate = Convert.ToDateTime(reader["DocSetDocStartDate"].ToString()); ret.DocumentSetDocument.EndDate = Convert.ToDateTime(reader["DocSetDocEndDate"].ToString()); ret.DocumentSetDocument.FKParentDocumentUID = Convert.ToInt32(reader["DocSetDocFKParentDocumentUID"].ToString()); ret.DocumentSetDocument.FKParentDocumentSetUID = Convert.ToInt32(reader["DocSetDocFKParentDocumentSetUID"].ToString()); } catch { } } } } return(ret); }