public void CreateFuelColumnInThermalPlantTable()
{
string table = "recursoTermicoBasica";
string column = "Combustible";
string query = string.Format("ALTER TABLE {0} ADD {1} Text", table, column);
using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
{
DataBaseManager.DbConnection.Open();
try
{
command.ExecuteNonQuery();
}
catch
{
//TODO: Move to DBManager after testing
}
DataBaseManager.DbConnection.Close();
}
query = string.Format("UPDATE {0} as r " +
"INNER JOIN combustibleRecurso AS c " +
"ON r.nombre = c.recurso " +
"SET r.Combustible = c.nombre", table);
DataBaseManager.ExecuteQuery(query);
log.Info(MessageUtil.FormatMessage("INFO.ColumnCreatedInTable", column, table));
}
public void CreatePeriodicHydroElementTable()
{
bool alterTable = false;
string table = "elementoHidraulicoPeriodo";
string query = string.Format("SELECT * FROM {0}", table);
using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
{
DataBaseManager.DbConnection.Open();
try
{
command.ExecuteNonQuery();
query = string.Format("ALTER TABLE {0} DROP CONSTRAINT PrimaryKey", table);
alterTable = true;
}
catch
{
query = string.Format("CREATE TABLE {0} (Nombre Text NOT NULL, Periodo Integer NOT NULL, TurMinimo Double, TurMaximo Double, Filtracion Double, FactorRecuperacion Double, PRIMARY KEY (Nombre, Periodo))", table);
}
DataBaseManager.DbConnection.Close();
}
DataBaseManager.ExecuteQuery(query);
if (alterTable)
{
query = string.Format("ALTER TABLE {0} ADD PRIMARY KEY (Nombre, Periodo)", table);
DataBaseManager.ExecuteQuery(query);
log.Info(MessageUtil.FormatMessage("INFO.PrimaryKeyAddedToTable", table));
}
else
{
log.Info(MessageUtil.FormatMessage("INFO.TableCreated", table));
}
}
public void CreatePlantsMappingTables()
{
List <string> tables = new List <string>()
{
"MapeoRecursosHidro",
"MapeoRecursosTermicos"
};
foreach (string table in tables)
{
string query = string.Format("SELECT TOP 1 Planta FROM {0}", table);
try
{
OleDbDataReader reader = DataBaseManager.ReadData(query);
}
catch
{
query = string.Format("CREATE TABLE {0} (Planta Text, Recurso Text)", table);
DataBaseManager.ExecuteQuery(query);
log.Info(MessageUtil.FormatMessage("INFO.TableCreated", table));
}
DataBaseManager.DbConnection.Close();
}
}
public static void DeleteRecursoBasica(RecursoBasica RecursoBasica)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} ", table, RecursoBasica.Name);
DataBaseManager.ExecuteQuery(query);
}
public void AddPrimaryKeyToPeriodsTable()
{
string table = "periodoBasica";
string query = string.Format("ALTER TABLE {0} DROP CONSTRAINT PRIMARYKEY", table);
DataBaseManager.ExecuteQuery(query);
query = string.Format("ALTER TABLE {0} ADD PRIMARY KEY (nombre, escenario)", table);
DataBaseManager.ExecuteQuery(query);
/*
* using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
* {
* DataBaseManager.DbConnection.Open();
* try
* {
* command.ExecuteNonQuery();
* }
* catch
* {
* //TODO: Move to DBManager after testing
* }
* DataBaseManager.DbConnection.Close();
* }
*/
log.Info(MessageUtil.FormatMessage("INFO.PrimaryKeyAddedToTable", table));
}
public static void DeleteZone(Zone dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Id = {1}", table, dataObject.Id);
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateObject(ExcludingPlants dataObject)
{
string query = string.Format("INSERT INTO {0}(Recurso1, Recurso2) " +
"VALUES('{1}', '{2}')", table, dataObject.Plant1, dataObject.Plant2);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteObject(NameMapping dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = '{1}'", table, dataObject.DHOGName);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteObject(ExcludingPlants dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Recurso1 = '{1}' AND Recurso2 = '{2}' ", table, dataObject.Plant1, dataObject.Plant2);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteObject(NonConventionalPlant dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Id = {1}", table, dataObject.Id);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteObject(RecursoFuelContract dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Id = {1}", table, dataObject.Id);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteObject(LineaBarra dataObject)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Nombre = {1}", table, dataObject.Nombre);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteAllPlantsFromZone(string zone)
{
string query = "DELETE FROM ZonaRecurso " +
"WHERE nombre = '" + zone + "' ";
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateObject(RutasDhogParameter dataObject)
{
string query = string.Format("UPDATE {0} SET " +
"RutaModelo = '{1}' " + ", RutaBD = '{3}'" + ", RutaEjecutable = '{4}'" + ", RutaSalida = '{5}'" + ", RutaSolver = '{6}'" +
" WHERE ID = {2}", table, dataObject.RutaModelo, dataObject.Id, dataObject.RutaBD, dataObject.RutaEjecutable, dataObject.RutaSalida, dataObject.RutaSolver);
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateObjectiveFuncion(int value)
{
string query = string.Format("UPDATE configuracionProblema " +
"SET valor = {0} " +
"WHERE nombre = 'MODELO'", value);
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateIsIterative(int value)
{
string query = string.Format("UPDATE configuracionProblema " +
"SET valor = {0} " +
"WHERE nombre = 'ITERATIVO'", value);
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateCaseDescription(string description)
{
string query = string.Format("UPDATE {0} " +
"SET Descripcion = '{1}' " +
"WHERE Id = 1", table, description);
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateObject(ProblemConfigurationParameter dataObject)
{
string query = string.Format("UPDATE {0} SET " +
"valor = {1} " +
"WHERE nombre = '{2}'", table, dataObject.Value, dataObject.Name);
DataBaseManager.ExecuteQuery(query);
}
public static void DeletePlantFromZone(string zone, string plant)
{
string query = "DELETE FROM ZonaRecurso " +
"WHERE nombre = '" + zone + "' " +
"AND recurso = '" + plant + "' ";
DataBaseManager.ExecuteQuery(query);
}
public static void DeletePeriodicHydroSystem(PeriodicHydroSystem periodicHydroSystem)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE sistema = '{1}' " +
"AND Periodo = {2} ",
table, periodicHydroSystem.Name, periodicHydroSystem.Period);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteCorteLinea(CorteLinea CorteLinea)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Sentido = {2}",
table, CorteLinea.Name, CorteLinea.Sentido);
DataBaseManager.ExecuteQuery(query);
}
public static void DeletePeriodicBlock(PeriodicBlock periodicBlock)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Periodo = {2}",
table, periodicBlock.Block, periodicBlock.Period);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteZonaUnidad(ZonaUnidad ZonaUnidad)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Periodo = {2}",
table, ZonaUnidad.Name, ZonaUnidad.Periodo);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteUnidadBarra(UnidadBarra UnidadBarra)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Barra = {2}",
table, UnidadBarra.Nombre, UnidadBarra.Barra);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteRecursoUnidad(RecursoUnidad RecursoUnidad)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Unidad = {2}",
table, RecursoUnidad.Name, RecursoUnidad.Unidad);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteAreaBarra(AreaBarra AreaBarra)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Periodo = {2}",
table, AreaBarra.Name, AreaBarra.Periodo);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteRecursoRampa(RecursoRampa RecursoRampa)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Configuracion = {2}",
table, RecursoRampa.Name, RecursoRampa.Configuracion);
DataBaseManager.ExecuteQuery(query);
}
public static void DeleteCortePeriodo(CortePeriodo CortePeriodo)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Periodo = {2}",
table, CortePeriodo.Name, CortePeriodo.Periodo);
DataBaseManager.ExecuteQuery(query);
}
public static void DeletePeriodicArea(PeriodicArea periodicArea)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = '{1}' " +
"AND Periodo = {2}",
table, periodicArea.Name, periodicArea.Period);
DataBaseManager.ExecuteQuery(query);
}
public static void DeletePeriodicHydroElement(PeriodicHydroElement periodicHydroElement)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Nombre = '{1}' " +
"AND Periodo = {2} ",
table, periodicHydroElement.Name, periodicHydroElement.Period);
DataBaseManager.ExecuteQuery(query);
}