public static List <OutputFileMonitorResult> GetMonitorResults(string runId, int offset, int numResults) { var results = new List <OutputFileMonitorResult>(); using (var cmd = new SQLiteCommand(GET_MONITOR_RESULTS, Connection, Transaction)) { cmd.Parameters.AddWithValue("@run_id", runId); cmd.Parameters.AddWithValue("@offset", offset); cmd.Parameters.AddWithValue("@limit", numResults); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var obj = new OutputFileMonitorResult() { RowKey = reader["row_key"].ToString(), Timestamp = reader["timestamp"].ToString(), Path = reader["path"].ToString(), OldPath = reader["old_path"].ToString(), Name = reader["path"].ToString(), OldName = reader["old_path"].ToString(), ChangeType = (CHANGE_TYPE)int.Parse(reader["change_type"].ToString(), CultureInfo.InvariantCulture), }; results.Add(obj); } } } return(results); }
public ActionResult GetMonitorResults(string RunId, int ResultType, int Offset, int NumResults) { var results = new List <OutputFileMonitorResult>(); using (var cmd = new SqliteCommand(GET_MONITOR_RESULTS, DatabaseManager.Connection, DatabaseManager.Transaction)) { cmd.Parameters.AddWithValue("@run_id", RunId); cmd.Parameters.AddWithValue("@offset", Offset); cmd.Parameters.AddWithValue("@limit", NumResults); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var obj = new OutputFileMonitorResult() { RowKey = reader["row_key"].ToString(), Timestamp = reader["timestamp"].ToString(), Path = reader["path"].ToString(), OldPath = reader["old_path"].ToString(), Name = reader["path"].ToString(), OldName = reader["old_path"].ToString(), ChangeType = (CHANGE_TYPE)int.Parse(reader["change_type"].ToString()), }; results.Add(obj); } } } Dictionary <string, object> output = new Dictionary <string, object>(); var result_count = 0; using (var cmd = new SqliteCommand(GET_RESULT_COUNT_MONITORED, DatabaseManager.Connection, DatabaseManager.Transaction)) { cmd.Parameters.AddWithValue("@run_id", RunId); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { result_count = int.Parse(reader["count(*)"].ToString()); } } output["Results"] = results; output["TotalCount"] = result_count; output["Offset"] = Offset; output["Requested"] = NumResults; output["Actual"] = results.Count; } return(Json(JsonConvert.SerializeObject(output))); }
public static List <OutputFileMonitorResult> GetMonitorResults(string runId, int offset, int numResults) { var results = new List <OutputFileMonitorResult>(); if (MainConnection != null) { using (var cmd = new SqliteCommand(GET_MONITOR_RESULTS, MainConnection.Connection, MainConnection.Transaction)) { cmd.Parameters.AddWithValue("@run_id", runId); cmd.Parameters.AddWithValue("@offset", offset); cmd.Parameters.AddWithValue("@limit", numResults); using (var reader = cmd.ExecuteReader()) { while (reader.Read()) { var path = reader["path"].ToString(); if (!string.IsNullOrEmpty(path)) { var obj = new OutputFileMonitorResult(path) { RowKey = reader["row_key"].ToString(), Timestamp = reader["timestamp"].ToString(), OldPath = reader["old_path"].ToString(), Name = reader["path"].ToString(), OldName = reader["old_path"].ToString(), ChangeType = (CHANGE_TYPE)int.Parse(reader["change_type"].ToString() ?? "Invalid", CultureInfo.InvariantCulture), }; results.Add(obj); } } } } } else { Log.Debug("Failed to GetMonitorResults. MainConnection was null."); } return(results); }