//*************************************************************************
// Constructor: AutomateTasksDialog()
//
/// <summary>
/// Initializes a new instance of the <see cref="AutomateTasksDialog" />
/// class.
/// </summary>
///
/// <param name="mode">
/// Indicates the mode in which the dialog is being used.
/// </param>
///
/// <param name="thisWorkbook">
/// Workbook containing the graph contents.
/// </param>
///
/// <param name="nodeXLControl">
/// The NodeXLControl object. This can be null if <paramref name="mode" />
/// is <see cref="DialogMode.EditOnly" />.
/// </param>
//*************************************************************************
public AutomateTasksDialog
(
DialogMode mode,
ThisWorkbook thisWorkbook,
NodeXLControl nodeXLControl
)
{
Debug.Assert(thisWorkbook != null);
Debug.Assert(nodeXLControl != null || mode == DialogMode.EditOnly);
m_eMode = mode;
m_oAutomateTasksUserSettings = new AutomateTasksUserSettings();
m_oThisWorkbook = thisWorkbook;
m_oNodeXLControl = nodeXLControl;
m_bIgnoreItemCheckEvents = false;
InitializeComponent();
if (m_eMode == DialogMode.EditOnly)
{
this.Text += " Options";
btnOK.Text = "OK";
}
// Instantiate an object that saves and retrieves the user settings for
// this dialog. Note that the object automatically saves the settings
// when the form closes.
m_oAutomateTasksDialogUserSettings =
new AutomateTasksDialogUserSettings(this);
PopulateTasksToRun();
DoDataExchange(false);
AssertValid();
}
AutomateThisWorkbook()
{
AssertValid();
AutomateTasksUserSettings oAutomateTasksUserSettings =
new AutomateTasksUserSettings();
TaskAutomator.AutomateOneWorkbook(m_oThisWorkbook, oNodeXLControl,
oAutomateTasksUserSettings.TasksToRun,
oAutomateTasksUserSettings.FolderToSaveWorkbookTo);
}
GetWorkbookSettings
(
Microsoft.Office.Interop.Excel.Workbook oWorkbook
)
{
Debug.Assert(oWorkbook != null);
AssertValid();
// Temporarily change some settings.
AutomateTasksUserSettings oAutomateTasksUserSettings =
new AutomateTasksUserSettings();
AutomationTasks eOriginalTasksToRun =
oAutomateTasksUserSettings.TasksToRun;
oAutomateTasksUserSettings.TasksToRun =
AutomationTasks.CalculateGraphMetrics;
oAutomateTasksUserSettings.Save();
GraphMetricUserSettings oGraphMetricUserSettings =
new GraphMetricUserSettings();
GraphMetrics eOriginalGraphMetricsToCalculate =
oGraphMetricUserSettings.GraphMetricsToCalculate;
oGraphMetricUserSettings.GraphMetricsToCalculate =
GraphMetrics.OverallMetrics;
oGraphMetricUserSettings.Save();
// Get the workbook settings that include the temporary changes.
String sWorkbookSettings =
( new PerWorkbookSettings(oWorkbook) ).WorkbookSettings;
// Restore the original settings.
oAutomateTasksUserSettings.TasksToRun = eOriginalTasksToRun;
oAutomateTasksUserSettings.Save();
oGraphMetricUserSettings.GraphMetricsToCalculate =
eOriginalGraphMetricsToCalculate;
oGraphMetricUserSettings.Save();
return (sWorkbookSettings);
}