private void dgvDanhSach_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvDanhSach.Rows.Count == e.RowIndex + 1)
{
return;
}
int id = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells["colMa"].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colSua"].Index)
{
frmSuaKH f = new frmSuaKH(id);
f.ShowDialog();
loadDuLieu();
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colXoa"].Index)
{
int ketQua = KhachHangControl.xoaThongTin(id);
if (ketQua <= 0)
{
MessageBox.Show("Thực hiện thất bại");
}
else
{
loadDuLieu();
}
}
}
private void dgvDanhSach_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dgvDanhSach.Rows.Count == e.RowIndex + 1)
{
return;
}
int id = Convert.ToInt32(dgvDanhSach.Rows[e.RowIndex].Cells["colMa"].Value.ToString());
if (e.ColumnIndex == dgvDanhSach.Columns["colSua"].Index)
{
frmSuaKH f = new frmSuaKH(id);
f.ShowDialog();
loadDuLieu();
}
else if (e.ColumnIndex == dgvDanhSach.Columns["colXoa"].Index)
{
// Hiển thị hộp thoại xác nhận xóa khách hàng
DialogResult dr = MessageBox.Show("Bạn chắc chắn muốn xóa khách hàng này?", "Xóa khách hàng", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (DialogResult.Yes == dr)
{
int ketQua = KhachHangControl.xoaDuLieu(id);
if (ketQua <= 0)
{
MessageBox.Show("Thực hiện thất bại");
}
else
{
loadDuLieu();
}
}
}
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = KhachHangControl.layDanhSach();
for (int i = 0; i < dt.Rows.Count; ++i)
{
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3] });
}
}
public frmSuaKH(int id)
{
InitializeComponent();
idKH = id;
DataTable dt = KhachHangControl.layThongTin(id);
txtTenCu.Text = dt.Rows[0][1].ToString();
txtDiaChiCu.Text = dt.Rows[0][2].ToString();
txtSDTCu.Text = dt.Rows[0][3].ToString();
}
private void loadDuLieu()
{
dgvDanhSach.Rows.Clear();
DataTable dt = KhachHangControl.layDanhSach();
lblCountCustomer.Text = lblCountCustomer.Text + dt.Rows.Count.ToString();
for (int i = 0; i < dt.Rows.Count; ++i)
{
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i]["MaKH"], dt.Rows[i]["TenKH"], dt.Rows[i]["DiaChi"], dt.Rows[i]["SDT"] });
}
}
public KhachHang(int manv)
{
MaKH = manv;
if (MaKH == 0)
{
TenKH = DiaChi = SDT = "";
return;
}
DataTable dt = KhachHangControl.layDuLieu(manv);
TenKH = dt.Rows[0]["TenKH"].ToString();
DiaChi = dt.Rows[0]["DiaChi"].ToString();
SDT = dt.Rows[0]["SDT"].ToString();
}
private void btnXacNhan_Click(object sender, EventArgs e)
{
string ten = txtTenMoi.Text;
string diachi = txtDiaChiMoi.Text;
string sdt = txtSDTMoi.Text;
if (kiemTra(ten, diachi, sdt))
{
int ketQua = 0;
ketQua = KhachHangControl.suaThongTin(idKH, ten, diachi, sdt);
if (ketQua > 0)
{
MessageBox.Show("thay đổi thành công");
this.Close();
}
}
}
private void loadDSKH()
{
DataTable dt = KhachHangControl.layDanhSach();
List <KhachHang> list = new List <KhachHang>();
for (int i = 0; i < dt.Rows.Count; ++i)
{
list.Add(new KhachHang
{
MaKH = Convert.ToInt32(dt.Rows[i]["MaKH"].ToString()),
TenKH = dt.Rows[i]["TenKH"].ToString(),
DiaChi = dt.Rows[0]["DiaChi"].ToString(),
SDT = dt.Rows[0]["SDT"].ToString()
});
}
cbKhachHang.DataSource = list;
cbKhachHang.DisplayMember = "TenKH";
}
private void timKiem()
{
// get text
string value = txtTimKiem.Text;
if (value.Length == 0)
{
loadDuLieu();
return;
}
dgvDanhSach.Rows.Clear();
DataTable dt = KhachHangControl.timKiem(value);
for (int i = 0; i < dt.Rows.Count; ++i)
{
dgvDanhSach.Rows.Add(new object[] { false, dt.Rows[i][0], dt.Rows[i][1], dt.Rows[i][2], dt.Rows[i][3] });
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
string ten = txtTen.Text;
string diachi = txtDiaChi.Text;
string sdt = txtSDT.Text;
if (kiemTraDuLieu(ten, diachi, sdt))
{
int ketqua = KhachHangControl.themDuLieu(ten, diachi, sdt);
if (ketqua > 0)
{
MessageBox.Show("thêm thành công");
this.Close();
}
else
{
MessageBox.Show("thêm thất bại");
}
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
int ketQua = 0;
for (int i = 0; i < dgvDanhSach.Rows.Count - 1; ++i)
{
if (Convert.ToBoolean(dgvDanhSach.Rows[i].Cells["colCheck"].Value.ToString()))
{
ketQua += KhachHangControl.xoaThongTin(Convert.ToInt32(dgvDanhSach.Rows[i].Cells["colMa"].Value.ToString()));
}
}
if (ketQua > 0)
{
MessageBox.Show("xóa thành công " + ketQua);
loadDuLieu();
}
else
{
MessageBox.Show("xóa thất bại");
}
}
public string layTenKH()
{
return(KhachHangControl.layTenKH(idKH));
}
private void frmTimKhachHang_Load(object sender, EventArgs e)
{
KhachHangControl ctrl = new KhachHangControl();
ctrl.HienthiComboBox(cmbtimKH);
}
