private void addToIndex(LuceneData sampleData) { LuceneSearch.AddUpdateLuceneIndex(sampleData); // litResult.Text = "Record was added to search index successfully!"; bindData(); }
private static void _addToLuceneIndex(LuceneData sampleData, IndexWriter writer) { // remove older index entry var searchQuery = new TermQuery(new Term("Id", sampleData.Id.ToString())); writer.DeleteDocuments(searchQuery); // add new index entry var doc = new Document(); // add lucene fields mapped to db fields doc.Add(new Field("Id", sampleData.Id.ToString(), Field.Store.YES, Field.Index.NOT_ANALYZED)); doc.Add(new Field("Name", sampleData.Name, Field.Store.YES, Field.Index.ANALYZED)); doc.Add(new Field("Description", sampleData.Description, Field.Store.YES, Field.Index.ANALYZED)); // add entry to index writer.AddDocument(doc); }
// add/update/clear search index data public static void AddUpdateLuceneIndex(LuceneData sampleData) { AddUpdateLuceneIndex(new List<LuceneData> { sampleData }); }
public static List<LuceneData> GetArticle() { string connStr = ConfigurationManager.ConnectionStrings["MyConnectionString"].ConnectionString; SqlConnection connection = new SqlConnection(connStr); List<LuceneData> obj1 = new List<LuceneData>(); DataTable dt = new DataTable(); SqlConnection con = new SqlConnection(connStr); con.Open(); SqlCommand cmd = new SqlCommand("select * from Article", con); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(dt); if (dt.Rows.Count > 0) { for (int i = 0; i < dt.Rows.Count; i++) { LuceneData ga = new LuceneData(); ga.Id = Convert.ToInt32(dt.Rows[i]["ArticleId"].ToString()); ga.Name = dt.Rows[i]["Title"].ToString(); ga.Description = dt.Rows[i]["Body"].ToString(); obj1.Add(ga); } } return obj1; }