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