public static void UpdatePeriodicNonConventionalPlant(PeriodicNonConventionalPlant periodicNonConventionalPlant) { string query = string.Format("UPDATE {0} SET " + "Maximo = @Max, " + "FactorPlanta = @PlantFactor " + "WHERE Nombre = @Name AND " + "periodo = @Period AND " + "escenario = @Case", table); using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection)) { command.Parameters.Add("@Max", OleDbType.Numeric); command.Parameters.Add("@PlantFactor", 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["@Max"].Value = periodicNonConventionalPlant.Max; command.Parameters["@PlantFactor"].Value = periodicNonConventionalPlant.PlantFactor; command.Parameters["@Name"].Value = periodicNonConventionalPlant.Name; command.Parameters["@Period"].Value = periodicNonConventionalPlant.Period; command.Parameters["@Case"].Value = periodicNonConventionalPlant.Case; int rowsAffected = command.ExecuteNonQuery(); DataBaseManager.DbConnection.Close(); } }
public static void DeletePeriodicNonConventionalPlant(PeriodicNonConventionalPlant periodicNonConventionalPlant) { string query = string.Format("DELETE FROM {0} " + "WHERE Nombre = '{1}' " + "AND Periodo = {2} " + "AND Escenario = {3}", table, periodicNonConventionalPlant.Name, periodicNonConventionalPlant.Period, periodicNonConventionalPlant.Case); DataBaseManager.ExecuteQuery(query); }
public PeriodicNonConventionalPlantsViewModel(PeriodicNonConventionalPlant periodicNonConventionalPlant) : base(periodicNonConventionalPlant) { this.periodicNonConventionalPlant = periodicNonConventionalPlant; }