Stored Procedure has too many arguments
The C# code you are using to invoke the stored procedure is passing in @order_id as the first parameter.  That parameter is not referenced in the actual stored procedure.  Try removing that parameter from the C# code.