private void FillDepartmentList()
        {
            DepartmentBAL          _objBAL        = new DepartmentBAL();
            List <DepartmentModel> DepartmentList = new List <DepartmentModel>();

            DepartmentList              = _objBAL.GetDepartmentList();
            cmbDepartment.DataSource    = DepartmentList;
            cmbDepartment.DisplayMember = "_DeptName";
            cmbDepartment.ValueMember   = "_DeptID";
            cmbDepartment.SelectedIndex = -1;
            cmbDepartment.Text          = "Select Department";
        }
        private void FillGrid()
        {
            DepartmentBAL          _objBAL        = new DepartmentBAL();
            List <DepartmentModel> DepartmentList = new List <DepartmentModel>();

            grdDepartment.DataSource = null;
            grdDepartment.Rows.Clear();
            DepartmentList = _objBAL.GetDepartmentList();
            grdDepartment.AutoGenerateColumns = false;
            int count = 0;

            foreach (var item in DepartmentList)
            {
                count++;
                grdDepartment.Rows.Add(item._DeptID, item._DeptName, item._Description, item._ModifiedDate.ToShortDateString());
            }
            tbxCount.Text = count.ToString();;
        }