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