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 ConsoleApp1
{
class Program
{
static void Main(string[] args)
{
string insertQuery = "INSERT INTO dbo.vehicle (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();

SqlCommand command = new SqlCommand("SELECT * FROM dbo.Technicians", conn);

using (SqlDataReader reader = command.ExecuteReader())
{
Console.WriteLine("FirstColumntSecond ColumnttThird ColumnttForth Columnt");
while (reader.Read())
{
Console.WriteLine(String.Format("{0} t | {1} t | {2} t | {3}",
reader[0], reader[1], reader[2], reader[3]));
}
}
Console.WriteLine("Data displayed! Now press enter to move to the next section!");
Console.ReadLine();
//Console.Clear();

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)
{
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);
Console.WriteLine(cmd.ExecuteNonQuery());
Console.ReadLine();

}


}
}
}