/// <summary> /// Get Total Publication by Language /// </summary> /// <param name="lng"></param> /// <returns></returns> public int GetTotalPublicationByLanguage(string lng) { int result = 2010; try { using (SqlConnection sqlConn = new SqlConnection(ConfigurationController.MainConnectionString)) { SqlCommand command = new SqlCommand("SW_BP_Issues_Count", sqlConn); command.CommandType = System.Data.CommandType.StoredProcedure; sqlConn.Open(); result = Int32.Parse(command.ExecuteScalar().ToString()); sqlConn.Close(); } } catch (Exception ex) { T.TraceError("Error GetTotalPublicationByLanguage", CLASS_NAME); T.TraceError(ex); throw ex; } return(result); }
public bool UpdateIndex(int taskId) { if (ConfigurationController.RunSpanishIndexing) { T.TraceMessage("Updating ES index..."); LuceneController.UpdateIndex("ES"); T.TraceMessage(" done updating ES index"); T.TraceMessage("Moving ES index..."); if (!string.IsNullOrEmpty(ConfigurationController.IndexRootPath)) { LuceneController.MoveIndex(false, "ES", 1); } T.TraceMessage(" done moving ES index"); } if (ConfigurationController.RunEnglishIndexing) { T.TraceMessage("Updating EN index..."); LuceneController.UpdateIndex("EN"); T.TraceMessage(" done updating EN index"); T.TraceMessage("Moving EN index..."); if (!string.IsNullOrEmpty(ConfigurationController.IndexRootPath)) { LuceneController.MoveIndex(false, "EN", 1); } T.TraceMessage(" done moving EN index"); } if (ConfigurationController.RunHebrewIndex) { T.TraceMessage("Updating HE index..."); LuceneController.UpdateIndex("HE"); T.TraceMessage(" done updating HE index"); T.TraceMessage("Moving HE index..."); if (!string.IsNullOrEmpty(ConfigurationController.IndexRootPath)) { LuceneController.MoveIndex(false, "HE", 1); } T.TraceMessage(" done moving HE index"); } return(true); }
/// <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); }