private void AddHDBModel_Click(object sender, EventArgs e) { #if !PISCES_OPEN var server = OracleServer.ConnectToOracle(); if (server == null) { return; } Hdb.Instance = new Hdb(server); SelectHdbModel dlg = new SelectHdbModel(); if (dlg.ShowDialog() == DialogResult.OK && dlg.ModelID > 0) { // create tree for this model. var folder = DB.AddFolder(CurrentFolder, dlg.ModelName + " " + dlg.ModelTable); var tbl = HdbModelTreeBuilder.PiscesSeriesCatalog(dlg.ModelID, dlg.ModelTable, dlg.OldestModelRunDate, DB.NextSDI(), folder.ID); if (tbl.Rows.Count == 0) { MessageBox.Show("No model runs found for model_id " + dlg.ModelID + " after " + dlg.OldestModelRunDate.ToString()); return; } DB.Server.SaveTable(tbl); // create scenario list. var scenarioTable = DB.GetScenarios(); var ref_model_run = Hdb.Instance.ref_model_run(dlg.ModelID, dlg.OldestModelRunDate); foreach (DataRow item in ref_model_run.Rows) { string date = Convert.ToDateTime(item["run_date"]).ToShortDateString(); string model_run_name = item["model_run_name"].ToString(); string id = item["model_run_id"].ToString(); string path = HdbModelSeries.BuildScenairoPath(model_run_name, id, date); string name = HdbModelSeries.BuildScenairoName(model_run_name, id, date); scenarioTable.AddScenarioRow(name, true, path, 0); } DB.Server.SaveTable(scenarioTable); DatabaseChanged(); } #endif }
private void AddHDBModel_Click(object sender, EventArgs e) { #if !PISCES_OPEN var server = OracleServer.ConnectToOracle(); if (server == null) return; Hdb.Instance = new Hdb(server); SelectHdbModel dlg = new SelectHdbModel(); if (dlg.ShowDialog() == DialogResult.OK && dlg.ModelID > 0) { // create tree for this model. var folder = DB.AddFolder(CurrentFolder, dlg.ModelName + " " + dlg.ModelTable); var tbl = HdbModelTreeBuilder.PiscesSeriesCatalog(dlg.ModelID, dlg.ModelTable, dlg.OldestModelRunDate, DB.NextSDI(), folder.ID); if (tbl.Rows.Count == 0) { MessageBox.Show("No model runs found for model_id " + dlg.ModelID + " after " + dlg.OldestModelRunDate.ToString()); return; } DB.Server.SaveTable(tbl); // create scenario list. var scenarioTable = DB.GetScenarios(); var ref_model_run = Hdb.Instance.ref_model_run(dlg.ModelID, dlg.OldestModelRunDate); foreach (DataRow item in ref_model_run.Rows) { string date = Convert.ToDateTime(item["run_date"]).ToShortDateString(); string model_run_name = item["model_run_name"].ToString(); string id = item["model_run_id"].ToString(); string path = HdbModelSeries.BuildScenairoPath(model_run_name, id, date); string name = HdbModelSeries.BuildScenairoName(model_run_name, id, date); scenarioTable.AddScenarioRow(name, true, path,0); } DB.Server.SaveTable(scenarioTable); DatabaseChanged(); } #endif }