Ejemplo n.º 1
0
        private async void button6_Click(object sender, EventArgs e)
        {
            if (comboBox6.Text != "")
            {
                SqlConnection = new OleDbConnection(connectString);
                await SqlConnection.OpenAsync();

                OleDbDataReader sqlReader = null;

                OleDbCommand command = new OleDbCommand("UPDATE [Клиенты] SET [Статус]=@status WHERE [Телефон]=@num", SqlConnection);
                command.Parameters.AddWithValue("status", comboBox6.Text);
                command.Parameters.AddWithValue("num", comboBox5.Text);
                await command.ExecuteNonQueryAsync();

                await command.ExecuteNonQueryAsync();

                MessageBox.Show("Статус вопроса успешно изменен");

                admin_panel open_form = new admin_panel();
                open_form.Text = this.Text;
                open_form.Show();
                this.Hide();
            }
            else
            {
                comboBox6.BackColor = Color.Peru;
            }
        }
Ejemplo n.º 2
0
        private async void button1_Click(object sender, EventArgs e)
        {
            SqlConnection = new OleDbConnection(connectString);
            await SqlConnection.OpenAsync();

            OleDbDataReader sqlReader = null;

            if (textBox2.Text != "")
            {
                OleDbCommand command = new OleDbCommand("INSERT INTO [Чат] (Пользователь, Текст, Роль)VALUES(@login, @text, @rol)", SqlConnection);
                command.Parameters.AddWithValue("login", this.Text);
                command.Parameters.AddWithValue("text", textBox2.Text);
                command.Parameters.AddWithValue("rol", "Консультант");
                await command.ExecuteNonQueryAsync();

                command = new OleDbCommand("SELECT * FROM [Чат]", SqlConnection);

                sqlReader = command.ExecuteReader();

                while (sqlReader.Read())
                {
                    int for_id = 0;

                    while (true)
                    {
                        if (for_id == Convert.ToInt32(sqlReader["Код"]))
                        {
                            if (this.Text == Convert.ToString(sqlReader["Пользователь"]))
                            {
                                textBox1.Text += "Вы" + ": " + Convert.ToString(sqlReader["Текст"]) + "\r\n" + "\r\n";
                            }
                            else
                            {
                                textBox1.Text += Convert.ToString(sqlReader["Пользователь"]) + " (" + Convert.ToString(sqlReader["Роль"]) + "): " + Convert.ToString(sqlReader["Текст"]) + "\r\n" + "\r\n";
                            }

                            break;
                        }

                        for_id++;
                    }
                }

                admin_panel a = new admin_panel();
                a.Text = this.Text;
                a.Show();
                this.Hide();
            }
            else
            {
                textBox2.BackColor = Color.Peru;
            }
        }
Ejemplo n.º 3
0
        private async void button2_Click(object sender, EventArgs e)
        {
            SqlConnection = new OleDbConnection(connectString);
            await SqlConnection.OpenAsync();

            OleDbDataReader sqlReader = null;

            if (textBox4.Text != "")
            {
                if (textBox3.Text != "")
                {
                    if (comboBox1.Text != "")
                    {
                        OleDbCommand command = new OleDbCommand("INSERT INTO [Пользователи] (Логин, Пароль, ФИО, Роль)VALUES(@login, @password, @fio, @rol)", SqlConnection);
                        command.Parameters.AddWithValue("login", textBox4.Text);
                        command.Parameters.AddWithValue("password", textBox3.Text);
                        command.Parameters.AddWithValue("fio", textBox13.Text);
                        command.Parameters.AddWithValue("rol", comboBox1.Text);
                        await command.ExecuteNonQueryAsync();

                        MessageBox.Show("Пользователь был успешно добавлен!");

                        admin_panel a = new admin_panel();
                        a.Text = this.Text;
                        a.Show();
                        this.Hide();

                        return;
                    }
                    else
                    {
                        comboBox1.BackColor = Color.Peru;
                    }
                }
                else
                {
                    textBox3.BackColor = Color.Peru;
                }
            }
            else
            {
                textBox4.BackColor = Color.Peru;
            }

            MessageBox.Show("Все поля должны бать заполены");
        }
Ejemplo n.º 4
0
        private async void button3_Click(object sender, EventArgs e)
        {
            if (textBox5.Text != "")
            {
                if (textBox6.Text != "")
                {
                    if (comboBox2.Text != "")
                    {
                        SqlConnection = new OleDbConnection(connectString);
                        await SqlConnection.OpenAsync();

                        OleDbDataReader sqlReader = null;

                        OleDbCommand command = new OleDbCommand("UPDATE [Пользователи] SET [Логин]=@login, [Пароль]=@pass, [Роль]=@rol WHERE [Логин]=@log", SqlConnection);
                        command.Parameters.AddWithValue("login", textBox5.Text);
                        command.Parameters.AddWithValue("pass", textBox6.Text);
                        command.Parameters.AddWithValue("rol", comboBox2.Text);
                        command.Parameters.AddWithValue("log", comboBox3.Text);
                        await command.ExecuteNonQueryAsync();

                        await command.ExecuteNonQueryAsync();

                        MessageBox.Show("Данные пользователя успешно изменены");

                        admin_panel open_form = new admin_panel();
                        open_form.Text = this.Text;
                        open_form.Show();
                        this.Hide();
                    }
                    else
                    {
                        comboBox2.BackColor = Color.Peru;
                    }
                }
                else
                {
                    textBox6.BackColor = Color.Peru;
                }
            }
            else
            {
                textBox5.BackColor = Color.Peru;
            }
        }
Ejemplo n.º 5
0
        private async void button5_Click(object sender, EventArgs e)
        {
            SqlConnection = new OleDbConnection(connectString);
            await SqlConnection.OpenAsync();

            OleDbDataReader sqlReader = null;

            OleDbCommand command = new OleDbCommand("DELETE * FROM [Пользователи] WHERE [Логин]=@log", SqlConnection);

            command.Parameters.AddWithValue("log", comboBox4.Text);
            await command.ExecuteNonQueryAsync();

            MessageBox.Show("Пользователь успешно удален");

            admin_panel open_form = new admin_panel();

            open_form.Text = this.Text;
            open_form.Show();
            this.Hide();
        }
Ejemplo n.º 6
0
        private async void button1_Click(object sender, EventArgs e)
        {
            if (textBox1.Text != "")
            {
                if (textBox2.Text != "")
                {
                    SqlConnection = new OleDbConnection(connectString);
                    await SqlConnection.OpenAsync();

                    OleDbDataReader sqlReader = null;

                    OleDbCommand command = new OleDbCommand("SELECT * FROM [Пользователи]", SqlConnection);

                    try
                    {
                        sqlReader = command.ExecuteReader();

                        while (sqlReader.Read())
                        {
                            if ((textBox1.Text == Convert.ToString(sqlReader["Логин"])) && (textBox2.Text == Convert.ToString(sqlReader["Пароль"])))
                            {
                                if (Convert.ToString(sqlReader["Роль"]) == "Консультант")
                                {
                                    common_cons a = new common_cons();
                                    a.Show();
                                    a.Text = Convert.ToString(sqlReader["Логин"]);
                                    this.Hide();
                                }

                                if (Convert.ToString(sqlReader["Роль"]) == "Главный Консультант")
                                {
                                    main_cons a = new main_cons();
                                    a.Show();
                                    a.Text = Convert.ToString(sqlReader["Логин"]);
                                    this.Hide();
                                }

                                if (Convert.ToString(sqlReader["Роль"]) == "Администратор")
                                {
                                    admin_panel a = new admin_panel();
                                    a.Show();
                                    a.Text = Convert.ToString(sqlReader["Логин"]);
                                    this.Hide();
                                }

                                if (Convert.ToString(sqlReader["Роль"]) == "Работа с клиентом")
                                {
                                    client_work_page a = new client_work_page();
                                    a.Show();
                                    a.Text = Convert.ToString(sqlReader["Логин"]);
                                    this.Hide();
                                }
                            }

                            label12.Visible    = true;
                            textBox1.BackColor = Color.Peru;
                            textBox2.BackColor = Color.Peru;
                        }
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message.ToString(), ex.Source.ToString(), MessageBoxButtons.OK, MessageBoxIcon.Error);
                    }
                }
                else
                {
                    textBox2.BackColor = Color.Peru;
                }
            }
            else
            {
                if (textBox2.Text == "")
                {
                    textBox1.BackColor = Color.Peru;
                    textBox2.BackColor = Color.Peru;
                }
                else
                {
                    textBox1.BackColor = Color.Peru;
                }
            }
        }