It's pretty simple.Create a single procedure and include your separate insert query
For eg:
Create procedure procedurename
@parameter1 bigint =0 ,
@parameter2 nvarchar(max)= null,
@parameter3 nvarchar(max) = null,
@type int
as
begin
if(@type=1)
insert query
else if(@type=2)
another insert query
end
and in the front end, mention the query no which you want to execute
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "Procedurename";
cmd.Parameters.Add(new SqlParameter("@parametername", SqlDbType.VarChar, 50));
cmd.Parameters["@type"].Value = 1;