public async Task <IActionResult> Edit(long id, [Bind("id,day,code,name,tclose,high,low,topen,lclose,chg,pchg,turnover,voturnover,vaturnover,tcap,mcap")] DayTransact dayTransact)
        {
            if (id != dayTransact.id)
            {
                return(NotFound());
            }

            if (ModelState.IsValid)
            {
                try
                {
                    _context.Update(dayTransact);
                    await _context.SaveChangesAsync();
                }
                catch (DbUpdateConcurrencyException)
                {
                    if (!DayTransactExists(dayTransact.id))
                    {
                        return(NotFound());
                    }
                    else
                    {
                        throw;
                    }
                }
                return(RedirectToAction(nameof(Index)));
            }
            return(View(dayTransact));
        }
        public async Task <IActionResult> Create([Bind("id,day,code,name,tclose,high,low,topen,lclose,chg,pchg,turnover,voturnover,vaturnover,tcap,mcap")] DayTransact dayTransact)
        {
            if (ModelState.IsValid)
            {
                _context.Add(dayTransact);
                await _context.SaveChangesAsync();

                return(RedirectToAction(nameof(Index)));
            }
            return(View(dayTransact));
        }
        public void download(String originalCode, String name, String fromDate, String toDate)
        {
            try
            {
                var _http = new HttpHelper(getReqUrl(originalCode, fromDate, toDate));

                String rawText = _http.CreateGetHttpResponse();

                dynamic obj = null;

                try
                {
                    String json = rawText.Substring(22, rawText.Length - 25);
                    obj = JsonConvert.DeserializeObject <dynamic>(json);
                }
                catch
                { }

                if (obj != null && obj.hq != null)
                {
                    if (dtList == null)
                    {
                        dtList = new List <DayTransact>();
                    }
                    foreach (var item in obj.hq)
                    {
                        DayTransact dt = new DayTransact();
                        dt.setCode(originalCode);
                        dt.setName(name);
                        dt.setDay(item[0].ToString());
                        dt.setTopen(Convert.ToDouble(item[1]));
                        dt.setTclose(Convert.ToDouble(item[2]));
                        dt.setChg(Convert.ToDouble(item[3]));
                        dt.setPchg(Convert.ToDouble(item[4].ToString().Replace("%", "")));
                        dt.setLow(Convert.ToDouble(item[5]));
                        dt.setHigh(Convert.ToDouble(item[6]));
                        dt.setVoturnover(Convert.ToInt64(item[7]));
                        dt.setVaturnover(Convert.ToDouble(item[8]));
                        dt.setTurnover(Convert.ToDouble(item[9].ToString().Replace("%", "")));
                        dtList.Add(dt);
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }