public static void DeleteRecursoBasica(RecursoBasica RecursoBasica)
{
string query = string.Format("DELETE FROM {0} " +
"WHERE nombre = {1} ", table, RecursoBasica.Name);
DataBaseManager.ExecuteQuery(query);
}
public static void UpdateRecursoBasica(RecursoBasica RecursoBasica)
{
string query = string.Format("UPDATE {0} SET " +
"TML = @TML, " +
"TMFL = @TMFL, " +
"genIni = @genIni, " +
"tlIni = @tlIni, " +
"tflIni = @tflIni, " +
"configuracion = @configuracion, " +
"maximoarranques = @maximoarranques, " +
"modelaRampas = @modelaRampas, " +
"modelaintervalos = @modelaintervalos, " +
"costoArranque = @costoArranque, " +
"WHERE nombre = @Name ", table);
using (OleDbCommand command = new OleDbCommand(query, DataBaseManager.DbConnection))
{
command.Parameters.Add("@TML", OleDbType.Numeric);
command.Parameters.Add("@TMFL", OleDbType.Numeric);
command.Parameters.Add("@Name", OleDbType.VarChar);
command.Parameters.Add("@genIni", OleDbType.Numeric);
command.Parameters.Add("@tlIni", OleDbType.Numeric);
command.Parameters.Add("@tflIni", OleDbType.Numeric);
command.Parameters.Add("@configuracion", OleDbType.Numeric);
command.Parameters.Add("@maximoarranques", OleDbType.Numeric);
command.Parameters.Add("@modelaRampas", OleDbType.Numeric);
command.Parameters.Add("@modelaintervalos", OleDbType.Numeric);
command.Parameters.Add("@costoArranque", OleDbType.Numeric);
DataBaseManager.DbConnection.Open();
command.Parameters["@TML"].Value = RecursoBasica.TML;
command.Parameters["@TMFL"].Value = RecursoBasica.TMFL;
command.Parameters["@Name"].Value = RecursoBasica.Name;
command.Parameters["@genIni"].Value = RecursoBasica.GenIni;
command.Parameters["@tlIni"].Value = RecursoBasica.TlIni;
command.Parameters["@tflIni"].Value = RecursoBasica.TflIni;
command.Parameters["@configuracion"].Value = RecursoBasica.Configuracion;
command.Parameters["@maximoarranques"].Value = RecursoBasica.Maximoarranques;
command.Parameters["@modelaRampas"].Value = RecursoBasica.ModelaRampas;
command.Parameters["@modelaintervalos"].Value = RecursoBasica.Modelaintervalos;
command.Parameters["@costoArranque"].Value = RecursoBasica.CostoArranque;
int rowsAffected = command.ExecuteNonQuery();
DataBaseManager.DbConnection.Close();
}
}
public RecursoBasicaViewModel(RecursoBasica RecursoBasica) : base()
{
this.RecursoBasica = RecursoBasica;
}
