internal async void GetCategorias() { try { IsBusy = true; long ultimo = 0; LstCategorias.Clear(); var Cardapio = await RecuperaCardapioAsync(); Cardapio.Sort((x, y) => x.ID_CATEGORIA.CompareTo(y.ID_CATEGORIA)); foreach (var item in Cardapio) { if (ultimo != item.ID_CATEGORIA) { LstCategorias.Add(new CardapioCateg() { ID_CATEGORIA = item.ID_CATEGORIA, DS_CATEGORIA = item.DS_CATEGORIA, FL_ADICIONAL = item.FL_ADICIONAL == "T", FL_ASSAR = item.FL_ASSAR, FL_PERMITEADICIONAL = item.FL_PERMITEADICIONAL == "T" }); } ultimo = item.ID_CATEGORIA; } } catch { } finally { IsBusy = false; } }
protected void Lst_division_SelectedIndexChanged(object sender, EventArgs e) { GridViewRow row = Lst_division.SelectedRow; //lbl_status.Text = row.Cells[1].Text; lbl_familia.Text = row.Cells[2].Text; id_familia = Convert.ToInt32(row.Cells[1].Text); LstCategorias.DataSource = null; LstCategorias.DataBind(); LstSubCategorias.DataSource = null; LstSubCategorias.DataBind(); carga_categorias(Convert.ToInt32(row.Cells[1].Text)); }
void carga_categorias(int id_familia) { string sql = ""; sql = "select ID_Categoria ID, CONCAT('(',Codigo,')',' ', Nombre) Categoria, IIF(activo=1,'SI','NO') Activo from tbl_Categorias where Id_Familia = " + id_familia; sql = "select ID_Categoria ID, "; sql = sql + "CONCAT('(', Codigo, ')', ' ', Nombre) Categoria, "; sql = sql + "IIF(activo = 1, 'SI', 'NO') Activo, "; sql = sql + "(select COUNT(1) from tbl_Subcategorias where Id_Categoria = tbl_Categorias.Id_Categoria) SubCategorias, "; sql = sql + "(select COUNT(distinct ct.id_categoria) from tbl_Items_web iw "; sql = sql + "inner join tbl_Categorias ct on ct.ID_Categoria = iw.Id_Categoria where iw.publicado_sitio = 1 "; sql = sql + "and ct.ID_Categoria = tbl_Categorias.ID_Categoria) Publicadas "; sql = sql + "from tbl_Categorias where Id_Familia = " + id_familia; using (SqlConnection connection = new SqlConnection(Sserver)) { try { connection.Open(); //SqlCommand command = new SqlCommand(sql, connection); SqlDataAdapter reader = new SqlDataAdapter(sql, connection); DataSet dr = new DataSet(); reader.Fill(dr, "tbl_Categorias"); LstCategorias.DataSource = dr; LstCategorias.DataBind(); connection.Close(); connection.Dispose(); } catch (Exception ex) { lbl_error.Text = ex.Message; connection.Close(); connection.Dispose(); } } }