public static void UpdatePeriodicBlock(PeriodicBlock periodicBlock)
{
string query = string.Format("UPDATE {0} SET " +
"FactorDuracion = @DurationFactor, " +
"FactorDemanda = @LoadFactor " +
"WHERE nombre = @Name AND " +
"periodo = @Period", table);
using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
{
command.Parameters.Add("@DurationFactor", OleDbType.Numeric);
command.Parameters.Add("@LoadFactor", OleDbType.Numeric);
command.Parameters.Add("@Name", OleDbType.Numeric);
command.Parameters.Add("@Period", OleDbType.Numeric);
DataBaseManager.DbConnection.Open();
command.Parameters["@DurationFactor"].Value = periodicBlock.DurationFactor;
command.Parameters["@LoadFactor"].Value = periodicBlock.LoadFactor;
command.Parameters["@Name"].Value = periodicBlock.Block;
command.Parameters["@Period"].Value = periodicBlock.Period;
int rowsAffected = command.ExecuteNonQuery();
DataBaseManager.DbConnection.Close();
}
}
public static void DeletePeriodicBlock(PeriodicBlock periodicBlock)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} " +
"AND Periodo = {2}",
table, periodicBlock.Block, periodicBlock.Period);
DataBaseManager.ExecuteQuery(query);
}
public PeriodicBlockViewModel(PeriodicBlock periodicBlock) : base(periodicBlock)
{
this.periodicBlock = periodicBlock;
}