Exemplo n.º 1
0
        private void FrmUsrInfo_Load(object sender, EventArgs e)
        {
            // Add columnts to DataGridView and set it right
            var textColumn = new DataGridViewTextBoxColumn();

            textColumn.Name       = "Группая Объектов";
            textColumn.FillWeight = 16;
            textColumn.ReadOnly   = true;
            dgvPrivileges.Columns.Add(textColumn);

            var cmbColumn = new DataGridViewComboBoxColumn();

            cmbColumn.Name       = "Уровень доступа";
            cmbColumn.FillWeight = 8;
            cmbColumn.FlatStyle  = FlatStyle.Flat;
            dgvPrivileges.Columns.Add(cmbColumn);
            dgvPrivileges.SelectionMode       = DataGridViewSelectionMode.FullRowSelect;
            dgvPrivileges.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
            cmbColumn.Items.AddRange(levels);

            // Populating the organisations combobox
            cmbOrganisations.Items.Clear();
            foreach (xOrganisation xorg in _Dh.myOrganisations)
            {
                cmbOrganisations.Items.Add(xorg.Name);
            }
            cmbOrganisations.SelectedIndex = 0;

            // Should it load data to DataGridView or is it new user with no data to fill?
            if (wUser != null)
            {
                fillTheForm(); fillDgvObGroups(true);
            }
            else
            {
                wUser = new xUser(); fillDgvObGroups(false);
            }

            // Cam I grant moderators rights to this user?
            if (_Dh.myAccount.isAdmin())
            {
                chkIsModerator.Visible = true;
            }

            // Prevent from downgrading the admins permissions by someone else
            if (wUser.isAdmin())
            {
                chkIsModerator.Visible = false;
            }

            // Has this user a moderator privileges?
            if (wUser.IsModerator)
            {
                chkIsModerator.Checked = true;
            }
        }
Exemplo n.º 2
0
        public static void loadUsers()
        {
            using (MySqlConnection connection = new MySqlConnection(connectionString()))
            {
                try
                {
                    connection.Open();
                    MySqlDataReader reader;

                    var cmd = new MySqlCommand("SELECT * from `users`", connection);
                    reader = cmd.ExecuteReader();


                    _Dh.myUsers = new List <xUser>();
                    while (reader.Read())
                    {
                        xUser x = new xUser()
                        {
                            Id          = sfIntReader(reader, "id"),
                            OrgId       = sfIntReader(reader, "orgid"),
                            Firstname   = sfStringReader(reader, "firstname"),
                            Lastname    = sfStringReader(reader, "lastname"),
                            Patronym    = sfStringReader(reader, "patronym"),
                            Login       = sfStringReader(reader, "login"),
                            Password    = sfStringReader(reader, "password"),
                            Pict64      = sfStringReader(reader, "pict64"),
                            Phone       = sfStringReader(reader, "phone"),
                            Email       = sfStringReader(reader, "email"),
                            C_Date      = sfStringReader(reader, "c_date"),
                            IsModerator = (sfIntReader(reader, "ismoderator") == 1) ? true : false
                        };
                        string s = sfStringReader(reader, "permissions");
                        x.Permissions = getPermissions(s);
                        _Dh.myUsers.Add(x);
                    }
                    reader.Close();
                }
                catch (MySqlException ex)
                {
                    if (ex.Number == 1146)
                    {
                        if (_Dh.msgQuestion("В выбранной БД отсутствуют необходимые таблицы, хотите создать их сейчас?") == DialogResult.Yes)
                        {
                            createTables();
                            System.Threading.Thread.Sleep(2000);
                            loadUsers();
                        }
                    }
                    else
                    {
                        err_processor(ex);
                    }
                }
            }
        }
Exemplo n.º 3
0
 private void panel1_DoubleClick(object sender, EventArgs e)
 {
     if (ofdPictPicker.ShowDialog() == System.Windows.Forms.DialogResult.OK)
     {
         if (wUser == null)
         {
             wUser = new xUser();
         }
         wUser.Pict64 = ImageToBase64(ofdPictPicker.FileName);
     }
 }
Exemplo n.º 4
0
 public static AccessLevel getGroupAccessLevel(xUser u, xObGroup g)
 {
     try
     {
         if (u.IsModerator)
         {
             return(AccessLevel.Remove);
         }
         return(u.Permissions[g.Id]);
     }
     catch (KeyNotFoundException kex)
     {
         return(AccessLevel.Read);
     }
     catch (Exception ex)
     {
         err_processor(ex);
         return(AccessLevel.None);
     }
 }
Exemplo n.º 5
0
        private void btnOk_Click(object sender, EventArgs e)
        {
            wUser.Firstname = txtFirstname.Text;
            wUser.Lastname  = txtLastname.Text;
            wUser.Patronym  = txtPatronymic.Text;
            wUser.Phone     = txtPhone.Text;
            wUser.Email     = txtEmail.Text;
            wUser.OrgId     = _Dh.myOrganisations[cmbOrganisations.SelectedIndex].Id;

            // Check if it is new user or not
            if (wUser.Id > 0)
            {
                // Write to DB
                using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(_Dh.connectionString()))
                {
                    wUser.Permissions.Clear();

                    // Prepare permissions string representation
                    string str_permissions = "";
                    for (int i = 0; i < _Dh.myObGroups.Count; i++)
                    {
                        string si            = (string)dgvPrivileges.Rows[i].Cells[1].Value;
                        int    selectedIndex = Array.IndexOf(levels, si, 0);
                        wUser.Permissions.Add(_Dh.myObGroups[i].Id, (_Dh.AccessLevel)selectedIndex);
                        str_permissions += _Dh.myObGroups[i].Id + "-" + ((int)wUser.Permissions[_Dh.myObGroups[i].Id]) + ";";
                    }
                    try
                    {
                        connection.Open();
                        {
                            byte isModerator = wUser.IsModerator ? (byte)1 : (byte)0;


                            MySqlCommand comm = new MySqlCommand();
                            comm.CommandText = @"UPDATE users SET orgid=@orgid,login=@login,password=@password,firstname=@firstname,lastname=@lastname,patronym=@patronym,permissions=@permissions,pict64=@pict64,phone=@phone,email=@email,ismoderator=@ismoderator,c_date=@c_date WHERE id=@id";
                            comm.Parameters.AddWithValue("@id", wUser.Id);
                            comm.Parameters.AddWithValue("@orgid", wUser.OrgId);
                            comm.Parameters.AddWithValue("@login", wUser.Login);
                            comm.Parameters.AddWithValue("@password", wUser.Password);
                            comm.Parameters.AddWithValue("@firstname", wUser.Firstname);
                            comm.Parameters.AddWithValue("@lastname", wUser.Lastname);
                            comm.Parameters.AddWithValue("@patronym", wUser.Patronym);
                            comm.Parameters.AddWithValue("@permissions", str_permissions);
                            comm.Parameters.AddWithValue("@pict64", wUser.Pict64);
                            comm.Parameters.AddWithValue("@phone", wUser.Phone);
                            comm.Parameters.AddWithValue("@email", wUser.Email);
                            comm.Parameters.AddWithValue("@ismoderator", isModerator);
                            comm.Parameters.AddWithValue("@c_date", wUser.C_Date);
                            _Dh.dbExecute(comm);
                        }
                    }
                    catch (Exception ex) { _Dh.err_processor(ex); }
                }
                _Dh.msgInformation("Данные пользователя обновлены!");
            }
            else
            {
                // Password
                var pg = new PasswordGenerator();
                pg.Minimum        = 6;
                pg.Maximum        = 6;
                pg.ExcludeSymbols = true;
                txtPassword.Text  = pg.Generate();

                // Initialize user object from input
                wUser = new xUser()
                {
                    Firstname = txtFirstname.Text, Lastname = txtLastname.Text, Patronym = txtPatronymic.Text, Password = txtPassword.Text, Phone = txtPhone.Text, Email = txtEmail.Text, IsModerator = chkIsModerator.Checked, C_Date = _Dh.rightNow
                };

                // Login
                Random rnd = new Random(DateTime.Now.Millisecond);
                wUser.Login   = wUser.Lastname + "_" + wUser.Firstname[0] + rnd.Next(10, 99);
                txtLogin.Text = wUser.Login;

                // Write to DB
                using (MySql.Data.MySqlClient.MySqlConnection connection = new MySql.Data.MySqlClient.MySqlConnection(_Dh.connectionString()))
                {
                    // Prepare permissions string representation
                    string str_permissions = "";
                    for (int i = 0; i < _Dh.myObGroups.Count; i++)
                    {
                        string si            = (string)dgvPrivileges.Rows[i].Cells[1].Value;
                        int    selectedIndex = Array.IndexOf(levels, si, 0);
                        wUser.Permissions.Add(_Dh.myObGroups[i].Id, (_Dh.AccessLevel)selectedIndex);
                        str_permissions += _Dh.myObGroups[i].Id + "-" + ((int)wUser.Permissions[_Dh.myObGroups[i].Id]) + ";";
                    }
                    try
                    {
                        connection.Open();
                        {
                            byte isModerator = wUser.IsModerator ? (byte)1 : (byte)0;


                            MySqlCommand comm = new MySqlCommand();
                            comm.CommandText = "INSERT INTO users(login,password,firstname,lastname,patronym,permissions,pict64,phone,email,ismoderator,c_date) VALUES(@login,@password,@firstname,@lastname,@patronym,@permissions,@pict64,@phone,@email,@ismoderator,@c_date)";
                            comm.Parameters.AddWithValue("@orgid", wUser.OrgId);
                            comm.Parameters.AddWithValue("@login", wUser.Login);
                            comm.Parameters.AddWithValue("@password", wUser.Password);
                            comm.Parameters.AddWithValue("@firstname", wUser.Firstname);
                            comm.Parameters.AddWithValue("@lastname", wUser.Lastname);
                            comm.Parameters.AddWithValue("@patronym", wUser.Patronym);
                            comm.Parameters.AddWithValue("@permissions", str_permissions);
                            comm.Parameters.AddWithValue("@pict64", wUser.Pict64);
                            comm.Parameters.AddWithValue("@phone", wUser.Phone);
                            comm.Parameters.AddWithValue("@email", wUser.Email);
                            comm.Parameters.AddWithValue("@ismoderator", isModerator);
                            comm.Parameters.AddWithValue("@c_date", wUser.C_Date);

                            wUser.Id = _Dh.dbExecute(comm);
                        }
                    }
                    catch (Exception ex) { _Dh.err_processor(ex); }
                }
                _Dh.myUsers.Add(wUser);
                _Dh.msgInformation("Пользователь успешно добавлен!");
            }
            Close();
        }