public override Stock GetStock(int stockId) { Stock stock = null; using (OdbcCommand command = new OdbcCommand()) { command.Connection = connection; command.CommandText = string.Format("SELECT ticker, price FROM get_stock({0});", stockId); using (OdbcDataReader reader = command.ExecuteReader(CommandBehavior.SingleResult)) { if (reader.HasRows) { stock = new Stock(); stock.Id = stockId; stock.Ticker = reader.GetString(0); stock.LastPrice = reader.GetDecimal(1); } reader.Close(); } } return stock; }
//~PostgresqlDataProvider() //{ // if (connection.State != ConnectionState.Closed) // connection.Close(); //} public override Stock GetStock(int stockId) { string query = "SELECT id, ticker, price FROM stocks WHERE id = " + stockId; OdbcCommand command = new OdbcCommand(query, connection); OdbcDataReader reader = command.ExecuteReader(CommandBehavior.SingleResult); if (!reader.HasRows) { reader.Close(); return null; } Stock stock = new Stock(); stock.Id = reader.GetInt32(0); stock.Ticker = reader.GetString(1); stock.LastPrice = reader.GetDecimal(2); reader.Close(); return stock; }
public override Stock[] SelectStocks() { IList<Stock> stocks = new List<Stock>(); string query = "SELECT id, ticker, price FROM stocks"; OdbcCommand command = new OdbcCommand(query, connection); OdbcDataReader reader = command.ExecuteReader(); while (reader.Read()) { Stock stock = new Stock(); stock.Id = reader.GetInt32(0); stock.Ticker = reader.GetString(1); stock.LastPrice = reader.GetDecimal(2); stocks.Add(stock); } reader.Close(); return stocks.ToArray(); }
public override Stock[] SelectStocks() { XDocument document = XDocument.Load(FileName); XElement stocksElement = document.Root.Element(StocksElementName); IList<Stock> stockList = new List<Stock>(); foreach (XElement stockElement in stocksElement.Elements()) { Stock stock = new Stock(); stock.Id = int.Parse(stockElement.Element("id").Value); //stock.TickSize = decimal.Parse(stockElement.Element("tickSize").Value, new CultureInfo("en-US")); stock.LastPrice = decimal.Parse(stockElement.Element("price").Value, new CultureInfo("en-US")); stockList.Add(stock); } return stockList.ToArray(); }
public override Stock[] SelectStocks() { IList<Stock> stocks = new List<Stock>(); using (OdbcCommand command = new OdbcCommand()) { command.Connection = connection; command.CommandText = "SELECT id, ticker, price FROM stocks;"; // nebo: FROM get_stocks(); using (OdbcDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Stock stock = new Stock(); stock.Id = reader.GetInt32(0); stock.Ticker = reader.GetString(1); stock.LastPrice = reader.GetDecimal(2); stocks.Add(stock); } reader.Close(); } } return stocks.ToArray(); }