private void createDocumentReview()
        {
            //populate so user can input necessary data
            DocumentDisplayForm ddf = new DocumentDisplayForm(df.createDocument(name, description, componentsList));
            if (ddf.ShowDialog() == DialogResult.OK)
            {
                //Serializes the newly created document. This should be added to each Wizard.
                TemplateStorage document = new TemplateStorage(name, version, description, componentsList);
                Serialization saveDocument = new Serialization();
                string output = saveDocument.serialize(document);

                String nextSqlText = "INSERT INTO Template (templateName, templateDescription, dateCreated, templateData, enabled) VALUES ('" + document.Name + "', '" + document.Description + "', '" + DateTime.Now.Date + "', '" + output + "', " + 1 + ");";
                DBCommand insertSqlCmd = DBConnection.makeCommand(nextSqlText);
                insertSqlCmd.RunNoReturnQuery();
                parentForm.refreshAll();
                this.Close();
            }
            else
            {
                this.componentsList.Clear();
            }
        }
예제 #2
0
        /// <summary>
        /// Gets the document's data and the associated template and then generates the document for the user to view.
        /// </summary>
        private void getTemplate()
        {
            if (projectTreeView.SelectedNode.Nodes.Count == 0 && projectTreeView.SelectedNode.Text != "Documents" && projectTreeView.SelectedNode.Level != 0)
            {
                newDocument = false;
                Serialization saveDocument = new Serialization();

                string getVersionIDText = "SELECT Version.versionID, Project.projectID FROM Version, Project WHERE Version.versionNumber=" + projectTreeView.SelectedNode.Parent.Parent.Text.Substring(7) + " AND Project.projectName='" + projectTreeView.SelectedNode.Parent.Parent.Parent.Text + "' AND Version.project = Project.projectID;";
                DBCommand getVersionIDCmd = DBConnection.makeCommand(getVersionIDText);
                SqlCeDataReader getVersionIDReader = getVersionIDCmd.Start();
                int versionID;
                int projectID;
                getVersionIDReader.Read();
                versionID = getVersionIDReader.GetInt32(0);
                projectID = getVersionIDReader.GetInt32(1);

                string getTemplateTypeSqlText = "SELECT documentType FROM Document WHERE documentName='" + projectTreeView.SelectedNode.Text + "' AND versionID=" + versionID + ";";
                DBCommand getTemplateTypeSqlCmd = DBConnection.makeCommand(getTemplateTypeSqlText);
                SqlCeDataReader getTemplateTypeSqlReader = getTemplateTypeSqlCmd.Start();
                String templateType = "";
                while (getTemplateTypeSqlReader.Read())
                {
                    templateType += getTemplateTypeSqlReader.GetString(0);
                }

                string getTemplateSqlText = "SELECT templateData FROM Template WHERE templateName='" + templateType + "';";
                DBCommand getTemplateSqlCmd = DBConnection.makeCommand(getTemplateSqlText);
                SqlCeDataReader getTemplateSqlReader = getTemplateSqlCmd.Start();
                String templateInput = "";
                while (getTemplateSqlReader.Read())
                {
                    templateInput += getTemplateSqlReader.GetString(0);
                }
                //Testing the deSerialize method.
                TemplateStorage templateStorage = new TemplateStorage();
                templateStorage = (TemplateStorage)saveDocument.deSerialize(templateStorage, templateInput);
                this.templateStorage = templateStorage;
                List<string> genericList = new List<string>(templateStorage.Componentlist);

                DocumentFactory df = new DocumentFactory();
                outputPanel.Controls.Clear();
                outputPanel.Controls.Add(df.createDocument(templateStorage.Name, templateStorage.Version, genericList));
                templateControlToolStrip.Enabled = true;

                string getDocSqlText = "SELECT documentID, data FROM Document, Version WHERE documentName='" + projectTreeView.SelectedNode.Text + "' AND Document.versionID=" + versionID + ";";
                DBCommand getDocSqlCmd = DBConnection.makeCommand(getDocSqlText);
                SqlCeDataReader getDocSqlReader = getDocSqlCmd.Start();
                String documentData = "";

                getDocSqlReader.Read();
                this.documentID = (int)getDocSqlReader.GetSqlInt32(0);
                documentData += getDocSqlReader.GetString(1);

                while (getDocSqlReader.Read())
                {

                }
                DocumentStorage documentStorage = new DocumentStorage();
                documentStorage = (DocumentStorage)saveDocument.deSerialize(documentStorage, documentData);

                string[] controlData = documentStorage.DocumentData;
                if (controlData != null)
                {
                    int counter = 0;
                    for (int i = 0; i < outputPanel.Controls[0].Controls[2].Controls.Count; i++)
                    {
                        if (i % 2 != 0)
                        {
                            outputPanel.Controls[0].Controls[2].Controls[i].Text = controlData[counter];
                            counter++;
                        }
                    }
                }
            }
        }
예제 #3
0
        private void useTemplateButton_Click(object sender, EventArgs e)
        {
            exampleOutputPanel.Controls.Clear();
            if (templateListView.SelectedItems.Count > 0)
            {
                newDocument = true;
                string nextSqlText = "SELECT templateData FROM Template WHERE templateName='" + templateListView.SelectedItems[0].Text + "';";
                DBCommand nextSqlCmd = DBConnection.makeCommand(nextSqlText);
                SqlCeDataReader nextSqlReader = nextSqlCmd.Start();
                String input = "";
                while (nextSqlReader.Read())
                {
                    input += nextSqlReader.GetString(0);
                }

                nextSqlCmd.Stop(); //Stops command.
                //Testing the deSerialize method.
                TemplateStorage templateStorage = new TemplateStorage();
                Serialization saveDocument = new Serialization();
                templateStorage = (TemplateStorage)saveDocument.deSerialize(templateStorage, input);
                this.templateStorage = templateStorage;
                List<string> genericList = new List<string>(templateStorage.Componentlist);

                DocumentFactory df = new DocumentFactory();
                outputPanel.Controls.Clear();
                outputPanel.Controls.Add(df.createDocument(templateStorage.Name, templateStorage.Description, genericList));
                templateControlToolStrip.Enabled = true;

                string next1SqlText = "SELECT documentID FROM Document WHERE documentType='" + templateListView.SelectedItems[0].Text + "';";
                DBCommand next1SqlCmd = DBConnection.makeCommand(next1SqlText);
                SqlCeDataReader next1SqlReader = next1SqlCmd.Start();
                int input1=0;
                if (next1SqlReader.Read())
                {
                    input1 = next1SqlReader.GetInt32(0);
                }
                                nextSqlCmd.Stop(); //Stops command.
                if (input1 == 0)
                {
                    Label noTemp = new Label();
                    noTemp.AutoSize = true;
                    noTemp.Text = "The Template has not been used.";
                    exampleOutputPanel.Controls.Add(noTemp);
                }
                else
                {
                    getExample(input1, templateListView.SelectedItems[0].Text);
                }
            }
        }
예제 #4
0
        private void getExample(int documentID, String docuType)
        {
            Serialization saveDocument = new Serialization();

                string getTemplateSqlText = "SELECT templateData FROM Template WHERE templateName='" + docuType + "';";
                DBCommand getTemplateSqlCmd = DBConnection.makeCommand(getTemplateSqlText);
                SqlCeDataReader getTemplateSqlReader = getTemplateSqlCmd.Start();
                String templateInput = "";
                while (getTemplateSqlReader.Read())
                {
                    templateInput += getTemplateSqlReader.GetString(0);
                }
                //Testing the deSerialize method.
                TemplateStorage templateStorage = new TemplateStorage();
                templateStorage = (TemplateStorage)saveDocument.deSerialize(templateStorage, templateInput);
                this.templateStorage = templateStorage;
                List<string> genericList = new List<string>(templateStorage.Componentlist);

                DocumentFactory df = new DocumentFactory();
                exampleOutputPanel.Controls.Clear();
                exampleOutputPanel.Controls.Add(df.createDocument(templateStorage.Name, templateStorage.Version, genericList));

                string getDocSqlText = "SELECT data FROM Document WHERE documentID='" + documentID + "';";
                DBCommand getDocSqlCmd = DBConnection.makeCommand(getDocSqlText);
                SqlCeDataReader getDocSqlReader = getDocSqlCmd.Start();
                String documentData = "";

                getDocSqlReader.Read();
                documentData += getDocSqlReader.GetString(0);

                DocumentStorage documentStorage = new DocumentStorage();
                documentStorage = (DocumentStorage)saveDocument.deSerialize(documentStorage, documentData);

                string[] controlData = documentStorage.DocumentData;
                if (controlData != null)
                {
                    int counter = 0;
                    for (int i = 0; i < outputPanel.Controls[0].Controls[2].Controls.Count; i++)
                    {
                        if (i % 2 != 0)
                        {
                            exampleOutputPanel.Controls[0].Controls[2].Controls[i].Text = controlData[counter];
                            counter++;
                        }
                    }
                }
        }