Query CRUD dalam 1 store procs

DELIMITER $$

USE `dbmadrasah`$$

DROP PROCEDURE IF EXISTS `sp_CRUD_tblsurat`$$

CREATE DEFINER=`root`@`localhost` PROCEDURE `sp_CRUD_tblsurat`(
 IN pIdsurat INT(11),
 IN pidguru INT(11),
 IN ptgl DATE,
 IN pjenis ENUM('masuk','keluar'),
 IN pno_surat VARCHAR(50),
 IN pket_surat VARCHAR(255)
        )
BEGIN
    IF @perintah='simpan' THEN
    INSERT INTO tblsurat (idsurat,idguru,tgl_surat,jenis_surat,no_surat,ket_surat)
    VALUES (pidsurat,pidguru,ptgl,pjenis,pno_surat,pket_surat);
    END IF;

    IF @perintah='ubah' THEN

    UPDATE tblsurat
    SET
    idguru=pidguru,tgl_surat=ptgl,jenis_surat=pjenis,no_surat=pno_surat,ket_surat=pket_surat
    WHERE
    idsurat=pidsurat;
     END IF;

     IF @perintah='hapus'THEN
    DELETE FROM tblsurat
        WHERE idsurat=pidsurat;
     END IF;
     IF @perintah='tampil' THEN

    SELECT * FROM tblsurat;
     END IF;

 END$$

DELIMITER ;