private void button5_Click(object sender, EventArgs e)
        {
            switch (state)
            {
            case 1:
            {
                Banggiactrl bg = new Banggiactrl();
                if (textBox1.Text.Trim() == "" || textBox2.Text.Trim() == "")
                {
                    MessageBox.Show("Phải có tên Dịch Vụ và Giá mới thực hiện thêm được!");
                }
                else
                {
                    bg.ThemBangGia(dataGridView1, textBox1.Text.Trim(), textBox2.Text.Trim(), dateTimePicker1.Text.Trim());
                }
                break;
            }

            case 2:
            {
                Banggiactrl bg = new Banggiactrl();
                bg.SuaBangGia(dataGridView1, this.dataGridView1.CurrentRow.Cells[0].Value.ToString(),
                              textBox1.Text.Trim(), textBox2.Text.Trim(), dateTimePicker1.Text.Trim(), dateTimePicker2.Text.Trim(), comboBox1.Text.ToString());
                break;
            }

            case 3:
            {
                Banggiactrl bg = new Banggiactrl();
                bg.XoaBangGia(dataGridView1, this.dataGridView1.CurrentRow.Cells[0].Value.ToString(), textBox1.Text.Trim(), textBox2.Text.Trim());
                break;
            }
            }
            TrangThaiBanDau();
        }
        private void button6_Click(object sender, EventArgs e)
        {
            Banggiactrl bg      = new Banggiactrl();
            string      _danghd = "";

            if (comboBox1.Text.Trim() == "")
            {
                _danghd = "";
            }
            else if (comboBox1.Text.Trim() == "false")
            {
                _danghd = "0";
            }
            else
            {
                _danghd = "1";
            }
            string _ngaythem = "";
            string _ngayhuy  = "";

            if (dateTimePicker1.Checked == true)
            {
                _ngaythem = dateTimePicker1.Text.Trim();
            }
            if (dateTimePicker2.Checked == true)
            {
                _ngayhuy = dateTimePicker1.Text.Trim();
            }
            bg.LoadDataGridView(dataGridView1, textBox1.Text.Trim(), textBox2.Text.Trim(), _ngaythem, _ngayhuy, _danghd);
        }
        private void BangGiaKhamBenh_Load(object sender, EventArgs e)
        {
            Banggiactrl bg = new Banggiactrl();

            bg.LoadDataGridView(dataGridView1, "", "", "", "", "");
            LoadDataGridViewFormat();
            TrangThaiBanDau();
            clsDatabase cls = new clsDatabase();

            cls.loadcombobox(comboBox1, "SELECT Distinct(Danghoatdong) FROM tblLoaihinhdichvu", 0);
        }