public void CapNhapDiem(string makh, int diem) { QL_KHACHHANG updateKhachHang = qlkh.QL_KHACHHANGs.Where(t => t.MaKH == makh).FirstOrDefault(); if (updateKhachHang != null) { updateKhachHang.DiemSo = diem; } qlkh.SubmitChanges(); }
public void xoaKhachHang(string makh) { QL_KHACHHANG deleteKhachHang = qlkh.QL_KHACHHANGs.Where(t => t.MaKH == makh).FirstOrDefault(); if (deleteKhachHang != null) { qlkh.QL_KHACHHANGs.DeleteOnSubmit(deleteKhachHang); } qlkh.SubmitChanges(); }
public void themKhachHang(string makh, string hoten, string sodt, string cmnd) { QL_KHACHHANG insertkh = new QL_KHACHHANG(); insertkh.MaKH = makh; insertkh.HoTen = hoten; insertkh.SDT = sodt; insertkh.CMND = cmnd; insertkh.DiemSo = 0; qlkh.QL_KHACHHANGs.InsertOnSubmit(insertkh); qlkh.SubmitChanges(); }
public void suaKhachHang(string makh, string hoten, string sodt, string cmnd, int diem) { QL_KHACHHANG updateKhachHang = qlkh.QL_KHACHHANGs.Where(t => t.MaKH == makh).FirstOrDefault(); if (updateKhachHang != null) { updateKhachHang.HoTen = hoten; updateKhachHang.SDT = sodt; updateKhachHang.CMND = cmnd; updateKhachHang.DiemSo = diem; } qlkh.SubmitChanges(); }
private void btnSeachKH_Click(object sender, EventArgs e) { if (txtKhachHang.Text == "KHCDK") { return; } if (txtKhachHang.Enabled == false) { checkDungDiem.Checked = false; txtKhachHang.Text = ""; txtKhachHang.Enabled = true; lbDiem.Text = "0"; checkDungDiem.Enabled = false; return; } if (txtKhachHang.Text == string.Empty) { MessageBox.Show("Chưa nhập mã số khách hàng"); return; } else { string makh = txtKhachHang.Text; QL_KHACHHANG kh = kh_bll.loadGridViewTimKiemPOSKhachHang(makh); kh_hientai = kh; if (kh == null) { MessageBox.Show("Khách Hàng này không tồn tại"); return; } txtKhachHang.Text = kh.HoTen; txtKhachHang.Enabled = false; if (kh.DiemSo == 0 || kh.DiemSo == null) { lbDiem.Text = "0"; checkDungDiem.Enabled = false; return; } checkDungDiem.Enabled = true; lbDiem.Text = (int)kh.DiemSo + ""; } }