Hi, you can use one stored procedure for all Actions.
write a sp with all possible parameters and assign value null to every parameter.
i.e.
Create procedure spUser
@ActivityType bigint = null,
@Uname varchar(50) = null
As
Begin
if @ActivityType = 1
Begin
End
if @ActivityType = 2
Begin
End
if @ActivityType = 3
Begin
End
End
I am using this, if you have any problem with this then tell me. :-)