private void editar(long id) { IDbCommand dbCommand = dbConnection.CreateCommand(); dbCommand.CommandText = string.Format("select * from articulo where id={0}", id); IDataReader dataReader = dbCommand.ExecuteReader(); dataReader.Read(); entryNombre.Text = (string)dataReader["nombre"]; spinButtonPrecio.Value = Convert.ToDouble((decimal)dataReader["precio"]); dataReader.Close(); saveAction.Activated += delegate { Console.WriteLine("saveAction.Activated"); IDbCommand dbUpdateCommand = dbConnection.CreateCommand(); dbUpdateCommand.CommandText = "update articulo set nombre=:nombre, precio=:precio where id=:id"; DbCommandExtensions.AddParameter(dbUpdateCommand, "nombre", entryNombre.Text); DbCommandExtensions.AddParameter(dbUpdateCommand, "precio", Convert.ToDecimal(spinButtonPrecio.Value)); DbCommandExtensions.AddParameter(dbUpdateCommand, "id", id); dbUpdateCommand.ExecuteNonQuery(); Destroy(); }; }
private void nuevo() { //inicializo los controles que quiera entryNombre.Text = "Pon el nombre"; spinButtonPrecio.Value = 1; saveAction.Activated += delegate { Console.WriteLine("saveAction.Activated"); IDbCommand dbCommand = dbConnection.CreateCommand(); dbCommand.CommandText = "insert into articulo (nombre, precio) values (:nombre, :precio)"; DbCommandExtensions.AddParameter(dbCommand, "nombre", entryNombre.Text); DbCommandExtensions.AddParameter(dbCommand, "precio", Convert.ToDecimal(spinButtonPrecio.Value)); dbCommand.ExecuteNonQuery(); Destroy(); }; }