Example #1
0
        private void LoadUsername()
        {
            dgvUsername.DataSource = "";
            TimeSheetAccess objTimeSheetAccess = new TimeSheetAccess();

            cboUsername.DataSource    = objTimeSheetAccess.DSLActive(cboSearch.SelectedValue.ToString(), txtSearch.Text);
            cboUsername.DisplayMember = "ptext";
            cboUsername.ValueMember   = "pvalue";
            cboUsername.SelectedIndex = 0;
        }
Example #2
0
        private void LoadDepartmentEmployees()
        {
            try
            {
                TimeSheetAccess objTimesheetAccess = new TimeSheetAccess();
                dgvDepartment.DataSource                  = objTimesheetAccess.DSLDepartmentEmployees(cboDepartment.SelectedValue.ToString(), cboUsername.SelectedValue.ToString());
                dgvDepartment.AutoGenerateColumns         = false;
                dgvDepartment.Columns[1].DataPropertyName = "ptext";
                dgvDepartment.Columns[2].DataPropertyName = "pvalue";

                foreach (DataGridViewRow dgRow in dgvDepartment.Rows)
                {
                    dgRow.Cells[0].Value = false;
                }
            }
            catch (Exception)
            {
                throw;
            }
        }
Example #3
0
        private void btnMoveRight_Click(object sender, EventArgs e)
        {
            TimeSheetAccess objTimesheet = new TimeSheetAccess();
            DataRow         drw;
            DataTable       tblSource = new DataTable();

            tblSource.Columns.Add("username");
            tblSource.Columns.Add("approver");

            foreach (DataGridViewRow dgRow in dgvUsername.Rows)
            {
                if (bool.Parse(dgRow.Cells[0].Value.ToString()) == true)
                {
                    drw             = tblSource.NewRow();
                    drw["approver"] = cboUsername.SelectedValue.ToString();
                    drw["username"] = dgRow.Cells[2].Value.ToString();
                    tblSource.Rows.Add(drw);
                }
            }
            objTimesheet.TimesheetRemoveAccess(tblSource);
            LoadUsernameAccess();
            LoadDepartmentEmployees();
        }