public void addData(NewsRecord news)
{
try
{
IDbCommand dbcmd = getDbCommand();
dbcmd.CommandText =
"INSERT INTO " + TABLE_NAME
+ " ( "
//+ KEY_NewsID + ", "
+ KEY_CompanyName + ", "
+ KEY_Content + ", "
+ KEY_FluctuationRate + " ) "
+ "VALUES ( '"
//+ news.NewsID + "', '"
+ news.CompanyName + "', '"
+ news.Content + "', '"
+ news.FluctuationRate + "' )";
dbcmd.ExecuteNonQuery();
}
catch
{
Debug.Log("Invalid data key because repeated. Please change a new key");
}
}
public NewsPart CreateNews(NewsRecord newsRecord)
{
var newpart = _orchardServices.ContentManager.New <NewsPart>("News");
newpart.Record = newsRecord;
_contentManager.Create(newpart, VersionOptions.Published);
return(newpart);
}
public void UpdateRepoNews(NewsRecord news)
{
NewsRecord oldNews = _newsRepository.Get(news.Id);
oldNews.NewsTitle = news.NewsTitle;
oldNews.NewsContent = news.NewsContent;
oldNews.NewsCategory = news.NewsCategory;
_newsRepository.Update(oldNews);
}
public ActionResult Create(string title, string content)
{
NewsRecord news = new NewsRecord()
{
NewsTitle = title,
NewsContent = content
};
_newsService.CreateNews(news);
return(RedirectToAction("Index"));
}
public NewsRecord CreateRecord([FromForm] NewsRecordDto newsRecordDto, int id)
{
var record = new NewsRecord {
CompanyId = id,
Content = newsRecordDto.Content,
Image = _mediaStorageService.UploadMedia(newsRecordDto.Image, this.GetUserId()),
Title = newsRecordDto.Title,
CreatedAt = DateTime.Now
};
_appContext.News.AddRange(record);
_appContext.SaveChanges();
return(record);
}
/// <summary>
/// Handler for streaming message.
/// </summary>
/// <param name="sender">Sender</param>
/// <param name="args">Args</param>
private void StreamingMessageHandler(object sender, IncomingMessageArgs args)
{
var message = args.Message.Parameters.GetString("update");
JSONObject responseBody = (JSONObject)JSONObject.Parse(message);
string commandName = responseBody["command"].ToString();
if (RecordReceived != null)
{
RecordReceived.Invoke(message);
}
switch (commandName)
{
case "tickPrices":
TickRecord tickRecord = new TickRecord((JSONObject)responseBody["data"]);
if (TickPricesRecordReceived != null)
{
TickPricesRecordReceived.Invoke(tickRecord);
}
break;
case "trade":
StreamingTradeRecord tradeRecord = new StreamingTradeRecord((JSONObject)responseBody["data"]);
if (TradeRecordReceived != null)
{
TradeRecordReceived.Invoke(tradeRecord);
}
break;
case "indicators":
IndicatorsRecord balanceRecord = new IndicatorsRecord((JSONObject)responseBody["data"]);
if (AccountIndicatorsRecordReceived != null)
{
AccountIndicatorsRecordReceived.Invoke(balanceRecord);
}
break;
case "orderStatus":
OrderStatusRecord tradeStatusRecord = new OrderStatusRecord((JSONObject)responseBody["data"]);
if (OrderStatusRecordReceived != null)
{
OrderStatusRecordReceived.Invoke(tradeStatusRecord);
}
break;
case "profit":
ProfitRecord profitRecord = new ProfitRecord((JSONObject)responseBody["data"]);
if (ProfitRecordReceived != null)
{
ProfitRecordReceived.Invoke(profitRecord);
}
break;
case "news":
NewsRecord newsRecord = new NewsRecord((JSONObject)responseBody["data"]);
if (NewsRecordReceived != null)
{
NewsRecordReceived.Invoke(newsRecord);
}
break;
case "keepAlive":
KeepAliveRecord keepAliveRecord = new KeepAliveRecord((JSONObject)responseBody["data"]);
if (KeepAliveRecordReceived != null)
{
KeepAliveRecordReceived.Invoke(keepAliveRecord);
}
break;
case "candle":
StreamingCandleRecord candleRecord = new StreamingCandleRecord((JSONObject)responseBody["data"]);
if (CandleRecordReceived != null)
{
CandleRecordReceived.Invoke(candleRecord);
}
break;
case "error":
StreamingErrorRecord streamingErrorRecord = new StreamingErrorRecord((JSONObject)responseBody["data"]);
if (ErrorRecordReceived != null)
{
ErrorRecordReceived.Invoke(streamingErrorRecord);
}
break;
default:
throw new APICommunicationException("Unknown streaming record received");
}
}
public void UpdateNews(NewsRecord news)
{
}
public void CreateRepoNews(NewsRecord newsRecord)
{
_newsRepository.Create(newsRecord);
}
