Example #1
0
 public bool GetData()
 {
     try
     {
         capacity_MAX = 0;
         DataTable dt = SoLieuDAO.GetSoLieu(DateTime.Now.AddDays(-1), DateTime.Now);
         if (dt.Rows.Count == 0)
         {
             Console.WriteLine("No data in DB !!!");
             return(false);
         }
         foreach (DataRow rd in dt.Rows)
         {
             double cap = double.Parse(rd["Capacity"].ToString());
             list.Add(new Data(rd["Time"].ToString(), cap,
                               double.Parse(rd["GHI"].ToString()), double.Parse(rd["Temperature"].ToString())
                               ));
             if (capacity_MAX < cap)
             {
                 capacity_MAX = cap;
             }
         }
     }
     catch (Exception e)
     {
         Console.WriteLine("Get Data From DB : " + e.Message);
         return(false);
     }
     return(true);
 }
        public void GetData()
        {
            try
            {
                DateTime       start  = DateTime.Now;
                HttpWebRequest WebReq = (HttpWebRequest)WebRequest.Create
                                            (string.Format("https://www.nldc.evn.vn/Renewable/Scada/GetScadaNhaMay?start=" + start.AddDays(-1).ToString("yyyyMMddHHmmss") + "&end=" + start.ToString("yyyyMMddHHmmss") + "&idNhaMay=362"));

                WebReq.Method = "GET";
                HttpWebResponse WebResp = (HttpWebResponse)WebReq.GetResponse();

                Stream       json     = WebResp.GetResponseStream();
                StreamReader json_str = new StreamReader(json);
                string       str      = json_str.ReadToEnd();

                JavaScriptSerializer jss = new JavaScriptSerializer();
                SoLieu obj = jss.Deserialize <SoLieu>(str);
                Console.WriteLine("sucess : " + obj.success + " " + DateTime.Now);

                int number = obj.data.Count;

                //set capacity_Max
                double capacity_MAX = obj.data[0].capacity / 0.9;

                DateTime TimeMax = SoLieuDAO.GetTimeMax();
                for (int i = 0; i < obj.data.Count; i++)
                {
                    if (capacity_MAX < obj.data[i].capacity / 0.9)
                    {
                        capacity_MAX = obj.data[i].capacity / 0.9;
                    }
                    // Console.WriteLine(obj.data[i]);
                    DataTable dt = SoLieuDAO.GetDuLieuByTime(DateTime.Parse(obj.data[i].time));
                    if (dt.Rows.Count == 0)
                    {
                        SoLieuDAO.InsertHistorialData(obj.data[i]);
                        Console.WriteLine("Insert Du Lieu : " + obj.data[i].ToString());
                    }
                }

                Console.WriteLine("message : " + obj.message);
            }
            catch (Exception e)
            {
                Console.WriteLine("Get Data : " + e.Message);
            }
        }