public static void DeletePeriodicFuel(PeriodicFuel periodicFuel) { string query = string.Format("DELETE FROM {0} " + "WHERE CentroAbastecimiento = '{1}' " + "AND Periodo = {2} " + "AND Escenario = {3}", table, periodicFuel.Name, periodicFuel.Period, periodicFuel.Case); DataBaseManager.ExecuteQuery(query); }
public static void UpdatePeriodicFuel(PeriodicFuel periodicFuel) { string query = string.Format("UPDATE {0} SET " + "CapacidadHora = @Capacity, " + "MinimoHora = @Min, " + "CostoCombustible = @Cost, " + "CostoTransporte = @TransportCost " + "WHERE CentroAbastecimiento = @Name AND " + "periodo = @Period AND " + "escenario = @Case", table); using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection)) { command.Parameters.Add("@Capacity", OleDbType.Numeric); command.Parameters.Add("@Min", OleDbType.Numeric); command.Parameters.Add("@Cost", OleDbType.Numeric); command.Parameters.Add("@TransportCost", 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["@Capacity"].Value = periodicFuel.Capacity; command.Parameters["@Min"].Value = periodicFuel.Min; command.Parameters["@Cost"].Value = periodicFuel.Cost; command.Parameters["@TransportCost"].Value = periodicFuel.TransportCost; command.Parameters["@Name"].Value = periodicFuel.Name; command.Parameters["@Period"].Value = periodicFuel.Period; command.Parameters["@Case"].Value = periodicFuel.Case; int rowsAffected = command.ExecuteNonQuery(); DataBaseManager.DbConnection.Close(); } }
public PeriodicFuelsViewModel(PeriodicFuel periodicFuel) : base(periodicFuel) { this.periodicFuel = periodicFuel; }