public int DecreaseQuantityTransaction(StockHoldings transaction) { using (SqlConnection con = new SqlConnection(_connectionString)) { con.Open(); SqlCommand cmd = new SqlCommand(_spDecreaseQuantity, con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", transaction.userId); cmd.Parameters.AddWithValue("@StockId", transaction.stockId); cmd.Parameters.AddWithValue("@Quantity", transaction.quantity); int rdr = cmd.ExecuteNonQuery(); return(rdr); } }
public string GetUserStock(int userId) { List <StockHoldings> stockHoldingList = new List <StockHoldings>(); using (SqlConnection con = new SqlConnection(_connectionString)) { con.Open(); SqlCommand cmd = new SqlCommand(_spGetStockIds, con); cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@UserId", userId); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { StockHoldings stock = new StockHoldings(); stock.stockId = Convert.ToInt32(rdr["StockId"]); stock.userId = Convert.ToInt32(rdr["UserId"]); stock.quantity = Convert.ToInt32(rdr["Quantity"]); stockHoldingList.Add(stock); } } return(JsonConvert.SerializeObject(stockHoldingList)); }
public int Put([FromBody] StockHoldings transaction) { return(obj.DecreaseQuantityTransaction(transaction)); }
public int Post([FromBody] StockHoldings transaction) { return(obj.InsertOrUpdateTransaction(transaction)); }