internal async Task <stockData> Read(string date) { try { string jsonString = await stockAPI(date); stockData stockData = new stockData(); //JSON反序列化裝入刻好的物件,傳入controller stockData = JsonConvert.DeserializeObject <stockData>(jsonString); data data = new data(); //清除data舊的日期資料 Delete(); for (int i = 0; i < stockData.data9.Count(); i++) { data.證券代號 = stockData.data9[i][0]; data.證券名稱 = stockData.data9[i][1]; data.成交股數 = stockData.data9[i][2]; data.成交筆數 = stockData.data9[i][3]; data.成交金額 = stockData.data9[i][4]; data.開盤價 = stockData.data9[i][5]; data.最高價 = stockData.data9[i][6]; data.最低價 = stockData.data9[i][7]; data.收盤價 = stockData.data9[i][8]; if (stockData.data9[i][9].Contains("+")) { stockData.data9[i][9] = stockData.data9[i][9].Replace("<p style= color:red>+</p>", "+"); } else if (stockData.data9[i][9].Contains("-")) { stockData.data9[i][9] = stockData.data9[i][9].Replace("<p style= color:green>-</p>", "-"); } else { stockData.data9[i][9] = stockData.data9[i][9].Replace("<p> </p>", "0"); } data.漲跌正or負 = stockData.data9[i][9]; data.漲跌價差 = stockData.data9[i][10]; //寫入DB create(data); } //清除datasave舊的資料 //datasave datasave = new datasave(); //Delete(datasave); return(stockData); } catch (Exception ex) { Console.WriteLine(ex.Message); return(null); } }
public async Task <ActionResult> DeleteConfirmed(string id) { stockData stockData = await db.stockDatas.FindAsync(id); db.stockDatas.Remove(stockData); await db.SaveChangesAsync(); return(RedirectToAction("Index")); }
public async Task <ActionResult> Edit([Bind(Include = "Symbol,LastPrice,Change,PChg,Currency,MarketTime,VolumeAvg")] stockData stockData) { if (ModelState.IsValid) { db.Entry(stockData).State = EntityState.Modified; await db.SaveChangesAsync(); return(RedirectToAction("Index")); } return(View(stockData)); }
// GET: stockData/Delete/5 public async Task <ActionResult> Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } stockData stockData = await db.stockDatas.FindAsync(id); if (stockData == null) { return(HttpNotFound()); } return(View(stockData)); }
public static void retrievePriceData(string[] symbols, DateTime[] earningsDate, DateTime[] endDate, string[] sectors, string[] surprise) { int i = 0; stockData stockDataObj = new stockData(); while (i < symbols.Length) { var awaiter = stockDataObj.getStockData(symbols[i], earningsDate[i], endDate[i], sectors[i], surprise[i]); if (awaiter.Result == 1) { i++; } } stockDataObj.genChart(); return; }