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); }