whereas i feel i could have executed an single SP call and get the response back.What are your thoughts
You could do it this way of course. But by doing this you have added another location for business logic (i.e. in the database) which will need written, tested and maintained, in addition to your application. In order to debug what is happening in your app. you will need to check more than one source, which adds complication. This also implies that changing the database/adding support for another database requires you re-implement the stored procedure in whatever database specific language that database uses.
Performance is pretty much the only reason I would choose to use Stored Procedures. And performance is only a valid requirement if it is
specifically specified for (with target metrics), rather than as a general concern.