public JsonResult saveData(string price_data, int count, string coin) { dynamic stuff = JsonConvert.DeserializeObject(price_data); string[] Users = stuff[0].ToObject <string[]>(); // int ac = 0; do { // string subArray = stuff[1]; string[] SubArrayData = stuff[count].ToObject <string[]>(); string price = SubArrayData[1]; decimal price2 = Convert.ToDecimal(price); string date1 = SubArrayData[0]; double epoch = Convert.ToDouble(date1); DateTime datex = new DateTime(1970, 1, 1).AddSeconds(epoch / 1000); //DateTime date4 = ConvertUnixTimeStamp(date1); // string date2 = Regex.Replace(date1, @"[^\d\s\.:]", string.Empty); // DateTime date3 = DateTime.ParseExact(date1, "MM.dd.yyyy HH:mm:ss", CultureInfo.InvariantCulture); //DateTime time = DateTime.ParseExact(SubArrayData[0], "dd/MM/yyyy", null); // string data1 = subArray[0]; //Decimal price = stuff[ac].price; //DateTime time = stuff[ac].price_timestamp; //decimal? rank = stuff[ac].rank; //decimal? rankdelta = stuff[ac].rank_delta; //decimal marketcap = stuff[ac].market_cap; //string symbol = stuff[ac].symbol; //textBox1.AppendText(coinname + Environment.NewLine); //textBox1.AppendText(price + Environment.NewLine); //textBox1.AppendText(time + Environment.NewLine); using (var context = new db61a6afb29dc84f4597e3a2b500ebed20Entities()) { var t = new PriceData { Coin = coin, Price = price2, //Rank = rank, //Rankdelta = rankdelta, //Marketcap = marketcap, //Symbol = symbol, Timestamp = datex }; context.PriceDatas.Add(t); context.SaveChanges(); } count--; } while (count > 0); return(Json(new { status = "saved" }, JsonRequestBehavior.AllowGet)); }
public JsonResult saveChangeData(string time_start, string time_end, decimal up, decimal down, int duration, string coin, decimal profit) { DateTime start_epoch = new DateTime(1970, 1, 1).AddSeconds(Convert.ToDouble(time_start) / 1000); DateTime end_epoch = new DateTime(1970, 1, 1).AddSeconds(Convert.ToDouble(time_end) / 1000); string uniqueID = coin + time_start + time_end + up.ToString() + down.ToString() + duration.ToString(); string status; var dataContext = new db61a6afb29dc84f4597e3a2b500ebed20Entities(); var data = from y in dataContext.PriceChanges where y.UniqueID == uniqueID select y; int ct = data.Count(); if (ct == 0) { using (var context = new db61a6afb29dc84f4597e3a2b500ebed20Entities()) { var t = new PriceChanx { Coin = coin, Time_start = start_epoch, Time_end = end_epoch, Up = up, Down = down, Duration = duration, UniqueID = uniqueID, profit = profit }; context.PriceChanges.Add(t); context.SaveChanges(); status = "Saved: " + duration; } } else { status = "Not saved: " + duration; } return(Json(new { status = status }, JsonRequestBehavior.AllowGet)); }