// -----------------------------------------------------
// List Documents for a client
// -----------------------------------------------------
public void ListClient(int clientUID)
{
this.documentList = new List <Model.ModelDocument.Document>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
RepDocument.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 MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Model.ModelDocument.Document _Document = new Model.ModelDocument.Document();
RepDocument.LoadDocumentFromReader(_Document, "DOC", reader);
documentList.Add(_Document);
}
}
}
}
}
// -----------------------------------------------------
// List Documents
// -----------------------------------------------------
private void List(string Condition)
{
this.documentList = new List <Model.ModelDocument.Document>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
RepDocument.SQLDocumentConcat("DOC") +
" FROM Document DOC " +
" WHERE DOC.SourceCode = 'FCM' " +
" AND DOC.IsVoid = 'N' " +
Condition +
" ORDER BY PARENTUID ASC, SequenceNumber ASC "
);
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Model.ModelDocument.Document _Document = new Model.ModelDocument.Document();
RepDocument.LoadDocumentFromReader(_Document, "DOC", reader);
documentList.Add(_Document);
}
}
}
}
}
// -----------------------------------------------------
// List Documents for a Document Set
// -----------------------------------------------------
public void ListDocSet(int documentSetUID)
{
this.documentList = new List <Model.ModelDocument.Document>();
using (var connection = new MySqlConnection(ConnString.ConnectionString))
{
var commandString = string.Format(
" SELECT " +
RepDocument.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 MySqlCommand(
commandString, connection))
{
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
Model.ModelDocument.Document _Document = new Model.ModelDocument.Document();
RepDocument.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 Model.ModelDocument.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 MySqlConnection(ConnString.ConnectionString))
{
using (var command = new MySqlCommand(
commandString, connection))
{
connection.Open();
MySqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
try
{
// Document
//
RepDocument.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);
}
