public void LoadChiTietThoiKhoaBieu()
        {
            for (int i = 0; i < dgvDanhSachTKB.Rows.Count; i++)
            {
                MonHoc monHoc = new MonHoc();
                monHoc = monHocService.GetMonHocByMaMonHoc(dgvDanhSachTKB.Rows[i].Cells[2].Value.ToString());
                dgvDanhSachTKB.Rows[i].Cells[3].Value = monHoc.TenMonHoc.ToString();
                dgvDanhSachTKB.Rows[i].Cells[4].Value = monHoc.STC.ToString();

                GiangVien gv = new GiangVien();
                gv = giangVienService.GetGiangVienByMaGV(dgvDanhSachTKB.Rows[i].Cells[5].Value.ToString());
                dgvDanhSachTKB.Rows[i].Cells[6].Value = gv.TenGV.ToString();
            }
        }
        //show data giảng viên lên các field
        public void ShowInfoGiangVien()
        {
            ID_GV = dgvDSAccountGiangVien.CurrentRow.Cells[1].Value.ToString().Trim();
            GiangVien gv = new GiangVien();

            gv = giangVienService.GetGiangVienByMaGV(ID_GV);
            txtEmailGiangVien.Text = gv.Email;
            txtPassGiangVien.Text  = gv.Password;
            lblMaGV.Text           = gv.MaGV;
            lblTenGV.Text          = gv.TenGV;
            lblGioiTinhGV.Text     = gv.GioiTinh;
            lblNamSinhGV.Text      = gv.NamSinh;
            lblSdtGV.Text          = gv.SDT;
            lblStartDayGV.Text     = gv.NgayBatDau;

            string status = gv.StatusAcc;

            if (status == "Activate")
            {
                lblStatusGV.BackColor = Color.Lime;
            }
            else if (status == "Lock")
            {
                lblStatusGV.BackColor = Color.Red;
            }
            else
            {
                lblStatusGV.BackColor = Color.Violet;
            }
        }