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)
{
}
}
