public ReturnValues AddRemoveSellProductQty(AddRemoveQty pr) { ReturnValues rv = new ReturnValues(); using (SqlConnection conn = connect.getConnection()) { using (SqlCommand cmd = new SqlCommand("AddRemoveProductQty", conn))//call Stored Procedure { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@productId", pr.productId); cmd.Parameters.AddWithValue("@userid", pr.userId); cmd.Parameters.AddWithValue("@businessid", pr.businessId); cmd.Parameters.AddWithValue("@addRemove", pr.ActionType); cmd.Parameters.AddWithValue("@Qty", pr.Qty); cmd.Parameters.Add("@returnvalue", SqlDbType.Int); cmd.Parameters["@returnvalue"].Direction = ParameterDirection.Output; cmd.Parameters.Add("@returnvalueString", System.Data.SqlDbType.VarChar, 200); cmd.Parameters["@returnvalueString"].Direction = ParameterDirection.Output; try { cmd.ExecuteNonQuery(); rv.StatusCode = Convert.ToInt32(cmd.Parameters["@returnvalue"].Value); rv.StatusMessage = Convert.ToString(cmd.Parameters["@returnvalueString"].Value); } catch (Exception ex) { CommonUtilityClass.ExceptionLog(ex); rv.StatusCode = 2000; rv.StatusMessage = "An Error Occured"; } } return(rv); } }
public IHttpActionResult AddRemoveFinishedProductQty([FromBody] AddRemoveQty arq) { var result = (Object)null; var ReturnedData = (Object)null; arq.businessId = Convert.ToInt32(Request.Headers.GetValues("BUSINESSID").FirstOrDefault()); arq.userId = Convert.ToInt32(Request.Headers.GetValues("USERID").FirstOrDefault()); if (arq.ActionType > 0 && arq.productId > 0 && arq.ActionType > 0) { rv = pr.AddRemoveSellProductQty(arq); result = cuc.GetJsonObject(ReturnedData, rv); } else { rv.StatusCode = 10; rv.StatusMessage = "you did not supply a vital identity"; result = cuc.GetJsonObject(ReturnedData, rv); } return(Ok(result)); }