// POST api/values
public void Post([FromBody] Object value)
{
//strings.Add(value);
DataClass001 dataClass001 = System.Text.Json.JsonSerializer.Deserialize <DataClass001>(value.ToString());
string insertNewRowQuery = @"INSERT INTO MyTable (Key,Value) Values ('"
+ dataClass001.Key + "','" + dataClass001.Value + "')";
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=|DataDirectory|/databaseFile2.db3"))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open(); // Open the connection to the database
com.CommandText = insertNewRowQuery; // Set CommandText to our query that will insert a row into the table
com.ExecuteNonQuery(); // Execute the query
/*com.CommandText = "Select * FROM MyTable"; // Select all rows from our database table
*
* using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
* {
* while (reader.Read())
* {
* Console.WriteLine(reader["Key"] + " : " + reader["Value"]); // Display the value of the key and value column for every row
* }
* }*/
conn.Close(); // Close the connection to the database
}
}
}
protected override void OnStart(string[] args)
{
//Create db
WindowsServiceMentorshipTest.Database.InitializeDB.CreateDBTable();
//Read from db
string selectQuery = @"SELECT * FROM MyTable";
using (System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection("data source=|DataDirectory|/databaseFile1.db3"))
{
using (System.Data.SQLite.SQLiteCommand com = new System.Data.SQLite.SQLiteCommand(conn))
{
conn.Open(); // Open the connection to the database
com.CommandText = selectQuery; // Set CommandText to our query that will select all rows from the table
com.ExecuteNonQuery(); // Execute the query
using (System.Data.SQLite.SQLiteDataReader reader = com.ExecuteReader())
{
//string postJSON;
DataClass001 dataClass001 = new DataClass001();
while (reader.Read())
{
dataClass001.Key = reader["Key"].ToString();
dataClass001.Value = reader["Value"].ToString();
//postJSON = JsonSerializer.Serialize(dataClass001);
System.IO.File.AppendAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\Result_Post_Keys.txt", dataClass001.Key);
System.IO.File.AppendAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\Result_Post_Values.txt", dataClass001.Value);
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://webapi.local/api/");
//HTTP POST
//var postTask = client.PostAsJsonAsync<DataClass001>("values", dataClass001);
var postTask = client.PostAsJsonAsync <string>("values", @"{" + "\"key\":\"" + dataClass001.Key + "\"," + "\"value\":\"" + dataClass001.Value + "\"}");
postTask.Wait();
var result = postTask.Result;
if (result.IsSuccessStatusCode)
{
//return RedirectToAction("Index");
System.IO.File.AppendAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\Result_Post.txt", "Success" + result.StatusCode);
}
else
{
System.IO.File.AppendAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\Result_Post.txt", "Fail" + result.StatusCode);
}
}
}
using (var client = new HttpClient())
{
client.BaseAddress = new Uri("http://webapi.local/api/");
//HTTP GET
var responseTask = client.GetAsync("values");
responseTask.Wait();
var result = responseTask.Result;
if (result.IsSuccessStatusCode)
{
System.IO.File.WriteAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\Result.txt", "Success");
var readTask = result.Content.ReadAsAsync <IList <string> >();
readTask.Wait();
IList <string> results = readTask.Result;
foreach (var s in results)
{
//Console.WriteLine(d);
System.IO.File.AppendAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\ResultBody.txt", s);
}
System.IO.File.AppendAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\ResultBody.txt", Environment.NewLine);
}
else
{
System.IO.File.WriteAllText(@"C:\Users\Isaiah\Documents\Mentorship Result Files\Result.txt", "FAIL");
}
}
conn.Close(); // Close the connection to the database
}
}
WriteToFile("Service is started at " + DateTime.Now);
timer.Elapsed += new ElapsedEventHandler(OnElapsedTime);
timer.Interval = 5000; //number in milisecinds
timer.Enabled = true;
}
}
