Exemple #1
0
        private void button1_Click(object sender, EventArgs e)
        {
            Database.GetInstance().CloseConnection();
            Database.GetInstance().OpenConnection();

            switch (comboBox1.Text)
            {
            case "Finance":
                if (textBox2.Text == psF)
                {
                    FormFinance finance = new FormFinance();
                    finance.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("Invalid login credentials");
                }
                break;

            case "Development":
                if (textBox2.Text == psD)
                {
                    Development d = new Development();
                    d.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("Invalid login credentials");
                }
                break;

            case "Sales":
                if (textBox2.Text == psS)
                {
                    Sales_dash SD = new Sales_dash();
                    SD.Show();
                    this.Hide();
                }
                else
                {
                    MessageBox.Show("Invalid login credentials");
                }
                break;

            default:
                MessageBox.Show("Invalid login credentials");
                break;
            }
        }
Exemple #2
0
        private void textBox2_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                switch (comboBox1.Text)
                {
                case "Finance":
                    if (textBox2.Text == psF)
                    {
                        MainForm mf = new MainForm();
                        mf.Show();
                        this.Close();
                    }
                    else
                    {
                        MessageBox.Show("Invalid login credentials");
                    }
                    break;

                case "Development":
                    if (textBox2.Text == psD)
                    {
                        Development d = new Development();
                        d.Show();
                        this.Hide();
                    }
                    else
                    {
                        MessageBox.Show("Invalid login credentials");
                    }
                    break;

                case "Sales":
                    if (textBox2.Text == psS)
                    {
                        Sales_dash SD = new Sales_dash();
                        SD.Show();
                        this.Hide();
                    }
                    else
                    {
                        MessageBox.Show("Invalid login credentials");
                    }
                    break;

                default:
                    MessageBox.Show("Invalid login credentials");
                    break;
                }
            }
        }
Exemple #3
0
        private void CheckLogin()
        {
            //database.Query("SELECT HASHBYTES('SHA', @a_password)");
            //database.AddParameter("@a_password", textBoxPassword.Text);

            database.Query("SELECT COUNT(*) FROM tbl_accounts WHERE a_username = @a_username AND a_password = @a_password;");
            database.AddParameter("@a_username", comboBoxDepartments.SelectedItem.ToString());
            database.AddParameter("@a_password", textBoxPassword.Text);

            if ((int)database.ExecuteQuery() > 0)
            {
                switch (comboBoxDepartments.SelectedItem.ToString().ToUpper())
                {
                case "FINANCE":
                    FormFinance finance = new FormFinance();
                    finance.Show();
                    break;

                case "SALES":
                    Sales_dash sales = new Sales_dash();
                    sales.Show();
                    break;

                case "DEVELOPMENT":
                    Development dev = new Development();
                    dev.Show();
                    break;

                default:
                    break;
                }
            }
            else
            {
                MessageBox.Show("Invalid login details...");
            }
        }