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

            if (type == "Male" || type == "Female")
            {
                re.FilterBySex(type, mgvTest);
            }
            if (type == "Child")
            {
                re.ChildFilter(mgvTest);
            }
            if (type == "Youth")
            {
                re.YouthFilter(mgvTest);
            }
            if (type == "Adult")
            {
                re.AdultFilter(mgvTest);
            }
            if (type == "Senior")
            {
                re.SeniorFilter(mgvTest);
            }
        }
        private void btnSearch_Click(object sender, EventArgs e)
        {
            var en = new ManageTestEntity();
            var re = new ManageTestRepo();

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

            re.Search(en, mgvTest);
        }
 private void btnDelete_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.No)
     {
         return;
     }
     else
     {
         var    re = new ManageTestRepo();
         string id = mgvTest.CurrentRow.Cells["id"].Value.ToString();
         re.Delete(id);
     }
 }
        private void btnTestUpdate_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Are you sure?", "Confirmation", MessageBoxButtons.YesNo) == DialogResult.No)
            {
                return;
            }
            else
            {
                var en = new ManageTestEntity();
                var re = new ManageTestRepo();

                en.Id        = txtTestId.Text;
                en.Name      = txtTestName.Text;
                en.Age       = int.Parse(txtTestAge.Text);
                en.Sex       = txtTestSex.Text;
                en.Reference = txtTestReference.Text;
                en.Date      = dtpTestDate.Value.ToString("yyyy-MM-dd");
                en.Time      = dtpTestTime.Value.ToString("hh:mm tt");

                re.Update(en);
            }
        }