Beispiel #1
0
        private void Label3_Click(object sender, EventArgs e)
        {
            this.Close();
            MainCatalog mainCat = new MainCatalog();

            mainCat.Show();
        }
Beispiel #2
0
        private void button1_Click(object sender, EventArgs e)
        {
            String login = textBox1.Text;
            String pass  = textBox2.Text;

            DB db = new DB();

            DataTable table1 = new DataTable();

            MySqlDataAdapter adapter = new MySqlDataAdapter();

            db.openConnection();
            MySqlCommand command = new MySqlCommand("SELECT * FROM users WHERE login = @uL AND password= @uP", db.getConnection());

            command.Parameters.Add("@uL", MySqlDbType.VarChar).Value = login;
            command.Parameters.Add("@uP", MySqlDbType.VarChar).Value = pass;

            adapter.SelectCommand = command;
            adapter.Fill(table1);

            if (table1.Rows.Count > 0)
            {
                int id = Convert.ToInt16(command.ExecuteScalar());
                veloshop.userID = id;
                command         = new MySqlCommand("SELECT acc_type FROM users WHERE ID = @uID", db.getConnection());
                command.Parameters.Add("@uID", MySqlDbType.Int16).Value = veloshop.userID;
                string acc_type = command.ExecuteScalar().ToString();
                if (acc_type == "admin")
                {
                    this.Hide();
                    Information inform = new Information();
                    inform.Show();
                    db.closeConnection();
                }
                else if (acc_type == "client")
                {
                    this.Hide();
                    MainCatalog catalog = new MainCatalog();
                    catalog.Show();
                    db.closeConnection();
                }
            }
            else
            {
                MessageBox.Show("Невірний логін або пароль!", "Помилка!");
            }
            db.closeConnection();
        }