TryExportToNodeXLGraphGallery ( Microsoft.Office.Interop.Excel.Workbook oWorkbook, NodeXLControl oNodeXLControl ) { Debug.Assert(oWorkbook != null); Debug.Assert(oNodeXLControl != null); ExportToNodeXLGraphGalleryUserSettings oExportToNodeXLGraphGalleryUserSettings = new ExportToNodeXLGraphGalleryUserSettings(); String sAuthor, sPassword; GetGraphGalleryAuthorAndPassword( oExportToNodeXLGraphGalleryUserSettings, out sAuthor, out sPassword); // Note that a graph summary is used for the description. try { (new NodeXLGraphGalleryExporter()).ExportToNodeXLGraphGallery( oWorkbook, oNodeXLControl, GraphTitleCreator.CreateGraphTitle(oWorkbook), GraphSummarizer.SummarizeGraph(oWorkbook), oExportToNodeXLGraphGalleryUserSettings.SpaceDelimitedTags, sAuthor, sPassword, oExportToNodeXLGraphGalleryUserSettings .ExportWorkbookAndSettings, oExportToNodeXLGraphGalleryUserSettings.ExportGraphML, oExportToNodeXLGraphGalleryUserSettings.UseFixedAspectRatio ); return(true); } catch (Exception oException) { String sMessage; if (NodeXLGraphGalleryExceptionHandler .TryGetMessageForRecognizedException( oException, out sMessage)) { FormUtil.ShowWarning(sMessage); } else { ErrorUtil.OnException(oException); } return(false); } }
DoDataExchange ( Boolean bFromControls ) { if (bFromControls) { String sTitle; if (!ValidateRequiredTextBox(txbTitle, "Enter a title.", out sTitle)) { return(false); } m_oExportToNodeXLGraphGalleryUserSettings.UseCredentials = radUseCredentials.Checked; String sAuthor = null; String sPassword = null; if (m_oExportToNodeXLGraphGalleryUserSettings.UseCredentials) { if ( !ValidateRequiredTextBox(txbAuthor, "Enter a user name.", out sAuthor) || !ValidateRequiredTextBox(txbPassword, "Enter a password.", out sPassword) ) { return(false); } } else { if ( !ValidateRequiredTextBox(txbGuestName, "Enter a guest name.", out sAuthor) ) { return(false); } } if (!usrExportedFiles.Validate()) { return(false); } m_oExportToNodeXLGraphGalleryUserSettings.SpaceDelimitedTags = txbSpaceDelimitedTags.Text.Trim(); m_oExportToNodeXLGraphGalleryUserSettings. ExportWorkbookAndSettings = usrExportedFiles.ExportWorkbookAndSettings; m_oExportToNodeXLGraphGalleryUserSettings.ExportGraphML = usrExportedFiles.ExportGraphML; m_oExportToNodeXLGraphGalleryUserSettings .UseFixedAspectRatio = usrExportedFiles.UseFixedAspectRatio; m_oExportToNodeXLGraphGalleryUserSettings.Author = sAuthor; m_oPasswordUserSettings.NodeXLGraphGalleryPassword = sPassword; } else { if (m_eMode == DialogMode.Normal) { txbTitle.Text = GraphTitleCreator.CreateGraphTitle(m_oWorkbook); txbDescription.Text = GetDefaultDescription(); } txbSpaceDelimitedTags.Text = m_oExportToNodeXLGraphGalleryUserSettings. SpaceDelimitedTags; usrExportedFiles.ExportWorkbookAndSettings = m_oExportToNodeXLGraphGalleryUserSettings. ExportWorkbookAndSettings; usrExportedFiles.ExportGraphML = m_oExportToNodeXLGraphGalleryUserSettings.ExportGraphML; usrExportedFiles.UseFixedAspectRatio = m_oExportToNodeXLGraphGalleryUserSettings .UseFixedAspectRatio; if (m_oExportToNodeXLGraphGalleryUserSettings.UseCredentials) { radUseCredentials.Checked = true; txbAuthor.Text = m_oExportToNodeXLGraphGalleryUserSettings.Author; txbPassword.Text = m_oPasswordUserSettings.NodeXLGraphGalleryPassword; } else { radAsGuest.Checked = true; txbGuestName.Text = m_oExportToNodeXLGraphGalleryUserSettings.Author; } EnableControls(); } return(true); }
TryExportToEmail ( Microsoft.Office.Interop.Excel.Workbook oWorkbook, NodeXLControl oNodeXLControl ) { Debug.Assert(oWorkbook != null); Debug.Assert(oNodeXLControl != null); ExportToEmailUserSettings oExportToEmailUserSettings = new ExportToEmailUserSettings(); String sSmtpPassword = (new PasswordUserSettings()).SmtpPassword; if (!ExportToEmailUserSettingsAreComplete( oExportToEmailUserSettings, sSmtpPassword)) { FormUtil.ShowWarning( "The graph can't be exported to email because all required" + " email options haven't been specified yet. Go to NodeXL," + " Graph, Automate to fix this." ); return(false); } try { (new EmailExporter()).ExportToEmail( oWorkbook, oNodeXLControl, oExportToEmailUserSettings.SpaceDelimitedToAddresses.Split(' '), oExportToEmailUserSettings.FromAddress, GraphTitleCreator.CreateGraphTitle(oWorkbook), oExportToEmailUserSettings.MessageBody, oExportToEmailUserSettings.SmtpHost, oExportToEmailUserSettings.SmtpPort, oExportToEmailUserSettings.UseSslForSmtp, oExportToEmailUserSettings.SmtpUserName, sSmtpPassword, oExportToEmailUserSettings.ExportWorkbookAndSettings, oExportToEmailUserSettings.ExportGraphML, oExportToEmailUserSettings.UseFixedAspectRatio ); return(true); } catch (Exception oException) { String sMessage; if (EmailExceptionHandler.TryGetMessageForRecognizedException( oException, out sMessage)) { FormUtil.ShowWarning(sMessage); } else { ErrorUtil.OnException(oException); } return(false); } }
DoDataExchange ( Boolean bFromControls ) { if (bFromControls) { String sToAddresses, sFromAddress, sSubject, sSmtpHost, sSmtpUserName, sSmtpPassword; Int32 iSmtpPort; if ( !ValidateRequiredTextBox(txbToAddresses, "Enter one or more \"to\" email addresses, separated with" + " spaces, commas or returns.", out sToAddresses) || !ValidateRequiredTextBox(txbFromAddress, "Enter a \"from\" email address.", out sFromAddress) || !ValidateRequiredTextBox(txbSubject, "Enter a subject.", out sSubject) || !ValidateRequiredTextBox(txbSmtpHost, "Enter the name of an SMTP server, such as" + " smtp.gmail.com.", out sSmtpHost) || !ValidateInt32TextBox(txbSmtpPort, 1, 65535, "Enter the SMTP port number.", out iSmtpPort) || !ValidateRequiredTextBox(txbSmtpUserName, "Enter the user name for an account on the SMTP server.", out sSmtpUserName) || !ValidateRequiredTextBox(txbSmtpPassword, "Enter the password for an account on the SMTP server.", out sSmtpPassword) || !usrExportedFiles.Validate() ) { return(false); } m_oExportToEmailUserSettings.SpaceDelimitedToAddresses = String.Join(" ", StringUtil.SplitOnCommonDelimiters( sToAddresses)); m_oExportToEmailUserSettings.FromAddress = sFromAddress; m_oExportToEmailUserSettings.MessageBody = txbMessageBody.Text; m_oExportToEmailUserSettings.SmtpHost = sSmtpHost; m_oExportToEmailUserSettings.SmtpPort = iSmtpPort; m_oExportToEmailUserSettings.UseSslForSmtp = chkUseSslForSmtp.Checked; m_oExportToEmailUserSettings.SmtpUserName = sSmtpUserName; m_oPasswordUserSettings.SmtpPassword = sSmtpPassword; m_oExportToEmailUserSettings.ExportWorkbookAndSettings = usrExportedFiles.ExportWorkbookAndSettings; m_oExportToEmailUserSettings.ExportGraphML = usrExportedFiles.ExportGraphML; m_oExportToEmailUserSettings.UseFixedAspectRatio = usrExportedFiles.UseFixedAspectRatio; } else { txbToAddresses.Text = m_oExportToEmailUserSettings.SpaceDelimitedToAddresses; txbFromAddress.Text = m_oExportToEmailUserSettings.FromAddress; if (m_eMode == DialogMode.Normal) { txbSubject.Text = GraphTitleCreator.CreateGraphTitle(m_oWorkbook); } txbMessageBody.Text = m_oExportToEmailUserSettings.MessageBody; txbSmtpHost.Text = m_oExportToEmailUserSettings.SmtpHost; txbSmtpPort.Text = m_oExportToEmailUserSettings.SmtpPort.ToString( CultureInfo.InvariantCulture); chkUseSslForSmtp.Checked = m_oExportToEmailUserSettings.UseSslForSmtp; txbSmtpUserName.Text = m_oExportToEmailUserSettings.SmtpUserName; txbSmtpPassword.Text = m_oPasswordUserSettings.SmtpPassword; usrExportedFiles.ExportWorkbookAndSettings = m_oExportToEmailUserSettings.ExportWorkbookAndSettings; usrExportedFiles.ExportGraphML = m_oExportToEmailUserSettings.ExportGraphML; usrExportedFiles.UseFixedAspectRatio = m_oExportToEmailUserSettings.UseFixedAspectRatio; } return(true); }