public void addEmployee(String password, String fname, String lname, String secret, String answer)
        {
            EmployeeAdd employees1 = new EmployeeAdd()
            {
                password       = password,
                FirstName      = fname,
                LastName       = lname,
                SecretQuestion = secret,
                Answer         = answer
            };



            if (fname == "" || lname == "" || secret == "" || answer == "" || password == "")
            {
                MessageBox.Show(" First Name, Last Name, Secret Question, Answer, and Password are required. Employee was not added.");
            }

            else
            {
                employeemodel.AddEmployee(employees1);
            }
        }
        internal void AddEmployee(EmployeeAdd employees)
        {
            string connectionString = ConfigurationManager.ConnectionStrings["MovieRental"].ConnectionString;
            string queryString      = @"Insert into EMPLOYEE (PASSWORD,EMPLOYEE_FNAME,EMPLOYEE_LNAME,SECRET_QUESTION,ANSWER)
         values(@PASSWORD, @EMPLOYEE_FNAME, @EMPLOYEE_LNAME, @SECRET_QUESTION, @ANSWER)";


            using (var connection = new SqlConnection(connectionString))
            {
                connection.Open();
                SqlCommand cmd2 = new SqlCommand();


                try
                {
                    cmd2 = new SqlCommand(queryString, connection);

                    cmd2.Parameters.AddWithValue("@PASSWORD", employees.password);
                    cmd2.Parameters.AddWithValue("@EMPLOYEE_FNAME", employees.FirstName);
                    cmd2.Parameters.AddWithValue("@EMPLOYEE_LNAME", employees.LastName);
                    cmd2.Parameters.AddWithValue("@SECRET_QUESTION", employees.SecretQuestion);
                    cmd2.Parameters.AddWithValue("@ANSWER", employees.Answer);


                    cmd2.ExecuteNonQuery();
                    MessageBox.Show(employees.FirstName + " " + employees.LastName + " " + "was successfully added.");
                    connection.Close();
                }
                catch (Exception e)
                {
                    MessageBox.Show(e.Message);
                    MessageBox.Show("Emloyee was not added");
                    connection.Close();
                }
            }
        }// end of add employee