public void AddPulse(Pulse p) { string query = "INSERT INTO Pulses ('PulseId', 'Name', 'Description', 'TLP', 'Created', 'Modified')" + "VALUES (@pulseId, @name, @description, @tlp, @created, @modified)"; OpenConnection(); SQLiteCommand command = new SQLiteCommand(query, connection); command.Parameters.AddWithValue("@pulseId", p.Id); command.Parameters.AddWithValue("@name", p.Name); command.Parameters.AddWithValue("@description", p.Description); command.Parameters.AddWithValue("@tlp", p.Tlp); command.Parameters.AddWithValue("@created", p.Created.ToString()); command.Parameters.AddWithValue("@modified", p.Modified.ToString()); var result = command.ExecuteNonQuery(); if (p.Indicators != null) { foreach (var i in p.Indicators) { AddIndicator(i); } } CloseConnection(); }
public void GetPulseById(string id) { parameters = new Dictionary <string, object>(); parameters.Add("id", id); HttpResponseMessage <string> responsePulse = restTemplate.Exchange <string>("/api/v1/pulses/{id}", HttpMethod.GET, requestEntity, parameters); if (responsePulse.StatusCode == HttpStatusCode.OK) { Pulse pulse = JsonSerializer.Deserialize <Pulse>(responsePulse.Body); database.AddPulse(pulse); File.WriteAllText(string.Format("./pulse-{0}.json", pulse.Id), JsonSerializer.Serialize(pulse, serializerOptions)); Console.WriteLine(pulse); return; } Console.WriteLine("Response status: {0}", responsePulse.StatusCode.ToString()); }