private void button1_Click(object sender, EventArgs e) { if (txtUsername.Text.Trim() == "" || txtPassword.Text.Trim() == "") { MessageBox.Show("Thiếu Username, Password!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } try { DataTable tb; if (rbtnNhanVien.Checked) { //tb = dp.Fillbang("select ID, Ma, Ten, IDChiNhanh, IDChucVu from NhanVien where Username = N'" + txtUsername.Text.Trim() + "' and Pass = N'" + txtPassword.Text.Trim() + "'"); string[] str = new string[2]; object[] val = new object[2]; str[0] = "@username"; str[1] = "@pass"; val[0] = txtUsername.Text.Trim(); val[1] = txtPassword.Text.Trim(); //Unrepeatable read if (DataAccount._fix) { tb = dp.ReadDataAddPram("sp_ReadLogin_NhanVien_Fix", str, val, 100); } else { tb = dp.ReadDataAddPram("sp_ReadLogin_NhanVien", str, val, 100); } } else { tb = dp.Fillbang(" select ID, Ma, Ten, IDChiNhanh, 3 as IDChucVu from KhachHang where Username = N'" + txtUsername.Text.Trim() + "' and Pass = N'" + txtPassword.Text.Trim() + "'"); } if (tb.Columns.Count < 1) { MessageBox.Show("Username, Password không đúng!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } int idUser = Convert.ToInt16(tb.Rows[0]["ID"].ToString()); int idChiNhanh = Convert.ToInt16(tb.Rows[0]["IDChiNhanh"].ToString()); int idChucVu = Convert.ToInt16(tb.Rows[0]["IDChucVu"].ToString()); DataAccount.SetDataAccount(idUser, txtUsername.Text.Trim(), tb.Rows[0]["Ma"].ToString(), tb.Rows[0]["Ten"].ToString(), idChiNhanh, idChucVu); MessageBox.Show("Thành công", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Dispose(); } catch (Exception ex) { DataAccount.ResetDataAccount(); MessageBox.Show("Lỗi Username, Password", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void button1_Click(object sender, EventArgs e) { if (txtPassOld.Text.Trim() == "" || txtPassNew.Text.Trim() == "") { MessageBox.Show("Thiếu thông tin", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } try { DataTable tb; if (rbtnNhanVien.Checked) { tb = dp.Fillbang("select ID from NhanVien where ID = " + DataAccount._idUser + " and Pass = N'" + txtPassOld.Text.Trim() + "'"); } else { tb = dp.Fillbang("select ID from KhachHang where ID = " + DataAccount._idUser + " and Pass = N'" + txtPassOld.Text.Trim() + "'"); } if (tb.Rows.Count < 1) { MessageBox.Show("Mật khẩu cũ không đúng!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (rbtnNhanVien.Checked) { dp.MyExecuteNonQuery("update NhanVien set Pass = N'" + txtPassNew.Text.Trim() + "' where ID = " + DataAccount._idUser); } else { dp.MyExecuteNonQuery("update KhachHang set Pass = N'" + txtPassNew.Text.Trim() + "' where ID = " + DataAccount._idUser); } DataAccount.ResetDataAccount(); MessageBox.Show("Thành công, vui lòng đăng nhập lại...", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Dispose(); } catch (Exception ex) { MessageBox.Show("Lỗi...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void mnuDX_Click(object sender, EventArgs e) { DataAccount.ResetDataAccount(); BlockMenu(false); }