Error Inserting into a postgresql database through a stored

Question

I have a c# application that needs to write into a postgresql table

using a stored procedure.

 

The stored procedure is developed and tested. It is working correctly  when i tested

it manually  using the select script facility  in postgresql

 

When tried to insert  from my C#  application i got the error below:

 

System.InvalidCastException: 'Can't write CLR type System.Int32 with handler type TextHandler'

 

My guess is that there is probably a disconnect between the data been inserted and the

respective datatypes in the database.

 

I have tried to check the datatypes for the 7  parameters  but cant resolve it

 

 

I attach a word file that contains the details of ALL that i have done step by step 

 

I will be grateful to have any input that can help to resolve the issue

 

Olukay