public void loadConbobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader pdg = sqlConn.getDataTable("PHIEUDANHGIA");
while (pdg.Read())
{
txtID_PhieuDanhGia.Items.Add(pdg["ID_PhieuDanhGia"].ToString());
}
sqlConn.closeConnection();
SqlDataReader pvt = sqlConn.getDataTable("PHIEUVATTU");
while (pvt.Read())
{
txtID_PhieuVatTu.Items.Add(pvt["ID_PhieuVatTu"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
public void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader lsc = sqlConn.getDataTable("LENHSUACHUA");
while (lsc.Read())
{
cmbID_LenhSuaChua.Items.Add(lsc["ID_LenhSuaChua"].ToString());
}
sqlConn.closeConnection();
SqlDataReader nv = sqlConn.getDataTable("NHANVIEN");
while (nv.Read())
{
cmbID_NhanVien.Items.Add(nv["ID_NhanVien"].ToString());
cmbTenNV.Items.Add(nv["HoTen"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
private void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader pvt = sqlConn.getDataTable("PHIEUVATTU");
while (pvt.Read())
{
cmbID_PhieuVatTu.Items.Add(pvt["ID_PhieuVatTu"].ToString());
}
sqlConn.closeConnection();
SqlDataReader vt = sqlConn.getDataTable("VATTU");
while (vt.Read())
{
cmbID_VatTu.Items.Add(vt["ID_VatTu"].ToString());
cmbTenVT.Items.Add(vt["TenVatTu"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
public void loadCombobox()
{
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
SqlDataReader kh = sqlConn.getDataTable("KHACHHANG");
while (kh.Read())
{
cmbID_KhachHang.Items.Add(kh["ID_KhachHang"].ToString());
cmbTenKH.Items.Add(kh["HoTen"].ToString());
}
sqlConn.closeConnection();
SqlDataReader xe = sqlConn.getDataTable("THONGTINXE");
while (xe.Read())
{
cmbID_Xe.Items.Add(xe["ID_Xe"].ToString());
cmbBienSoXe.Items.Add(xe["BienSoXe"].ToString());
}
//cmbTimKiem.SelectedIndex = 0;
}
private void btnLuu_Click(object sender, EventArgs e)
{
if (DAL.NguoiDung_Model.matkhau.Equals(txtMKCu.Text.Trim()))
{
if (txtXacNhan.Text.Trim().Equals(txtMKMoi.Text.Trim()))
{
string TaiKhoan = DAL.NguoiDung_Model.taikhoan;
string MatKhau = txtMKMoi.Text.Trim();
string query = "update NGUOIDUNG set MatKhau = '" + MatKhau + "' where TaiKhoan = '" + TaiKhoan + "'";
DAL.sqlConnect sqlConn = new DAL.sqlConnect();
try
{
sqlConn.openConnection();
SqlCommand cmd = new SqlCommand(query, sqlConn.Conn);
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
DAL.NguoiDung_Model.matkhau = MatKhau;
sqlConn.closeConnection();
}
MessageBox.Show("Đổi mật khẩu thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Close();
}
else
{
MessageBox.Show("Mật khâu không khớp", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Mật khẩu không chính xác", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtMKCu.Focus();
}
}