C#

  private bool isUserIDEmpty()
    {
        return(txtUserID.Text.Length==0);
    }

private bool isFNameEmpty()
    {
        return(txtFName.Text.Length==0);
    }

private bool isMidNameEmpty()
    {
        return(txtMidInitial.Text.Length==0);
    }

private bool isLNameEmpty()
    {
            return(this.txtLName.Text.Length==0);
    }

private bool isSSNEmpty()
    {
        return(this.txtSSN.Text.Length == 0);
    }

  internal void ValidateAndAssignValues()
{
    Queue messages = new Queue();
    Control focusControl = null;

if(!isUserIDEmpty())
    {
        EmpID = this.txtUserID.Text;
    }
else
        {
        messages.Enqueue("Please Enter a User ID");
        focusControl = this.txtUserID;
    }

if (!isFNameEmpty())
    {
        FName = this.txtFName.Text;
    }
else
    {
        messages.Enqueue("Please Enter a First Name.");
        if(focusControl == null)
            focusControl = this.txtFName;
    }
       if(!isSSNEmpty())
    {//validating
        //validate integer
        if(isSSNNineDigits()!= true)
          {
              messages.Enqueue("You have not enter nine characters");
            if (focusControl == null)
                focusControl = this.txtSSN;
            }
        else
            {
            try
               {
                  SSN = int.Parse(this.txtSSN.Text);
                }
            catch
                 {
                messages.Enqueue("Please Enter a valid SSN.                                         Please ensure that you have entered numbers only.");

                if (focusControl == null)
                    focusControl = this.txtSSN;
            }
              }
                }

            if (messages.Count > 0)
    {
        StringBuilder sb = new StringBuilder();
        bool first = true;
        foreach (string message in messages)
        {
            if (first)
                first = false;
            else
                sb.Append('\n');
            sb.Append(message);
        }

        lblError.Visible = true;
        lblError.Text = sb.ToString();
    }
    else
         {
             lblError.Visible = false;
               lblError.Text = "";
            }

          if (focusControl != null)
        focusControl.Focus();


        }

internal void InsertIntoDatabase()
    {
        ValidateAndAssignValues()


        try
        {
            SqlCommand cmd = newSqlCommand                                   ("SP_InsertEmployeeRecord",conDatabase);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add(new SqlParameter("@Emp_Login_ID",EmpID ));
            cmd.Parameters.Add(new SqlParameter("@Emp_SSN", SSN));
            cmd.Parameters.Add(new SqlParameter("@Emp_First_Name", FName));
            cmd.Parameters.Add(new SqlParameter("@Emp_Middle_Name", MidName));
            cmd.Parameters.Add(new SqlParameter("@Emp_Last_Name", LName));
            cmd.Parameters.Add(new SqlParameter("@Emp_Birth_Date", DOB));
            cmd.Parameters.Add(new SqlParameter("@Emp_Hire_Date", HireDate));
            cmd.Parameters.Add(new SqlParameter("@Emp_Position", Position));
            cmd.Parameters.Add(new SqlParameter("@Emp_Sex", Sex));

            conDatabase.Open();
            cmd.ExecuteNonQuery();
        }
        catch(Exception G)
        {
            this.lblError.Text = (G.Message);
            this.lblError.Visible=true;

        }

        conDatabase.Close();

        this.lblError.Visible=true;
        this.lblError.Text = "You record have been saved";

    }