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