private void UpdateIndex()
{
// Update Lucene search index
LuceneIndexer li = new LuceneIndexer();
li.CreateIndexWriter();
li.UpdateWebPage(FaqID.ToString(), URL, Question, Question + " " + Answer, "FAQ");
li.Close();
li.IndexWords();
}
public void Delete()
{
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
using (SqlCommand cmd = new SqlCommand("DELETE FROM cms_FAQ WHERE FaqSerial = @FaqSerial", cn)) {
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("FaqSerial", SqlDbType.Int).Value = _FaqSerial;
cmd.Connection.Open();
cmd.ExecuteNonQuery();
cmd.Connection.Close();
}
}
// Remove from Lucene search index
LuceneIndexer li = new LuceneIndexer();
li.CreateIndexWriter();
li.Delete(FaqID.ToString());
li.Close();
}
