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();
}
}
});
}
