コード例 #1
0
        public void Fill()
        {
            SqlConnection connection = new SqlConnection(connectionString);

            try
            {
                connection.Open();
                SqlDataReader dataReader;
                string        sql     = "SELECT * FROM type_user";
                SqlCommand    command = new SqlCommand(sql, connection);
                dataReader = command.ExecuteReader();
                while (dataReader.Read())
                {
                    TypeUserDB obj = new TypeUserDB();
                    obj.id                   = Convert.ToInt32(dataReader.GetValue(0));
                    obj.name                 = Convert.ToString(dataReader.GetValue(1));
                    obj.description          = Convert.ToString(dataReader.GetValue(2));
                    obj.comment              = Convert.ToString(dataReader.GetValue(3));
                    obj.perm_test_create     = Convert.ToBoolean(dataReader.GetValue(4));
                    obj.perm_test_edit       = Convert.ToBoolean(dataReader.GetValue(5));
                    obj.perm_test_delete     = Convert.ToBoolean(dataReader.GetValue(6));
                    obj.perm_protocol_create = Convert.ToBoolean(dataReader.GetValue(7));
                    obj.perm_protocol_edit   = Convert.ToBoolean(dataReader.GetValue(8));
                    obj.perm_protocol_delete = Convert.ToBoolean(dataReader.GetValue(9));
                    obj.perm_set_examiner    = Convert.ToBoolean(dataReader.GetValue(10));
                    obj.perm_user_management = Convert.ToBoolean(dataReader.GetValue(11));
                    obj.m_yk                 = Convert.ToBoolean(dataReader.GetValue(12));
                    obj.m_pk                 = Convert.ToBoolean(dataReader.GetValue(13));
                    obj.m_vik                = Convert.ToBoolean(dataReader.GetValue(14));
                    obj.m_pvk                = Convert.ToBoolean(dataReader.GetValue(15));
                    obj.m_ek                 = Convert.ToBoolean(dataReader.GetValue(16));
                    obj.m_mk                 = Convert.ToBoolean(dataReader.GetValue(17));
                    obj.m_ae                 = Convert.ToBoolean(dataReader.GetValue(18));
                    obj.m_tk                 = Convert.ToBoolean(dataReader.GetValue(19));
                    obj.m_pvt                = Convert.ToBoolean(dataReader.GetValue(20));
                    obj.m_yt                 = Convert.ToBoolean(dataReader.GetValue(21));
                    obj.m_vd                 = Convert.ToBoolean(dataReader.GetValue(22));
                    obj.auto_exam            = Convert.ToBoolean(dataReader.GetValue(23));
                    obj.o1                   = Convert.ToBoolean(dataReader.GetValue(24));
                    obj.o2                   = Convert.ToBoolean(dataReader.GetValue(25));
                    obj.o3                   = Convert.ToBoolean(dataReader.GetValue(26));
                    obj.o4                   = Convert.ToBoolean(dataReader.GetValue(27));
                    obj.o5                   = Convert.ToBoolean(dataReader.GetValue(28));
                    obj.o6                   = Convert.ToBoolean(dataReader.GetValue(29));
                    obj.o7                   = Convert.ToBoolean(dataReader.GetValue(30));
                    obj.o8                   = Convert.ToBoolean(dataReader.GetValue(31));
                    obj.o9                   = Convert.ToBoolean(dataReader.GetValue(32));
                    obj.o10                  = Convert.ToBoolean(dataReader.GetValue(33));
                    obj.o11                  = Convert.ToBoolean(dataReader.GetValue(34));
                    obj.o12                  = Convert.ToBoolean(dataReader.GetValue(34));

                    list_objects.Add(obj);
                    obj = null;
                }
                connection.Close();
            }
            catch (Exception ex)
            {
            }
        }
コード例 #2
0
        private void btnConfirm_Click_1(object sender, EventArgs e)
        {
            TypeUserDB obj = new TypeUserDB();

            obj.AddToDB(tbNameTypeUser.Text);
            UserTypes ut = new UserTypes(1);

            ut.Show();
            this.Close();
        }
コード例 #3
0
        public UserTypes(int type_selected_id)
        {
            InitializeComponent();
            int        index = type_selected_id;
            TypeUserDB obj   = new TypeUserDB();

            obj.Fill();


            Dictionary <string, string> user_types_list = new Dictionary <string, string>();

            for (int i = 0; i < obj.list_objects.Count; i++)
            {
                user_types_list.Add(obj.list_objects[i].id.ToString(), obj.list_objects[i].name);
            }

            cbUserTypes.DataSource    = new BindingSource(user_types_list, null);
            cbUserTypes.DisplayMember = "Value";
            cbUserTypes.ValueMember   = "Key";
            cbUserTypes.SelectedIndex = index;

            // Заполним дефолтные параметры
            description.Text             = obj.list_objects[0].description;
            perm_test_create.Checked     = obj.list_objects[0].perm_test_create;
            perm_test_edit.Checked       = obj.list_objects[0].perm_test_edit;
            perm_test_delete.Checked     = obj.list_objects[0].perm_test_delete;
            perm_protocol_create.Checked = obj.list_objects[0].perm_protocol_create;
            perm_protocol_delete.Checked = obj.list_objects[0].perm_protocol_delete;
            perm_set_examiner.Checked    = obj.list_objects[0].perm_set_examiner;
            perm_user_management.Checked = obj.list_objects[0].perm_user_management;
            m_yk.Checked      = obj.list_objects[0].m_yk;
            m_pk.Checked      = obj.list_objects[0].m_pk;
            m_vik.Checked     = obj.list_objects[0].m_vik;
            m_pvk.Checked     = obj.list_objects[0].m_pvk;
            m_ek.Checked      = obj.list_objects[0].m_ek;
            m_mk.Checked      = obj.list_objects[0].m_mk;
            m_ae.Checked      = obj.list_objects[0].m_ae;
            m_tk.Checked      = obj.list_objects[0].m_tk;
            m_pvt.Checked     = obj.list_objects[0].m_pvt;
            m_yt.Checked      = obj.list_objects[0].m_yt;
            m_vd.Checked      = obj.list_objects[0].m_vd;
            auto_exam.Checked = obj.list_objects[0].auto_exam;
            o1.Checked        = obj.list_objects[0].o1;
            o2.Checked        = obj.list_objects[0].o2;
            o3.Checked        = obj.list_objects[0].o3;
            o4.Checked        = obj.list_objects[0].o4;
            o5.Checked        = obj.list_objects[0].o5;
            o6.Checked        = obj.list_objects[0].o6;
            o7.Checked        = obj.list_objects[0].o7;
            o8.Checked        = obj.list_objects[0].o8;
            o9.Checked        = obj.list_objects[0].o9;
            o10.Checked       = obj.list_objects[0].o10;
            o11.Checked       = obj.list_objects[0].o11;
            o12.Checked       = obj.list_objects[0].o12;
        }
コード例 #4
0
        private void btnConfirm_Click_1(object sender, EventArgs e)
        {
            TypeUserDB obj = new TypeUserDB();

            obj.id                   = Convert.ToInt32(((KeyValuePair <string, string>)cbUserTypes.SelectedItem).Key);
            obj.name                 = Convert.ToString(((KeyValuePair <string, string>)cbUserTypes.SelectedItem).Value);
            obj.description          = description.Text;
            obj.perm_test_create     = perm_test_create.Checked;
            obj.perm_test_edit       = perm_test_edit.Checked;
            obj.perm_test_delete     = perm_test_delete.Checked;
            obj.perm_protocol_create = perm_protocol_create.Checked;
            obj.perm_protocol_delete = perm_protocol_delete.Checked;
            obj.perm_set_examiner    = perm_set_examiner.Checked;
            obj.perm_user_management = perm_user_management.Checked;
            obj.m_yk                 = m_yk.Checked;
            obj.m_pk                 = m_pk.Checked;
            obj.m_vik                = m_vik.Checked;
            obj.m_pvk                = m_pvk.Checked;
            obj.m_ek                 = m_ek.Checked;
            obj.m_mk                 = m_mk.Checked;
            obj.m_ae                 = m_ae.Checked;
            obj.m_tk                 = m_tk.Checked;
            obj.m_pvt                = m_pvt.Checked;
            obj.m_yt                 = m_yt.Checked;
            obj.m_vd                 = m_vd.Checked;
            obj.auto_exam            = auto_exam.Checked;
            obj.o1                   = o1.Checked;
            obj.o2                   = o2.Checked;
            obj.o3                   = o3.Checked;
            obj.o4                   = o4.Checked;
            obj.o5                   = o5.Checked;
            obj.o6                   = o6.Checked;
            obj.o7                   = o7.Checked;
            obj.o8                   = o8.Checked;
            obj.o9                   = o9.Checked;
            obj.o10                  = o10.Checked;
            obj.o11                  = o11.Checked;
            obj.o12                  = o12.Checked;

            obj.Save();

            //this.Close();
        }
コード例 #5
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            this.Close();
            DialogResult dr = MessageBox.Show("Вы уверены, что хотите удалить объект?", "Вопрос", MessageBoxButtons.YesNo);

            switch (dr)
            {
            case DialogResult.Yes:
                TypeUserDB obj = new TypeUserDB();
                obj.Delete(Convert.ToInt32(((KeyValuePair <string, string>)cbUserTypes.SelectedItem).Key));

                UserTypes ut = new UserTypes(1);
                ut.Show();
                break;

            case DialogResult.No:
                break;
            }
        }
コード例 #6
0
        private void cbUserTypes_SelectedIndexChanged(object sender, EventArgs e)
        {
            int user_type_id   = 1;
            int selected_index = 0;

            user_type_id   = Convert.ToInt32(((KeyValuePair <string, string>)cbUserTypes.SelectedItem).Key);
            selected_index = cbUserTypes.SelectedIndex;
            TypeUserDB obj = new TypeUserDB(user_type_id);

            description.Text             = obj.description;
            perm_test_create.Checked     = obj.perm_test_create;
            perm_test_edit.Checked       = obj.perm_test_edit;
            perm_test_delete.Checked     = obj.perm_test_delete;
            perm_protocol_create.Checked = obj.perm_protocol_create;
            perm_protocol_delete.Checked = obj.perm_protocol_delete;
            perm_set_examiner.Checked    = obj.perm_set_examiner;
            perm_user_management.Checked = obj.perm_user_management;
            m_yk.Checked      = obj.m_yk;
            m_pk.Checked      = obj.m_pk;
            m_vik.Checked     = obj.m_vik;
            m_pvk.Checked     = obj.m_pvk;
            m_ek.Checked      = obj.m_ek;
            m_mk.Checked      = obj.m_mk;
            m_ae.Checked      = obj.m_ae;
            m_tk.Checked      = obj.m_tk;
            m_pvt.Checked     = obj.m_pvt;
            m_yt.Checked      = obj.m_yt;
            m_vd.Checked      = obj.m_vd;
            auto_exam.Checked = obj.auto_exam;
            o1.Checked        = obj.o1;
            o2.Checked        = obj.o2;
            o3.Checked        = obj.o3;
            o4.Checked        = obj.o4;
            o5.Checked        = obj.o5;
            o6.Checked        = obj.o6;
            o7.Checked        = obj.o7;
            o8.Checked        = obj.o8;
            o9.Checked        = obj.o9;
            o10.Checked       = obj.o10;
            o11.Checked       = obj.o11;
            o12.Checked       = obj.o12;
        }