c＃中单个存储过程中的crud操作

ALTER PROCEDURE dbo.bicrudlogin 
    (
    @id int,
    @username nvarchar(50),
    @password nvarchar(50),
    @type varchar(50),
    @status varchar(50)
    )   
AS
if(@status='insert')
Begin   
insert into tbllogin  values(@username,@password,@type)
End

if(@status='select')
Begin   
select type from tbllogin where username=@username and password=@password
End

if(@status='update')
Begin   
update tbllogin set username=@username,password=@password,type=@type  where id=@id
End

if(@status='delete')
Begin   
delete from tbllogin where id=@id
End 

RETURN
ALTER PROCEDURE dbo.bicrudlogin 
    (
    @id