/// <summary> /// Summarizes sets of SearchInfo instances that were created during the specified datetime range. /// </summary> /// <param name="startDay">The start day.</param> /// <param name="endDay">The end day.</param> /// <returns>A <see cref="IndexLibrary.Analysis.SearchInfoSummary"/> that represents a summary of the data in that timespan</returns> public static SearchInfoSummary SummarizeSearchData(DateTime startDay, DateTime endDay) { if (startDay > endDay) { throw new ArgumentOutOfRangeException("startDay", "startDay cannot be newer than endDay"); } DataTable table; SearchInfoSummary summary = new SearchInfoSummary(); Action <DataTable> action = delegate(DataTable inputTable) { if (inputTable != null && inputTable.Columns.Contains("IndexName") && inputTable.Columns.Contains("Query") && inputTable.Columns.Contains("SearchMethodType") && inputTable.Columns.Contains("TotalResults") && inputTable.Columns.Contains("Canceled") && inputTable.Columns.Contains("CreateTime")) { int count = inputTable.Rows.Count; for (int j = 0; j < count; j++) { DataRow row = inputTable.Rows[j]; try { summary.AddSearchInfo(new SearchInfo(row["IndexName"].ToString(), row["Query"].ToString(), (SearchMethodType)Enum.Parse(typeof(SearchMethodType), row["SearchMethodType"].ToString()), int.Parse(row["TotalResults"].ToString()), bool.Parse(row["Canceled"].ToString()), DateTime.Parse(row["CreateTime"].ToString()))); } catch (Exception) { } } } }; if (startDay.Date < endDay.Date) { table = ReadDay(startDay, TableName.SearchAnalysis, true); action(table); startDay = startDay.Date.AddDays(1.0); } while (startDay < endDay) { table = ReadDay(startDay, TableName.SearchAnalysis, true); action(table); startDay = startDay.AddDays(1.0); } if (startDay.Date == endDay.Date) { table = ReadDay(endDay, TableName.SearchAnalysis, false); action(table); endDay = new DateTime(endDay.Year, endDay.Month, endDay.Day, 23, 59, 59); } return(summary); }
/// <summary> /// Summarizes sets of SearchInfo instances that were created during the specified datetime range. /// </summary> /// <param name="startDay">The start day.</param> /// <param name="endDay">The end day.</param> /// <returns>A <see cref="IndexLibrary.Analysis.SearchInfoSummary"/> that represents a summary of the data in that timespan</returns> public static SearchInfoSummary SummarizeSearchData(DateTime startDay, DateTime endDay) { if (startDay > endDay) throw new ArgumentOutOfRangeException("startDay", "startDay cannot be newer than endDay"); DataTable table; SearchInfoSummary summary = new SearchInfoSummary(); Action<DataTable> action = delegate(DataTable inputTable) { if (inputTable != null && inputTable.Columns.Contains("IndexName") && inputTable.Columns.Contains("Query") && inputTable.Columns.Contains("SearchMethodType") && inputTable.Columns.Contains("TotalResults") && inputTable.Columns.Contains("Canceled") && inputTable.Columns.Contains("CreateTime")) { int count = inputTable.Rows.Count; for (int j = 0; j < count; j++) { DataRow row = inputTable.Rows[j]; try { summary.AddSearchInfo(new SearchInfo(row["IndexName"].ToString(), row["Query"].ToString(), (SearchMethodType)Enum.Parse(typeof(SearchMethodType), row["SearchMethodType"].ToString()), int.Parse(row["TotalResults"].ToString()), bool.Parse(row["Canceled"].ToString()), DateTime.Parse(row["CreateTime"].ToString()))); } catch (Exception) { } } } }; if (startDay.Date < endDay.Date) { table = ReadDay(startDay, TableName.SearchAnalysis, true); action(table); startDay = startDay.Date.AddDays(1.0); } while (startDay < endDay) { table = ReadDay(startDay, TableName.SearchAnalysis, true); action(table); startDay = startDay.AddDays(1.0); } if (startDay.Date == endDay.Date) { table = ReadDay(endDay, TableName.SearchAnalysis, false); action(table); endDay = new DateTime(endDay.Year, endDay.Month, endDay.Day, 23, 59, 59); } return summary; }