private void btnDelete_Click(object sender, EventArgs e)
{
SearchPatternAR sp = new SearchPatternAR();
sp = cmbPatterns.SelectedItem as SearchPatternAR;
s.Delete(sp);
MessageBox.Show("Запись удалена");
}
// Пример активной записи
private void btnInsertXYZ_Click(object sender, EventArgs e)
{
SearchPatternAR sp = new SearchPatternAR();
sp.RegularExpression = "XYZ";
sp.Action = "XYZ";
sp.CompareWith = "XYZ";
s.Create(sp);
MessageBox.Show("Запись " + "'XYZ'" + " успешно добавлена");
}
private void btnInsert_Click(object sender, EventArgs e)
{
SearchPatternAR sp = new SearchPatternAR();
sp.RegularExpression = txtRegExp.Text;
sp.Action = cmbCompare.Text;
sp.CompareWith = cmbAction.Text;
s.Create(sp);
MessageBox.Show("Запись успешно добавлена");
}
// CRUD поисковых шаблонов
//Create
public void Create(SearchPatternAR arsp)
{
using (SqlConnection connection1 = new SqlConnection(CONNECTION_STRING))
{
connection1.Open();
using (SqlCommand command = connection1.CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "INSERT INTO TSearchPattern (regularExpression, compareWith, action) VALUES('" + arsp.RegularExpression + "', '" + arsp.CompareWith + "', '" + arsp.Action + "')";
command.ExecuteNonQuery();
}
}
}
//Delete
public void Delete(SearchPatternAR sp)
{
using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
using (SqlCommand command = connection.CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "DELETE FROM TSearchPattern WHERE ID= " + sp.ID;
command.ExecuteNonQuery();
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
SearchPatternAR oldPattern = new SearchPatternAR();
SearchPatternAR newPattern = new SearchPatternAR();
oldPattern = cmbPatterns.SelectedItem as SearchPatternAR;
newPattern.RegularExpression = txtNewRegExp.Text;
newPattern.CompareWith = cmbNewCompare.Text;
newPattern.Action = cmbNewAction.Text;
s.Update(oldPattern, newPattern);
MessageBox.Show("Запись обновлена");
}
//Update
public void Update(SearchPatternAR oldPattern, SearchPatternAR newPattern)
{
using (SqlConnection connection = new SqlConnection(CONNECTION_STRING))
{
connection.Open();
using (SqlCommand command = connection.CreateCommand())
{
command.CommandType = System.Data.CommandType.Text;
command.CommandText = "UPDATE [TSearchPattern] SET regularExpression= '" + newPattern.RegularExpression + "', compareWith= '" + newPattern.CompareWith + "', action= '" + newPattern.Action + "' WHERE ID=" + oldPattern.ID;
command.ExecuteNonQuery();
}
}
}
//Read
public List <SearchPatternAR> Read()
{
List <SearchPatternAR> spList = new List <SearchPatternAR>();
try
{
command.CommandText = "SELECT * FROM TSearchPattern";
command.CommandType = System.Data.CommandType.Text;
connection.Open();
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
SearchPatternAR sp = new SearchPatternAR();
sp.ID = Convert.ToInt32(reader["ID"].ToString());
sp.RegularExpression = reader["regularExpression"].ToString();
sp.CompareWith = reader["compareWith"].ToString();
sp.Action = reader["action"].ToString();
spList.Add(sp);
}
return(spList);
}
catch (Exception)
{
throw;
}
finally
{
if (connection != null)
{
connection.Close();
}
}
}
