Notes

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.IO;
using System.Linq;
using System.Net;
using System.Text;
using System.Threading.Tasks;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;

namespace ConsoleApp3
{
class Program
{
static void Main(string[] args)
{
string insertQuery = "INSERT INTO dbo.vehicle2 (UnitID, Updated, Description, lat, lon, Event, Speed, Direction, Engine, Killed, Distance, Duration , Odometer, Battery, GpsStatus, TankVolume, TankReserve, CheckFuel, Level, SymbolType, Number, SmsCount, IsApproved) VALUES ";
string html = string.Empty;
string url = @"http://210.48.155.248/PrxAndroid/PrxAndroid.svc/GetMobiles/UEMEdgenta";

using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = "Server=tcp:urbaniseserver.database.windows.net,1433;Initial Catalog=ubndb;Persist Security Info=False;User ID=ubnadmin;Password=UrbaniseEdgenta123!;MultipleActiveResultSets=True;Encrypt=True;TrustServerCertificate=False;Connection Timeout=2000;";
conn.Open();

HttpWebRequest request = (HttpWebRequest)WebRequest.Create(url);
request.AutomaticDecompression = DecompressionMethods.GZip;

using (HttpWebResponse response = (HttpWebResponse)request.GetResponse())
using (Stream stream = response.GetResponseStream())
using (StreamReader reader = new StreamReader(stream))
{
html = reader.ReadToEnd();
}


dynamic json = JsonConvert.DeserializeObject(html);

int counter = 0;
// pakai ni kalau nak pakai parameter untuk insert value
/* foreach(var item in json)
{
Console.WriteLine(item);
insertQuery += "(";
foreach (var keyValue in item)
{
insertQuery += "@" + keyValue["Key"] + counter + ",";
cmd.Parameters.AddWithValue("@" + keyValue["Key"] + counter, keyValue["Value"]);
Console.WriteLine(keyValue["Value"]);
}
insertQuery = insertQuery.Remove(insertQuery.Length - 1);
insertQuery += "),";
counter += 1;
}*/


//pakai ni kalau tak nak pakai parameter
foreach (var item in json)
{
insertQuery += "(";
foreach (var keyValue in item)
{
if (keyValue["Key"].Equals("Updated"))
{

insertQuery += "'" + DateTime.ParseExact(keyValue["Value"], "dd/MM/yyyy HH:mm:ss,fff", System.Globalization.CultureInfo.InvariantCulture

) + "',";
}
else
insertQuery += "'" + keyValue["Value"] + "',";

}
insertQuery = insertQuery.Remove(insertQuery.Length - 1);
insertQuery += "),";
counter += 1;
}

insertQuery = insertQuery.Remove(insertQuery.Length - 1);
SqlCommand cmd = new SqlCommand(insertQuery, conn);
Console.WriteLine(insertQuery);
cmd.ExecuteNonQuery();
Console.ReadLine();

}


}
}
}