private void capNhatThongTinMuon_Load(object sender, EventArgs e)
{
dtpNgayMuon.Format = DateTimePickerFormat.Custom;
dtpNgayMuon.CustomFormat = "dd-MM-yyyy";
dtpNgayTra.Format = DateTimePickerFormat.Custom;
dtpNgayTra.CustomFormat = "dd-MM-yyyy";
connectSer.Connect();
connectSer.LoadDataCombobox(cbMaDocGia, "select MADG from tblDocGia");
connectSer.LoadDataCombobox(cbTenDocGia, "select HOTEN from tblDocGia");
connectSer.LoadDataListBox(lbMaSach, "select MASACH from tblSach");
thongTinMuonSer.getAll(dgvThongTinMuon);
for (int i = 0; i < (dgvThongTinMuon.Rows.Count - 1); i++)
{
if (this.dgvThongTinMuon.Rows[i].Cells[0].Value.ToString() != string.Empty)
{
try
{
string status = this.dgvThongTinMuon.Rows[i].Cells[5].Value.ToString();
string deadline = this.dgvThongTinMuon.Rows[i].Cells[4].Value.ToString();
DateTime result = DateTime.ParseExact(deadline, "dd-MM-yyyy", CultureInfo.InvariantCulture);
DateTime localDate = DateTime.Now;
if (result.Date < localDate.Date && status.Equals("Chưa trả"))
{
thongTinMuonSer.updateDeadline(this.dgvThongTinMuon.Rows[i].Cells[0].Value.ToString());
}
}
catch (Exception Ee)
{
MessageBox.Show(Ee.ToString());
}
}
}
}
private void capNhatSach_Load(object sender, EventArgs e)
{
dtpNgayNhap.Format = DateTimePickerFormat.Custom;
dtpNgayNhap.CustomFormat = "dd-MM-yyyy";
connectSer.Connect();
sachSer.getAll(dgvSach);
connectSer.LoadDataCombobox(cbMaLinhVuc, "select MALV from tblLinhVuc");
connectSer.LoadDataCombobox(cbTenLinhVuc, "select TENLV from tblLinhVuc");
}