//day la phan load ma mon ten mon



        private void bttThongKeLop_Click(object sender, EventArgs e)
        {
            DatabaseConnection.ketnoi();

            cls.Data3DataGridView(grvThongkeLop, "select Diemtongket.MaHS,Lop.Malop,Lop.Tenlop, Diemtongket.DiemTongketCanam from Lop,Diemtongket,Hocsinh where Hocsinh.MaHS = Diemtongket.MaHS and Lop.Malop = Hocsinh.Malop  and Namhoc='" +
                                  cbNamHocLop.Text.Trim() + "' and Lop.Malop='" + cbMaLop.Text.Trim() + "'");
            int demsoluong   = grvThongkeLop.RowCount;
            int phantramgioi = 0;
            int phantramkha  = 0;
            int phantramtb   = 0;
            int phantramyeu  = 0;
            int khatam       = 0;
            int gioitam      = 0;
            int tbtam        = 0;
            int yeutam       = 0;

            //string kt = "";
            if (demsoluong - 1 == 0)
            {
                MessageBox.Show("Không tồn tại dữ liệu");
            }
            else
            {
                for (int i = 0; i < demsoluong - 1; i++)
                {
                    //kt = kt + grvTKN.Rows[i].Cells[1].Value.ToString().Trim() + " , ";
                    if (double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) >= 8 && double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) <= 10)
                    {
                        gioitam++;
                    }
                    else
                    if (double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) >= 6.5 && double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) < 8)
                    {
                        khatam++;
                    }
                    else
                    if (double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) >= 5 && double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) < 6.5)
                    {
                        tbtam++;
                    }
                    else
                    if (double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) >= 0 && double.Parse(grvThongkeLop.Rows[i].Cells[3].Value.ToString().Trim()) < 5)
                    {
                        yeutam++;
                    }
                }
            }
            try
            {
                phantramgioi = (gioitam * 100) / (demsoluong - 1);
                phantramkha  = (khatam * 100) / (demsoluong - 1);
                phantramtb   = (tbtam * 100) / (demsoluong - 1);
                phantramyeu  = (yeutam * 100) / (demsoluong - 1);

                txtGioiL.Text = phantramgioi.ToString() + " %";
                txtKhaL.Text  = phantramkha.ToString() + " %";
                txtTBL.Text   = phantramtb.ToString() + " %";
                txtYeuL.Text  = phantramyeu.ToString() + " %";
            }
            catch
            {
                MessageBox.Show("Lớp '" + cbTenLop.Text + "'chưa cập nhật điểm.");
            }


            DatabaseConnection.ngatketnoi();
        }
        private void bttThongKeHK_Click(object sender, EventArgs e)
        {
            DatabaseConnection.ketnoi();

            if (cbHocKy.Text == "I")
            {
                grvTKHK1.Visible = true;
                grvTKHK2.Visible = false;
                cls.Data1DataGridView(grvTKHK1, "select MaHS,Namhoc,DiemTongketky1 from Diemtongket where Namhoc=N'" + cbNamHocHK.Text + "'");

                int ptgioi    = 0;
                int ptkha     = 0;
                int pttb      = 0;
                int ptyeu     = 0;
                int khatamhk  = 0;
                int gioitamhk = 0;
                int tbtamhk   = 0;
                int yeutamhk  = 0;
                int dem       = grvTKHK1.RowCount;

                if (dem - 1 == 0)
                {
                    MessageBox.Show("Không có học sinh nào trong học kỳ: " + cbHocKy.Text + " của năm học: " + cbNamHocHK.Text);
                }
                else
                {
                    for (int i = 0; i < dem - 1; i++)
                    {
                        //kt = kt + grvTKN.Rows[i].Cells[1].Value.ToString().Trim() + " , ";
                        if (double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) >= 8 && double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) <= 10)
                        {
                            gioitamhk++;
                        }
                        else
                        if (double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) >= 6.5 && double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) < 8)
                        {
                            khatamhk++;
                        }
                        else
                        if (double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) >= 5 && double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) < 6.5)
                        {
                            tbtamhk++;
                        }
                        else
                        if (double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) >= 0 && double.Parse(grvTKHK1.Rows[i].Cells[2].Value.ToString().Trim()) < 5)
                        {
                            yeutamhk++;
                        }
                    }
                }

                try
                {
                    ptgioi = (gioitamhk * 100) / (dem - 1);
                    ptkha  = (khatamhk * 100) / (dem - 1);
                    pttb   = (tbtamhk * 100) / (dem - 1);
                    ptyeu  = (yeutamhk * 100) / (dem - 1);

                    txtGioiHK.Text = ptgioi.ToString() + " %";
                    txtKhaHK.Text  = ptkha.ToString() + " %";
                    txtTBHK.Text   = pttb.ToString() + " %";
                    txtYeuHK.Text  = ptyeu.ToString() + " %";
                }
                catch
                { }
            }
            else
            if (cbHocKy.Text == "II")
            {
                grvTKHK1.Visible = false;
                grvTKHK2.Visible = true;
                cls.Data2DataGridView(grvTKHK2, "select MaHS,Namhoc,DiemTongketky2 from Diemtongket where Namhoc=N'" + cbNamHocHK.Text + "'");

                int ptgioi    = 0;
                int ptkha     = 0;
                int pttb      = 0;
                int ptyeu     = 0;
                int khatamhk  = 0;
                int gioitamhk = 0;
                int tbtamhk   = 0;
                int yeutamhk  = 0;
                int dem       = grvTKHK2.RowCount;

                if (dem - 1 == 0)
                {
                    MessageBox.Show("Không có học sinh nào trong học kỳ: " + cbHocKy.Text + " của năm học: " + cbNamHocHK.Text);
                }
                else
                {
                    for (int i = 0; i < dem - 1; i++)
                    {
                        //kt = kt + grvTKN.Rows[i].Cells[1].Value.ToString().Trim() + " , ";
                        if (double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) >= 8 && double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) <= 10)
                        {
                            gioitamhk++;
                        }
                        else
                        if (double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) >= 6.5 && double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) < 8)
                        {
                            khatamhk++;
                        }
                        else
                        if (double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) >= 5 && double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) < 6.5)
                        {
                            tbtamhk++;
                        }
                        else
                        if (double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) >= 0 && double.Parse(grvTKHK2.Rows[i].Cells[2].Value.ToString().Trim()) < 5)
                        {
                            yeutamhk++;
                        }
                    }
                }
                try
                {
                    ptgioi = (gioitamhk * 100) / (dem - 1);
                    ptkha  = (khatamhk * 100) / (dem - 1);
                    pttb   = (tbtamhk * 100) / (dem - 1);
                    ptyeu  = (yeutamhk * 100) / (dem - 1);

                    txtGioiHK.Text = ptgioi.ToString() + " %";
                    txtKhaHK.Text  = ptkha.ToString() + " %";
                    txtTBHK.Text   = pttb.ToString() + " %";
                    txtYeuHK.Text  = ptyeu.ToString() + " %";
                }
                catch
                { }
            }

            DatabaseConnection.ngatketnoi();
        }