private void cmbFilter_SelectedIndexChanged(object sender, EventArgs e)
        {
            string type = cmbFilter.SelectedItem.ToString();

            var re = new DoctorTestRepo();

            if (type == "Male" || type == "Female")
            {
                re.SexFilter(type, mgvTest);
            }
            else if (type == "Child")
            {
                re.ChildFilter(mgvTest);
            }
            else if (type == "Youth")
            {
                re.YouthFilter(mgvTest);
            }
            else if (type == "Adult")
            {
                re.AdultFilter(mgvTest);
            }
            else if (type == "Senior")
            {
                re.SeniorFilter(mgvTest);
            }
        }
        private void btnSearch_Click(object sender, EventArgs e)
        {
            //var sql = "select id,name,age,sex,tests,date,time from test where id ";
            var en = new DoctorTestEntity();
            var re = new DoctorTestRepo();

            en.Id   = txtId.Text;
            en.Name = txtName.Text;
            en.Date = dtpDate.Value.ToString("yyyy-MM-dd");

            re.Search(en, mgvTest);
        }