Esempio n. 1
0
        static void insertHistory(DateTime start, DateTime end, int id)
        {
            WebClient            web     = new WebClient();
            string               jsonStr = web.DownloadString("https://www.nldc.evn.vn/Renewable/Scada/GetScadaNhaMay?start=" + start.ToString("yyyyMMddHHmmss") + "&end=" + end.ToString("yyyyMMddHHmmss") + "&idNhaMay=" + id); //get JSON from Request
            JavaScriptSerializer java    = new JavaScriptSerializer();
            Success              list    = (Success)java.Deserialize(jsonStr, typeof(Success));                                                                                                                                   //convert JSON to List of Model

            if (list.success.Equals("True"))
            {
                foreach (DataModel item in list.data)
                {
                    QuerrySql.insertHistory(Convert.ToDateTime(item.time.Replace('-', '/').Replace('T', ' ')), item.capacity, item.ghi, item.envtemp, id); //Convert 2020-05-19T07:53:00 to 2020/05/19 07:53:00
                }
            }
            else
            {
                Console.WriteLine("Can't get factory's information");
            }
        }