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); } }