/// <summary> /// Export to XPS /// </summary> public void ExportToXPS() { // If there are no rows in the grid then we cannot export if (_currentGrid.Rows.Count == 0) { MessageBox.Show("There is no data to Export", "Export Error"); } else { // First browse for the folder / file that we will save SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.ValidateNames = false; saveFileDialog.FileName = "AuditWizardData.xps"; saveFileDialog.Filter = "XML Paper Specification (*.xps)|*.xps"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { UltraGridExporter.Export(saveFileDialog.FileName , "" , "" , "" , _currentGrid , Infragistics.Documents.Reports.Report.FileFormat.XPS); DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'"); } } }
/// <summary> /// Export to PDF /// </summary> public void ExportToPDF() { // If there are no rows in the grid then we cannot export if (this.applicationsDataSet.Tables[0].Rows.Count == 0) { MessageBox.Show("There is no data to Export", "Export Error"); } else { // We need to temporarily set the grid view to 'Resize all columns' in order to get // the resultant PDF file formatted correctly. AutoFitStyle oldStyle = applicationsGridView.DisplayLayout.AutoFitStyle; applicationsGridView.DisplayLayout.AutoFitStyle = AutoFitStyle.ResizeAllColumns; // First browse for the folder / file that we will save SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.ValidateNames = false; saveFileDialog.FileName = headerLabel.Text + ".pdf"; saveFileDialog.Filter = "Adobe Acrobat Document (*.pdf)|*.pdf"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { UltraGridDocumentExporter exporter = new UltraGridDocumentExporter(); exporter.Export(applicationsGridView, saveFileDialog.FileName, GridExportFileFormat.PDF); DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'"); } // Populate the old autofit style this.applicationsGridView.DisplayLayout.AutoFitStyle = oldStyle; } }
/// <summary> /// Export to XPS /// </summary> public void ExportToXPS() { // If there are no rows in the grid then we cannot export if (this.OSDataSet.Tables[0].Rows.Count == 0) { MessageBox.Show("There is no data to Export", "Export Error"); } else { // First browse for the folder / file that we will save SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.ValidateNames = false; saveFileDialog.FileName = headerLabel.Text + ".xps"; saveFileDialog.Filter = "XML Paper Specification (*.xps)|*.xps"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { UltraGridExporter.Export(saveFileDialog.FileName , "AuditWizard Applications View : " + OSGridView.Text , "Generated by AuditWizard from Layton Technology, Inc." , DataStrings.Disclaimer , OSGridView , Infragistics.Documents.Reports.Report.FileFormat.XPS); DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'"); } } }
/// <summary> /// The background worker has completed and as such we need to signal the UI thread of this fact /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorkerUpload_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { bnClose.Visible = true; bnClose.Enabled = true; bnCancel.Visible = false; bnUploadAll.Enabled = true; lvAudits.SelectedItems.Clear(); // If we have been returned an error status then we do not display the summary but instead allow the user to see // the message reported. if ((int)e.Result == -1) { DesktopAlert.ShowDesktopAlert("Upload complete."); } else { DesktopAlert.ShowDesktopAlert("The selected Audit Data file(s) have been successfully uploaded."); foreach (AuditDataFile file in _uploadedFiles) { foreach (UltraListViewItem listViewItem in lvAudits.Items) { if (listViewItem.Key == file.FileName) { lvAudits.Items.Remove(listViewItem); break; } } } // Update the status bar lblProgress.Text = "Audit(s) uploaded."; } }
/// <summary> /// save function for the IAdministrationView Interface /// </summary> public void Save() { if (!ValidateRequiredValues()) { return; } auditAgentScannerDefinition.ScannerName = tbName.Text; auditAgentScannerDefinition.Filename = Path.Combine(Application.StartupPath, @"scanners\auditagent\" + auditAgentScannerDefinition.ScannerName + ".xml"); if (File.Exists(auditAgentScannerDefinition.Filename)) { if (MessageBox.Show("The config file '" + auditAgentScannerDefinition.ScannerName + "' already exists." + Environment.NewLine + Environment.NewLine + "Do you wish to overwrite the file?", "AuditWizard", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No) { return; } } UpdateChanges(); if (AuditWizardSerialization.SerializeObjectToFile(auditAgentScannerDefinition)) { DesktopAlert.ShowDesktopAlert("The scanner configuration file '" + auditAgentScannerDefinition.ScannerName + "' has been saved."); } }
private void SaveScanSettings() { SettingsDAO settingsDao = new SettingsDAO(); settingsDao.SetSetting("AutoScanIntervalValue", tbScanInterval.Text, false); settingsDao.SetSetting("AutoScanNetwork", Convert.ToString(cbEnableScan.Checked), false); settingsDao.SetSetting("AutoScanDeployAgent", Convert.ToString(cbDeployAgent.Checked), false); settingsDao.SetSetting("AutoScanIntervalUnits", Convert.ToString(cbScanInterval.SelectedItem.ToString()), false); AuditWizardServiceController _serviceController = new Layton.AuditWizard.Common.AuditWizardServiceController(); LaytonServiceController.ServiceStatus serviceStatus = _serviceController.CheckStatus(); if (serviceStatus == LaytonServiceController.ServiceStatus.Running) { _serviceController.RestartService(); } else { if (serviceStatus != LaytonServiceController.ServiceStatus.NotInstalled) { _serviceController.Start(); } } DesktopAlert.ShowDesktopAlert("Settings have been updated."); }
private void buttonSaveAs_Click(object sender, EventArgs e) { if (tbCustomReportName.Text.Length == 0) { MessageBox.Show( "Please enter a name for the custom report.", "Save Custom Report", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } SaveFields(); BinaryFormatter bf = new BinaryFormatter(); MemoryStream mem = new MemoryStream(); bf.Serialize(mem, _selectedFields); string lReportData = Convert.ToBase64String(mem.ToArray()); if (_editingReport) { new ReportsDAO().Update(_customReportId, tbCustomReportName.Text, lReportData); } else { DataTable lExistingReports = new ReportsDAO().GetReportsByTypeAndName(ReportsDAO.ReportType.CustomReport, tbCustomReportName.Text); if (lExistingReports.Rows.Count > 0) { if (MessageBox.Show( "A custom report already exists with this name." + Environment.NewLine + Environment.NewLine + "Do you wish to overwrite?", "Save Custom Report", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { new ReportsDAO().Update(Convert.ToInt32(lExistingReports.Rows[0][0]), tbCustomReportName.Text, lReportData); } else { return; } } else { new ReportsDAO().Insert(tbCustomReportName.Text, ReportsDAO.ReportType.CustomReport, lReportData); } } bnSaveComplianceReport.Enabled = false; _reportSaved = true; DesktopAlert.ShowDesktopAlert(String.Format("The custom report '{0}' has been saved.", tbCustomReportName.Text)); }
private void wizardControl_FinishButtonClick(object sender, EventArgs e) { // We now need to serialize the AlertDefinitions TextWriter textWriter = null; try { XmlSerializer serializer = new XmlSerializer(typeof(AlertDefinition)); string alertMonitorDirectory = Path.Combine(Application.StartupPath, "scanners\\alertmonitors\\"); string fileName = alertMonitorDirectory + _alertDefinition.Name + ".xml"; if (!Directory.Exists(alertMonitorDirectory)) { Directory.CreateDirectory(alertMonitorDirectory); } textWriter = new StreamWriter(fileName); serializer.Serialize(textWriter, _alertDefinition); // if we were editing and changed name, delete the original if (_editing && (_alertDefinition.Name != _originalName)) { File.Delete(alertMonitorDirectory + _originalName + ".xml"); } DesktopAlert.ShowDesktopAlert("The alert monitor '" + _alertDefinition.Name + "' has been saved."); } catch (Exception ex) { logger.Error("Error in wizardControl_FinishButtonClick", ex); Utility.DisplayApplicationErrorMessage("An error occurred whilst trying to save the alert definition."); } finally { // close text writer if (textWriter != null) { textWriter.Close(); } // close the form Close(); } }
private void bnDeleteAllSchedules_Click(object sender, EventArgs e) { if (MessageBox.Show( "Are you sure you want to delete all expired schedules?", "Delete schedules", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { int lCounter = 0; foreach (DataRow row in lReportSchedulesDAO.GetAllAppointments().Rows) { object rawAppointmentData = row["_APPOINTMENTDATA"]; if (rawAppointmentData is byte[] == false) { continue; } Appointment appointment = Appointment.FromBytes(rawAppointmentData as byte[]); if (appointment.Recurrence.RangeEndDate < DateTime.Now.AddSeconds(-62)) { lReportSchedulesDAO.DeleteAppt(Convert.ToInt32(row["_REPORTSCHEDULEID"])); lCounter++; } } string message = String.Format("Deleted {0} expired report schedules.", lCounter); if (lCounter == 0) { message = "There were no expired report schedules to delete."; } DesktopAlert.ShowDesktopAlert(message); //MessageBox.Show( // message, // "Delete report schedules", // MessageBoxButtons.OK, // MessageBoxIcon.Information); PopulateGrid(); } }
/// <summary> /// Deploy the scanner (Network Configuration) /// </summary> public void DeployNetwork() { try { // Ensure that the scanner name has been defined if (_auditScannerDefinition.ScannerName == "") { MessageBox.Show("The scanner name is blank - please specify a unique name for this scanner"); return; } // First we need to request the tabs which work with the scanner configuration to save // any changes which they may have made but not yet saved. ScannerConfigurationTabView generalTabView = WorkItem.Items[Properties.Settings.Default.ScannerConfigurationTabView] as ScannerConfigurationTabView; _auditScannerDefinition = generalTabView.UpdateChanges(); // save the changes so that the auto-loader can pick up the scanner folder generalTabView.Save(false); // create the scann folders (scanner and data) Directory.CreateDirectory(_auditScannerDefinition.DeployPathData); Directory.CreateDirectory(_auditScannerDefinition.DeployPathScanner); // ...and deploy it if (_auditScannerDefinition.Deploy(false)) { string scannerPath = _auditScannerDefinition.DeployPathScanner; //MessageBox.Show("The Audit Scanner has been deployed to " + _auditScannerDefinition.DeployPathScanner, "Deployment Successful"); if (scannerPath.Length > 50) { scannerPath = scannerPath.Substring(0, 22) + "..~.." + scannerPath.Substring(scannerPath.Length - 22, 22); } DesktopAlert.ShowDesktopAlert("The Audit Scanner has been deployed to " + scannerPath); } } catch (Exception ex) { logger.Error("Error in DeployNetwork.", ex); Utility.DisplayApplicationErrorMessage(ex.Message); } }
/// <summary> /// Export to PDF /// </summary> public void ExportToPDF() { // If there are no rows in the grid then we cannot export if (this._currentGrid.Rows.Count == 0) { MessageBox.Show("There is no data to Export", "Export Error"); } else { // We need to temporarily set the grid view to 'Resize all columns' in order to get // the resultant PDF file formatted correctly. AutoFitStyle oldStyle = _currentGrid.DisplayLayout.AutoFitStyle; _currentGrid.DisplayLayout.AutoFitStyle = AutoFitStyle.ResizeAllColumns; // First browse for the folder / file that we will save SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.ValidateNames = false; saveFileDialog.FileName = "AuditWizardData.pdf"; saveFileDialog.Filter = "Adobe Acrobat Document (*.pdf)|*.pdf"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { UltraGridExporter.Export(saveFileDialog.FileName , "" , "" , "" , _currentGrid , Infragistics.Documents.Reports.Report.FileFormat.PDF); DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'"); } // Populate the old autofit style this._currentGrid.DisplayLayout.AutoFitStyle = oldStyle; } }
/// <summary> /// Export to PDF /// </summary> public void ExportToPDF() { // If there are no rows in the grid then we cannot export if (this.OSDataSet.Tables[0].Rows.Count == 0) { MessageBox.Show("There is no data to Export", "Export Error"); } else { // We need to temporarily set the grid view to 'Resize all columns' in order to get // the resultant PDF file formatted correctly. AutoFitStyle oldStyle = OSGridView.DisplayLayout.AutoFitStyle; OSGridView.DisplayLayout.AutoFitStyle = AutoFitStyle.ResizeAllColumns; // First browse for the folder / file that we will save SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.ValidateNames = false; saveFileDialog.FileName = headerLabel.Text + ".pdf"; saveFileDialog.Filter = "Adobe Acrobat Document (*.pdf)|*.pdf"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { UltraGridExporter.Export(saveFileDialog.FileName , "AuditWizard Applications View : " + OSGridView.Text , "Generated by AuditWizard from Layton Technology, Inc." , DataStrings.Disclaimer , OSGridView , Infragistics.Documents.Reports.Report.FileFormat.PDF); DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'"); } // Populate the old autofit style this.OSGridView.DisplayLayout.AutoFitStyle = oldStyle; } }
/// <summary> /// Export to XPS /// </summary> public void ExportToXPS() { // If there are no rows in the grid then we cannot export if (this.applicationsDataSet.Tables[0].Rows.Count == 0) { MessageBox.Show("There is no data to Export", "Export Error"); } else { // First browse for the folder / file that we will save SaveFileDialog saveFileDialog = new SaveFileDialog(); saveFileDialog.ValidateNames = false; saveFileDialog.FileName = headerLabel.Text + ".xps"; saveFileDialog.Filter = "XML Paper Specification (*.xps)|*.xps"; if (saveFileDialog.ShowDialog(this) == DialogResult.OK) { UltraGridDocumentExporter exporter = new UltraGridDocumentExporter(); exporter.Export(applicationsGridView, saveFileDialog.FileName, GridExportFileFormat.XPS); DesktopAlert.ShowDesktopAlert("Data successfully exported to '" + saveFileDialog.FileName + "'"); } } }
void backgroundWorker1_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { DesktopAlert.ShowDesktopAlert("The selected asset(s) have been re-audited."); }
private void bnSave_Click(object sender, EventArgs e) { if (!textBoxSQLString.Text.ToUpper().StartsWith("SELECT")) { MessageBox.Show( "Only SELECT statements can be executed from this dialog.", "SQL Query", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); return; } if (tbReportName.Text == "") { MessageBox.Show( "Please enter a name for the SQL report.", "Save SQL Report", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } if (textBoxSQLString.Text.Length == 0) { MessageBox.Show( "Please enter a SQL string to run against the database.", "Save SQL Report", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } List <string> _filterConditions = new List <string>(); _filterConditions.Add(textBoxSQLString.Text); BinaryFormatter bf = new BinaryFormatter(); MemoryStream mem = new MemoryStream(); bf.Serialize(mem, _filterConditions); string lReportData = Convert.ToBase64String(mem.ToArray()); DataTable lExistingReports = new ReportsDAO().GetReportsByTypeAndName(ReportsDAO.ReportType.SqlReport, tbReportName.Text); if (lExistingReports.Rows.Count > 0) { if (MessageBox.Show( "A SQL report already exists with this name." + Environment.NewLine + Environment.NewLine + "Do you wish to overwrite?", "Save SQL Report", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) { new ReportsDAO().Update(Convert.ToInt32(lExistingReports.Rows[0][0]), tbReportName.Text, lReportData); } else { return; } } else { new ReportsDAO().Insert(tbReportName.Text, ReportsDAO.ReportType.SqlReport, lReportData); } DesktopAlert.ShowDesktopAlert(String.Format("The SQL report '{0}' has been saved.", tbReportName.Text)); bnSave.Enabled = false; _reportSaved = true; }