public void ConvertDBToCurrentVersion(DHOGDataBaseViewModel dhogDB) { GlobalContext.Properties["DBConversionLogFileName"] = dhogDB.DBFolder + "\\DHOG_ConversionBD.log"; XmlConfigurator.Configure(); log.Info(MessageUtil.FormatMessage("INFO.DBVersion", dhogDB.Version)); while (dhogDB.Version < DHOGMainWindow.DHOGVersion) { if (dhogDB.Version < 3.2) { CreateDBInfoTable(); CreatePlantsMappingTables(); CreatePeriodicHydroElementTable(); CreateIdsForBasicTables(); CreateSubareaColumnInPlantsTables(); CreateFuelColumnInThermalPlantTable(); CreateElementTypeColumnInHydroTopologyTable(); AlterProblemConfigurationTable(); UpdateCplexParameterDescription(); ChangeColumnsType(); AddPrimaryKeyToPeriodsTable(); AddPrimaryKeyToScenariosTable(); AddPrimaryKeyToHydroSystemTable(); AddPrimaryKeyToVariableThermalPlantTable(); AddPrimaryKeyToHydroTopologyTable(); AddPrimaryKeyToPFEquationsTable(); AddPrimaryKeyToExcludingPlantsTable(); ReplaceNullsWithZero(); CreateDBZonaEspecial(); CreateDBRutasDhog(); dhogDB.Version = 3.2; log.Info(MessageUtil.FormatMessage("INFO.DBVersion", dhogDB.Version)); } } }
private void LoadDBButton_Click(object sender, RoutedEventArgs e) { DHOGDataBaseViewModel dhogDataBaseViewModel = DataContext as DHOGDataBaseViewModel; if (TipoBD == 1) { if (File.Exists(DBFileTextBox.Text)) { dhogDataBaseViewModel.DBFolder = rutacodigo; dhogDataBaseViewModel.TipoBD = "Access"; dhogDataBaseViewModel.InputDBFile = DBFileTextBox.Text; dhogDataBaseViewModel.OutputDBFile = Rutaout; if (File.Exists(dhogDataBaseViewModel.OutputDBFile)) //TODO: Delete when testing is over! { ValidDBFile = true; Close(); } else { RadWindow.Alert(new DialogParameters { Content = "No existe el archivo " + dhogDataBaseViewModel.OutputDBFile + " en la ruta seleccionada.", Owner = this }); } } else { RadWindow.Alert(new DialogParameters { Content = "No existe el archivo " + DBFileTextBox.Text + ".", Owner = this }); } } if (TipoBD == 2) { //dhogDataBaseViewModel.InputDBFile = bdentradasql; dhogDataBaseViewModel.DBFolder = rutacodigo; dhogDataBaseViewModel.TipoBD = "Sql Server"; dhogDataBaseViewModel.OutputDBFile = bdsalidasql.ToString(); dhogDataBaseViewModel.InputDBFile = DBFileTextBox.Text; ValidDBFile = true; Close(); } }