public static SqlCommand GetInsertRawDataQuery(RawDataEntry entry, SqlConnection sqlConnection) { String rawObject = (entry.RawContent == null) ? "" : JsonConvert.SerializeObject(entry.RawContent); String command = @"INSERT INTO RAWDATATABLE (source,author,timestamp,content,rawcontent) VALUES (@source,@author,@timestamp,@content,@rawcontent)"; SqlCommand sqlCommand = new SqlCommand(command, sqlConnection); sqlCommand.Parameters.AddWithValue("@source", entry.Source); sqlCommand.Parameters.AddWithValue("@author", entry.Author); sqlCommand.Parameters.AddWithValue("@timestamp", entry.TimeStamp); sqlCommand.Parameters.AddWithValue("@content", entry.Content); sqlCommand.Parameters.AddWithValue("@rawcontent", rawObject); return(sqlCommand); }
public static void RecordRawData(RawDataEntry entry) { try { if (SqlConnection.State != System.Data.ConnectionState.Open) { SqlConnection.Open(); } SqlCommand sqlCommand = DBQueries.GetInsertRawDataQuery(entry, SqlConnection); sqlCommand.ExecuteNonQuery(); } catch (Exception e) { Console.WriteLine("Committing to SQL failed for RecordRawData with exception: {0}", e); } }
public static IEnumerable <RawDataEntry> GetRawDataForAnalyzer(String AnalyzerId) { List <RawDataEntry> result = new List <RawDataEntry>(); try { if (SqlConnection.State != System.Data.ConnectionState.Open) { SqlConnection.Open(); } SqlCommand sqlCommand = DBQueries.GetAnalyzerMarkerQuery(AnalyzerId, SqlConnection); String id = sqlCommand.ExecuteScalar().ToString(); sqlCommand = DBQueries.GetRetrieveRawRecordsForProcessingQuery(id, SqlConnection); using (SqlDataReader reader = sqlCommand.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { RawDataEntry entry = new RawDataEntry { Id = reader.GetInt32(0).ToString(), Source = reader.GetString(1), Author = reader.GetString(2), TimeStamp = reader.GetDateTime(3), Content = reader.GetString(4) }; result.Add(entry); } } } } catch (Exception e) { Console.WriteLine("Committing to SQL failed for GetRawDataForAnalyzer with exception: {0}", e); } return(result); }