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