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