public static void DeleteDocGia(int idDocGia)
        {
            DOCGIA dg = db.DOCGIAs.Find(idDocGia);

            db.DOCGIAs.Remove(dg);
            db.SaveChanges();
        }
        public static void UpdateNo(int idDocGia, double tongNo)
        {
            DOCGIA docGia = db.DOCGIAs.Find(idDocGia);

            if (docGia != null)
            {
                docGia.TongNo = tongNo;
                db.SaveChanges();
            }
        }
        public static void UpdateDocGia(int idDocGia, string tenDocGia, int idLoaiDG, DateTime ngaySinh, string diaChi, string email,
                                        DateTime ngayLapThe, double tongNo)
        {
            DOCGIA dg = db.DOCGIAs.Find(idDocGia);

            dg.HoTen        = tenDocGia;
            dg.IDLoaiDocGia = idLoaiDG;
            dg.NgaySinh     = ngaySinh;
            dg.DiaChi       = diaChi;
            dg.Email        = email;
            dg.NgayLapThe   = ngayLapThe;
            dg.TongNo       = tongNo;
            db.SaveChanges();
        }