public ActionResult <ItemResponse <CryptoPortfolioModel> > Get(int id) { ItemResponse <CryptoPortfolioModel> response = null; ActionResult result = null; try { CryptoPortfolioModel cryptoPortfolio = _cryptoPortfolioService.Get(id); if (cryptoPortfolio == null) { result = NotFound404(new ErrorResponse("No Portfolio Found.")); } else { response = new ItemResponse <CryptoPortfolioModel>(); response.Item = cryptoPortfolio; result = Ok200(response); } } catch (Exception ex) { Logger.LogError(ex.ToString()); result = StatusCode(500, new ErrorResponse(ex.Message.ToString())); } return(result); }
private static CryptoPortfolioModel Mapper(IDataReader reader) { CryptoPortfolioModel cryptoPortfolio = new CryptoPortfolioModel(); cryptoPortfolio.Id = (int)reader["Id"]; cryptoPortfolio.CoinId = (int)reader["CoinId"]; cryptoPortfolio.ExchangeId = (int)reader["ExchangeId"]; cryptoPortfolio.Price = (Decimal)reader["Price"]; cryptoPortfolio.Quantity = (Decimal)reader["Quantity"]; return(cryptoPortfolio); }
public CryptoPortfolioModel Get(int?id) { CryptoPortfolioModel cryptoPortfolio = new CryptoPortfolioModel(); using (SqlConnection con = new SqlConnection(connString)) { SqlCommand cmd = new SqlCommand("dbo.CryptoPortfolio_GetById", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Id", id); con.Open(); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { cryptoPortfolio = Mapper(reader); } ; } return(cryptoPortfolio); }