public StatisticForm(bool connected, string title)
 {
     InitializeComponent();
     this.connected = connected;
     this.title = title;
     sqLiteDatabase = new SqLiteDatabase(settings);
 }
 public SocketServerController(string title, int limit)
 {
     try
     {
         _threadList = new List<Thread>();
         var ip = new IPEndPoint(IPAddress.Any, 8081);
         _server = new Socket(ip.AddressFamily, SocketType.Stream, ProtocolType.Tcp);
         _server.Bind(ip);
         _server.Listen(MaxConnection);
         //--------------------------------------
         _settings           = _manager.Load();
         _database              = new SqLiteDatabase(_settings);
         _usedAccountArray   = new UsedAccountsController();
         _jsonHelper              = new JsonHelper();
         _myTitle            = title;
     }
     catch (Exception ex)
     {
         CreateSystemMessage("SocketError", "Ошибка 2.1: " + ex.Message);
     }
 }
        private void load_settings()
        {
            try
            {
                set_notification_label("trying", "postgres");
                set_notification_label("trying", "mysql");
                _settings    = _manager.Load();
                _myTitle     = _settings.CenterName;
                _postgres    = new PostgresController(_settings);
                // _mysql       = new MysqlDatabase(_settings);
                _sqLiteDatabase = new SqLiteDatabase(_settings);
                // --
                _sqLiteDatabase.OnSqlMessage    += HandleDatabaseMessage;
                _postgres.OnPostgresMessage     += HandleDatabaseMessage;
                // --

                _sqLiteDatabase.InitiateTables();
                if (_sqLiteDatabase.GetSteamAccounts().Rows.Count == 0)
                {
                    AddToLog("Таблица аккаунтов пуста");
                    if (File.Exists("accounts_backup.xml"))
                    {
                        var list = _manager.restore_accounts_from_backup();
                        if (list != null)
                        {
                            _sqLiteDatabase.RestoreAccounts(list);
                            AddToLog("Восстановлено из бэкапа аккаунтов: " + list.Count);
                        }
                    }
                }
                Start_Server();
                //
                this.Text = "Локальный сервер. Центр " + _myTitle;
                _server?.set_my_title(_myTitle);
                if (_postgres.is_connection_to_database())
                {
                    set_notification_label("online", "postgres");
                    _connectedToPostgres = true;
                }
                else
                {
                    set_notification_label("offline", "postgres");
                    _connectedToPostgres = false;
                }
                set_notification_label(_sqLiteDatabase.IsConnectionToDatabase() ? "online" : "offline", "mysql");
                get_my_limit();
                //equalize_accounts();
                AddToLog("Настройки загружены");
                CheckAccountsForMe();
                if (_settings.ActiveWebServer)
                    start_web_server();
            }
            catch (Exception ex)
            {
                _notificationHandler.write_an_error("Error 5.13: " + ex.Message);
            }
        }
 private void InitiateDatabases()
 {
     _postgresDatabase = new PostgresController(_settings);
     _mysqlDatabase = new SqLiteDatabase(_settings);
     // _mysqlDatabase = new MysqlDatabase(_settings);
 }