Reduce no of stored procedures in a project

Reduce no of stored procedures in a project

create PROCEDURE [dbo].[your_procedure_name]
        --your parameters
    @mode varchar(20)
AS

 BEGIN transaction  begin

 if @mode='Edit'  begin  -- your update query  end

 if @mode='Add'  begin  -- your insert query  end

 if @mode='delete'  begin  -- your delete query  end

 if @@error<>0  begin
ROLLBACK  end
commit  end