private void btnModificarSubcategoria_Click(object sender, EventArgs e)
{
var nef = new NuevoElementoForm
{
Text = "Modificar Subcategoría",
Elemento = listSubcategorias.SelectedItems[0].Text
};
if (nef.ShowDialog() == DialogResult.OK)
{
// modificar
try
{
dh_subcategorias subcat = new dh_subcategorias().getObject((int)listSubcategorias.SelectedValue);
subcat.subcategoria = nef.Elemento;
subcat.id_categoria = (int)listCategorias.SelectedValue;
subcat.Update(subcat);
DataSet ds = new dh_subcategorias().GetDataSet((int)listCategorias.SelectedValue);
listSubcategorias.DisplayMember = "subcategoria";
listSubcategorias.ValueMember = "id_subcategoria";
listSubcategorias.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
Log.ShowAndLog(ex);
}
}
}
private void listCategorias_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (listCategorias.SelectedIndices.Count != 0)
{
// cargar subs
DataSet ds = new dh_subcategorias().GetDataSet((int)listCategorias.SelectedValue);
listSubcategorias.DisplayMember = "subcategoria";
listSubcategorias.ValueMember = "id_subcategoria";
listSubcategorias.DataSource = ds.Tables[0];
btnModificarCategoria.Enabled = true;
btnEliminarCategoria.Enabled = true;
btnAgregarSubcategoria.Enabled = true;
}
else
{
listSubcategorias.Items.Clear();
btnModificarCategoria.Enabled = false;
btnEliminarCategoria.Enabled = false;
btnAgregarSubcategoria.Enabled = false;
}
}
catch (Exception ex)
{
Log.ShowAndLog(ex);
}
}
private void btnAgregarSubcategoria_Click(object sender, EventArgs e)
{
var nef = new NuevoElementoForm {
Text = "Nueva Subcategoría"
};
if (nef.ShowDialog() == DialogResult.OK)
{
// agregar
var subcat = new dh_subcategorias
{
subcategoria = nef.Elemento,
id_categoria = ((int)listCategorias.SelectedValue)
};
subcat.Insert(subcat);
DataSet ds = new dh_subcategorias().GetDataSet((int)listCategorias.SelectedValue);
listSubcategorias.DisplayMember = "subcategoria";
listSubcategorias.ValueMember = "id_subcategoria";
listSubcategorias.DataSource = ds.Tables[0];
}
}
private void btnEliminarSubcategoria_Click(object sender, EventArgs e)
{
if (
MessageBox.Show(
"Si elimina esta subcategoría, se eliminarán todos los elementos que contiene, ¿está seguro?",
"Eliminar Subcategoría", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
// eliminar
try
{
new dh_subcategorias().Delete((int)listSubcategorias.SelectedValue);
DataSet ds = new dh_subcategorias().GetDataSet((int)listCategorias.SelectedValue);
listSubcategorias.DisplayMember = "subcategoria";
listSubcategorias.ValueMember = "id_subcategoria";
listSubcategorias.DataSource = ds.Tables[0];
}
catch (Exception ex)
{
Log.ShowAndLog(ex);
}
}
}
private void DespachoHerramientasEquiposForm_Load(object sender, EventArgs e)
{
//icono
Icon = Icon.FromHandle(Resources.icon.GetHicon());
// cargar treeview
DataSet ds = new dh_categorias().GetDataSet();
foreach (DataRow dr in ds.Tables[0].Rows)
{
var tn = new TreeNode {
Text = ((string)dr["categoria"])
};
DataSet ds1 = new dh_subcategorias().GetDataSet((int)dr["id_categoria"]);
tn.ImageKey = "icon-toolbox";
tn.SelectedImageKey = "icon-toolbox";
foreach (DataRow dr2 in ds1.Tables[0].Rows)
{
var tn2 = new SubcategoriaTreeNode((string)dr2["subcategoria"])
{
Tag = dr2["id_subcategoria"],
ImageKey = "icon-tools",
SelectedImageKey = "icon-tools"
};
tn.Nodes.Add(tn2);
}
treeCategorias.Nodes.Add(tn);
}
// cargar expedientes
DataSet exp = new e_expedientes().Gete_expedientes();
comboExpedientes.DisplayMember = "clave_dir";
comboExpedientes.ValueMember = "id_expediente";
comboExpedientes.DataSource = exp.Tables[0];
comboExpedientes.SelectedValue = zeusWin.IdExpediente;
}
