private void btnAdd_Click(object sender, EventArgs e) { string id = ""; string memberID = ""; string bookID; string ngaymuon = dtpBorrowday.Value.ToString("yyyy-MM-dd"); string ngaytra = dtpReturnday.Value.ToString("yyyy-MM-dd"); string tienphat; string point; if (isNotText(txtBorrowID.Text) || !canConvertToInt(txtBorrowID.Text)) { MessageBox.Show("Mã độc giả không hợp lệ"); } else { id = txtBorrowID.Text; memberID = txtMemberID.Text; bookID = lbBookID.SelectedItem.ToString(); tienphat = txtPunish.Text; point = txtPoint.Text; int kq = TraSach_DAO.InsertData(memberID, id, bookID, ngaymuon, ngaytra, tienphat, point); if (kq >= 1) { int quan = int.Parse(TraSach_DAO.quantity(bookID)); MessageBox.Show("Thêm phiếu trả thành công"); kq = TraSach_DAO.increaseremainbook(bookID, quan); } } }
private void lbBookID_SelectedValueChanged(object sender, EventArgs e) { string time = dtpBorrowday.Value.ToString(); string bookID = lbBookID.SelectedItem.ToString(); txtBorrowID.Text = TraSach_DAO.getID(txtMemberID.Text, bookID); string id = txtBorrowID.Text; }
private void btnCheck_Click(object sender, EventArgs e) { if (isNotText(txtMemberID.Text) || !TraSach_DAO.CheckMemberID(txtMemberID.Text)) { MessageBox.Show("Sai mã độc giả"); } else { DataTable dt = TraSach_DAO.bookIdUserKeep(txtMemberID.Text); foreach (DataRow item in dt.Rows) { lbBookID.Items.Add(item["ma_sach"].ToString()); } } }
private void dtpBorrowday_ValueChanged(object sender, EventArgs e) { dtpReturnday.Value = DateTime.Now; if (txtBorrowID.Text == "" || txtMemberID.Text == "" || lbBookID.SelectedItem.ToString() == "") { return; } int d = TraSach_DAO.getExp(txtBorrowID.Text, txtMemberID.Text, lbBookID.SelectedItem.ToString()); if (d < 0) { txtPunish.Text = "0"; } if (d >= 0 && d <= 7) { txtPunish.Text = (int.Parse(CaiDat_DAO.LayTienPhatNgay()) * d).ToString(); } if (d > 7) { txtPunish.Text = (int.Parse(CaiDat_DAO.LayTienPhatTuan()) * (float)d / 7).ToString(); } }
private void TraSach_Load(object sender, EventArgs e) { dtgv.DataSource = TraSach_DAO.LoadData(); }