Register Insert in Asp and sql-server

Create procedure Registerationinsert
@email nvarchar(max),@passwaord nvarchar(max)
as
Begin
     Declare @Count int,@regcount int
     Select @Count = Count(EmployeeMailID)
     from EmployeeDuplicate
     where EmployeeMailID = @email
     If @Count > 0
  select @regcount=count(EmployeeEmail) from AMS_Registration where EmployeeEmail=@email
  if @regcount = 0
  begin insert into AMS_Registration (EmployeeID,EmployeeEmail,Password,EmployeeName,PhoneNumber,Role) Select EmployeeID, @email,@passwaord,EmployeeName,
  EmployeePhoneNumber,EmployeeDesignation from EmployeeDuplicate where EmployeeMailID=@email
  end
  else if @regcount >0
  begin
  select 1 as Alreadyregistered
  end
     Else if @Count = 0
          Select 0 as Notvalid
End

<div class="col-md-12">
          <div class="col-md-6">
          <input type="text" id="txtemail" /><br /></div>
 
          <label id="divOutput"></label>
          <div class="col-md-6">
          <input type="text" id="txtpwd" /><br /></div>
          <div class="col-md-2">
          <input type="button" id="btnsubmit" value="Submit" /><br /></div>
      </div>

<script>
      $(document).ready(function () {
 
          $('#btnsubmit').click(function () {
              var userName = $("#txtemail").val();
              var pwd = $("#txtpwd").val();
 
              if (userName.length >= 3) {
                  $.ajax({
                      url: 'register.aspx/UserNameExists',
                      method: 'post',
                      data: { userName: userName, pwd: pwd },
                      dataType: 'json',
                      success: function (data) {
                          var divElement = $('#divOutput');
                          if (data.UserNameInUse) {
                              divElement.text(data.UserName + ' already in use');
                              divElement.css('color', 'red');
                          }
                          else if (data.usernameno) {
 
                              divElement.text(data.UserName + 'not valid');
                              divElement.css('color', 'red');
                          }
                          else {
                              divElement.text(data.UserName + ' Registered')
                              divElement.css('color', 'green');
                          }
                      },
                      error: function (err) {
                          alert(err);
                      }
                  });
              }
          });
      });
  </script>






[WebMethod]
     public void UserNameExists(string userName,string pwd)
     {
         bool userNameInUse = false;
         bool usernameno = true;
         string cs = ConfigurationManager.ConnectionStrings["AMS_ProjectEntities"].ConnectionString;
         using (SqlConnection con = new SqlConnection(cs))
         {
             SqlCommand cmd = new SqlCommand("Registerationinsert", con);
             cmd.CommandType = CommandType.StoredProcedure;
 
             cmd.Parameters.Add(new SqlParameter()
             {
                 ParameterName = "@email",
                 Value = userName
             });
             cmd.Parameters.Add(new SqlParameter()
             {
                 ParameterName = "@passwaord",
                 Value = pwd
             });
             con.Open();
             userNameInUse = Convert.ToBoolean(cmd.ExecuteScalar());
             usernameno = Convert.ToBoolean(cmd.ExecuteScalar());
         }
     }