/// <summary> /// Get Chart object by account, instrument and timeframe (single chart) /// </summary> /// <param name="accountID"></param> /// <param name="insID"></param> /// <param name="tf"></param> /// <returns></returns> public CommonData.Chart GetChart(int accountID, int insID, Timeframes tf) { return(null); //????????????????????? DbChart chart = null; using (var db = new DaContext(_options)) { chart = db.Chart.FirstOrDefault(r => r.AccountID == accountID && r.InsID == insID && r.Tf == (byte)tf); if (chart == null) { return(null); } } var xd = new XDocument(); if (!string.IsNullOrEmpty(chart.Data)) { xd = XDocument.Parse(chart.Data); } return(new CommonData.Chart() { ChartID = chart.ChartID, InsID = chart.InsID, Tf = (Timeframes)chart.Tf, AccountID = chart.AccountID, XmlData = xd }); }
/// <summary> /// Get Chart object by Id /// </summary> /// <param name="chartId"></param> /// <returns></returns> public CommonData.Chart GetChartByID(int chartId) { DbChart chart = null; using (var db = new DaContext(_options)) { chart = db.Chart.Find(chartId); if (chart == null) { return(null); } } var xd = new XDocument(); if (!string.IsNullOrEmpty(chart.Data)) { xd = XDocument.Parse(chart.Data); } return(new CommonData.Chart() { ChartID = chart.ChartID, InsID = chart.InsID, Tf = (Timeframes)chart.Tf, AccountID = chart.AccountID, XmlData = xd }); }
/// <summary> /// Create new chart /// </summary> /// <param name="accountID">Account Id</param> /// <param name="insID">Instrum Id</param> /// <param name="tf">Timeframe</param> /// <param name="xData">Chart data</param> /// <returns></returns> public int CreateChart(int accountID, int insID, Timeframes tf, XDocument xData) { DbChart db_chart = new DbChart() { ChartID = 0, InsID = insID, Tf = (byte)tf, AccountID = accountID, Data = xData.ToString() }; using (var db = new DaContext(_options)) { db.Chart.Add(db_chart); db.SaveChanges(); } return(db_chart.ChartID); }
// Constructor public ChartJsRenderer(DbChart chart) => Chart = chart;