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