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