示例#1
0
        private void Button_Login_Click(object sender, EventArgs e)
        {
            // These are the Text box and combobox stuffs...

            string username = TextBox_UserName.Text;
            string password = TextBox_Password.Text;
            string usertype = ComboBox_SelectUser.Text;


            // from here databse connection starts..

            DB db = new DB();

            DataTable table = new DataTable();

            MySqlDataAdapter adapter = new MySqlDataAdapter();

            MySqlCommand command = new MySqlCommand("SELECT * FROM users WHERE username = @usn and password = @pass and usertype = @type", db.getConnection());

            command.Parameters.Add("@usn", MySqlDbType.VarChar).Value  = username;
            command.Parameters.Add("@pass", MySqlDbType.VarChar).Value = password;
            command.Parameters.Add("@type", MySqlDbType.VarChar).Value = usertype;

            adapter.SelectCommand = command;

            adapter.Fill(table);
            // here ends database things.

            if (usertype == "Manager")
            {
                if (table.Rows.Count > 0)
                {
                    // MessageBox.Show("Manager Login Successful");
                    this.Hide();
                    ManagerForm managerform = new ManagerForm();
                    managerform.Show();
                    // from here we are going to manager page..
                }
                else
                {
                    MessageBox.Show("Manager Login Unsuccessful");
                    TextBox_UserName.Clear();
                    TextBox_Password.Clear();
                }
            }
            else if (usertype == "Admin")
            {
                if (table.Rows.Count > 0)
                {
                    //MessageBox.Show("Admin Login Successful");

                    this.Hide();
                    AdminForm adminform = new AdminForm();
                    adminform.Show();

                    // from here we are going to admin page..
                }
                else
                {
                    MessageBox.Show("Admin Login Unsuccessful");
                    TextBox_UserName.Clear();
                    TextBox_Password.Clear();
                }
            }
        }