public void DeleteSinonimo(Sinonimos sinonimo)
{
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbCommand cmd;
try
{
connection.Open();
string sqlCadena = "Delete FROM Sinonimos WHERE IdSinonimo = @IdSinonimo";
cmd = new OleDbCommand(sqlCadena, connection);
cmd.Parameters.AddWithValue("@IdSinonimo", sinonimo.IdSinonimo);
cmd.ExecuteNonQuery();
}
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();
}
}
private void BtnAgregar_Click(object sender, RoutedEventArgs e)
{
if (String.IsNullOrEmpty(TxtConcepto.Text) || String.IsNullOrWhiteSpace(TxtConcepto.Text))
{
MessageBox.Show("Ingrese el concepto antes de Agregar");
return;
}
else
{
Sinonimos newSinonimo = new Sinonimos();
newSinonimo.Sinonimo = StringUtilities.UppercaseFirst(TxtConcepto.Text);
newSinonimo.SinonimoStr = StringUtilities.PrepareToAlphabeticalOrder(newSinonimo.Sinonimo);
newSinonimo.Fuente = TxtFuente.Text;
if (!String.IsNullOrEmpty(newSinonimo.Fuente) || !String.IsNullOrWhiteSpace(newSinonimo.Fuente))
{
newSinonimo.FuenteStr = StringUtilities.PrepareToAlphabeticalOrder(newSinonimo.Fuente);
}
sinonimosPorGuardar.Add(newSinonimo);
TxtConcepto.Text = String.Empty;
RBtnAceptar.IsEnabled = true;
}
}
/*
* En esta clase la mayor parte de los métodos hacen referencia a los sinónimos de las palabras existentes en el
* diccionario. Los sinónimod mostrados en los temáticos usan el API propia de los mismos para ser mostrados, a
* excepción del Temático Constitucional que si esta contenido dentro de esta clase y se identifica expresamente
* */
public ObservableCollection <Sinonimos> GetSinonimos(Genericos terminoGenerico)
{
ObservableCollection <Sinonimos> conceptos = new ObservableCollection <Sinonimos>();
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbCommand cmd;
OleDbDataReader reader = null;
try
{
connection.Open();
string sqlCadena = "SELECT S.IdSinonimo, S.Sinonimo, S.Fuente, R.IdConcepto, R.IdRelExterna " +
" FROM Sinonimos S INNER JOIN Relaciones R ON R.IdRelExterna = S.IdSinonimo " +
" WHERE IdConcepto = @IdConcepto AND TipoRelacion = 2";
cmd = new OleDbCommand(sqlCadena, connection);
cmd.Parameters.AddWithValue("@IdConcepto", terminoGenerico.IdGenerico);
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Sinonimos sinonimo = new Sinonimos();
sinonimo.IdSinonimo = reader["IdSinonimo"] as int? ?? 0;
sinonimo.Sinonimo = reader["Sinonimo"].ToString();
sinonimo.Fuente = reader["Fuente"].ToString();
conceptos.Add(sinonimo);
}
}
}
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);
}
public ObservableCollection <Sinonimos> GetSinonimos()
{
ObservableCollection <Sinonimos> conceptos = new ObservableCollection <Sinonimos>();
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbCommand cmd;
OleDbDataReader reader = null;
try
{
connection.Open();
string sqlCadena = "SELECT * FROM Sinonimos";
cmd = new OleDbCommand(sqlCadena, connection);
reader = cmd.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Sinonimos sinonimo = new Sinonimos();
sinonimo.IdSinonimo = reader["IdSinonimo"] as int? ?? 0;
sinonimo.Sinonimo = reader["Sinonimo"].ToString();
sinonimo.SinonimoStr = reader["SinonimoStr"].ToString();
conceptos.Add(sinonimo);
}
}
}
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);
}
public UpdateSinonimos(Sinonimos sinonimo)
{
InitializeComponent();
this.sinonimo = sinonimo;
}
private void RLstSinonimos_SelectionChanged(object sender, SelectionChangeEventArgs e)
{
SelectedSinonimo = RLstSinonimos.SelectedItem as Sinonimos;
}
/// <summary>
/// Modifica la estructura original del sinónimo
/// </summary>
/// <param name="sinonimo">Sinonimo que se modificará</param>
public void UpdateSinonimo(Sinonimos sinonimo)
{
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
string sqlCadena = "SELECT * FROM Sinonimos WHERE IdSinonimo = @IdSinonimo";
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection);
dataAdapter.SelectCommand.Parameters.AddWithValue("@IdSinonimo", sinonimo.IdSinonimo);
dataAdapter.Fill(dataSet, "Sinonimos");
dr = dataSet.Tables["Sinonimos"].Rows[0];
dr.BeginEdit();
dr["Sinonimo"] = sinonimo.Sinonimo;
dr["SinonimoStr"] = sinonimo.SinonimoStr;
dr["Fuente"] = sinonimo.Fuente;
dr["FuenteStr"] = sinonimo.FuenteStr;
dr.EndEdit();
dataAdapter.UpdateCommand = connection.CreateCommand();
dataAdapter.UpdateCommand.CommandText = "UPDATE Sinonimos SET Sinonimo = @Sinonimo, SinonimoStr = @SinonimoStr, " +
" Fuente = @Fuente, FuenteStr = @FuenteStr WHERE IdSinonimo = @IdSinonimo";
dataAdapter.UpdateCommand.Parameters.Add("@Sinonimo", OleDbType.VarChar, 0, "Sinonimo");
dataAdapter.UpdateCommand.Parameters.Add("@SinonimoStr", OleDbType.VarChar, 0, "SinonimoStr");
dataAdapter.UpdateCommand.Parameters.Add("@Fuente", OleDbType.VarChar, 0, "Fuente");
dataAdapter.UpdateCommand.Parameters.Add("@FuenteStr", OleDbType.VarChar, 0, "FuenteStr");
dataAdapter.UpdateCommand.Parameters.Add("@IdSinonimo", OleDbType.Numeric, 0, "IdSinonimo");
dataAdapter.Update(dataSet, "Sinonimos");
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>
/// Establece una relación entre algún concepto y el término que se quiere asociar como sinónimo
/// </summary>
/// <param name="sinonimo">Término con significado similar </param>
/// <param name="idConcepto">Concepto al que irá ligado el sinónimo</param>
public void SetNewSinonimo(Sinonimos sinonimo, int idConcepto)
{
OleDbConnection connection = new OleDbConnection(ConfigurationManager.ConnectionStrings["Diccionario"].ToString());
OleDbDataAdapter dataAdapter;
DataSet dataSet = new DataSet();
DataRow dr;
try
{
sinonimo.IdSinonimo = DataBaseUtilities.GetNextIdForUse("Sinonimos", "IdSinonimo", connection);
string sqlCadena = "SELECT * FROM Sinonimos WHERE IdSinonimo = 0";
dataAdapter = new OleDbDataAdapter();
dataAdapter.SelectCommand = new OleDbCommand(sqlCadena, connection);
dataAdapter.Fill(dataSet, "Sinonimos");
dr = dataSet.Tables["Sinonimos"].NewRow();
dr["IdSinonimo"] = sinonimo.IdSinonimo;
dr["Sinonimo"] = sinonimo.Sinonimo;
dr["SinonimoStr"] = sinonimo.SinonimoStr;
dr["Fuente"] = sinonimo.Fuente;
dr["FuenteStr"] = sinonimo.FuenteStr;
dr["FechaAlta"] = DateTime.Now;
dr["FechaAltaInt"] = DateTimeUtilities.DateToInt(DateTime.Now);
dataSet.Tables["Sinonimos"].Rows.Add(dr);
dataAdapter.InsertCommand = connection.CreateCommand();
dataAdapter.InsertCommand.CommandText = "INSERT INTO Sinonimos VALUES (@IdSinonimo,@Sinonimo,@SinonimoStr,@Fuente,@FuenteStr,@FechaAlta,@FechaAltaInt)";
dataAdapter.InsertCommand.Parameters.Add("@IdSinonimo", OleDbType.Numeric, 0, "IdSinonimo");
dataAdapter.InsertCommand.Parameters.Add("@Sinonimo", OleDbType.VarChar, 0, "Sinonimo");
dataAdapter.InsertCommand.Parameters.Add("@SinonimoStr", OleDbType.VarChar, 0, "SinonimoStr");
dataAdapter.InsertCommand.Parameters.Add("@Fuente", OleDbType.VarChar, 0, "Fuente");
dataAdapter.InsertCommand.Parameters.Add("@FuenteStr", OleDbType.VarChar, 0, "FuenteStr");
dataAdapter.InsertCommand.Parameters.Add("@FechaAlta", OleDbType.Date, 0, "FechaAlta");
dataAdapter.InsertCommand.Parameters.Add("@FechaAltaInt", OleDbType.Numeric, 0, "FechaAltaInt");
dataAdapter.Update(dataSet, "Sinonimos");
dataSet.Dispose();
dataAdapter.Dispose();
new RelacionesModel().SetNewRelation(idConcepto, sinonimo.IdSinonimo, 2);
}
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();
}
}