private void button3_Click(object sender, EventArgs e)
{
if (s > end)
{
MessageBox.Show("Vui lòng điều chỉnh lại thời gian bắt đầu và kết thúc", "Thông báo");
}
else
{
dgv_History.DataSource = BLL_HISTORY.filterPage(s, end, PageCur - 1);
if (dgv_History.Rows.Count > 0)
{
DataGridViewImageColumn img = (DataGridViewImageColumn)dgv_History.Columns["AnhNV"];
img.ImageLayout = DataGridViewImageCellLayout.Stretch;
PageCur -= 1;
for (int i = 0; i < dgv_History.Rows.Count; i++)
{
try
{
Bitmap imgv = new Bitmap(dgv_History.Rows[i].Cells["IMG_FACE"].Value.ToString());
img.Image = imgv;
}
catch (Exception)
{
img.Image = new Bitmap(Application.StartupPath + @"\File\noimagefound.Jpg");
}
dgv_History.Rows[i].MinimumHeight = 80;
}
}
}
if (PageCur == 1)
{
button3.Enabled = false;
button2.Enabled = true;
}
}
private void button5_Click(object sender, EventArgs e)
{
s = (DateTime)dtp_Start.Value;
end = (DateTime)dtp_End.Value;
if (s > end)
{
MessageBox.Show("Vui lòng chọn lại thời gian bắt đầu và kết thúc", "Lỗi lọc");
}
else
{
dgv_history.DataSource = BLL_HISTORY.filterByPer(s, end, idps);
if (dgv_history.Rows.Count > 0)
{
dayEnd = dgv_history.Rows[0].Cells["NGAY"].Value.ToString();
dayStart = dgv_history.Rows[dgv_history.Rows.Count - 1].Cells["NGAY"].Value.ToString();
}
}
}
private void dgv_AllEmp_RowEnter(object sender, DataGridViewCellEventArgs e)
{
txt_HoTen.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["NAME"].Value.ToString();
url_Face_Cur = dgv_AllEmp.Rows[e.RowIndex].Cells["IMG_FACE"].Value.ToString();
try
{
Bitmap img = new Bitmap(url_Face_Cur);
ptb_ImageCustomer.Image = img;
}
catch (Exception)
{
ptb_ImageCustomer.Image = new Bitmap(Application.StartupPath + @"\File\noimagefound.Jpg");
}
ptb_ImageCustomer.SizeMode = PictureBoxSizeMode.StretchImage;
txt_Cmt.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["CMT"].Value.ToString();
txt_Email.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["EMAIL"].Value.ToString();
txt_GhiChu.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["GHICHU"].Value.ToString();
txt_SDT.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["PHONE"].Value.ToString();
if (dgv_AllEmp.Rows[e.RowIndex].Cells["GT"].Value.ToString() == "Nam")
{
rbn_Nam.Checked = true;
}
else
{
rbn_Nu.Checked = true;
}
dtp_birthday.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["BIRTHDAY"].Value.ToString();
txt_DiaChi.Text = dgv_AllEmp.Rows[e.RowIndex].Cells["ADDRESS"].Value.ToString();
idps = int.Parse(dgv_AllEmp.Rows[e.RowIndex].Cells["ID_PS"].Value.ToString());
dgv_history.DataSource = BLL_HISTORY.getByEmp(idps);
if (dgv_history.Rows.Count > 0)
{
dayEnd = dgv_history.Rows[0].Cells["NGAY"].Value.ToString();
dayStart = dgv_history.Rows[dgv_history.Rows.Count - 1].Cells["NGAY"].Value.ToString();
}
emp = DAL_EMPLOYEE.getEmpByIDPER(idps);
}
private void loadDGV()
{
DateTime now = DateTime.Today;
s = new DateTime(now.Year, now.Month, now.Day, 0, 0, 0);
end = new DateTime(now.Year, now.Month, now.Day, 23, 59, 0);
PageCount = DAL_HISTORY.PageCount(s, end);
button3.Enabled = false;
if (PageCount > 1)
{
button2.Enabled = true;
}
else
{
button2.Enabled = false;
}
dgv_History.DataSource = BLL_HISTORY.filterPage(s, end, 1);
if (dgv_History.Rows.Count > 0)
{
DataGridViewImageColumn img = (DataGridViewImageColumn)dgv_History.Columns["AnhNV"];
img.ImageLayout = DataGridViewImageCellLayout.Stretch;
PageCur = 1;
for (int i = 0; i < dgv_History.Rows.Count; i++)
{
try
{
Bitmap imgv = new Bitmap(dgv_History.Rows[i].Cells["IMG_FACE"].Value.ToString());
img.Image = imgv;
}
catch (Exception)
{
img.Image = new Bitmap(Application.StartupPath + @"\File\noimagefound.Jpg");
}
dgv_History.Rows[i].MinimumHeight = 80;
}
}
}