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()); } } } }