private void btnXoa_Click(object sender, EventArgs e) { QuanLyBanHangDataContext db = new QuanLyBanHangDataContext(); KhachHang xoaKhachHangTheoMaKH = db.KhachHangs.Single(kh => kh.MaKH.Equals(txtMaKH.Text.Trim())); db.KhachHangs.DeleteOnSubmit(xoaKhachHangTheoMaKH); db.SubmitChanges(); HienThi(); }
private void btnSua_Click(object sender, EventArgs e) { QuanLyBanHangDataContext db = new QuanLyBanHangDataContext(); KhachHang capNhatKhachHangTheoMaKH = db.KhachHangs.Single(kh => kh.MaKH.Equals(txtMaKH.Text.Trim())); capNhatKhachHangTheoMaKH.TenKH = txtTenKH.Text.Trim(); capNhatKhachHangTheoMaKH.DiaChi = txtDiaChi.Text.Trim(); capNhatKhachHangTheoMaKH.Sdt = txtSDT.Text.Trim(); db.SubmitChanges(); HienThi(); }
private void btnThem_Click(object sender, EventArgs e) { QuanLyBanHangDataContext db = new QuanLyBanHangDataContext(); KhachHang khachHangMoi = new KhachHang(); khachHangMoi.MaKH = txtMaKH.Text.Trim(); khachHangMoi.TenKH = txtTenKH.Text.Trim(); khachHangMoi.DiaChi = txtDiaChi.Text.Trim(); khachHangMoi.Sdt = txtSDT.Text.Trim(); db.KhachHangs.InsertOnSubmit(khachHangMoi); db.SubmitChanges(); HienThi(); }