public void xoaKhachHang(string mancc)
        {
            QL_NhaCungCap delete = data.QL_NhaCungCaps.Where(t => t.MaNCC == mancc).FirstOrDefault();

            if (delete != null)
            {
                data.QL_NhaCungCaps.DeleteOnSubmit(delete);
            }
            data.SubmitChanges();
        }
        public void themNhaCungCap(string mancc, string tenncc, string diachi, string sdt, string email)
        {
            QL_NhaCungCap insert = new QL_NhaCungCap();

            insert.MaNCC  = mancc;
            insert.TenNCC = tenncc;
            insert.DiaChi = diachi;
            insert.SDT    = sdt;
            insert.Email  = email;
            data.QL_NhaCungCaps.InsertOnSubmit(insert);
            data.SubmitChanges();
        }
        public void suaKhachHang(string mancc, string tenncc, string diachi, string sdt, string email)
        {
            QL_NhaCungCap update = data.QL_NhaCungCaps.Where(t => t.MaNCC == mancc).FirstOrDefault();

            if (update != null)
            {
                update.TenNCC = tenncc;
                update.DiaChi = diachi;
                update.SDT    = sdt;
                update.Email  = email;
            }
            data.SubmitChanges();
        }