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; } }
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); }