private void loadMemberList(string idTeam)
{
objInProject.MemberList memberList = new objInProject.MemberList();
string sqlquery = "select IDThanhVien from ThanhVien_Nhom where IDNhom = " + idTeam + " and NgungHD is null";
DataTable dt = dal_Attendance.getData(sqlquery);
List <objInProject.Member> list = memberList.seachMemberID(dt, caseData.DataTam.DuLieu.mbList);
int x = 10, y = 10;
int widthUC = frm_attendance.pn_MemberList.Size.Width / 2 - 20;
frm_attendance.pn_MemberList.Controls.Clear();
try
{
for (int i = 0; i < list.Count; i++)
{
sqlquery = "select iif(datediff(hh,max(ThoiGian),getdate()) < 3,0,1) from DiemDanh where IDThanhVien = " + list[i].IdThanhVien
+ " and NhomDiemDanh = " + idTeam;
int daDiemDanh = int.Parse(dal_Attendance.getID(sqlquery));
uc_Attendances[i] = new GUI.uc_Attendance();
uc_Attendances[i].BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
uc_Attendances[i].Location = new System.Drawing.Point(x, y);
uc_Attendances[i].Name = list[i].IdThanhVien;
uc_Attendances[i].Size = new System.Drawing.Size(widthUC, 85);
uc_Attendances[i].TabIndex = i;
uc_Attendances[i].lb_ChucVu.Text = list[i].TenChucVu;
uc_Attendances[i].lb_HoTen.Text = list[i].HoThanhVien + " " + list[i].TenThanhVien;
uc_Attendances[i].lb_MSSV.Text = list[i].Mssv;
if (list[i].Avatar != null)
{
uc_Attendances[i].pic_Avatar.Image = list[i].Avatar;
}
if (daDiemDanh == 0)
{
uc_Attendances[i].Enabled = false;
}
else
{
uc_Attendances[i].Enabled = true;
}
if ((i + 1) % 2 != 0)
{
x = widthUC + 30;
}
else
{
x = 10;
y += 90;
}
frm_attendance.pn_MemberList.Controls.Add(uc_Attendances[i]);
}
}
catch (Exception e)
{
MessageBox.Show("Lỗi: " + e.Message);
}
}
