public JsonResult PData(string coin, int days, DateTime from_dt, DateTime to_dt)
{
var dataContext = new db61a6afb29dc84f4597e3a2b500ebed20Entities();
var dt = DateTime.Now.AddDays(-days);
//from_dt = Convert.ToDateTime("10/02/2021");
// var coinList;
List <Area> coinList = new List <Area>();
// IList<PriceData> cl = new IList<PriceData>;
var data = (from y in dataContext.PriceDatas
where y.Timestamp > from_dt
where y.Timestamp < to_dt
where y.Coin == coin
orderby y.Timestamp ascending
select new
{
y.Price,
y.Timestamp,
y.MA100,
y.MA50
});
//dataContext.PriceChanges
// .Where(c => c.Coin == coin).Average(r => r.Down);
return(Json(new { data_out = data }, JsonRequestBehavior.AllowGet));
//graph needs, [[time,price],[time,price]]
}
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 ActionResult Index()
{
var dataContext = new db61a6afb29dc84f4597e3a2b500ebed20Entities();
var data = from y in dataContext.PriceDatas
orderby y.Timestamp descending
select y;
return(View("Index", data));
}
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));
}
public JsonResult PLata(int days)
{
var dataContext = new db61a6afb29dc84f4597e3a2b500ebed20Entities();
var dt = DateTime.Now.AddDays(-days);
var data = (from y in dataContext.Orders
where y.Timestamp > dt
orderby y.Timestamp descending
select new
{
y.Price,
y.Timestamp,
y.PLpct
});
//dataContext.PriceChanges
// .Where(c => c.Coin == coin).Average(r => r.Down);
return(Json(new { data_out = data }, JsonRequestBehavior.AllowGet));
//graph needs, [[time,price],[time,price]]
}