private void cbCategoria_SelectedIndexChanged(object sender, EventArgs e)
{
cbSubCategoria.SelectedItem = string.Empty;
var categoriaWhere = "Producto_categoria_descripcion = '" + DataUtil.GetString(cbCategoria.SelectedItem) + "'";
DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere)), null);
}
private void SubCategoriasCarouselDataBinding_Load(int categoriaID)
{
if (categoriaID != 0)
{
if (categoriaIdSelected != categoriaID)
{
tcAdicionales.Visible = false;
tcProductos.Visible = false;
categoriaIdSelected = categoriaID;
rcSubCategorias.ItemDataBound += new ItemDataBoundEventHandler(rcSubCategorias_ItemDataBound);
rcSubCategorias.NewCarouselItemCreating += new NewCarouselItemCreatingEventHandler(rcSubCategorias_NewCarouselItemCreating);
// Create a generic list of Feature objects and bind it
List <SubCategoriasFeatures> sub_products = new List <SubCategoriasFeatures>();
DataSet dsSubCategorias = DataUtil.FillDataSet(DataBaseQuerys.ProductoSubCategoriaActivos(true, categoriaID.ToString()), "producto_sub_categoria");
if (dsSubCategorias.Tables["producto_sub_categoria"].Rows.Count > 0)
{
foreach (DataRow subCategoriaRow in dsSubCategorias.Tables["producto_sub_categoria"].Rows)
{
string subCategoriaDesc = DataUtil.GetString(subCategoriaRow["Producto_sub_categoria_descripcion"]);
if (subCategoriaDesc.Length > 12)
{
subCategoriaDesc = subCategoriaDesc.Remove(12);
}
int subCategoriaID = DataUtil.GetInt(subCategoriaRow["Producto_sub_categoria_id"]);
sub_products.Add(new SubCategoriasFeatures(subCategoriaID, subCategoriaDesc));
}
}
rcSubCategorias.DataSource = sub_products;
}
}
}
private void btnAddCategoria_Click(object sender, EventArgs e)
{
DialogResult result = MessageBox.Show("Desea agregar una nueva sub categoria?", "Sub Categoria", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
frmProductSubCategory frmProductSubCategoryAdd = new frmProductSubCategory();
frmProductSubCategoryAdd.adding = true;
frmProductSubCategoryAdd.formTitle = "Producto Sub Categoria - Agregar";
frmProductSubCategoryAdd.ShowDialog();
string categoriaWhere = "Producto_categoria_descripcion = '" + DataUtil.GetString(cbCategoria.SelectedItem) + "'";
DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_id", categoriaWhere)), null);
}
}
private void frmProductSearch_Load(object sender, EventArgs e)
{
btnAdd.Visible = DataBaseQuerys.GetAccess(13, AppConstant.EmployeeInfo.Codigo, AppConstant.AccessoTipos.Nuevo);
btnModify.Visible = DataBaseQuerys.GetAccess(13, AppConstant.EmployeeInfo.Codigo, AppConstant.AccessoTipos.Edicion);
DataUtil.FillComboBox(cbCategoria.Items, DataBaseQuerys.ProductoCategoriaActivos(false), string.Empty);
DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, string.Empty), string.Empty);
lblNo.Text = @"0";
if (dsSearchProd != null)
{
cbCategoria.SelectedItem = string.Empty;
cbSubCategoria.SelectedItem = string.Empty;
cbTipo.SelectedItem = string.Empty;
txtDescripcion.Text = descriptionSearch;
dgwResult.DataSource = dsSearchProd;
dgwResult.DataMember = "producto";
dgwResult.Columns[1].Width = 300;
lblNo.Text = DataUtil.GetString(dsSearchProd.Tables[0].Rows.Count);
if (tipoSearch != string.Empty)
{
cbTipo.SelectedItem = tipoSearch;
cbTipo.Enabled = false;
btnClean.Visible = false;
}
if (categoriaIdSearch != string.Empty)
{
string sWhere = "producto_categoria_id = " + categoriaIdSearch + "";
cbCategoria.SelectedItem = DataUtil.FindSingleRow("producto_categoria", "Producto_categoria_descripcion", sWhere);
sWhere = "producto_sub_categoria_id = " + subCategoriaIdSearch + "";
cbSubCategoria.SelectedItem = DataUtil.FindSingleRow("producto_sub_categoria", "Producto_sub_categoria_descripcion", sWhere);
cbCategoria.Enabled = false;
cbSubCategoria.Enabled = false;
btnClean.Visible = false;
}
}
}
public void BindDataGrid()
{
lblNo.Text = "0";
if (stringBrowserSQL != string.Empty)
{
DataSet dsTable = DataUtil.FillDataSet(stringBrowserSQL, tableNameBrowser);
dgwResult.DataSource = dsTable;
dgwResult.DataMember = tableNameBrowser;
dgwResult.Columns[0].Width = columnWidth0;
dgwResult.Columns[1].Width = columnWidth1;
dgwResult.Columns[2].Width = columnWidth2;
dgwResult.Columns[3].Width = columnWidth3;
dgwResult.Columns[4].Width = columnWidth4;
dgwResult.Columns[5].Width = columnWidth5;
dgwResult.Columns[6].Width = columnWidth6;
if (dgwResult.Columns.Count > 7)
{
dgwResult.Columns[7].Width = columnWidth7;
}
if (dgwResult.Columns.Count > 8)
{
dgwResult.Columns[8].Width = columnWidth8;
}
lblNo.Text = DataUtil.GetString(dsTable.Tables[0].Rows.Count);
if (searchVisible)
{
DataUtil.FillComboBox(cbField.Items, "SELECT * FROM configuracion_busqueda WHERE tabla = '" + tableNameBrowser + "' ORDER BY campo", string.Empty);
}
}
if (categoriaVisible)
{
DataUtil.FillComboBox(cbCategoria.Items, DataBaseQuerys.ProductoCategoriaActivos(false), null);
DataUtil.FillComboBox(cbSubCategoria.Items, DataBaseQuerys.ProductoSubCategoriaActivos(false, string.Empty), null);
}
}
