private async Task LoadDataAttendanceAsync() { dgvTableOfAttendance.ColumnCount = DateTime.DaysInMonth(dtpAttendanceDate.Value.Year, dtpAttendanceDate.Value.Month) + 1; dgvTableOfAttendance.Columns[0].Name = $"User Name"; for (int i = 1; i < dgvTableOfAttendance.ColumnCount; i++) { dgvTableOfAttendance.Columns[i].Name = $"Day {i}"; } List <Users> listUsers = await _usersRepository.GetList(); List <Attendances> listAttendance = await _attendancesRepository.GetList(); foreach (Attendances item in listAttendance) { int month = Convert.ToInt32((item.dateCheck.Substring(item.dateCheck.IndexOf("-") + 1, item.dateCheck.LastIndexOf("-") - item.dateCheck.IndexOf("-") - 1))); int year = Convert.ToInt32((item.dateCheck.Substring(0, item.dateCheck.IndexOf("-")))); if (month != dtpAttendanceDate.Value.Month || year != dtpAttendanceDate.Value.Year) { listAttendance.Remove(item); } } foreach (Users item in listUsers) { DataGridViewRow row = (DataGridViewRow)dgvTableOfAttendance.Rows[0].Clone(); row.Cells[0].Value = item.fullName; foreach (Attendances attendanItem in listAttendance) { if (attendanItem.users.fullName == item.fullName) { int index = Convert.ToInt32(attendanItem.dateCheck.Substring(attendanItem.dateCheck.Length - 2)); if (attendanItem.note != null && attendanItem.note != "") { row.Cells[index].Style.BackColor = Color.Yellow; row.Cells[index].Value = "P"; } else { row.Cells[index].Style.BackColor = Color.Green; row.Cells[index].Value = "X"; } } } dgvTableOfAttendance.Rows.Add(row); } }
private async void LoadData() { List <Departments> listDepartments = await _departmentRepository.GetList(); List <Shifts> listShifts = await _shiftsRepository.GetList(); List <Attendances> listAttendances = await _attendancesRepository.GetList(); List <Roles> listRoles = await _rolesRepository.GetList(); List <Payslips> listPayslips = await _payslipsRepository.GetList(); List <Users> listUsers = await _usersRepository.GetList(); switch (flag) { case 1: ucView1.dgvManagement.DataSource = listDepartments; break; case 2: ucView1.dgvManagement.DataSource = listRoles; break; case 3: ucView1.dgvManagement.DataSource = listUsers; break; case 4: ucView1.dgvManagement.DataSource = listShifts; break; case 5: ucView1.dgvManagement.DataSource = listAttendances; break; case 6: ucView1.dgvManagement.DataSource = listPayslips; break; default: break; } }
private async void LoadData() { try { List <Departments> listDepartments = await _departmentRepository.GetList(); List <Shifts> listShifts = await _shiftsRepository.GetList(); List <Attendances> listAttendances = await _attendancesRepository.GetList(); List <Roles> listRoles = await _rolesRepository.GetList(); List <Payslips> listPayslips = await _payslipsRepository.GetList(); List <Users> listUsers = await _usersRepository.GetList(); switch (flag) { case 1: if (listDepartments == null) { return; } ucView1.dgvManagement.DataSource = listDepartments; ucView1.dgvManagement.Columns["shifts"].Visible = false; ucView1.dgvManagement.AutoResizeColumns(); ucView1.dgvManagement.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case 2: if (listRoles == null) { return; } ucView1.dgvManagement.DataSource = listRoles; ucView1.dgvManagement.AutoResizeColumns(); ucView1.dgvManagement.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case 3: if (listUsers == null) { return; } ucView1.dgvManagement.DataSource = listUsers; ucView1.dgvManagement.Columns["roles"].Visible = false; ucView1.dgvManagement.Columns["departments"].Visible = false; ucView1.dgvManagement.Columns["shifts"].Visible = false; ucView1.dgvManagement.AutoResizeColumns(); ucView1.dgvManagement.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case 4: if (listShifts == null) { return; } ucView1.dgvManagement.DataSource = listShifts; ucView1.dgvManagement.AutoResizeColumns(); ucView1.dgvManagement.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; case 5: if (listAttendances == null) { return; } ucView1.dgvManagement.DataSource = listAttendances; ucView1.dgvManagement.AutoResizeColumns(); ucView1.dgvManagement.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; ucView1.dgvManagement.Columns["users"].Visible = false; break; case 6: if (listPayslips == null) { return; } ucView1.dgvManagement.DataSource = listPayslips; ucView1.dgvManagement.AutoResizeColumns(); ucView1.dgvManagement.Columns["users"].Visible = false; ucView1.dgvManagement.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; break; default: break; } } catch (Exception) { } }