public IHttpActionResult FinishProductToShop([FromBody] FinishedProductToShop fpts)
{
var result = (Object)null;
var ReturnedData = (Object)null;
if (fpts.BusinessId > 0 && fpts.StoreId > 0 && fpts.ProductionManagerId > 0 && fpts.StoreManagerId > 0)
{
rv = pr.SendFinishProductToShop(fpts);
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));
}
public ReturnValues SendFinishProductToShop(FinishedProductToShop fp)
{
ReturnValues rv = new ReturnValues();
using (SqlConnection conn = connect.getConnection())
{
using (SqlCommand cmd = new SqlCommand("SendFinishedProductToStore", conn))//call Stored Procedure
{
//fp.ActionType --- 1 -> Add to Store, 2-> Moved from store, 3-> sold from store
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@BusinessId", fp.BusinessId);
cmd.Parameters.AddWithValue("@StoreId", fp.StoreId);
cmd.Parameters.AddWithValue("@ProductId", fp.ProductId);
cmd.Parameters.AddWithValue("@ActionQty", fp.ActionQty);
cmd.Parameters.AddWithValue("@ActionType", "Add To Store");
cmd.Parameters.AddWithValue("@ProductionManagerId", fp.ProductionManagerId);
cmd.Parameters.AddWithValue("@StoreManagerId", fp.StoreManagerId);
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)
{
Console.WriteLine("We are catching an exception");
CommonUtilityClass.ExceptionLog(ex);
Console.WriteLine(ex.Message);
rv.StatusCode = 2000;
rv.StatusMessage = "An Error Occured";
}
}
}
return(rv);
}
