public void FillAllUsers()
        {
            // Clear out global users list, in case it's been updated.
            GlobalVars.uList.Clear();

            // Clear out current listbox.
            lb_UsersList.Items.Clear();

            // Setting up DB stuff.
            string s_ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data " +
                "Source=|DataDirectory|\\CloseoutApp.accdb";

            string s_Query = "SELECT UserID, UserName, UserTitle, UserArea, CanEditData " +
                "FROM Users ORDER BY UserID;";

            using (OleDbConnection AccessConn = new OleDbConnection(s_ConnString))
            {
                using (OleDbCommand AccessCmd = AccessConn.CreateCommand())
                {
                    AccessCmd.CommandText = s_Query;
                    try
                    {
                        AccessConn.Open();

                        OleDbDataReader rdr = AccessCmd.ExecuteReader();

                        while (rdr.Read())
                        {
                            User u = new User();
                            u.UserID = rdr.GetInt32(0);
                            u.UserName = rdr.GetString(1);
                            u.UserTitle = rdr.GetString(2);
                            u.UserArea = rdr.GetString(3);
                            u.CanEditData = rdr.GetBoolean(4);
                            GlobalVars.uList.Add(u);
                        }

                        rdr.Close();
                        AccessConn.Close();
                    }
                    catch (Exception e)
                    {

                        MessageBox.Show("Database error:\n" + e.Message +
                         "\nPlease take a screenshot and\nreport this to Ashton.",
                         "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                    }
                }
            }

            foreach (User u in GlobalVars.uList)
            {
                lb_UsersList.Items.Add(u.UserName);
            }

            lb_UsersList.SelectedIndex = 0;
        }
        private void ReadUsersIntoListBox()
        {
            // Setting up DB stuff.
            string s_ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data " +
                "Source=|DataDirectory|\\CloseoutApp.accdb";

            string s_Query = "SELECT UserID, UserName, UserTitle, UserArea FROM Users " +
                "ORDER BY UserName;";

            using (OleDbConnection AccessConn = new OleDbConnection(s_ConnString))
            {
                using (OleDbCommand AccessCmd = AccessConn.CreateCommand())
                {
                    AccessCmd.CommandText = s_Query;

                    try
                    {
                        AccessConn.Open();

                        OleDbDataReader rdr = AccessCmd.ExecuteReader();

                        while (rdr.Read())
                        {
                            User newUser = new User();
                            newUser.UserID = rdr.GetInt32(0);
                            newUser.UserName = rdr.GetString(1);
                            newUser.UserTitle = rdr.GetString(2);
                            newUser.UserArea = rdr.GetString(3);

                            userList.Add(newUser);
                        }

                        rdr.Close();

                    }

                    catch (Exception ex)
                    {
                        MessageBox.Show("Database error:\n" + ex.Message +
                         "\nPlease take a screenshot and\nreport this to Ashton.",
                         "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                    }

                }

            }

            // Add users to the ListBox.
            foreach (User u in userList)
            {
                lb_Users.Items.Add(u.UserName);
            }
        }
        private void FillUsersList()
        {
            /* FillUsersList()
             *
             * 1. Clears out current listbox and global users list.
             * 2. Reads user's ID and Name into global users list and then into a ComboBox.
             *
             */

            // Clear out global users list, in case it's been updated.
            GlobalVars.uList.Clear();

            // Clear out current listbox.
            cb_AssignedTo.Items.Clear();

            // Setting up DB stuff.
            string s_ConnString = "Provider=Microsoft.ACE.OLEDB.12.0;Data " +
                "Source=|DataDirectory|\\CloseoutApp.accdb";

            string s_Query = "SELECT UserID, UserName " +
                "FROM Users ORDER BY UserName;";

            using (OleDbConnection AccessConn = new OleDbConnection(s_ConnString))
            {
                using (OleDbCommand AccessCmd = AccessConn.CreateCommand())
                {
                    AccessCmd.CommandText = s_Query;
                    try
                    {
                        AccessConn.Open();

                        OleDbDataReader rdr = AccessCmd.ExecuteReader();

                        while (rdr.Read())
                        {
                            User u = new User();
                            u.UserID = rdr.GetInt32(0);
                            u.UserName = rdr.GetString(1);

                            GlobalVars.uList.Add(u);
                        }

                        rdr.Close();
                        AccessConn.Close();
                    }
                    catch (Exception e)
                    {

                        MessageBox.Show("Database error:\n" + e.Message +
                         "\nPlease take a screenshot and\nreport this to Ashton.",
                         "Error", MessageBoxButton.OK, MessageBoxImage.Error);
                    }
                }
            }

            foreach (User u in GlobalVars.uList)
            {
                cb_AssignedTo.Items.Add(u.UserName);
            }

            cb_AssignedTo.SelectedIndex = -1;
        }