public ActionResult sysConfig() { using (var db = new WebStockEntities()) { var sysconfig = db.sysConfig.FirstOrDefault(); return(View(sysconfig)); } }
// GET: GetStockData public ActionResult Index() { using (var db = new WebStockEntities()) { var lastUpdate = db.sysConfig.FirstOrDefault(); string stockDate = lastUpdate.stockUpdate.ToString("yyyy-MM-dd"); ViewBag.stockLastUpdate = $"Stock Last Update {stockDate}"; string otcDate = lastUpdate.otcUpdate.ToString("yyyy-MM-dd"); ViewBag.otcLastUpdate = $"Otc Last Update {otcDate}"; string nowDate = lastUpdate.nowDate.ToString("yyyy-MM-dd"); ViewBag.nowDate = $"Now Last Update {nowDate}"; string avgStartDate = lastUpdate.avgStartDate.ToString("yyyy-MM-dd"); string avgEndDate = lastUpdate.avgEndDate.ToString("yyyy-MM-dd"); ViewBag.avgDate = $"{avgStartDate} ~ {avgEndDate}"; } return(View()); }