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);
}
