private void BFind_Click(object sender, EventArgs e)
{
if (TBRussian.Text != "" || TBEnglish.Text != "")
{
DB.Open();
TBResults.Clear();
SQLiteCommand CMD = DB.CreateCommand();
CMD.CommandText = "select * from Translator where Russian like '%' || @Russian || '%' and English like '%' || @English || '%'";
CMD.Parameters.Add("@Russian", DbType.String).Value = TBRussian.Text.ToUpper();
CMD.Parameters.Add("@English", DbType.String).Value = TBEnglish.Text.ToUpper();
SQLiteDataReader SQReader = CMD.ExecuteReader();
if (SQReader.HasRows)
{
while (SQReader.Read())
{
TBResults.Text += SQReader["Russian"] + " - " + SQReader["English"] + "\r\n";
}
}
else
{
TBResults.Text = "Нет результатов";
}
LResCount.Text = GetWordsCount();
DB.Close();
}
}
private void BDelete_Click(object sender, EventArgs e)
{
if (TBRussian.Text != "" && TBEnglish.Text != "")
{
DB.Open();
TBResults.Clear();
SQLiteCommand CMD = DB.CreateCommand();
CMD.CommandText = "delete from Translator where Russian = @Russian and English = @English";
CMD.Parameters.Add("@Russian", DbType.String).Value = TBRussian.Text.ToUpper();
CMD.Parameters.Add("@English", DbType.String).Value = TBEnglish.Text.ToUpper();
CMD.ExecuteNonQuery();
TBRussian.Text = "";
TBEnglish.Text = "";
DB.Close();
RefreshList();
}
else
{
MessageBox.Show("Что бы удалить слово нужно ввести его " +
"вариант на двух языках для точного удаления!");
}
}
public void RefreshList()
{
DB.Open();
SQLiteCommand CMD = DB.CreateCommand();
CMD.CommandText = "select * from Translator order by Russian";
TBResults.Clear();
SQLiteDataReader SQReader = CMD.ExecuteReader();
if (SQReader.HasRows)
{
while (SQReader.Read())
{
TBResults.Text += SQReader["Russian"] + " - " + SQReader["English"] + "\r\n";
}
}
else
{
TBResults.Text = "Нет результатов";
}
LResCount.Text = GetWordsCount();
DB.Close();
}