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