/// <summary>
/// Indexing a single publication, passed as parameter
/// </summary>
/// <param name="bean"></param>
/// <param name="lng"></param>
/// <returns></returns>
public static int IndexPublication(IssueDocumentDto bean, string lng)
{
Analyzer analyzer = new SpanishAnalyzer(ConfigurationController.Stop_Words);
if (!string.IsNullOrEmpty(ConfigurationController.IndexRootPath))
{
Directory indexDir = FSDirectory.Open(new System.IO.DirectoryInfo(ConfigurationController.IndexRootPath + "/ES/IDX"));
if (!lng.ToLower().Trim().Equals("es"))
{
indexDir = FSDirectory.Open(new System.IO.DirectoryInfo(ConfigurationController.IndexRootPath + "/EN/IDX"));
}
LuceneDao dao = new LuceneDao();
dao.Analizer = analyzer;
return(dao.IndexPublication(indexDir, bean));
}
return(-1);
}
/// <summary>
/// Get publication list
/// </summary>
/// <param name="start"></param>
/// <param name="end"></param>
/// <param name="lng"></param>
/// <returns></returns>
public Dictionary <string, IssueDocumentDto> GetIssuesIndexList(int start, int end, string lng)
{
Dictionary <string, IssueDocumentDto> issuesList = new Dictionary <string, IssueDocumentDto>();
try
{
using (SqlConnection sqlConn = new SqlConnection(ConfigurationController.MainConnectionString))
{
SqlCommand command = new SqlCommand("SP_BW_ISSUES_SEARCH", sqlConn);
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue("@StartRowIndex", start);
command.Parameters.AddWithValue("@EndRowIndex", end);
sqlConn.Open();
SqlDataReader dr = command.ExecuteReader();
IssueDocumentDto obj = null;
while (dr.Read())
{
obj = new IssueDocumentDto();
obj.Id = dr.GetInt32(dr.GetOrdinal("Issue_ID"));
if (!dr.IsDBNull(dr.GetOrdinal("Issue_Company_ID")))
{
obj.CompanyId = dr.GetInt32(dr.GetOrdinal("Issue_Company_ID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Issue_ID_Per_Company")))
{
obj.IssueIdPerCompany = dr.GetInt32(dr.GetOrdinal("Issue_ID_Per_Company"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Issue_Title")))
{
obj.IssueTitle = dr.GetString(dr.GetOrdinal("Issue_Title"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Priority_ID")))
{
obj.PriorityId = dr.GetInt32(dr.GetOrdinal("Priority_ID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Status_ID")))
{
obj.StatusId = dr.GetInt32(dr.GetOrdinal("Status_ID"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Cur_Owner")))
{
obj.CurrentOwner = dr.GetString(dr.GetOrdinal("Cur_Owner"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Last_Owner")))
{
obj.LastOwner = dr.GetString(dr.GetOrdinal("Last_Owner"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Project_Name")))
{
obj.ProjectName = dr.GetString(dr.GetOrdinal("Project_Name"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Assigned_CurUser_Date")))
{
obj.AssignedCUDate = dr.GetDateTime(dr.GetOrdinal("Assigned_CurUser_Date"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Destination_Date")))
{
obj.DestinationDate = dr.GetDateTime(dr.GetOrdinal("Destination_Date"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Desc_Last")))
{
obj.DescLast = dr.GetString(dr.GetOrdinal("Desc_Last"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Read_Users_BitIDs1")))
{
obj.ReadUsersBitIds1 = dr.GetInt64(dr.GetOrdinal("Read_Users_BitIDs1"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Read_Users_BitIDs2")))
{
obj.ReadUsersBitIds2 = dr.GetInt64(dr.GetOrdinal("Read_Users_BitIDs2"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Last_Update_Date")))
{
obj.LastUpdate = dr.GetDateTime(dr.GetOrdinal("Last_Update_Date"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Start_Date")))
{
obj.StartDate = dr.GetDateTime(dr.GetOrdinal("Start_Date"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IsAllDay")))
{
obj.IsAllDay = dr.GetBoolean(dr.GetOrdinal("IsAllDay"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Destination_Reminder_Date")))
{
obj.DestReminderDate = dr.GetDateTime(dr.GetOrdinal("Destination_Reminder_Date"));
}
if (!dr.IsDBNull(dr.GetOrdinal("RecurrenceId")))
{
obj.ReccurenceId = dr.GetInt32(dr.GetOrdinal("RecurrenceId"));
}
issuesList.Add("I" + obj.Id.ToString(), obj);
}
sqlConn.Close();
}
}
catch (Exception ex)
{
T.TraceError("Error GetPublicationIndexList CN: {0}, start: {1}, end: {2}, language {3}", CLASS_NAME, start, end, lng);
T.TraceError(ex);
throw ex;
}
return(issuesList);
}
public int IndexPublication(Lucene.Net.Store.Directory indexDir, IssueDocumentDto bean)
{
IndexWriter writer = null;
Document doc = null;
Field field = null;
IndexWriter idxModif = null;
int numIndexed = 0;
try
{
if (IndexWriter.IsLocked(indexDir))
{
IndexWriter.Unlock(indexDir);
}
idxModif = new IndexWriter(indexDir, this.Analizer, false, new IndexWriter.MaxFieldLength(2500000));
doc = new Document();
doc.Add(new Field("issue_id", bean.IssueId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
if (bean.CompanyId != -1)
{
doc.Add(new Field("company_id", bean.CompanyId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.IssueIdPerCompany != -1)
{
doc.Add(new Field("issue_per_company", bean.IssueIdPerCompany.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.PriorityId != -1)
{
doc.Add(new Field("priority_id", bean.PriorityId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.StatusId != -1)
{
doc.Add(new Field("status_id", bean.StatusId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (!string.IsNullOrEmpty(bean.CurrentOwner))
{
doc.Add(new Field("curr_owner", bean.CurrentOwner, Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (!string.IsNullOrEmpty(bean.LastOwner))
{
doc.Add(new Field("last_owner", bean.LastOwner, Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (!string.IsNullOrEmpty(bean.ProjectName))
{
doc.Add(new Field("project_name", bean.ProjectName, Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.AssignedCUDate != DateTime.MinValue)
{
doc.Add(new Field("assigned_cu_date", DateTools.DateToString(bean.AssignedCUDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.DestinationDate != DateTime.MinValue)
{
doc.Add(new Field("destination_date", DateTools.DateToString(bean.DestinationDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (!string.IsNullOrEmpty(bean.DescLast))
{
doc.Add(new Field("desc_last", bean.DescLast, Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.ReadUsersBitIds1 != -1)
{
doc.Add(new Field("read_usr_bit1", bean.ReadUsersBitIds1.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.ReadUsersBitIds2 != -1)
{
doc.Add(new Field("read_usr_bit1", bean.ReadUsersBitIds2.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.LastUpdate != DateTime.MinValue)
{
doc.Add(new Field("last_update", DateTools.DateToString(bean.LastUpdate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.StartDate != DateTime.MinValue)
{
doc.Add(new Field("start_date", DateTools.DateToString(bean.StartDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.IsAllDay)
{
doc.Add(new Field("is_all_day", "1", Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
else
{
doc.Add(new Field("is_all_day", "0", Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.DestReminderDate != DateTime.MinValue)
{
doc.Add(new Field("dest_rem_date", DateTools.DateToString(bean.DestReminderDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.ReccurenceId != -1)
{
doc.Add(new Field("reccurence_id", bean.ReccurenceId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
idxModif.AddDocument(doc);
idxModif.Optimize();
idxModif.Commit();
numIndexed = idxModif.MaxDoc();
idxModif.Dispose();
}
catch
{
if (writer != null)
{
idxModif.Optimize();
idxModif.Commit();
idxModif.Dispose();
}
throw;
}
return(numIndexed);
}
private int Index(IndexWriter writer, int start, int end, String lng)
{
#if DEBUG
T.TraceMessage("Begin indexing from {0} to {1}, language {2}, time: {3}", start, end, lng, DateTime.Now.ToLongTimeString());
#endif
Document doc = null;
Field field = null;
Dictionary <string, IssueDocumentDto> list = new Dictionary <string, IssueDocumentDto>();
try
{
list = new IssuesDao().GetIssuesIndexList(start, end, lng);
foreach (KeyValuePair <string, IssueDocumentDto> pair in list)
{
IssueDocumentDto bean = pair.Value;
doc = new Document();
doc.Add(new Field("issue_id", bean.IssueId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
if (bean.CompanyId != -1)
{
doc.Add(new Field("company_id", bean.CompanyId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.IssueIdPerCompany != -1)
{
doc.Add(new Field("issue_per_company", bean.IssueIdPerCompany.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.PriorityId != -1)
{
doc.Add(new Field("priority_id", bean.PriorityId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.StatusId != -1)
{
doc.Add(new Field("status_id", bean.StatusId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (!string.IsNullOrEmpty(bean.CurrentOwner))
{
doc.Add(new Field("curr_owner", bean.CurrentOwner, Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (!string.IsNullOrEmpty(bean.LastOwner))
{
doc.Add(new Field("last_owner", bean.LastOwner, Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (!string.IsNullOrEmpty(bean.ProjectName))
{
doc.Add(new Field("project_name", bean.ProjectName, Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.AssignedCUDate != DateTime.MinValue)
{
doc.Add(new Field("assigned_cu_date", DateTools.DateToString(bean.AssignedCUDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.DestinationDate != DateTime.MinValue)
{
doc.Add(new Field("destination_date", DateTools.DateToString(bean.DestinationDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (!string.IsNullOrEmpty(bean.DescLast))
{
doc.Add(new Field("desc_last", bean.DescLast, Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.ReadUsersBitIds1 != -1)
{
doc.Add(new Field("read_usr_bit1", bean.ReadUsersBitIds1.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.ReadUsersBitIds2 != -1)
{
doc.Add(new Field("read_usr_bit1", bean.ReadUsersBitIds2.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.LastUpdate != DateTime.MinValue)
{
doc.Add(new Field("last_update", DateTools.DateToString(bean.LastUpdate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.StartDate != DateTime.MinValue)
{
doc.Add(new Field("start_date", DateTools.DateToString(bean.StartDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.IsAllDay)
{
doc.Add(new Field("is_all_day", "1", Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
else
{
doc.Add(new Field("is_all_day", "0", Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
if (bean.DestReminderDate != DateTime.MinValue)
{
doc.Add(new Field("dest_rem_date", DateTools.DateToString(bean.DestReminderDate, DateTools.Resolution.DAY), Lucene.Net.Documents.Field.Store.NO, Lucene.Net.Documents.Field.Index.ANALYZED));
}
if (bean.ReccurenceId != -1)
{
doc.Add(new Field("reccurence_id", bean.ReccurenceId.ToString(), Lucene.Net.Documents.Field.Store.YES, Lucene.Net.Documents.Field.Index.NO));
}
writer.AddDocument(doc);
}
writer.Optimize();
}
catch (Exception ex)
{
T.TraceError("Error Index (start: {1}, end: {2}, language {3}), class {0} ", CLASS_NAME, start, end, lng);
T.TraceError(ex);
throw ex;
}
return(list.Count);
}
