public static void UpdatePeriodicLoadBlock(PeriodicLoadBlock periodicBlock)
{
string query = string.Format("UPDATE {0} SET " +
"Demanda = @Load " +
"WHERE bloque = @Block AND " +
"periodo = @Period AND " +
"escenario = @Case", table);
using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
{
command.Parameters.Add("@Load", OleDbType.Numeric);
command.Parameters.Add("@Block", OleDbType.Numeric);
command.Parameters.Add("@Period", OleDbType.Numeric);
command.Parameters.Add("@Case", OleDbType.Numeric);
DataBaseManager.DbConnection.Open();
command.Parameters["@Load"].Value = periodicBlock.Load;
command.Parameters["@Block"].Value = periodicBlock.Block;
command.Parameters["@Period"].Value = periodicBlock.Period;
command.Parameters["@Case"].Value = periodicBlock.Case;
int rowsAffected = command.ExecuteNonQuery();
DataBaseManager.DbConnection.Close();
}
}
public static void DeletePeriodicLoadBlock(PeriodicLoadBlock periodicBlock)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE Bloque = {1} " +
"AND Periodo = {2} " +
"AND Escenario = {3}",
table, periodicBlock.Block, periodicBlock.Period, periodicBlock.Case);
DataBaseManager.ExecuteQuery(query);
}
public PeriodicLoadBlockViewModel(PeriodicLoadBlock periodicLoadBlock) : base(periodicLoadBlock)
{
this.periodicLoadBlock = periodicLoadBlock;
}
