private void toolStripMenuItemExportModelScenarios_Click(object sender, EventArgs e)
{
DB.SuspendTreeUpdates();
toolStripProgressBar1.Visible = true;
OpenFileDialog dlg = new OpenFileDialog();
dlg.Title = "Export Gains and Forecasts for each scenario";
dlg.Filter = "Excel (*.xls;*.xlsx) |*.xls;*.xlsx|All files (*.*)|*.*";
var ds = new ScenarioManagement.ScenarioDataSet();
ds.OnProgress += explorer_OnProgress;
try
{
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ds.Export(dlg.FileName, DB);
}
}
catch (Exception eex)
{
MessageBox.Show(eex.Message, "Error");
}
finally
{
DB.ResumeTreeUpdates();
DatabaseChanged();
toolStripProgressBar1.Visible = false;
}
}
public void ReadExcelScenario()
{
string fn = Path.Combine(TestData.DataPath, "Scenarios", "InputScenarioConfig.xlsx");
var ds = new ScenarioManagement.ScenarioDataSet();
var fn1 = FileUtility.GetTempFileName(".pdb");
SQLiteServer svr = new SQLiteServer(fn1);
var db = new TimeSeriesDatabase(svr, false);
ds.Import(fn, db);
Assert.IsTrue(ds.ScenarioMapping.Count > 0);
// create Scenarios
}
public void ReadExcelScenario()
{
string fn = Path.Combine(TestData.DataPath, "Scenarios", "InputScenarioConfig.xlsx");
var ds = new ScenarioManagement.ScenarioDataSet();
var fn1 = FileUtility.GetTempFileName(".pdb");
SQLiteServer svr = new SQLiteServer(fn1);
var db = new TimeSeriesDatabase(svr,false);
ds.Import(fn, db);
Assert.IsTrue(ds.ScenarioMapping.Count > 0);
// create Scenarios
svr.CloseAllConnections();
File.Delete(fn1);
}
private void ImportHydrologicModels_Click(object sender, EventArgs e)
{
DB.SuspendTreeUpdates();
toolStripProgressBar1.Visible = true;
OpenFileDialog dlg = new OpenFileDialog();
dlg.Title = "Import Hydrologic Model output";
dlg.Filter = "Excel (*.xls;*.xlsx) |*.xls;*.xlsx|All files (*.*)|*.*";
var ds = new ScenarioManagement.ScenarioDataSet();
ds.OnProgress += explorer_OnProgress;
try
{
if (dlg.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
ds.Import(dlg.FileName, DB);
}
}
catch (Exception eex)
{
MessageBox.Show(eex.Message, "Error");
}
finally
{
DB.ResumeTreeUpdates();
DatabaseChanged();
toolStripProgressBar1.Visible = false;
}
}
