public MainWindow() : base(Gtk.WindowType.Toplevel) { Build (); QueryResult queryresult=PersisterHelper.Get("select * from articulo"); TreeViewHelper.Fill (TreeView, queryresult); refreshAction.Activated += delegate{ fillTreeView(); }; deleteAction.Activated += delegate{ object id=TreeViewHelper.GetId(TreeView); Console.WriteLine("Click en deleteAction id={0}", id); delete(id); }; editAction.Activated += delegate { object id=TreeViewHelper.GetId(TreeView); Console.WriteLine("Edicion de la tabla seleccionada"); new ArticuloView(id); }; TreeView.Selection.Changed += delegate { Console.WriteLine("ha ocurrido treeView.Selection.Changed"); deleteAction.Sensitive=TreeViewHelper.GetId(TreeView)!=null; }; deleteAction.Sensitive = false; }
private void init() { this.Build(); entryNombre.Text = nombre; QueryResult queryResult = PersisterHelper.Get("select * from categoria"); saveAction.Activated += delegate { save(); }; }
private void delete(object id) { if (confirmDelete(this)) { PersisterHelper.Get("DELETE FROM `articulo` WHERE id = " + id.ToString()); fillTreeView(); } }
public void init() { this.Build(); entry1.Text = nombre; QueryResult query = PersisterHelper.Get("Select * from categoria"); ComboBoxHelper.Fill(combobox1, query, categoria); spinbutton1.Value = Convert.ToDouble(precio); saveAction.Activated += delegate { save(); }; }
protected void onSaveCategoriaActivated(object sender, EventArgs e) { string nombreCategoria = entryCategoriaNombre.Text; IList nuevaRow = new List <object>(); nuevaRow.Add(nombreCategoria); PersisterHelper.Save("Categoria", nuevaRow); this.Destroy(); }
public MainWindow() : base(Gtk.WindowType.Toplevel) { Build(); Console.WriteLine("MainWindow ctor."); QueryResult queryResult = PersisterHelper.Get("select * from articulo"); //TODO usar el queryResult IDbConnection dbConnection = App.Instance.DbConnection; IDbCommand dbCommand = dbConnection.CreateCommand(); dbCommand.CommandText = "select * from articulo"; IDataReader dataReader = dbCommand.ExecuteReader(); // treeView.AppendColumn ("id", new CellRendererText (), "text", 0); // treeView.AppendColumn ("nombre", new CellRendererText (), "text", 1); string[] columnNames = getColumnNames(dataReader); CellRendererText cellRendererText = new CellRendererText(); for (int index = 0; index < columnNames.Length; index++) { //treeView.AppendColumn (columnNames [index], cellRendererText, "text", index); int column = index; treeView.AppendColumn(columnNames [index], cellRendererText, delegate(TreeViewColumn tree_column, CellRenderer cell, TreeModel tree_model, TreeIter iter) { IList row = (IList)tree_model.GetValue(iter, 0); cellRendererText.Text = row[column].ToString(); }); } //ListStore listStore = new ListStore (typeof(String), typeof(String)); //Type[] types = getTypes (dataReader.FieldCount); ListStore listStore = new ListStore(typeof(IList)); while (dataReader.Read()) { //listStore.AppendValues (dataReader [0].ToString(), dataReader [1].ToString()); IList values = getValues(dataReader); listStore.AppendValues(values); } dataReader.Close(); treeView.Model = listStore; dbConnection.Close(); }
public MainWindow() : base(Gtk.WindowType.Toplevel) { Build(); Console.WriteLine("MainWindow ctor."); QueryResult queryResult = PersisterHelper.Get("select * from articulo"); TreeViewHelper.Fill(treeView, queryResult); // Boton actualizar refreshAction.Activated += delegate { fillTreeView(); }; // Boton nuevo newAction.Activated += delegate { new ArticuloView(); fillTreeView(); }; // Boton eliminar clearAction.Sensitive = false; //Deshabilita el boton de eliminar clearAction.Activated += delegate { object id = TreeViewHelper.GetId(treeView); delete(id); fillTreeView(); }; // Boton de editar editAction.Sensitive = false; //Deshabilita el boton de editar editAction.Activated += delegate { object id = TreeViewHelper.GetId(treeView); new ArticuloView(id); fillTreeView(); }; // Deteccion de cambio de elemento seleccionado treeView.Selection.Changed += delegate { clearAction.Sensitive = TreeViewHelper.isSelected(treeView); editAction.Sensitive = TreeViewHelper.isSelected(treeView); //Sirve para ver los cambios }; }
public void fillTreeView() { CellRendererText cellRendererText = new CellRendererText(); for (int i = 0; i < queryResult.ColumNames.Length; i++) { int column = i; treeView.AppendColumn(queryResult.ColumNames.GetValue(i).ToString(), cellRendererText, delegate(TreeViewColumn treeColumn, CellRenderer cell, TreeModel treeModel, TreeIter iter) { IList row = (IList)treeModel.GetValue(iter, 0); cellRendererText.Text = row [column].ToString(); }); } treeView.AppendColumn("Editar", new Gtk.CellRendererPixbuf(), "pixbuf", 1); treeView.AppendColumn("Eliminar", new Gtk.CellRendererPixbuf(), "pixbuf", 2); listStore = new ListStore(typeof(IList), typeof(Gdk.Pixbuf), typeof(Gdk.Pixbuf)); IEnumerable <IList> values = queryResult.Rows; Pixbuf pixbufDelete = new Pixbuf(this.GetType().Assembly, "PSerpisTrives.delete.png"); Pixbuf pixbufEdit = new Pixbuf(this.GetType().Assembly, "PSerpisTrives.edit.png"); foreach (IList k in values) { listStore.AppendValues(k, pixbufEdit, pixbufDelete); } treeView.Model = listStore; treeView.RowActivated += (delegate(object o, RowActivatedArgs args){ string tituloRow = args.Column.Title; if (tituloRow == "Editar") { Console.WriteLine(tituloRow + " prueba path:" + args.Path); TreeIter treeIter = new TreeIter(); treeView.Model.GetIter(out treeIter, args.Path); IList row = (IList)treeView.Model.GetValue(treeIter, 0); int id = int.Parse(row [0].ToString()); QueryResult queryResultGet = PersisterHelper.Get("select * from " + tabla + "where id=" + id); } if (tituloRow == "Eliminar") { Console.WriteLine(tituloRow + " prueba path:" + args.Path); TreeIter treeIter = new TreeIter(); treeView.Model.GetIter(out treeIter, args.Path); IList row = (IList)treeView.Model.GetValue(treeIter, 0); int id = int.Parse(row [0].ToString()); MessageDialog messageDialog = new MessageDialog(new Gtk.Window("Dialog"), DialogFlags.DestroyWithParent, MessageType.Question, ButtonsType.YesNo, "¿Esta seguro que desea eliminar?"); ResponseType result = (ResponseType)messageDialog.Run(); if (result == ResponseType.Yes) { messageDialog.Destroy(); PersisterHelper.Delete(tabla, id); } else { messageDialog.Destroy(); } } }); }