public ActionResult <ItemResponse <SuccessResponse> > Update(CryptoPortfolioUpdateRequest req)
{
SuccessResponse response = new SuccessResponse();
ActionResult result = null;
try
{
_cryptoPortfolioService.Update(req);
result = Ok200(response);
}
catch (Exception ex)
{
Logger.LogError(ex.ToString());
result = StatusCode(500, new ErrorResponse(ex.Message.ToString()));
}
return(result);
}
public void Update(CryptoPortfolioUpdateRequest req)
{
using (SqlConnection con = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand("dbo.CryptoPortfolio_Update", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", req.Id);
cmd.Parameters.AddWithValue("@CoinId", req.CoinId);
cmd.Parameters.AddWithValue("@ExchangeId", req.ExchangeId);
cmd.Parameters.AddWithValue("@Price", req.Price);
cmd.Parameters.AddWithValue("@Quantity", req.Quantity);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
