Procedure and Trigger

--Create Procedure CRUD Customer--
create procedure CRUDCustomer
(ID int,
@Name char(25),
@Phone_Num char(15),
@Address varchar(50),
@StatementType char(6) = '')
as

if @StatementType = 'insert'
    begin
        insert into [dbo].[Customer] ([Cust_ID], [Name], [Phone_Number], [Address] )
        values (@ID, @Name, @Phone_Num, @Address)
    end

if @StatementType = 'select'
    begin
        select * from [dbo].[Customer]
    end

if @StatementType = 'update'
    begin
        update [dbo].[Customer]
        set
            [Name] = @Name,
            [Phone_Number] = @Phone_Num,
            [Address] = @Address
        where [Cust_ID] = @ID
    end

if @StatementType = 'delete'
    begin
        delete from [dbo].[Customer]
        where [Cust_ID] = @ID
    end
go

--Create Trigger for Customer Table--
create trigger AddCust on [dbo].[Customer]
    after insert
    as
        begin
        print 'Data Added'
        end
go

create trigger UpdateCust on [dbo].[Customer]
    after update
    as
        begin
        print 'Data Updated'
        end
go

create trigger DeleteCust on [dbo].[Customer]
    after delete
    as
        begin
        print 'Data Deleted'
        end
go