protected void Group1_CheckedChanged(object sender, EventArgs e)
        {
            if (DeptRadioBtn.Checked)
            {
                // var q= (model.Departments.Select(x => new { x.Department_Name }));
                DeptOrSupp1.DataSource = bl.getDepartmentNames();
                DeptOrSupp1.DataBind();

                DeptOrSupp2.DataSource = bl.getDepartmentNames();
                DeptOrSupp2.DataBind();

                DeptOrSupp3.DataSource = bl.getDepartmentNames();
                DeptOrSupp3.DataBind();
            }

            if (SupplierRadioBtn.Checked)
            {
                DeptOrSupp1.DataSource = bl.getSupplierNames();
                DeptOrSupp1.DataBind();

                DeptOrSupp2.DataSource = bl.getSupplierNames();
                DeptOrSupp2.DataBind();

                DeptOrSupp3.DataSource = bl.getSupplierNames();
                DeptOrSupp3.DataBind();
            }
        }
        protected void Group1_CheckedChanged(object sender, EventArgs e)
        {
            if (DeptRadioBtn.Checked)
            {
                DeptOrSupp1.DataSource = bl.getDepartmentNames();
                DeptOrSupp1.DataBind();

                DeptOrSupp2.DataSource = bl.getDepartmentNames();
                DeptOrSupp2.DataBind();

                DeptOrSupp3.DataSource = bl.getDepartmentNames();
                DeptOrSupp3.DataBind();
            }

            if (SupplierRadioBtn.Checked)
            {
                DeptOrSupp1.DataSource = bl.getSupplierNames();
                DeptOrSupp1.DataBind();

                DeptOrSupp2.DataSource = bl.getSupplierNames();
                DeptOrSupp2.DataBind();

                DeptOrSupp3.DataSource = bl.getSupplierNames();
                DeptOrSupp3.DataBind();
            }
        }