public void RunTask() { try { // Lets download the JSON file string jsonString; using (System.Net.WebClient w = new System.Net.WebClient()) { jsonString = w.DownloadString(ConfigurationManager.AppSettings["WazeDownloadURL"]); } Console.WriteLine(jsonString); var welcome = WazeDownload.FromJson(jsonString); var connectionString = ConfigurationManager.ConnectionStrings["WazeDownloader.WazeDownloadContext"].ConnectionString; using (SqlConnection connection = new SqlConnection(connectionString)) { string query = "INSERT INTO dbo.WazeDownloadsRaw (FullText) VALUES (@title)"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("@title", jsonString); connection.Open(); int result = command.ExecuteNonQuery(); // Check Error if (result < 0) { Console.WriteLine("Error inserting data into Database!"); } } } using (var db = new WazeDownloadContext()) { db.WazeDownloads.Add(welcome); db.SaveChanges(); } } catch { } }
public static string ToJson(this WazeDownload self) => JsonConvert.SerializeObject(self, WazeDownloader.Converter.Settings);