My Stored Procedure Gives error

CREATE PROCEDURE empinsert
	@email varchar(50),
	@Name varchar(50),
	@FatherName varchar(50),
	@Login varchar(50),
	@Password varchar(50),
	@Department Varchar(50),
	@Designation varchar(50),
	@weightage int
	As
	
	Begin 
	insert into emp_registration values(@email,@Name,@FatherName,@Login,@Password,@Department,@Designation)
	END
	
				if @Designation ='Manager'
                
                    @weightage = 7;
                
              else if @Designation = 'Asst.Manager'
                
                    @weightage = 5;
                
                else if @Designation= 'Deputy Manager'
                                    
                    @weightage = 6;
                
               else if @Designation = 'Team Leader'
               
                   @weightage = 4;
               
 
              else if @Designation = 'Executives'
                
                    @weightage= 3;
                
                else if @Designation = 'Clerk'
                
                    @weightage = 3;
                
 
               else if @Designation= "Officeassistant"
                
                    @weightage = 2;
                
	Begin				
	insert into Users values(@Login,@Password,@weightage)
	End
	Go