Ejemplo n.º 1
0
        private void Setup_Load(object sender, EventArgs e)
        {
            SimpleEncryption decrypt = new SimpleEncryption("password");

            string[] splited = new string[3];
            if (logon_class.Properties.Settings.Default.encrypted.Equals("1"))
            {
                splited               = (decrypt.Decrypt(logon_class.Properties.Settings.Default.db)).Split('=', ';');
                db.Text               = splited[1];
                splited               = (decrypt.Decrypt(logon_class.Properties.Settings.Default.catalog)).Split('=', ';');
                catalog.Text          = splited[1];
                splited               = (decrypt.Decrypt(logon_class.Properties.Settings.Default.security)).Split('=', ';');
                security.SelectedItem = splited[1];
                security.Text         = splited[1];
                splited               = decrypt.Decrypt(logon_class.Properties.Settings.Default.user).Split('=', ';');
                user.Text             = splited[1];
                splited               = decrypt.Decrypt((logon_class.Properties.Settings.Default.password)).Split('=', ';');
                password.Text         = splited[1];
            }
            else
            {
                splited               = (logon_class.Properties.Settings.Default.db).Split('=', ';');
                db.Text               = splited[1];
                splited               = (logon_class.Properties.Settings.Default.catalog).Split('=', ';');
                catalog.Text          = splited[1];
                splited               = (logon_class.Properties.Settings.Default.security).Split('=', ';');
                security.SelectedItem = splited[1];
                security.Text         = splited[1];
                splited               = (logon_class.Properties.Settings.Default.user).Split('=', ';');
                user.Text             = splited[1];
                splited               = (logon_class.Properties.Settings.Default.password).Split('=', ';');
                password.Text         = splited[1];
            }
        }
Ejemplo n.º 2
0
        public List <BindingIP> GetBindings(bool autoBinded = false)
        {
            DataTable dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_DESC, defaultTable, "ID"));

            if (autoBinded)
            {
                dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_WHERE, defaultTable, "AutoBind = 1"));
            }
            List <BindingIP> pwds = new List <BindingIP>();

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    BindingIP cmd = new BindingIP()
                    {
                        ID          = dr["ID"].ToSafeInteger(),
                        IPAddress   = SimpleEncryption.Decrypt(dr["IPAddress"].ToSafeString()),
                        Description = SimpleEncryption.Decrypt(dr["Description"].ToSafeString()),
                        Path        = SimpleEncryption.Decrypt(dr["Path"].ToSafeString()),
                        AutoBind    = dr["AutoBind"].ToSafeInteger(),
                        Code        = dr["Code"].ToSafeString()
                    };
                    pwds.Add(cmd);
                }
            }
            return(pwds);
        }
Ejemplo n.º 3
0
        public BindingIP GetBinding(string id)
        {
            if (string.IsNullOrEmpty(id))
            {
                return(null);
            }
            DataTable dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_WHERE, defaultTable, "ID=" + id));
            BindingIP b  = new BindingIP();

            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    try {
                        b = new BindingIP()
                        {
                            ID          = dr["ID"].ToSafeInteger(),
                            IPAddress   = SimpleEncryption.Decrypt(dr["IPAddress"].ToSafeString()),
                            Description = SimpleEncryption.Decrypt(dr["Description"].ToSafeString()),
                            Path        = SimpleEncryption.Decrypt(dr["Path"].ToSafeString()),
                            AutoBind    = dr["AutoBind"].ToSafeInteger(),
                            Code        = dr["Code"].ToSafeString()
                        };
                    } catch { /*@Ignore exception*/ }
                }
            }
            return(b);
        }
        public Credential GetCredential(string id)
        {
            if (string.IsNullOrEmpty(id))
            {
                return(null);
            }
            DataTable  dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_WHERE, defaultTable, "ID=" + id));
            Credential c  = new Credential();

            if (dt != null)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    try {
                        c = new Credential()
                        {
                            ID          = dr["ID"].ToSafeInteger(),
                            Username    = SimpleEncryption.Decrypt(dr["Username"].ToSafeString()),
                            Description = SimpleEncryption.Decrypt(dr["Description"].ToSafeString()),
                            PassKey     = SimpleEncryption.Decrypt(dr["PassKey"].ToSafeString()),
                            Code        = dr["Code"].ToSafeString()
                        };
                    } catch { /*@Ignore exception*/ }
                }
            }
            return(c);
        }
Ejemplo n.º 5
0
        public void get_settings()
        {
            string           check_time = "";
            SimpleEncryption decrypt    = new SimpleEncryption("password");

            if (logon_class.Properties.Settings.Default.encrypted.Equals("1"))
            {
                connection = decrypt.Decrypt(logon_class.Properties.Settings.Default.db) + decrypt.Decrypt(logon_class.Properties.Settings.Default.catalog) + decrypt.Decrypt(logon_class.Properties.Settings.Default.security) + decrypt.Decrypt(logon_class.Properties.Settings.Default.user) + decrypt.Decrypt(logon_class.Properties.Settings.Default.password);
                check_time = decrypt.Decrypt(logon_class.Properties.Settings.Default.default_service_time);
                check_t    = Convert.ToInt32(TimeSpan.Parse(check_time).TotalSeconds) * 1000;
            }
            else
            {
                connection = logon_class.Properties.Settings.Default.db + logon_class.Properties.Settings.Default.catalog + logon_class.Properties.Settings.Default.security + logon_class.Properties.Settings.Default.user + logon_class.Properties.Settings.Default.password;
                check_time = logon_class.Properties.Settings.Default.default_service_time;
                check_t    = Convert.ToInt32(TimeSpan.Parse(check_time).TotalSeconds) * 1000;
            }
        }
Ejemplo n.º 6
0
 public void DecryptExampleTests()
 {
     Assert.AreEqual("This is a test!", SimpleEncryption.Decrypt("This is a test!", 0));
     Assert.AreEqual("This is a test!", SimpleEncryption.Decrypt("hsi  etTi sats!", 1));
     Assert.AreEqual("This is a test!", SimpleEncryption.Decrypt("s eT ashi tist!", 2));
     Assert.AreEqual("This is a test!", SimpleEncryption.Decrypt(" Tah itse sits!", 3));
     Assert.AreEqual("This is a test!", SimpleEncryption.Decrypt("This is a test!", 4));
     Assert.AreEqual("This is a test!", SimpleEncryption.Decrypt("This is a test!", -1));
     Assert.AreEqual("This kata is very interesting!",
                     SimpleEncryption.Decrypt("hskt svr neetn!Ti aai eyitrsig", 1));
 }
Ejemplo n.º 7
0
        public void TestDecryptSingleCharStringToString()
        {
            IEncryption simpleEncryption = new SimpleEncryption();

            string plainText = "a";

            string encryptedText = simpleEncryption.EncryptToString(plainText);
            string decryptedText = simpleEncryption.Decrypt(encryptedText);

            //Make sure that we are able to get back the same plain text
            Assert.AreEqual(plainText, decryptedText);
        }
Ejemplo n.º 8
0
        private void InitializeOptions()
        {
            _iconListManager = new IconListManager(imageList16, IconReader.IconSize.Small);

            _cfgs                  = new Configs(BindingFile.DatabaseFile);
            _autoSelectArchi       = _cfgs.Get <bool>("AutoSelectArchitecture");
            _setPassword           = _cfgs.Get <bool>("SetPassword");
            _isShowEnterCmd        = _cfgs.Get <bool>("ShowEnterCmd");
            _isKillProcesses       = _cfgs.Get <bool>("KillProcess");
            _operationalStatusOnly = _cfgs.Get <bool>("OperationalStatus");
            menuToolbar.Checked    = _cfgs.Get <bool>("Toolbar");
            menuStatusbar.Checked  = _cfgs.Get <bool>("Statusbar");
            listViewBind.GridLines = menuGridlines.Checked = _cfgs.Get <bool>("Gridlines");

            int pingCount = _cfgs.Get <int>("PingCount");

            if (pingCount >= 4 && pingCount <= 100)
            {
                _pingCount = pingCount;
            }
            _responseDelay = _cfgs.Get <int>("ResponseDelay");

            Color cmdcolor = _cfgs.Get <Color>("CommandColor");

            if (cmdcolor != null)
            {
                _cmdColor = cmdcolor;
            }
            Font cmdFont = _cfgs.Get <Font>("CommandFont");

            if (cmdFont != null)
            {
                _cmdFont = cmdFont;
            }

            listBoxLog.Font    = _cmdFont;
            menuXPLook.Checked = _cfgs.Get <bool>("XPLook");
            if (menuXPLook.Checked)
            {
                menuStripBind.RenderMode = ToolStripRenderMode.System;
                toolStripBind.RenderMode = ToolStripRenderMode.System;
            }
            else
            {
                menuStripBind.RenderMode = ToolStripRenderMode.Professional;
                toolStripBind.RenderMode = ToolStripRenderMode.Professional;
            }
            _password = _cfgs.Get <string>("MasterPassword");
            _password = SimpleEncryption.Decrypt(_password);
        }
Ejemplo n.º 9
0
        private void Setup_Load(object sender, EventArgs e)
        {
            check_service_state getstate = new check_service_state();
            string cur_service_state     = getstate.get_state("logon_server_service");

            if (cur_service_state.Equals("Running") || cur_service_state.Equals("Starting"))
            {
                service_install_but.Text    = "Удалить сервис";
                service_control_but.Text    = "Остановить сервис";
                service_control_but.Enabled = true;
            }
            else if (cur_service_state.Equals("Not found"))
            {
                service_install_but.Text    = "Установить сервис";
                service_control_but.Enabled = false;
            }
            else
            {
                service_install_but.Text    = "Удалить сервис";
                service_control_but.Text    = "Запустить сервис";
                service_control_but.Enabled = true;
            }
            SimpleEncryption decrypt = new SimpleEncryption("password");

            string[] splited = new string[3];

            if (logon_class.Properties.Settings.Default.encrypted.Equals("1"))
            {
                splited                  = (decrypt.Decrypt(logon_class.Properties.Settings.Default.db)).Split('=', ';');
                db.Text                  = splited[1];
                splited                  = (decrypt.Decrypt(logon_class.Properties.Settings.Default.catalog)).Split('=', ';');
                catalog.Text             = splited[1];
                splited                  = (decrypt.Decrypt(logon_class.Properties.Settings.Default.security)).Split('=', ';');
                security.SelectedItem    = splited[1];
                security.Text            = splited[1];
                splited                  = decrypt.Decrypt(logon_class.Properties.Settings.Default.user).Split('=', ';');
                user.Text                = splited[1];
                splited                  = decrypt.Decrypt((logon_class.Properties.Settings.Default.password)).Split('=', ';');
                password.Text            = splited[1];
                default_time_picker.Text = decrypt.Decrypt(logon_class.Properties.Settings.Default.default_service_time);
            }
            else
            {
                splited                  = (logon_class.Properties.Settings.Default.db).Split('=', ';');
                db.Text                  = splited[1];
                splited                  = (logon_class.Properties.Settings.Default.catalog).Split('=', ';');
                catalog.Text             = splited[1];
                splited                  = (logon_class.Properties.Settings.Default.security).Split('=', ';');
                security.SelectedItem    = splited[1];
                security.Text            = splited[1];
                splited                  = (logon_class.Properties.Settings.Default.user).Split('=', ';');
                user.Text                = splited[1];
                splited                  = (logon_class.Properties.Settings.Default.password).Split('=', ';');
                password.Text            = splited[1];
                default_time_picker.Text = logon_class.Properties.Settings.Default.default_service_time;
            }
        }
Ejemplo n.º 10
0
        static public String GetSqlString()
        {
            SimpleEncryption decrypt = new SimpleEncryption("password");

            if (logon_class.Properties.Settings.Default.encrypted.Equals("1"))
            {
                string connection = decrypt.Decrypt(logon_class.Properties.Settings.Default.db) + decrypt.Decrypt(logon_class.Properties.Settings.Default.catalog) + decrypt.Decrypt(logon_class.Properties.Settings.Default.security) + decrypt.Decrypt(logon_class.Properties.Settings.Default.user) + decrypt.Decrypt(logon_class.Properties.Settings.Default.password);
                return(connection);
            }
            else
            {
                string connection = logon_class.Properties.Settings.Default.db + logon_class.Properties.Settings.Default.catalog + logon_class.Properties.Settings.Default.security + logon_class.Properties.Settings.Default.user + logon_class.Properties.Settings.Default.password;
                return(connection);
            }
        }
Ejemplo n.º 11
0
        private void InitOptions()
        {
            _password = _cfgs.Get <string>("MasterPassword");
            if (!string.IsNullOrEmpty(_password))
            {
                try {
                    _password = SimpleEncryption.Decrypt(_password);
                } catch {
                    _password = string.Empty;
                }
                linkChange.Visible = (!string.IsNullOrEmpty(_password));
            }
            int pingCount = _cfgs.Get <int>("PingCount");

            if (pingCount > 0)
            {
                numericUpDownPingCount.Value = pingCount;
            }
            int delay = _cfgs.Get <int>("ResponseDelay");

            if (delay >= 0)
            {
                numericUpDownDelay.Value = delay;
            }
            Color bc = _cfgs.Get <Color>("CommandColor");

            if (bc != null)
            {
                btnColor.BackColor = bc;
                btnColor.Text      = bc.Name;
            }
            Font cf = _cfgs.Get <Font>("CommandFont");

            if (cf != null)
            {
                btnFont.Font = cf;
                btnFont.Text = cf.Name;
            }

            chkAutoSelecteArch.Checked   = _cfgs.Get <bool>("AutoSelectArchitecture");
            chkClearBindList.Checked     = _cfgs.Get <bool>("ClearBindList");
            chkSetPassword.Checked       = _cfgs.Get <bool>("SetPassword");
            chkOperationalStatus.Checked = _cfgs.Get <bool>("OperationalStatus");
            chkEnterCmd.Checked          = _cfgs.Get <bool>("ShowEnterCmd");
            chkKillProcess.Checked       = _cfgs.Get <bool>("KillProcess");
        }
Ejemplo n.º 12
0
 private void SetPassword(string password)
 {
     using (PasswordForm pwd = new PasswordForm(password)) {
         if (pwd.ShowDialog().Equals(DialogResult.OK))
         {
             Cursor.Current = Cursors.WaitCursor;
             _cfgs.Set <string>("MasterPassword", SimpleEncryption.Encrypt(pwd.Password));
             _password      = _cfgs.Get <string>("MasterPassword");
             _password      = SimpleEncryption.Decrypt(_password);
             Cursor.Current = Cursors.Default;
         }
         else
         {
             chkSetPassword.Checked = false;
         }
     }
 }
Ejemplo n.º 13
0
        public List <Credential> GetCredentials()
        {
            DataTable dt = sqlite.Select(string.Format(Queries.SELECT_TABLE_DESC, defaultTable, "ID"));

            List <Credential> pwds = new List <Credential>();

            if (dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    Credential cmd = new Credential()
                    {
                        ID          = dr["ID"].ToSafeInteger(),
                        Username    = SimpleEncryption.Decrypt(dr["Username"].ToSafeString()),
                        Description = SimpleEncryption.Decrypt(dr["Description"].ToSafeString()),
                        PassKey     = SimpleEncryption.Decrypt(dr["PassKey"].ToSafeString()),
                        Code        = dr["Code"].ToSafeString()
                    };
                    pwds.Add(cmd);
                }
            }
            return(pwds);
        }
Ejemplo n.º 14
0
        public void LongEncryptionStringTest()
        {
            var encryption = new SimpleEncryption(new string('c', 200));

            Assert.AreEqual("A", encryption.Decrypt(encryption.Encrypt("A")));
        }
Ejemplo n.º 15
0
 public void NullTests()
 {
     Assert.AreEqual(null, SimpleEncryption.Encrypt(null, 0));
     Assert.AreEqual(null, SimpleEncryption.Decrypt(null, 0));
 }
Ejemplo n.º 16
0
 public void EmptyTests()
 {
     Assert.AreEqual("", SimpleEncryption.Encrypt("", 0));
     Assert.AreEqual("", SimpleEncryption.Decrypt("", 0));
 }
Ejemplo n.º 17
0
        private void SettingsForm_Load(object sender, EventArgs e)
        {
            string[] idleTime = new string[3];
            try
            {
                idleTime   = logon_class.get_settings.get_idle_time();
                idle_time  = idleTime[0];
                wStartTime = idleTime[1];
                wEndTime   = idleTime[2];
            }
            catch (Exception ex)
            {
                MessageBox.Show("Произошла ошибка при получении времени простоя: \n" + ex.ToString());
                idle_time  = "00:05:00";
                wStartTime = "09:00:00";
                wEndTime   = "18:00:00";
            }

            SimpleEncryption decrypt = new SimpleEncryption("password");

            string[] splited = new string[3];
            if (logon_class.Properties.Settings.Default.encrypted.Equals("1"))
            {
                splited               = (decrypt.Decrypt(logon_class.Properties.Settings.Default.db)).Split('=', ';');
                db.Text               = splited[1];
                splited               = (decrypt.Decrypt(logon_class.Properties.Settings.Default.catalog)).Split('=', ';');
                catalog.Text          = splited[1];
                splited               = (decrypt.Decrypt(logon_class.Properties.Settings.Default.security)).Split('=', ';');
                security.SelectedItem = splited[1];
                security.Text         = splited[1];
                splited               = decrypt.Decrypt(logon_class.Properties.Settings.Default.user).Split('=', ';');
                user.Text             = splited[1];
                splited               = decrypt.Decrypt((logon_class.Properties.Settings.Default.password)).Split('=', ';');
                password.Text         = splited[1];
                if (decrypt.Decrypt((logon_class.Properties.Settings.Default.default_time)).Equals("month"))
                {
                    date.SelectedItem = "Месяц";
                    date.Text         = "Месяц";
                }
                else if (decrypt.Decrypt(logon_class.Properties.Settings.Default.default_time).Equals("week"))
                {
                    date.SelectedItem = "Неделю";
                    date.Text         = "Неделю";
                }
                else if (decrypt.Decrypt(logon_class.Properties.Settings.Default.default_time).Equals("day"))
                {
                    date.SelectedItem = "День";
                    date.Text         = "День";
                }
            }
            else
            {
                splited               = (logon_class.Properties.Settings.Default.db).Split('=', ';');
                db.Text               = splited[1];
                splited               = (logon_class.Properties.Settings.Default.catalog).Split('=', ';');
                catalog.Text          = splited[1];
                splited               = (logon_class.Properties.Settings.Default.security).Split('=', ';');
                security.SelectedItem = splited[1];
                security.Text         = splited[1];
                splited               = (logon_class.Properties.Settings.Default.user).Split('=', ';');
                user.Text             = splited[1];
                splited               = (logon_class.Properties.Settings.Default.password).Split('=', ';');
                password.Text         = splited[1];
                if (logon_class.Properties.Settings.Default.default_time.Equals("month"))
                {
                    date.SelectedItem = "Месяц";
                    date.Text         = "Месяц";
                }
                else if (logon_class.Properties.Settings.Default.default_time.Equals("week"))
                {
                    date.SelectedItem = "Неделю";
                    date.Text         = "Неделю";
                }
                else if (logon_class.Properties.Settings.Default.default_time.Equals("day"))
                {
                    date.SelectedItem = "День";
                    date.Text         = "День";
                }
            }
            default_time_picker.Text = idle_time;
            workStartTime.Text       = wStartTime;
            workEndTime.Text         = wEndTime;
        }
Ejemplo n.º 18
0
        public void BlankEncryptionStringTest()
        {
            var encryption = new SimpleEncryption("");

            Assert.AreEqual("A", encryption.Decrypt(encryption.Encrypt("A")));
        }
Ejemplo n.º 19
0
        public void ShortEncryptionStringTest()
        {
            var encryption = new SimpleEncryption("ab325-sdf21");

            Assert.AreEqual("A", encryption.Decrypt(encryption.Encrypt("A")));
        }
Ejemplo n.º 20
0
        private void Form1_Load(object sender, EventArgs e)
        {
            SimpleEncryption decrypt = new SimpleEncryption("password");

            if (!checkPodrobn.Checked)
            {
                showPodrobn = false;
            }
            if (!checkBox2.Checked)
            {
                showAll = false;
            }
            this.userstats.Visible = false;
            if (date_changed == false)
            {
                if (logon_class.Properties.Settings.Default.encrypted.Equals("1"))
                {
                    if (decrypt.Decrypt(logon_class.Properties.Settings.Default.default_time).Equals("month"))
                    {
                        startdate.Value = new DateTime(startdate.Value.Year, startdate.Value.Month, 1);
                    }
                    else if (decrypt.Decrypt(logon_class.Properties.Settings.Default.default_time).Equals("week"))
                    {
                        startdate.Value = DateTime.Now.Date.AddDays(-6);
                    }
                    else if (decrypt.Decrypt(logon_class.Properties.Settings.Default.default_time).Equals("day"))
                    {
                        startdate.Value = DateTime.Now.Date;
                    }
                }
                else
                {
                    if (logon_class.Properties.Settings.Default.default_time.Equals("month"))
                    {
                        startdate.Value = new DateTime(startdate.Value.Year, startdate.Value.Month, 1);
                    }
                    else if (logon_class.Properties.Settings.Default.default_time.Equals("week"))
                    {
                        startdate.Value = DateTime.Now.Date.AddDays(-6);
                    }
                    else if (logon_class.Properties.Settings.Default.default_time.Equals("day"))
                    {
                        startdate.Value = DateTime.Now.Date;
                    }
                }
            }
            int i;

            k = 0;
            string begin = startdate.ToString();
            string end   = enddate.ToString();

            if (is_rdp == null)
            {
                is_rdp = "0";
            }
            //if (username == null) username = "******";
            if (username == null)
            {
                username = "******";
            }
            //заполняем список пользователей
            if (comboBox1.Items.Count < 1)
            {
                comboBox1.Items.Clear();
                comboBox1.Items.Add("все пользователи");
                i = 0;
                while (spisok_polzovateley().Length > i)
                {
                    comboBox1.Items.Add(spisok_polzovateley()[i].ToString());
                    i++;
                }
            }

            k = 0;
            string sql = "";

            //диапазон дат
            mindate = startdate.Value.ToString("yyyy-MM-dd");
            maxdate = enddate.Value.ToString("yyyy-MM-dd");
            //вывод всех
            try
            {
                DataSet ds = new DataSet();
                if (checkBox2.Checked)
                {
                    sql = "exec showall @mindate='" + mindate + "', @maxdate='" + maxdate + "', @is_rdp=" + is_rdp + ", @username="******"";
                    k   = 0;
                    ds  = dsfill(sql, ds);
                }

                else if (showPodrobn)
                {
                    //вывод с РДП
                    if (checkBox1.Checked)
                    {
                        sql = "exec showrdp @mindate='" + mindate + "', @maxdate='" + maxdate + "', @username="******"";
                        k   = 1;
                        ds  = dsfill(sql, ds);
                    }
                    //вывод мин
                    else
                    {
                        sql = "exec showmin @mindate='" + mindate + "', @maxdate='" + maxdate + "', @username="******"";
                        k   = 1;
                        ds  = dsfill(sql, ds);
                    }
                }
                //не подробный вывод
                else
                {
                    //sql = ("select userdatetime from dbuserloginmin where username='******' and cast(userdatetime as date)='31.05.2016'");
                    sql = "ShowMinNePodrobno @is_rdp=" + is_rdp + ", @mindate='" + mindate + "', @maxdate='" + maxdate + "';";
                    ds  = dsfill(sql, ds);
                    k   = 2;
                }



                dataGridView1.Columns.Clear();
                dataGridView1.DataSource = ds;
                dataGridView1.DataMember = "table";



                //форматирование datagridview
                if (k == 0)
                {
                    this.dataGridView1.Columns[3].DefaultCellStyle.Format = @"hh\:mm\:ss";
                    RowsColor(5);
                }
                if (k == 1)
                {
                    this.dataGridView1.Columns[2].DefaultCellStyle.Format = @"hh\:mm\:ss";
                    this.dataGridView1.Columns[3].DefaultCellStyle.Format = @"hh\:mm\:ss";
                    this.dataGridView1.Columns[4].Visible = false;
                    RowsColor(4);
                }
                if (k == 2)
                {
                    dataGridView1.AutoGenerateColumns = true;
                    add_columns();
                    dataGridView1.Columns["times"].Visible   = false;
                    dataGridView1.Columns["surname"].Visible = false;
                    // dataGridView1.Columns[3].Visible = false;
                }

                //информация о пользователе
                if (!username.Equals("'%'"))
                {
                    this.userstats.Visible = true;
                    string show = "За выбранный промежуток времени \n";
                    show += "Время на работе - " + sum_time(mindate, maxdate, username, is_rdp)[1] + "\n";
                    show += "Время за компьютером - " + sum_time(mindate, maxdate, username, is_rdp)[0] + "\n";
                    show += "Раз опоздал/раньше ушел - " + sum_time(mindate, maxdate, username, is_rdp)[2] + "\n";
                    show += "Раз недоработал - " + sum_time(mindate, maxdate, username, is_rdp)[3] + "\n";
                    this.userstats.Text = show;
                }
                resize_elements();
                send = ds;
                this.graphic.Refresh();
            }
            catch (Exception ex)
            {
                //  MessageBox.Show(ex.ToString());
            }
        }
        public void DecryptTest()
        {
            string actual = _SimpleEncryption.Decrypt(ENCRYPTED_TEXT);

            Assert.AreEqual(PLAIN_TEXT, actual);
        }