Store Processor

ALTER PROCEDURE [dbo].[SP_Student](
@Action VARCHAR(50)=NULL,
@Name VARCHAR(50)=NULL,
@DOB DATE=NULL,
@Email VARCHAR(120)=NULL,
@ImagePath VARCHAR(500)=NULL,
@Password VARCHAR(300)=NULL
)
AS
BEGIN
    IF(@Action='insert')
        BEGIN
            IF NOT EXISTS(SELECT * FROM Student WHERE Email=@Email)
                BEGIN
                    INSERT INTO Student(Name,DOB,Email,Password,ImagePath,IsActive,AddedOn) VALUES(@Name,@DOB,@Email,@Password,'/content/profilepic/user.png',1,GETDATE());
                    SELECT 1 AS Flag;
                END
            ELSE
                BEGIN
                    SELECT 0 AS Flag;
                END
        END
    ELSE IF(@Action='select')
        BEGIN
            SELECT * FROM Student;
        END
    ELSE IF(@Action='VerifyLogin')
        BEGIN
            SELECT TOP 1 Password FROM Student WHERE Email=@Email AND Password=@Password;
        END
   ELSE IF(@Action='singlerecard')
        BEGIN
            SELECT * FROM Student WHERE Email=@Email and IsActive=1;
        END
 ELSE IF(@Action='updateimg')
        BEGIN
            update Student set ImagePath=@ImagePath WHERE Email=@Email;
        END
END