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(); }