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