public ObservableCollection<ElementalProperties> GetTitulos() { ObservableCollection<ElementalProperties> catalogoTitulos = new ObservableCollection<ElementalProperties>(); string sqlCadena = "SELECT * FROM C_Titulo ORDER BY IdTitulo"; OleDbConnection connection = new OleDbConnection(connectionString); OleDbCommand cmd = null; OleDbDataReader reader = null; try { connection.Open(); cmd = new OleDbCommand(sqlCadena, connection); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ElementalProperties elemento = new ElementalProperties(); elemento.IdElemento = Convert.ToInt32(reader["IdTitulo"]); elemento.Descripcion = reader["TituloMay"].ToString(); elemento.ElementoAuxiliar = reader["TituloAbr"].ToString(); catalogoTitulos.Add(elemento); } } cmd.Dispose(); reader.Close(); } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ElementalPropertiesModel", "PadronApi"); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; ErrorUtilities.SetNewErrorMessage(ex, methodName + " Exception,ElementalPropertiesModel", "PadronApi"); } finally { connection.Close(); } return catalogoTitulos; }
private void CbxTipoOrg_SelectionChanged(object sender, SelectionChangedEventArgs e) { TxtOrganismo.Text = String.Empty; selectedTipoOrg = CbxTipoOrg.SelectedItem as ElementalProperties; if (selectedTipoOrg.IdElemento < 2 || selectedTipoOrg.IdElemento > 10) { GpxMaterias.IsEnabled = false; CbxOrdinal.IsEnabled = false; CbxCircuito.IsEnabled = false; LblDescripcion.IsEnabled = false; TxtOrganismo.IsEnabled = true; CbxCircuito.SelectedIndex = -1; CbxOrdinal.SelectedIndex = -1; foreach (Materia materia in listaMaterias) materia.IsChecked = false; } else { GpxMaterias.IsEnabled = true; CbxOrdinal.IsEnabled = true; CbxCircuito.IsEnabled = true; LblDescripcion.IsEnabled = true; TxtOrganismo.IsEnabled = false; } }