/// <summary> /// 取得搜尋潮汐資訊(金門) /// </summary> /// <param name="local">鄉鎮地區關鍵字 /// "金門縣金城鎮", "金門縣金沙鎮", "金門縣金湖鎮", "金門縣金寧鄉", "金門縣烈嶼鄉", "金門縣烏坵鄉"</param> /// <returns></returns> public ActionResult GetTidalInfo(string local = "金門縣金城鎮") { //Initial Variables ITidal repos = DataFactory.TidalRepository(); return(Content(JsonConvert.SerializeObject(repos.getTidalInfo(local)), "application/json")); }
// GET: TidalCus public ActionResult Index() { //Initial Variables ITidal repos = DataFactory.TidalRepository(); repos.clearTidalTable(); List <string> tList = new List <string> { "金門縣金城鎮", "金門縣金沙鎮", "金門縣金湖鎮", "金門縣金寧鄉", "金門縣烈嶼鄉", "金門縣烏坵鄉" }; //Dictionary<int, string> wtD = new Dictionary<int, string>(); //clear DataTable from DB repos.clearTidalTable(); int rCount = 1; DateTime now = DateTime.Now; //string targetURI = ConfigurationManager.AppSettings["WeatherInfoURL"].ToString() + "/?elementName=Wx,PoP,T,CI&sort=time"; //Add Json Data to SQL for (int i = 0; i <= tList.Count - 1; i++) { string targetURI = ConfigurationManager.AppSettings["TidalInfoURL"].ToString() + "/" + "F-A0021-001?locationName=" + tList[i].ToString() + "&sort=datatime"; var jsonResponse = ""; StringBuilder jsonResultSB = new StringBuilder(); //Get HTTPRequest RESPONSE Custom JSON FORMAT var webRequest = System.Net.WebRequest.Create(targetURI); if (webRequest != null) { webRequest.Method = "GET"; webRequest.Timeout = 900000; webRequest.ContentType = "application/json"; webRequest.Headers.Add("Authorization", "CWB-43A3A823-91B0-4D35-96E1-D66A1B5277AA"); using (System.IO.Stream s = webRequest.GetResponse().GetResponseStream()) { using (System.IO.StreamReader sr = new System.IO.StreamReader(s)) { jsonResponse = sr.ReadToEnd(); JObject o = (JObject)JsonConvert.DeserializeObject(jsonResponse); jsonResultSB.Append(o.SelectToken("records").SelectToken("location[0].validTime").ToString()); } } } //Deserialize var collection = JsonConvert.DeserializeObject <IEnumerable <TidalDeserialize> >(jsonResultSB.ToString()); rCount = repos.addTidalInfo(collection, rCount, tList[i].ToString()); } DateTime afterNow = DateTime.Now; string spendTime = (afterNow - now).ToString(); return(View()); }
public IHttpActionResult GetSearchTidal(string local = "金門縣金城鎮") { //Initial IHttpActionResult responseResult; ITidal repos = DataFactory.TidalRepository(); //序列化撈出來的資料 var jsonSerialize = JsonConvert.SerializeObject(repos.getTidalInfo(local)); //做成JSON字串包裝到最後輸出 StringContent responseMsgString = new StringContent(jsonSerialize, System.Text.Encoding.UTF8, "application/json"); HttpResponseMessage responseMsg = new HttpResponseMessage() { Content = responseMsgString }; responseResult = ResponseMessage(responseMsg); return(responseResult); }