public AddUpdateTesauroScjn(TesauroScjn conceptoScjn) { InitializeComponent(); this.conceptoScjn = conceptoScjn; this.isUpdating = true; this.Header = "Actualizar concepto del tesauro de la SCJN"; }
public ObservableCollection <TesauroScjn> GetRelations(Temas temaTematico, int tipoRelacion) { OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString()); ObservableCollection <TesauroScjn> conceptosRelacionados = new ObservableCollection <TesauroScjn>(); OleDbCommand cmd; OleDbDataReader reader; cmd = connection.CreateCommand(); cmd.Connection = connection; try { connection.Open(); string miQry = "SELECT T.* FROM Relaciones R INNER JOIN TesauroScjn T ON R.IdRelExterna = T.IdTesauroScjn " + " WHERE IdConcepto = @IdConcepto AND TipoRelacion = @TipoRelacion"; cmd = new OleDbCommand(miQry, connection); cmd.Parameters.AddWithValue("@IdConcepto", temaTematico.IDTema); cmd.Parameters.AddWithValue("@TipoRelacion", tipoRelacion); reader = cmd.ExecuteReader(); while (reader.Read()) { TesauroScjn tesauro = new TesauroScjn() { Id = reader["IdTesauroScjn"] as int? ?? 0, ConceptoScjn = reader["Concepto"].ToString(), IsSelected = false }; conceptosRelacionados.Add(tesauro); } } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } finally { connection.Close(); } return(conceptosRelacionados); }
/// <summary> /// Obtiene los términos relacionados a un concepto genérico en concreto /// </summary> /// <param name="idConceptoScjn">Identificador del concepto del cual se quieren obtener sus relaciones</param> /// <returns></returns> public ObservableCollection <TesauroScjn> GetTerminosScjn(Genericos terminoGenerico) { ObservableCollection <TesauroScjn> conceptos = new ObservableCollection <TesauroScjn>(); OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString()); OleDbCommand cmd; OleDbDataReader reader = null; try { connection.Open(); string sqlCadena = "SELECT T.IdTesauroScjn, T.Concepto, R.IdConcepto, R.IdRelExterna " + " FROM TesauroScjn T INNER JOIN Relaciones R ON R.IdRelExterna = T.IdTesauroScjn " + " WHERE IdConcepto = @IdConcepto AND TipoRelacion = 9"; cmd = new OleDbCommand(sqlCadena, connection); cmd.Parameters.AddWithValue("@IdConcepto", terminoGenerico.IdGenerico); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { TesauroScjn scjn = new TesauroScjn(); scjn.Id = reader["IdTesauroScjn"] as int? ?? 0; scjn.ConceptoScjn = reader["Concepto"].ToString(); conceptos.Add(scjn); } } } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } finally { reader.Close(); connection.Close(); } return(conceptos); }
/// <summary> /// Permite añadir un nuevo concepto del Tesauro de la SCJN /// </summary> /// <param name="terminoScjn"></param> public void SetNewTerminoScjn(TesauroScjn terminoScjn) { OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString()); OleDbDataAdapter dataAdapter; DataSet dataSet = new DataSet(); DataRow dr; try { string sqlCadena = "SELECT * FROM TesauroScjn WHERE IdTesauroScjn = 0"; dataAdapter = new OleDbDataAdapter(); dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection); dataAdapter.Fill(dataSet, "TesauroScjn"); dr = dataSet.Tables["TesauroScjn"].NewRow(); dr["IdTesauroScjn"] = terminoScjn.Id; dr["Concepto"] = StringUtilities.ToTitleCase(terminoScjn.ConceptoScjn); dataSet.Tables["TesauroScjn"].Rows.Add(dr); dataAdapter.InsertCommand = connection.CreateCommand(); dataAdapter.InsertCommand.CommandText = "INSERT INTO TesauroScjn VALUES (@IdTesauroScjn,@Concepto)"; dataAdapter.InsertCommand.Parameters.Add("@IdTesauroScjn", OleDbType.Numeric, 0, "IdTesauroScjn"); dataAdapter.InsertCommand.Parameters.Add("@Concepto", OleDbType.VarChar, 0, "Concepto"); dataAdapter.Update(dataSet, "TesauroScjn"); dataSet.Dispose(); dataAdapter.Dispose(); } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } finally { connection.Close(); } }
/// <summary> /// /// </summary> /// <returns></returns> public ObservableCollection <TesauroScjn> GetTerminosScjn() { OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString()); ObservableCollection <TesauroScjn> terminosScjn = new ObservableCollection <TesauroScjn>(); OleDbCommand cmd; OleDbDataReader reader; cmd = connection.CreateCommand(); cmd.Connection = connection; try { connection.Open(); string miQry = "SELECT * FROM TesauroScjn"; cmd = new OleDbCommand(miQry, connection); reader = cmd.ExecuteReader(); while (reader.Read()) { TesauroScjn tesauro = new TesauroScjn(); tesauro.Id = reader["IdTesauroScjn"] as int? ?? -1; tesauro.ConceptoScjn = reader["Concepto"].ToString(); terminosScjn.Add(tesauro); } } catch (OleDbException ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } catch (Exception ex) { string methodName = System.Reflection.MethodBase.GetCurrentMethod().Name; MessageBox.Show("Error ({0}) : {1}" + ex.Source + ex.Message, methodName, MessageBoxButtons.OK, MessageBoxIcon.Warning); ErrorUtilities.SetNewErrorMessage(ex, methodName, 0); } finally { connection.Close(); } return(terminosScjn); }
private void BtnAddRelaciona_Click(object sender, RoutedEventArgs e) { TesauroScjn tesauro = new TesauroScjn() { Id = Convert.ToInt32(TxtIdTemaScjn.Text), ConceptoScjn = TxtConceptoScjn.Text, IsSelected = false }; new TesauroScjnModel().SetNewTerminoScjn(tesauro); new RelacionesModel().SetNewRelation(selectedTema.IDTema, tesauro.Id, selectedMateria.Id + 100); TesauroScjnSingleton.ConceptosScjn.Add(tesauro); conceptosScjn.Add(tesauro); this.BtnLimpiar_Click(null, null); }
public AddUpdateTesauroScjn() { InitializeComponent(); this.conceptoScjn = new TesauroScjn(); this.Header = "Añadir concepto del tesauro de la SCJN"; }