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