private void buttonLogin_Click(object sender, EventArgs e) { My_db db = new My_db(); if (radioButtonAdmin.Checked) { if (verify()) { DataTable table = new DataTable(); SqlCommand command = new SqlCommand("SELECT *FROM DangNhap (@usn,@pass)", db.getConnection); command.Parameters.Add("@usn", SqlDbType.VarChar).Value = textBoxUser.Text; command.Parameters.Add("@pass", SqlDbType.VarChar).Value = textBoxPassWord.Text; //Xử lý dữ liệu SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; adapter.Fill(table); if ((table.Rows.Count > 0)) { MainForm frm1 = new MainForm(); frm1.ShowDialog(); } else { MessageBox.Show("Invalid Username Or Password", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Empty Username Or Password", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else if (radioButtonGuest.Checked) { DataTable table = new DataTable(); SqlCommand command = new SqlCommand("SELECT *FROM DangNhap_Guest (@usn,@pass)", db.getConnection); command.Parameters.Add("@usn", SqlDbType.VarChar).Value = textBoxUser.Text; command.Parameters.Add("@pass", SqlDbType.VarChar).Value = textBoxPassWord.Text; //Xử lý dữ liệu SqlDataAdapter adapter = new SqlDataAdapter(); adapter.SelectCommand = command; adapter.Fill(table); if ((table.Rows.Count > 0)) { GiaoDienDanhMucHangHoa frm1 = new GiaoDienDanhMucHangHoa(); frm1.ShowDialog(); } else { MessageBox.Show("Invalid Username Or Password", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Please Check Again", "Login Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void danhMụcHàngHóaToolStripMenuItem_Click(object sender, EventArgs e) { GiaoDienDanhMucHangHoa frm = new GiaoDienDanhMucHangHoa(); frm.Show(); }