// adds user to database
        private async void AddUserClicked(object sender, EventArgs e)
        {
            // if any of the fields are invalid
            if ((string.IsNullOrWhiteSpace(userNameEntry.Text)) ||
                (string.IsNullOrWhiteSpace(passwordEntry.Text)) ||
                (string.IsNullOrEmpty(userNameEntry.Text)) ||
                (string.IsNullOrEmpty(passwordEntry.Text)))

            {
                // display error message
                await DisplayAlert("Invalid Entry", "Please Make Sure That the Data You Have Entered is Correct.", "OK");
            }
            // if all of the fields are valid
            else
            {
                // insert information from fields to user object
                userToAdd.Username = userNameEntry.Text;
                userToAdd.Password = passwordEntry.Text;

                // by default users should not be administrators
                userToAdd.Administrator = 0;

                try
                {
                    // add user to database
                    var returnvalue = userOps.AddUser(userToAdd);

                    // if user is successfully added
                    if (returnvalue)
                    {
                        // display success message
                        await DisplayAlert("User Add", "User Successfully Added to Database", "OK");

                        // go back to login page
                        await Navigation.PushAsync(new LogInPage());
                    }
                    // if user is not successfully added
                    else
                    {
                        // display error message
                        await DisplayAlert("User Add", "Please Try Again", "OK");

                        // reset input fields
                        userNameEntry.Text = string.Empty;
                        passwordEntry.Text = string.Empty;
                    }
                }
                catch (Exception ex)
                {
                    Debug.WriteLine(ex);
                }

                Navigation.PushAsync(new LogInPage());
            }
        }
        private static void addUsers(DBUserOps ops)
        {
            User user1 = new User();
            User user2 = new User();
            User user3 = new User();
            User user4 = new User();
            User user5 = new User();
            User user6 = new User();
            User user7 = new User();
            User user8 = new User();

            user1.Username      = "******";
            user1.Password      = "******";
            user1.Administrator = 1;
            user2.Username      = "******";
            user2.Password      = "******";
            user2.Administrator = 0;
            user3.Username      = "******";
            user3.Password      = "******";
            user3.Administrator = 0;
            user4.Username      = "******";
            user4.Password      = "******";
            user4.Administrator = 1;
            user5.Username      = "******";
            user5.Password      = "******";
            user5.Administrator = 0;
            user6.Username      = "******";
            user6.Password      = "******";
            user6.Administrator = 0;
            user7.Username      = "******";
            user7.Password      = "******";
            user7.Administrator = 1;
            user8.Username      = "******";
            user8.Password      = "******";
            user8.Administrator = 0;

            ops.AddUser(user1);
            ops.AddUser(user2);
            ops.AddUser(user3);
            ops.AddUser(user4);
            ops.AddUser(user5);
            ops.AddUser(user6);
            ops.AddUser(user7);
            ops.AddUser(user8);
        }