// ----------------------------------------------------- // List Documents // ----------------------------------------------------- public static List <DocumentVersion> List(Model.ModelDocument.Document document) { var documentIssueList = new List <DocumentVersion>(); using (var connection = new MySqlConnection(ConnString.ConnectionString)) { var commandString = string.Format( " SELECT " + DocumentVersionFieldString() + " FROM " + DocumentVersion.TableName + " WHERE FKDocumentUID = '{0}'", document.UID); using (var command = new MySqlCommand( commandString, connection)) { connection.Open(); using (MySqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { DocumentVersion documentIssue = new DocumentVersion(); LoadObject(reader, documentIssue); documentIssueList.Add(documentIssue); } } } } return(documentIssueList); }
/// <summary> /// Load reader information into object /// </summary> /// <param name="reader"></param> /// <param name="documentIssue"></param> private static void LoadObject(MySqlDataReader reader, DocumentVersion documentIssue) { documentIssue.UID = Convert.ToInt32(reader["UID"].ToString()); documentIssue.FKDocumentUID = Convert.ToInt32(reader["FKDocumentUID"].ToString()); documentIssue.FKDocumentCUID = reader["FKDocumentCUID"].ToString(); documentIssue.IssueNumber = Convert.ToInt32(reader["IssueNumber"].ToString()); documentIssue.Location = reader["Location"].ToString(); documentIssue.FileName = reader["FileName"].ToString(); }