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