public static void UpdatePeriodicReservoir(PeriodicReservoir periodicReservoir)
{
string query = string.Format("UPDATE {0} SET " +
"VolumenMinimo = @MinLevel, " +
"VolumenMaximo = @MaxLevel " +
"WHERE Nombre = @Name AND " +
"periodo = @Period AND " +
"escenario = @Case", table);
using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
{
command.Parameters.Add("@MinLevel", OleDbType.Numeric);
command.Parameters.Add("@MaxLevel", OleDbType.Numeric);
command.Parameters.Add("@Name", OleDbType.VarChar);
command.Parameters.Add("@Period", OleDbType.Numeric);
command.Parameters.Add("@Case", OleDbType.Numeric);
DataBaseManager.DbConnection.Open();
command.Parameters["@MinLevel"].Value = periodicReservoir.MinLevel;
command.Parameters["@MaxLevel"].Value = periodicReservoir.MaxLevel;
command.Parameters["@Name"].Value = periodicReservoir.Name;
command.Parameters["@Period"].Value = periodicReservoir.Period;
command.Parameters["@Case"].Value = periodicReservoir.Case;
int rowsAffected = command.ExecuteNonQuery();
DataBaseManager.DbConnection.Close();
}
}
public static void DeletePeriodicReservoir(PeriodicReservoir periodicReservoir)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Nombre = '{1}' " +
"AND Periodo = {2} " +
"AND Escenario = {3}",
table, periodicReservoir.Name, periodicReservoir.Period, periodicReservoir.Case);
DataBaseManager.ExecuteQuery(query);
}
public PeriodicReservoirsViewModel(PeriodicReservoir periodicReservoir) : base(periodicReservoir)
{
this.periodicReservoir = periodicReservoir;
}