public static List <MachineTag> getAll()
{
List <MachineTag> listMachineTag = new List <MachineTag>();
SqlConnection conn = ConnectionBuilder.getConnection();
conn.Open();
string sql = "SELECT tag_name FROM Tag";
SqlCommand sqlCom = new SqlCommand(sql, conn);
//sqlCom.ExecuteReader();
using (SqlDataReader reader = sqlCom.ExecuteReader())
{
while (reader.Read())
{
MachineTag mt = new MachineTag();
//mt.Id = int.Parse(reader["id"].ToString());
mt.TagName = reader["tag_name"].ToString();
listMachineTag.Add(mt);
}
//users.Add(reader.GetInt32(0), reader.GetString(1));
//ViewData["Message_V"] = reader["tag_name"].ToString();
//System.Diagnostics.Debug.WriteLine(reader["tag_name"].ToString());
}
//sqlCom.ExecuteNonQuery();
conn.Close();
return(listMachineTag);
}
public static JObject getAllMachineTagValue(String url)
{
List <MachineTag> listMachineTag = MachineTag.getAll();
//To get JsonObject need to call json string from URL first and then Parse it into object type
WebClient webClient = new WebClient();
DupeNVC dnvc = new DupeNVC("ids");
foreach (MachineTag matchineTag in listMachineTag)
{
dnvc.Add("ids", matchineTag.TagName);
//Debug.WriteLine(matchineTag.TagName);
//webClient.QueryString.Add("ids", matchineTag.TagName);
}
webClient.QueryString = dnvc;
//Debug.WriteLine("Hellooooo");
//Debug.WriteLine(dnvc.ToString());
string respones = webClient.DownloadString(url); // get json string from URL
JObject jsonObject = JObject.Parse(respones); //Parse json string to jsonObject
// JValue id = (JValue)jsonObject["readResults"][0]["id"];
return(jsonObject); // return json object for use in other method
}
