TestConnection() static private method

static private TestConnection ( ) : bool
return bool
QSMain Class Documentation
Beispiel #1
0
        void UpdateUsers()
        {
            if (!QSMain.TestConnection())
            {
                return;
            }
            QSMain.CheckConnectionAlive();
            logger.Info("Получаем таблицу пользователей...");

            string sql = "SELECT * FROM users ";

            if (!chkShowInactive.Active)
            {
                sql += " WHERE deactivated = 0";
            }
            MySqlCommand cmd = new MySqlCommand(sql, QSMain.connectionDB);

            MySqlDataReader rdr = cmd.ExecuteReader();

            UsersListStore.Clear();
            while (rdr.Read())
            {
                bool deactivated = false;
                try {
                    deactivated = DBWorks.GetBoolean(rdr, "deactivated", false);
                } catch {
                    logger.Warn("В базе отсутствует поле deactivated!");
                }
                UsersListStore.AppendValues(int.Parse(rdr ["id"].ToString()),
                                            rdr ["login"].ToString(),
                                            rdr ["name"].ToString(),
                                            (bool)rdr ["admin"],
                                            deactivated,
                                            deactivated ? "grey" : "black");
            }
            rdr.Close();

            logger.Info("Ok");

            OnTreeviewUsersCursorChanged(null, null);
        }